ZenotiHelp

Item Type Dimension Table

ZTZenoti Docs Team Updated April 10, 2026 1 min readGuide

Dimension table storing item type classifications used to categorize invoice line items (e.g., Service, Product, Membership, Package). Populated from the application's item-type enumeration.

Columns

Column Name Data Type Nullable Description
itemtypewid BIGINT IDENTITY No Surrogate warehouse key for the item type dimension
itemtypeid INTEGER Yes Natural numeric identifier of the item type
itemtypecode VARCHAR(100) Yes Short code representing the item type
itemtypevalue NUMERIC(19,0) Yes Numeric enumeration value of the item type
void BOOLEAN Yes Soft-delete flag; TRUE means the record is logically deleted

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

itemtypewid

Foreign Keys

This table has no foreign key relationships to other analytics tables.

Enumerator Values

Column Values
itemtypecode 0 = Service
2 = Product
3 = Membership
4 = Series Package
5 = Day Package
6 = Gift Card
11 = Class
itemtypevalue Numeric equivalent of the item type enumeration
Was this article helpful?
Your feedback helps us improve our documentation.