app.asset_lot_balances
Vista
Quantity on hand per live lot: the opening count plus every ledger delta. Derived, never stored.
| Columna | Tipo | Admite nulos | Descripción |
|---|---|---|---|
| asset_lot_id | uuid | Sí | Lot. |
| org_id | uuid | Sí | Owning org. |
| opening_quantity | numeric | Sí | Opening count. |
| on_hand | numeric | Sí | Quantity on hand now. |