XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for StrItmByInvCriVo 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 |
store_id |
number10 |
1 |
1 |
Store identifier |
STORE_ITEM |
STORE_ID |
VARCHAR2 |
25 |
Yes |
the unique identifier of the item being sold or kept at the location. |
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. |
|
|
|
|
Yes |
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. |
|
|
|
|
Yes |
max no of items to return from query |
inventory_status |
str_itm_inv_status |
1 |
1 |
Include only items with inventory in this status. Valid values are AVAILABLE, UNAVAILABLE. |
|
|
|
|
Yes |
Include only items with inventory in this status. Valid values are AVAILABLE, UNAVAILABLE. |
nonsellable_qty_type_id |
number12 |
0 |
1 |
Include only items with this SIM internal non-sellable quantity type identifier. |
STORE_ITEM_STOCK_NONSELL |
NONSELLABLE_TYPE_ID |
number |
12,0 |
Yes |
The nonsellable quantity type identifier |