xpms.v_sheet_vendor_directory
View
The Playbook Vendor Directory 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. |
| vendor_id | text | Yes | VENDOR ID (column A), field. |
| department | text | Yes | DEPARTMENT (column D), field. |
| category | text | Yes | CATEGORY (column E), field. |
| sub_category | text | Yes | SUB CATEGORY (column F), field. |
| company | text | Yes | COMPANY (column G), field. |
| counterparty_type | text | Yes | COUNTERPARTY TYPE (column H), field. |
| website | text | Yes | WEBSITE (column I), field. |
| primary_contact | text | Yes | PRIMARY CONTACT (column J), field. |
| primary_email | text | Yes | PRIMARY EMAIL (column K), field. |
| primary_phone | text | Yes | PRIMARY PHONE (column L), field. |
| tax_id | text | Yes | TAX ID (column M), field. |
| default_gl_account | text | Yes | DEFAULT GL ACCOUNT (column N), field. |
| default_cost_center | text | Yes | DEFAULT COST CENTER (column O), field. |
| payment_terms | text | Yes | PAYMENT TERMS (column P), field. |
| contract | text | Yes | CONTRACT (column Q), field. |
| w9 | text | Yes | W9 (column R), field. |
| ach_form | text | Yes | ACH FORM (column S), field. |
| coi | text | Yes | COI (column T), field. |
| insurance_expiration | text | Yes | INSURANCE EXPIRATION (column U), field. |
| additional_insured | text | Yes | ADDITIONAL INSURED (column V), field. |
| status | text | Yes | STATUS (column W), field. |
| flag | text | Yes | FLAG (column X), field. |
| notes | text | Yes | NOTES (column Y), field. |
| created_by | text | Yes | CREATED BY (column Z), field. |
| created_at | text | Yes | CREATED AT (column AA), field. |
| updated_at | text | Yes | UPDATED AT (column AB), field. |
| organization | text | Yes | ORGANIZATION (column B), computed. |
| project_id | text | Yes | PROJECT ID (column C), computed. |