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

ERP/2.50/Developers Guide/Database Model/org.openbravo.model.dataimport/I Tax

Contents

I_Tax

This table contains the following columns:

Name Nullable Data Type Description
I_Tax_ID NVARCHAR2(32)null
AD_Client_ID YVARCHAR2(32)Client for this installation.
AD_Org_ID YVARCHAR2(32)Organizational entity within client
IsActive YCHAR(1)A flag indicating whether this record is available for use or de-activated.
Created YDATEThe date that this record is completed.
Createdby YVARCHAR2(32)User who created this records
Updated YDATEx not implemented
Updatedby YVARCHAR2(32)User who updated this records
C_Tax_ID YVARCHAR2(32)The percentage of money requested by the government for this specified product or transaction.
T_Name YNVARCHAR2(60)null
T_Description YNVARCHAR2(255)null
TaxIndicator YVARCHAR2(5)A fast method for finding a specific tax.
ValidFrom YDATEA parameter stating the starting time of a specified request.
IsSummary YCHAR(1)A means of grouping fields in order to view or hide additional information.
Rate YNUMBERThe 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.
IsTaxExempt YCHAR(1)A condition stating that for a specific case, taxes must not be applied.
SOPOType YVARCHAR2(60)Sales Tax applies to sales situations, Purchase Tax to purchase situations
Line YNUMBERA line stating the position of this request in the document.
Cascade YCHAR(1)Any additional discount built upon the remaining total after applying previous discounts.
C_TaxCategory_ID YVARCHAR2(32)A classification of tax options based on similar characteristics or attributes.
TC_Name YNVARCHAR2(60)null
TC_Description YNVARCHAR2(255)null
TC_CommodityCode YNVARCHAR2(20)null
C_BP_TaxCategory_ID YVARCHAR2(32)Bussines Partner Tax Category as a Vendor
BPTC_Name YNVARCHAR2(60)null
BPTC_Description YNVARCHAR2(255)null
Processing YCHAR(1)A request to process the respective document or task.
Processed YCHAR(1)A confirmation that the associated documents or requests are processed.
I_ErrorMsg YNVARCHAR2(2000)A message that appears when errors occur during the importing process.
I_IsImported YCHAR(1)A indication that the desired process has been completed successfully.
Parent_Name YNVARCHAR2(255)null
From_Code_Country YNVARCHAR2(60)null
TO_Code_Country YNVARCHAR2(60)null
From_Code_Region YNVARCHAR2(60)null
TO_Code_Region YNVARCHAR2(60)null

Other Info

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

I_Tax_ID

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.

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

Updated By

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

top

Tax

Foreign key column to C_Tax table, (column: C_Tax_ID)

top

Tax Name

top

Tax Description

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.

top

Parent Tax Rate

Foreign key column to C_Tax table, (column: C_Tax_ID)


Reference Table C_Tax Parent is NULL With the following where clause:

 
C_Tax.Parent_Tax_ID IS NULL


top

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)

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

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

Line No.

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

top

Cascade

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

top

Tax Category

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

top

Tax Category Name

top

Tax Cat. Description

top

Commodity Code

top

Business Partner Tax Category

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

top

BP Tax Category Name

top

BP Tax Category Description

top

Process Now

When this field is set as 'Y' a process is being performed on this record.

top

Processed

The Processed checkbox indicates that a document has been processed.

top

Import Error Message

The Import Error Message displays any error messages generated during the import process.

top

Import Process Complete

The Imported check box indicates if this import has been processed.

top

Parent Tax Name

top

Country from Code

top

Country to Code

top

Region from Code

top

Region to Code

top

Retrieved from "http://wiki.openbravo.com/wiki/ERP/2.50/Developers_Guide/Database_Model/org.openbravo.model.dataimport/I_Tax"

This page has been accessed 5,000 times. This page was last modified on 2 July 2011, at 20:51. Content is available under Creative Commons Attribution-ShareAlike 2.5 Spain License.