RPM Future Retail

id that uniquely identifies the future retail record.

id that uniquely identifies the item on the future retail record. items on the rpm_future_retail table are always transaction level items.

the department of the item. Oracle Retail target column DEPT on RPM_FUTURE_RETAIL.

the class of the item. Oracle Retail target column CLASS on RPM_FUTURE_RETAIL.

the subclass of the item. Oracle Retail target column SUBCLASS on RPM_FUTURE_RETAIL.

indicates the type of location on the rpm_future_retail record. valid values include: 0 store; 2 warehouse.

id that uniquely identifies the location on the rpm_future_retail record. this field will contain either a store or a warehouse.

the action date of the future retail event.

this field contains the regular unit retail price in the selling unit of measure for the item/location combination on the action date.

the currency for which the selling retail is represented.

this field contains the selling unit of measure for the item/locations single selling regular unit retail on the action date.

this field contains the number of units associated with the multi-unit regular retail for the item/location combination on the action date.

this field holds the multi-unit regular retail in the multi-unit selling unit of measure for the item/location combination on the action date.

the currency for which the multi-unit retail is represented.

this field holds the selling unit of measure for the item/locations regular multi-unit retail on the action date.

id that uniquely identifies the clearance that this clearance is an exception to. only filled if this clearance is a clearance exception.

this field contains the clearance unit retail price in the clearance unit of measure for the item/location combination on the action date.

the currency for which the clearance unit retail is represented

this field contains the selling unit of measure for the item/locations clearance unit retail on the action date.

id that uniquely identifies the price change. this field will be populated if there is either a price change occurring on the action date, or if there is a pricing event occurring on the action date that affects the regular retail for the price change on the action date.

display id that uniquely identifies the price change. this field will be populated if there is either a price change occurring on the action date, or if there is a pricing event occurring on the action date that affects the regular retail for the price change on the action date.

id that uniquely identifies the price change that this price change is an exception to. only filled if this price change is a price change exception.

the type of change being applied to the item/location on the price change. valid values include: 0 change by percent; 2 fixed price; 4 exclude; 5 change by amount;

the amount of change applied to the item/location on the price change.

when the value in the pc_change_type field is either 1 change by amount, or 2 fixed price, this field holds the currency associated with the amount field.

the percentage amount of change applied to the item/location on the price change.

the selling uom associated with the price change.

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.

this field contains the number of units associated with the multi-unit retail for the item/location combination on the price change.

this field holds the multi-unit retail in the multi-unit selling unit of measure for the item/location combination on the price change.

the currency for which the multi-unit retail is represented.

the multi-unit selling uom associated with the price change.

Rounding Rule ID that is attached to the price change.

id that uniquely identifies the clearance. this field will be populated if there is either a clearance occurring on the action date, or if there is a pricing event occurring on the action date that affects the clearance retail on the action date.

display id that uniquely identifies the clearance. this field will be populated if there is either a clearance occurring on the action date, or if there is a pricing event occurring on the action date that affects the clearance retail on the action date.

the current count of clearances for the item/location activated since the last reset date. this field will be populated if there is either a new clearance event occurring on the action date, or if there is a pricing event occurring on the action date that affects the clearance retail on the action date.

this field indicates the status of the clearance markdown. valid values include: 1 clearance is starting; 2 clearance is in progress; 3 clearance is ending;

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;

the amount of change applied to the item/location on the clearance. for clearance price changes with a change type of 1 change by amount, this is the amount that will be deducted from the current regular retail. for clearance price changes 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 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 selling uom associated with the clearance.

Rounding Rule ID that is attached to the clearance.

The item parent for the item when the item is a transaction level item

The diff id for the item parent that the item falls under

The maximum hierarchy level that this record could roll up to

The current hierarchy level for this record.