View source | Discuss this page | Page history | Printable version   

ERP/3.0/Developers Guide/Database Model/org.openbravo.model.financialmgmt.tax/C Tax

This article is protected against manual editing because it is automatically generated from Openbravo meta-data. Learn more about writing and translating such documents.
Back button.png   Back to ERP/3.0/Developers Guide/Database Model/org.openbravo.model.financialmgmt.tax


Contents

C_Tax

This table contains the following columns:

Name Nullable Data Type Description


IsActive No CHAR (1) 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.

BaseAmount No VARCHAR (60) 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.
C_BP_TaxCategory_ID Yes VARCHAR (32) Bussines Partner Tax Category is a category defined for applying default taxes to procurement transactions.
Cascade Yes CHAR (1) Indicates if it is applied in an accumulative way or if it is applied to the base amount.
AD_Client_ID No VARCHAR (32) A Client is a company or a legal entity. You cannot share data between Clients.
C_Country_ID Yes VARCHAR (32) The Country defines a Country. Each Country must be defined before it can be used in any document.
CreatedBy No VARCHAR (32) The Created By field indicates the user who created this record.
Created No TIMESTAMP (7) The Created field indicates the date that this record was created.
Deducpercent Yes DECIMAL (10,0) It is the deductible percentage
IsDefault No CHAR (1) The Default Checkbox indicates if this record will be used as a default value.
Description Yes NVARCHAR (255) A description is limited to 255 characters.
To_Country_ID Yes VARCHAR (32) The To Country indicates the receiving country on a document
To_Region_ID Yes VARCHAR (32) The To Region indicates the receiving region on a document
DocTaxAmount No VARCHAR (60) Criteria used for the calculation of tax base amount at document level.
IsCashVAT No CHAR (1) Cash VAT tax rate
IsTaxDeductable Yes 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.
Line Yes DECIMAL Indicates the unique line for a document. It will also control the display order of the lines within a document.
Name No NVARCHAR (60) 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.
IsNoVAT Yes CHAR (1) Is no VAT
IsNoTaxable Yes CHAR (1) Check if it is not taxable
IsTaxUndeductable Yes CHAR (1) Check it if the tax is not deductible
AD_Org_ID No VARCHAR (32) An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations.
Originalrate Yes DECIMAL (10,0) Original Rate
Parent_Tax_ID Yes VARCHAR (32) The Parent Tax indicates a tax that is a reference for multiple taxes. This allows you to charge multiple taxes on a document by entering the Parent Tax
Rate No DECIMAL The Rate indicates the percentage to be multiplied by the source to arrive at the tax or exchange amount.
C_Region_ID Yes VARCHAR (32) The Region identifies a unique Region for this Country.
SOPOType No VARCHAR (60) Sales Tax: charged when selling - examples: Sales Tax, Output VAT (payable)Purchase Tax: tax charged when purchasing - examples: Use Tax, Input VAT (receivable)
Value No NVARCHAR (60) A search key allows for a fast method of finding a particular record. If you leave the search key empty, the system automatically creates a numeric number originating from a document sequence defined in the "Document Sequence" window. The sequence naming convention follows a rule "DocumentNo_TableName", where TableName is the actual name of the database table (e.g. C_Order).

Usually, company's internal identifiers for various records (products, customers, etc) are stored here.

IsSummary No CHAR (1) 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.
C_Tax_ID No VARCHAR (32) The Tax indicates the type of tax for this document line.
C_TaxBase_ID Yes VARCHAR (32) The amount of the tax selected here will be used as tax base amount for the tax calculation.
C_TaxCategory_ID No VARCHAR (32) The Tax Category provides a method of grouping similar taxes. For example, Sales Tax or Value Added Tax.
IsTaxExempt No CHAR (1) 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.
TaxIndicator Yes VARCHAR (5) The Tax Indicator identifies the short name that will print on documents referencing this tax.
Updated No TIMESTAMP (7) The Updated field indicates the date that this record was updated.
UpdatedBy No VARCHAR (32) The Updated By field indicates the user who updated this record.
ValidFrom No TIMESTAMP (7) The Valid From date indicates the first day of a date range
IsWithholdingTax Yes CHAR (1) Describe if the tax is included in the Withholding's Calculation.

Columns

Active


Callout: SE_Taxes_Active

This column has a callout associated.

It is implemented by [1] Java Class.

top


Base Amount


List values: All base amount

The allowed values for this list are:

top


Business Partner Tax Category


Foreign key column to C_BP_TaxCategory table, (column: C_BP_TaxCategory_ID)

top


Cascade



top


Client


Foreign key column to AD_Client table, (column: AD_Client_ID) It has a validation "AD_Client Security validation", with the following code

AD_Client.AD_Client_ID in (@#User_Client@)

top


Country


Foreign key column to C_Country table, (column: C_Country_ID)

top


Created By


Foreign key column to AD_User table, (column: AD_User_ID)

top


Creation Date



top


Deductable Rate



top


Default



top


Description



top


Destination Country


Foreign key column to C_Country table, (column: C_Country_ID)

top


Destination Region


Foreign key column to C_Region table, (column: C_Region_ID) It has a validation "C_Region of To_Country", with the following code

C_Region.C_Country_ID=@To_Country_ID@

top


DocTaxAmount


List values: All document tax amount calculation criteria

The allowed values for this list are:

top


IsCashVAT



top


Istaxdeductable



top


Line No.



top


Name


top


No VAT



top


Not Taxable



top


Not tax-deductable



top


Organization


Foreign key column to AD_Org table, (column: AD_Org_ID)

Callout: SL_TaxCategory_Org

This column has a callout associated.

It is implemented by [2] Java Class.

top


Original Rate



top


Parent Tax Rate


Foreign key column to C_Tax table, (column: C_Tax_ID) It has a validation "Tax not included", with the following code

(C_Tax.C_Tax_ID <> @C_TAX_ID@ OR @C_TAX_ID@ IS NULL)

top


Rate



It has a validation "AD_Client Security validation", with the following code

AD_Client.AD_Client_ID in (@#User_Client@)

top


Region


Foreign key column to C_Region table, (column: C_Region_ID) It has a validation "C_Region of Country", with the following code

C_Region.C_Country_ID=@C_Country_ID@

top


Sales/Purchase Type


List values: C_Tax SPPOType

The allowed values for this list are:

top


Search Key



top


Summary Level



top


Tax



top


Tax Base


Foreign key column to C_Tax table, (column: C_Tax_ID) It has a validation "C_Tax - Base taxes", 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@

top


Tax Category

Foreign key column to C_TaxCategory table, (column: C_TaxCategory_ID)

top


Tax Exempt



top


Tax Search Key



top


Updated



top


Updated By


Foreign key column to AD_User table, (column: AD_User_ID)

top


Valid from Date



top


Withholding tax



Callout: SE_TaxRate_Withholding

This column has a callout associated.

It is implemented by [3] Java Class.

top


Other Info

Check Constraints

These are the check constraints for this table:

top

Back button.png   Back to org.openbravo.model.financialmgmt.tax

Retrieved from "http://wiki.openbravo.com/wiki/ERP/3.0/Developers_Guide/Database_Model/org.openbravo.model.financialmgmt.tax/C_Tax"

This page has been accessed 5,128 times. This page was last modified on 4 September 2023, at 01:59. Content is available under Creative Commons Attribution-ShareAlike 2.5 Spain License.