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 |
STORE_ITEM_STOCK |
ITEM_ID |
RIB or/and RSB |
25 |
Yes |
Sku number |
store_id |
number10 |
1 |
1 |
Store identifier |
STORE_ITEM_STOCK. |
STORE_ID |
RIB or/and RSB |
10 |
Yes |
Store identifier |
is_ranged |
xs:boolean |
1 |
1 |
True if item has inventory at the store, otherwise false. |
n/a |
n/a |
RIB or/and RSB |
n/a |
Yes |
True if item has inventory at the store, otherwise false |
is_estimated |
xs:boolean |
1 |
1 |
True if pack item's inventory was estimated from component inventory, otherwise false. |
n/a |
n/a |
RIB or/and RSB |
n/a |
Yes |
True if pack item's inventory was estimated from component inventory, otherwise false. |
uom_code |
varchar24 |
1 |
1 |
Unit of measure code of the quantities. |
ITEM |
UNIT_OF_MEASURE |
RIB or/and RSB |
4 |
Yes |
Unit of measure code of the quantities |
case_size |
number10_2 |
1 |
1 |
Default case size of the item. |
ITEM |
CASE_SIZE |
RIB or/and RSB |
(12,4) |
Yes |
Default case size of the item |
stock_on_hand_qty |
number20_4 |
1 |
1 |
Stock on hand quantity |
STORE_ITEM_STOCK |
QUANTITY_TOTAL |
RIB or/and RSB |
12,4 |
Yes |
total stock quantity |
back_room_qty |
number20_4 |
1 |
1 |
Quantity in the back room area |
STORE_ITEM_STOCK |
n/a |
RIB or/and RSB |
n/a |
Yes |
Quantity in the back room area, |
shop_floor_qty |
number20_4 |
1 |
1 |
Quantity on the shop floor |
STORE_ITEM_STOCK |
QUANTITY_SHOP_FLOOR |
RIB or/and RSB |
12,4 |
Yes |
Quantity on the shop floor |
delivery_bay_qty |
number20_4 |
1 |
1 |
Quantity in delivery bay |
STORE_ITEM_STOCK |
QUANTITY_DELIVERY_BAY |
RIB or/and RSB |
12,4 |
Yes |
Quantity in delivery bay |
available_qty |
number20_4 |
1 |
1 |
Available quantity |
STORE_ITEM_STOCK |
Fill table column name. |
RIB or/and RSB |
Fill column length. |
Yes |
Available quantity, calculated value |
unavailable_qty |
number20_4 |
1 |
1 |
Unavailable quantity |
STORE_ITEM_STOCK |
n/a |
RIB or/and RSB |
n/a |
Yes |
unavailable quantity |
nonsell_total_qty |
number20_4 |
1 |
1 |
Total non-sellable quantity |
STORE_ITEM_STOCK |
QUANTITY_NON_SELLABLE |
RIB or/and RSB |
12,4 |
Yes |
Total non-sellable quantity |
in_transit_qty |
number20_4 |
1 |
1 |
In transit quantity |
STORE_ITEM_STOCK |
QUANTITY_IN_TRANSIT |
RIB or/and RSB |
12,4 |
Yes |
Quantity in transit |
cust_reserved_qty |
number20_4 |
1 |
1 |
Customer reserved quantity |
STORE_ITEM_STOCK |
QUANTITY_CUSTOMER_RESERVE |
RIB or/and RSB |
(12,4) |
Yes |
Customer reserved quantity |
transfer_reserved_qty |
number20_4 |
1 |
1 |
Transfer reserved quantity |
STORE_ITEM_STOCK |
QUANTITY_RESERVED |
RIB or/and RSB |
12,4 |
Yes |
Transfer reserved quantity |
vendor_return_qty |
number20_4 |
1 |
1 |
Vendor return quantity |
STORE_ITEM_STOCK |
QUANTITY_VENDOR_RETURN |
RIB or/and RSB |
12,4 |
Yes |
Vendor return quantity |
StrInvNslQty
|
*
|
0
|
unbounded
|
Collection of non-sellable quantities by specific non-sellable reason.
|
|
|
|
|
|
|