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

XML-Schema Name:StrItmImgColDesc 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 StrItmImgColDesc 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
StrItmImgDesc:StrItmImgDesc * 0 unbounded Collection of store item images. 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:StrItmImgDesc 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 StrItmImgDesc 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 Sku number ITEM_IMAGE ITEM_ID varchar2 25 Yes the item id from item table
store_id number10 0 1 Store identifier. This field is required if the type is QR_CODE. ITEM_QR_CODE STORE_ID NUMBER 10,0 Yes Store Identifier
url varchar21000 1 1 Universal resource locator ITEM_QR_CODE IMAGE_URL varchar2 1000 Yes URL to the image location
type StrItmImageType 1 1 Type Valid values are IMAGE, QR_CODE, UNKNOWN. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes possible values are IMAGE, QR_CODE
name varchar2120 1 1 Name ITEM_QR_CODE IMAGE_NAME VARCHAR2 120 Yes Name of image
start_date xs:dateTime 0 1 Date image becomes active. ITEM_QR_CODE START_DATE DATE Fill column length. No Fill this description.
end_date xs:dateTime 0 1 Date image ceases being active ITEM_QR_CODE END_DATE DATE Fill column length. No Fill this description.