ZenotiHelp

Product Vendors Dimension Table

ZTZenoti Docs Team Updated April 10, 2026 1 min readGuide

Dimension table storing vendor-product associations including purchase pricing, tax, discount, and vendor part number details per center.

Columns

Column Name Data Type Nullable Description
ProductVendorWID BIGINT IDENTITY No Surrogate warehouse identifier (auto-generated)
ProductVendorId VARCHAR(36) Yes Source system unique identifier for the product-vendor association
ProductId VARCHAR(36) Yes Unique identifier of the associated product
VendorId VARCHAR(36) Yes Unique identifier of the vendor
PurchasePrice FLOAT Yes Purchase price from the vendor
IncludesTax BOOLEAN Yes Indicates if the purchase price includes tax
Discount NVARCHAR(128) Yes Discount value or description offered by the vendor
void BOOLEAN Yes Soft-delete flag
TaxTypeId VARCHAR(36) Yes Identifier of the tax type applied to this vendor product
VendorProductPartNumber VARCHAR(8192) Yes Vendor-specific part number for the product
CenterId VARCHAR(36) Yes Unique identifier of the center this association applies to

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

ProductVendorWID

Foreign Keys

Column References
ProductId the product dimension (Bi_DimProduct or equivalent)
VendorId the vendor dimension
CenterId the center dimension
TaxTypeId the tax type configuration
Was this article helpful?
Your feedback helps us improve our documentation.