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 BDI) |
SIM's Column Length |
Is Column Required in SIM's API? |
SIM's API Description |
item_id |
varchar225 |
1 |
1 |
Sku number |
ITEM |
ITEM_ID |
VARCHAR2 |
25 |
Yes |
Sku number |
store_id |
number10 |
1 |
1 |
Store identifier |
STORE_ITEM_STOCK. |
STORE_ID |
NUMBER |
10 |
Yes |
Store identifier |
is_ranged |
xs:boolean |
1 |
1 |
True if item has inventory at the store, otherwise false. |
|
|
|
|
No |
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. |
|
|
|
|
No |
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 |
VARCHAR2 |
4 |
Yes |
Unit of measure code of the quantities |
case_size |
number10_2 |
1 |
1 |
Default case size of the item. |
ITEM |
CASE_SIZE |
NUMBER |
(12,4) |
No |
Default case size of the item |
stock_on_hand_qty |
number20_4 |
1 |
1 |
Stock on hand quantity |
STORE_ITEM_STOCK |
QUANTITY_TOTAL |
NUMBER |
12,4 |
Yes |
total stock quantity |
back_room_qty |
number20_4 |
1 |
1 |
Quantity in the back room area |
|
|
|
|
No |
Quantity in the back room area, |
shop_floor_qty |
number20_4 |
1 |
1 |
Quantity on the shop floor |
STORE_ITEM_STOCK |
QUANTITY_SHOP_FLOOR |
NUMBER |
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 |
NUMBER |
12,4 |
Yes |
Quantity in delivery bay |
available_qty |
number20_4 |
1 |
1 |
Available quantity |
|
|
|
|
No |
Available quantity, calculated value |
unavailable_qty |
number20_4 |
1 |
1 |
Unavailable quantity |
|
|
|
|
No |
unavailable quantity, calculated value. |
nonsell_total_qty |
number20_4 |
1 |
1 |
Total non-sellable quantity |
STORE_ITEM_STOCK |
QUANTITY_NON_SELLABLE |
NUMBER |
12,4 |
Yes |
Total non-sellable quantity |
in_transit_qty |
number20_4 |
1 |
1 |
In transit quantity |
STORE_ITEM_STOCK |
QUANTITY_IN_TRANSIT |
NUMBER |
12,4 |
Yes |
Quantity in transit |
cust_reserved_qty |
number20_4 |
1 |
1 |
Customer reserved quantity |
STORE_ITEM_STOCK |
QUANTITY_CUSTOMER_RESERVE |
NUMBER |
(12,4) |
Yes |
Customer reserved quantity |
transfer_reserved_qty |
number20_4 |
1 |
1 |
Transfer reserved quantity |
STORE_ITEM_STOCK |
QUANTITY_RESERVED |
NUMBER |
12,4 |
Yes |
Transfer reserved quantity |
vendor_return_qty |
number20_4 |
1 |
1 |
Vendor return quantity |
STORE_ITEM_STOCK |
QUANTITY_VENDOR_RETURN |
NUMBER |
12,4 |
Yes |
Vendor return quantity |
StrInvNslQty
|
*
|
0
|
unbounded
|
Collection of non-sellable quantities by specific non-sellable reason.
|
|
|
|
|
|
|