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 BDI) |
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 |
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. |
|
|
|
|
No |
valid values are SELLING and STANDARD |