xpms.v_sheet_budget_expenses
Vista
The Playbook Budget Expenses 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. |
| event | text | Sí | EVENT (column C), field. |
| location | text | Sí | LOCATION (column D), field. |
| zone | text | Sí | ZONE (column E), field. |
| space | text | Sí | SPACE (column F), field. |
| activation | text | Sí | ACTIVATION (column G), field. |
| department | text | Sí | DEPARTMENT (column H), field. |
| discipline | text | Sí | DISCIPLINE (column I), field. |
| category | text | Sí | CATEGORY (column J), field. |
| sub_category | text | Sí | SUB CATEGORY (column K), field. |
| item | text | Sí | ITEM (column L), field. |
| description | text | Sí | DESCRIPTION (column M), field. |
| urid | text | Sí | URID (column N), field. |
| phase | text | Sí | PHASE (column O), field. |
| tier | text | Sí | TIER (column P), field. |
| xyz | text | Sí | XYZ (column Q), field. |
| line_type | text | Sí | LINE TYPE (column R), field. |
| quantity | text | Sí | QUANTITY (column S), field. |
| unit_basis | text | Sí | UNIT BASIS (column U), field. |
| actual | text | Sí | ACTUAL (column Z), field. |
| vendor | text | Sí | VENDOR (column AB), field. |
| status | text | Sí | STATUS (column AC), field. |
| flag | text | Sí | FLAG (column AD), field. |
| external_notes | text | Sí | EXTERNAL NOTES (column AE), field. |
| internal_notes | text | Sí | INTERNAL NOTES (column AF), field. |
| account_code | text | Sí | ACCOUNT CODE (column AG), field. |
| cost_center | text | Sí | COST CENTER (column AI), field. |
| urid_dimension | text | Sí | URID DIMENSION (column AJ), field. |
| tax_type | text | Sí | TAX TYPE (column AK), field. |
| currency | text | Sí | CURRENCY (column AL), field. |
| created_by | text | Sí | CREATED BY (column AM), field. |
| created_at | text | Sí | CREATED AT (column AN), field. |
| updated_at | text | Sí | UPDATED AT (column AO), field. |
| rate | numeric | Sí | RATE (column T), computed. |
| estimate | numeric | Sí | ESTIMATE (column V), computed. |
| budget | numeric | Sí | BUDGET (column W), computed. |
| committed | numeric | Sí | COMMITTED (column X), computed. |
| forecast | numeric | Sí | FORECAST (column Y), computed. |
| variance | numeric | Sí | VARIANCE (column AA), computed. |
| account_name | xpms.canon_text | Sí | ACCOUNT NAME (column AH), computed. |