ERP/3.0/Developers Guide/Database Model/org.openbravo.model.financialmgmt.tax/C Tax
C_Tax
- Name:C_Tax
- Classname:FinancialMgmtTaxRate
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
- Physical column name: IsActive
- Property Name: active
- Reference: YesNo
- Default value: Y
Callout: SE_Taxes_Active
This column has a callout associated.
It is implemented by [1] Java Class.
Base Amount
- Physical column name: BaseAmount
- Property Name: baseAmount
- Reference: List
- Default value: LNA
List values: All base amount
The allowed values for this list are:
- TBA (Alternate Tax Base Amount)
- TAX (Tax Amount)
- LNA (Line Net Amount)
- TBATAX (Alternate Tax Base Amount + Tax Amount)
- LNATAX (Line Net Amount + Tax Amount)
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)
Cascade
- Physical column name: Cascade
- Property Name: cascade
- Reference: YesNo
- Default value: N
Client
- Physical column name: AD_Client_ID
- Property Name: client
- Reference: TableDir
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@)
Country
- Physical column name: C_Country_ID
- Property Name: country
- Reference: Table
Foreign key column to C_Country table, (column: C_Country_ID)
Created By
- Physical column name: CreatedBy
- Property Name: createdBy
- Reference: Search
Foreign key column to AD_User table, (column: AD_User_ID)
Creation Date
- Physical column name: Created
- Property Name: creationDate
- Reference: DateTime
- Default value: SYSDATE
Deductable Rate
- Physical column name: Deducpercent
- Property Name: deductableRate
- Reference: Number
Default
- Physical column name: IsDefault
- Property Name: default
- Reference: YesNo
- Default value: N
Description
- Physical column name: Description
- Property Name: description
- Reference: String
Destination Country
- Physical column name: To_Country_ID
- Property Name: destinationCountry
- Reference: Table
Foreign key column to C_Country table, (column: C_Country_ID)
Destination Region
- Physical column name: To_Region_ID
- Property Name: destinationRegion
- Reference: Table
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@
DocTaxAmount
- 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:
- L (Line based amount by rate)
- D (Document based amount by rate)
IsCashVAT
- Physical column name: IsCashVAT
- Property Name: isCashVAT
- Reference: YesNo
- Default value: N
Istaxdeductable
- Physical column name: IsTaxDeductable
- Property Name: istaxdeductable
- Reference: YesNo
- Default value: N
Line No.
- Physical column name: Line
- Property Name: lineNo
- Reference: Integer
Name
- Physical column name: Name
- Property Name: name
- Reference: String
- This column is part of the table's identifier
No VAT
- Physical column name: IsNoVAT
- Property Name: noVAT
- Reference: YesNo
- Default value: N
Not Taxable
- Physical column name: IsNoTaxable
- Property Name: notTaxable
- Reference: YesNo
- Default value: N
Not tax-deductable
- Physical column name: IsTaxUndeductable
- Property Name: notTaxdeductable
- Reference: YesNo
- Default value: N
Organization
- Physical column name: AD_Org_ID
- Property Name: organization
- Reference: TableDir
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.
Original Rate
- Physical column name: Originalrate
- Property Name: originalRate
- Reference: Number
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)
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)
Rate
- Physical column name: Rate
- Property Name: rate
- Reference: Number
It has a validation "AD_Client Security validation", with the following code
AD_Client.AD_Client_ID in (@#User_Client@)
Region
- Physical column name: C_Region_ID
- Property Name: region
- Reference: Table
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@
Sales/Purchase Type
- 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)
- S (Sales Tax)
- P (Purchase Tax)
Search Key
- Physical column name: Value
- Property Name: searchKey
- Reference: String
Summary Level
- Physical column name: IsSummary
- Property Name: summaryLevel
- Reference: YesNo
- Default value: N
Tax
- Physical column name: C_Tax_ID
- Property Name: id
- Reference: ID
Tax Base
- Physical column name: C_TaxBase_ID
- Property Name: taxBase
- Reference: Table
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@
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)
Tax Exempt
- Physical column name: IsTaxExempt
- Property Name: taxExempt
- Reference: YesNo
- Default value: N
Tax Search Key
- Physical column name: TaxIndicator
- Property Name: taxSearchKey
- Reference: String
Updated
- Physical column name: Updated
- Property Name: updated
- Reference: DateTime
- Default value: SYSDATE
Updated By
- Physical column name: UpdatedBy
- Property Name: updatedBy
- Reference: Search
Foreign key column to AD_User table, (column: AD_User_ID)
Valid from Date
- Physical column name: ValidFrom
- Property Name: validFromDate
- Reference: Date
Withholding tax
- Physical column name: IsWithholdingTax
- Property Name: withholdingTax
- Reference: YesNo
Callout: SE_TaxRate_Withholding
This column has a callout associated.
It is implemented by [3] Java Class.
Other Info
Check Constraints
These are the check constraints for this table:
- C_TAX_ISACTIVE_CHECK: ISACTIVE IN ('Y', 'N')
- C_TAX_ISCASHVAT_WH_CH: ISCASHVAT = 'Y' AND ISWITHHOLDINGTAX = 'N' OR ISCASHVAT = 'N'
- C_TAX_ISTAXDEDUCTABLE: ISTAXDEDUCTABLE IN ('Y', 'N')