Oracle Portal Retail Integration Bus Mappings Report    Release: 13.0.0

Application Name: Retail Price Management System
Version 13.0.0
XML-Schema or Node Name:ItemLocDesc.xsd
Tag Name Table Name Column Name API Req Description
item rpm_future_retail item Yes item
ItemLocPhys * * Yes An Array of these is read in on the java side. These are converted to an ItemLocVirt through the _itemLocVirtList.

Application Name: Retail Price Management System
Version 13.0.0
XML-Schema or Node Name:ItemLocPhys
Tag Name Table Name Column Name API Req Description
physical_loc * * * *
ItemLocVirt * * Yes Is used to retrieve the ItemLocVirt.
ItemLocVirtRepl * * * *

Application Name: Retail Price Management System
Version 13.0.0
XML-Schema or Node Name:ItemLocVirt
Tag Name Table Name Column Name API Req Description
loc rpm_future_retail location Yes The id of the location.
loc_type rpm_future_retail zone_node_type Yes when value is 's' the loc will be persisted.
local_item_desc * * * *
local_short_desc * * * *
status * * * *
primary_supp * * * *
primary_cntry * * * *
receive_as_type * * * *
taxable_ind * * * *
source_method * * * *
source_wh * * * *
unit_retail * * * *
selling_unit_retail rpm_future_retail selling_retail Yes The Id is read in and the currency for the id is found. the selling retail is then written and persisted.
selling_uom rpm_future_retail selling_uom Yes *
store_price_ind * * * *

Application Name: Retail Price Management System
Version 13.0.0
XML-Schema or Node Name:ItemLocVirtRepl
Tag Name Table Name Column Name API Req Description
loc rpm_future_retail location Yes *
loc_type rpm_future_retail zone_node_type Yes *
primary_repl_supplier * * * *
repl_method * * * *
reject_store_order_ind * * * *
next_delivery_date * * * *