app.change_order_line_facts
Vista
One row per live change order line with its dimensions and NULL-aware amount. A line that adjusts a budget line inherits that line's cost center.
| Columna | Tipo | Admite nulos | Descripción |
|---|---|---|---|
| change_order_line_id | uuid | Sí | Change order line. |
| change_order_id | uuid | Sí | Change order. |
| project_id | uuid | Sí | Project. |
| budget_id | uuid | Sí | Budget the change order amends. |
| change_order_state | app.change_order_state | Sí | State of the change order. |
| budget_line_id | uuid | Sí | Budget line adjusted, when the change adjusts one. |
| urid | text | Sí | Dimension 2 of the change. |
| dept_code | text | Sí | Department class of the URID. |
| account_code | text | Sí | Expense account of the change: the explicit GL default of the item the adjusted budget line prices, when the change keeps that line's URID, else the URID class's expense account (decision D13 as owner decision 39 reads it). |
| cost_center_id | uuid | Sí | Cost center of the adjusted budget line. |
| extended_minor | bigint | Sí | Quantity times unit price; NULL when unpriced. |
| is_unpriced | boolean | Sí | True when the unit price is NULL. |