api_external.change_orders
View
Change orders the org shared with the caller for approval. The total is NULL while any line is unpriced; budget coding never appears.
| Column | Type | Nullable | Description |
|---|---|---|---|
| id | uuid | Yes | Change order. |
| project_id | uuid | Yes | Project. |
| change_order_key | text | Yes | Display key. |
| title | text | Yes | Title. |
| change_purpose | text | Yes | Why the change is needed. |
| change_order_state | app.change_order_state | Yes | Internal state: Proposed, Priced, Approved, Rejected or Canceled. |
| total_minor | bigint | Yes | Total in minor units; NULL while unpriced. |
| currency_code | character(3) | Yes | Currency. |