Retail Integration Mappings Report Release:14.1.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.
XSD Structure

XML-Schema Name:RegPrcChgDesc Version:14.1.0 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for RegPrcChgDesc 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 store id
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.

XML-Schema Name:RegPrcChgDtl Version:14.1.0 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for RegPrcChgDtl 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
price_change_id number15 1 1 Contains the ID of the price change that initiated the ticket request. PRICE_CHANGE_WORKSHEET REGULAR_PRICE_CHANGE_ID NUMBER 15,0 No regular price change identifer from pricing engine
item varchar225 1 1 Alphanumeric value that identifies the item for which tickets have been requested. PRICE_CHANGE_WORKSHEET ITEM_ID VARCHAR2 25 Yes Item id
effective_date xs:dateTime 1 1 Price Change Effective Date PRICE_CHANGE_WORKSHEET 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. PRICE_CHANGE_WORKSHEET SELLING_UNIT_CHANGE NUMBER 1,0 No The selling retail price change indicator
selling_unit_retail number20_4 1 1 This field contains the unit retail for the item at the indicated location. PRICE_CHANGE_WORKSHEET SELLING_RETAIL VARCHAR2 12,4 No The selling retail price
selling_uom varchar24 1 1 Holds the selling unit of measure for an item's single-unit retail. PRICE_CHANGE_WORKSHEET SELLING_RETAIL_UOM VARCHAR2 4,0 No The selling retail Unit Of Measure
selling_currency varchar23 1 1 Contains the currency code that should match the store's or warehouse's currency code. PRICE_CHANGE_WORKSHEET SELLING_RETAIL_CURRENCY VARCHAR2 3 No The selling retail 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. PRICE_CHANGE_WORKSHEET MULTI_UNIT_CHANGE NUMBER 1,0 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 PRICE_CHANGE_WORKSHEET MULTI_UNITS NUMBER 12,4 No The price of multiple units
multi_unit_retail number20_4 0 1 This field contains the multi-unit retail for the item at the indicated location. PRICE_CHANGE_WORKSHEET MULTI_UNIT_RETAIL NUMBER 12,4 No The multi-units retail price
multi_unit_retail_currency varchar23 0 1 Contains the currency code that should match the store's or warehouse's currency code. PRICE_CHANGE_WORKSHEET MULTI_UNIT_RETAIL_CURRENCY VARCHAR2 3,0 No The multi-units retail currency
multi_selling_uom varchar24 0 1 Multi Unit Selling UOM PRICE_CHANGE_WORKSHEET MULTI_UNIT_RETAIL_UOM VARCHAR2 4,0 No The multi-units retail Unit Of Measure