SalesOrdersForOrderHublinesexternalAssetReference
Stores external asset references tied to subscription items, aiding integration with external systems.
Columns
| Name | Type | Description |
| SalesOrdersForOrderHubHeaderId [KEY] | Long | Unique identifier for the sales order header, linking the external asset reference to the parent sales order, ensuring proper tracking of asset references within the order. |
| LinesFulfillLineId [KEY] | Long | Identifier for the fulfillment line associated with the external asset reference, enabling tracking of assets at the line level within the sales order. |
| ExternalAssetKey | String | Unique value that identifies the asset key for the subscription or coverage item in an external application, helping to integrate external asset management systems with Oracle systems. |
| ExternalParentAssetKey | String | Unique value that identifies the parent asset key for the subscription or coverage item in an external application, providing a hierarchical reference for asset relationships. |
| ExternalRootParentAssetKey | String | Unique value that identifies the root parent asset key for the subscription or coverage item in an external application, establishing the top-level asset relationship in external systems. |
| SubscriptionProductPuid | String | Unique identifier for the product within the subscription in Oracle Subscription Management Cloud, allowing accurate tracking of subscription-based products. |
| Finder | String | Method or tool used to locate specific external asset reference records, enabling efficient retrieval of asset data associated with the sales order. |
| FromDate | Date | Start date when the external asset reference is valid, marking the beginning of its applicability period. |
| HeaderId | Long | Unique identifier for the order header, used to link external asset references to the overall sales order in the system. |
| OrderKey | String | Unique key used to reference the sales order associated with the external asset reference, ensuring that all related transactions are properly tracked under the correct order. |
| OrderNumber | String | Unique order number assigned to the sales order, used for referencing the order across different platforms and processes. |
| SourceTransactionNumber | String | Transaction number from the source system, linking the external asset reference to its originating transaction, ensuring consistency across platforms. |
| SourceTransactionSystem | String | Source system name from which the external asset reference originated, providing context for integration and traceability with external systems. |
| ToDate | Date | End date when the external asset reference is no longer valid, marking the expiration of the asset reference and ensuring the reference period is time-bound. |