Retail Integration Bus Mappings Report Release:13.2.0 (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.2.0 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 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). Not Yet Available Indicates the type of location which has requested tickets. Valid values for this field are: 'W' (for warehouse) and 'S' (for store).
RegPrcChgDtl * 1 unbounded Description is not available.
ExtOfRegPrcChgDesc:ExtOfRegPrcChgDesc * 0 1 Provide an extension hook to customize RegPrcChgDesc. NA NA NA NA NA NA
LocOfRegPrcChgDesc:LocOfRegPrcChgDesc * 0 1 Provide an extension hook to localize RegPrcChgDesc. NA NA NA NA NA NA

XML-Schema Name:RegPrcChgDtl Version:13.2.0 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 PRICE_CHANGE_ID NUMBER 128 Yes Contains the ID of the price change that initiated the ticket request.
item varchar225 1 1 Alphanumeric value that identifies the item for which tickets have been requested. RK_PRICE_CHANGE ID_ITM VARCHAR2 25 No Alphanumeric value that identifies the item for which tickets have been requested.
effective_date xs:dateTime 1 1 Price Change Effective Date RK_PRICE_CHANGE EFFECTIVE_DATE DATE No Price Change Effective Date
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. RK_PRICE_CHANGE SELLING_UNIT_CHANGE_IND number 1 No Indicates whether the selling retail price has been changed. Valid values are '0' - no change or '1' - retail is changed.
selling_unit_retail number20_4 1 1 This field contains the unit retail for the item at the indicated location. RK_PRICE_CHANGE UNIT_RETAIL VARCHAR2 75 No This field contains the unit retail for the item at the indicated location.
selling_uom varchar24 1 1 Holds the selling unit of measure for an item's single-unit retail. RK_PRICE_CHANGE SELLING_UOM VARCHAR2 40 No Holds the selling unit of measure for an item's single-unit retail.
selling_currency varchar23 1 1 Contains the currency code that should match the store's or warehouse's currency code. RK_PRICE_CHANGE SELLING_RETAIL_CURRENCY varchar2 3 No Contains the currency code that should match the store's or warehouse's currency code.
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. RK_PRICE_CHANGE MULTI_UNIT_CHANGED_IND number 1 No Indicates whether the retail for multi units has been changed. Valid values are '0' - no change or '1' - retail is changed. Default value is 0
multi_units number12_4 0 1 The number that indicate how many item is priced in the multi unit selling retail RK_PRICE_CHANGE MULTI_UNITS number 12 No The number that indicate how many item is priced in the multi unit selling retail
multi_unit_retail number20_4 0 1 This field contains the multi-unit retail for the item at the indicated location. RK_PRICE_CHANGE MULTI_UNIT_RETAIL VARCHAR2 75 No This field contains the multi-unit retail for the item at the indicated location.
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 RK_PRICE_CHANGE MULTI_SELLING_UOM varchar2 40 No Multi Unit Selling UOM
ExtOfRegPrcChgDesc:ExtOfRegPrcChgDtl * 0 1 Provide an extension hook to customize RegPrcChgDtl. NA NA NA NA NA NA
LocOfRegPrcChgDesc:LocOfRegPrcChgDtl * 0 1 Provide an extension hook to localize RegPrcChgDtl. NA NA NA NA NA NA

XML-Schema Name:ExtOfRegPrcChgDtl Version:13.2.0 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:LocOfRegPrcChgDtl Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description sim Mapping For LocOfRegPrcChgDtl
Table Name Column Name API Type Column Length API Required API Description
InRegPrcChgDesc:InRegPrcChgDtl * 0 unbounded India Localization. NA NA NA NA NA NA
BrRegPrcChgDesc:BrRegPrcChgDtl * 0 unbounded Brazil Localization. NA NA NA NA NA NA

XML-Schema Name:ExtOfRegPrcChgDesc Version:13.2.0 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

XML-Schema Name:LocOfRegPrcChgDesc Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description sim Mapping For LocOfRegPrcChgDesc
Table Name Column Name API Type Column Length API Required API Description
InRegPrcChgDesc:InRegPrcChgDesc * 0 unbounded India Localization. NA NA NA NA NA NA
BrRegPrcChgDesc:BrRegPrcChgDesc * 0 unbounded Brazil Localization. NA NA NA NA NA NA