Oracle Portal Retail Integration Bus Mappings Report   

Application Name: Retail Price Management System
XML-Schema or Node Name:ClrPrcChgDesc.xsd
Tag Name Table Name Column Name API Req Description
location rpm_future_retail location Yes Unique identifier that indicates a Location (Store or Warehouse)
loc_type rpm_future_retail zone_node_type Yes Identifier that indicates whether a location is a Store ('S') or a Warehouse ('W')
ClrPrcChgDtl * * * *

Application Name: Retail Price Management System
XML-Schema or Node Name:ClrPrcChgDtl
Tag Name Table Name Column Name API Req Description
clearance_id rpm_clearance clearance_id Yes Clearance Id
item rpm_future_retail clear_retail Yes Item Number
effective_date rpm_clearance effective_date Yes Effective date of the clearance
selling_unit_retail rpm_future_retail clear_retail Yes Clearance selling retail
selling_uom rpm_future_retail clear_uom Yes Clearance selling UOM
selling_currency rpm_future_retail clear_retail_currency Yes Clearance selling currency
reset_clearance_id rpm_clearance clearance_id Yes Clearance reset id


Oracle Portal Retail Integration Bus Mappings Report   

Application Name: Retail Price Management System
XML-Schema or Node Name:ClrPrcChgRef.xsd
Tag Name Table Name Column Name API Req Description
location rpm_future_retail location Yes Unique identifier that indicates a Location (Store or Warehouse)
loc_type rpm_future_retail zone_node_type * Identifier that indicates whether a location is a Store ('S') or a Warehouse ('W')
ClrPrcChgDtlref * * * *

Application Name: Retail Price Management System
XML-Schema or Node Name:ClrPrcChgDtlRef
Tag Name Table Name Column Name API Req Description
clearance_id rpm_clearance clearance_id * Clearance Id
item rpm_future_retail item * Item Number


Oracle Portal Retail Integration Bus Mappings Report   

Application Name: Retail Price Management System
XML-Schema or Node Name:PrmPrcChgDesc.xsd
Tag Name Table Name Column Name API Req Description
location rpm_future_retail location * Unique identifier that indicates a Location (Store or Warehouse)
loc_type rpm_future_retail zone_node_type * Identifier that indicates whether a location is a Store ('S') or a Warehouse ('W')
PrmPrcChgDtl * * * *

Application Name: Retail Price Management System
XML-Schema or Node Name:PrmPrcChgDtl
Tag Name Table Name Column Name API Req Description
promo_id rpm_promo promo_id * Promotion Id
promo_name rpm_promo name * Promotion Name
promo_description rpm_promo description * Promotion Description
promo_comp_id rpm_promo_comp promo_comp_id * Promotion Component Id
promo_comp_desc rpm_promo_comp name * Promotion Component Description
promo_comp_detail_id rpm_promo_comp_detail rpm_promo_comp_detail_id * Promotion Component Detail Id
apply_order rpm_future_retail * * The order that this promotion component detail to be applied in case there is more than one promotion component details in one day for an item/location
start_date rpm_promo_comp_detail start_date * Start date of the promotion component detail
end_date rpm_promo_comp_detail end_date * End date of the promotion component detail
PrmPrcChgSmp * * * *
PrmPrcChgThr * * * *
PrmPrcChgBuyGet * * * *

Application Name: Retail Price Management System
XML-Schema or Node Name:PrmPrcChgSmp
Tag Name Table Name Column Name API Req Description
item rpm_future_retail item * Item number
promo_selling_retail rpm_future_retail simple_promo_retail * Simple Promotion selling retail
promo_selling_uom rpm_future_retail simple_promo_uom * Simple promotion selling UOM
prm_chg_type rpm_promo_comp_simple change_type * Simple Promotion change type
prm_chg_value rpm_promo_comp_simple change_amt or change_percent * Simple Promotion change value
prm_chg_uom rpm_promo_comp_simple change_selling_uom * Simple Promotion change selling UOM

Application Name: Retail Price Management System
XML-Schema or Node Name:PrmPrcChgThr
Tag Name Table Name Column Name API Req Description
item rpm_future_retail item * Item number
threshold_id rpm_prom_comp_threshold threshold_id * Threshold Id
threshold_name rpm_threshold name * Threshold Name
qualification_type rpm_threshold qualification_type * Threshold Qualification Type
threshold_type rpm_threshold_interval threshold_type * Threshold Type
prm_chg_type rpm_threshold_interval change_type * Threshold Discount Change Type
PrmPrcChgThrDtl * * * *

Application Name: Retail Price Management System
XML-Schema or Node Name:PrmPrcChgThrDtl
Tag Name Table Name Column Name API Req Description
threshold_value rpm_threshold_interval threshold_amount * Threshold Interval Value
prm_chg_value rpm_threshold_interval change_amt or change_percent * Threshold Change Value
prm_chg_uom rpm_threshold_interval change_uom * Threshold Change Selling UOM

Application Name: Retail Price Management System
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 * Buy Get discount change type
prm_chg_value rpm_promo_comp_buy_get change_amount or change_percent * Buy Get Discount Change Value
prm_chg_uom rpm_promo_comp_buy_get change_selling_uom change_selling_uom Buy Get Change Selling UOM
buy_qty rpm_promo_comp_buy_get buy_item_qty * Buy quantity
all_ind rpm_promo_comp_buy_get buy_item_type * Buy All Indicator
PrmPrcChgGetItem * * * *
PrmPrcChgBuyItem * * * *

Application Name: Retail Price Management System
XML-Schema or Node Name:PrmPrcChgGetItem
Tag Name Table Name Column Name API Req Description
item rpm_promo_get_item item * Get Item

Application Name: Retail Price Management System
XML-Schema or Node Name:PrmPrcChgBuyItem
Tag Name Table Name Column Name API Req Description
item rpm_promo_comp_buy_item item * Buy Item


Oracle Portal Retail Integration Bus Mappings Report   

Application Name: Retail Price Management System
XML-Schema or Node Name:PrmPrcChgRef.xsd
Tag Name Table Name Column Name API Req Description
location rpm_future_retail location * Unique identifier that indicates a Location (Store or Warehouse)
loc_type rpm_future_retail zone_node_type * Identifier that indicates whether a location is a Store ('S') or a Warehouse ('W')
PrmPrcChgDtlref * * * *

Application Name: Retail Price Management System
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 * Promotion Component Detail Id
PrmPrcChgSmpDtlRef * * * *
PrmPrcChgThrDtlref * * * *

Application Name: Retail Price Management System
XML-Schema or Node Name:PrmPrcChgSmpDtlRef
Tag Name Table Name Column Name API Req Description
item rpm_future_retail item * Item number

Application Name: Retail Price Management System
XML-Schema or Node Name:PrmPrcChgThrDtlRef
Tag Name Table Name Column Name API Req Description
item rpm_future_retail item * Item number


Oracle Portal Retail Integration Bus Mappings Report   

Application Name: Retail Price Management System
XML-Schema or Node Name:RegPrcChgDesc.xsd
Tag Name Table Name Column Name API Req Description
location rpm_future_retail location Yes Unique identifier that indicates a Location (Store or Warehouse)
loc_type rpm_future_retail zone_node_type Yes Identifier that indicates whether a location is a Store ('S') or a Warehouse ('W')
RegPrcChgDtl * * * *

Application Name: Retail Price Management System
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 Price Change Id
item rpm_future_retail item Yes Item number
effective_date rpm_future_retail action_date Yes Price Change Effective Date
selling_retail_changed_ind rpm_future_retail_gtt pc_selling_retail_ind Yes Indicate whether the regular selling retail is change by the Price Change
selling_unit_retail rpm_future_retail selling_retail Yes Regular selling retail
selling_uom rpm_future_retail selling_uom Yes Regular Selling UOM
selling_currency rpm_future_retail selling_retail currency Yes Regular Selling Retail Currency
multi_unit_changed_ind rpm_future_retail_gtt pc_multi_unit_ind Yes Indicate whether the Multi Unit Selling Retail is changed by the Price Change
multi_units rpm_future_retail multi_units No The number that indicate how many item is priced in the multi unit selling retail
multi_unit_retail rpm_future_retail multi_unit_retail No Multi Unit Selling Retail
multi_unit_retail_currency rpm_future_retail multi_unit_retail_currency No Multi Unit Retail Currency
multi_selling_uom rpm_future_retail multi_selling_uom No Multi Unit Selling UOM


Oracle Portal Retail Integration Bus Mappings Report   

Application Name: Retail Price Management System
XML-Schema or Node Name:RegPrcChgRef.xsd
Tag Name Table Name Column Name API Req Description
location rpm_future_retail location * Unique identifier that indicates a Location (Store or Warehouse)
loc_type rpm_future_retail zone_node_type * Identifier that indicates whether a location is a Store ('S') or a Warehouse ('W')
RegPrcChgDtlRef * * * *

Application Name: Retail Price Management System
XML-Schema or Node Name:RegPrcChgDtlRef
Tag Name Table Name Column Name API Req Description
price_change_id rpm_price_change price_change_id * Price Change ID
item rpm_future_retail item * Item number


Oracle Portal Retail Integration Bus Mappings Report   

Application Name: Retail Price Management System
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
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 * * * *