app.budget_revised_totals
Vista
Budget totals with approved change orders applied. Only fully priced change orders can be approved, so the approved amount is never unpriced; the revised total is NULL while the budget itself has an unpriced line (Section 3.7).
| 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. |
| total_minor | bigint | Sí | Original total; NULL while any line is unpriced. |
| actual_minor | bigint | Sí | Approved and paid expenses against the budget. |
| approved_change_count | bigint | Sí | Approved change orders against the budget. |
| approved_change_minor | bigint | Sí | Sum of approved change orders; zero when there are none. |
| revised_total_minor | bigint | Sí | Original total plus approved change orders; NULL while the original total is NULL. |