OpenPickLinesitemLots
Tracks lot details associated with picked items, ensuring accurate lot-level tracking.
Columns
Name | Type | Description |
OpenPickLinesTransactionId [KEY] | Long | The unique identifier for the OpenPickLinesTransaction associated with this record in the OpenPickLinesitemLots table. |
Lot [KEY] | String | The identification code or lot number associated with the item in the OpenPickLinesitemLots table, representing a specific batch or grouping. |
Quantity | Decimal | The quantity of items in the OpenPickLinesitemLots record, indicating how many units are involved in the transaction or lot. |
SecondaryQuantity | Decimal | The secondary quantity of items, often used when dealing with units of measure that differ from the primary quantity (for example, weight or volume). |
Finder | String | A reference identifier used to locate or track the item in the OpenPickLinesitemLots table, often related to internal inventory or warehouse systems. |
PItem | String | The part number or product identifier for the item in the OpenPickLinesitemLots table, typically representing the item being processed or shipped. |
PMovementRequest | String | An identifier for the movement request associated with this item lot, often used for tracking internal or external material handling requests. |
POrder | String | The purchase order number related to the item, linking this record to a specific order for procurement or fulfillment. |
POrganization | String | The identifier for the organization or business unit associated with this item, often used to track inventory within different departments or locations. |
POrganizationId | String | A unique identifier for the organization linked to the record, which may represent a company or business unit in the OpenPickLinesitemLots table. |
PPickSlip | String | The pick slip number associated with this item, used in warehouse or inventory operations to track the picking process of goods for an order. |
PPickWave | String | The pick wave identifier for this item lot, used in picking and shipping processes to group items to be picked together within a certain time frame. |
PSourceSubinventory | String | The subinventory from which the items are sourced, typically representing a specific storage location within a warehouse or distribution center. |
PTransactionType | String | The type of transaction associated with this item lot, indicating whether the movement is an addition, subtraction, or adjustment to inventory. |
TransactionId | Long | The unique identifier for the transaction involving this item lot, typically used to track individual movements, adjustments, or processes related to inventory. |