CData Python Connector for Oracle Fusion Cloud SCM

Build 24.0.9175

OpenPickLinesDFFs

Customizes descriptive flexfields for pick lines, supporting specific data requirements.

Columns

Name Type Description
OpenPickLinesTransactionId [KEY] Long The unique identifier for the transaction in the OpenPickLinesDFFs table, used to track individual pick line transactions.
TransactionTempId [KEY] Long A temporary identifier for tracking the specific transaction during processing within the OpenPickLinesDFFs table.
_FLEX_Context String A context value representing the descriptive flexfield (DFF) context for the OpenPickLinesDFFs table, used for identifying specific DFF information.
_FLEX_Context_DisplayValue String The display value of the DFF context, providing a human-readable representation of the _FLEX_Context.
Finder String A field used to identify or locate specific records in the OpenPickLinesDFFs table, often used for search or filtering purposes.
PItem String The item identifier associated with a pick line, representing the specific product involved in the transaction within OpenPickLinesDFFs.
PMovementRequest String An identifier for the movement request linked to the pick line transaction, used to track material movement operations.
POrder String The order number associated with the pick line transaction, typically representing the sales order or purchase order in the system.
POrganization String The organization code linked to the pick line transaction, identifying the business unit or department responsible for the transaction.
POrganizationId String The unique identifier for the organization linked to the pick line transaction, differentiating between different organizational entities.
PPickSlip String The pick slip identifier associated with the transaction, used for tracking the physical picking of items in the warehouse.
PPickWave String The pick wave identifier for grouping pick line transactions that are processed together, often used in warehouse management systems.
PSourceSubinventory String The source subinventory where the items are being picked from during the transaction, indicating the location within the warehouse.
PTransactionType String The type of transaction being performed, such as receiving, shipping, or transfer, as defined in the OpenPickLinesDFFs context.
TransactionId Long The unique identifier for the overall transaction within the OpenPickLinesDFFs table, used for managing and referencing the entire process.

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