View source | Discuss this page | Page history | Printable version   
Toolbox
Main Page
Upload file
What links here
Recent changes
Help

PDF Books
Add page
Show collection (0 pages)
Collections help

Search

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


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)
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.
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.
C_BP_TaxCategory_ID Yes VARCHAR (32) Bussines Partner Tax Category is a category defined for applying default taxes to procurement transactions.
Line Yes DECIMAL Indicates the unique line for a document. It will also control the display order of the lines within a document.
Cascade Yes CHAR (1) Indicates if it is applied in an accumulative way or if it is applied to the base amount.
IsWithholdingTax Yes CHAR (1) Describe if the tax is included in the Withholding's Calculation.
IsNoTaxable Yes CHAR (1) Check if it is not taxable
Deducpercent Yes DECIMAL (10,0) It is the deductible percentage
Originalrate Yes DECIMAL (10,0) Original Rate
IsTaxUndeductable Yes CHAR (1) Check it if the tax is not deductible
IsNoVAT Yes CHAR (1) Is no VAT
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_TaxBase_ID Yes VARCHAR (32) The amount of the tax selected here will be used as tax base amount for the tax calculation.
DocTaxAmount No VARCHAR (60) Criteria used for the calculation of tax base amount at document level.
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.
IsCashVAT No CHAR (1) Cash VAT tax rate
IsDefault No CHAR (1) The Default Checkbox indicates if this record will be used as a default value.
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.
ValidFrom No TIMESTAMP (7) The Valid From date indicates the first day of a date range
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.
C_TaxCategory_ID No VARCHAR (32) The Tax Category provides a method of grouping similar taxes. For example, Sales Tax or Value Added Tax.
To_Region_ID Yes VARCHAR (32) The To Region indicates the receiving region on a document
To_Country_ID Yes VARCHAR (32) The To Country indicates the receiving country on a document
C_Region_ID Yes VARCHAR (32) The Region identifies a unique Region for this Country.
C_Country_ID Yes VARCHAR (32) The Country defines a Country. Each Country must be defined before it can be used in any document.
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.
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
Description Yes NVARCHAR (255) A description is limited to 255 characters.
Rate No DECIMAL The Rate indicates the percentage to be multiplied by the source to arrive at the tax or exchange amount.
CreatedBy No VARCHAR (32) The Created By field indicates the user who created this record.
TaxIndicator Yes VARCHAR (5) The Tax Indicator identifies the short name that will print on documents referencing this tax.
Created No TIMESTAMP (7) The Created field indicates the date that this record was created.
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.

C_Tax_ID No VARCHAR (32) The Tax indicates the type of tax for this document line.
AD_Client_ID No VARCHAR (32) A Client is a company or a legal entity. You cannot share data between Clients.

Columns

Sales/Purchase Type


List values: C_Tax SPPOType

The allowed values for this list are:

top


Tax Exempt



top


Name


top


Business Partner Tax Category


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

top


Line No.



top


Cascade



top


Withholding tax



Callout: SE_TaxRate_Withholding

This column has a callout associated.

It is implemented by [1] Java Class.

top


Not Taxable



top


Deductable Rate



top


Original Rate



top


Not tax-deductable



top


No VAT



top


Base Amount


List values: All base amount

The allowed values for this list are:

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


DocTaxAmount


List values: All document tax amount calculation criteria

The allowed values for this list are:

top


Istaxdeductable



top


IsCashVAT



top


Default



top


Summary Level



top


Valid from Date



top


Updated



top


Updated By


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

top


Tax Category

Foreign key column to C_TaxCategory table, (column: C_TaxCategory_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


Destination Country


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

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


Country


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

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


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


Description



top


Rate



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

AD_Client.AD_Client_ID in (@#User_Client@)

top


Created By


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

top


Tax Search Key



top


Creation Date



top


Active


Callout: SE_Taxes_Active

This column has a callout associated.

It is implemented by [3] Java Class.

top


Tax



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


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 1,572 times. This page was last modified on 1 September 2016, at 02:30. Content is available under Creative Commons Attribution-ShareAlike 2.5 Spain License.