ZenotiHelp

Account Name Dimension Table

ZTZenoti Docs Team Updated April 10, 2026 1 min readGuide

Dimension table storing chart-of-account names used in the accounting module. Each row represents a named account within an organization.

Columns

Column Name Data Type Nullable Description
accountwid BIGINT IDENTITY No Surrogate warehouse key for the account name dimension
accountid INTEGER Yes Natural numeric identifier of the account
accountname VARCHAR(100) Yes Display name of the account
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

accountwid

Foreign Keys

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

Was this article helpful?
Your feedback helps us improve our documentation.