Tax group details dimension table
bi_dimtaxgroupdetails
Column name | Column type | Primary key | Description |
|---|---|---|---|
taxgroupdetailswid | BIGINT | yes | Unique identifier for the row. Primary key |
taxtypedetailId | VARCHAR(36) | Unique identifier for the row | |
taxgroupid | VARCHAR(36) | Unique identifier for tax group created | |
TaxGroupName | VARCHAR(100) | Name of Tax group created | |
OrganizationId | VARCHAR(36) | A unique identifier for the organition for which this data belongs | |
Code | VARCHAR(256) | Code associated with tax group. User input when creating the tax group in product | |
TaxGroupDescription | VARCHAR(8000) | Description for tax group | |
void | BOOLEAN | Indicates if the row should be inserted or deleted. 1- delete, 0-insert | |
Active | BOOLEAN | Indicates if the tax group is set to "Active" in the product | |
TaxTypeId | VARCHAR(36) | identifier for tax type within a tax group | |
TaxTypeName | VARCHAR(100) | component of tax contributing to tax group. Dropdown from "component name" in tax settings | |
TaxPercentage | NUMERIC(19,4) | percentage of tax associated with tax type name | |
BasePriceFlag | INT | 0 - indicates tax on base price. 1 - indicates tax on discounted price | |
TaxCalculationFlag | INT | 0- simple, 1- compound, 2- surcharge | |
ItemPercentage | NUMERIC(19,4) | percentage of item value to be taxed | |
OrderofApplication | INT | order in which tax is to be applied among other tax components in the tax group | |
TaxTypeCategory | INT | ||
EtlLastUpdatedOn | TIMESTAMP | ETL system admin user who inserted or updated the corresponding record in this table. | |
EtlLastUpdatedBy | VARCHAR(50) | Latest timestamp at which the corresponding record was either inserted or updated in this table. | |
PodName | VARCHAR(20) | Internal to the ETL, says from which POD data is being synced the table | |
groupid | Internal to Zenoti. Used for data processing. | BIGINT | |