RPM Price Change

id to uniquely identify the price change.

the id displayed to the user for the price change.

reason for the price change. possible reasons are maintained in the rpm code maintenance dialogue.

If the price change is a transaction item level price change that has been pulled off from a parent/zone level price change, this field holds the id of the parent price change the exception was pulled from.

item the price change is being applied to. can be at the transaction level or one level above the transaction level.

optional field that can be populated when the item field holds an item one level above the transaction. when it is populated, only children of the item in the item field with this diff_id value are effected by the price change.

price changes are optionally setup at either the zone level or at the location level. when a price change is at the zone level, this field will be populated.

price changes are optionally setup at either the zone level or at the location level. when a price change is at the location level, this field will be populated.

indicates whether the price change was created at a store, warehouse or zone

the date the price change will go into effect.

describes the type of price change exception. types include: change by amount, change by percent, change to amount and reset point of sale price.

when the change type is change by amount or change to amount this field will hold the amount.

when the change type is change by amount or change to amount this field will hold the currency of the amount.

when the change type is change by percent this field will hold percent.

when the change type is change to amount this field will hold percent will hold the selling uom associated with the amount.

This is a helper column to indicate what is the Price Change impact to Multi Unit information. Valid value comes from code_detail table with code_type PCIM; those are AU - Multi Unit information is added or updated, R - Multi Unit information is removed and N - Multi unit information is not changed, set to whatever it was in the system.

contains the new multi units determined by the price change.

this field contains the new multi unit retail price in the selling unit of measure determined by the price change.

this field contains the currency of the new multi unit retail price in the selling unit of measure determined by the price change.

this field holds the selling unit of measure for an items multi-unit retail.

the rounding rule id associated with the price change.

the date of the creation of the price change.

the user that created the price change.

the date of the last approval of the price change.

the id of the parent price change that generated this price change for area differentials

indicates whether or not pricing constraints should be considered on this price change.

Field to help with optimistic locking.

Indicates if the price change is a system generated exclusion or not.

The price change group the price change belongs to.

The date of the last update. Oracle Retail target column LAST_UPDATE_DATETIME on RPM_PRICE_CHANGE.

The user that made the last update.

Indicates if there are any conflicts associated with the price change.

The state of the price change.

This column indicates that this row was created automatically by a batch job.

The primary supplier for the item/location.

The purchase type. Valid value comes from code_detail table with code_type PRTP; those are 0 - Owned, 1 - Consignment and 2 - Concession.

The creator of the price change. Valid value comes from code_detail table with code_type PRCT; those are S - Supplier and R - Retailer.

The original item id entered by user during creation, which later got exploded to tran level due to ownership variation under created level.

The original diff_id entered by user during creation, which later got exploded to tran level due to ownership variation under created level.

The original zone_id entered by user during creation, which later got exploded to loc level due to ownership variation under created level.

The original price change id before the price change is exploded due to ownership variation under created level.

The file that processed the price change record

The source that last created/updated the price change