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/RegPrcChgDesc/v1
Version 1.0
Description This is root element of this document which contains name space definitions for the document elements.

XML-Schema Name:RegPrcChgDesc Version:13.1 Return to Top
Tag Name Type Min Occurs Max Occurs Description sim Mapping For RegPrcChgDesc
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 Indicates the type of location which has requested tickets. Valid values for this field are: 'W' (for warehouse) and 'S' (for store). TBD TBD VARCHAR2 * Not Yet Available Not Yet Available
RegPrcChgDtl * 1 unbounded Description is not available.
ExtOfRegPrcChgDesc:ExtOfRegPrcChgDesc * 0 1 Provide an extension hook to customize RegPrcChgDesc. NA NA NA NA NA NA

XML-Schema Name:RegPrcChgDtl Version:13.1 Return to Top
Tag Name Type Min Occurs Max Occurs Description sim Mapping For RegPrcChgDtl
Table Name Column Name API Type Column Length API Required API Description
price_change_id number15 1 1 Contains the ID of the price change that initiated the ticket request. RK_PRICE_CHANGE CHANGE_ID NUMBER 15 No Not Yet Available
item varchar225 1 1 Alphanumeric value that identifies the item for which tickets have been requested. RK_PRICE_CHANGE ID_ITM VARCHAR2 128 No Not Yet Available
effective_date xs:dateTime 1 1 Price Change Effective Date RK_PRICE_CHANGE EFFECTIVE_DATE RIBDate * Yes Not Yet Available
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. null number 1 null null
selling_unit_retail number20_4 1 1 This field contains the unit retail for the item at the indicated location. RK_PRICE_CHANGE NEW_PRICE NUMBER 75 Yes Not Yet Available
selling_uom varchar24 1 1 Holds the selling unit of measure for an item's single-unit retail. RK_PRICE_CHANGE NEW_SELLING_UOM VARCHAR2 40 No Not Yet Available
selling_currency varchar23 1 1 Contains the currency code that should match the store's or warehouse's currency code. null varchar2 3 null null
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. null number 1 null null
multi_units number12_4 0 1 The number that indicate how many item is priced in the multi unit selling retail null number 12 null null
multi_unit_retail number20_4 0 1 This field contains the multi-unit retail for the item at the indicated location. null number 20 null null
multi_unit_retail_currency varchar23 0 1 Contains the currency code that should match the store's or warehouse's currency code. null varchar2 3 null null
multi_selling_uom varchar24 0 1 Multi Unit Selling UOM null varchar2 4 null null
ExtOfRegPrcChgDesc:ExtOfRegPrcChgDtl * 0 1 Provide an extension hook to customize RegPrcChgDtl. NA NA NA NA NA NA

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

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