ADO.NET Provider for Oracle Fusion Cloud SCM

Build 24.0.9175

SalesOrdersForOrderHublinescoverageReferences

Stores details about coverage items associated with sales order lines, specifying which items they cover.

Columns

Name Type Description
SalesOrdersForOrderHubHeaderId [KEY] Long Unique identifier for the sales order header, linking the coverage references to the parent order and ensuring proper tracking across the order lifecycle.
LinesFulfillLineId [KEY] Long Identifier for the fulfillment line associated with the coverage reference, enabling proper tracking of coverage details at the line level within the sales order.
OrderNumber String Unique number assigned to the sales order, used for referencing the order throughout various processes like invoicing, fulfillment, and reporting.
SourceOrderNumber String Order number from the source system, providing the originating reference for the order and ensuring integration with external systems for consistent order tracking.
SourceLineNumber String Line number from the source system corresponding to the coverage reference, enabling proper linkage between the source system and the sales order in external systems.
DisplayLineNumber String User-friendly version of the order line number, used in interfaces to display the line item in a readable format, especially for customer-facing reports.
CoverageItemNumber String Unique identifier for the coverage item associated with the order line, helping to track which items are covered under the sales order, such as for warranties or service contracts.
CoverageFulfillLineId Long Fulfillment line ID for the coverage item, linking it to a specific fulfillment line, and aiding in the tracking of fulfillment for coverage under the order.
HeaderId Long Unique ID for the order header, ensuring that coverage references are linked to the correct sales order and maintaining consistency throughout the order’s lifecycle.
Finder String Method or tool used to locate coverage reference records within the sales order, allowing for efficient retrieval and management of coverage data.
FromDate Date Start date of the coverage reference, determining the period during which coverage is valid. Ensures accurate tracking of coverage within the specified time frame.
OrderKey String Unique key used to reference the sales order associated with the coverage reference, ensuring that all related transactions are accurately tracked under the correct order.
SourceTransactionNumber String Transaction number from the source system, linking the coverage reference to its originating transaction, and providing traceability when integrating with external systems.
SourceTransactionSystem String Name of the source system from which the coverage reference data originated, providing context for system integration and ensuring consistency across platforms.
ToDate Date End date when the coverage reference is no longer valid, marking the expiration of coverage and ensuring accurate coverage periods within the sales order.

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