app.budget_line_amounts
Vista
Budget line amounts, derived: extended amount (NULL when unpriced, never zero), contingency moved in and out, the GL account (the item's explicit default, else by class: decision D13 as owner decision 39 reads it) and approved spend.
| Columna | Tipo | Admite nulos | Descripción |
|---|---|---|---|
| budget_line_id | uuid | Sí | Budget line. |
| budget_id | uuid | Sí | Budget. |
| line_type | app.budget_line_type | Sí | Line type. |
| urid | text | Sí | Dimension 2. |
| account_code | text | Sí | Expense account the line posts to: the priced item's explicit GL default, else the URID class's expense account. |
| extended_minor | bigint | Sí | Quantity times unit price in minor units; NULL when unpriced. |
| is_unpriced | boolean | Sí | True when the unit price is NULL. |
| drawn_in_minor | numeric | Sí | Contingency drawn into the line. |
| drawn_out_minor | numeric | Sí | Contingency drawn out of the line. |
| actual_minor | numeric | Sí | Approved and paid expenses posted to the line. |