Cmdlets for Oracle Fusion Cloud SCM

Build 23.0.8839

SalesOrdersForOrderHublineschargeschargeComponents

SalesOrdersForOrderHublineschargeschargeComponents

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 Double Price or adjustment for each unit displayed in the charge currency that the order line uses.
ChargeCurrencyExtendedAmount Double 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 Double 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 Double Price or adjustment for each unit of the item, displayed in the currency that the order header uses.
HeaderCurrencyExtendedAmount Double Extended amount, displayed in the currency that the order header uses.
HeaderCurrencyDurationExtendedAmount Double 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 Double 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

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
FromDate Date FromDate
HeaderId String HeaderId
OrderKey String OrderKey
OrderNumber String OrderNumber
SourceTransactionNumber String SourceTransactionNumber
SourceTransactionSystem String SourceTransactionSystem
ToDate Date ToDate
Finder String finder

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