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.