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. |