OpenPickLinesitemSerials
Tracks serial details for picked items, ensuring traceability for serialized inventory.
Columns
Name | Type | Description |
OpenPickLinesTransactionId [KEY] | Long | The unique identifier for the OpenPickLines transaction in the OpenPickLinesitemSerials table. This ID links the serials data to a specific pick line transaction. |
FromSerialNumber [KEY] | String | The starting serial number for the range of serials being processed in the OpenPickLinesitemSerials. This value identifies the first item in the batch for picking. |
ToSerialNumber | String | The ending serial number for the range of serials being processed in the OpenPickLinesitemSerials. This value identifies the last item in the batch for picking. |
Finder | String | The identifier for the entity or process that initiated the pick line operation. This could be used for tracking the origin of the transaction. |
PItem | String | The product item code associated with the pick line transaction. This value links the pick line record to a specific item in the inventory system. |
PMovementRequest | String | The movement request code tied to the pick line transaction, indicating the reason for inventory movement or the associated request. |
POrder | String | The purchase order number that is associated with the pick line. It links the pick line records to specific orders in the system. |
POrganization | String | The code representing the organization within the system that is responsible for the inventory transaction in OpenPickLinesitemSerials. |
POrganizationId | String | The unique identifier of the organization in the database. This value helps to differentiate between different organizations within the SCM system. |
PPickSlip | String | The pick slip number linked to the pick line. This value identifies the document used to pick items for shipment. |
PPickWave | String | The pick wave identifier that associates the pick line with a specific batch or group of items being picked in the system. |
PSourceSubinventory | String | The source subinventory location from where the items are being picked. This refers to the inventory location from which stock is moved. |
PTransactionType | String | The type of transaction being processed in the OpenPickLinesitemSerials, such as a movement, receipt, or shipment. |
TransactionId | Long | The unique transaction ID for the specific entry in the OpenPickLinesitemSerials table. This serves as a reference for tracking the transaction details. |