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. |