Price Adjustments

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

Data Store Key : FscmTopModelAM.ScmExtractAM.DooBiccExtractAM.PriceAdjustmentExtractPVO

Primary Keys : PriceAdjustmentId

Initial Extract Date : PriceAdjustmentCreationDate

Incremental Extract Date : PriceAdjustmentLastUpdateDate

Attributes

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

Name Description
PriceAdjustmentAdjustmentName Name of the price adjustment.
PriceAdjustmentAdjustmentTypeCode Code that identifies the type of price adjustment. A list of accepted values is defined in the lookup type DOO_ADJUSTMENT_TYPE.
PriceAdjustmentAmount Amount of the price adjustment. Can be charge or cost.
PriceAdjustmentCreatedBy User who created the price adjustment row.
PriceAdjustmentCreationDate Date when the price adjustment row was created.
PriceAdjustmentFulfillLineId Value that identifies the fulfillment line associated to the price adjustment row. This is a foreign key to the Fulfillment Lines view object.
PriceAdjustmentHeaderId Value that identifies the sales order header associated to the price adjustment row. This is a foreign key to the Sales Order Headers view object.
PriceAdjustmentId Value that uniquely identifies the price adjustment. This is the primary key of the Price Adjustments view object.
PriceAdjustmentInvoicedFlag Indicates whether the price adjustment has been billed. A list of accepted values is defined in the lookup type YES_NO. The default value is N.
PriceAdjustmentLastUpdateDate Date when the price adjustment row was last updated.
PriceAdjustmentLastUpdateLogin Session login associated to the user who most recently updated the price adjustment row.
PriceAdjustmentLastUpdatedBy User who most recently updated the price adjustment row.
PriceAdjustmentLineId Value that identifies the sales order line associated to the price adjustment row. This is a foreign key to the Sales Order Lines view object.
PriceAdjustmentObjectVersionNumber Number of times the price adjustment row has been updated.
PriceAdjustmentOrigSysAdjustmentRef Original reference for the price adjustment from the source system.