OpenPickLines
Manages open pick lines, including locator, lot, and serial information, ensuring efficient picking processes.
Columns
| Name | Type | Description |
| PickSlip | Long | The unique identifier for the pick slip associated with the open pick lines. |
| PickSlipLine | Long | The specific line number within the pick slip that corresponds to this open pick line. |
| PickSlipType | String | The type or classification of the pick slip, indicating the process or method used for picking. |
| PickWave | Double | The wave number or identifier for the picking process, typically used to group multiple pick slips for processing. |
| DueDate | Date | The date by which the items in the open pick lines are expected to be picked or processed. |
| Organization | String | The organization within which the open pick lines are recorded or belong. |
| Item | String | The unique identifier or Stock Keeping Unit (SKU) for the item associated with the open pick lines. |
| Revision | String | The revision identifier for the item, indicating its version or update in the inventory system. |
| RequestedQuantity | Decimal | The quantity of the item requested in the open pick lines for fulfillment. |
| UOM | String | The unit of measure (for example, each, box, kilogram) used for the requested quantity. |
| SecondaryRequestedQuantity | Decimal | The secondary quantity requested, typically used when the item is measured in multiple units of measure. |
| SecondaryUOM | String | The unit of measure for the secondary requested quantity, used in multi-UOM scenarios. |
| SourceSubinventory | String | The subinventory location within the warehouse from which the item is to be picked. |
| SourceLocatorId | Long | The unique identifier for the specific locator (bin or shelf) within the source subinventory. |
| SourceLocator | String | The specific location or identifier within the source subinventory where the item is stored. |
| DestinationSubinventory | String | The subinventory location within the warehouse to which the item is being transferred. |
| DestinationAccount | String | The account code associated with the destination location, often used for accounting and inventory tracking. |
| DestinationLocator | String | The specific location or identifier within the destination subinventory where the item will be placed. |
| Order | String | The order number associated with the open pick lines, typically referring to a sales order or work order. |
| SourceOrder | String | The source order number from which the open pick lines are derived, often linked to a larger order fulfillment. |
| SourceOrderLine | String | The specific line number within the source order that corresponds to the open pick lines. |
| ShippingPriority | String | The priority level for shipping, often used to determine the urgency or order in which items should be processed. |
| Customer | String | The customer associated with the open pick lines, indicating which customer is receiving the order. |
| Shipment | String | The shipment identifier for the delivery of items associated with the open pick lines. |
| ShipToLocation | String | The address or location to which the items are being shipped. |
| ShippingMethod | String | The method of shipping chosen for the order, such as ground, air, or expedited delivery. |
| RequiredDate | Date | The date by which the customer requires the items to be shipped or delivered. |
| CreationDate | Datetime | The date and time when the open pick lines record was created in the system. |
| TransactionId [KEY] | Long | The unique identifier for the transaction associated with the open pick lines, typically used for inventory movements. |
| TransactionType | String | The type of transaction, such as sales order, return, or inventory transfer, associated with the open pick lines. |
| TransactionTypeId | Long | The identifier for the specific transaction type, which may link to predefined transaction types in the system. |
| MovementRequest | String | The identifier for a movement request that initiates the movement of items between inventory locations. |
| MovementRequestLine | Long | The specific line number of the movement request, indicating which part of the request is being fulfilled. |
| AllowUseOfCommonSuppliesFlag | Bool | A flag indicating whether common supplies (such as packaging materials) can be used for fulfilling the pick lines. |
| ItemDescription | String | A textual description of the item associated with the open pick lines, providing more detail about the product. |
| ItemPrimaryImageURL | String | The URL to the primary image of the item, typically used in order fulfillment systems for visual identification. |
| LotControlCode | Decimal | The code used for controlling the lot or batch number of the item in inventory, relevant for lot-controlled items. |
| SerialNumberControlCode | Decimal | The code used for controlling the serial numbers of individual items in inventory, relevant for serialized items. |
| InventoryItemId | Long | The unique identifier for the inventory item, linking it to the broader inventory management system. |
| SplitLineFlag | Bool | A flag indicating whether the open pick lines can be split into multiple lines for fulfillment purposes. |
| PrimaryRequestedQuantity | Decimal | The primary quantity requested, typically referring to the main unit of measure for the item. |
| PrimaryUOMCode | String | The code for the primary unit of measure, indicating the default unit for the item’s quantity. |
| Finder | String | The identifier or reference used for finding or searching for the open pick lines in the system. |
| PItem | String | The parent item associated with the open pick lines, potentially a higher-level or related product. |
| PMovementRequest | String | The movement request related to the open pick lines, which could correspond to a transfer or relocation of stock. |
| POrder | String | The parent order associated with the open pick lines, often representing a higher-level order. |
| POrganization | String | The parent organization linked to the open pick lines, often for cross-organizational tracking or reporting. |
| POrganizationId | String | The identifier for the parent organization related to the open pick lines. |
| PPickSlip | String | The parent pick slip associated with the open pick lines, indicating the grouping for picking activities. |
| PPickWave | String | The parent pick wave associated with the open pick lines, grouping pick slips for coordinated fulfillment. |
| PSourceSubinventory | String | The parent source subinventory from which items in the open pick lines are to be picked. |
| PTransactionType | String | The parent transaction type, which may refer to the type of transaction that initiated the open pick lines. |