RPM Clearance

id to uniquely identify the clearance.

display id for the clearance. Oracle Retail target column CLEARANCE_DISPLAY_ID on RPM_CLEARANCE.

reason for the clearance. valid values include codes on the rpm_codes table with a code type of 0.

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

item the clearance 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 clearance is created at the parent level. this field can be specified when the transaction level items below the parent have diff ids attached. when specified, the clearance will only apply to those transaction level items that contain the diff_id.

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

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

indicates at what location level the clearance was created at. valid values include: 0-store; 1- zone; 2- warehouse.

the date the clearance will go into effect.

the type of change being applied to the item/location on the clearance. valid values include: 0 - change by percent; 1 - change by amount; 2 - fixed price; 4 - exclude; clearance with a change type of 'exclude' cannot be manually created - they are only created through the location move process and/or new item/location creation from rms.

the amount of change being applied to the item/location on the clearance. for clearance with a change type of 1 - change by amount, this is the amount that will be deducted from the current regular retail. for clearance with a change time of 2 - fixed price, this is the price of the item/location on clearance.

when the value in the change_type field is either 1 - change by amount, or 2 - fixed price, this field holds the currency of the amount.

the percentage amount of change being applied to the item/location on the clearance. this field will only hold a value for clearances with a change type of 0 - change by percent. the percentage in this field will be deducted from the current regular retail.

the selling uom associated with the clearance.

the rounding rule associated with the clearance.

the date the clearance was created.

the id of the user that created the clearance.

the date the clearance was last approved.

the id of the user that last approved the clearance.

field to help with optimistic locking.

Indicates if the clearance is a system generated exclusion or not.

The clearance group the clearance belongs to.

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

The user that made the last update.

Indicates if there are any conflicts associated with the clearance.

The current state of the clearance.

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

Markdown number for the clearance.

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 clearance. 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 clearance id before the clearance is exploded due to ownership variation under created level.

The file that processed the clearance record

The source that last created/updated the clearance