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

XML-Schema Name:ClrPrcChgDesc Version:13.1 Return to Top
Tag Name Type Min Occurs Max Occurs Description sim Mapping For ClrPrcChgDesc
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) RK_PRICE_CHANGE id_str_rt NUMBER 128 Yes Not Yet Available
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 Not Yet Available
ClrPrcChgDtl * 1 unbounded Description is not available.
ExtOfClrPrcChgDesc:ExtOfClrPrcChgDesc * 0 1 Provide an extension hook to customize ClrPrcChgDesc. NA NA NA NA NA NA

XML-Schema Name:ClrPrcChgDtl Version:13.1 Return to Top
Tag Name Type Min Occurs Max Occurs Description sim Mapping For ClrPrcChgDtl
Table Name Column Name API Type Column Length API Required API Description
clearance_id Number15 1 1 Not Yet Available RK_PRICE_CHANGE change_id NUMBER 15 No Not Yet Available
item varchar225 1 1 Not Yet Available RK_PRICE_CHANGE id_item VARCHAR2 128 No Not Yet Available
effective_date xs:dateTime 1 1 Not Yet Available RK_PRICE_CHANGE effective_date RIBDate * Yes Not Yet Available
selling_unit_retail number20_4 1 1 Not Yet Available RK_PRICE_CHANGE new_price NUMBER 75 Yes Not Yet Available
selling_uom varchar24 1 1 Not Yet Available RK_PRICE_CHANGE new_selling_uom VARCHAR2 40 No Not Yet Available
selling_currency Varchar23 1 1 NA null varchar2 25 null null
reset_clearance_id Number15 0 1 NA null null null null null
ExtOfClrPrcChgDesc:ExtOfClrPrcChgDtl * 0 1 Provide an extension hook to customize ClrPrcChgDtl. NA NA NA NA NA NA

XML-Schema Name:ExtOfClrPrcChgDtl Version:13.1 Return to Top
Tag Name Type Min Occurs Max Occurs Description sim Mapping For ExtOfClrPrcChgDtl
Table Name Column Name API Type Column Length API Required API Description

XML-Schema Name:ExtOfClrPrcChgDesc Version:13.1 Return to Top
Tag Name Type Min Occurs Max Occurs Description sim Mapping For ExtOfClrPrcChgDesc
Table Name Column Name API Type Column Length API Required API Description