XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for StrInvDesc 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 |
Sku number |
Fill application table name. |
Fill table column name. |
RIB or/and RSB or/and RSL |
Fill column length. |
Yes |
Fill this description. |
store_id |
number10 |
1 |
1 |
Store identifier |
Fill application table name. |
Fill table column name. |
RIB or/and RSB or/and RSL |
Fill column length. |
Yes |
Fill this description. |
is_ranged |
xs:boolean |
1 |
1 |
True if item has inventory at the store, otherwise false. |
Fill application table name. |
Fill table column name. |
RIB or/and RSB or/and RSL |
Fill column length. |
Yes |
Fill this description. |
is_estimated |
xs:boolean |
1 |
1 |
True if pack item's inventory was estimated from component inventory, otherwise false. |
Fill application table name. |
Fill table column name. |
RIB or/and RSB or/and RSL |
Fill column length. |
Yes |
Fill this description. |
uom_code |
varchar24 |
1 |
1 |
Unit of measure code of the quantities. |
Fill application table name. |
Fill table column name. |
RIB or/and RSB or/and RSL |
Fill column length. |
Yes |
Fill this description. |
case_size |
number10_2 |
1 |
1 |
Default case size of the item. |
Fill application table name. |
Fill table column name. |
RIB or/and RSB or/and RSL |
Fill column length. |
Yes |
Fill this description. |
stock_on_hand_qty |
number20_4 |
1 |
1 |
Stock on hand quantity |
Fill application table name. |
Fill table column name. |
RIB or/and RSB or/and RSL |
Fill column length. |
Yes |
Fill this description. |
back_room_qty |
number20_4 |
1 |
1 |
Quantity in the back room area |
Fill application table name. |
Fill table column name. |
RIB or/and RSB or/and RSL |
Fill column length. |
Yes |
Fill this description. |
shop_floor_qty |
number20_4 |
1 |
1 |
Quantity on the shop floor |
Fill application table name. |
Fill table column name. |
RIB or/and RSB or/and RSL |
Fill column length. |
Yes |
Fill this description. |
delivery_bay_qty |
number20_4 |
1 |
1 |
Quantity in delivery bay |
Fill application table name. |
Fill table column name. |
RIB or/and RSB or/and RSL |
Fill column length. |
Yes |
Fill this description. |
available_qty |
number20_4 |
1 |
1 |
Available quantity |
Fill application table name. |
Fill table column name. |
RIB or/and RSB or/and RSL |
Fill column length. |
Yes |
Fill this description. |
unavailable_qty |
number20_4 |
1 |
1 |
Unavailable quantity |
Fill application table name. |
Fill table column name. |
RIB or/and RSB or/and RSL |
Fill column length. |
Yes |
Fill this description. |
nonsell_total_qty |
number20_4 |
1 |
1 |
Total non-sellable quantity |
Fill application table name. |
Fill table column name. |
RIB or/and RSB or/and RSL |
Fill column length. |
Yes |
Fill this description. |
on_order_qty |
number20_4 |
1 |
1 |
On order quantity |
Fill application table name. |
Fill table column name. |
RIB or/and RSB or/and RSL |
Fill column length. |
Yes |
Fill this description. |
in_transit_qty |
number20_4 |
1 |
1 |
In transit quantity |
Fill application table name. |
Fill table column name. |
RIB or/and RSB or/and RSL |
Fill column length. |
Yes |
Fill this description. |
cust_reserved_qty |
number20_4 |
1 |
1 |
Customer reserved quantity |
Fill application table name. |
Fill table column name. |
RIB or/and RSB or/and RSL |
Fill column length. |
Yes |
Fill this description. |
transfer_reserved_qty |
number20_4 |
1 |
1 |
Transfer reserved quantity |
Fill application table name. |
Fill table column name. |
RIB or/and RSB or/and RSL |
Fill column length. |
Yes |
Fill this description. |
vendor_return_qty |
number20_4 |
1 |
1 |
Vendor return quantity |
Fill application table name. |
Fill table column name. |
RIB or/and RSB or/and RSL |
Fill column length. |
Yes |
Fill this description. |
allocation_total_qty |
number20_4 |
1 |
1 |
Total quantity of allocations |
Fill application table name. |
Fill table column name. |
RIB or/and RSB or/and RSL |
Fill column length. |
Yes |
Fill this description. |
StrInvNslQty
|
*
|
0
|
unbounded
|
Collection of non-sellable quantities by specific non-sellable reason.
|
|
|
|
|
|
|