XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for StrInvCriVo 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_col |
varchar225 |
1 |
10 |
Collection of sku numbers |
STORE_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_col |
number10 |
1 |
100 |
Collection of store identifiers |
STORE_ITEM_STOCK |
STORE_ID |
number |
10,0 |
Yes |
the unique identifier of the location that is holding the item. |
uom_type |
StrInvUomType |
1 |
1 |
Type of unit of measure to attempt to return quantities. Will default to STANDARD if unable to perform a unit of measure conversion. Valid values are STANDARD, SELLING. |
n/a |
n/a |
RIB or/and RSB |
n/a |
Yes |
valid values are SELLING and STANDARD |