Retail Integration Bus Mappings Report Release: 13.0.0
Application Name: Retail Price Management System
Version 13.0.0
XML-Schema or Node Name:ClrPrcChgDesc.xsd
Tag Name
Table Name
Column Name
API Req
Description
location
rpm_future_retail
location
Yes
Contains the number which identifies the location
loc_type
rpm_future_retail
zone_node_type
Yes
Tells whether it is a Store or WareHouse
ClrPrcChgDtl
*
*
Yes
The detail for this Clearance.
Application Name: Retail Price Management System
Version 13.0.0
XML-Schema or Node Name:ClrPrcChgDtl
Tag Name
Table Name
Column Name
API Req
Description
clearance_id
rpm_clearance
clearance_id
Yes
Number that uniquely identifies a clearance
item
rpm_future_retail
clear_retail
Yes
Identifier for item
effective_date
rpm_clearance
effective_date
Yes
Date on which this clearance will be effective
selling_unit_retail
rpm_future_retail
clear_retail
Yes
retail price
selling_uom
rpm_future_retail
clear_uom
Yes
Unit of measure of the clerance item
selling_currency
rpm_future_retail
clear_retail_currency
Yes
Currency in which the item is sold
reset_clearance_id
rpm_future_retail
clearance_id
Yes
The id of the reset clearance.
RIB Mappings Report Release: 13.0.0
Retail Integration Bus Mappings Report Release: 13.0.0
Application Name: Retail Price Management System
Version 13.0.0
XML-Schema or Node Name:ClrPrcChgRef.xsd
Tag Name
Table Name
Column Name
API Req
Description
location
rpm_future_retail
location
Yes
Value that identifies a location
loc_type
rpm_future_retail
zone_node_type
Yes
Tells whether it is a Store or WareHouse
ClrPrcChgDtlref
*
*
Yes
The details for this Clearance.
Application Name: Retail Price Management System
Version 13.0.0
XML-Schema or Node Name:ClrPrcChgDtlRef
Tag Name
Table Name
Column Name
API Req
Description
clearance_id
rpm_clearance
clearance_id
Yes
*
item
rpm_future_retail
clear_retail
Yes
*
RIB Mappings Report Release: 13.0.0
Retail Integration Bus Mappings Report Release: 13.0.0
Application Name: Retail Price Management System
Version 13.0.0
XML-Schema or Node Name:ItemHdrDesc.xsd
Tag Name
Table Name
Column Name
API Req
Description
item
*
*
Yes
RPM only subscribes ItemHdrMod and only processes for Item Reclassification message
item_number_type
*
*
*
*
format_id
*
*
*
*
prefix
*
*
*
*
item_parent
*
*
*
*
item_grandparent
*
*
*
*
pack_ind
*
*
*
*
item_level
*
*
*
*
tran_level
*
*
*
*
diff_1
*
*
*
*
diff_1_type
*
*
*
*
diff_2
*
*
*
*
diff_2_type
*
*
*
*
diff_3
*
*
*
*
diff_3_type
*
*
*
*
diff_4
*
*
*
*
diff_4_type
*
*
*
*
dept
*
*
Yes
*
dept_name
*
*
*
*
class
*
*
Yes
*
class_name
*
*
*
*
subclass
*
*
Yes
*
sub_name
*
*
*
*
status
*
*
*
*
item_desc
*
*
*
*
short_desc
*
*
*
*
desc_up
*
*
*
*
primary_ref_item_ind
*
*
*
*
retail_zone_group_id
*
*
*
*
cost_zone_group_id
*
*
*
*
standard_uom
*
*
*
*
uom_conv_factor
*
*
*
*
package_size
*
*
*
*
package_uom
*
*
*
*
merchandise_ind
*
*
*
*
store_ord_mult
*
*
*
*
forecast_ind
*
*
*
*
mfg_rec_retail
*
*
*
*
retail_label_type
*
*
*
*
retail_label_type_desc
*
*
*
*
retail_label_value
*
*
*
*
handling_temp
*
*
*
*
handling_temp_desc
*
*
*
*
handling_sensitivity
*
*
*
*
handling_sensitivity_desc
*
*
*
*
catch_weight_ind
*
*
*
*
waste_type
*
*
*
*
waste_type_desc
*
*
*
*
waste_pct
*
*
*
*
default_waste_pct
*
*
*
*
const_dimen_ind
*
*
*
*
simple_pack_ind
*
*
*
*
contains_inner_ind
*
*
*
*
sellable_ind
*
*
*
*
orderable_ind
*
*
*
*
pack_type
*
*
*
*
order_as_type
*
*
*
*
comments
*
*
*
*
unit_retail
*
*
*
*
item_service_level
*
*
*
*
gift_wrap_ind
*
*
*
*
ship_alone_ind
*
*
*
*
vendor_style
*
*
*
*
std_unit_weight
*
*
*
*
single_price_flag
*
*
*
*
preticket_flag
*
*
*
*
planned_residual
*
*
*
*
autopackable
*
*
*
*
sortable
*
*
*
*
item_master_uda1
*
*
*
*
item_master_uda2
*
*
*
*
item_master_uda3
*
*
*
*
item_master_uda4
*
*
*
*
item_master_uda5
*
*
*
*
item_master_uda6
*
*
*
*
item_master_uda7
*
*
*
*
item_master_uda8
*
*
*
*
item_master_uda9
*
*
*
*
item_master_uda10
*
*
*
*
item_master_uda11
*
*
*
*
item_master_uda12
*
*
*
*
item_master_uda13
*
*
*
*
item_master_uda14
*
*
*
*
item_master_uda15
*
*
*
*
ship_alone
*
*
*
*
slottable
*
*
*
*
freight_class
*
*
*
*
new_item
*
*
*
*
brand
*
*
*
*
break_case_ups
*
*
*
*
rigid
*
*
*
*
fragile
*
*
*
*
container_type
*
*
*
*
conveyable_flag
*
*
*
*
hazard_matl_code
*
*
*
*
velocity
*
*
*
*
high_value_ind
*
*
*
*
ticket_type
*
*
*
*
color
*
*
*
*
size1
*
*
*
*
fit
*
*
*
*
shade
*
*
*
*
single_contain_bulk
*
*
*
*
unit_pick_system_code
*
*
*
*
roundable_flag
*
*
*
*
perishable_ind
*
*
*
*
division
*
*
*
*
vendor_nbr
*
*
*
*
kitting_wip_code
*
*
*
*
unit_ticket_qty
*
*
*
*
item_length
*
*
*
*
item_width
*
*
*
*
item_height
*
*
*
*
item_weight
*
*
*
*
item_cube
*
*
*
*
std_unit_factor
*
*
*
*
std_unit_qty
*
*
*
*
expiration_days
*
*
*
*
putaway_by_volume
*
*
*
*
putaway_plan
*
*
*
*
item_type
*
*
*
*
sorter_group
*
*
*
*
sku_optimization
*
*
*
*
ext_source_system
*
*
*
*
item_xform_ind
*
*
*
*
inventory_ind
*
*
*
*
order_type
*
*
*
*
sale_type
*
*
*
*
deposit_item_type
*
*
*
*
container_item
*
*
*
*
deposit_in_price_per_uom
*
*
*
*
transport_ind
*
*
*
*
RIB Mappings Report Release: 13.0.0
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
*
*
*
*
RIB Mappings Report Release: 13.0.0
Retail Integration Bus Mappings Report Release: 13.0.0
Application Name: Retail Price Management System
Version 13.0.0
XML-Schema or Node Name:ItemLocRef.xsd
Tag Name
Table Name
Column Name
API Req
Description
item
rpm_future_retail
item
Yes
*
ItemLocPhysRef
*
*
*
*
Application Name: Retail Price Management System
Version 13.0.0
XML-Schema or Node Name:ItemLocPhysRef
Tag Name
Table Name
Column Name
API Req
Description
physical_loc
*
*
*
*
ItemLocVirtRef
*
*
*
*
Application Name: Retail Price Management System
Version 13.0.0
XML-Schema or Node Name:ItemLocVirtRef
Tag Name
Table Name
Column Name
API Req
Description
loc
rpm_future_retail
location
Yes
*
RIB Mappings Report Release: 13.0.0
Retail Integration Bus Mappings Report Release: 13.0.0
Application Name: Retail Price Management System
Version 13.0.0
XML-Schema or Node Name:MrchHrClsDesc.xsd
Tag Name
Table Name
Column Name
API Req
Description
class
*
*
Yes
*
class_name
*
*
Yes
*
class_vat_ind
*
*
No
*
dept
*
*
Yes
*
RIB Mappings Report Release: 13.0.0
Retail Integration Bus Mappings Report Release: 13.0.0
Application Name: Retail Price Management System
Version 13.0.0
XML-Schema or Node Name:MrchHrClsRef.xsd
Tag Name
Table Name
Column Name
API Req
Description
class
*
*
*
*
dept
*
*
*
*
RIB Mappings Report Release: 13.0.0
Retail Integration Bus Mappings Report Release: 13.0.0
Application Name: Retail Price Management System
Version 13.0.0
XML-Schema or Node Name:MrchHrDeptDesc.xsd
Tag Name
Table Name
Column Name
API Req
Description
dept
rpm_merch_retail_def
dept
Yes
Checks for existing dept aggregation and adds new department aggregation.
dept_name
*
*
No
*
buyer
*
*
No
*
purchase_type
*
*
No
*
total_market_amt
*
*
No
*
merch
*
*
No
*
group_no
*
*
No
*
bud_mkup
*
*
No
*
profit_calc_type
*
*
No
*
markup_calc_type
rpm_merch_retail_def
markup_calc_type
Yes
*
otb_calc_type
*
*
No
*
max_avg_counter
*
*
No
*
avg_tolerance_pct
*
*
No
*
bud_int
*
*
No
*
dept_vat_incl_ind
*
*
No
*
RIB Mappings Report Release: 13.0.0
Retail Integration Bus Mappings Report Release: 13.0.0
Application Name: Retail Price Management System
Version 13.0.0
XML-Schema or Node Name:MrchHrDeptRef.xsd
Tag Name
Table Name
Column Name
API Req
Description
dept
rpm_merch_retail_def
dept
Yes
*
RIB Mappings Report Release: 13.0.0
Retail Integration Bus Mappings Report Release: 13.0.0
Application Name: Retail Price Management System
Version 13.0.0
XML-Schema or Node Name:MrchHrDivDesc.xsd
Tag Name
Table Name
Column Name
API Req
Description
division
*
*
Yes
*
div_name
*
*
Yes
*
buyer
*
*
No
*
merch
*
*
No
*
total_market_amt
*
*
No
*
RIB Mappings Report Release: 13.0.0
Retail Integration Bus Mappings Report Release: 13.0.0
Application Name: Retail Price Management System
Version 13.0.0
XML-Schema or Node Name:MrchHrDivRef.xsd
Tag Name
Table Name
Column Name
API Req
Description
division
*
*
*
*
RIB Mappings Report Release: 13.0.0
Retail Integration Bus Mappings Report Release: 13.0.0
Application Name: Retail Price Management System
Version 13.0.0
XML-Schema or Node Name:MrchHrGrpDesc.xsd
Tag Name
Table Name
Column Name
API Req
Description
group_no
*
*
Yes
*
group_name
*
*
Yes
*
buyer
*
*
No
*
merch
*
*
No
*
division
*
*
Yes
*
RIB Mappings Report Release: 13.0.0
Retail Integration Bus Mappings Report Release: 13.0.0
Application Name: Retail Price Management System
Version 13.0.0
XML-Schema or Node Name:MrchHrGrpRef.xsd
Tag Name
Table Name
Column Name
API Req
Description
group_no
*
*
*
*
RIB Mappings Report Release: 13.0.0
Retail Integration Bus Mappings Report Release: 13.0.0
Application Name: Retail Price Management System
Version 13.0.0
XML-Schema or Node Name:MrchHrSclsDesc.xsd
Tag Name
Table Name
Column Name
API Req
Description
subclass
*
*
Yes
*
subclass_name
*
*
Yes
*
class
*
*
Yes
*
dept
*
*
Yes
*
RIB Mappings Report Release: 13.0.0
Retail Integration Bus Mappings Report Release: 13.0.0
Application Name: Retail Price Management System
Version 13.0.0
XML-Schema or Node Name:MrchHrSclsRef.xsd
Tag Name
Table Name
Column Name
API Req
Description
subclass
*
*
Yes
*
class
*
*
Yes
*
dept
*
*
Yes
*
RIB Mappings Report Release: 13.0.0
Retail Integration Bus Mappings Report Release: 13.0.0
Application Name: Retail Price Management System
Version 13.0.0
XML-Schema or Node Name:PrmPrcChgDesc.xsd
Tag Name
Table Name
Column Name
API Req
Description
location
rpm_future_retail
location
*
*
loc_type
rpm_future_retail
zone_node_type
*
*
PrmPrcChgDtl
*
*
Yes
The detail for this promotion.
Application Name: Retail Price Management System
Version 13.0.0
XML-Schema or Node Name:PrmPrcChgDtl
Tag Name
Table Name
Column Name
API Req
Description
promo_id
rpm_promo
promo_id
Yes
*
promo_name
rpm_promo
name
Yes
*
promo_description
rpm_promo
description
Yes
*
promo_comp_id
rpm_promo_comp
promo_comp_id
Yes
*
promo_comp_desc
rpm_promo_comp
description
Yes
*
promo_comp_detail_id
rpm_promo_comp_detail
rpm_promo_comp_detail_id
Yes
*
apply_order
*
*
No
*
start_date
rpm_promo_comp_detail
start_date
Yes
*
end_date
rpm_promo_comp_detail
end_date
Yes
*
PrmPrcChgSmp
*
*
Yes
A list of these, one of which is a simple promotion.
PrmPrcChgThr
*
*
Yes
Thre is a list of these that represent a threshold Promotion.
PrmPrcChgBuyGet
*
*
Yes
A list of these, one of which is a buy get promotion.
Application Name: Retail Price Management System
Version 13.0.0
XML-Schema or Node Name:PrmPrcChgSmp
Tag Name
Table Name
Column Name
API Req
Description
item
rpm_future_retail
item
Yes
*
promo_selling_retail
rpm_future_retail
simple_promo_retail
Yes
*
promo_selling_uom
rpm_future_retail
simple_promo_uom
Yes
*
prm_chg_type
rpm_promo_comp_simple
change_type
Yes
*
prm_chg_value
rpm_promo_comp_simple
change_amt or change_percent
Yes
*
prm_chg_uom
rpm_promo_comp_simple
change_selling_uom
Yes
*
Application Name: Retail Price Management System
Version 13.0.0
XML-Schema or Node Name:PrmPrcChgThr
Tag Name
Table Name
Column Name
API Req
Description
item
rpm_future_retail
item
Yes
*
threshold_id
rpm_prom_comp_threshold
threshold_id
Yes
*
threshold_name
rpm_threshold
name
Yes
*
qualification_type
rpm_threshold
qualification_type
Yes
*
threshold_type
rpm_threshold_interval
threshold_type
Yes
*
prm_chg_type
rpm_threshold_interval
change_type
Yes
*
PrmPrcChgThrDtl
*
*
Yes
A list, one of wich is a promotion component detail.
Application Name: Retail Price Management System
Version 13.0.0
XML-Schema or Node Name:PrmPrcChgThrDtl
Tag Name
Table Name
Column Name
API Req
Description
threshold_value
rpm_threshold_interval
threshold_amount
Yes
*
prm_chg_value
rpm_threshold_interval
change_amt or change_percent
Yes
*
prm_chg_uom
rpm_threshold_interval
change_uom
Yes
*
Application Name: Retail Price Management System
Version 13.0.0
XML-Schema or Node Name:PrmPrcChgBuyGet
Tag Name
Table Name
Column Name
API Req
Description
prm_chg_type
rpm_promo_comp_buy_get
change_type
Yes
*
prm_chg_value
rpm_promo_comp_buy_get
change_amount or change_percent
Yes
*
prm_chg_uom
rpm_promo_comp_buy_get
change_selling_uom
Yes
*
buy_qty
rpm_promo_comp_buy_get
buy_item_qty
Yes
*
all_ind
rpm_promo_comp_buy_get
buy_item_type
Yes
*
PrmPrcChgGetItem
*
*
Yes
A list, one of which is an item on this get.
PrmPrcChgBuyItem
*
*
Yes
A list, one of which is an item on this buy.
Application Name: Retail Price Management System
Version 13.0.0
XML-Schema or Node Name:PrmPrcChgGetItem
Tag Name
Table Name
Column Name
API Req
Description
item
rpm_promo_get_item
item
Yes
*
Application Name: Retail Price Management System
Version 13.0.0
XML-Schema or Node Name:PrmPrcChgBuyItem
Tag Name
Table Name
Column Name
API Req
Description
item
rpm_promo_comp_buy_item
item
Yes
*
RIB Mappings Report Release: 13.0.0
Retail Integration Bus Mappings Report Release: 13.0.0
Application Name: Retail Price Management System
Version 13.0.0
XML-Schema or Node Name:PrmPrcChgRef.xsd
Tag Name
Table Name
Column Name
API Req
Description
location
rpm_future_retail
location
Yes
*
loc_type
rpm_future_retail
zone_node_type
Yes
*
PrmPrcChgDtlref
*
*
Yes
The details for this promotion.
Application Name: Retail Price Management System
Version 13.0.0
XML-Schema or Node Name:PrmPrcChgDtlRef
Tag Name
Table Name
Column Name
API Req
Description
promo_comp_detail_id
rpm_promo_comp_detail
rpm_promo_comp_detail_id
Yes
*
PrmPrcChgSmpDtlRef
rpm_future_retail
item
Yes
*
PrmPrcChgThrDtlref
*
*
Yes
The details for this threshold.
Application Name: Retail Price Management System
Version 13.0.0
XML-Schema or Node Name:PrmPrcChgSmpDtlRef
Tag Name
Table Name
Column Name
API Req
Description
item
rpm_future_retail
item
Yes
*
Application Name: Retail Price Management System
Version 13.0.0
XML-Schema or Node Name:PrmPrcChgThrDtlRef
Tag Name
Table Name
Column Name
API Req
Description
item
rpm_future_retail
item
Yes
*
RIB Mappings Report Release: 13.0.0
Retail Integration Bus Mappings Report Release: 13.0.0
Application Name: Retail Price Management System
Version 13.0.0
XML-Schema or Node Name:RegPrcChgDesc.xsd
Tag Name
Table Name
Column Name
API Req
Description
location
rpm_future_retail
location
Yes
*
loc_type
rpm_future_retail
zone_node_type
Yes
*
RegPrcChgDtl
*
*
Yes
Details for this price change.
Application Name: Retail Price Management System
Version 13.0.0
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
*
item
rpm_future_retail
item
Yes
*
effective_date
rpm_future_retail
action_date
Yes
*
selling_retail_changed_ind
*
*
Yes
IS NOT USED IN RPM
selling_unit_retail
rpm_future_retail
selling_retail
Yes
*
selling_uom
*
*
Yes
IS NOT USED BY RPM
selling_currency
rpm_future_retail
selling_retail currency
Yes
*
multi_unit_changed_ind
*
*
Yes
IS NOT USED BY RPM
multi_units
rpm_future_retail
multi_units
Yes
*
multi_unit_retail
rpm_future_retail
multi_unit_retail
Yes
*
multi_unit_retail_currency
*
*
Yes
IS NOT USED BY RPM
multi_selling_uom
rpm_future_retail
multi_selling_uom
Yes
*
RIB Mappings Report Release: 13.0.0
Retail Integration Bus Mappings Report Release: 13.0.0
Application Name: Retail Price Management System
Version 13.0.0
XML-Schema or Node Name:RegPrcChgRef.xsd
Tag Name
Table Name
Column Name
API Req
Description
location
rpm_future_retail
location
Yes
*
loc_type
rpm_future_retail
zone_node_type
Yes
*
RegPrcChgDtlRef
*
*
Yes
The details for the price change.
Application Name: Retail Price Management System
Version 13.0.0
XML-Schema or Node Name:RegPrcChgDtlRef
Tag Name
Table Name
Column Name
API Req
Description
price_change_id
rpm_price_change
price_change_id
Yes
*
item
rpm_future_retail
item
Yes
*
RIB Mappings Report Release: 13.0.0
Retail Integration Bus Mappings Report Release: 13.0.0
Application Name: Retail Price Management System
Version 13.0.0
XML-Schema or Node Name:StoreDesc.xsd
Tag Name
Table Name
Column Name
API Req
Description
store
rpm_zone_location
location
Yes
The Id of the location is stored in the location column.
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.0
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
*
*
*
*
RIB Mappings Report Release: 13.0.0
Retail Integration Bus Mappings Report Release: 13.0.0
Application Name: Retail Price Management System
Version 13.0.0
XML-Schema or Node Name:StoreRef.xsd
Tag Name
Table Name
Column Name
API Req
Description
store
*
*
*
*
AddrRef
*
*
*
*
Application Name: Retail Price Management System
Version 13.0.0
XML-Schema or Node Name:AddrRef
Tag Name
Table Name
Column Name
API Req
Description
addr
*
*
*
*
RIB Mappings Report Release: 13.0.0
Retail Integration Bus Mappings Report Release: 13.0.0
Application Name: Retail Price Management System
Version 13.0.0
XML-Schema or Node Name:WHDesc.xsd
Tag Name
Table Name
Column Name
API Req
Description
wh
rpm_zone_location
location
Yes
Warehouse only added to rpm_zone_location if the "Recoqnize Warehouse as location" in RPM System Options is checked and if the warehouse stockholding_ind = 'Y'
wh_name
*
*
*
*
wh_add1
*
*
*
*
wh_add2
*
*
*
*
wh_city
*
*
*
*
county
*
*
*
*
state
*
*
*
*
country_id
*
*
*
*
wh_pcode
*
*
*
*
email
*
*
*
*
stockholding_ind
*
*
Yes
Location will not be written if value = 'N'
channel_id
*
*
*
*
currency_code
*
*
*
*
duns_number
*
*
*
*
duns_loc
*
*
*
*
physical_wh
*
*
*
*
break_pack_ind
*
*
*
*
redist_wh_ind
*
*
*
*
delivery_policy
*
*
*
*
contact_person
*
*
*
*
dest_fax
*
*
*
*
phone_nbr
*
*
*
*
default_route
*
*
*
*
default_carrier_code
*
*
*
*
default_service_code
*
*
*
*
expedite_route
*
*
*
*
expedite_carrier_code
*
*
*
*
expedite_service_code
*
*
*
*
bol_upload_type
*
*
*
*
bol_print_type
*
*
*
*
lead_time
*
*
*
*
distance_to_dest
*
*
*
*
drop_trailers_accepted_flag
*
*
*
*
rcv_dock_available_flag
*
*
*
*
container_type
*
*
*
*
mld_default_route
*
*
*
*
unit_pick_container_type
*
*
*
*
dest_seq_nbr
*
*
*
*
owning_dc
*
*
*
*
AddrDesc
*
*
*
*
pricing_loc
*
*
Yes
Warehouse will be added to RPM_ZONE_LOCATION if this field is not null
pricing_loc_curr
*
*
*
*
Application Name: Retail Price Management System
Version 13.0.0
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
*
*
*
*
RIB Mappings Report Release: 13.0.0
Retail Integration Bus Mappings Report Release: 13.0.0