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