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.