ZenotiHelp

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.