OpenPickLinesitemLotsitemLotSerials
Manages serial details for items controlled by lots, supporting traceability and accuracy.
Columns
| Name | Type | Description |
| OpenPickLinesTransactionId [KEY] | Long | The unique identifier for the transaction associated with the OpenPickLinesitemLotsitemLotSerials table, used to track the specific transaction in the Open Pick Lines process. |
| ItemlotsLot [KEY] | String | The identifier for the lot within the item lots, which is used to distinguish different lots of the same item in the OpenPickLinesitemLotsitemLotSerials table. |
| FromSerialNumber [KEY] | String | The serial number from which the item is being moved or picked, part of the lot serialization process for tracking items in OpenPickLinesitemLotsitemLotSerials. |
| ToSerialNumber | String | The serial number to which the item is being moved or transferred, used in conjunction with the FromSerialNumber for item tracking during OpenPickLinesitemLotsitemLotSerials transactions. |
| Finder | String | An identifier used to locate or search for specific records in the OpenPickLinesitemLotsitemLotSerials, typically related to user-defined or system-generated search criteria. |
| PItem | String | The identifier for the item being processed in the OpenPickLinesitemLotsitemLotSerials, often linked to inventory, shipment, or order records. |
| PMovementRequest | String | The identifier for the movement request, representing a specific inventory movement or transaction request related to the OpenPickLinesitemLotsitemLotSerials. |
| POrder | String | The order number associated with the OpenPickLinesitemLotsitemLotSerials table, typically representing the sales or purchase order that this item is being processed for. |
| POrganization | String | The identifier for the organization associated with the OpenPickLinesitemLotsitemLotSerials table, typically referring to the business unit or warehouse in Oracle SCM. |
| POrganizationId | String | A unique identifier for the organization within the Oracle SCM system, used to track organizational boundaries and manage inventory and order information. |
| PPickSlip | String | The pick slip identifier, used to reference the specific picking document associated with the OpenPickLinesitemLotsitemLotSerials, detailing the items to be picked for an order. |
| PPickWave | String | The pick wave identifier, used to group and track items picked together in a specific wave of order fulfillment in the OpenPickLinesitemLotsitemLotSerials. |
| PSourceSubinventory | String | The identifier for the source subinventory where the item is stored, used in inventory transactions such as picking, shipping, and transferring items in Oracle SCM. |
| PTransactionType | String | The type of transaction being processed (such as a pick, transfer, or move) that defines the nature of the action being taken within the OpenPickLinesitemLotsitemLotSerials. |
| TransactionId | Long | A unique identifier for the transaction in the OpenPickLinesitemLotsitemLotSerials, used to track individual transactions and their statuses throughout the system. |