Retail Integration Mappings Report Release:15.0.0 (Store Inventory Management)
Application Store Inventory 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

XML-Schema Name:ClrPrcChgDesc 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 ClrPrcChgDesc in SIM application.
SIM's Table Name SIM's Column Name Integration API(RIB or/and RSB or/and RSL) SIM's Column Length Is Column Required in SIM's API? SIM's API Description
location number10 1 1 Unique identifier that indicates a Location (Store or Warehouse) PRICE_CHANGE_WORKSHEET STORE_ID NUMBER 10,0 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') TBD TBD VARCHAR2 * Not Yet Available 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:15.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 SIM application.
SIM's Table Name SIM's Column Name Integration API(RIB or/and RSB or/and RSL) SIM's Column Length Is Column Required in SIM's API? SIM's API Description
clearance_id Number15 1 1 Clearance ID PRICE_CHANGE_WORKSHEET CLEARANCE_ID NUMBER 15,0 No Clearance price identifier from pricing engine
item varchar225 1 1 Unique identifier of the item in the clearance PRICE_CHANGE_WORKSHEET ITEM_ID VARCHAR2 25 Yes Item id
effective_date xs:dateTime 1 1 The date the clearance becomes active PRICE_CHANGE_WORKSHEET EFFECTIVE_DATE DATE DATE No Date price change is effective
selling_unit_retail number20_4 1 1 Clearance selling unit retail PRICE_CHANGE_WORKSHEET SELLING_UNIT_CHANGE NUMBER 1,0 No The selling retail price change indicator
selling_uom varchar24 1 1 Clearance selling UOM PRICE_CHANGE_WORKSHEET SELLING_RETAIL_UOM VARCHAR2 4,0 No The selling retail Unit Of Measure
selling_currency Varchar23 1 1 Clearance selling currency PRICE_CHANGE_WORKSHEET SELLING_RETAIL_CURRENCY VARCHAR2 3 No The selling retail currency code
reset_clearance_id Number15 0 1 Clearance reset ID PRICE_CHANGE_WORKSHEET RESET_CLEARANCE_ID NUMBER 15,0 No Reset clearance id