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.