Item Source Dimension Table
ZTZenoti Docs Team Updated April 10, 2026 1 min readGuide
Dimension table storing item source classifications that identify the origin channel of an invoice item (e.g., Walk-in, Online, App). Populated from the application's item-source enumeration.
Columns
| Column Name | Data Type | Nullable | Description |
|---|---|---|---|
| itemsourcewid | BIGINT IDENTITY | No | Surrogate warehouse key for the item source dimension |
| sourcenum | INTEGER | Yes | Numeric enumeration value representing the source |
| sourcename | VARCHAR(128) | Yes | Display name of the item source |
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
itemsourcewid
Foreign Keys
This table has no foreign key relationships to other analytics tables.
Enumerator Values
| Column | Values |
|---|---|
| sourcenum / sourcename | Enumerated source channel (e.g., Walk-in, Online, App) |
Was this article helpful?
Your feedback helps us improve our documentation.