Product Dimension Table
ZTZenoti Docs Team Updated April 10, 2026 2 min readGuide
Dimension table storing product catalog information including product details, categorization, pricing, brand associations, and commission settings. Populated from the product master data.
Columns
| Column Name | Data Type | Nullable | Description |
|---|---|---|---|
| productwid | BIGINT IDENTITY | No | Surrogate warehouse key for the product dimension, auto-generated |
| businessunitid | VARCHAR(36) | Yes | Identifier of the business unit the product belongs to |
| categoryid | VARCHAR(36) | Yes | Identifier of the product category |
| parentcategoryid | VARCHAR(36) | Yes | Identifier of the parent category (for hierarchical categorization) |
| comissioneligible | BOOLEAN | Yes | Whether the product is eligible for commission |
| commissionfactor | DOUBLE PRECISION | Yes | Commission factor/multiplier for the product |
| consummable | BOOLEAN | Yes | Whether the product is consumable (used during services) |
| hasvariant | BOOLEAN | Yes | Whether the product has variant options (e.g., size, color) |
| issouldout | BOOLEAN | Yes | Whether the product is currently sold out |
| loyaltyeligible | BOOLEAN | Yes | Whether the product is eligible for loyalty points |
| mrp | DOUBLE PRECISION | Yes | Maximum Retail Price of the product |
| productid | VARCHAR(36) | Yes | Natural unique identifier (GUID) of the product from the source system |
| productnew | BOOLEAN | Yes | Whether the product is marked as new in the catalog |
| productrecommended | BOOLEAN | Yes | Whether the product is marked as recommended in the catalog |
| productsortorder | INTEGER | Yes | Sort order for display in the catalog |
| retail | BOOLEAN | Yes | Whether the product is available for retail sale |
| transferprice | DOUBLE PRECISION | Yes | Transfer price of the product (inter-center pricing) |
| volumeperitem | DOUBLE PRECISION | Yes | Volume measurement per item unit |
| volumetypename | VARCHAR(36) | Yes | Name of the volume type (e.g., ml, oz) |
| void | BOOLEAN | Yes | Soft-delete flag; TRUE indicates the record is voided/inactive |
| tags | VARCHAR(65535) | Yes | Tags associated with the product for categorization/filtering |
| productdesc | VARCHAR(65535) | Yes | Detailed description of the product |
| productdisplayname | VARCHAR(512) | Yes | Display name of the product |
| businessunitname | VARCHAR(800) | Yes | Name of the associated business unit |
| businessunitdescription | VARCHAR(65535) | Yes | Description of the associated business unit |
| categoryname | VARCHAR(65535) | Yes | Name of the product category |
| parentcategoryname | VARCHAR(65535) | Yes | Name of the parent category |
| metadescription | VARCHAR(1024) | Yes | SEO meta description for the product |
| metakeywords | VARCHAR(1024) | Yes | SEO meta keywords for the product |
| productname | VARCHAR(1024) | Yes | Full name of the product |
| categorycode | VARCHAR(128) | Yes | Short code for the product category |
| parentcategorycode | VARCHAR(128) | Yes | Short code for the parent category |
| productcode | VARCHAR(128) | Yes | Short code identifier for the product |
| productcatalogprice | VARCHAR(256) | Yes | Catalog display price of the product (stored as string for formatting) |
| productcolorname | VARCHAR(2048) | Yes | Color variant name of the product |
| productsizename | VARCHAR(2048) | Yes | Size variant name of the product |
| brandid | VARCHAR(36) | Yes | Identifier (GUID) of the product brand |
| brandcode | VARCHAR(512) | Yes | Short code for the brand |
| brandname | VARCHAR(512) | Yes | Display name of the brand |
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
productwid
Foreign Keys
| Column | References |
|---|---|
| organizationid | Bi_DimCenter |
| categoryid | the product category entity |
| parentcategoryid | the parent product category entity |
| businessunitid | the business unit entity |
| brandid | the brand entity |
Was this article helpful?
Your feedback helps us improve our documentation.