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

XML-Schema Name:StrItmByInvCriVo 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 StrItmByInvCriVo 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 VARCHAR2 25 Yes the unique identifier of the item being sold or kept at the location.
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 VARCHAR2 255, 400 No short/long description of 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 max no of items to return from query
inventory_status str_itm_inv_status 1 1 Include only items with inventory in this status. Valid values are AVAILABLE, UNAVAILABLE. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Include only items with inventory in this status. Valid values are AVAILABLE, UNAVAILABLE.
nonsellable_qty_type_id number12 0 1 Include only items with this SIM internal non-sellable quantity type identifier. STORE_ITEM_STOCK_NONSELL NONSELLABLE_TYPE_ID number 12,0 Yes The nonsellable quantity type identifier