Excel Add-In for Oracle Fusion Cloud SCM

Build 24.0.9175

SalesOrdersForOrderHubtotals

Tracks total sales order costs, including subtotals and tax calculations.

Columns

Name Type Description
SalesOrdersForOrderHubHeaderId [KEY] Long Unique identifier for the sales order header, linking the totals to the overall order in the system.
OrderTotalId [KEY] Long Unique identifier for the order total, allowing tracking and management of the total values for the order.
TotalName String Name assigned to the total, used to specify the type of total (for example, subtotal, taxes, shipping) in the order.
TotalCode String Code assigned to the total for identification and categorization of the total (for example, TAX, SHIPPING).
TotalAmount Decimal Total amount for the order, calculated based on various factors like items, discounts, and taxes.
CurrencyName String Name of the currency used for the total, ensuring proper financial tracking across different regions (for example, USD, EUR).
CurrencyCode String Code of the currency used for the total, adhering to standard currency abbreviations (for example, USD).
TotalGroup String Group name to categorize the total (for example, charges, discounts, taxes) for easier reporting and analysis.
PrimaryFlag Bool Indicates whether the total is the primary total for the order (true) or not (false), typically used for financial reporting.
EstimatedFlag Bool Flag indicating whether the total is estimated (true) or actual (false), useful for provisional amounts in Oracle Fusion Order Management.
DisplayName String Display name for the total, often used in user interfaces or reports for easy reference by the customer or sales representative.
Finder String Method or tool used to locate specific total records in the system, enhancing data retrieval and search functionality.
FromDate Date Start date from which the total information is valid, used for ensuring accurate financial reporting from that point onward.
HeaderId Long Unique identifier for the header linking the total information to the sales order header in the system, ensuring data consistency.
OrderKey String Unique key used to reference the sales order associated with the total, helping ensure the correct data is tied to the appropriate order.
OrderNumber String Unique order number used to identify the sales order, a key reference point for reporting, invoicing, and shipping.
SourceTransactionNumber String Transaction number from the source system, used to link the total data to its originating transaction for consistency.
SourceTransactionSystem String Source system name from which the total data originated, providing context for integration with external systems.
ToDate Date End date when the total information is no longer valid, ensuring that the total amounts remain accurate for the defined time frame.

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