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.