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. |
|
|
|
|
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 |
|
No |
|
end_date |
xs:dateTime |
0 |
1 |
Date image ceases being active |
ITEM_QR_CODE |
END_DATE |
DATE |
|
No |
|