XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for StrItmHdrDesc 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 |
Item identifier |
ITEM |
ITEM_ID |
VARCHAR2 |
25 |
Yes |
the retailers sku or unique item identifier for items sold or returned. this field is required by sim. |
store_id |
number10 |
0 |
1 |
Store identifier |
STORE_ITEM |
STORE_ID |
NUMBER |
10,0 |
Yes |
the unique identifier of the location that is holding the item. |
item_type |
str_itm_type |
1 |
1 |
Item type Valid values are ITEM, CONSIGNMENT, CONCESSION, NON_INVENTORY, PACK_SIMPLE, PACK_COMPLEX, PACK_SIMPLE_BREAKABLE, PACK_COMPLEX_BREAKABLE, UNKNOWN. |
ITEM |
ITEM_TYPE |
NUMBER |
2,0 |
Yes |
Indicates the type of item. Possible values are
0 - Item,
5 - Consignment,
10- Concession,
12 - Non Inventory,
15 - Simple Pack,
20 - Complex Pack,
25 - Simple Breakable Pack,
30 - Complex Breakable Pack |
short_description |
varchar2120 |
1 |
1 |
Short description |
ITEM |
SHORT_DESCRIPTION |
VARCHAR2 |
255 |
No |
the textural description of the item and its characteristics. |
long_description |
varchar2250 |
0 |
1 |
Long description |
ITEM |
LONG_DESCRIPTION |
VARCHAR2 |
400 |
No |
long description of the item. |
department_name |
varchar2120 |
0 |
1 |
Merchandise hierarchy department name |
ITEM |
DEPARTMENT_ID |
number |
12,0 |
No |
hierarchy department id |
class_name |
varchar2120 |
0 |
1 |
Merchandise hierarchy class name |
ITEM |
CLASS_ID |
number |
12,0 |
No |
hierarchy class id |
subclass_name |
varchar2120 |
0 |
1 |
Merchandise hierarchy subclass name. |
ITEM |
SUBCLASS_ID |
NUMBER |
12,0 |
Yes |
hierarchy subclass id |
primary_supplier_id |
varchar2128 |
0 |
1 |
Primary supplier identifier |
STORE_ITEM |
PRIMARY_SUPPLIER_ID |
varchar2 |
128 |
No |
the unique identifier of the supplier that is the default primary supplier for the item at this location. |
primary_supplier_name |
varchar240 |
0 |
1 |
Primary supplier name |
SUPPLIER |
NAME |
VARCHAR2 |
240 |
No |
the name of the supplier. |
ranged |
xs:boolean |
1 |
1 |
True if inventory exists at the criteria input store, false otherwise. |
Fill application table name. |
Fill table column name. |
RIB or/and RSB |
Fill column length. |
Yes |
True if inventory exists at the criteria input store, false otherwise. |