Tableau Connector for Oracle Fusion Cloud SCM

Build 24.0.9060

SalesOrdersForOrderHublinesmanualPriceAdjustments

The Manual Price Adjustments resource manages manual price adjustments that the Order Entry Specialist applies for each order line.

Columns

Name Type Description
SalesOrdersForOrderHubHeaderId [KEY] Long SalesOrdersForOrderHubHeaderId of SalesOrdersForOrderHublinesmanualPriceAdjustments
LinesFulfillLineId [KEY] Long LinesFulfillLineId of SalesOrdersForOrderHublinesmanualPriceAdjustments
ManualPriceAdjustmentId [KEY] Long ManualPriceAdjustmentId of SalesOrdersForOrderHublinesmanualPriceAdjustments
AdjustmentAmount Decimal 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 Decimal 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 Decimal 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 Decimal 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.
Finder String Finder of SalesOrdersForOrderHublinesmanualPriceAdjustments
FromDate Date FromDate of SalesOrdersForOrderHublinesmanualPriceAdjustments
HeaderId Long HeaderId of SalesOrdersForOrderHublinesmanualPriceAdjustments
OrderKey String OrderKey of SalesOrdersForOrderHublinesmanualPriceAdjustments
OrderNumber String OrderNumber of SalesOrdersForOrderHublinesmanualPriceAdjustments
SourceTransactionNumber String SourceTransactionNumber of SalesOrdersForOrderHublinesmanualPriceAdjustments
SourceTransactionSystem String SourceTransactionSystem of SalesOrdersForOrderHublinesmanualPriceAdjustments
ToDate Date ToDate of SalesOrdersForOrderHublinesmanualPriceAdjustments

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