Power BI Connector for Oracle Fusion Cloud SCM

Build 24.0.9060

OpenPickLines

The Open Pick Lines resource manages details about open picks, such as pick slip number, quantities, locator information, and inventory control details, such as lot numbers and serial numbers.

Columns

Name Type Description
PickSlip Long PickSlip of OpenPickLines
PickSlipLine Long PickSlipLine of OpenPickLines
PickSlipType String PickSlipType of OpenPickLines
PickWave Double PickWave of OpenPickLines
DueDate Date DueDate of OpenPickLines
Organization String Organization of OpenPickLines
Item String Item of OpenPickLines
Revision String Revision of OpenPickLines
RequestedQuantity Decimal RequestedQuantity of OpenPickLines
UOM String UOM of OpenPickLines
SecondaryRequestedQuantity Decimal SecondaryRequestedQuantity of OpenPickLines
SecondaryUOM String SecondaryUOM of OpenPickLines
SourceSubinventory String SourceSubinventory of OpenPickLines
SourceLocatorId Long SourceLocatorId of OpenPickLines
SourceLocator String SourceLocator of OpenPickLines
DestinationSubinventory String DestinationSubinventory of OpenPickLines
DestinationAccount String DestinationAccount of OpenPickLines
DestinationLocator String DestinationLocator of OpenPickLines
Order String Order of OpenPickLines
SourceOrder String SourceOrder of OpenPickLines
SourceOrderLine String SourceOrderLine of OpenPickLines
ShippingPriority String ShippingPriority of OpenPickLines
Customer String Customer of OpenPickLines
Shipment String Shipment of OpenPickLines
ShipToLocation String ShipToLocation of OpenPickLines
ShippingMethod String ShippingMethod of OpenPickLines
RequiredDate Date RequiredDate of OpenPickLines
CreationDate Datetime CreationDate of OpenPickLines
TransactionId [KEY] Long TransactionId of OpenPickLines
TransactionType String TransactionType of OpenPickLines
TransactionTypeId Long TransactionTypeId of OpenPickLines
MovementRequest String MovementRequest of OpenPickLines
MovementRequestLine Long MovementRequestLine of OpenPickLines
AllowUseOfCommonSuppliesFlag Bool AllowUseOfCommonSuppliesFlag of OpenPickLines
ItemDescription String ItemDescription of OpenPickLines
ItemPrimaryImageURL String ItemPrimaryImageURL of OpenPickLines
LotControlCode Decimal LotControlCode of OpenPickLines
SerialNumberControlCode Decimal SerialNumberControlCode of OpenPickLines
InventoryItemId Long InventoryItemId of OpenPickLines
SplitLineFlag Bool SplitLineFlag of OpenPickLines
PrimaryRequestedQuantity Decimal PrimaryRequestedQuantity of OpenPickLines
PrimaryUOMCode String PrimaryUOMCode of OpenPickLines
Finder String Finder of OpenPickLines
PItem String PItem of OpenPickLines
PMovementRequest String PMovementRequest of OpenPickLines
POrder String POrder of OpenPickLines
POrganization String POrganization of OpenPickLines
POrganizationId String POrganizationId of OpenPickLines
PPickSlip String PPickSlip of OpenPickLines
PPickWave String PPickWave of OpenPickLines
PSourceSubinventory String PSourceSubinventory of OpenPickLines
PTransactionType String PTransactionType of OpenPickLines

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060