XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for ItemSupCtyRef 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 |
varchar225 |
1 |
1 |
Description is not available. |
SUPPLIER_ITEM_COUNTRY |
ITEM_ID |
VARCHAR2 |
25 |
Yes |
the item id |
supplier |
varchar210 |
1 |
1 |
Description is not available. |
SUPPLIER_ITEM_COUNTRY |
SUPPLIER_ID |
VARCHAR2 |
128 |
Yes |
The supplier id |
origin_country_id |
varchar23 |
1 |
1 |
Description is not available. |
SUPPLIER_ITEM_COUNTRY |
COUNTRY_ID |
VARCHAR2 |
3 |
Yes |
typically a 2-letter country code, like us, en, fr |
|