SalesOrdersForOrderHublinesmanualPriceAdjustments
SalesOrdersForOrderHublinesmanualPriceAdjustments
Columns
| Name | Type | Description |
| SalesOrdersForOrderHubHeaderId [KEY] | Long | SalesOrdersForOrderHubHeaderId of SalesOrdersForOrderHublinesmanualPriceAdjustments |
| LinesFulfillLineId [KEY] | Long | LinesFulfillLineId of SalesOrdersForOrderHublinesmanualPriceAdjustments |
| ManualPriceAdjustmentId [KEY] | Long | ManualPriceAdjustmentId of SalesOrdersForOrderHublinesmanualPriceAdjustments |
| AdjustmentAmount | Double | Amount of the manual price adjustment for a charge or total. The value is an amount or a percent. |
| AdjustmentElementBasis | String | Basis that pricing uses to calculate the manual pricing adjustment. |
| AdjustmentElementBasisName | String | Name of the basis that pricing uses to calculate the manual pricing adjustment. |
| AdjustmentTypeCode | String | Abbreviation that identifies the type of manual price adjustment. |
| AdjustmentType | String | Method that pricing uses to calculate manual price adjustment for the item. |
| ChargeDefinitionCode | String | Abbreviation that identifies the definition of the charge that pricing uses to apply a manual price adjustment. |
| ChargeDefinition | String | Definition of the charge that pricing uses to apply a manual price adjustment. |
| ChargeRollupFlag | Bool | Contains one of the following values: true or false. If true, then pricing rolls up the charge for the manual price adjustment. If false, then pricing does not do this roll up. For Oracle Fusion application priced orders, the default value is set based on the pricing setup. For pre-priced orders, there is no default value. |
| Comments | String | Comments that describe the manual price adjustment. |
| ParentEntityId | Long | ParentEntityId of SalesOrdersForOrderHublinesmanualPriceAdjustments |
| PricePeriodicityCode | String | Abbreviation that identifies the price periodicity of the charge where pricing applies the manual price adjustment. |
| PricePeriodicity | String | Price periodicity of the charge where pricing applies the manual price adjustment. |
| ReasonCode | String | Abbreviation that identifies the reason for the manual price adjustment. |
| Reason | String | Reason for the manual price adjustment. |
| SequenceNumber | Int | Sequence that pricing uses to apply the manual price adjustment in relation to other manual price adjustments. |
| SourceManualPriceAdjustmentId | String | Value that uniquely identifies the manual price adjustment. The source application assigns this value. |
| ValidationStatusCode | String | ValidationStatusCode of SalesOrdersForOrderHublinesmanualPriceAdjustments |
| EffectivityTypeCode | String | Abbreviation that identifies the type of effectivity to use for the price adjustment. A list of accepted values is defined in the lookup type ORA_OSS_PRICE_ADJ_EFFECTIVITY. This is available for use with the Integrate Order Management with Subscription Management to Process Subscriptions or Coverages features. |
| EffectivityType | String | Type of effectivity of the price adjustment. This is available for use with the Integrate Order Management with Subscription Management to Process Subscriptions or Coverages features. |
| EffectivePeriodFrom | Double | Number that identifies the period when the price adjustment starts. This is available for use with the Integrate Order Management with Subscription Management to Process Subscriptions or Coverages features. |
| EffectivePeriodUntil | Double | Number that identifies the period when the price adjustment ends. This is available for use with the Integrate Order Management with Subscription Management to Process Subscriptions or Coverages features. |
| EffectiveNumberOfPeriods | Double | Number of periods to use for the price adjustment. This is available for use with the Integrate Order Management with Subscription Management to Process Subscriptions or Coverages features. |
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 |