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/StrItmByUdaCriVo/v1
Version 1.0
Description
XSD Structure

XML-Schema Name:StrItmByUdaCriVo 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 StrItmByUdaCriVo 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
store_id number10 1 1 Store identifier STORE_ITEM STORE_ID NUMBER 10,0 Yes the unique identifier of the location that is holding the item.
department_id number12 0 1 Include only items with this merchandise hierarchy department identifier. ITEM DEPARTMENT_ID NUMBER 12,0 No hierarchy department id
class_id number12 0 1 Include only items with this merchandise hierarchy class identifier. ITEM CLASS_ID NUMBER 12,0 No hierarchy class id
subclass_id number12 0 1 Include only items with this merchandise hierarchy subclass identifier ITEM SUBCLASS_ID NUMBER 12,0 No hierarchy subclass id
include_non_ranged xs:boolean 1 1 True if should include non-ranged items, false if only ranged items. . No True if should include non-ranged items, false if only ranged items.
item_description varchar2250 0 1 Include only items containing this description. ITEM SHORT_DESCRIPTION, LONG_DESCRIPTION VARCHAR2 255, 400 No short / long description of item
search_limit number3 1 1 Maximum number of items to return from the query. No Maximum number of items to return from the query.
text_uda_id number5 0 1 Include only items that contain this text type user defined attribute identifier. ITEM_UDA UDA_ID NUMBER 5 Yes UDA Identifier.
uda_text varchar2120 0 1 Include only items that contain this user defined attribute text. This field is required if text_uda_id exists. ITEM_UDA UDA_TEXT VARCHAR2 250 No Holds the value of uda display type of FF (free form text)
value_uda_id number5 0 1 Include only items that contain this value type user defined attribute identifier. ITEM_UDA UDA_ID NUMBER 5 Yes UDA Identifier
uda_value varchar225 0 1 Include only items with uda(s) containing this value. This field is required if value_uda_id exists. ITEM_UDA UDA_LOV_ID VARCHAR2 25 No Holds the value of uda display type of LOV for numeric data
date_uda_id number5 0 1 Include only items that contain this date type user defined attribute identifier. ITEM_UDA UDA_ID NUMBER 5 Yes UDA Identifier.
uda_date_from xs:dateTime 0 1 Include only items with uda(s) after this date. This field is required if date_uda_id exists. ITEM_UDA UDA_DATE DATE No Holds the value of uda display type of DT (date)
uda_date_to xs:dateTime 0 1 Include only items with uda(s) before this date. This field is required if date_uda_id exists. ITEM_UDA UDA_DATE DATE No Include only items with uda(s) before this date. This field is required if date_uda_id exists.