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. |