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

XML-Schema Name:StrItmHdrColDesc 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 StrItmHdrColDesc 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
StrItmHdrDesc:StrItmHdrDesc * 0 unbounded Collection of store item headers NA NA NA NA NA NA
collection_size number4 1 1 Size of the collection. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.

XML-Schema Name:StrItmHdrDesc 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 StrItmHdrDesc 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
item_id varchar225 1 1 Item identifier ITEM ITEM_ID VARCHAR2 25 Yes the retailers sku or unique item identifier for items sold or returned. this field is required by sim.
store_id number10 0 1 Store identifier STORE_ITEM STORE_ID NUMBER 10,0 Yes the unique identifier of the location that is holding the item.
item_type str_itm_type 1 1 Item type Valid values are ITEM, CONSIGNMENT, CONCESSION, NON_INVENTORY, PACK_SIMPLE, PACK_COMPLEX, PACK_SIMPLE_BREAKABLE, PACK_COMPLEX_BREAKABLE, UNKNOWN. ITEM ITEM_TYPE NUMBER 2,0 Yes Indicates the type of item. Possible values are 0 - Item, 5 - Consignment, 10- Concession, 12 - Non Inventory, 15 - Simple Pack, 20 - Complex Pack, 25 - Simple Breakable Pack, 30 - Complex Breakable Pack
short_description varchar2120 1 1 Short description ITEM SHORT_DESCRIPTION VARCHAR2 255 No the textural description of the item and its characteristics.
long_description varchar2250 0 1 Long description ITEM LONG_DESCRIPTION VARCHAR2 400 No long description of the item.
department_name varchar2120 0 1 Merchandise hierarchy department name ITEM DEPARTMENT_ID number 12,0 No hierarchy department id
class_name varchar2120 0 1 Merchandise hierarchy class name ITEM CLASS_ID number 12,0 No hierarchy class id
subclass_name varchar2120 0 1 Merchandise hierarchy subclass name. ITEM SUBCLASS_ID NUMBER 12,0 Yes hierarchy subclass id
primary_supplier_id varchar2128 0 1 Primary supplier identifier STORE_ITEM PRIMARY_SUPPLIER_ID varchar2 128 No the unique identifier of the supplier that is the default primary supplier for the item at this location.
primary_supplier_name varchar240 0 1 Primary supplier name SUPPLIER NAME VARCHAR2 240 No the name of the supplier.
ranged xs:boolean 1 1 True if inventory exists at the criteria input store, false otherwise. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes True if inventory exists at the criteria input store, false otherwise.