Retail Integration Mappings Report Release:15.0.0 (Retail Price Management)
Application Retail Price Management
Target Name Space http://www.oracle.com/retail/integration/base/bo/PrmPrcChgDesc/v1
Version 1.0
Description This is root element of this document which contains name space definitions for the document elements.
XSD Structure

XML-Schema Name:PrmPrcChgDesc Version:15.0.0 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for PrmPrcChgDesc in RPM application.
RPM's Table Name RPM's Column Name Integration API(RIB or/and RSB or/and RSL) RPM's Column Length Is Column Required in RPM's API? RPM's API Description
location number10 1 1 Unique identifier that indicates a Location (Store or Warehouse) rpm_promo_location_payload location number 10 Yes Unique identifier that indicates a Location (Store or Warehouse)
loc_type varchar21 1 1 Identifier that indicates whether a location is a Store ('S') or a Warehouse ('W') rpm_promo_location_payload location_type number 30 * Identifier that indicates whether a location is a Store ('S') or a Warehouse ('W')
PrmPrcChgDtl * 1 unbounded Description is not available.

XML-Schema Name:PrmPrcChgDtl Version:15.0.0 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for PrmPrcChgDtl in RPM application.
RPM's Table Name RPM's Column Name Integration API(RIB or/and RSB or/and RSL) RPM's Column Length Is Column Required in RPM's API? RPM's API Description
promo_id number10 1 1 Promotion Id rpm_promo_dtl_payload promo_id number 10 Yes Promotion Id
promo_name varchar240 0 1 Promotion Name rpm_promo_dtl_payload name varchar2 160 * Promotion Name
promo_description varchar2160 0 1 Promotion Description rpm_promo_dtl_payload description varchar2 640 * Promotion Description
promo_comp_id number10 1 1 Promotion Component Id rpm_promo_dtl_payload promo_comp_id number 10 Yes Promotion Component Id
promo_comp_desc varchar240 0 1 Promotion Component Description rpm_promo_dtl_payload name varchar2 160 * Promotion Component Description
promo_comp_detail_id number10 1 1 Promotion Component Detail Id rpm_promo_dtl_payload promo_dtl_id number 10 Yes Promotion Component Detail Id
apply_order number1 1 1 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 rpm_promo_dtl_payload apply_order number 6 * 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 xs:dateTime 1 1 Start date of the promotion component detail rpm_promo_dtl_payload start_date date Fill column length. Yes Start date of the promotion component detail
end_date xs:dateTime 0 1 End date of the promotion component detail rpm_promo_dtl_payload end_date date Fill column length. No End date of the promotion component detail
PrmPrcChgSmp * 0 unbounded Description is not available.
PrmPrcChgThr * 0 unbounded Description is not available.
PrmPrcChgBuyGet * 0 unbounded Description is not available.

XML-Schema Name:PrmPrcChgSmp Version:15.0.0 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for PrmPrcChgSmp in RPM application.
RPM's Table Name RPM's Column Name Integration API(RIB or/and RSB or/and RSL) RPM's Column Length Is Column Required in RPM's API? RPM's API Description
item varchar225 1 1 Item number rpm_promo_dtl_merch_node item varchar2 25 * Item number
promo_selling_retail number20 1 1 Simple Promotion selling retail rpm_future_retail simple_promo_retail number 20,4 * Simple Promotion selling retail
promo_selling_uom xs:string 1 1 Simple promotion selling UOM rpm_future_retail simple_promo_uom varchar2 4 * Simple promotion selling UOM
prm_chg_type varchar21 1 1 Simple Promotion change type rpm_promo_dtl_disc_ladder change_type number 2 * Simple Promotion change type
prm_chg_value number20 1 1 Simple Promotion change value rpm_promo_dtl_disc_ladder change_amt or change_percent number 20,4 * Simple Promotion change value
prm_chg_uom varchar24 0 1 Simple Promotion change selling UOM rpm_promo_dtl_disc_ladder change_selling_uom varchar2 4 * Simple Promotion change selling UOM

XML-Schema Name:PrmPrcChgThr Version:15.0.0 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for PrmPrcChgThr in RPM application.
RPM's Table Name RPM's Column Name Integration API(RIB or/and RSB or/and RSL) RPM's Column Length Is Column Required in RPM's API? RPM's API Description
item varchar225 1 1 Item number rpm_promo_dtl_merch_node item varchar2 25 * Item number
threshold_id number6 1 1 Threshold Id rpm_threshold threshold_id number 6 * Threshold Id
threshold_name varchar230 0 1 Threshold Name rpm_threshold name varchar2 120 * Threshold Name
qualification_type number1 1 1 Threshold Qualification Type rpm_threshold qualification_type number 1 * Threshold Qualification Type
threshold_type varchar21 1 1 Threshold Type rpm_threshold_interval threshold_type number 1 * Threshold Type
prm_chg_type varchar21 1 1 Threshold Discount Change Type rpm_promo_dtl_disc_ladder change_type number 2 * Threshold Discount Change Type
PrmPrcChgThrDtl * 1 unbounded Description is not available.

XML-Schema Name:PrmPrcChgThrDtl Version:15.0.0 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for PrmPrcChgThrDtl in RPM application.
RPM's Table Name RPM's Column Name Integration API(RIB or/and RSB or/and RSL) RPM's Column Length Is Column Required in RPM's API? RPM's API Description
threshold_value number20 1 1 Threshold Interval Value rpm_threshold_interval threshold_amount number 20,4 * Threshold Interval Value
prm_chg_value number20 1 1 Threshold Change Value rpm_threshold_interval change_amt or change_percent number 20,4 * Threshold Change Value
prm_chg_uom varchar24 0 1 Threshold Change Selling UOM rpm_threshold_interval change_uom varchar2 4 * Threshold Change Selling UOM

XML-Schema Name:PrmPrcChgBuyGet Version:15.0.0 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for PrmPrcChgBuyGet in RPM application.
RPM's Table Name RPM's Column Name Integration API(RIB or/and RSB or/and RSL) RPM's Column Length Is Column Required in RPM's API? RPM's API Description
prm_chg_type varchar21 1 1 Buy Get discount change type rpm_promo_dtl_disc_ladder change_type number 2 * Buy Get discount change type
prm_chg_value number20 1 1 Buy Get Discount Change Value rpm_promo_dtl_disc_ladder change_amount or change_percent number 20,4 * Buy Get Discount Change Value
prm_chg_uom varchar24 0 1 Buy Get Change Selling UOM rpm_promo_dtl_disc_ladder change_selling_uom varchar2 4 change_selling_uom Buy Get Change Selling UOM
buy_qty number20 1 1 Buy quantity rpm_promo_dtl_disc_ladder qual_value number 20,4 * Buy quantity
all_ind number1 1 1 Buy All Indicator rpm_promo_dtl_disc_ladder qual_type number 2 * All Indicator
PrmPrcChgGetItem * 1 unbounded Description is not available.
PrmPrcChgBuyItem * 1 unbounded Description is not available.

XML-Schema Name:PrmPrcChgGetItem Version:15.0.0 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for PrmPrcChgGetItem in RPM application.
RPM's Table Name RPM's Column Name Integration API(RIB or/and RSB or/and RSL) RPM's Column Length Is Column Required in RPM's API? RPM's API Description
item varchar225 1 1 Get Item rpm_promo_dtl_merch_node item varchar2 25 * Get Item

XML-Schema Name:PrmPrcChgBuyItem Version:15.0.0 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for PrmPrcChgBuyItem in RPM application.
RPM's Table Name RPM's Column Name Integration API(RIB or/and RSB or/and RSL) RPM's Column Length Is Column Required in RPM's API? RPM's API Description
item varchar225 1 1 Buy Item rpm_promo_dtl_merch_node item varchar2 25 * Buy Item

Retail Integration Mappings Report Release:15.0.0
Retail Integration Mappings Report Release:15.0.0 (Retail Price Management)
Application Retail Price Management
Target Name Space http://www.oracle.com/retail/integration/base/bo/InvocationSuccess/v1
Version 1.0
Description
XSD Structure

XML-Schema Name:InvocationSuccess Version:15.0.0 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for InvocationSuccess in RPM application.
RPM's Table Name RPM's Column Name Integration API(RIB or/and RSB or/and RSL) RPM's Column Length Is Column Required in RPM's API? RPM's API Description
success_message varchar2500 0 1 N/A N/A N/A N/A N/A N/A

Retail Integration Mappings Report Release:15.0.0
Retail Integration Mappings Report Release:15.0.0 (Retail Price Management)
Application Retail Price Management
Target Name Space http://www.oracle.com/retail/integration/base/bo/PromotionDesc/v1
Version 1.0
Description This is root element of this document which contains name space definitions for the document elements.
XSD Structure

XML-Schema Name:PromotionDesc Version:15.0.0 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for PromotionDesc in RPM application.
RPM's Table Name RPM's Column Name Integration API(RIB or/and RSB or/and RSL) RPM's Column Length Is Column Required in RPM's API? RPM's API Description
promo_id number10 1 1 Promotion ID rpm_promo_dtl_payload promo_id number 10 Yes promotion ID
promo_name varchar2160 0 1 Promotion Header Name rpm_promo_dtl_payload promo_name varchar2 160 * promotion header name
promo_description varchar2640 0 1 Promotion Header Description rpm_promo_dtl_payload promo_desc varchar2 640 No promotion header description
promo_comp_id number10 1 1 Promotion Component Id rpm_promo_dtl_payload promo_comp_id number 10 Yes promotion component ID
promo_comp_desc varchar2160 0 1 Promotion Component Name rpm_promo_dtl_payload promo_comp_desc varchar2 160 No Promotion Component Description
promo_comp_type number2 1 1 Promotion Component Type rpm_promo_dtl_payload promo_comp_type number 2 Yes promotion component type - (0) multi-buy, (1) simple, (2) threshold, (3) finance, (4) transaction
promo_dtl_id number10 1 1 Promotion Component Detail Id rpm_promo_dtl_payload promo_dtl_id number 10 Yes promotion component detail ID
apply_order number6 1 1 Application Order of the Promotion rpm_promo_dtl_payload apply_order number 6 Yes the order the promotion will be applied if there aremultiple promotions
start_date xs:dateTime 1 1 Start Date of Promotion Component Detail rpm_promo_dtl_payload start_date date Fill column length. Yes start date of the promotion detail
end_date xs:dateTime 0 1 End Date of Promotion Component Detail rpm_promo_dtl_payload end_date date Fill column length. No end date of the promotion component detail
apply_to_code number1 0 1 Determines if the promo discount will be applied to regular, clearance retail or both RPM_PROMO_DTL_PAYLOAD APPLY_TO_CODE NUMBER 1 Yes Determines if the promotional discount will be applied to regular retail (0), clearance retail (1) or both (2)
discount_limit number3 0 1 The number of times that the promotion can be applied to a transaction. RPM_PROMO_DTL_PAYLOAD DISCOUNT_LIMIT NUMBER 3 No Limit of the discount
exception_parent_id number10 0 1 Parent promotion component detail ID if the detail isan exception rpm_promo_dtl_payload exception_parent_id number 10 No Parent promotion component detail ID if the detail isan exception
LocationList * 1 unbounded Description is not available.
ListGroup * 1 unbounded Description is not available.
ItemLocSimpleRet * 0 unbounded Description is not available.
customer_type_id number10 0 1 Customer Type rpm_promo_dtl_payload customer_type number 10 No the customer type of the promotion component
CreditDetail * 0 unbounded Description is not available.
threshold_qual_type number1 0 1 The Threshold qualification type. A value of 1 means threshold level and a value of 0 means item level. RPM_PROMO_DTL_PAYLOAD THRESH_QUALIFICATION_TYPE NUMBER 1 No indicates the level of threshold promos, valid values are 0 for item level and 1 for threshold level

XML-Schema Name:LocationList Version:15.0.0 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for LocationList in RPM application.
RPM's Table Name RPM's Column Name Integration API(RIB or/and RSB or/and RSL) RPM's Column Length Is Column Required in RPM's API? RPM's API Description
location number10 1 1 Location Number rpm_promo_location_payload location number 10 Yes location number
loc_type varchar22 1 1 Location Type rpm_promo_location_payload location_type varchar2 30 Yes location type

XML-Schema Name:ListGroup Version:15.0.0 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for ListGroup in RPM application.
RPM's Table Name RPM's Column Name Integration API(RIB or/and RSB or/and RSL) RPM's Column Length Is Column Required in RPM's API? RPM's API Description
listgroup_id number10 1 1 Promotion Detail List Group ID rpm_promo_dtl_list_grp_payload promo_dtl_list_grp_id number 10 Yes Promotion Detail List Group ID
ListDtl * 1 unbounded Description is not available.

XML-Schema Name:ListDtl Version:15.0.0 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for ListDtl in RPM application.
RPM's Table Name RPM's Column Name Integration API(RIB or/and RSB or/and RSL) RPM's Column Length Is Column Required in RPM's API? RPM's API Description
listdtl_id number10 1 1 Promotion Detail List ID RPM_PROMO_DTL_LIST_PAYLOAD PROMO_DTL_LIST_ID NUMBER 10 Yes Promotion Detail List Id
reward_application number1 0 1 Reward Application RPM_PROMO_DTL_LIST_PAYLOAD REWARD_APPLICATION NUMBER 1 No determine whether the reward is embedded in this list or is shared among all lists for the group
description varchar2160 0 1 Description for the promo detail list RPM_PROMO_DTL_LIST_PAYLOAD DESCRIPTION VARCHAR2 120 No Description
DiscountLadder * 0 unbounded Description is not available.
ItemList * 1 unbounded Description is not available.
price_range_min number20_4 0 1 Contains price range promotion minimum valid retail value RPM_PROMO_DTL_PRC_RNG_PAYLOAD BUY_LIST_MIN, GET_LIST_MIN NUMBER 20, 4 No Minimum promotion price for the buy/get list item
price_range_max number20_4 0 1 Contains price range promotion maximum valid retail value RPM_PROMO_DTL_PRC_RNG_PAYLOAD BUY_LIST_MAX GET_LIST_MAX NUMBER 20, 4 No Maximum promotion price for the buy/get list item

XML-Schema Name:DiscountLadder Version:15.0.0 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for DiscountLadder in RPM application.
RPM's Table Name RPM's Column Name Integration API(RIB or/and RSB or/and RSL) RPM's Column Length Is Column Required in RPM's API? RPM's API Description
chg_type number2 0 1 Change Type RPM_PROMO_DISC_LDR_PAYLOAD CHANGE_TYPE NUMBER 2 No Change Type
chg_amt number20_4 0 1 Change Amount RPM_PROMO_DISC_LDR_PAYLOAD CHANGE_AMOUNT NUMBER 20 No Change Amount
chg_currency varchar23 0 1 Currency Code RPM_PROMO_DISC_LDR_PAYLOAD CHANGE_CURRENCY VARCHAR2 3 No Change Currency
chg_percent number20_4 0 1 Change Percent RPM_PROMO_DISC_LDR_PAYLOAD CHANGE_PERCENT NUMBER 20 No Change Percent
chg_selling_uom varchar24 0 1 Change Selling UOM RPM_PROMO_DISC_LDR_PAYLOAD CHANGE_SELLING_UOM VARCHAR2 4 No Selling UOM
qual_type number2 0 1 Qualification Type RPM_PROMO_DISC_LDR_PAYLOAD QUAL_TYPE NUMBER 2 No Qualification Type - (0) all, (1) amount, (2) quantity
qual_value number20_4 0 1 Qualification Value RPM_PROMO_DISC_LDR_PAYLOAD QUAL_VALUE NUMBER 20 No Qualification Value
chg_duration number20_4 0 1 Change duration RPM_PROMO_DISC_LDR_PAYLOAD DURATION NUMBER 10 No Change Duration

XML-Schema Name:ItemList Version:15.0.0 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for ItemList in RPM application.
RPM's Table Name RPM's Column Name Integration API(RIB or/and RSB or/and RSL) RPM's Column Length Is Column Required in RPM's API? RPM's API Description
item_num varchar225 1 1 Item Number RPM_PROMO_ITEM_PAYLOAD ITEM VARCHAR2 25 Yes Item Number

XML-Schema Name:ItemLocSimpleRet Version:15.0.0 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for ItemLocSimpleRet in RPM application.
RPM's Table Name RPM's Column Name Integration API(RIB or/and RSB or/and RSL) RPM's Column Length Is Column Required in RPM's API? RPM's API Description
item_num varchar225 1 1 Transaction Item Identifier RPM_PROMO_ITEM_LOC_SR_PAYLOAD ITEM VARCHAR2 25 No Item Number
location number10 1 1 Store ID RPM_PROMO_ITEM_LOC_SR_PAYLOAD LOCATION NUMBER 10 No Location
selling_retail number20_4 0 1 Selling retail of the item RPM_PROMO_ITEM_LOC_SR_PAYLOAD selling_retail NUMBER 20 No Selling Retail
selling_uom varchar24 0 1 Selling UOM of the item RPM_PROMO_ITEM_LOC_SR_PAYLOAD selling_uom VARCHAR2 4 No Selling UOM
effective_date xs:dateTime 0 1 Specifies when the given selling retail is to take effect for the given item and location. RPM_PROMO_ITEM_LOC_SR_PAYLOAD EFFECTIVE_DATE DATE Fill column length. Yes Specifies when the given selling retail is to take effect for the given item and location.
selling_currency varchar23 1 1 Contains the currency code that should match the store's currency code. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.

XML-Schema Name:CreditDetail Version:15.0.0 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for CreditDetail in RPM application.
RPM's Table Name RPM's Column Name Integration API(RIB or/and RSB or/and RSL) RPM's Column Length Is Column Required in RPM's API? RPM's API Description
credit_detail_id number10 1 1 N/A Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
credit_type varchar240 1 1 Credit Card Type RPM_PROMO_FIN_DTL_PAYLOAD CARD_TYPE VARCHAR2 25 No Credit Card Type
bin_number_from number10 1 1 BIN Number From Value RPM_PROMO_FIN_DTL_PAYLOAD BIN_FROM_VALUE NUMBER 16 No Bin From Value.
bin_number_to number10 1 1 BIN Number To Value RPM_PROMO_FIN_DTL_PAYLOAD BIN_TO_VALUE NUMBER 16 No Bin To Value
commision_rate number10 1 1 Commission Rate RPM_PROMO_FIN_DTL_PAYLOAD COMMISSION_RATE NUMBER 20 No Commission Rate
comments varchar2160 1 1 Comments RPM_PROMO_FIN_DTL_PAYLOAD COMMENTS VARCHAR2 1000 No Comments

Retail Integration Mappings Report Release:15.0.0
Retail Integration Mappings Report Release:15.0.0 (Retail Price Management)
Application Retail Price Management
Target Name Space http://www.oracle.com/retail/integration/base/bo/StoreDesc/v1
Version 1.0
Description This is root element of this document which contains name space definitions for the document elements.
XSD Structure

XML-Schema Name:StoreDesc Version:15.0.0 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for StoreDesc in RPM application.
RPM's Table Name RPM's Column Name Integration API(RIB or/and RSB or/and RSL) RPM's Column Length Is Column Required in RPM's API? RPM's API Description
store number10 1 1 Contains the number to uniquely identify the store. rpm_zone_location location null null Yes *
store_type varchar21 1 1 This will indicate whether a particular store is a franchise or company store. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
store_name varchar2150 1 1 Contains the name of the store. * * varchar2 150 * *
store_name10 varchar210 0 1 Contains a ten character abbreviation of the store name. * * varchar2 10 * *
store_name3 varchar23 0 1 Contains a three character abbreviation of the store name. * * varchar2 3 * *
store_add1 varchar2240 0 1 Not used by RMS. * * varchar2 240 * *
store_add2 varchar2240 0 1 Not used by RMS. * * varchar2 240 * *
store_city varchar2120 0 1 Not used by RMS. * * varchar2 120 * *
county varchar2250 0 1 Not used by RMS. * * varchar2 250 * *
state varchar23 0 1 Not used by RMS. * * varchar2 3 * *
country_id varchar23 0 1 Not used by RMS. * * varchar2 3 * *
store_pcode varchar230 0 1 Not used by RMS. * * varchar2 30 * *
store_class varchar21 0 1 Contains the code letter indicating the class of which the store is a member. Valid values are A through E. * * varchar2 1 * *
store_mgr_name varchar2120 0 1 Contains the name of the store manager. * * varchar2 120 * *
store_open_date xs:dateTime 0 1 Contains the date on which the store opened. * * RIBDate * * *
store_close_date xs:dateTime 0 1 Contains the date on which the store closed. * * RIBDate * * *
acquired_date xs:dateTime 0 1 Contains the date on which the store was acquired. * * RIBDate * * *
remodel_date xs:dateTime 0 1 Contains the date on which the store was last remodeled. * * RIBDate * * *
fax_number varchar220 0 1 Contains the fax number for the store. * * varchar2 20 * *
phone_number varchar220 0 1 Contains the phone number for the store. * * varchar2 20 * *
email varchar2100 0 1 Contains the email address for the location. * * varchar2 100 * *
total_square_ft number8 0 1 Contains the total square footage of the store. * * number 8 * *
selling_square_ft number8 0 1 Contains the total square footage of the store's selling area. * * number 8 * *
linear_distance number8 0 1 Contains the total space of the location that can be used for merchandise. * * number 8 * *
stockholding_ind varchar21 0 1 This column indicates whether the store can hold stock. In a non-multichannel environment this will always be * * varchar2 1 * *
channel_id number4 0 1 In a multichannel environment this will contain the channel with which the store is associated. Valid values can be found on the channels table. * * number 4 * *
store_format number4 0 1 Contains the number indicating the format of the store. Valid values are found on the store format table. * * number 4 * *
mall_name varchar2120 0 1 Contains the name of the mall in which the store is located. * * varchar2 120 * *
district number10 0 1 Contains the number of the district in which the store is a member. * * number 10 * *
district_name varchar2120 0 1 Contains the name of the district. * * varchar2 120 * *
promo_zone number4 0 1 Not used by RMS. * * number 4 * *
promo_desc varchar220 0 1 Not used by RMS. * * varchar2 20 * *
transfer_zone number4 0 1 Contains the transfer zone in which the store is located. Valid values are located on the tsfzone table. * * number 4 * *
description varchar21000 0 1 Contains the name of the transfer zone. * * varchar2 1000 * *
default_wh varchar210 0 1 Contains the number of the warehouse that may be used as the default for creating cross-dock masks. This determines which stores are associated with or sourced from a warehouse. Will hold only virtual warehouses in a multi-channel environment. * * varchar2 10 * *
stop_order_days number3 0 1 Contains the number of days before a store closing that the store will stop accepting orders. This column will be used when the store_close_date is defined. * * number 3 * *
start_order_days number3 0 1 Contains the number of days before the store_open_date that the store will begin accepting orders. * * number 3 * *
currency_code varchar23 0 1 This field contains the currency code under which the store operates. * * varchar2 3 * *
lang number6 0 1 This column identifies the language to be used for the store. * * number 6 * *
integrated_pos_ind varchar21 0 1 Indicates whether the POS system at the store is integrated. * * varchar2 1 * *
orig_currency_code varchar23 0 1 holds the original currency of a store after it's adopted the Euro as its main operating currency * * varchar2 3 * *
duns_number varchar29 0 1 This type can hold a number of digits count umber. * * varchar2 9 * *
duns_loc varchar24 0 1 This field contains the Dun and Bradstreet number to identify the location. * * varchar2 4 * *
AddrDesc:AddrDesc * 0 unbounded It's a referenced element. For detailed description, please refer referenced element doc. NA NA NA NA NA NA
pricing_loc number10 0 1 If this field is null, the new store will not be added to RPM_ZONE_LOCATION table. * * null null Yes If this field is null, the new store will not be added to RPM_ZONE_LOCATION table.
pricing_loc_curr varchar23 0 1 This is the currency code of the pricing_loc store. * * varchar2 3 * *
org_unit_id number15 0 1 Column will contain the organizational unit ID value. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
timezone_name varchar264 0 1 Indicates the time zone of the store. For example, 'America/New_York'. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.

XML-Schema Name:AddrDesc Version:15.0.0 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for AddrDesc in RPM application.
RPM's Table Name RPM's Column Name Integration API(RIB or/and RSB or/and RSL) RPM's Column Length Is Column Required in RPM's API? RPM's API Description
city_id varchar210 0 1 Indicates the City Id or Code. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
state_name varchar2120 0 1 Indicates the State name. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
country_name varchar2120 0 1 Indicates the Country Name. For e.g Brazil,United States Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
addr varchar232 1 1 This field holds the unique address ID from the source system. For addresses that are interfaced into RMS, it will hold the external system's address ID. For addresses published out of RMS, it will hold RMS's address ID. * * number 6 * *
addr_type varchar22 1 1 Indicates the type for the address. Valid values (e.g. 01-business, 02-postal) are in the add_type table. * * varchar2 2 * *
primary_addr_type_ind varchar21 0 1 Description is not available. * * varchar2 1 * *
primary_addr_ind varchar21 1 1 Indicates whether this address is the primary address for this address type * * varchar2 1 * *
add_1 varchar2240 1 1 Contains the first line of the address * * varchar2 240 * *
add_2 varchar2240 0 1 Contains the second line of the address. * * varchar2 240 * *
add_3 varchar2240 0 1 Contains the thirdline of the address. * * varchar2 240 * *
city varchar2120 1 1 Contains the name of the city that is associated with the address. * * varchar2 120 * *
state varchar23 0 1 Contains the postal abbreviation for the state in which the warehouse is located. * * varchar2 3 * *
country_id varchar23 1 1 Contains the country where the address exists. * * varchar2 3 * *
post varchar230 0 1 Contains the zip code for the address. * * varchar2 30 * *
contact_name varchar2120 0 1 Contains the name of the contact for the supplier at this address. * * varchar2 120 * *
contact_phone varchar220 0 1 Contains the phone number of the contact person at this address. * * varchar2 20 * *
contact_telex varchar220 0 1 Contains the telex number of the partner or suppliers representative contact. * * varchar2 20 * *
contact_fax varchar220 0 1 Contains the fax number of the contact person at this address. * * varchar2 20 * *
contact_email varchar2100 0 1 Contains the email address of the partner or suppliers representative contact. * * varchar2 100 * *
oracle_vendor_site_id number15 0 1 The unique identifier of this address in the Oracle Financials systems, if used. * * number 15 * *
county varchar2250 0 1 Contains the county name for the location. * * varchar2 250 * *
jurisdiction_code varchar210 0 1 ID associated to the tax jurisdiction of the country-state relationship. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.

Retail Integration Mappings Report Release:15.0.0
Retail Integration Mappings Report Release:15.0.0 (Retail Price Management)
Application Retail Price Management
Target Name Space http://www.oracle.com/retail/integration/base/bo/ClrPrcChgDesc/v1
Version 1.0
Description This is root element of this document which contains name space definitions for the document elements.
XSD Structure

XML-Schema Name:ClrPrcChgDesc Version:15.0.0 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for ClrPrcChgDesc in RPM application.
RPM's Table Name RPM's Column Name Integration API(RIB or/and RSB or/and RSL) RPM's Column Length Is Column Required in RPM's API? RPM's API Description
location number10 1 1 Unique identifier that indicates a Location (Store or Warehouse) rpm_clearance_payload location number 10 Yes Unique identifier that indicates a Location (Store or Warehouse).
loc_type varchar21 1 1 Identifier that indicates whether a location is a Store ('S') or a Warehouse ('W') rpm_clearance_payload location_type varchar2 30 Yes Identifier that indicates whether a location is a Store (S) or a Warehouse (W).
ClrPrcChgDtl * 1 unbounded Description is not available.

XML-Schema Name:ClrPrcChgDtl Version:15.0.0 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for ClrPrcChgDtl in RPM application.
RPM's Table Name RPM's Column Name Integration API(RIB or/and RSB or/and RSL) RPM's Column Length Is Column Required in RPM's API? RPM's API Description
clearance_id Number15 1 1 Clearance ID rpm_clearance_payload clearance_id number 15 Yes Clearance Id
item varchar225 1 1 Unique identifier of the item in the clearance rpm_clearance_payload item varchar2 25 Yes Item Number
effective_date xs:dateTime 1 1 The date the clearance becomes active rpm_clearance_payload effective_date date Fill column length. Yes Effective date of the clearance
selling_unit_retail number20_4 1 1 Clearance selling unit retail rpm_clearance_payload selling_retail number 20 Yes Clearance selling retail
selling_uom varchar24 1 1 Clearance selling UOM rpm_clearance_payload selling_retail_uom varchar2 25 Yes Clearance selling UOM
selling_currency Varchar23 1 1 Clearance selling currency rpm_clearance_payload selling_retail_currency varchar2 25 Yes Clearance selling currency
reset_clearance_id Number15 0 1 Clearance reset ID rpm_clearance_payload reset_clearance_id number 15 No Clearance reset id

Retail Integration Mappings Report Release:15.0.0
Retail Integration Mappings Report Release:15.0.0 (Retail Price Management)
Application Retail Price Management
Target Name Space http://www.oracle.com/retail/integration/base/bo/RegPrcChgRef/v1
Version 1.0
Description This is root element of this document which contains name space definitions for the document elements.
XSD Structure

XML-Schema Name:RegPrcChgRef Version:15.0.0 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for RegPrcChgRef in RPM application.
RPM's Table Name RPM's Column Name Integration API(RIB or/and RSB or/and RSL) RPM's Column Length Is Column Required in RPM's API? RPM's API Description
location number10 1 1 Unique identifier of the location rpm_price_chg_payload location NUMBER 10 * Unique identifier that indicates a Location (Store or Warehouse)
loc_type varchar21 1 1 Identifier that indicates whether a location is a Store ('S') or a Warehouse ('W') rpm_price_chg_payload location_type NUMBER 30 * Identifier that indicates whether a location is a Store ('S') or a Warehouse ('W')
RegPrcChgDtlRef * 1 unbounded NA

XML-Schema Name:RegPrcChgDtlRef Version:15.0.0 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for RegPrcChgDtlRef in RPM application.
RPM's Table Name RPM's Column Name Integration API(RIB or/and RSB or/and RSL) RPM's Column Length Is Column Required in RPM's API? RPM's API Description
price_change_id number15 1 1 Unique identifier of the price change rpm_price_chg_payload price_change_id NUMBER 15 * Price Change ID
item varchar225 1 1 Unique identifier of the item rpm_price_chg_payload item VARCHAR2 25 * Item number

Retail Integration Mappings Report Release:15.0.0
Retail Integration Mappings Report Release:15.0.0 (Retail Price Management)
Application Retail Price Management
Target Name Space http://www.oracle.com/retail/integration/base/bo/Nothing/v1
Version 1.0
Description
XSD Structure

XML-Schema Name:Nothing Version:15.0.0 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for Nothing in RPM application.
RPM's Table Name RPM's Column Name Integration API(RIB or/and RSB or/and RSL) RPM's Column Length Is Column Required in RPM's API? RPM's API Description
description varchar2500 0 1 N/A N/A N/A N/A N/A N/A

Retail Integration Mappings Report Release:15.0.0
Retail Integration Mappings Report Release:15.0.0 (Retail Price Management)
Application Retail Price Management
Target Name Space http://www.oracle.com/retail/integration/base/bo/PrcInqDesc/v1
Version 1.0
Description This is root element of this document which contains name space definitions for the document elements.
XSD Structure

XML-Schema Name:PrcInqDesc Version:15.0.0 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for PrcInqDesc in RPM application.
RPM's Table Name RPM's Column Name Integration API(RIB or/and RSB or/and RSL) RPM's Column Length Is Column Required in RPM's API? RPM's API Description
PrcInqDtl * 1 unbounded Description is not available.

XML-Schema Name:PrcInqDtl Version:15.0.0 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for PrcInqDtl in RPM application.
RPM's Table Name RPM's Column Name Integration API(RIB or/and RSB or/and RSL) RPM's Column Length Is Column Required in RPM's API? RPM's API Description
status_code varchar210 1 1 Status Code of the Price Inquiry (Success or Business Error) N/A N/A N/A N/A Yes Status Code of the Price Inquiry - success or error
item varchar225 1 1 Unique Identification of the Item RPM_FUTURE_RETAIL ITEM VARCHAR2 25 Yes Item Number
location number10 1 1 Location RPM_FUTURE_RETAIL LOCATION NUMBER 10 Yes Location Number
location_type varchar21 1 1 Location Type ('S'tore or 'W'arehouse) RPM_FUTURE_RETAIL ZONE_NODE_TYPE NUMBER 6 Yes Location Type
pricing_date xs:dateTime 1 1 The date the price is effective RPM_FUTURE_RETAIL ACTION_DATE DATE Fill column length. Yes The date the selling unit retail is effective
selling_unit_retail number20_4 1 1 Selling Unit Retail RPM_FUTURE_RETAIL SELLING_RETAIL NUMBER 20,4 Yes Selling Unit Retail
selling_uom varchar24 1 1 Selling Unit of Measure RPM_FUTURE_RETAIL SELLING_UOM VARCHAR2 4 Yes Selling Unit of Measure
multi_units number12_4 0 1 Multi Units RPM_FUTURE_RETAIL MULTI_UNITS NUMBER 12,4 No Multi Units
multi_unit_retail number20_4 0 1 Multi Unit Retail RPM_FUTURE_RETAIL MULTI_UNIT_RETAIL NUMBER 20,4 No Multi Unit Retail
multi_selling_uom varchar24 0 1 Multi Selling UOM RPM_FUTURE_RETAIL MULTI_SELLING_UOM VARCHAR2 4 No Multi Selling Unit of Measure
currency_code varchar23 1 1 Currency Code RPM_FUTURE_RETAIL SELLING_RETAIL_CURRENCY VARCHAR2 3 Yes Selling Retail Currency Code
price_type VARCHAR26 1 1 Selling Unit Retail Type (Regular, Clearance or Promotion depending if the item is on clearance, promotion or not) N/A N/A N/A N/A Yes Selling Unit Retail Type (Regular, Clearance or Promotion)

Retail Integration Mappings Report Release:15.0.0
Retail Integration Mappings Report Release:15.0.0 (Retail Price Management)
Application Retail Price Management
Target Name Space http://www.oracle.com/retail/integration/base/bo/PrmCnlItemLocDesc/v1
Version 1.0
Description This is root element of this document which contains name space definitions for the document elements.
XSD Structure

XML-Schema Name:PrmCnlItemLocDesc Version:15.0.0 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for PrmCnlItemLocDesc in RPM application.
RPM's Table Name RPM's Column Name Integration API(RIB or/and RSB or/and RSL) RPM's Column Length Is Column Required in RPM's API? RPM's API Description
promo_id number10 1 1 Promotion ID rpm_promo_dtl_cil_payload promo_id number 10 Yes Promotion ID
promo_comp_id number10 1 1 Promotion Component ID rpm_promo_dtl_cil_payload promo_comp_id number 10 Yes Promotion Component ID
promo_dtl_id number10 1 1 Promotion Component Detail ID rpm_promo_dtl_cil_payload promo_dtl_id number 10 Yes Promotion Component Detail ID
promo_comp_type number2 1 1 Promotion Component Type rpm_promo_dtl_cil_payload promo_comp_type number 2 Yes Promotion Component Type
CancelItemLoc * 1 unbounded Description is not available.
cancellation_date xs:dateTime 1 1 Specifies the date and time when the cancellation takes effect. rpm_promo_dtl_cil_payload cancellation_date date N/A Yes effective date for the cancellation

XML-Schema Name:CancelItemLoc Version:15.0.0 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for CancelItemLoc in RPM application.
RPM's Table Name RPM's Column Name Integration API(RIB or/and RSB or/and RSL) RPM's Column Length Is Column Required in RPM's API? RPM's API Description
item_num varchar225 1 1 The item of the item-location combination being cancelled rpm_promo_dtl_cil_item_payload item varchar2 25 Yes item number
location number10 1 1 The location of the item-location combination being cancelled. rpm_promo_dtl_cil_loc_payload location number 10 Yes location number
loc_type varchar22 1 1 Location Type rpm_promo_dtl_cil_loc_payload location_type varchar2 30 Yes location type

Retail Integration Mappings Report Release:15.0.0
Retail Integration Mappings Report Release:15.0.0 (Retail Price Management)
Application Retail Price Management
Target Name Space http://www.oracle.com/retail/integration/base/bo/ReferenceId/v1
Version 1.0
Description
XSD Structure

XML-Schema Name:ReferenceId Version:15.0.0 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for ReferenceId in RPM application.
RPM's Table Name RPM's Column Name Integration API(RIB or/and RSB or/and RSL) RPM's Column Length Is Column Required in RPM's API? RPM's API Description
id varchar2255 0 1 N/A N/A N/A N/A N/A N/A
Pair * 0 unbounded

XML-Schema Name:Pair Version:15.0.0 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for Pair in RPM application.
RPM's Table Name RPM's Column Name Integration API(RIB or/and RSB or/and RSL) RPM's Column Length Is Column Required in RPM's API? RPM's API Description
name varchar2255 1 1 N/A N/A N/A N/A N/A N/A
value varchar2255 1 1 N/A N/A N/A N/A N/A N/A

Retail Integration Mappings Report Release:15.0.0
Retail Integration Mappings Report Release:15.0.0 (Retail Price Management)
Application Retail Price Management
Target Name Space http://www.oracle.com/retail/integration/base/bo/PrmPrcChgRef/v1
Version 1.0
Description This is root element of this document which contains name space definitions for the document elements.
XSD Structure

XML-Schema Name:PrmPrcChgRef Version:15.0.0 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for PrmPrcChgRef in RPM application.
RPM's Table Name RPM's Column Name Integration API(RIB or/and RSB or/and RSL) RPM's Column Length Is Column Required in RPM's API? RPM's API Description
location number10 1 1 Description is not available. rpm_future_retail location NUMBER 10 * Unique identifier that indicates a Location (Store or Warehouse)
loc_type varchar21 1 1 Identifier that indicates whether a location is a Store ('S') or a Warehouse ('W') rpm_future_retail zone_node_type NUMBER 6 * Identifier that indicates whether a location is a Store ('S') or a Warehouse ('W')
PrmPrcChgDtlRef * 1 unbounded Description is not available.

XML-Schema Name:PrmPrcChgDtlRef Version:15.0.0 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for PrmPrcChgDtlRef in RPM application.
RPM's Table Name RPM's Column Name Integration API(RIB or/and RSB or/and RSL) RPM's Column Length Is Column Required in RPM's API? RPM's API Description
promo_comp_detail_id number10 1 1 Description is not available. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
PrmPrcChgSmpDtlRe * 0 unbounded Description is not available.
PrmPrcChgThrDtlRe * 0 unbounded Description is not available.

XML-Schema Name:PrmPrcChgSmpDtlRe Version:15.0.0 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for PrmPrcChgSmpDtlRe in RPM application.
RPM's Table Name RPM's Column Name Integration API(RIB or/and RSB or/and RSL) RPM's Column Length Is Column Required in RPM's API? RPM's API Description
item varchar225 1 1 NA Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.

XML-Schema Name:PrmPrcChgThrDtlRe Version:15.0.0 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for PrmPrcChgThrDtlRe in RPM application.
RPM's Table Name RPM's Column Name Integration API(RIB or/and RSB or/and RSL) RPM's Column Length Is Column Required in RPM's API? RPM's API Description
item varchar225 1 1 NA Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.

Retail Integration Mappings Report Release:15.0.0
Retail Integration Mappings Report Release:15.0.0 (Retail Price Management)
Application Retail Price Management
Target Name Space http://www.oracle.com/retail/integration/base/bo/AddrDesc/v1
Version 1.0
Description This is root element of this document which contains name space definitions for the document elements.
XSD Structure

XML-Schema Name:AddrDesc Version:15.0.0 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for AddrDesc in RPM application.
RPM's Table Name RPM's Column Name Integration API(RIB or/and RSB or/and RSL) RPM's Column Length Is Column Required in RPM's API? RPM's API Description
city_id varchar210 0 1 Indicates the City Id or Code. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
state_name varchar2120 0 1 Indicates the State name. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
country_name varchar2120 0 1 Indicates the Country Name. For e.g Brazil,United States Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
addr varchar232 1 1 This field holds the unique address ID from the source system. For addresses that are interfaced into RMS, it will hold the external system's address ID. For addresses published out of RMS, it will hold RMS's address ID. * * number 6 * *
addr_type varchar22 1 1 Indicates the type for the address. Valid values (e.g. 01-business, 02-postal) are in the add_type table. * * varchar2 2 * *
primary_addr_type_ind varchar21 0 1 Description is not available. * * varchar2 1 * *
primary_addr_ind varchar21 1 1 Indicates whether this address is the primary address for this address type * * varchar2 1 * *
add_1 varchar2240 1 1 Contains the first line of the address * * varchar2 240 * *
add_2 varchar2240 0 1 Contains the second line of the address. * * varchar2 240 * *
add_3 varchar2240 0 1 Contains the thirdline of the address. * * varchar2 240 * *
city varchar2120 1 1 Contains the name of the city that is associated with the address. * * varchar2 120 * *
state varchar23 0 1 Contains the postal abbreviation for the state in which the warehouse is located. * * varchar2 3 * *
country_id varchar23 1 1 Contains the country where the address exists. * * varchar2 3 * *
post varchar230 0 1 Contains the zip code for the address. * * varchar2 30 * *
contact_name varchar2120 0 1 Contains the name of the contact for the supplier at this address. * * varchar2 120 * *
contact_phone varchar220 0 1 Contains the phone number of the contact person at this address. * * varchar2 20 * *
contact_telex varchar220 0 1 Contains the telex number of the partner or suppliers representative contact. * * varchar2 20 * *
contact_fax varchar220 0 1 Contains the fax number of the contact person at this address. * * varchar2 20 * *
contact_email varchar2100 0 1 Contains the email address of the partner or suppliers representative contact. * * varchar2 100 * *
oracle_vendor_site_id number15 0 1 The unique identifier of this address in the Oracle Financials systems, if used. * * number 15 * *
county varchar2250 0 1 Contains the county name for the location. * * varchar2 250 * *
jurisdiction_code varchar210 0 1 ID associated to the tax jurisdiction of the country-state relationship. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.

Retail Integration Mappings Report Release:15.0.0
Retail Integration Mappings Report Release:15.0.0 (Retail Price Management)
Application Retail Price Management
Target Name Space http://www.oracle.com/retail/integration/base/bo/PrcChgDesc/v1
Version 1.0
Description This is root element of this document which contains name space definitions for the document elements.
XSD Structure

XML-Schema Name:PrcChgDesc Version:15.0.0 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for PrcChgDesc in RPM application.
RPM's Table Name RPM's Column Name Integration API(RIB or/and RSB or/and RSL) RPM's Column Length Is Column Required in RPM's API? RPM's API Description
PrcChg * 1 unbounded Description is not available.

XML-Schema Name:PrcChg Version:15.0.0 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for PrcChg in RPM application.
RPM's Table Name RPM's Column Name Integration API(RIB or/and RSB or/and RSL) RPM's Column Length Is Column Required in RPM's API? RPM's API Description
location number10 1 1 Location Number RPM_PRICE_CHANGE LOCATION NUMBER 10 Yes Location ID
loc_type varchar21 1 1 Location Type RPM_PRICE_CHANGE ZONE_NODE_TYPE NUMBER 6 Yes Location Type
item varchar225 1 1 Unique Identification of the Item RPM_PRICE_CHANGE ITEM VARCHAR2 25 Yes Item ID
change_type varchar26 1 1 Price Event Type - Price Change, Clearance or Promotion N/A N/A VARCHAR2 N/A Yes Valid values are PE (Regular), CL (Clearance) and PR (Promotion for Simple Promo only)
PrcChgDtl * 0 unbounded Description is not available.
PrcChgRef * 0 unbounded Description is not available.

XML-Schema Name:PrcChgDtl Version:15.0.0 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for PrcChgDtl in RPM application.
RPM's Table Name RPM's Column Name Integration API(RIB or/and RSB or/and RSL) RPM's Column Length Is Column Required in RPM's API? RPM's API Description
unit_retail number20_4 0 1 Selling Unit Retail RPM_PRICE_CHANGE CHANGE_AMOUNT NUMBER 20,4 Yes Fixed Amount Value - New Selling Unit Retail
new_uom varchar24 0 1 Unit of Measure RPM_PRICE_CHANGE CHANGE_SELLING_UOM VARCHAR2 4 Yes Change Selling Unit Of Measure
effective_date xs:dateTime 0 1 The date the price event will start RPM_PRICE_CHANGE EFFECTIVE_DATE DATE Fill column length. Yes The date the price event will take effect
end_date xs:dateTime 0 1 The date the promotion will end or the reset date for clearance RPM_PROMO_DTL END_DATE DATE Fill column length. No The date the promotion will end

XML-Schema Name:PrcChgRef Version:15.0.0 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for PrcChgRef in RPM application.
RPM's Table Name RPM's Column Name Integration API(RIB or/and RSB or/and RSL) RPM's Column Length Is Column Required in RPM's API? RPM's API Description
change_id number15 1 1 Promotion Component Detail ID or Price Change ID or Clearance ID if the price event type is a promotion or price change or clearance, respectively RPM_PRICE_CHANGE PRICE_CHANGE_ID NUMBER 15 Yes Price Change ID
promo_comp_id number10 0 1 Promotion Component ID if the price event type is a promotion RPM_PROMO_COMP PROMO_COMP_ID NUMBER 10 No Promotion Component ID
promo_id number10 0 1 Promotion ID if the price event type is a promotion RPM_PROMO PROMO_ID NUMBER 10 No Promotion ID if the price event type is a promotion

Retail Integration Mappings Report Release:15.0.0
Retail Integration Mappings Report Release:15.0.0 (Retail Price Management)
Application Retail Price Management
Target Name Space http://www.oracle.com/retail/integration/base/bo/RegPrcChgDesc/v1
Version 1.0
Description This is root element of this document which contains name space definitions for the document elements.
XSD Structure

XML-Schema Name:RegPrcChgDesc Version:15.0.0 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for RegPrcChgDesc in RPM application.
RPM's Table Name RPM's Column Name Integration API(RIB or/and RSB or/and RSL) RPM's Column Length Is Column Required in RPM's API? RPM's API Description
location number10 1 1 Unique identifier that indicates a Location (Store or Warehouse) rpm_price_chg_payload location NUMBER 10 Yes Unique identifier that indicates a Location (Store or Warehouse)
loc_type varchar21 1 1 Indicates the type of location which has requested tickets. Valid values for this field are: 'W' (for warehouse) and 'S' (for store). rpm_price_chg_payload location_type VARCHAR2 30 Yes Identifier that indicates whether a location is a Store ('S') or a Warehouse ('W')
RegPrcChgDtl * 1 unbounded Description is not available.

XML-Schema Name:RegPrcChgDtl Version:15.0.0 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for RegPrcChgDtl in RPM application.
RPM's Table Name RPM's Column Name Integration API(RIB or/and RSB or/and RSL) RPM's Column Length Is Column Required in RPM's API? RPM's API Description
price_change_id number15 1 1 Contains the ID of the price change that initiated the ticket request. rpm_price_chg_payload price_change_id NUMBER 15 Yes Price Change Id
item varchar225 1 1 Alphanumeric value that identifies the item for which tickets have been requested. rpm_price_chg_payload item VARCHAR2 25 Yes Item number
effective_date xs:dateTime 1 1 Price Change Effective Date rpm_price_chg_payload effective_date DATE null Yes Price Change Effective Date
selling_retail_changed_ind number1 1 1 Indicates whether the selling retail price has been changed. Valid values are '0' - no change or '1' - retail is changed. rpm_price_chg_payload selling_unit_change_ind NUMBER 6 Yes Indicate whether the regular selling retail is change by the Price Change
selling_unit_retail number20_4 1 1 This field contains the unit retail for the item at the indicated location. rpm_price_chg_payload selling_retail NUMBER 20,4 Yes Regular selling retail
selling_uom varchar24 1 1 Holds the selling unit of measure for an item's single-unit retail. rpm_price_chg_payload selling_retail_uom VARCHAR2 25 Yes Regular Selling UOM
selling_currency varchar23 1 1 Contains the currency code that should match the store's or warehouse's currency code. rpm_price_chg_payload selling_retail currency VARCHAR2 25 Yes Regular Selling Retail Currency
multi_unit_changed_ind number1 1 1 Indicates whether the retail for multi units has been changed. Valid values are '0' - no change or '1' - retail is changed. rpm_price_chg_payload multi_unit_changed_ind NUMBER 6 Yes Indicate whether the Multi Unit Selling Retail is changed by the Price Change
multi_units number12_4 0 1 The number that indicate how many item is priced in the multi unit selling retail rpm_price_chg_payload multi_units NUMBER 18, 4 No The number that indicate how many item is priced in the multi unit selling retail
multi_unit_retail number20_4 0 1 This field contains the multi-unit retail for the item at the indicated location. rpm_price_chg_payload multi_units_retail NUMBER 20,4 No Multi Unit Selling Retail
multi_unit_retail_currency varchar23 0 1 Contains the currency code that should match the store's or warehouse's currency code. rpm_price_chg_payload multi_units_currency VARCHAR2 25 No Multi Unit Retail Currency
multi_selling_uom varchar24 0 1 Multi Unit Selling UOM rpm_price_chg_payload multi_units_uom VARCHAR2 25 No Multi Unit Selling UOM

Retail Integration Mappings Report Release:15.0.0
Retail Integration Mappings Report Release:15.0.0 (Retail Price Management)
Application Retail Price Management
Target Name Space http://www.oracle.com/retail/integration/base/bo/PromotionRef/v1
Version 1.0
Description This is root element of this document which contains name space definitions for the document elements.
XSD Structure

XML-Schema Name:PromotionRef Version:15.0.0 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for PromotionRef in RPM application.
RPM's Table Name RPM's Column Name Integration API(RIB or/and RSB or/and RSL) RPM's Column Length Is Column Required in RPM's API? RPM's API Description
reward_qty number10 1 1 Description is not available. * * * * * *
promo_id number10 1 1 Promotion ID RPM_PROMO_DTL_PAYLOAD PROMO_ID NUMBER 10 Yes Promotion Id
promo_comp_id number10 1 1 Promotion Component ID RPM_PROMO_DTL_PAYLOAD PROMO_COMP_ID NUMBER 10 Yes Promotion Component Id
promo_dtl_id number10 1 1 Promotion Component Detail ID RPM_PROMO_DTL_PAYLOAD PROMO_DTL_ID NUMBER 10 Yes Promotion Detail Id
LocationListRef * 1 unbounded Description is not available.
ListGroupRef * 1 unbounded Description is not available.

XML-Schema Name:LocationListRef Version:15.0.0 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for LocationListRef in RPM application.
RPM's Table Name RPM's Column Name Integration API(RIB or/and RSB or/and RSL) RPM's Column Length Is Column Required in RPM's API? RPM's API Description
location number10 1 1 Store ID RPM_PROMO_LOCATION_PAYLOAD LOCATION NUMBER 10 Yes Location Id

XML-Schema Name:ListGroupRef Version:15.0.0 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for ListGroupRef in RPM application.
RPM's Table Name RPM's Column Name Integration API(RIB or/and RSB or/and RSL) RPM's Column Length Is Column Required in RPM's API? RPM's API Description
listgroup_id number10 1 1 Promotion Detail List Group ID RPM_PROMO_DTL_LIST_GRP_PAYLOAD PROMO_DTL_LIST_GRP_ID NUMBER 10 Yes Promotion Detail List Group Id
ListDtlRef * 1 unbounded Description is not available.

XML-Schema Name:ListDtlRef Version:15.0.0 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for ListDtlRef in RPM application.
RPM's Table Name RPM's Column Name Integration API(RIB or/and RSB or/and RSL) RPM's Column Length Is Column Required in RPM's API? RPM's API Description
listdtl_id number10 1 1 Promotion Detail List ID RPM_PROMO_DTL_LIST_PAYLOAD PROMO_DTL_LIST_ID NUMBER 10 Yes Promotion Detail List Id
ItemListRef * 1 unbounded Description is not available.

XML-Schema Name:ItemListRef Version:15.0.0 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for ItemListRef in RPM application.
RPM's Table Name RPM's Column Name Integration API(RIB or/and RSB or/and RSL) RPM's Column Length Is Column Required in RPM's API? RPM's API Description
item_num varchar225 1 1 Item ID RPM_PROMO_ITEM_PAYLOAD ITEM VARCHAR2 25 * Item Number

Retail Integration Mappings Report Release:15.0.0
Retail Integration Mappings Report Release:15.0.0 (Retail Price Management)
Application Retail Price Management
Target Name Space http://www.oracle.com/retail/integration/base/bo/PrcInqCriVo/v1
Version 1.0
Description This is root element of this document which contains name space definitions for the document elements.
XSD Structure

XML-Schema Name:PrcInqCriVo Version:15.0.0 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for PrcInqCriVo in RPM application.
RPM's Table Name RPM's Column Name Integration API(RIB or/and RSB or/and RSL) RPM's Column Length Is Column Required in RPM's API? RPM's API Description
PrcInqCriDtl * 1 unbounded Description is not available.

XML-Schema Name:PrcInqCriDtl Version:15.0.0 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for PrcInqCriDtl in RPM application.
RPM's Table Name RPM's Column Name Integration API(RIB or/and RSB or/and RSL) RPM's Column Length Is Column Required in RPM's API? RPM's API Description
item varchar225 1 1 Unique Identification of the Item RPM_FUTURE_RETAIL ITEM VARCHAR2 25 Yes Item Number
location number10 1 1 Location Number RPM_FUTURE_RETAIL LOCATION NUMBER 10 Yes Location Number
location_type varchar21 1 1 Location Type ('S'tore or 'W'arehouse) RPM_FUTURE_RETAIL ZONE_NODE_TYPE NUMBER 6 Yes Location Type
pricing_date xs:dateTime 0 1 The date the price is effective RPM_FUTURE_RETAIL ACTION_DATE DATE Fill column length. Yes The date the price is effective

Retail Integration Mappings Report Release:15.0.0
Retail Integration Mappings Report Release:15.0.0 (Retail Price Management)
Application Retail Price Management
Target Name Space http://www.oracle.com/retail/integration/base/bo/ClrPrcChgRef/v1
Version 1.0
Description This is root element of this document which contains name space definitions for the document elements.
XSD Structure

XML-Schema Name:ClrPrcChgRef Version:15.0.0 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for ClrPrcChgRef in RPM application.
RPM's Table Name RPM's Column Name Integration API(RIB or/and RSB or/and RSL) RPM's Column Length Is Column Required in RPM's API? RPM's API Description
location number10 1 1 Unique identifier that indicates a Location (Store or Warehouse) rpm_clearance_payload location NUMBER 10 Yes Unique identifier that indicates a Location (Store or Warehouse).
loc_type varchar21 1 1 Identifier that indicates whether a location is a Store ('S') or a Warehouse ('W') rpm_clearance_payload location_type VARCHAR2 30 Yes Identifier that indicates whether a location is a Store (S) or a Warehouse (W).
ClrPrcChgDtlRef * 1 unbounded Description is not available.

XML-Schema Name:ClrPrcChgDtlRef Version:15.0.0 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for ClrPrcChgDtlRef in RPM application.
RPM's Table Name RPM's Column Name Integration API(RIB or/and RSB or/and RSL) RPM's Column Length Is Column Required in RPM's API? RPM's API Description
clearance_id number15 1 1 Unique identifier of the clearance rpm_clearance_payload clearance_id NUMBER 15 Yes Clearance Id
item varchar225 1 1 Unique identifier of the item rpm_clearance_payload item VARCHAR2 25 Yes Item Number