SalesOrdersForOrderHublineschargeschargeComponents
Manages detailed breakdowns of pricing components, such as taxes and discounts, at the order line level.
Columns
| Name | Type | Description |
| SalesOrdersForOrderHubHeaderId [KEY] | Long | Unique identifier for the sales order header, used to track and associate the charge components with the specific sales order in the system. |
| LinesFulfillLineId [KEY] | Long | Identifier for the fulfillment line within the sales order that corresponds to the charge component, ensuring the charge is applied to the correct item or service. |
| ChargesOrderChargeId [KEY] | Long | Unique identifier for the order charge within the sales order, linking the charge component to the main order charge. |
| OrderChargeComponentId [KEY] | Long | Unique identifier for the specific charge component within the order charge, used to track adjustments and detailed charge breakdowns. |
| SourceChargeComponentId | String | Value assigned by the source application to uniquely identify the charge component, facilitating integration between systems. |
| ChargeCurrencyUnitPrice | Decimal | Price or adjustment for each unit of the charge component, displayed in the currency selected for the order line. |
| ChargeCurrencyExtendedAmount | Decimal | The extended amount calculated by multiplying the unit price by the quantity of the item or service, expressed in the charge currency. |
| ChargeCurrencyDurationExtendedAmount | Decimal | The extended amount for the duration of the charge component, calculated similarly to the standard extended amount but reflecting a time-based calculation. |
| ChargeCurrencyCode | String | Abbreviation representing the currency code used for the charge component, such as USD. |
| ChargeCurrency | String | Full name of the currency used for the charge component, such as USD or EUR. |
| PriceElementCode | String | Abbreviation identifying the specific price element for the charge component, such as list price or net price. |
| PriceElement | String | Name of the price element, which could refer to the type of price applied, such as 'list price', 'discounted price', or 'net price'. |
| PriceElementUsageCode | String | Abbreviation identifying the charge component's usage, such as whether it is applied for shipping or as part of a specific discount. |
| PriceElementUsage | String | Detailed description of the charge component's usage, clarifying how the price element is applied in the context of the order. |
| SequenceNumber | Int | The sequence number indicating the order in which charge components are applied, helping to organize and prioritize the charges. |
| RollupFlag | Bool | Flag indicating whether the charge is a rollup value (true) for the charge component. For Oracle Fusion application priced orders, the default value is set based on the pricing setup. For pre-priced orders, the default value is false. |
| Explanation | String | Textual explanation that clarifies the charge component, offering transparency for billing or auditing purposes. |
| ExplanationMessageName | String | Message name for the explanation text displayed in the pricing breakdown dialog, assisting users in understanding the charge details. |
| HeaderCurrencyUnitPrice | Decimal | Price or adjustment for each unit of the item in the sales order, displayed in the currency used for the order header. |
| HeaderCurrencyExtendedAmount | Decimal | Extended amount in the currency of the order header, calculated by multiplying the unit price by the quantity of the items in the order. |
| HeaderCurrencyDurationExtendedAmount | Decimal | Extended amount for the duration of the charge, displayed in the currency of the order header. |
| HeaderCurrencyCode | String | Currency code used for the order header, such as USD, ensuring consistency across all charges related to the header. |
| HeaderCurrency | String | Name of the currency used for the order header, such as USD or EUR. |
| PercentOfComparisonElement | Decimal | Percentage representing the portion of the charge relative to a comparison element, such as the percent of the list price or net price. |
| PricingSourceId | String | Identifier for the pricing source that defines the lowest-level pricing applied, such as a line item price or tier rule. |
| PricingSourceTypeCode | String | Type of the pricing source, such as a segment price list or charge, providing context for the pricing logic applied. |
| PricingSourceType | String | Detailed name describing the type of pricing source, helping to clarify the origin of the pricing, such as 'price list' or 'tier rule'. |
| SourceMpaId | String | Identifier for the source of a manual price adjustment, linking the charge component to any manual modifications applied to the pricing. |
| TaxIncludedFlag | Bool | Indicates whether tax is included in the price of the charge component (true) or not (false). For Oracle Fusion application priced orders, this is set based on pricing setup. |
| TotalComponents | String | Total components associated with the charge component, often used for reporting or breakdown purposes to track all parts of a specific charge. |
| Finder | String | Tool or method used to locate specific charge components within the order system, allowing efficient retrieval of charge details for review or reporting. |
| FromDate | Date | Start date indicating when the charge component becomes applicable, helping to track the timing of charges in relation to the order's lifecycle. |
| HeaderId | Long | Unique identifier for the order header, linking charge components to the overall order in the system for proper tracking and processing. |
| OrderKey | String | Unique key assigned to the order for referencing the charge component, facilitating seamless processing and tracking across the system. |
| OrderNumber | String | Number that identifies the order in the system, used for managing and referencing the order, including all associated charge components. |
| SourceTransactionNumber | String | Transaction number from the source system, allowing the charge component to be linked to its originating transaction in external systems. |
| SourceTransactionSystem | String | System name from the source application, providing context for integration between the source transaction system and Oracle Fusion Order Management. |
| ToDate | Date | End date for the applicability of the charge component, marking the date when the charge is no longer valid or should be replaced. |