XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for StrItmRelDesc 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 |
Related sku number |
RELATED_ITEM |
ITEM_ID |
VARCHAR2 |
25 |
Yes |
Item whose related items are recorded |
short_description |
varchar2120 |
1 |
1 |
Short description |
ITEM |
SHORT_DESCRIPTION |
VARCHAR2 |
255 |
Yes |
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. |
unit_of_measure |
varchar225 |
1 |
1 |
Unit of measure |
ITEM |
UNIT_OF_MEASURE |
VARCHAR2 |
4 |
Yes |
unit of measure which the stock for this item is tracked at the coporate level. |
available_soh_qty |
number12_4 |
0 |
1 |
Available stock on hand quantity. |
STORE_ITEM_STOCK |
QUANTITY_RESERVED, QUANTITY_CUSTOMER_RESERVE, QUANTITY_NON_SELLABLE, QUANTITY_VENDOR_RETURN |
12,4 |
NUMBER |
Yes |
available stock on hand quantity |
diff_type1 |
varchar210 |
0 |
1 |
Item differentiator type 1. |
DIFFERENTIATOR_TYPE |
DESCRIPTION |
varchar2 |
255 |
Yes |
contains the diff type description. |
diff_description1 |
varchar2255 |
0 |
1 |
Item differentiator type 1 description. |
DIFFERENTIATOR |
DESCRIPTION |
varchar2 |
255 |
Yes |
description of the differential number. (for example, blueberry, shower fresh, red, etc.) |
diff_type2 |
varchar210 |
0 |
1 |
Item differentiator type 2. |
DIFFERENTIATOR_TYPE |
DESCRIPTION |
varchar2 |
255 |
Yes |
contains the diff type description. |
diff_description2 |
varchar2255 |
0 |
1 |
Item differentiator type 2 description. |
DIFFERENTIATOR |
DESCRIPTION |
varchar2 |
255 |
Yes |
description of the differential number. (for example, blueberry, shower fresh, red, etc.) |
diff_type3 |
varchar210 |
0 |
1 |
Item differentiator type 3. |
DIFFERENTIATOR_TYPE |
DESCRIPTION |
varchar2 |
255. |
Yes |
contains the diff type description. |
diff_description3 |
varchar2255 |
0 |
1 |
Item differentiator type 3 description. |
DIFFERENTIATOR |
DESCRIPTION |
varchar2 |
255 |
Yes |
description of the differential number. (for example, blueberry, shower fresh, red, etc.) |
diff_type4 |
varchar210 |
0 |
1 |
Item differentiator type 4. |
DIFFERENTIATOR_TYPE |
DESCRIPTION |
varchar2 |
255 |
Yes |
contains the diff type description. |
diff_description4 |
varchar2255 |
0 |
1 |
Item differentiator type 4 description. |
DIFFERENTIATOR |
DESCRIPTION |
varchar2 |
255 |
Yes |
description of the differential number. (for example, blueberry, shower fresh, red, etc.) |
effective_date |
xs:dateTime |
0 |
1 |
The date this related item becomes effective. |
RELATED_ITEM |
EFFECTIVE_DATE |
date |
|
No |
Date from which this relationship is effective |
end_date |
xs:dateTime |
0 |
1 |
The date this related item is no longer effective. |
RELATED_ITEM |
END_DATE |
date |
|
No |
Date till when this relationship is effective |
relationship_type |
varchar26 |
1 |
1 |
Relationship type |
RELATED_ITEM |
RELATIONSHIP_TYPE |
VARCHAR2 |
6 |
Yes |
Relationship type. valid values
RLTD - Related,
SUBS - Substitute,
UPSL - Upsell,
CSSL - Crosssell |
mandatory_ind |
xs:boolean |
1 |
1 |
Mandatory indicator |
RELATED_ITEM |
MANDATORY_IND |
VARCHAR2 |
1 |
Yes |
Fill this description. |