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:StoreDesc.xsd
Tag Name Table Name Column Name API Req Description
store rpm_zone_location location Yes *
store_name * * * *
store_name10 * * * *
store_name3 * * * *
store_add1 * * * *
store_add2 * * * *
store_city * * * *
county * * * *
state * * * *
country_id * * * *
store_pcode * * * *
store_class * * * *
store_mgr_name * * * *
store_open_date * * * *
store_close_date * * * *
acquired_date * * * *
remodel_date * * * *
fax_number * * * *
phone_number * * * *
email * * * *
total_square_ft * * * *
selling_square_ft * * * *
linear_distance * * * *
stockholding_ind * * * *
channel_id * * * *
store_format * * * *
mall_name * * * *
district * * * *
district_name * * * *
promo_zone * * * *
promo_desc * * * *
transfer_zone * * * *
description * * * *
default_wh * * * *
stop_order_days * * * *
start_order_days * * * *
currency_code * * * *
lang * * * *
integrated_pos_ind * * * *
orig_currency_code * * * *
duns_number * * * *
duns_loc * * * *
AddrDesc * * * *
pricing_loc * * Yes If this field is null, the new store will not be added to RPM_ZONE_LOCATION table.
pricing_loc_curr * * * *

Application Name: Retail Price Management System
Version 13.0.1
XML-Schema or Node Name:AddrDesc
Tag Name Table Name Column Name API Req Description
addr * * * *
addr_type * * * *
primary_addr_type_ind * * * *
primary_addr_ind * * * *
add_1 * * * *
add_2 * * * *
add_3 * * * *
city * * * *
state * * * *
country_id * * * *
post * * * *
contact_name * * * *
contact_phone * * * *
contact_telex * * * *
contact_fax * * * *
contact_email * * * *
oracle_vendor_site_id * * * *
county * * * *