app.purchase_order_totals
View
Purchase order totals, NULL-aware, with approved change order deltas beside them.
| Column | Type | Nullable | Description |
|---|---|---|---|
| purchase_order_id | uuid | Yes | Purchase order. |
| project_id | uuid | Yes | Project. |
| currency_code | character(3) | Yes | Currency. |
| unpriced_count | bigint | Yes | Lines whose unit price is NULL. |
| lines_total_minor | bigint | Yes | Sum of the lines; NULL while any line is unpriced. |
| approved_changes_minor | bigint | Yes | Sum of approved change order deltas; NULL when there are none. |