XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for StrItmByUdaCriVo 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 item |
search_limit |
number3 |
1 |
1 |
Maximum number of items to return from the query. |
|
|
|
|
No |
Maximum number of items to return from the query. |
text_uda_id |
number5 |
0 |
1 |
Include only items that contain this text type user defined attribute identifier. |
ITEM_UDA |
UDA_ID |
NUMBER |
5 |
Yes |
UDA Identifier. |
uda_text |
varchar2120 |
0 |
1 |
Include only items that contain this user defined attribute text. This field is required if text_uda_id exists. |
ITEM_UDA |
UDA_TEXT |
VARCHAR2 |
250 |
No |
Holds the value of uda display type of FF (free form text) |
value_uda_id |
number5 |
0 |
1 |
Include only items that contain this value type user defined attribute identifier. |
ITEM_UDA |
UDA_ID |
NUMBER |
5 |
Yes |
UDA Identifier |
uda_value |
varchar225 |
0 |
1 |
Include only items with uda(s) containing this value. This field is required if value_uda_id exists. |
ITEM_UDA |
UDA_LOV_ID |
VARCHAR2 |
25 |
No |
Holds the value of uda display type of LOV for numeric data |
date_uda_id |
number5 |
0 |
1 |
Include only items that contain this date type user defined attribute identifier. |
ITEM_UDA |
UDA_ID |
NUMBER |
5 |
Yes |
UDA Identifier. |
uda_date_from |
xs:dateTime |
0 |
1 |
Include only items with uda(s) after this date. This field is required if date_uda_id exists. |
ITEM_UDA |
UDA_DATE |
DATE |
|
No |
Holds the value of uda display type of DT (date) |
uda_date_to |
xs:dateTime |
0 |
1 |
Include only items with uda(s) before this date. This field is required if date_uda_id exists. |
ITEM_UDA |
UDA_DATE |
DATE |
|
No |
Include only items with uda(s) before this date. This field is required if date_uda_id exists. |