Account name dimension table
Bi_DimAccountName
Field | Description | Field Type | Primary Key |
|---|---|---|---|
accountid | unique identifier for the account | integer | |
accountname | Name of the account | varchar ( 100 ) | |
accountwid | unique identifier for the row | bigint | Yes |
etllastupdatedby | ETL system admin user who inserted or updated the corresponding record in this table. | varchar ( 50 ) | |
etllastupdatedon | Latest timestamp at which the corresponding record was either inserted or updated in this table. | timestamp without time zone | |
organizationid | Unique identifier for the organization | varchar ( 36 ) | |
podname | Internal to the ETL, says from which POD data is being synced the table | varchar ( 20 ) | |
void | indicates if the account is void | boolean | |
groupid | Internal to Zenoti. Used for data processing. | BIGINT |