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
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | String of length 3 | Text (3) |
| SQL name | LDVatCat | The database field name. |
| API identifier | agricultureDataflowVatCategory | The API identifier used in GraphQL. |
| Number | 18056 |
Agriculture dataflow VAT type
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | String of length 1 | Text (1) |
| SQL name | LDVatTp | The database field name. |
| API identifier | agricultureDataflowVatType | The API identifier used in GraphQL. |
| Number | 18055 |
Cost %
The proportion that is non-deductible, if the company is not eligible for received taxes to be deducted in full.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Percent | Decimal |
| SQL name | CstP | The database field name. |
| API identifier | costPercent | The API identifier used in GraphQL. |
| Number | 601 |
Description
The name of the VAT code.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Name | Text (80) |
| SQL name | Descr | The database field name. |
| API identifier | description | The API identifier used in GraphQL. |
| Number | 598 |
Form no.
The form that will be used for the VAT report associated with this VAT code.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Form no. | Integer |
| SQL name | FormNo | The database field name. |
| API identifier | formNo | The API identifier used in GraphQL. |
| Number | 13715 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | VAT code | Integer |
| SQL name | InvTxNo | The database field name. |
| API identifier | investmentTaxNo | The API identifier used in GraphQL. |
| Number | 602 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Inv. tax | InvestmentTax |
|
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Boolean | Integer |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | nonTaxable | The API identifier used in GraphQL. |
| Number | 7887 |
SAF-T tax code
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | String of length 15 | Text (15) |
| SQL name | SfTxCd | The database field name. |
| API identifier | saftTaxCode | The API identifier used in GraphQL. |
| Number | 18054 |
Service type
A turnover class for services will be selected in the vouchers rather than one for goods.
- 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
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Service type | Integer |
| SQL name | Serv | The database field name. |
| API identifier | serviceType | The API identifier used in GraphQL. |
| Number | 6889 |
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.
- 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
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Turnover class | Integer |
| SQL name | TrnCl | The database field name. |
| API identifier | turnoverClass | The API identifier used in GraphQL. |
| Number | 8519 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | VAT code | Integer |
| Primary key | Yes | VAT code |
| SQL name | TxCdNo | The database field name. |
| API identifier | taxCode | The API identifier used in GraphQL. |
| Number | 597 |
VAT code processing
Settings defining the behaviour of the VAT code.
- 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
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | VAT code processing | Integer |
| SQL name | WgDPro | The database field name. |
| API identifier | taxCodeProcessing | The API identifier used in GraphQL. |
| Number | 7888 |
VAT information
Optional field for additional information.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | VAT information | Text (22) |
| SQL name | TxInf | The database field name. |
| API identifier | taxInformation | The API identifier used in GraphQL. |
| Number | 8732 |
VAT no.
The VAT rate.
You can also use this field as a parameter in VAT reports. It is also possible to display turnover per. VAT no.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | VAT code | Integer |
| SQL name | VatNo | The database field name. |
| API identifier | vatNo | The API identifier used in GraphQL. |
| Number | 599 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| VAT rate | Vat |
|
VAT rate type
Used for identifying VAT rate types in outgoing XML invoices.
- 1 - High
- 2 - Medium
- 3 - Low
- 4 - Zero
- 5 - Exempt
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | VAT rate type | Integer |
| SQL name | VatRtTp | The database field name. |
| API identifier | vatRateType | The API identifier used in GraphQL. |
| Number | 17528 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Percent | Decimal |
| SQL name | WthTxRt | The database field name. |
| API identifier | withholdingTaxRate | The API identifier used in GraphQL. |
| Number | 4855 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | User name | Text (24) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | ChUsr | The database field name. |
| API identifier | changedByUser | The API identifier used in GraphQL. |
| Number | A unique column number. |
Changed date
The date when the record was changed.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Date | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | ChDt | The database field name. |
| API identifier | changedDate | The API identifier used in GraphQL. |
| Number | A unique column number. |
Changed time
The time when the record was changed.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Time | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | ChTm | The database field name. |
| API identifier | changedTime | The API identifier used in GraphQL. |
| Number | A 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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Date/time | DateTime |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | ChTs | The database field name. |
| API identifier | changedTimestamp | The API identifier used in GraphQL. |
| Number | A unique column number. |
Created by user
The name of the user that created the record.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | User name | Text (24) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | CreUsr | The database field name. |
| API identifier | createdByUser | The API identifier used in GraphQL. |
| Number | A unique column number. |
Created date
The date when the record was created.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Date | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | CreDt | The database field name. |
| API identifier | createdDate | The API identifier used in GraphQL. |
| Number | A unique column number. |
Created time
The time when the record was created.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Time | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | CreTm | The database field name. |
| API identifier | createdTime | The API identifier used in GraphQL. |
| Number | A unique column number. |
Created time stamp
The date and time when the record was created.
The field is updated with the UTC time.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Date/time | DateTime |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | CreTs | The database field name. |
| API identifier | createdTimestamp | The API identifier used in GraphQL. |
| Number | A 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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Edit status | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | LckSt | The database field name. |
| API identifier | editStatus | The API identifier used in GraphQL. |
| Number | A unique column number. |
Process no
The Process no. from the Active company process table which is currently using or has control of this record.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Process no. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | ChPrc | The database field name. |
| API identifier | lockedByProcessNo | The API identifier used in GraphQL. |
| Number | A unique column number. |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Active company process | CompanyProcess | Process no. | Process no. |