XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for StrItmByItmCriVo in SIM application. |
SIM's Table Name |
SIM's Column Name |
Integration API(RIB or/and RSB or/and BDI) |
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. |
|
|
|
|
No |
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 the item. |
search_limit |
number3 |
1 |
1 |
Maximum number of items to return from the query. |
|
|
|
|
No |
max no of items to return from query |
item_id_or_barcode |
varchar225 |
0 |
1 |
Include only items matching this sku number or embedded within the barcode. |
ITEM |
ITEM_ID |
VARCHAR2 |
25 |
Yes |
the retailers sku or unique item identifier for items sold or returned. this field is required by sim. |
uin |
varchar2128 |
0 |
1 |
Include only items that have at least one occurance this universal identifier number. |
ITEM_UIN |
UIN |
VARCHAR2 |
128 |
Yes |
an identifier of universal identification number |