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
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| 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 |