SalesOrdersForOrderHublinesoriginalOrderReference
Tracks the original order linked to return sales orders for reconciliation.
Columns
| Name | Type | Description |
| SalesOrdersForOrderHubHeaderId [KEY] | Long | Unique identifier for the sales order header, linking the original order reference to the parent order. This ensures proper tracking of the order's origin and relationship to subsequent changes or updates. |
| LinesFulfillLineId [KEY] | Long | Identifier for the fulfillment line associated with the original order reference, helping to track the fulfillment details for specific items on the order. |
| OriginalOrderNumber | String | Original order number, referencing the first order in a sequence or as the initial order in a series of linked transactions. This provides context for tracing the order's origin and any changes made. |
| OriginalSourceOrderNumber | String | Source order number from the external or originating system, ensuring the integration and consistency between Oracle Fusion and external order management systems. |
| OriginalSourceLineNumber | String | Line number from the source system that identifies a specific line item in the original order, enabling cross-system integration and accurate tracking of item details. |
| OriginalFulfillLineId | Long | Unique identifier for the fulfillment line from the original order, used for associating fulfillment activities with the original order's items. |
| OriginalHeaderId | Long | Header ID from the original order, linking it to the overall sales order and providing a connection between the original and subsequent orders or changes. |
| OriginalItemNumber | String | Original item number from the first order, used to reference the specific item being tracked across order modifications, returns, or other changes. |
| OriginalSourceOrderId | String | Unique identifier for the source order from the originating system, ensuring consistency and tracking when the original order comes from an external application. |
| OriginalSourceLineId | String | Line ID from the source system for the original order, enabling specific line-level reference for order integration and updates across systems. |
| OriginalSourceOrderSystem | String | Name of the source system from which the original order was placed, providing the context of the external system where the order was initiated. |
| OriginalItemLineNumber | String | Line number for the item in the original order, aiding in linking specific items to their corresponding orders and facilitating cross-system consistency. |
| Finder | String | Method or tool used to locate specific records in the order management system, allowing for efficient tracking and retrieval of related order reference data. |
| FromDate | Date | Start date when the original order reference becomes valid or applicable. This is useful for tracking the period when the order information is active or in effect. |
| HeaderId | Long | Unique identifier for the header of the order reference, linking the original order details to the overall sales order. |
| OrderKey | String | Unique key used to reference the sales order associated with the original order reference, ensuring all related transactions are tracked under the correct order. |
| OrderNumber | String | Unique sales order number that helps in tracking and referencing the order details, ensuring proper integration and consistency in the system. |
| SourceTransactionNumber | String | Transaction number from the source system, linking the original order reference to its originating transaction and ensuring traceability across systems. |
| SourceTransactionSystem | String | Source system name that provided the data for the original order reference, ensuring that external system integrations are properly tracked and consistent. |
| ToDate | Date | End date when the original order reference is no longer valid, marking the expiration or closure of the reference, ensuring timely updates in Oracle Fusion. |