MaintenanceWorkOrderTransactionHistory
Tracks the transaction history of maintenance work orders, including operation, resource, and inventory transactions.
Columns
| Name | Type | SupportedFinders | Description |
| WorkOrderId | Long | The unique identifier for the work order. | |
| WorkOrderNumber | String | The number of the work order associated with the transaction. | |
| TransactionId [KEY] | Long | PrimaryKey | The unique identifier for the transaction. |
| OrganizationId | Long | The unique identifier for the organization. | |
| OperationSequenceNumber | Decimal | The sequence number of the operation within the maintenance work order. | |
| Quantity | Decimal | The quantity of items involved in the transaction. | |
| OperationType | String | The type of operation performed in the transaction. | |
| TransactionDate | Datetime | The date on which the transaction was recorded. | |
| TransactionType | String | The type of transaction recorded in the maintenance work order history. | |
| AssetId | Decimal | The unique identifier for the asset. | |
| AssetNumber | String | The number of the asset associated with the work order transaction. | |
| AssetDescription | String | A description of the asset associated with the work order transaction. | |
| TransactionTypeMeaning | String | The meaning of the transaction type. | |
| ProductItemNumber | String | The product item number associated with the work order transaction. | |
| InventoryItemId | Long | The unique identifier for the inventory item. | |
| ItemDescription | String | A description of the inventory item associated with the transaction. | |
| Component | String | The component number associated with the work order transaction. | |
| ComponentItemId | Decimal | The unique identifier for the component item. | |
| ResourceName | String | The name of the resource associated with the work order transaction. | |
| ResourceInstance | String | The specific instance of the resource used in the work order transaction. | |
| UnitOfMeasure | String | Specifies the unit of measure associated with the transaction record. | |
| SecondaryQuantity | Decimal | The secondary quantity associated with the transaction. | |
| SecondaryUOMCode | String | The secondary unit of measure code for the transaction. | |
| SecondaryUnitOfMeasure | String | Specifies the secondary unit of measure associated with the transaction record. | |
| SubInventory | String | The subinventory associated with the work order transaction. | |
| SubInventoryName | String | The name of the subinventory. | |
| LocatorCode | String | The locator code identifying the inventory storage location for the transaction. | |
| ItemRevision | String | The revision of the item used in the work order transaction. | |
| LotNumber | String | The lot number of the item used in the work order transaction. | |
| ItemSerialNumber | String | The serial number of the item used in the work order transaction. | |
| ComponentSerialNumber | String | The serial number of the component used in the work order transaction. | |
| OperationTypeCode | String | The code identifying the type of operation. | |
| MultipleLotFlag | Bool | Indicates whether multiple lots are allowed for the transaction. | |
| MultipleItemSerialFlag | Bool | Indicates whether the transaction involves multiple item serial numbers. | |
| MultipleComponentSerialFlag | Bool | Indicates whether the transaction involves multiple component serial numbers. | |
| ActivityType | String | The type of activity associated with the work order transaction. | |
| OperationTransactionReference | Decimal | The reference identifier for the operation transaction. | |
| ResourceTransactionReference | Decimal | The reference identifier for the resource transaction. | |
| InventoryTransactionReference | Decimal | The reference identifier for the inventory transaction. | |
| ReceivingTransactionReference | Decimal | The reference identifier for the receiving transaction. | |
| ParentTransactionReference | Decimal | The reference identifier for the parent transaction. | |
| TransactionNote | String | A note associated with the transaction. | |
| PurchaseOrderNumber | String | The purchase order number associated with the work order transaction. | |
| PurchaseOrderline | Decimal | The line number of the purchase order associated with the work order transaction. | |
| ReceiptNumber | String | The receipt number associated with the work order transaction. | |
| CategoryType | String | The type of the category. | |
| ProjectNumber | String | The project number associated with the work order transaction. | |
| TaskNumber | String | The task number associated with the work order transaction. | |
| ProjectId | Long | The unique identifier for the project. | |
| TaskId | Long | The unique identifier for the task. | |
| UseCommonInventoryFlag | Bool | Indicates whether common inventory is used for the work order transaction. | |
| LPN | String | The registered License Plate Number. | |
| CreationDate | Datetime | The date of creation. | |
| CreatedBy | String | The user who created the object. | |
| LastUpdateLogin | String | The user login who last updated the object. | |
| LastUpdatedBy | String | The user who last updated the object. | |
| BindOrganizationId | Long | FindByOrgIdAndDate | Bind parameter for filtering the transaction history by the unique identifier of the organization. |
| BindTransactionEndDate | Datetime | FindByOrgIdAndDate | Bind parameter for filtering the transaction history by the end date of the transaction date range. |
| BindTransactionStartDate | Datetime | FindByOrgIdAndDate | Bind parameter for filtering the transaction history by the start date of the transaction date range. |
| Finder | String | The name of the finder method used to search and filter maintenance work order transaction history records. |