ZenotiHelp

Vendor Dimension Table

ZTZenoti Docs Team Updated April 10, 2026 1 min readGuide

Dimension table storing vendor (supplier) master data including contact details, tax information, and address fields. Populated from the organization's vendor configuration.

Columns

Column Name Data Type Nullable Description
vendorwid BIGINT IDENTITY No Surrogate warehouse key for the vendor dimension
vendorid VARCHAR(144) Yes Natural unique identifier of the vendor
taxcharged DOUBLE PRECISION Yes Default tax rate or tax amount charged by the vendor
vendorworkphonecountryfk INTEGER Yes Country code foreign key for the vendor work phone number
void BOOLEAN Yes Soft-delete flag; TRUE means the record is logically deleted
vendorcity VARCHAR(512) Yes City portion of the vendor address
vendorstateother VARCHAR(512) Yes State or province of the vendor (free-text for non-standard regions)
vendoraddress1 VARCHAR(1024) Yes Primary street address line of the vendor
vendoraddress2 VARCHAR(1024) Yes Secondary street address line of the vendor
vendorcst VARCHAR(1024) Yes Central Sales Tax number of the vendor
vendoremail VARCHAR(1024) Yes Email address of the vendor
vendortin VARCHAR(1024) Yes Tax Identification Number of the vendor
vendorzipcode VARCHAR(128) Yes Postal / ZIP code of the vendor
vendorcode VARCHAR(1024) Yes Short code identifying the vendor
vendorname VARCHAR(1024) Yes Display name of the vendor
vendorworkphone VARCHAR(128) Yes Work phone number of the vendor
vendordesc VARCHAR(65535) Yes Free-text description of the vendor

Note: All dimension tables also include standard ETL metadata columns (podname, organizationid, groupid, etlLastUpdatedOn, etlLastUpdatedBy) which are omitted from this reference for brevity.

Primary Key

vendorwid

Foreign Keys

Column References
vendorworkphonecountryfk Country reference
Was this article helpful?
Your feedback helps us improve our documentation.