xpms.v_sheet_vendor_entitlements
View
The Playbook Vendor Entitlements 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 | xpms.canon_text | Yes | RECORD ID (column A), field. |
| vendor_class | xpms.canon_text | Yes | VENDOR CLASS (column D), field. |
| module | xpms.canon_text | Yes | MODULE (column E), field. |
| permitted | boolean | Yes | PERMITTED (column F), field. |
| status | xpms.canon_text | Yes | STATUS (column G), field. |
| flag | boolean | Yes | FLAG (column H), field. |
| notes | xpms.canon_text | Yes | NOTES (column I), field. |
| created_by | xpms.canon_text | Yes | CREATED BY (column J), field. |
| created_at | timestamp without time zone | Yes | CREATED AT (column K), field. |
| updated_at | timestamp without time zone | Yes | UPDATED AT (column L), field. |
| organization | text | Yes | ORGANIZATION (column B), computed. |
| project | text | Yes | PROJECT (column C), computed. |