Excel Add-In for Oracle Fusion Cloud SCM

Build 24.0.9175

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.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 24.0.9175