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

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

Contents

C_Tax

The Tax Rate Window defines the different taxes used for each tax category.

This table contains the following columns:

Name Nullable Data Type Description
C_Tax_ID NVARCHAR2(32)The percentage of money requested by the government for this specified product or transaction.
AD_Client_ID NVARCHAR2(32)Client for this installation.
AD_Org_ID NVARCHAR2(32)Organizational entity within client
IsActive NCHAR(1)A flag indicating whether this record is available for use or de-activated.
Created NDATEThe date that this record is completed.
CreatedBy NVARCHAR2(32)User who created this records
Updated NDATEx not implemented
Name NNVARCHAR2(60)A non-unique identifier for a record/document often used as a search tool.
UpdatedBy NVARCHAR2(32)User who updated this records
Description YNVARCHAR2(255)A space to write additional related information.
TaxIndicator YVARCHAR2(5)A fast method for finding a specific tax.
ValidFrom NDATEA parameter stating the starting time of a specified request.
IsSummary NCHAR(1)A means of grouping fields in order to view or hide additional information.
Rate NNUMBERThe percentage to be multiplied by the source to arrive at the tax or exchange amount.
Parent_Tax_ID YVARCHAR2(32)Parent Tax indicates a tax that is made up of multiple taxes
C_Country_ID YVARCHAR2(32)A state or a nation.
C_Region_ID YVARCHAR2(32)An area of a specific country.
To_Country_ID YVARCHAR2(32)The country receiving a shipment
To_Region_ID YVARCHAR2(32)The state/province inside of a country receiving the shipment.
C_TaxCategory_ID NVARCHAR2(32)A classification of tax options based on similar characteristics or attributes.
IsDefault NCHAR(1)A value that is shown whenever a record is created.
IsTaxExempt NCHAR(1)A condition stating that for a specific case, taxes must not be applied.
SOPOType NVARCHAR2(60)Sales Tax applies to sales situations, Purchase Tax to purchase situations
Cascade YCHAR(1)Any additional discount built upon the remaining total after applying previous discounts.
C_BP_TaxCategory_ID YVARCHAR2(32)Bussines Partner Tax Category as a Vendor
Line YNUMBERA line stating the position of this request in the document.
IsWithholdingTax YCHAR(1)Is withholding tax
IsNoTaxable YCHAR(1)Check if it is not taxable
Deducpercent YNUMBER(10, 0)Deductable Rate
Originalrate YNUMBER(10, 0)Original Rate
IsTaxUndeductable YCHAR(1)Tax Not Deductible
IsTaxDeductable YCHAR(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 YCHAR(1)Is no VAT tax
BaseAmount NVARCHAR2(60)Base Amount to be used for the calculation of the tax amount.
C_TaxBase_ID YVARCHAR2(32)Tax rate used as tax base amount for tax calculation
DocTaxAmount NVARCHAR2(60)Document tax amount calculation criteria

Other Info

Check constraints

These are the check constraints for this table:

top

Indexes

These are the indexes for this table (for each index there is a list of all the columns included within it):

Unique

top

Columns

Tax

The Tax indicates the type of tax for this document line.

top

Client

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@)

top

Organization

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

top

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.

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.

top

Creation Date

The Created field indicates the date that this record was created.

top

Created By

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

top

Updated

The Updated field indicates the date that this record was updated.

top

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.

top

Updated By

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

top

Description

A description is limited to 255 characters.

top

Tax Search Key

The Tax Indicator identifies the short name that will print on documents referencing this tax.

top

Valid from Date

The Valid From date indicates the first day of a date range

top

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.

top

Rate

The Rate indicates the percentage to be multiplied by the source to arrive at the tax or exchange amount.

Validation Rule AD_Client Security validation: Clients with user access rights. With the following code:

 
AD_Client.AD_Client_ID IN (@#User_Client@)

top

Parent Tax Rate

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'


top

Country

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


Reference Table C_Country

top

Region

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@

top

Destination Country

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


Reference Table C_Country

top

Destination Region

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@

top

Tax Category

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

top

Default

The Default Checkbox indicates if this record will be used as a default value.

top

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.

top

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)

List values: C_Tax SPPOType

The allowed values for this list are:

top

Cascade

Indicates if it is applied in an accumulative way or if it is applied to the base amount.

top

Business Partner Tax Category

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

top

Line No.

Indicates the unique line for a document. It will also control the display order of the lines within a document.

top

Withholding tax

Describe if the tax is included in the Withholding's Calculation.

top

Not Taxable

Check if it is not taxable

top

Deductable Rate

It is the deductable percentage

top

Original Rate

Original Rate

top

Not tax-deductable

Check it if the tax is not deductible

top

Istaxdeductable

If active, this rate will behave as a tax deductible rate, no matter if the organization where used is tax deductible or not.

top

No VAT

Is no VAT

top

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.

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)


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@

top

DocTaxAmount

Criteria used for the calculation of tax base amount at document level.

List values: All document tax amount calculation criteria

The allowed values for this list are:

top

Related tables

Tables that link this table:

top

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

This page has been accessed 6,493 times. This page was last modified on 2 July 2011, at 21:00. Content is available under Creative Commons Attribution-ShareAlike 2.5 Spain License.