org.vendors

Purchase-side parties.

Columns

Column	Type	Notes
id	UUID PK
org_id	UUID FK	→ platform.organizations(id).
name	VARCHAR(255)	UNIQUE per (org_id, lower(name)) — case-insensitive, per org.
address	TEXT
city	VARCHAR(150)
state	VARCHAR(100)
country	CHAR(2)	ISO 3166-1 alpha-2.
zip_code	VARCHAR(20)
term	VARCHAR(50)	Payment term used by this vendor (e.g., Net 30, Net 60, COD).
qbo_id	VARCHAR(100)	UNIQUE per (org_id, qbo_id). QBO sync identifier.
notes	TEXT
is_active	BOOL	NOT NULL. Default true.
created_at	TIMESTAMPTZ	NOT NULL. Default NOW().
updated_at	TIMESTAMPTZ	NOT NULL. Default NOW(). Auto-updated by trigger.

Cross-references

• Used by purchase orders — every PO has a vendor_id (RESTRICT).
• Linked to contacts via entity_contacts.entity_type = 'vendor'.