InventoryBalance

Stores real-time inventory balances for items across different locations, warehouses, or subsidiaries.

Columns


Name	Type	References	Description
item [KEY]	Integer		The unique identifier for an inventory item within the system, including stock items, non-inventory items, kits, and more.
quantityavailable	Float		The total quantity of the item currently available for allocation or sale.
binnumber	Integer		The specific bin or storage location where the item is physically stored within a warehouse.
committedqtyperlocation	Float		The quantity of the item that has been allocated to orders at a specific location but not yet shipped.
committedqtyperseriallotnumber	Float		The quantity of the item that has been allocated to orders based on its serial or lot number.
committedqtyperseriallotnumberlocation	Float		The quantity of the item allocated to orders based on both its serial/lot number and warehouse location.
inventorystatus	Integer		The current status of the inventory, which can indicate availability, damage, or restrictions.
location	Integer		The identifier of the warehouse or facility where the item is stored is essential for effective inventory management.
quantityonhand	Float		The total quantity of the item physically present in inventory, including allocated and unallocated stock.
quantitypicked	Float		The quantity of the item that has been selected for fulfillment but not yet shipped from inventory locations.
inventorynumber	Integer		The serial or lot number associated with a specific inventory item for tracking and compliance purposes.