Tax Group Details Dimension Table
ZTZenoti Docs Team Updated April 10, 2026 1 min readGuide
Dimension table storing tax group and tax type details used for tax calculation on transactions within an organization.
Columns
| Column Name | Data Type | Nullable | Description |
|---|---|---|---|
| taxgroupdetailswid | BIGINT IDENTITY | No | Surrogate warehouse key for the tax group detail record |
| taxtypedetailId | VARCHAR(36) | Yes | Unique identifier (GUID) for the tax type detail |
| taxgroupid | VARCHAR(36) | Yes | Unique identifier (GUID) for the tax group |
| TaxGroupName | VARCHAR(100) | Yes | Display name of the tax group |
| Code | VARCHAR(256) | Yes | Code assigned to the tax group |
| TaxGroupDescription | VARCHAR(8000) | Yes | Detailed description of the tax group |
| void | BOOLEAN | Yes | Indicates whether the record has been voided/soft-deleted |
| Active | BOOLEAN | Yes | Indicates whether the tax group detail is currently active |
| TaxTypeId | VARCHAR(36) | Yes | Unique identifier (GUID) for the tax type |
| TaxTypeName | VARCHAR(100) | Yes | Display name of the tax type |
| TaxPercentage | NUMERIC(19,4) | Yes | Tax percentage rate applied by this tax type |
| BasePriceFlag | INT | Yes | Flag indicating how the base price is determined for tax calculation |
| TaxCalculationFlag | INT | Yes | Flag indicating the method of tax calculation |
| ItemPercentage | NUMERIC(19,4) | Yes | Percentage applied at the item level |
| OrderofApplication | INT | Yes | Order in which this tax type is applied relative to others |
| TaxTypeCategory | INT | Yes | Category classification of the tax type |
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
taxgroupdetailswid
Foreign Keys
| Column | References |
|---|---|
| taxgroupid | a tax group entity in the source system |
| TaxTypeId | a tax type entity in the source system |
| OrganizationId | an organization entity in the source system |
Enumerator Values
| Column | Values |
|---|---|
| void | FALSE = Active, TRUE = Voided |
| Active | FALSE = Inactive, TRUE = Active |
| BasePriceFlag | 0 = Exclude Base Price 1 = Include Base Price |
| TaxCalculationFlag | 0 = Standard Calculation 1 = Inclusive 2 = Exclusive |
| TaxTypeCategory | 1 = Sales Tax 2 = Service Tax 3 = VAT 4 = GST |
Was this article helpful?
Your feedback helps us improve our documentation.