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)