SSIS Components for Oracle Fusion Cloud SCM

Build 24.0.9060

SalesOrdersForOrderHublineschargeschargeComponents

The Charge Components resource manages price details for the order line, including price elements and amounts.

Columns

Name Type Description
SalesOrdersForOrderHubHeaderId [KEY] Long SalesOrdersForOrderHubHeaderId of SalesOrdersForOrderHublineschargeschargeComponents
LinesFulfillLineId [KEY] Long LinesFulfillLineId of SalesOrdersForOrderHublineschargeschargeComponents
ChargesOrderChargeId [KEY] Long ChargesOrderChargeId of SalesOrdersForOrderHublineschargeschargeComponents
OrderChargeComponentId [KEY] Long OrderChargeComponentId of SalesOrdersForOrderHublineschargeschargeComponents
SourceChargeComponentId String Value that uniquely identifies the charge component. The source application assigns this value.
ChargeCurrencyUnitPrice Decimal Price or adjustment for each unit displayed in the charge currency that the order line uses.
ChargeCurrencyExtendedAmount Decimal Extended amount displayed in the currency that the charge uses. Extended amount equals the unit price multiplied by the quantity on the order line. For a configured item, the extended amount equals the unit price multiplied by the extended quantity on the order line.
ChargeCurrencyDurationExtendedAmount Decimal Extended amount for the duration displayed in the currency that the charge uses.
ChargeCurrencyCode String Abbreviation that identifies the currency that the charge component uses.
ChargeCurrency String Name of the currency that the charge component uses.
PriceElementCode String Abbreviation that identifies the price element.
PriceElement String Name of the price element, such as list price, net price, and so on.
PriceElementUsageCode String Abbreviation that identifies the charge component usage.
PriceElementUsage String Name that describes charge component usage.
SequenceNumber Int Sequence number for the charge component.
RollupFlag Bool Contains one of the following values: true or false. If true, then the value is a rollup value for the charge component. If false, then the value is not a rollup value. 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 Explanation of the charge component.
ExplanationMessageName String Message name of the explanation that displays in the price break down dialog.
HeaderCurrencyUnitPrice Decimal Price or adjustment for each unit of the item, displayed in the currency that the order header uses.
HeaderCurrencyExtendedAmount Decimal Extended amount, displayed in the currency that the order header uses.
HeaderCurrencyDurationExtendedAmount Decimal Extended amount for the duration, displayed in the currency that the order header uses.
HeaderCurrencyCode String Abbreviation that identifies the currency that the order header uses.
HeaderCurrency String Name of the currency that the order header uses.
PercentOfComparisonElement Decimal Percent that the unit price constitutes of the basis charge component. The default value for the basis is List Price. This attribute stores the margin percent, the percent that net price constitutes of the list price, and so on.
PricingSourceId String Value that identifies the source of the lowest level pricing. For example, it contains the Id that identifies a line on the price list, a tier rule, a shipping line, and so on.
PricingSourceTypeCode String Type of the price source, such as the charge of a segment price list. A list of accepted values is defined in the lookup type ORA_QP_SOURCE_TYPES.
PricingSourceType String Type of the price source.
SourceMpaId String Value that identifies the source of a manual price adjustment.
TaxIncludedFlag Bool Contains one of the following values: true or false. If true, then the price for the charge component includes tax. If false, then the price for the charge component does not include tax. 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.
TotalComponents String TotalComponents of SalesOrdersForOrderHublineschargeschargeComponents
Finder String Finder of SalesOrdersForOrderHublineschargeschargeComponents
FromDate Date FromDate of SalesOrdersForOrderHublineschargeschargeComponents
HeaderId Long HeaderId of SalesOrdersForOrderHublineschargeschargeComponents
OrderKey String OrderKey of SalesOrdersForOrderHublineschargeschargeComponents
OrderNumber String OrderNumber of SalesOrdersForOrderHublineschargeschargeComponents
SourceTransactionNumber String SourceTransactionNumber of SalesOrdersForOrderHublineschargeschargeComponents
SourceTransactionSystem String SourceTransactionSystem of SalesOrdersForOrderHublineschargeschargeComponents
ToDate Date ToDate of SalesOrdersForOrderHublineschargeschargeComponents

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060