InventoryBalance
The InventoryBalance table.
Columns
| Name | Type | References | Description |
| item [KEY] | Integer | Item | |
| quantityavailable | Float | Available Quantity | |
| binnumber | Integer | Bin | |
| committedqtyperlocation | Float | Committed Quantity (Per Location) | |
| committedqtyperseriallotnumber | Float | Committed Quantity (Per Serial/Lot Number) | |
| committedqtyperseriallotnumberlocation | Float | Committed Quantity (Per Serial/Lot Number & Location) | |
| inventorystatus | Integer | Inventory Status | |
| location | Integer | Location | |
| quantityonhand | Float | On-Hand Quantity | |
| quantitypicked | Float | Picked Quantity | |
| inventorynumber | Integer | Serial/Lot Number |