| Name | Description | Type | Additional information |
|---|---|---|---|
| item_number |
Item number (SKU). |
string |
None. |
| description |
Item description |
string |
None. |
| open_wo |
Open quantities in work orders. |
integer |
None. |
| open_po |
Open quantities in purchase orders. |
integer |
None. |
| open_rma |
Open quantities in RMAs. |
integer |
None. |
| on_demand |
Quantity on demand (open orders). |
integer |
None. |
| on_hand |
Quantity on hand. |
integer |
None. |
| on_hold |
Quantity on hold. |
integer |
None. |
| committed |
Quantity on committed. |
integer |
None. |
| in_process |
Quantity in process. |
integer |
None. |
| available |
Helper value. 'available' = 'on_hand' - 'on_hold' - 'committed' - 'in_process'. |
integer |
None. |
| net_available |
Helper value. 'net_available' = 'on_hand' - 'on_hold' - 'committed' - 'in_process' - 'on_demand'. |
integer |
None. |
| inventory_type |
Inventory type (warehouse) |
string |
None. |
| min_quantity | integer |
None. |
|
| dcl_quantity | integer |
None. |
|
| lots |
Item lot detail. |
Collection of lot |
None. |
