Retail Integration Mappings Report Release:14.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 ClrPrcChgDesc ClrPrcChgDtl

XML-Schema Name:ClrPrcChgDesc Version:14.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:14.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 Not Yet Available rpm_clearance_payload clearance_id number 15 Yes Clearance Id item varchar225 1 1 Not Yet Available rpm_clearance_payload item varchar2 25 Yes Item Number effective_date xs:dateTime 1 1 Not Yet Available rpm_clearance_payload effective_date date Yes Effective date of the clearance selling_unit_retail number20_4 1 1 Not Yet Available rpm_clearance_payload selling_retail number 20 Yes Clearance selling retail selling_uom varchar24 1 1 Not Yet Available rpm_clearance_payload selling_retail_uom varchar2 25 Yes Clearance selling UOM selling_currency Varchar23 1 1 NA rpm_clearance_payload selling_retail_currency varchar2 25 Yes Clearance selling currency reset_clearance_id Number15 0 1 NA rpm_clearance_payload reset_clearance_id number 15 No Clearance reset id

Retail Integration Mappings Report Release:14.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 Nothing

XML-Schema Name:Nothing Version:14.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:14.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 RegPrcChgRef RegPrcChgDtlRef

XML-Schema Name:RegPrcChgRef Version:14.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 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') RegPrcChgDtlRef * 1 unbounded NA

XML-Schema Name:RegPrcChgDtlRef Version:14.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 Description is not available. rpm_price_change price_change_id NUMBER 15 * Price Change ID item varchar225 1 1 Description is not available. rpm_future_retail item VARCHAR2 25 * Item number

Retail Integration Mappings Report Release:14.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 AddrDesc

XML-Schema Name:AddrDesc Version:14.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. NA NA NA NA NA NA state_name varchar2120 0 1 Indicates the State name. NA NA NA NA NA NA country_name varchar2120 0 1 Indicates the Country Name. For e.g Brazil,United States NA NA NA NA NA NA 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. NA NA NA NA NA NA

Retail Integration Mappings Report Release:14.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 PrmPrcChgRef PrmPrcChgDtlRef PrmPrcChgSmpDtlRe PrmPrcChgThrDtlRe

XML-Schema Name:PrmPrcChgRef Version:14.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. NA NA NA NA NA NA

XML-Schema Name:PrmPrcChgDtlRef Version:14.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. NA NA NA NA NA NA PrmPrcChgSmpDtlRe * 0 unbounded Description is not available. NA NA NA NA NA NA PrmPrcChgThrDtlRe * 0 unbounded Description is not available. NA NA NA NA NA NA

XML-Schema Name:PrmPrcChgSmpDtlRe Version:14.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 NA NA NA NA NA NA

XML-Schema Name:PrmPrcChgThrDtlRe Version:14.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 NA NA NA NA NA NA

Retail Integration Mappings Report Release:14.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 PrmPrcChgDesc PrmPrcChgDtl PrmPrcChgSmp PrmPrcChgThr PrmPrcChgThrDtl PrmPrcChgBuyGet PrmPrcChgGetItem PrmPrcChgBuyItem

XML-Schema Name:PrmPrcChgDesc Version:14.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_zone_location 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_promo_zone_location zone_node_type number 2 * 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:14.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 promo_id number 10 * Promotion Id promo_name varchar240 0 1 Promotion Name rpm_promo name varchar2 160 * Promotion Name promo_description varchar2160 0 1 Promotion Description rpm_promo description varchar2 640 * Promotion Description promo_comp_id number10 1 1 Promotion Component Id rpm_promo_comp promo_comp_id number 10 * Promotion Component Id promo_comp_desc varchar240 0 1 Promotion Component Description rpm_promo_comp name varchar2 160 * Promotion Component Description promo_comp_detail_id number10 1 1 Promotion Component Detail Id rpm_promo_dtl promo_dtl_id number 10 * 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_future_retail * null null * 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 start_date date * Start date of the promotion component detail end_date xs:dateTime 0 1 End date of the promotion component detail rpm_promo_dtl end_date date * 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:14.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:14.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:14.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:14.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:14.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:14.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:14.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 RegPrcChgDesc RegPrcChgDtl

XML-Schema Name:RegPrcChgDesc Version:14.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_future_retail 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_future_retail zone_node_type NUMBER 6 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:14.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_change 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_future_retail item VARCHAR2 25 Yes Item number effective_date xs:dateTime 1 1 Price Change Effective Date rpm_future_retail action_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_future_retail_gtt pc_selling_retail_ind NUMBER 1 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_future_retail 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_future_retail selling_uom VARCHAR2 2 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_future_retail selling_retail currency VARCHAR2 3 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_future_retail_gtt pc_multi_unit_ind NUMBER 1 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_future_retail multi_units NUMBER 12, 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_future_retail multi_unit_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_future_retail multi_unit_retail_currency VARCHAR2 3 No Multi Unit Retail Currency multi_selling_uom varchar24 0 1 Multi Unit Selling UOM rpm_future_retail multi_selling_uom VARCHAR2 4 No Multi Unit Selling UOM

Retail Integration Mappings Report Release:14.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 ReferenceId Pair

XML-Schema Name:ReferenceId Version:14.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:14.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:14.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 PromotionDesc LocationList ListGroup ListDtl DiscountLadder ItemList ItemLocSimpleRet CreditDetail

XML-Schema Name:PromotionDesc Version:14.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 * * * * * * promo_name varchar2160 0 1 Promotion Header Name * * * * * * promo_description varchar2640 0 1 Promotion Header Description * * * * * * promo_comp_id number10 1 1 Promotion Component Id * * * * * * promo_comp_desc varchar2160 0 1 Promotion Component Name * * * * * * promo_comp_type number2 1 1 Promotion Component Type * * * * * * promo_dtl_id number10 1 1 Promotion Component Detail Id * * * * * * apply_order number6 1 1 Application Order of the Promotion * * * * * * start_date xs:dateTime 1 1 Start Date of Promotion Component Detail * * * * * * end_date xs:dateTime 0 1 End Date of Promotion Component Detail * * * * * * apply_to_code number1 0 1 The apply_to value for the Promotion Component Detail NA NA NA NA NA NA discount_limit number3 0 1 The number of times that the promotion that can be applied to a transaction. NA NA NA NA NA NA exception_parent_id number10 0 1 NA * * * * * * 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. * * * * * * 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. NA NA NA NA NA NA

XML-Schema Name:LocationList Version:14.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 NA * * * * * * loc_type varchar22 1 1 null * * * * * *

XML-Schema Name:ListGroup Version:14.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 NA * * * * * * ListDtl * 1 unbounded Description is not available.

XML-Schema Name:ListDtl Version:14.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 NA RPM_PROMO_DTL_LIST_PAYLOAD PROMO_DTL_LIST_ID NUMBER 10 Yes Promotion Detail List Id reward_application number1 0 1 NA RPM_PROMO_DTL_LIST_PAYLOAD REWARD_APPLICATION NUMBER 1 No Reward Application description varchar2160 0 1 null 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. NA NA NA NA NA NA price_range_max number20_4 0 1 Contains price range promotion maximum valid retail value. NA NA NA NA NA NA

XML-Schema Name:DiscountLadder Version:14.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 NA 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 NA RPM_PROMO_DISC_LDR_PAYLOAD QUAL_TYPE NUMBER 2 No Qualification Type qual_value number20_4 0 1 NA 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:14.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 NA RPM_PROMO_ITEM_PAYLOAD ITEM VARCHAR2 25 Yes Item Number

XML-Schema Name:ItemLocSimpleRet Version:14.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. NA NA NA NA NA NA selling_currency varchar23 1 1 Contains the currency code that should match the store's currency code. NA NA NA NA NA NA

XML-Schema Name:CreditDetail Version:14.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 NA NA NA NA NA NA credit_type varchar240 1 1 NA NA NA NA NA NA bin_number_from number10 1 1 RPM_PROMO_FIN_DTL_PAYLOAD BIN_FROM_VALUE NUMBER 16 No Bin From Value bin_number_to number10 1 1 RPM_PROMO_FIN_DTL_PAYLOAD BIN_TO_VALUE NUMBER 16 No Bin To Value commision_rate number10 1 1 RPM_PROMO_FIN_DTL_PAYLOAD COMMISSION_RATE NUMBER 20 No Commission Rate comments varchar2160 1 1 RPM_PROMO_FIN_DTL_PAYLOAD COMMENTS VARCHAR2 1000 No Comments

Retail Integration Mappings Report Release:14.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 InvocationSuccess

XML-Schema Name:InvocationSuccess Version:14.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:14.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 PromotionRef LocationListRef ListGroupRef ListDtlRef ItemListRef

XML-Schema Name:PromotionRef Version:14.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 Description is not available. 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:14.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:14.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 Description is not available. 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:14.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 Description is not available. RPM_PROMO_DTL_LIST_PAYLOAD PROMO_DTL_LIST_ID NUMBER 10 Yes Promotion Detail List Id ItemListRef * 1 unbounded Description is not available. NA NA NA NA NA NA

XML-Schema Name:ItemListRef Version:14.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:14.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 StoreDesc AddrDesc

XML-Schema Name:StoreDesc Version:14.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. NA NA NA NA NA NA 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. NA NA NA NA NA NA timezone_name varchar264 0 1 Indicates the time zone of the store. For example, 'America/New_York'. NA NA NA NA NA NA

XML-Schema Name:AddrDesc Version:14.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. NA NA NA NA NA NA state_name varchar2120 0 1 Indicates the State name. NA NA NA NA NA NA country_name varchar2120 0 1 Indicates the Country Name. For e.g Brazil,United States NA NA NA NA NA NA 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. NA NA NA NA NA NA

Retail Integration Mappings Report Release:14.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 ClrPrcChgRef ClrPrcChgDtlRef

XML-Schema Name:ClrPrcChgRef Version:14.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 * 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:14.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 NA rpm_clearance_payload clearance_id NUMBER 15 Yes Clearance Id item varchar225 1 1 NA rpm_clearance_payload item VARCHAR2 25 * Item Number