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