XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for StrItmBySrcCriVo 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 |
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. |
Fill application table name. |
Fill table column name. |
RIB or/and RSB |
Fill column length. |
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 |
255,400 |
varchar2 |
No |
long / short description of the item. |
search_limit |
number3 |
1 |
1 |
Maximum number of items to return from the query. |
Fill application table name. |
Fill table column name. |
RIB or/and RSB |
Fill column length. |
Yes |
Maximum number of items to return from the query. |
source_type |
str_itm_src_type |
1 |
1 |
Include only items from this source type. Valid values are SUPPLIER, WAREHOUSE, FINISHER. |
Fill application table name. |
Fill table column name. |
RIB or/and RSB |
Fill column length. |
Yes |
Include only items from this source type. Valid values are SUPPLIER, WAREHOUSE, FINISHER. |
source_id |
varchar2128 |
1 |
1 |
Include only items from a source with this identifier. |
SUPPLIER |
ID |
VARCHAR2 |
128 |
Yes |
a code to uniquely identify the supplier. |