xpms.v_sheet_vendor_directory

Vista

The Playbook Vendor Directory sheet as the database holds it: one row per source row, computed columns reproduced in SQL.

Columnas de xpms.v_sheet_vendor_directory
Columna	Tipo	Admite nulos	Descripción
source_row	integer	Sí	Row number in the source sheet.
vendor_id	text	Sí	VENDOR ID (column A), field.
department	text	Sí	DEPARTMENT (column D), field.
category	text	Sí	CATEGORY (column E), field.
sub_category	text	Sí	SUB CATEGORY (column F), field.
company	text	Sí	COMPANY (column G), field.
counterparty_type	text	Sí	COUNTERPARTY TYPE (column H), field.
website	text	Sí	WEBSITE (column I), field.
primary_contact	text	Sí	PRIMARY CONTACT (column J), field.
primary_email	text	Sí	PRIMARY EMAIL (column K), field.
primary_phone	text	Sí	PRIMARY PHONE (column L), field.
tax_id	text	Sí	TAX ID (column M), field.
default_gl_account	text	Sí	DEFAULT GL ACCOUNT (column N), field.
default_cost_center	text	Sí	DEFAULT COST CENTER (column O), field.
payment_terms	text	Sí	PAYMENT TERMS (column P), field.
contract	text	Sí	CONTRACT (column Q), field.
w9	text	Sí	W9 (column R), field.
ach_form	text	Sí	ACH FORM (column S), field.
coi	text	Sí	COI (column T), field.
insurance_expiration	text	Sí	INSURANCE EXPIRATION (column U), field.
additional_insured	text	Sí	ADDITIONAL INSURED (column V), field.
status	text	Sí	STATUS (column W), field.
flag	text	Sí	FLAG (column X), field.
notes	text	Sí	NOTES (column Y), field.
created_by	text	Sí	CREATED BY (column Z), field.
created_at	text	Sí	CREATED AT (column AA), field.
updated_at	text	Sí	UPDATED AT (column AB), field.
organization	text	Sí	ORGANIZATION (column B), computed.
project_id	text	Sí	PROJECT ID (column C), computed.