ERP/2.50/Developers Guide/Database Model/org.openbravo.model.financialmgmt.tax/C Tax
C_Tax
The Tax Rate Window defines the different taxes used for each tax category.
- Name:FinancialMgmtTaxRate
- Classname:TaxRate
This table contains the following columns:
Name | Nullable | Data Type | Description |
C_Tax_ID | N | VARCHAR2(32) | The percentage of money requested by the government for this specified product or transaction. |
AD_Client_ID | N | VARCHAR2(32) | Client for this installation. |
AD_Org_ID | N | VARCHAR2(32) | Organizational entity within client |
IsActive | N | CHAR(1) | A flag indicating whether this record is available for use or de-activated. |
Created | N | DATE | The date that this record is completed. |
CreatedBy | N | VARCHAR2(32) | User who created this records |
Updated | N | DATE | x not implemented |
Name | N | NVARCHAR2(60) | A non-unique identifier for a record/document often used as a search tool. |
UpdatedBy | N | VARCHAR2(32) | User who updated this records |
Description | Y | NVARCHAR2(255) | A space to write additional related information. |
TaxIndicator | Y | VARCHAR2(5) | A fast method for finding a specific tax. |
ValidFrom | N | DATE | A parameter stating the starting time of a specified request. |
IsSummary | N | CHAR(1) | A means of grouping fields in order to view or hide additional information. |
Rate | N | NUMBER | The percentage to be multiplied by the source to arrive at the tax or exchange amount. |
Parent_Tax_ID | Y | VARCHAR2(32) | Parent Tax indicates a tax that is made up of multiple taxes |
C_Country_ID | Y | VARCHAR2(32) | A state or a nation. |
C_Region_ID | Y | VARCHAR2(32) | An area of a specific country. |
To_Country_ID | Y | VARCHAR2(32) | The country receiving a shipment |
To_Region_ID | Y | VARCHAR2(32) | The state/province inside of a country receiving the shipment. |
C_TaxCategory_ID | N | VARCHAR2(32) | A classification of tax options based on similar characteristics or attributes. |
IsDefault | N | CHAR(1) | A value that is shown whenever a record is created. |
IsTaxExempt | N | CHAR(1) | A condition stating that for a specific case, taxes must not be applied. |
SOPOType | N | VARCHAR2(60) | Sales Tax applies to sales situations, Purchase Tax to purchase situations |
Cascade | Y | CHAR(1) | Any additional discount built upon the remaining total after applying previous discounts. |
C_BP_TaxCategory_ID | Y | VARCHAR2(32) | Bussines Partner Tax Category as a Vendor |
Line | Y | NUMBER | A line stating the position of this request in the document. |
IsWithholdingTax | Y | CHAR(1) | Is withholding tax |
IsNoTaxable | Y | CHAR(1) | Check if it is not taxable |
Deducpercent | Y | NUMBER(10, 0) | Deductable Rate |
Originalrate | Y | NUMBER(10, 0) | Original Rate |
IsTaxUndeductable | Y | CHAR(1) | Tax Not Deductible |
IsTaxDeductable | Y | CHAR(1) | If active, this rate will behave as a tax deductible rate, no matter if the organization where used is tax deductible or not. |
IsNoVAT | Y | CHAR(1) | Is no VAT tax |
BaseAmount | N | VARCHAR2(60) | Base Amount to be used for the calculation of the tax amount. |
C_TaxBase_ID | Y | VARCHAR2(32) | Tax rate used as tax base amount for tax calculation |
DocTaxAmount | N | VARCHAR2(60) | Document tax amount calculation criteria |
Other Info
Check constraints
These are the check constraints for this table:
- C_TAX_ISACTIVE_CHECK: ISACTIVE IN ('Y', 'N')
- C_TAX_ISTAXDEDUCTABLE: ISTAXDEDUCTABLE IN ('Y', 'N')
Indexes
These are the indexes for this table (for each index there is a list of all the columns included within it):
Unique
- C_TAX_KEY
- C_TAX_NAME1
Columns
Tax
The Tax indicates the type of tax for this document line.
- Physical column name: C_Tax_ID
- Property Name: id
- Reference: ID
Client
- Physical column name: AD_Client_ID
- Property Name: client
- Reference: TableDir
- Default value: @AD_CLIENT_ID@
Foreign key column to AD_Client table, (column: AD_Client_ID)
Validation Rule AD_Client Security validation: Clients with user access rights. With the following code:
AD_Client.AD_Client_ID IN (@#User_Client@)
Organization
- Physical column name: AD_Org_ID
- Property Name: organization
- Reference: TableDir
- Default value: @AD_Org_ID@
Foreign key column to AD_Org table, (column: AD_Org_ID)
Active
There are two methods of making records unavailable in the system: One is to delete the record, the other is to de-activate the record. A de-activated record is not available for selection, but available for reporting. There are two reasons for de-activating and not deleting records:
(1) The system requires the record for auditing purposes.
(2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are existing invoices for it. By de-activating the Business Partner you prevent it from being used in future transactions.
- Physical column name: IsActive
- Property Name: active
- Reference: YesNo
Callout: SE_Taxes_Active
This element is linked to a callout.
It is implemented by org.openbravo.erpCommon.ad_callouts.SE_Taxes_Active Java class.
Creation Date
The Created field indicates the date that this record was created.
- Physical column name: Created
- Property Name: creationDate
- Reference: DateTime
Created By
- Physical column name: CreatedBy
- Property Name: createdBy
- Reference: Search
Foreign key column to AD_User table, (column: AD_User_ID)
Updated
The Updated field indicates the date that this record was updated.
- Physical column name: Updated
- Property Name: updated
- Reference: DateTime
Name
A more descriptive identifier (that does need to be unique) of a record/document that is used as a default search option along with the search key (that is unique and mostly shorter). It is up to 60 characters in length.
- Physical column name: Name
- Property Name: name
- Reference: String
- This column is part of the table's identifier
Updated By
- Physical column name: UpdatedBy
- Property Name: updatedBy
- Reference: Search
Foreign key column to AD_User table, (column: AD_User_ID)
Description
A description is limited to 255 characters.
- Physical column name: Description
- Property Name: description
- Reference: String
Tax Search Key
The Tax Indicator identifies the short name that will print on documents referencing this tax.
- Physical column name: TaxIndicator
- Property Name: taxSearchKey
- Reference: String
Valid from Date
The Valid From date indicates the first day of a date range
- Physical column name: ValidFrom
- Property Name: validFromDate
- Reference: Date
Summary Level
A summary entity represents a branch in a tree rather than an end-node. Summary entities are used for reporting and do not have own values.
- Physical column name: IsSummary
- Property Name: summaryLevel
- Reference: YesNo
Rate
The Rate indicates the percentage to be multiplied by the source to arrive at the tax or exchange amount.
- Physical column name: Rate
- Property Name: rate
- Reference: Number
Validation Rule AD_Client Security validation: Clients with user access rights. With the following code:
AD_Client.AD_Client_ID IN (@#User_Client@)
Parent Tax Rate
- Physical column name: Parent_Tax_ID
- Property Name: parentTaxRate
- Reference: Table
Foreign key column to C_Tax table, (column: C_Tax_ID)
Reference Table C_Tax_Parent : Parent Taxes. With the following where clause:
C_Tax.IsSummary = 'Y'
Country
- Physical column name: C_Country_ID
- Property Name: country
- Reference: Table
Foreign key column to C_Country table, (column: C_Country_ID)
Reference Table C_Country
Region
- Physical column name: C_Region_ID
- Property Name: region
- Reference: Table
Foreign key column to C_Region table, (column: C_Region_ID)
Reference Table C_Region
Validation Rule C_Region of Country: null. With the following code:
C_Region.C_Country_ID=@C_Country_ID@
Destination Country
- Physical column name: To_Country_ID
- Property Name: destinationCountry
- Reference: Table
Foreign key column to C_Country table, (column: C_Country_ID)
Reference Table C_Country
Destination Region
- Physical column name: To_Region_ID
- Property Name: destinationRegion
- Reference: Table
Foreign key column to C_Region table, (column: C_Region_ID)
Reference Table C_Region
Validation Rule C_Region of To_Country: null. With the following code:
C_Region.C_Country_ID=@To_Country_ID@
Tax Category
- Physical column name: C_TaxCategory_ID
- Property Name: taxCategory
- Reference: TableDir
- This column is part of the table's identifier
Foreign key column to C_TaxCategory table, (column: C_TaxCategory_ID)
Default
The Default Checkbox indicates if this record will be used as a default value.
- Physical column name: IsDefault
- Property Name: default
- Reference: YesNo
Tax Exempt
If a business partner is exempt from tax, the exempt tax rate is used. For this, you need to set up a tax rate with a 0% rate and indicate that this is your tax exempt rate. This is required for tax reporting, so that you can track tax exempt transactions.
- Physical column name: IsTaxExempt
- Property Name: taxExempt
- Reference: YesNo
Sales/Purchase Type
Sales Tax: charged when selling - examples: Sales Tax, Output VAT (payable)Purchase Tax: tax charged when purchasing - examples: Use Tax, Input VAT (receivable)
- Physical column name: SOPOType
- Property Name: salesPurchaseType
- Reference: List
- Default value: B
List values: C_Tax SPPOType
The allowed values for this list are:
- B (Both)
- P (Purchase Tax)
- S (Sales Tax)
Cascade
Indicates if it is applied in an accumulative way or if it is applied to the base amount.
- Physical column name: Cascade
- Property Name: cascade
- Reference: YesNo
- Default value: N
Business Partner Tax Category
- Physical column name: C_BP_TaxCategory_ID
- Property Name: businessPartnerTaxCategory
- Reference: TableDir
Foreign key column to C_BP_TaxCategory table, (column: C_BP_TaxCategory_ID)
Line No.
Indicates the unique line for a document. It will also control the display order of the lines within a document.
- Physical column name: Line
- Property Name: lineNo
- Reference: Integer
- Default value: @SQL=SELECT COALESCE(MAX(LINE),0)+10 AS DefaultValue FROM C_TAX WHERE PARENT_TAX_ID=@Parent_tax_ID@
Withholding tax
Describe if the tax is included in the Withholding's Calculation.
- Physical column name: IsWithholdingTax
- Property Name: withholdingTax
- Reference: YesNo
Not Taxable
Check if it is not taxable
- Physical column name: IsNoTaxable
- Property Name: notTaxable
- Reference: YesNo
Deductable Rate
It is the deductable percentage
- Physical column name: Deducpercent
- Property Name: deductableRate
- Reference: Number
Original Rate
Original Rate
- Physical column name: Originalrate
- Property Name: originalRate
- Reference: Number
Not tax-deductable
Check it if the tax is not deductible
- Physical column name: IsTaxUndeductable
- Property Name: notTaxdeductable
- Reference: YesNo
- Default value: N
Istaxdeductable
If active, this rate will behave as a tax deductible rate, no matter if the organization where used is tax deductible or not.
- Physical column name: IsTaxDeductable
- Property Name: istaxdeductable
- Reference: YesNo
- Default value: N
No VAT
Is no VAT
- Physical column name: IsNoVAT
- Property Name: noVAT
- Reference: YesNo
- Default value: N
Base Amount
Base Amount to be used as base for the calculation. Line net amount or alternate line net amount can be selected as base for the tax calculation.
- Physical column name: BaseAmount
- Property Name: baseAmount
- Reference: List
- Default value: LNA
List values: All base amount
The allowed values for this list are:
- LNA (Line Net Amount)
- LNATAX (Line Net Amount + Tax Amount)
- TAX (Tax Amount)
- TBA (Alternate Tax Base Amount)
- TBATAX (Alternate Tax Base Amount + Tax Amount)
Tax Base
- Physical column name: C_TaxBase_ID
- Property Name: taxBase
- Reference: Table
Foreign key column to C_Tax table, (column: C_Tax_ID)
Reference Table C_Tax
Validation Rule C_Tax - Base taxes: Base taxes previously calculated. With the following code:
C_TAX_GET_ROOT(C_TAX.C_TAX_ID) = C_TAX_GET_ROOT(@C_Tax_ID@) AND C_TAX_GET_LEVEL(C_TAX_GET_ROOT(C_TAX.C_TAX_ID), C_TAX.C_TAX_ID, 0) < C_TAX_GET_LEVEL(C_TAX_GET_ROOT(C_TAX.C_TAX_ID),@C_Tax_ID@ , 0) AND C_TAX_GET_ROOT(C_TAX.C_TAX_ID)<>@C_Tax_ID@
DocTaxAmount
Criteria used for the calculation of tax base amount at document level.
- Physical column name: DocTaxAmount
- Property Name: docTaxAmount
- Reference: List
- Default value: D
List values: All document tax amount calculation criteria
The allowed values for this list are:
- D (Document based amount by rate)
- L (Line based amount by rate)
Related tables
Tables that link this table:
- BusinessPartnerWithholding.Tax
- DataImportInvoice.Tax
- DataImportOrder.Tax
- DataImportTax.Parent Tax Rate
- DataImportTax.Tax
- FinancialMgmtAccountingFact.Tax
- FinancialMgmtGLItem.Tax
- FinancialMgmtGLJournalLine.Tax
- FinancialMgmtTaxRate.Parent Tax Rate
- FinancialMgmtTaxRate.Tax Base
- FinancialMgmtTaxRateAccounts.Tax
- FinancialMgmtTaxRegisterTypeLines.Tax
- FinancialMgmtTaxRegisterline.Tax
- FinancialMgmtTaxReport.Tax
- FinancialMgmtTaxTrl.Tax
- FinancialMgmtTaxZone.Tax
- InvoiceLine.Tax
- InvoiceLineTax.Tax
- InvoiceLineTaxV.Tax
- InvoiceTax.Tax
- OrderLine.Tax
- OrderLineTax.Tax
- OrderLineTaxV.Tax
- OrderTax.Tax
- OrganizationInformation.SalesTaxExemptRate
- ProjectLine.Tax