InterfacedPickTransactionslots
Tracks lot data associated with pick transactions for improved inventory management.
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 InterfacePickTransactionslots table. This identifier is essential for tracking and managing interfaced transactions within Oracle SCM. |
| LotNumber [KEY] | String | The unique lot number assigned to the item, used for inventory tracking, traceability, and compliance with lot control requirements. This lot number helps ensure that specific batches of items can be identified and managed throughout the supply chain. |
| PrimaryQuantity | Decimal | The quantity of the item in the primary unit of measure (UOM) as defined in the system. This quantity represents the transaction quantity in the standard unit used for inventory and fulfillment processes. |
| TransactionQuantity | Decimal | The total quantity of the item included in the pick-confirm transaction. This quantity ensures accurate record-keeping for inventory movements and transaction validation. |
| SecondaryTransactionQuantity | Decimal | The transaction quantity of the item expressed in a secondary UOM. This field supports dual UOM tracking, allowing for more precise handling of items with multiple measurement units. |
| 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. |
| TransactionInterfaceId | Long | The unique identifier assigned to the interfaced pick-confirm transaction, facilitating integration, tracking, and validation within the Oracle SCM system. This identifier ensures that each transaction can be processed accurately across various inventory and fulfillment modules. |