SalesOrdersForOrderHublinesexternalFulfillmentSalesOrderReference
Tracks sales orders submitted to external fulfillment systems for processing and delivery.
Columns
| Name | Type | SupportedFinders | 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 | FindByOrderedDate | Start date when the external fulfillment sales order reference becomes valid, marking the beginning of its applicability period within the order. |
| HeaderId | Long | PrimaryKey, findByHeaderId | 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 | FindByOrderKey | Unique key used to reference the sales order associated with the external fulfillment sales order reference, ensuring consistency across all related transactions. |
| OrderNumber | String | FindByOrderNumber | Unique order number assigned to the sales order, used for referencing and tracking the order in reports, invoicing, and fulfillment. |
| SourceTransactionNumber | String | FindBySourceOrderNumberAndSystem | 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 | FindBySourceOrderNumberAndSystem | Source system name from which the external fulfillment sales order reference data originated, providing context for integration and traceability across platforms. |
| ToDate | Date | FindByOrderedDate | 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. |