Retail Integration Bus Mappings Report Release:13.2.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.

XML-Schema Name:RegPrcChgDesc Version:13.2.0 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 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.
ExtOfRegPrcChgDesc:ExtOfRegPrcChgDesc * 0 1 Provide an extension hook to customize RegPrcChgDesc. NA NA NA NA NA NA
LocOfRegPrcChgDesc:LocOfRegPrcChgDesc * 0 1 Provide an extension hook to localize RegPrcChgDesc. NA NA NA NA NA NA

XML-Schema Name:RegPrcChgDtl Version:13.2.0 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 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
ExtOfRegPrcChgDesc:ExtOfRegPrcChgDtl * 0 1 Provide an extension hook to customize RegPrcChgDtl. NA NA NA NA NA NA
LocOfRegPrcChgDesc:LocOfRegPrcChgDtl * 0 1 Provide an extension hook to localize RegPrcChgDtl. NA NA NA NA NA NA

XML-Schema Name:ExtOfRegPrcChgDtl Version:13.2.0 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:LocOfRegPrcChgDtl Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rpm Mapping For LocOfRegPrcChgDtl
Table Name Column Name API Type Column Length API Required API Description
InRegPrcChgDesc:InRegPrcChgDtl * 0 unbounded India Localization. NA NA NA NA NA NA
BrRegPrcChgDesc:BrRegPrcChgDtl * 0 unbounded Brazil Localization. NA NA NA NA NA NA

XML-Schema Name:ExtOfRegPrcChgDesc Version:13.2.0 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

XML-Schema Name:LocOfRegPrcChgDesc Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rpm Mapping For LocOfRegPrcChgDesc
Table Name Column Name API Type Column Length API Required API Description
InRegPrcChgDesc:InRegPrcChgDesc * 0 unbounded India Localization. NA NA NA NA NA NA
BrRegPrcChgDesc:BrRegPrcChgDesc * 0 unbounded Brazil Localization. NA NA NA NA NA NA