ODBC Driver for Oracle Fusion Cloud SCM

Build 25.0.9434

SalesOrdersForOrderHublinesdropShipPurchaseOrderReference

Tracks purchase orders used in drop shipping scenarios for sales order fulfillment.

Columns

Name Type Description
SalesOrdersForOrderHubHeaderId [KEY] Long Unique identifier for the sales order header, linking the drop-ship purchase order references to the parent sales order and ensuring proper tracking of the order.
LinesFulfillLineId [KEY] Long Identifier for the fulfillment line associated with the drop-ship purchase order reference, enabling tracking of drop-shipped items within the order.
POHeaderId String Unique identifier for the purchase order header, linking the sales order to the corresponding purchase order in the source system.
PONumber String Purchase order number from the source system, used for referencing the drop-ship purchase order in related documents, such as invoices and reports.
POLineId String Unique identifier for the purchase order line within the source system, linking the sales order to the specific line of the drop-ship purchase order.
POLineLocationId String Location identifier for the purchase order line, used to track where the goods are being shipped from or to in relation to the drop-ship purchase order.
DocumentSystemReferenceId [KEY] Long Unique identifier for the document system reference, linking the drop-ship purchase order to its associated documents in the source system.
Finder String Method or tool used to locate specific drop-ship purchase order reference records in the system, enabling efficient retrieval and management.
FromDate Date Start date of the drop-ship purchase order reference, used to track the validity period of the reference and ensure timely processing of related orders.
HeaderId Long Unique identifier for the order header, linking the drop-ship purchase order reference to the overall sales order.
OrderKey String Unique key used to reference the sales order associated with the drop-ship purchase order reference, ensuring that all related transactions are tracked under the correct order.
OrderNumber String Unique order number assigned to the sales order, used for referencing and tracking the order throughout the fulfillment and invoicing process.
SourceTransactionNumber String Transaction number from the source system, linking the drop-ship purchase order reference to its originating transaction, ensuring consistency across systems.
SourceTransactionSystem String Source system name from which the drop-ship purchase order reference originated, providing context for integration with external systems.
ToDate Date End date when the drop-ship purchase order reference is no longer valid, marking the expiration of the reference and ensuring that coverage is time-bound and accurate.

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