app.asset_lot_balances
View
Quantity on hand per live lot: the opening count plus every ledger delta. Derived, never stored.
| Column | Type | Nullable | Description |
|---|---|---|---|
| asset_lot_id | uuid | Yes | Lot. |
| org_id | uuid | Yes | Owning org. |
| opening_quantity | numeric | Yes | Opening count. |
| on_hand | numeric | Yes | Quantity on hand now. |