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 BDI) |
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 |
STORE_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. |
|
|
|
|
No |
available stock on hand quantity.
Available SOH = Total SOH - Transfer Reserved Qty - Customer Reserved Qty - Vendor Return Qty - Non Sellable Qty |
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 |
Fill column length. |
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 |
Indicates if the relationship is mandatory. Valid values are Y or N |