Retail Integration Mappings Report Release:15.0.0 (Store Inventory Management)
Application Store Inventory Management
Target Name Space http://www.oracle.com/retail/integration/base/bo/StrItmBySrcCriVo/v1
Version 1.0
Description
XSD Structure

XML-Schema Name:StrItmBySrcCriVo Version:15.0.0 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for StrItmBySrcCriVo 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
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. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes 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 255,400 varchar2 No long / short description of the item.
search_limit number3 1 1 Maximum number of items to return from the query. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Maximum number of items to return from the query.
source_type str_itm_src_type 1 1 Include only items from this source type. Valid values are SUPPLIER, WAREHOUSE, FINISHER. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Include only items from this source type. Valid values are SUPPLIER, WAREHOUSE, FINISHER.
source_id varchar2128 1 1 Include only items from a source with this identifier. SUPPLIER ID VARCHAR2 128 Yes a code to uniquely identify the supplier.