ADO.NET Provider for Oracle Fusion Cloud SCM

Build 24.0.9175

SalesOrdersForOrderHublinesinternalOrderReference

Tracks sales orders that are managed internally within the order management system.

Columns

Name Type Description
SalesOrdersForOrderHubHeaderId [KEY] Long Unique identifier for the sales order header, linking internal order reference details to the parent order. This ensures accurate tracking of internal orders associated with the sales order.
LinesFulfillLineId [KEY] Long Identifier for the fulfillment line associated with the internal order reference, allowing tracking of internal orders at the line level.
DocumentSystemReferenceId [KEY] Long Unique identifier for the reference document in the external or internal document system, ensuring seamless integration and traceability of the internal order with associated documents.
InternalOrderDocumentType String Type of the internal order document (for example, purchase order, requisition) that relates to the sales order, helping categorize and track different internal order document types.
Finder String Search method or tool used to locate specific internal order reference records, facilitating the retrieval of internal order data related to the sales order.
FromDate Date Start date when the internal order reference is valid, providing the time period for which the internal order applies.
HeaderId Long Unique identifier for the header of the internal order reference, ensuring that the reference is properly linked to the sales order at the header level.
OrderKey String Unique key that references the sales order related to the internal order, ensuring all transactions related to the order are appropriately tracked.
OrderNumber String Unique order number assigned to the sales order, used for tracking and referencing the order in reporting, invoicing, and fulfillment processes.
SourceTransactionNumber String Transaction number from the source system that links to the internal order reference, ensuring that all related transactions are accurately integrated between systems.
SourceTransactionSystem String Name of the source system where the transaction originated, providing insight into the external system from which the internal order reference data is sourced.
ToDate Date End date when the internal order reference is no longer applicable, marking the expiration of the internal order's validity period and ensuring time-bound data management.

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