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 BDI) |
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. |
STORE_ITEM, ITEM |
ITEM_TYPE |
NUMBER |
2,0 |
Yes |
Indicates the type of item. Possible values are:0 - Item,15 - Simple Pack,20 - Complex Pack,25 - Simple Breakable Pack,30 - Complex Breakable Pack |
short_description |
varchar2120 |
1 |
1 |
Short description |
STORE_ITEM, ITEM |
SHORT_DESCRIPTION |
VARCHAR2 |
255 |
No |
the textural description of the item and its characteristics. |
long_description |
varchar2250 |
0 |
1 |
Long description |
STORE_ITEM, ITEM |
LONG_DESCRIPTION |
VARCHAR2 |
400 |
No |
long description of the item. |
department_name |
varchar2120 |
0 |
1 |
Merchandise hierarchy department name |
ITEM_HIERARCHY |
DEPARTMENT_NAME |
VARCHAR2 |
360 |
No |
hierarchy department name |
class_name |
varchar2120 |
0 |
1 |
Merchandise hierarchy class name |
ITEM_HIERARCHY |
CLASS_NAME |
VARCHAR2 |
360 |
No |
hierarchy class name |
subclass_name |
varchar2120 |
0 |
1 |
Merchandise hierarchy subclass name. |
ITEM_HIERARCHY |
SUBCLASS_NAME |
VARCHAR2 |
360 |
No |
hierarchy subclass name |
primary_supplier_id |
varchar2128 |
0 |
1 |
Primary supplier identifier |
STORE_ITEM |
PRIMARY_SUPPLIER_ID |
NUMBER |
10 |
No |
the unique identifier of the supplier that is the default primary supplier for the item at this location. |
primary_supplier_name |
varchar2240 |
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. |
|
|
|
|
No |
True if inventory exists at the criteria input store, false otherwise. |