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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not 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 | 12984 |
Description
The name of the tax code automatic entry.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not 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 | 12981 |
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.
| 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 | 12985 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Inv. tax | InvestmentTax |
|
Line no.
A unique number identifying tax code automatic entry.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | No. | Integer |
| Primary key | Yes | Line no. |
| SQL name | PK | The database field name. |
| API identifier | lineNo | The API identifier used in GraphQL. |
| Number | 12979 |
New account no.
An account used for the vouchers that will be split between different VAT rates.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Account no. | Integer |
| SQL name | NwAcNo | The database field name. |
| API identifier | newAccountNo | The API identifier used in GraphQL. |
| Number | 13748 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| General ledger account | NewAccount |
|
New tax code no.
The VAT code to be used for the share entered in the Share field.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | VAT code | Integer |
| SQL name | NwTxCdNo | The database field name. |
| API identifier | newTaxCodeNo | The API identifier used in GraphQL. |
| Number | 13747 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| VAT code | NewTaxCode |
|
Non-taxable
This field is no longer in use. Be aware the field may be removed in later versions.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Boolean | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| 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 | 12987 |
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 | No | This field is not 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 | 12986 |
Share
The share of the voucher that is to be processed using the VAT code entered in the New tax code no. field.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Percent | Decimal |
| SQL name | Shr | The database field name. |
| API identifier | share | The API identifier used in GraphQL. |
| Number | 12991 |
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 | 12989 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | VAT code | Integer |
| SQL name | TxCdNo | The database field name. |
| API identifier | taxCode | The API identifier used in GraphQL. |
| Number | 12980 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| VAT code | TaxCode |
|
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 | No | This field is not 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 | 12988 |
VAT information
Optional field for additional information.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not 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 | 12990 |
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 | 12982 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| VAT rate | Vat |
|
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 | 12983 |
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. |