Retail Integration Bus Mappings Report Release:13.1

(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. AddrDesc ExtOfAddrDesc

XML-Schema Name:AddrDesc Version:13.1 Return to Top Tag Name Type Min Occurs Max Occurs Description rpm Mapping For AddrDesc Table Name Column Name API Type Column Length API Required API Description addr number6 1 1 Description is not available. * * 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 1 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 Description is not available. * * varchar2 240 * * add_2 varchar2240 0 1 Description is not available. * * varchar2 240 * * add_3 varchar2240 0 1 Description is not available. * * varchar2 240 * * city varchar2120 1 1 Description is not available. * * 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 Description is not available. * * varchar2 3 * * post varchar230 0 1 Description is not available. * * varchar2 30 * * contact_name varchar2120 0 1 Description is not available. * * varchar2 120 * * contact_phone varchar220 0 1 Description is not available. * * 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 Description is not available. * * 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 varchar220 0 1 Description is not available. * * varchar2 250 * * ExtOfAddrDesc:ExtOfAddrDesc * 0 1 Provide an extension hook to customize AddrDesc. NA NA NA NA NA NA

XML-Schema Name:ExtOfAddrDesc Version:13.1 Return to Top Tag Name Type Min Occurs Max Occurs Description rpm Mapping For ExtOfAddrDesc Table Name Column Name API Type Column Length API Required API Description

Retail Integration Bus Mappings Report Release:13.1

(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. ClrPrcChgDesc ClrPrcChgDtl ExtOfClrPrcChgDtl ExtOfClrPrcChgDesc

XML-Schema Name:ClrPrcChgDesc Version:13.1 Return to Top Tag Name Type Min Occurs Max Occurs Description rpm Mapping For ClrPrcChgDesc Table Name Column Name API Type Column Length API Required API Description location number10 1 1 Unique identifier that indicates a Location (Store or Warehouse) rpm_future_retail location null null 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_future_retail zone_node_type null null Yes Identifier that indicates whether a location is a Store ('S') or a Warehouse ('W') ClrPrcChgDtl * 1 unbounded Description is not available. ExtOfClrPrcChgDesc:ExtOfClrPrcChgDesc * 0 1 Provide an extension hook to customize ClrPrcChgDesc. NA NA NA NA NA NA

XML-Schema Name:ClrPrcChgDtl Version:13.1 Return to Top Tag Name Type Min Occurs Max Occurs Description rpm Mapping For ClrPrcChgDtl Table Name Column Name API Type Column Length API Required API Description clearance_id Number15 1 1 Not Yet Available rpm_clearance clearance_id null null Yes Clearance Id item varchar225 1 1 Not Yet Available rpm_future_retail clear_retail null null Yes Item Number effective_date xs:dateTime 1 1 Not Yet Available rpm_clearance effective_date null null Yes Effective date of the clearance selling_unit_retail number20_4 1 1 Not Yet Available rpm_future_retail clear_retail null null Yes Clearance selling retail selling_uom varchar24 1 1 Not Yet Available rpm_future_retail clear_uom null null Yes Clearance selling UOM selling_currency Varchar23 1 1 NA rpm_future_retail clear_retail_currency null null Yes Clearance selling currency reset_clearance_id Number15 0 1 NA rpm_clearance clearance_id null null Yes Clearance reset id ExtOfClrPrcChgDesc:ExtOfClrPrcChgDtl * 0 1 Provide an extension hook to customize ClrPrcChgDtl. NA NA NA NA NA NA

XML-Schema Name:ExtOfClrPrcChgDtl Version:13.1 Return to Top Tag Name Type Min Occurs Max Occurs Description rpm Mapping For ExtOfClrPrcChgDtl Table Name Column Name API Type Column Length API Required API Description

XML-Schema Name:ExtOfClrPrcChgDesc Version:13.1 Return to Top Tag Name Type Min Occurs Max Occurs Description rpm Mapping For ExtOfClrPrcChgDesc Table Name Column Name API Type Column Length API Required API Description

Retail Integration Bus Mappings Report Release:13.1

(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. ClrPrcChgRef ClrPrcChgDtlRef ExtOfClrPrcChgDtlRef ExtOfClrPrcChgRef

XML-Schema Name:ClrPrcChgRef Version:13.1 Return to Top Tag Name Type Min Occurs Max Occurs Description rpm Mapping For ClrPrcChgRef Table Name Column Name API Type Column Length API Required API Description location number10 1 1 Unique identifier that indicates a Location (Store or Warehouse) rpm_future_retail location null null 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_future_retail zone_node_type null null * Identifier that indicates whether a location is a Store ('S') or a Warehouse ('W') ClrPrcChgDtlRef * 1 unbounded Description is not available. NA NA NA NA NA NA ExtOfClrPrcChgRef:ExtOfClrPrcChgRef * 0 1 Provide an extension hook to customize ClrPrcChgRef. NA NA NA NA NA NA

XML-Schema Name:ClrPrcChgDtlRef Version:13.1 Return to Top Tag Name Type Min Occurs Max Occurs Description rpm Mapping For ClrPrcChgDtlRef Table Name Column Name API Type Column Length API Required API Description clearance_id number15 1 1 NA NA NA NA NA NA NA item varchar225 1 1 NA NA NA NA NA NA NA ExtOfClrPrcChgRef:ExtOfClrPrcChgDtlRef * 0 1 Provide an extension hook to customize ClrPrcChgDtlRef. NA NA NA NA NA NA

XML-Schema Name:ExtOfClrPrcChgDtlRef Version:13.1 Return to Top Tag Name Type Min Occurs Max Occurs Description rpm Mapping For ExtOfClrPrcChgDtlRef Table Name Column Name API Type Column Length API Required API Description

XML-Schema Name:ExtOfClrPrcChgRef Version:13.1 Return to Top Tag Name Type Min Occurs Max Occurs Description rpm Mapping For ExtOfClrPrcChgRef Table Name Column Name API Type Column Length API Required API Description

Retail Integration Bus Mappings Report Release:13.1

(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. PrmPrcChgDesc PrmPrcChgDtl PrmPrcChgSmp ExtOfPrmPrcChgSmp PrmPrcChgThr PrmPrcChgThrDtl ExtOfPrmPrcChgThrDtl ExtOfPrmPrcChgThr PrmPrcChgBuyGet PrmPrcChgGetItem ExtOfPrmPrcChgGetItem PrmPrcChgBuyItem ExtOfPrmPrcChgBuyItem ExtOfPrmPrcChgBuyGet ExtOfPrmPrcChgDtl ExtOfPrmPrcChgDesc

XML-Schema Name:PrmPrcChgDesc Version:13.1 Return to Top Tag Name Type Min Occurs Max Occurs Description rpm Mapping For PrmPrcChgDesc Table Name Column Name API Type Column Length API Required API Description location number10 1 1 Unique identifier that indicates a Location (Store or Warehouse) rpm_future_retail location null null * 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 null null * Identifier that indicates whether a location is a Store ('S') or a Warehouse ('W') PrmPrcChgDtl * 1 unbounded Description is not available. ExtOfPrmPrcChgDesc:ExtOfPrmPrcChgDesc * 0 1 Provide an extension hook to customize PrmPrcChgDtl. NA NA NA NA NA NA

XML-Schema Name:PrmPrcChgDtl Version:13.1 Return to Top Tag Name Type Min Occurs Max Occurs Description rpm Mapping For PrmPrcChgDtl Table Name Column Name API Type Column Length API Required API Description promo_id number10 1 1 Promotion Id rpm_promo promo_id null null * Promotion Id promo_name varchar240 0 1 Promotion Name rpm_promo name null null * Promotion Name promo_description varchar2160 0 1 Promotion Description rpm_promo description null null * Promotion Description promo_comp_id number10 1 1 Promotion Component Id rpm_promo_comp promo_comp_id null null * Promotion Component Id promo_comp_desc varchar240 0 1 Promotion Component Description rpm_promo_comp name null null * Promotion Component Description promo_comp_detail_id number10 1 1 Promotion Component Detail Id rpm_promo_comp_detail rpm_promo_comp_detail_id null null * 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_comp_detail start_date null null * Start date of the promotion component detail end_date xs:dateTime 0 1 End date of the promotion component detail rpm_promo_comp_detail end_date null null * 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. ExtOfPrmPrcChgDesc:ExtOfPrmPrcChgDtl * 0 1 Provide an extension hook to customize PrmPrcChgDtl. NA NA NA NA NA NA

XML-Schema Name:PrmPrcChgSmp Version:13.1 Return to Top Tag Name Type Min Occurs Max Occurs Description rpm Mapping For PrmPrcChgSmp Table Name Column Name API Type Column Length API Required API Description item varchar225 1 1 Item number rpm_future_retail item null null * Item number promo_selling_retail number20 1 1 Simple Promotion selling retail rpm_future_retail simple_promo_retail null null * Simple Promotion selling retail promo_selling_uom xs:string 1 1 Simple promotion selling UOM rpm_future_retail simple_promo_uom null null * Simple promotion selling UOM prm_chg_type varchar21 1 1 Simple Promotion change type rpm_promo_comp_simple change_type null null * Simple Promotion change type prm_chg_value number20 1 1 Simple Promotion change value rpm_promo_comp_simple change_amt or change_percent null null * Simple Promotion change value prm_chg_uom varchar24 0 1 Simple Promotion change selling UOM rpm_promo_comp_simple change_selling_uom null null * Simple Promotion change selling UOM ExtOfPrmPrcChgDesc:ExtOfPrmPrcChgSmp * 0 1 Provide an extension hook to customize PrmPrcChgSmp. NA NA NA NA NA NA

XML-Schema Name:ExtOfPrmPrcChgSmp Version:13.1 Return to Top Tag Name Type Min Occurs Max Occurs Description rpm Mapping For ExtOfPrmPrcChgSmp Table Name Column Name API Type Column Length API Required API Description

XML-Schema Name:PrmPrcChgThr Version:13.1 Return to Top Tag Name Type Min Occurs Max Occurs Description rpm Mapping For PrmPrcChgThr Table Name Column Name API Type Column Length API Required API Description item varchar225 1 1 Item number rpm_future_retail item null null * Item number threshold_id number6 1 1 Threshold Id rpm_prom_comp_threshold threshold_id null null * Threshold Id threshold_name varchar230 0 1 Threshold Name rpm_threshold name null null * Threshold Name qualification_type number1 1 1 Threshold Qualification Type rpm_threshold qualification_type null null * Threshold Qualification Type threshold_type varchar21 1 1 Threshold Type rpm_threshold_interval threshold_type null null * Threshold Type prm_chg_type varchar21 1 1 Threshold Discount Change Type rpm_threshold_interval change_type null null * Threshold Discount Change Type PrmPrcChgThrDtl * 1 unbounded Description is not available. ExtOfPrmPrcChgDesc:ExtOfPrmPrcChgThr * 0 1 Provide an extension hook to customize PrmPrcChgThr. NA NA NA NA NA NA

XML-Schema Name:PrmPrcChgThrDtl Version:13.1 Return to Top Tag Name Type Min Occurs Max Occurs Description rpm Mapping For PrmPrcChgThrDtl Table Name Column Name API Type Column Length API Required API Description threshold_value number20 1 1 Threshold Interval Value rpm_threshold_interval threshold_amount null null * Threshold Interval Value prm_chg_value number20 1 1 Threshold Change Value rpm_threshold_interval change_amt or change_percent null null * Threshold Change Value prm_chg_uom varchar24 0 1 Threshold Change Selling UOM rpm_threshold_interval change_uom null null * Threshold Change Selling UOM ExtOfPrmPrcChgDesc:ExtOfPrmPrcChgThrDtl * 0 1 Provide an extension hook to customize PrmPrcChgThrDtl. NA NA NA NA NA NA

XML-Schema Name:ExtOfPrmPrcChgThrDtl Version:13.1 Return to Top Tag Name Type Min Occurs Max Occurs Description rpm Mapping For ExtOfPrmPrcChgThrDtl Table Name Column Name API Type Column Length API Required API Description

XML-Schema Name:ExtOfPrmPrcChgThr Version:13.1 Return to Top Tag Name Type Min Occurs Max Occurs Description rpm Mapping For ExtOfPrmPrcChgThr Table Name Column Name API Type Column Length API Required API Description

XML-Schema Name:PrmPrcChgBuyGet Version:13.1 Return to Top Tag Name Type Min Occurs Max Occurs Description rpm Mapping For PrmPrcChgBuyGet Table Name Column Name API Type Column Length API Required API Description prm_chg_type varchar21 1 1 Buy Get discount change type rpm_promo_comp_buy_get change_type null null * Buy Get discount change type prm_chg_value number20 1 1 Buy Get Discount Change Value rpm_promo_comp_buy_get change_amount or change_percent null null * Buy Get Discount Change Value prm_chg_uom varchar24 0 1 Buy Get Change Selling UOM rpm_promo_comp_buy_get change_selling_uom null null change_selling_uom Buy Get Change Selling UOM buy_qty number20 1 1 Buy quantity rpm_promo_comp_buy_get buy_item_qty null null * Buy quantity all_ind number1 1 1 Buy All Indicator rpm_promo_comp_buy_get buy_item_type null null * Buy All Indicator PrmPrcChgGetItem * 1 unbounded Description is not available. PrmPrcChgBuyItem * 1 unbounded Description is not available. ExtOfPrmPrcChgDesc:ExtOfPrmPrcChgBuyGet * 0 1 Provide an extension hook to customize PrmPrcChgBuyGet. NA NA NA NA NA NA

XML-Schema Name:PrmPrcChgGetItem Version:13.1 Return to Top Tag Name Type Min Occurs Max Occurs Description rpm Mapping For PrmPrcChgGetItem Table Name Column Name API Type Column Length API Required API Description item varchar225 1 1 Get Item rpm_promo_get_item item null null * Get Item ExtOfPrmPrcChgDesc:ExtOfPrmPrcChgGetItem * 0 1 Provide an extension hook to customize PrmPrcChgGetItem. NA NA NA NA NA NA

XML-Schema Name:ExtOfPrmPrcChgGetItem Version:13.1 Return to Top Tag Name Type Min Occurs Max Occurs Description rpm Mapping For ExtOfPrmPrcChgGetItem Table Name Column Name API Type Column Length API Required API Description

XML-Schema Name:PrmPrcChgBuyItem Version:13.1 Return to Top Tag Name Type Min Occurs Max Occurs Description rpm Mapping For PrmPrcChgBuyItem Table Name Column Name API Type Column Length API Required API Description item varchar225 1 1 Buy Item rpm_promo_comp_buy_item item null null * Buy Item ExtOfPrmPrcChgDesc:ExtOfPrmPrcChgBuyItem * 0 1 Provide an extension hook to customize PrmPrcChgBuyItem. NA NA NA NA NA NA

XML-Schema Name:ExtOfPrmPrcChgBuyItem Version:13.1 Return to Top Tag Name Type Min Occurs Max Occurs Description rpm Mapping For ExtOfPrmPrcChgBuyItem Table Name Column Name API Type Column Length API Required API Description

XML-Schema Name:ExtOfPrmPrcChgBuyGet Version:13.1 Return to Top Tag Name Type Min Occurs Max Occurs Description rpm Mapping For ExtOfPrmPrcChgBuyGet Table Name Column Name API Type Column Length API Required API Description

XML-Schema Name:ExtOfPrmPrcChgDtl Version:13.1 Return to Top Tag Name Type Min Occurs Max Occurs Description rpm Mapping For ExtOfPrmPrcChgDtl Table Name Column Name API Type Column Length API Required API Description

XML-Schema Name:ExtOfPrmPrcChgDesc Version:13.1 Return to Top Tag Name Type Min Occurs Max Occurs Description rpm Mapping For ExtOfPrmPrcChgDesc Table Name Column Name API Type Column Length API Required API Description

Retail Integration Bus Mappings Report Release:13.1

(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. PrmPrcChgRef PrmPrcChgDtlRef PrmPrcChgSmpDtlRe ExtOfPrmPrcChgSmpDtlRe PrmPrcChgThrDtlRe ExtOfPrmPrcChgThrDtlRe ExtOfPrmPrcChgDtlRef ExtOfPrmPrcChgRef

XML-Schema Name:PrmPrcChgRef Version:13.1 Return to Top Tag Name Type Min Occurs Max Occurs Description rpm Mapping For PrmPrcChgRef Table Name Column Name API Type Column Length API Required API Description location number10 1 1 Description is not available. rpm_future_retail location null null * 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 null null * 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 ExtOfPrmPrcChgRef:ExtOfPrmPrcChgRef * 0 1 Provide an extension hook to customize PrmPrcChgRef. NA NA NA NA NA NA

XML-Schema Name:PrmPrcChgDtlRef Version:13.1 Return to Top Tag Name Type Min Occurs Max Occurs Description rpm Mapping For PrmPrcChgDtlRef Table Name Column Name API Type Column Length API Required 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 ExtOfPrmPrcChgRef:ExtOfPrmPrcChgDtlRef * 0 1 Provide an extension hook to customize PrmPrcChgDtlRef. NA NA NA NA NA NA

XML-Schema Name:PrmPrcChgSmpDtlRe Version:13.1 Return to Top Tag Name Type Min Occurs Max Occurs Description rpm Mapping For PrmPrcChgSmpDtlRe Table Name Column Name API Type Column Length API Required API Description item varchar225 1 1 NA NA NA NA NA NA NA ExtOfPrmPrcChgRef:ExtOfPrmPrcChgSmpDtlRe * 0 1 Provide an extension hook to customize PrmPrcChgSmpDtlRef. NA NA NA NA NA NA

XML-Schema Name:ExtOfPrmPrcChgSmpDtlRe Version:13.1 Return to Top Tag Name Type Min Occurs Max Occurs Description rpm Mapping For ExtOfPrmPrcChgSmpDtlRe Table Name Column Name API Type Column Length API Required API Description

XML-Schema Name:PrmPrcChgThrDtlRe Version:13.1 Return to Top Tag Name Type Min Occurs Max Occurs Description rpm Mapping For PrmPrcChgThrDtlRe Table Name Column Name API Type Column Length API Required API Description item varchar225 1 1 NA NA NA NA NA NA NA ExtOfPrmPrcChgRef:ExtOfPrmPrcChgThrDtlRe * 0 1 Provide an extension hook to customize PrmPrcChgThrDtlRef. NA NA NA NA NA NA

XML-Schema Name:ExtOfPrmPrcChgThrDtlRe Version:13.1 Return to Top Tag Name Type Min Occurs Max Occurs Description rpm Mapping For ExtOfPrmPrcChgThrDtlRe Table Name Column Name API Type Column Length API Required API Description

XML-Schema Name:ExtOfPrmPrcChgDtlRef Version:13.1 Return to Top Tag Name Type Min Occurs Max Occurs Description rpm Mapping For ExtOfPrmPrcChgDtlRef Table Name Column Name API Type Column Length API Required API Description

XML-Schema Name:ExtOfPrmPrcChgRef Version:13.1 Return to Top Tag Name Type Min Occurs Max Occurs Description rpm Mapping For ExtOfPrmPrcChgRef Table Name Column Name API Type Column Length API Required API Description

Retail Integration Bus Mappings Report Release:13.1

(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. RegPrcChgDesc RegPrcChgDtl ExtOfRegPrcChgDtl ExtOfRegPrcChgDesc

XML-Schema Name:RegPrcChgDesc Version:13.1 Return to Top Tag Name Type Min Occurs Max Occurs Description rpm Mapping For RegPrcChgDesc Table Name Column Name API Type Column Length API Required API Description location number10 1 1 Unique identifier that indicates a Location (Store or Warehouse) rpm_future_retail location null null 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 null null Yes Identifier that indicates whether a location is a Store ('S') or a Warehouse ('W') RegPrcChgDtl * 1 unbounded Description is not available. ExtOfRegPrcChgDesc:ExtOfRegPrcChgDesc * 0 1 Provide an extension hook to customize RegPrcChgDesc. NA NA NA NA NA NA

XML-Schema Name:RegPrcChgDtl Version:13.1 Return to Top Tag Name Type Min Occurs Max Occurs Description rpm Mapping For RegPrcChgDtl Table Name Column Name API Type Column Length API Required 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 null null Yes Price Change Id item varchar225 1 1 Alphanumeric value that identifies the item for which tickets have been requested. rpm_future_retail item null null Yes Item number effective_date xs:dateTime 1 1 Price Change Effective Date rpm_future_retail action_date null 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 null null 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 null null 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 null null 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 null null 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 null null 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 null null 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 null null 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 null null No Multi Unit Retail Currency multi_selling_uom varchar24 0 1 Multi Unit Selling UOM rpm_future_retail multi_selling_uom null null No Multi Unit Selling UOM ExtOfRegPrcChgDesc:ExtOfRegPrcChgDtl * 0 1 Provide an extension hook to customize RegPrcChgDtl. NA NA NA NA NA NA

XML-Schema Name:ExtOfRegPrcChgDtl Version:13.1 Return to Top Tag Name Type Min Occurs Max Occurs Description rpm Mapping For ExtOfRegPrcChgDtl Table Name Column Name API Type Column Length API Required API Description

XML-Schema Name:ExtOfRegPrcChgDesc Version:13.1 Return to Top Tag Name Type Min Occurs Max Occurs Description rpm Mapping For ExtOfRegPrcChgDesc Table Name Column Name API Type Column Length API Required API Description

Retail Integration Bus Mappings Report Release:13.1

(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. RegPrcChgRef RegPrcChgDtlRef ExtOfRegPrcChgDtlRef ExtOfRegPrcChgRef

XML-Schema Name:RegPrcChgRef Version:13.1 Return to Top Tag Name Type Min Occurs Max Occurs Description rpm Mapping For RegPrcChgRef Table Name Column Name API Type Column Length API Required API Description location number10 1 1 Description is not available. rpm_future_retail location null null * 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 null null * Identifier that indicates whether a location is a Store ('S') or a Warehouse ('W') RegPrcChgDtlRef * 1 unbounded NA ExtOfRegPrcChgRef:ExtOfRegPrcChgRef * 0 1 Provide an extension hook to customize RegPrcChgRef. NA NA NA NA NA NA

XML-Schema Name:RegPrcChgDtlRef Version:13.1 Return to Top Tag Name Type Min Occurs Max Occurs Description rpm Mapping For RegPrcChgDtlRef Table Name Column Name API Type Column Length API Required API Description price_change_id number15 1 1 Description is not available. rpm_price_change price_change_id null null * Price Change ID item varchar225 1 1 Description is not available. rpm_future_retail item null null * Item number ExtOfRegPrcChgRef:ExtOfRegPrcChgDtlRef * 0 1 Provide an extension hook to customize RegPrcChgDtlRef. NA NA NA NA NA NA

XML-Schema Name:ExtOfRegPrcChgDtlRef Version:13.1 Return to Top Tag Name Type Min Occurs Max Occurs Description rpm Mapping For ExtOfRegPrcChgDtlRef Table Name Column Name API Type Column Length API Required API Description

XML-Schema Name:ExtOfRegPrcChgRef Version:13.1 Return to Top Tag Name Type Min Occurs Max Occurs Description rpm Mapping For ExtOfRegPrcChgRef Table Name Column Name API Type Column Length API Required API Description

Retail Integration Bus Mappings Report Release:13.1

(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. StoreDesc AddrDesc ExtOfAddrDesc ExtOfStoreDesc

XML-Schema Name:StoreDesc Version:13.1 Return to Top Tag Name Type Min Occurs Max Occurs Description rpm Mapping For StoreDesc Table Name Column Name API Type Column Length API Required API Description store number10 1 1 Description is not available. rpm_zone_location location null null Yes * store_type varchar21 1 1 Description is not available. NA NA NA NA NA NA store_name varchar2150 1 1 Description is not available. * * varchar2 150 * * store_name10 varchar210 0 1 Description is not available. * * varchar2 10 * * store_name3 varchar23 0 1 Description is not available. * * varchar2 3 * * store_add1 varchar2240 0 1 Description is not available. * * varchar2 240 * * store_add2 varchar2240 0 1 Description is not available. * * varchar2 240 * * store_city varchar2120 0 1 Description is not available. * * varchar2 120 * * county varchar2250 0 1 Description is not available. * * varchar2 250 * * state varchar23 0 1 Description is not available. * * varchar2 3 * * country_id varchar23 0 1 Description is not available. * * varchar2 3 * * store_pcode varchar230 0 1 Description is not available. * * 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 Description is not available. * * varchar2 120 * * store_open_date xs:dateTime 0 1 Description is not available. * * RIBDate * * * store_close_date xs:dateTime 0 1 Description is not available. * * RIBDate * * * acquired_date xs:dateTime 0 1 Description is not available. * * RIBDate * * * remodel_date xs:dateTime 0 1 Description is not available. * * RIBDate * * * fax_number varchar220 0 1 This type can hold a number of digits count mber. * * varchar2 20 * * phone_number varchar220 0 1 This type can hold a number of digits count number. * * varchar2 20 * * email varchar2100 0 1 Description is not available. * * varchar2 100 * * total_square_ft number8 0 1 Description is not available. * * number 8 * * selling_square_ft number8 0 1 Description is not available. * * number 8 * * linear_distance number8 0 1 Description is not available. * * 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 Description is not available. * * varchar2 120 * * district number10 0 1 Description is not available. * * number 10 * * district_name varchar2120 0 1 Description is not available. * * varchar2 120 * * promo_zone number4 0 1 Description is not available. * * number 4 * * promo_desc varchar220 0 1 Description is not available. * * 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 Description is not available. * * 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 Description is not available. * * varchar2 3 * * lang number6 0 1 Description is not available. * * number 6 * * integrated_pos_ind varchar21 0 1 Description is not available. * * 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 Description is not available. * * 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 Description is not available. * * varchar2 3 * * org_unit_id number15 0 1 Description is not available. NA NA NA NA NA NA timezone_name varchar264 0 1 Description is not available. NA NA NA NA NA NA ExtOfStoreDesc:ExtOfStoreDesc * 0 1 Provide an extension hook to customize StoreDesc. NA NA NA NA NA NA

XML-Schema Name:AddrDesc Version:13.1 Return to Top Tag Name Type Min Occurs Max Occurs Description rpm Mapping For AddrDesc Table Name Column Name API Type Column Length API Required API Description addr number6 1 1 Description is not available. * * 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 1 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 Description is not available. * * varchar2 240 * * add_2 varchar2240 0 1 Description is not available. * * varchar2 240 * * add_3 varchar2240 0 1 Description is not available. * * varchar2 240 * * city varchar2120 1 1 Description is not available. * * 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 Description is not available. * * varchar2 3 * * post varchar230 0 1 Description is not available. * * varchar2 30 * * contact_name varchar2120 0 1 Description is not available. * * varchar2 120 * * contact_phone varchar220 0 1 Description is not available. * * 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 Description is not available. * * 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 varchar220 0 1 Description is not available. * * varchar2 250 * * ExtOfAddrDesc:ExtOfAddrDesc * 0 1 Provide an extension hook to customize AddrDesc. NA NA NA NA NA NA

XML-Schema Name:ExtOfAddrDesc Version:13.1 Return to Top Tag Name Type Min Occurs Max Occurs Description rpm Mapping For ExtOfAddrDesc Table Name Column Name API Type Column Length API Required API Description

XML-Schema Name:ExtOfStoreDesc Version:13.1 Return to Top Tag Name Type Min Occurs Max Occurs Description rpm Mapping For ExtOfStoreDesc Table Name Column Name API Type Column Length API Required API Description