InventoryStagedTransactionslotslotSerials
Manages the serial numbers associated with lots in staged inventory transactions, enabling detailed tracking for items controlled by both lot and serial.
Columns
| Name | Type | Description |
| InventoryStagedTransactionsTransactionInterfaceId [KEY] | Long | The unique identifier for the transaction interface record associated with the staged inventory transaction. This identifier ensures that lot and serial tracking details are properly linked to the inventory transaction. |
| LotsLotNumber [KEY] | String | The lot number associated with the inventory item in the staged transaction. This lot number ensures traceability and accurate tracking of lot-controlled inventory. |
| LotsTransactionInterfaceId [KEY] | Long | The unique identifier for the transaction interface record associated with the lot. This identifier ensures that lot and serial attributes are properly linked to the staged inventory transaction. |
| TransactionInterfaceId [KEY] | Long | The unique identifier for the staged inventory transaction. This identifier helps track and manage lot- and serial-controlled inventory movements within the system. |
| FmSerialNumber [KEY] | String | The starting serial number in a range of serial numbers assigned to items within the lot. This serial number ensures proper traceability for serialized inventory. |
| ToSerialNumber | String | The ending serial number in a range of serial numbers assigned to items within the lot. This serial number allows for managing and tracking serialized inventory in bulk transactions. |
| SourceCode | String | An abbreviation representing the source of the inventory transaction. This abbreviation helps classify inventory movements based on procurement, manufacturing, or distribution processes. |
| SourceLineId | Long | The unique identifier for the source line associated with the inventory transaction. This identifier ensures proper linkage between the transaction and its originating document. |
| ErrorCode | String | A system-generated abbreviation representing an error encountered during the inventory transaction. This abbreviation helps in troubleshooting and resolving transaction processing issues. |
| OriginationDate | Date | The date when this lot serial record was created. This date is essential for tracking inventory history, compliance, and traceability requirements. |
| StatusId | Long | The unique identifier for the status of the lot-serial transaction. This identifier ensures proper tracking of inventory status, such as available, in transit, or on hold. |
| StatusName | String | A descriptive name of the current status of the lot-serial transaction. This name provides meaningful insight into the inventory condition. |
| StatusCode | String | A system-generated abbreviation representing the current status of the lot-serial transaction. This abbreviation helps in categorizing inventory for reporting and operational control. |
| Finder | String | A reference attribute used for searching and retrieving specific lot-serial transaction records. This attribute enhances system usability by allowing users to locate serial tracking data efficiently. |