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