ZenotiHelp

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.