ZenotiHelp

Items Dimension Table

ZTZenoti Docs Team Updated April 10, 2026 1 min readGuide

Dimension table storing generic item definitions used across the system. Items represent miscellaneous chargeable or trackable entities that are not services, products, memberships, or packages. Populated from the item master data.

Columns

Column Name Data Type Nullable Description
itemwid BIGINT IDENTITY No Surrogate warehouse key for the item dimension, auto-generated
itemid VARCHAR(36) Yes Natural unique identifier (GUID) of the item from the source system
itemname VARCHAR(512) Yes Name of the item
itemcode VARCHAR(256) Yes Short code identifier for the item
businessunitid VARCHAR(65535) Yes Identifier(s) of the business unit(s) the item belongs to
businessunitname VARCHAR(65535) Yes Name(s) of the associated business unit(s)
tags VARCHAR(65535) Yes Tags associated with the item for categorization/filtering
void BOOLEAN Yes Soft-delete flag; TRUE indicates the record is voided/inactive

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

itemwid

Foreign Keys

Column References
organizationid Bi_DimCenter
Was this article helpful?
Your feedback helps us improve our documentation.