xpms.v_sheet_change_orders
View
The Playbook Change Orders sheet as the database holds it: one row per source row, computed columns reproduced in SQL.
| Column | Type | Nullable | Description |
|---|---|---|---|
| source_row | integer | Yes | Row number in the source sheet. |
| record_id | text | Yes | RECORD ID (column A), field. |
| project_id | text | Yes | PROJECT ID (column B), field. |
| parent_po_number | text | Yes | PARENT PO NUMBER (column C), field. |
| po_line_id | text | Yes | PO LINE ID (column D), field. |
| expense_ref_id | text | Yes | EXPENSE REF ID (column E), field. |
| item_id | text | Yes | ITEM ID (column F), field. |
| vendor_id | text | Yes | VENDOR ID (column G), field. |
| change_order_type | text | Yes | CHANGE ORDER TYPE (column H), field. |
| reason_code | text | Yes | REASON CODE (column I), field. |
| description | text | Yes | DESCRIPTION (column J), field. |
| quantity | text | Yes | QUANTITY (column K), field. |
| unit_rate | text | Yes | UNIT RATE (column L), field. |
| gl_account | text | Yes | GL ACCOUNT (column N), field. |
| cost_center | text | Yes | COST CENTER (column O), field. |
| currency | text | Yes | CURRENCY (column P), field. |
| schedule_impact_days | text | Yes | SCHEDULE IMPACT (DAYS) (column Q), field. |
| client_impact | text | Yes | CLIENT IMPACT (column R), field. |
| justification | text | Yes | JUSTIFICATION (column S), field. |
| requested_by | text | Yes | REQUESTED BY (column T), field. |
| approved_by | text | Yes | APPROVED BY (column U), field. |
| approval_date | text | Yes | APPROVAL DATE (column V), field. |
| status | text | Yes | STATUS (column W), field. |
| flag | text | Yes | FLAG (column X), field. |
| notes | text | Yes | NOTES (column Y), field. |
| created_by | text | Yes | CREATED BY (column Z), field. |
| created_at | text | Yes | CREATED AT (column AA), field. |
| updated_at | text | Yes | UPDATED AT (column AB), field. |
| total_amount | numeric | Yes | TOTAL AMOUNT (column M), computed. |