SalesOrdersForOrderHubtotalstotalComponents
Breaks down components contributing to total order costs for transparency.
Columns
| Name | Type | Description |
| SalesOrdersForOrderHubHeaderId [KEY] | Long | Unique identifier for the sales order header, linking the total components to the overall order. Ensures consistency and proper tracking across systems. |
| TotalsOrderTotalId [KEY] | Long | Unique identifier for the order total, which aggregates all the total components related to the order. This ID helps group totals for reporting. |
| OrderTotalId | Long | Unique identifier for the specific order total within the overall order. It tracks the financials at a finer level, especially for invoices and charges. |
| OrderTotalComponentId [KEY] | Long | Unique identifier for the specific component of the order total. Used for detailed financial tracking and categorization of the total components. |
| OrderChargeComponentId | Long | Unique identifier for the charge component associated with the total. Helps distinguish between different charge types and their impact on the order total. |
| HeaderCurrencyCode | String | Currency code used for the header's financial transactions, such as USD, EUR, or GBP. It ensures proper currency tracking for the entire order. |
| HeaderCurrencyName | String | Currency name used for the header's financial transactions, such as USD, EUR, or GBP. This helps clarify the currency in reports. |
| HeaderCurrencyExtendedAmount | Decimal | The total amount for the header in the specified currency, including all charges, taxes, and other components, to provide an accurate financial total. |
| PriceElementCode | String | Code identifying the type of price element, such as list price, discount, tax, or shipping, for each component of the total. |
| PriceElement | String | Description or name of the price element (such as list price, discounted price, or tax amount), used to break down the total cost. |
| PriceElementUsageCode | String | Code that identifies the usage type of the price element (for example, one-time, recurring). This helps categorize how the price element is applied. |
| PriceElementUsage | String | Description of the usage for the price element, such as whether it is applied once or recurring, helping with proper financial tracking and reporting. |
| Finder | String | Method or tool used to search for specific total component records in the system, aiding in efficient data retrieval for analysis and reporting. |
| FromDate | Date | Start date from which the total component is valid. Ensures that the total components are tracked and applied from the correct date. |
| HeaderId | Long | Unique identifier for the header, linking the total component to the specific sales order, ensuring consistency and data integrity. |
| OrderKey | String | Unique key used to identify the order associated with the total component, ensuring all components are correctly linked to their respective orders. |
| OrderNumber | String | Unique number identifying the sales order. This is used in reports, invoicing, and fulfillment processes to track the order. |
| SourceTransactionNumber | String | Transaction number from the source system, used to link the total component to its originating transaction and ensure integration with external systems. |
| SourceTransactionSystem | String | Source system name from which the total component data originated, helping with integration and providing context for transaction handling. |
| ToDate | Date | End date when the total component is no longer valid, ensuring accurate financial data for reporting, with an accurate cutoff for each total component. |