app.budget_revised_totals
View
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).
| Column | Type | Nullable | Description |
|---|---|---|---|
| budget_id | uuid | Yes | Budget. |
| project_id | uuid | Yes | Project. |
| currency_code | character(3) | Yes | Currency of the budget. |
| line_count | bigint | Yes | Lines in the budget. |
| unpriced_count | bigint | Yes | Lines whose unit price is NULL. |
| priced_total_minor | bigint | Yes | Sum of the priced lines only. |
| total_minor | bigint | Yes | Original total; NULL while any line is unpriced. |
| actual_minor | bigint | Yes | Approved and paid expenses against the budget. |
| approved_change_count | bigint | Yes | Approved change orders against the budget. |
| approved_change_minor | bigint | Yes | Sum of approved change orders; zero when there are none. |
| revised_total_minor | bigint | Yes | Original total plus approved change orders; NULL while the original total is NULL. |