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