ZenotiHelp

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.