Tax
C_Tax
Tax identifier
Overview
| Table Name | C_Tax |
|---|---|
| Access Level | System + Client |
| Entity Type | D |
| Is Document | No |
| Is View | No |
| Has UUID | Yes |
| Parent Table | C_CountryGroupFrom |
| Wiki | View on iDempiere Wiki |
Columns (37)
| Column | Type | Required | Default | Description |
|---|---|---|---|---|
C_CountryGroupFrom_ID |
Table(10) | No | - | - |
C_CountryGroupTo_ID |
Table(10) | No | - | - |
C_TaxBase_ID |
Table Direct(10) | No | - | - |
C_TaxProvider_ID |
Table Direct(22) | No | - | - |
C_TaxSchema_ID |
Table Direct(10) | No | - | Tax Schema let you group the Tax Rates |
IsTaxExempt |
Yes-No(1) | Yes | - | Business partner is exempt from tax |
IsVAT |
Yes-No(1) | Yes | N | - |
SOPOType |
List(1) | Yes | B | Sales Tax applies to sales situations, Purchase Tax to purchase situations |
TaxPostingIndicator |
List(1) | No | 0 | Type of input tax (deductible and non deductible) |
TaxRateMessage |
String(256) | No | - | - |
Value |
String(40) | Yes | - | Search key for the record in the format required - must be unique |
Name |
String(60) | Yes | - | Alphanumeric identifier of the entity |
AD_Client_ID |
Table Direct(22) | Yes | @#AD_Client_ID@ | Tenant for this installation. |
AD_Org_ID |
Table Direct(22) | Yes | @#AD_Org_ID@ | Organizational entity within tenant |
AD_Rule_ID |
Table Direct(22) | No | - | - |
C_Country_ID |
Table(22) | No | - | Country |
Created |
Date+Time(7) | Yes | SYSDATE | Date this record was created |
CreatedBy |
Search(22) | Yes | - | User who created this records |
C_Region_ID |
Table(22) | No | - | Identifies a geographical Region |
C_TaxCategory_ID |
Table Direct(22) | Yes | - | Tax Category |
C_Tax_ID |
ID(22) | Yes | - | Tax identifier |
C_Tax_UU |
String(36) | No | - | - |
Description |
String(255) | No | - | Optional short description of the record |
IsActive |
Yes-No(1) | Yes | Y | The record is active in the system |
IsDefault |
Yes-No(1) | Yes | - | Default value |
IsDocumentLevel |
Yes-No(1) | Yes | - | Tax is calculated on document level (rather than line by line) |
IsSalesTax |
Yes-No(1) | Yes | N | This is a sales tax (i.e. not a value added tax) |
IsSummary |
Yes-No(1) | Yes | - | This is a summary entity |
Parent_Tax_ID |
Table(22) | No | - | Parent Tax indicates a tax that is made up of multiple taxes |
Rate |
Number(22) | Yes | - | Rate or Tax or Exchange |
RequiresTaxCertificate |
Yes-No(1) | Yes | - | This tax rate requires the Business Partner to be tax exempt |
TaxIndicator |
String(10) | No | - | Short form for Tax to be printed on documents |
To_Country_ID |
Table(22) | No | - | Receiving Country |
To_Region_ID |
Table(22) | No | - | Receiving Region |
Updated |
Date+Time(7) | Yes | SYSDATE | Date this record was updated |
UpdatedBy |
Search(22) | Yes | - | User who updated this records |
ValidFrom |
Date(7) | Yes | - | Valid from including this date (first day) |
Foreign Keys
| Column | References | Description |
|---|---|---|
C_CountryGroupFrom_ID |
C_CountryGroupFrom.C_CountryGroupFrom_ID | - |
C_CountryGroupTo_ID |
C_CountryGroupTo.C_CountryGroupTo_ID | - |
C_TaxBase_ID |
C_TaxBase.C_TaxBase_ID | - |
C_TaxProvider_ID |
C_TaxProvider.C_TaxProvider_ID | - |
C_TaxSchema_ID |
C_TaxSchema.C_TaxSchema_ID | Tax Schema let you group the Tax Rates |
AD_Client_ID |
AD_Client.AD_Client_ID | Tenant for this installation. |
AD_Org_ID |
AD_Org.AD_Org_ID | Organizational entity within tenant |
AD_Rule_ID |
AD_Rule.AD_Rule_ID | - |
C_Country_ID |
C_Country.C_Country_ID | Country |
C_Region_ID |
C_Region.C_Region_ID | Identifies a geographical Region |
C_TaxCategory_ID |
C_TaxCategory.C_TaxCategory_ID | Tax Category |
Parent_Tax_ID |
Parent_Tax.Parent_Tax_ID | Parent Tax indicates a tax that is made up of multiple taxes |
To_Country_ID |
To_Country.To_Country_ID | Receiving Country |
To_Region_ID |
To_Region.To_Region_ID | Receiving Region |
Generated on 2026-05-03T16:41:41.499592955Z