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
*
*
*
*