CData Python Connector for Oracle Fusion Cloud SCM

Build 24.0.9175

SalesOrdersForOrderHublinesexternalFulfillmentSalesOrderReference

Tracks sales orders submitted to external fulfillment systems for processing and delivery.

Columns

Name Type Description
SalesOrdersForOrderHubHeaderId [KEY] Long Unique identifier for the sales order header, linking the external fulfillment sales order reference to the parent order in Oracle Fusion Order Management, ensuring accurate tracking of fulfillment sales orders.
LinesFulfillLineId [KEY] Long Identifier for the fulfillment line associated with the external fulfillment sales order reference, providing granularity for tracking sales order fulfillment at the line level.
DocumentNumber String Unique identifier for the document associated with the external fulfillment sales order reference, used to track and cross-reference documents within external systems.
DocumentId String Unique identifier for the external document related to the fulfillment sales order, ensuring proper tracking and association with the sales order in external systems.
DocumentLineNumber String Line number within the external document, providing a reference to the specific item or action related to the fulfillment sales order.
DocumentSystemReferenceId [KEY] Long Unique identifier assigned to the document by the external system, enabling seamless integration between Oracle systems and external document management systems.
Finder String Method or tool used to locate specific external fulfillment sales order reference records in Oracle Fusion Order Management, enabling efficient retrieval of related data.
FromDate Date Start date when the external fulfillment sales order reference becomes valid, marking the beginning of its applicability period within the order.
HeaderId Long Unique identifier for the order header, used to link the external fulfillment sales order reference to the overall sales order in Oracle Fusion Order Management.
OrderKey String Unique key used to reference the sales order associated with the external fulfillment sales order reference, ensuring consistency across all related transactions.
OrderNumber String Unique order number assigned to the sales order, used for referencing and tracking the order in reports, invoicing, and fulfillment.
SourceTransactionNumber String Transaction number from the source system, linking the external fulfillment sales order reference to its originating transaction, ensuring proper integration with external systems.
SourceTransactionSystem String Source system name from which the external fulfillment sales order reference data originated, providing context for integration and traceability across platforms.
ToDate Date End date when the external fulfillment sales order reference is no longer valid, marking the expiration of the reference period and ensuring accurate, time-bound data.

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