Retail Integration Mappings Report Release:16.0.030 (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:16.0.030 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 BDI) 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 )
loc_type varchar21 1 1 Identifier that indicates whether a location is a Store ('S') or a Warehouse ('W') Yes Identifier that indicates whether a location is a Store ('S') or a Warehouse ('W'). SIM only consumes loc_type = S
ClrPrcChgDtl * 1 unbounded Description is not available.

XML-Schema Name:ClrPrcChgDtl Version:16.0.030 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 BDI) 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 identifier
effective_date xs:dateTime 1 1 The date the clearance becomes active PRICE_CHANGE_WORKSHEET EFFECTIVE_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 CLEARANCE_RESET_ID NUMBER 15,0 No Reset clearance id