xpms.v_sheet_categories_urid_master
View
The Playbook Categories & URID Master 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. |
| urid | text | Yes | URID (column A), field. |
| department | text | Yes | DEPARTMENT (column B), field. |
| discipline | text | Yes | DISCIPLINE (column C), field. |
| category | text | Yes | CATEGORY (column D), field. |
| default_cost_center | text | Yes | DEFAULT COST CENTER (column E), field. |
| default_gl_account | text | Yes | DEFAULT GL ACCOUNT (column F), field. |
| schema_family_xyz | text | Yes | SCHEMA FAMILY (XYZ) (column G), field. |
| status | text | Yes | STATUS (column H), field. |
| created_by | text | Yes | CREATED BY (column I), field. |
| created_at | text | Yes | CREATED AT (column J), field. |
| updated_at | text | Yes | UPDATED AT (column K), field. |