xpms.v_sheet_vendor_classes
Vista
The Playbook Vendor Classes 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 | xpms.canon_text | Sí | RECORD ID (column A), field. |
| department | xpms.canon_text | Sí | DEPARTMENT (column D), field. |
| category | xpms.canon_text | Sí | CATEGORY (column E), field. |
| sub_category | xpms.canon_text | Sí | SUB CATEGORY (column F), field. |
| class | xpms.canon_text | Sí | CLASS (column G), field. |
| description | xpms.canon_text | Sí | DESCRIPTION (column H), field. |
| clearance_tier | xpms.canon_text | Sí | CLEARANCE TIER (column I), field. |
| status | xpms.canon_text | Sí | STATUS (column J), field. |
| flag | boolean | Sí | FLAG (column K), field. |
| notes | xpms.canon_text | Sí | NOTES (column L), field. |
| created_by | xpms.canon_text | Sí | CREATED BY (column M), field. |
| created_at | timestamp without time zone | Sí | CREATED AT (column N), field. |
| updated_at | timestamp without time zone | Sí | UPDATED AT (column O), field. |
| organization | text | Sí | ORGANIZATION (column B), computed. |
| project | text | Sí | PROJECT (column C), computed. |