Manual Price Adjustments

The Manual Price Adjustments view object that extracts manual price adjustment details from the sales orders.

Data Store Key : FscmTopModelAM.ScmExtractAM.DooBiccExtractAM.ManualPriceAdjustmentExtractPVO

Primary Keys : ManualPriceAdjustmentId

Initial Extract Date : ManualPriceAdjustmentCreationDate

Incremental Extract Date : ManualPriceAdjustmentLastUpdateDate

Attributes

This table provides the list of exposed attributes and their descriptions.

Name	Description
ManualPriceAdjustmentAdjustmentAmount	Value that's used to calculate the manual price adjustment. Can be a monetary unit or a percentage value.
ManualPriceAdjustmentAdjustmentElementBasis	Value that identifies the pricing basis for the calculation of manual price adjustment, such as list price or selling price.
ManualPriceAdjustmentAdjustmentTypeCode	Code that identifies the method used to calculate the manual price adjustment for a charge. A list of accepted values is defined in the lookup type ORA_QP_LINE_ADJ_TYPES.
ManualPriceAdjustmentChargeDefinitionCode	Code that identifies the charge definition of the charge to which the manual price adjustment is applied.
ManualPriceAdjustmentChargeRollupFlag	Indicates whether the charge to which the manual price adjustment is applied is a rollup charge. A list of accepted values is defined in the lookup type YES_NO.
ManualPriceAdjustmentComments	Comments on manual price adjustment.
ManualPriceAdjustmentCreatedBy	User who created the manual price adjustment row.
ManualPriceAdjustmentCreationDate	Date when the manual price adjustment row was created.
ManualPriceAdjustmentDeltaType	Value that identifies the type of change, such as update, cancel, and so on. Order Management uses this values when processing change order.
ManualPriceAdjustmentEffectivityTypeCode	Value 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.
ManualPriceAdjustmentId	Value that uniquely identifies the manual price adjustment. This is the primary key of the Manual Price Adjustments view object.
ManualPriceAdjustmentLastUpdateDate	Date when the manual price adjustment row was last updated.
ManualPriceAdjustmentLastUpdateLogin	Session login associated to the user who most recently updated the manual price adjustment row.
ManualPriceAdjustmentLastUpdatedBy	User who most recently updated the manual price adjustment row.
ManualPriceAdjustmentModifiedFlag	Indicates whether the manual price adjustment row has been modified. A list of accepted values is defined in the lookup type YES_NO. The default value is N.
ManualPriceAdjustmentNumberOfPeriods	Value that identifies the number of periods to use for the price adjustment.
ManualPriceAdjustmentObjectVersionNumber	Number of times the manual price adjustment row has been updated.
ManualPriceAdjustmentParentEntityCode	Code that identifies the parent entity to which the manual price adjustment is applied.
ManualPriceAdjustmentParentEntityId	Value that identifies the parent entity for the manual price adjustment.
ManualPriceAdjustmentPeriodFrom	Value that identifies the period when the price adjustment starts.
ManualPriceAdjustmentPeriodUntil	Value that identifies the period when the price adjustment ends.
ManualPriceAdjustmentPricePeriodicityCode	Code that identifies the price periodicity of the charge to which the manual price adjustment is applied.
ManualPriceAdjustmentReasonCode	Code that identifies the reason for the manual price adjustment. A list of accepted values is defined in the lookup type ORA_FOM_ADJUSTMENT_REASON_CODE.
ManualPriceAdjustmentReferenceMpaId	Value that identifies the previous manual price adjustment row. Order Management uses this values when processing change order.
ManualPriceAdjustmentSequenceNumber	Value that identifies the sequence in which the manual price adjustment is applied in relation to other manual price adjustments.
ManualPriceAdjustmentSourceManualPriceAdjId	Value that uniquely identifies the manual price adjustment row for the source order.
ManualPriceAdjustmentValidationStatusCode	Code that identifies the validation status of the manual price adjustment according to the pricing guidelines. A list of accepted values is defined in the lookup type ORA_FOM_MPA_VALIDATION_STATUS.