InterfacedPickTransactionslotslotSerials
Manages serials for lots in pick transactions when items are both lot and serial-controlled.
Columns
| Name | Type | Description |
| InterfacedPickTransactionsTransactionInterfaceId [KEY] | Long | A system-generated identifier that uniquely links an interfaced pick-confirm transaction to its corresponding transaction record in the InterfacePickTransactionslotslotSerials table. This identifier is critical for tracking and managing interfaced transactions within Oracle SCM. |
| LotsLotNumber [KEY] | String | The unique lot number assigned to the item within the pick-confirm transaction. This lot number is essential for inventory tracking, traceability, and compliance with lot control requirements, ensuring accurate stock management and regulatory adherence. |
| FromSerialNumber [KEY] | String | The starting serial number in a sequential range for a serial-controlled item within the transaction. This serial number is used to identify and track specific units of inventory, ensuring proper traceability in Oracle SCM. |
| ToSerialNumber | String | The ending serial number in a sequential range for a serial-controlled item within the transaction. This serial number defines the last serial in the range, allowing for efficient management and validation of serialized inventory movements. |
| Finder | String | The lookup reference used to identify and retrieve interfaced pick-confirm transactions within the system. This reference enables efficient search and navigation for transaction records in Oracle SCM, facilitating accurate tracking and reconciliation. |
| TransactionInterfaceId | Long | The unique identifier assigned to the interfaced pick-confirm transaction, ensuring seamless integration, tracking, and validation within Oracle SCM. This identifier plays a key role in processing serialized and lot-controlled inventory movements across various modules. |