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: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
RIB Mappings Report Release: 13.0.0
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.


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: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
RIB Mappings Report Release: 13.0.0
Tag Name Table Name Column Name API Req Description
clearance_id rpm_clearance clearance_id Yes *
item rpm_future_retail clear_retail Yes *


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:ItemHdrDesc.xsd
RIB Mappings Report Release: 13.0.0
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 * * * *


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
RIB Mappings Report Release: 13.0.0
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 * * * *


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: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
RIB Mappings Report Release: 13.0.0
Tag Name Table Name Column Name API Req Description
loc rpm_future_retail location Yes *


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:MrchHrClsDesc.xsd
RIB Mappings Report Release: 13.0.0
Tag Name Table Name Column Name API Req Description
class * * Yes *
class_name * * Yes *
class_vat_ind * * No *
dept * * Yes *


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:MrchHrClsRef.xsd
RIB Mappings Report Release: 13.0.0
Tag Name Table Name Column Name API Req Description
class * * * *
dept * * * *


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:MrchHrDeptDesc.xsd
RIB Mappings Report Release: 13.0.0
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 *


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:MrchHrDeptRef.xsd
RIB Mappings Report Release: 13.0.0
Tag Name Table Name Column Name API Req Description
dept rpm_merch_retail_def dept Yes *


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:MrchHrDivDesc.xsd
RIB Mappings Report Release: 13.0.0
Tag Name Table Name Column Name API Req Description
division * * Yes *
div_name * * Yes *
buyer * * No *
merch * * No *
total_market_amt * * No *


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:MrchHrDivRef.xsd
RIB Mappings Report Release: 13.0.0
Tag Name Table Name Column Name API Req Description
division * * * *


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:MrchHrGrpDesc.xsd
RIB Mappings Report Release: 13.0.0
Tag Name Table Name Column Name API Req Description
group_no * * Yes *
group_name * * Yes *
buyer * * No *
merch * * No *
division * * Yes *


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:MrchHrGrpRef.xsd
RIB Mappings Report Release: 13.0.0
Tag Name Table Name Column Name API Req Description
group_no * * * *


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:MrchHrSclsDesc.xsd
RIB Mappings Report Release: 13.0.0
Tag Name Table Name Column Name API Req Description
subclass * * Yes *
subclass_name * * Yes *
class * * Yes *
dept * * Yes *


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:MrchHrSclsRef.xsd
RIB Mappings Report Release: 13.0.0
Tag Name Table Name Column Name API Req Description
subclass * * Yes *
class * * Yes *
dept * * Yes *


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: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
RIB Mappings Report Release: 13.0.0
Tag Name Table Name Column Name API Req Description
item rpm_promo_comp_buy_item item Yes *


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: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
RIB Mappings Report Release: 13.0.0
Tag Name Table Name Column Name API Req Description
item rpm_future_retail item Yes *


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: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
RIB Mappings Report Release: 13.0.0
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 *


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: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
RIB Mappings Report Release: 13.0.0
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 *


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: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
RIB Mappings Report Release: 13.0.0
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 * * * *


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: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
RIB Mappings Report Release: 13.0.0
Tag Name Table Name Column Name API Req Description
addr * * * *


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: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
RIB Mappings Report Release: 13.0.0
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 * * * *


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:WHRef.xsd
Tag Name Table Name Column Name API Req Description
wh * * * *
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 * * * *