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.