ZenotiHelp

Category Products Dimension Table

ZTZenoti Docs Team Updated April 10, 2026 1 min readGuide

Bridge/association dimension table linking products to their assigned categories within an organization.

Columns

Column Name Data Type Nullable Description
productcategorywid BIGINT IDENTITY No Surrogate warehouse identifier (auto-generated)
ProductCategoryPK DECIMAL(19,0) Yes Source system primary key for the product-category association
ProductId VARCHAR(36) Yes Unique identifier of the product
CategoryId VARCHAR(36) Yes Unique identifier of the category
Void BOOLEAN Yes Soft-delete flag

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

productcategorywid

Foreign Keys

Column References
ProductId the product dimension (Bi_DimProduct or equivalent)
CategoryId the category dimension
Was this article helpful?
Your feedback helps us improve our documentation.