app.budget_totals
Vista
Budget totals, NULL-aware: the total is NULL while any line is unpriced, with the unpriced count and the priced subtotal beside it (Section 3.7, invariant 11).
| Columna | Tipo | Admite nulos | Descripción |
|---|---|---|---|
| budget_id | uuid | Sí | Budget. |
| project_id | uuid | Sí | Project. |
| currency_code | character(3) | Sí | Currency of the budget. |
| line_count | bigint | Sí | Lines in the budget. |
| unpriced_count | bigint | Sí | Lines whose unit price is NULL. |
| priced_total_minor | bigint | Sí | Sum of the priced lines only; NULL when no line is priced. |
| total_minor | bigint | Sí | Budget total; NULL while any line is unpriced or the budget has no lines. |
| actual_minor | bigint | Sí | Approved and paid expenses against the budget. |