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:ClrPrcChgDesc.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')
ClrPrcChgDtl * * * *

Application Name: Retail Price Management System
Version 13.0.1
XML-Schema or Node Name:ClrPrcChgDtl
Tag Name Table Name Column Name API Req Description
clearance_id rpm_clearance clearance_id Yes Clearance Id
item rpm_future_retail clear_retail Yes Item Number
effective_date rpm_clearance effective_date Yes Effective date of the clearance
selling_unit_retail rpm_future_retail clear_retail Yes Clearance selling retail
selling_uom rpm_future_retail clear_uom Yes Clearance selling UOM
selling_currency rpm_future_retail clear_retail_currency Yes Clearance selling currency
reset_clearance_id rpm_clearance clearance_id Yes Clearance reset id