VAT code

This table contains one row for each tax code.

The entries are used in the Voucher table, to request calculation of taxes.

The following fields exist in this table:

Agriculture dataflow VAT category

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainString of length 3Text (3)
SQL nameLDVatCatThe database field name.
API identifieragricultureDataflowVatCategoryThe API identifier used in GraphQL.
Number18056 

Agriculture dataflow VAT type

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainString of length 1Text (1)
SQL nameLDVatTpThe database field name.
API identifieragricultureDataflowVatTypeThe API identifier used in GraphQL.
Number18055 

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 defaultYesThis field is visible by default in the table display.
DomainPercentDecimal
SQL nameCstPThe database field name.
API identifiercostPercentThe API identifier used in GraphQL.
Number601 

Description

The name of the VAT code.

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

Form no.

The form that will be used for the VAT report associated with this VAT code.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainForm no.Integer
SQL nameFormNoThe database field name.
API identifierformNoThe API identifier used in GraphQL.
Number13715 

Invest. tax no.

The investment tax the VAT code is using.

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.
Number602 
Table 1. Table relations
To tablePurposeFrom columnsTo columnsComments
Inv. taxInvestmentTax
  • Invest. tax no.

Non-taxable

VAT amount will not be calculated.

When selected, the Turnover class will be set to Non taxable. VAT amount will not be calculated for the general ledger transactions and capital asset transactions that are produced when updating vouchers. Nor will the transactions be included in the VAT reports. The Non VAT-reportable check box in the VAT code processing field will be selected.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainBooleanInteger
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.
Number7887 

SAF-T tax code

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainString of length 15Text (15)
SQL nameSfTxCdThe database field name.
API identifiersaftTaxCodeThe API identifier used in GraphQL.
Number18054 

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 defaultYesThis field is visible by default in the table display.
DomainService typeInteger
SQL nameServThe database field name.
API identifierserviceTypeThe API identifier used in GraphQL.
Number6889 

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.
Number8519 

VAT code

A unique number identifying the VAT code.

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 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 defaultYesThis field is visible by default in the table display.
DomainVAT codeInteger
Primary keyYesVAT code
SQL nameTxCdNoThe database field name.
API identifiertaxCodeThe API identifier used in GraphQL.
Number597 

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 defaultYesThis field is visible by default in the table display.
DomainVAT code processingInteger
SQL nameWgDProThe database field name.
API identifiertaxCodeProcessingThe API identifier used in GraphQL.
Number7888 

VAT information

Optional field for additional information.

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

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.
Number599 
Table 2. Table relations
To tablePurposeFrom columnsTo columnsComments
VAT rateVat
  • VAT no.

VAT rate type

Used for identifying VAT rate types in outgoing XML invoices.

A look-up in this field gives you the following list of possible values:
1 - High
2 - Medium
3 - Low
4 - Zero
5 - Exempt
PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainVAT rate typeInteger
SQL nameVatRtTpThe database field name.
API identifiervatRateTypeThe API identifier used in GraphQL.
Number17528 

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.
Number4855 

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 3. Table relations
To table Purpose From columns To columns Comments
Active company process CompanyProcess Process no. Process no.