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