Tax code automatic entry

You use this table to define how amounts entered on certain VAT codes are to be distributed on multiple VAT codes and VAT numbers.

The following fields exist in this table:

Cost %

The proportion that is non-deductible, if the company is not eligible for received taxes to be deducted in full.

Tip:
If you want to separate this cost from the purchase account and enter it in a separate account, you can specify this general ledger account in the Cost account field in the VAT rate table.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainPercentDecimal
SQL nameCstPThe database field name.
API identifiercostPercentThe API identifier used in GraphQL.
Number12984 

Description

The name of the tax code automatic entry.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainNameText (80)
SQL nameDescrThe database field name.
API identifierdescriptionThe API identifier used in GraphQL.
Number12981 

Invest. tax no.

Investment tax number is not in use. You can use this field for anything you like.

Rate, Basis account and Inv. tax account is fetched from the Inv. tax table.

Note:
Investment tax is not calculated on VAT codes where the Invest. tax no. field is empty.

Note:
If you double-click or press * in this field, you can look up a value in the related table.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainVAT codeInteger
SQL nameInvTxNoThe database field name.
API identifierinvestmentTaxNoThe API identifier used in GraphQL.
Number12985 
Table 1. Table relations
To tablePurposeFrom columnsTo columnsComments
Inv. taxInvestmentTax
  • Invest. tax no.

Line no.

A unique number identifying tax code automatic entry.

Note:
If you press + in this field, the next available number is suggested. Gaps in the number series resulting from any deleted rows are not suggested. If you enter an existing number you will receive an error message. The number cannot be changed once it is entered.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainNo.Integer
Primary keyYesLine no.
SQL namePKThe database field name.
API identifierlineNoThe API identifier used in GraphQL.
Number12979 

New account no.

An account used for the vouchers that will be split between different VAT rates.

Note:
If you double-click or press * in this field, you can look up a value in the related table.
PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAccount no.Integer
SQL nameNwAcNoThe database field name.
API identifiernewAccountNoThe API identifier used in GraphQL.
Number13748 
Table 2. Table relations
To tablePurposeFrom columnsTo columnsComments
General ledger accountNewAccount
  • New account no.

New tax code no.

The VAT code to be used for the share entered in the Share field.

Note:
If you double-click or press * in this field, you can look up a value in the related table.
PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainVAT codeInteger
SQL nameNwTxCdNoThe database field name.
API identifiernewTaxCodeNoThe API identifier used in GraphQL.
Number13747 
Table 3. Table relations
To tablePurposeFrom columnsTo columnsComments
VAT codeNewTaxCode
  • New tax code no.

Non-taxable

This field is no longer in use. Be aware the field may be removed in later versions.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainBooleanInteger
Write AccessNoneYou are not allowed to modify the value in this field.
Memory fieldYesThe value in this field is only displayed in the program, it is not stored in the database.
API identifiernonTaxableThe API identifier used in GraphQL.
Number12987 

Service type

A turnover class for services will be selected in the vouchers rather than one for goods.

A look-up in this field gives you the following list of possible values:
1 - Services
This is significant for foreign associates, i.e. associates with Trade area in the range 2 - 5. The value in the Cost % field is taken into account when calculating VAT.
2 - OSS union service scheme
3 - OSS union goods scheme
4 - OSS import scheme
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainService typeInteger
SQL nameServThe database field name.
API identifierserviceTypeThe API identifier used in GraphQL.
Number12986 

Share

The share of the voucher that is to be processed using the VAT code entered in the New tax code no. field.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainPercentDecimal
SQL nameShrThe database field name.
API identifiershareThe API identifier used in GraphQL.
Number12991 

Turnover class

Value entered in this field will be suggested as Debit turnover cl. or Credit turnover cl. in the Voucher when entering Debit VAT code and Credit VAT code respectively.

On vouchers with general ledger entries for sales and purchases that are generated on the basis of orders, the turnover class is defined on the basis of the Transaction type, Trade area and Service type fields.

A look-up in this field gives you the following list of possible values:
1 - Taxable sales
Is used for sales of taxable products. I.e. when
  • the Transaction type is 1 - Sales or 2 - Hire
  • the Trade area is 0 - Taxable domestic according to VAT- and accounting inf./VAT code
2 - Non-taxable domestic sales
Is used for sales of non-taxable products. I.e. when
  • the Transaction type is 1 - Sales or 2 - Hire
  • the Trade area is 1 - Non-taxable domestic
10 - Transfer of goods to EU countries
Used when
  • the Transaction type is 1 - Sales or 2 - Hire
  • the Trade area is 4 - Subsidiary in another EU country
  • Service type1 - Services is not selected
5 - Sale of goods to EU countries
Used when
  • the Transaction type is 1 - Sales or 2 - Hire
  • the Trade area is 2 - Within other EU country
  • Service type1 - Services is not selected
3 - Sale of goods outside EU/Abroad
Used when
  • the Transaction type is 1 - Sales or 2 - Hire
  • the Trade area is 3 - Outside EU/Abroad
  • Service type1 - Services is not selected
9 - Sale of services abroad
Used when
  • the Transaction type is 1 - Sales or 2 - Hire
  • the Trade area is 2 - Within other EU country, 3 - Outside EU/Abroad or 4 - Subsidiary in another EU country
  • Service type1 - Services is selected
13 - Non-taxable sales
16 - Sales outside tax area
18 - Sales, taxable for purchaser
20 - Agent sales to third party
22 - Sales of services to EU countries
26 - Rent income voluntary
27 - OSS union scheme services
28 - OSS union scheme goods
29 - OSS import scheme
4 - Taxable purchases
Is used for purchases of taxable products. I.e. when
  • the Transaction type is 6 - Purchase
  • the Trade area is 0 - Taxable domestic according to VAT- and accounting inf./VAT code
7 - Non-taxable domestic purchases
Is used for purchases of non-taxable products. I.e. when
  • the Transaction type is 6 - Purchase
  • the Trade area is 1 - Non-taxable domestic
15 - Domestic purchases with reversed VAT deduction
11 - Transfer of goods between other EU countries
Used when
  • the Transaction type is 6 - Purchase
  • the Trade area is 5 - Transfer between other EU countries
  • Service type1 - Services is not selected
6 - Purchase of goods from EU countries
Used when
  • the Transaction type is 6 - Purchase
  • the Trade area is 2 - Within other EU country
  • Service type1 - Services is not selected
8 - Purchase of goods outside EU/Abroad
Used when
  • the Transaction type is 6 - Purchase
  • the Trade area is 3 - Outside EU/Abroad
  • Service type1 - Services is not selected
12 - Purchase of services abroad
Used when
  • the Transaction type is 6 - Purchase
  • the Trade area is 2 - Within other EU country or 5 - Transfer between other EU countries
  • Service type1 - Services is selected
14 - Non-taxable purchases
17 - Purchase outside tax area
19 - Purchase, taxable by purchaser
21 - Purchase of services from EU countries
23 - Domestic purchase of services
24 - Taxable product consumption
25 - Domestic purchases with reversed VAT liability
PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainTurnover classInteger
SQL nameTrnClThe database field name.
API identifierturnoverClassThe API identifier used in GraphQL.
Number12989 

VAT code

The VAT code with which the tax code automatic entry is associated.

In the Order table this is suggested on the basis of what is entered for the customer/supplier. If this field is empty the tax codes in the VAT- and accounting information table are used.

Note:
If you double-click or press * in this field, you can look up a value in the related table.
PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainVAT codeInteger
SQL nameTxCdNoThe database field name.
API identifiertaxCodeThe API identifier used in GraphQL.
Number12980 
Table 4. Table relations
To tablePurposeFrom columnsTo columnsComments
VAT codeTaxCode
  • VAT code

VAT code processing

Settings defining the behaviour of the VAT code.

A look-up opens the dialog box where you can see the following check boxes and options:
Non VAT-reportable
The Turnover class will be set to Non taxable, and VAT amount will not be calculated for general ledger and capital asset transactions, which will be produced when you update vouchers. Nor will the transactions be included in the VAT reports.
Do not calculate VAT amount
The Turnover class will be set to Non taxable, and VAT amount will not be calculated for general ledger and capital asset transactions, which will be produced when you update vouchers. The transaction will however be assigned VAT rate.
Exclude from Master Data Management
Agriculture
VAT compensation
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainVAT code processingInteger
SQL nameWgDProThe database field name.
API identifiertaxCodeProcessingThe API identifier used in GraphQL.
Number12988 

VAT information

Optional field for additional information.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainVAT informationText (22)
SQL nameTxInfThe database field name.
API identifiertaxInformationThe API identifier used in GraphQL.
Number12990 

VAT no.

The VAT rate.

Note:
Neither input nor output VAT is calculated on VAT codes where the VAT no. field is empty.

You can also use this field as a parameter in VAT reports. It is also possible to display turnover per. VAT no.

Note:
If you double-click or press * in this field, you can look up a value in the related table.
PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainVAT codeInteger
SQL nameVatNoThe database field name.
API identifiervatNoThe API identifier used in GraphQL.
Number12982 
Table 5. Table relations
To tablePurposeFrom columnsTo columnsComments
VAT rateVat
  • VAT no.

Withholding tax rate

The percentage rate for calculation of withholding tax.

Withholding tax is levied in some countries where customers pay part of VAT directly to the state.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainPercentDecimal
SQL nameWthTxRtThe database field name.
API identifierwithholdingTaxRateThe API identifier used in GraphQL.
Number12983 

Control columns

Control columns include information about who has changed the record last and when, and which process that is currently editing the record.

Changed by user

The name of the user that changed the record.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainUser nameText (24)
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameChUsrThe database field name.
API identifierchangedByUserThe API identifier used in GraphQL.
NumberA unique column number. 

Changed date

The date when the record was changed.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainDateInteger
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameChDtThe database field name.
API identifierchangedDateThe API identifier used in GraphQL.
NumberA unique column number. 

Changed time

The time when the record was changed.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainTimeInteger
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameChTmThe database field name.
API identifierchangedTimeThe API identifier used in GraphQL.
NumberA unique column number. 

Changed time stamp

The date and time when the record was changed.

The field is updated with the UTC time.

This value can be used by external systems to replicate changed data. The column is indexed. 

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainDate/timeDateTime
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameChTsThe database field name.
API identifierchangedTimestampThe API identifier used in GraphQL.
NumberA unique column number. 

Created by user

The name of the user that created the record.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainUser nameText (24)
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameCreUsrThe database field name.
API identifiercreatedByUserThe API identifier used in GraphQL.
NumberA unique column number. 

Created date

The date when the record was created.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainDateInteger
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameCreDtThe database field name.
API identifiercreatedDateThe API identifier used in GraphQL.
NumberA unique column number. 

Created time

The time when the record was created.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainTimeInteger
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameCreTmThe database field name.
API identifiercreatedTimeThe API identifier used in GraphQL.
NumberA unique column number. 

Created time stamp

The date and time when the record was created.

The field is updated with the UTC time.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainDate/timeDateTime
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameCreTsThe database field name.
API identifiercreatedTimestampThe API identifier used in GraphQL.
NumberA unique column number. 

Edit status

The current status of the record.

A look-up in this field gives you the following list of possible values:

0 - Unchanged: The record is read, but not changed.

1 - Inserted: The record is new.

2 - Changed: The record is changed.

3 - Deleted: The record is deleted.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainEdit statusInteger
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameLckStThe database field name.
API identifiereditStatusThe API identifier used in GraphQL.
NumberA unique column number. 

Process no

The Process no. from the Active company process table which is currently using or has control of this record.

Note:
If you double-click or press * in this field, you can look up a value in the related table.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainProcess no.Integer
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameChPrcThe database field name.
API identifierlockedByProcessNoThe API identifier used in GraphQL.
NumberA unique column number. 
Table 6. Table relations
To table Purpose From columns To columns Comments
Active company process CompanyProcess Process no. Process no.