Oracle Portal Retail Integration Bus Mappings Report    Release: 13.0.1

Application Name: Retail Price Management System
Version 13.0.1
XML-Schema or Node Name:RegPrcChgDesc.xsd
Tag Name Table Name Column Name API Req Description
location rpm_future_retail location Yes Unique identifier that indicates a Location (Store or Warehouse)
loc_type rpm_future_retail zone_node_type Yes Identifier that indicates whether a location is a Store ('S') or a Warehouse ('W')
RegPrcChgDtl * * * *

Application Name: Retail Price Management System
Version 13.0.1
XML-Schema or Node Name:RegPrcChgDtl
Tag Name Table Name Column Name API Req Description
price_change_id rpm_price_change price_change_id Yes Price Change Id
item rpm_future_retail item Yes Item number
effective_date rpm_future_retail action_date Yes Price Change Effective Date
selling_retail_changed_ind rpm_future_retail_gtt pc_selling_retail_ind Yes Indicate whether the regular selling retail is change by the Price Change
selling_unit_retail rpm_future_retail selling_retail Yes Regular selling retail
selling_uom rpm_future_retail selling_uom Yes Regular Selling UOM
selling_currency rpm_future_retail selling_retail currency Yes Regular Selling Retail Currency
multi_unit_changed_ind rpm_future_retail_gtt pc_multi_unit_ind Yes Indicate whether the Multi Unit Selling Retail is changed by the Price Change
multi_units rpm_future_retail multi_units No The number that indicate how many item is priced in the multi unit selling retail
multi_unit_retail rpm_future_retail multi_unit_retail No Multi Unit Selling Retail
multi_unit_retail_currency rpm_future_retail multi_unit_retail_currency No Multi Unit Retail Currency
multi_selling_uom rpm_future_retail multi_selling_uom No Multi Unit Selling UOM