RPM Item Loc Thread Ws Hist

Process_ID that is used to group the data that is being processed by NIL Batch.

The thread number of the record

Date/time stamp of when the record was created

system generated id. it is based on sequence RPM_ITEM_LOC_THREAD_WS_SEQ.

a valid item in rms that can be ranged to locations.

The item parent of the item when the item is a transaction level item.

The dept of the record if the record is at the merchandise hierarchy level.

The class of the record if the record is at the merchandise hierarchy level.

The subclass of the record if the record is at the merchandise hierarchy level.

loc. Oracle Retail target column LOC on RPM_ITEM_LOC_THREAD_WS_HIST.

zone node type, valid values are 0 for store and 2 for warehouse.

selling currency at the store.

selling unit retail Oracle Retail target column SELLING_UNIT_RETAIL on RPM_ITEM_LOC_THREAD_WS_HIST.

selling uom. Oracle Retail target column SELLING_UOM on RPM_ITEM_LOC_THREAD_WS_HIST.

multi units. Oracle Retail target column MULTI_UNITS on RPM_ITEM_LOC_THREAD_WS_HIST.

multi unit retail. Oracle Retail target column MULTI_UNIT_RETAIL on RPM_ITEM_LOC_THREAD_WS_HIST.

multi selling uom. Oracle Retail target column MULTI_UNIT_SELLING_UOM on RPM_ITEM_LOC_THREAD_WS_HIST.

Rounding Rule ID for the Clearance.

diff 1. Oracle Retail target column DIFF_1 on RPM_ITEM_LOC_THREAD_WS_HIST.

diff 2. Oracle Retail target column DIFF_2 on RPM_ITEM_LOC_THREAD_WS_HIST.

diff 3. Oracle Retail target column DIFF_3 on RPM_ITEM_LOC_THREAD_WS_HIST.

diff 4. Oracle Retail target column DIFF_4 on RPM_ITEM_LOC_THREAD_WS_HIST.

The maximum hier value for the record.

Oracle Retail target column STATUS on RPM_ITEM_LOC_THREAD_WS_HIST.

This is the most reason Clearance ID for the item location that is already in executed state.

This is the effective date of the executed clearance id.

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.

This indicates whether the price for the consignment/concession item will be managed by supplier or by retailer.When the supplier manages pricing for Consignment/Concession item, this must be set to Supplier(S).No value is required for Owned items and for consignment/concession items for which pricing is managed by the retailer.