All accounts

This table contains accounts of different account types, such as customers, suppliers, general ledger accounts and capital assets.

This table is defined as a view in the database.

PropertyValueDescription
DatabaseCompanyThis table is a view in the company databases.
View nameAllAcNoThis table is a view and only displayed in the program, it is not stored in the database.
API identifierallAccountsThe API identifier used in GraphQL.
Table no.368The table number in the data model.

The following fields exist in this table:

Account no.

The customer no., supplier no., general ledger account no. or capital asset no., depending on the Account type field.

The Account no. is used as a reference in all tables that refer to the General ledger account. It also applies for voucher entries and budgeting, to ensure the relevant General ledger account is used. The Norwegian Standard uses four-digit account numbers.

If you want the Account no. to be made up of a minimum number of digits, enter the number in the Digits in account no. w/0 field in the Company information table. If you enter a new General ledger account with fewer digits than the number you specified in this field, Visma Business adds the relevant number of zeros in front of the digit to meet the criterion. You can still enter Account no. with more digits than the number you specified in the Digits in account no. w/0 field.

Note:
This does not affect existing account numbers that consist of more digits.

If you define a number series for General ledger account numbers in the Account no. series tables, the Account no. will be suggested accordingly. If you follow the number series, the Account no. will be a unique account reference, and you can hide the Account type field in the Voucher entry window.

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
Primary keyYesAccount no., Account type
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameAcNoThe database field name.
API identifieraccountNoThe API identifier used in GraphQL.
Number16084 
Table 1. Table relations
To tablePurposeFrom columnsTo columnsComments
AssociateSwitchCustomer
  • Account no.
AssociateSwitchSupplier
  • Account no.
General ledger accountSwitchGeneralLedgerAccount
  • Account no.
Capital assetSwitchCapitalAsset
  • Account no.

Account type

The type of account.

A look-up in this field gives you the following list of possible values:
1 - Customer
The account number refer to a customer.
2 - Supplier
The account number refer to a supplier.
3 - General ledger account
The account number refer to a general ledger account.
4 - Capital asset
The account number refer to a capital asset.
PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAccount typeInteger
Primary keyYesAccount no., Account type
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameAcTpThe database field name.
API identifieraccountTypeThe API identifier used in GraphQL.
Number16085 

Address line 1

The address for the customer/supplier.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAddress lineText (60)
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameAd1The database field name.
API identifieraddressLine1The API identifier used in GraphQL.
Number16092 

Address line 2

The address for the customer/supplier.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAddress lineText (60)
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameAd2The database field name.
API identifieraddressLine2The API identifier used in GraphQL.
Number16093 

Address line 3

The address for the customer/supplier.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAddress lineText (60)
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameAd3The database field name.
API identifieraddressLine3The API identifier used in GraphQL.
Number16094 

Address line 4

The address for the customer/supplier.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAddress lineText (60)
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameAd4The database field name.
API identifieraddressLine4The API identifier used in GraphQL.
Number16095 

Associate no.

The associate no. for the customer/supplier.

Tip:
On start-up you should create an associate manually, for example with the associate number 1000 or 10000 depending on the number of digits you want to use in the employee number. This means you can use the same number as the employee number and associate number. The employee then only needs to use an employee number when an associate number is used in CRM.
Tip:
When converting from another system, you should use customer numbers and supplier numbers as associate numbers. This makes it easier to link to contacts.

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.
DomainAssociate no.Integer
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameActNoThe database field name.
API identifierassociateNoThe API identifier used in GraphQL.
Number16118 
Table 2. Table relations
To tablePurposeFrom columnsTo columnsComments
AssociateAssociate
  • Associate no.

Bank account

The bank account no. for the customer/supplier.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainBank accountText (35)
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameBGiroThe database field name.
API identifierbankAccountThe API identifier used in GraphQL.
Number16102 

Country no.

The country for the customer/supplier.

You define default country in the Company information table. The Country no. field is used to enter the country number that applies to the associate.

When the country number is entered, values get updated in the Language no. and Currency no. fields if you have entered this information for the relevant country in the Country table. The values can be changed if required. The country number determines, amongst other things, the parameters to be used for invoicing, reminders and calculation of interest. The field appears in two sets in the order head, and is suggested based of the customer/supplier and the recipient. If required, the country can also be edited out in forms as a part of the address, by retrieving the name of the country (or nationality code) from the Country table.

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.
DomainCountry no.Integer
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameCtryThe database field name.
API identifiercountryNoThe API identifier used in GraphQL.
Number16098 
Table 3. Table relations
To tablePurposeFrom columnsTo columnsComments
CountryCountry
  • Country no.

Currency no.

The currency for the customer/supplier/general ledger account/capital asset.

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.
DomainCurrency no.Integer
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameCurThe database field name.
API identifiercurrencyNoThe API identifier used in GraphQL.
Number16089 
Table 4. Table relations
To tablePurposeFrom columnsTo columnsComments
CurrencyCurrency
  • Currency no.

ISO code

The ISO code found in the Country table for the country referred to in the Country no. field.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainISO codeText (3)
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameISOCtryThe database field name.
API identifiercountryIsoCodeThe API identifier used in GraphQL.
Number16099 

ISO code

The ISO code found in the Currency table for the currency referred to in the Currency no. field.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainISO codeText (3)
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameISOCurThe database field name.
API identifiercurrencyIsoCodeThe API identifier used in GraphQL.
Number16090 

Name

The name of the customer/supplier/general ledger account/capital asset.

The account name is displayed in the status bar when references to the account are made during voucher entry and budgeting to help you check that you are referring to the right account. The account name is also displayed when you include a reference to the Account no. in the Company information, Currency, Voucher type, VAT rate, Automatic entry and Associate tables.

The account name can be included in lists and reports such as account listings and balance lists, as well as specific Profit and loss account and balance sheet reports.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainNameText (80)
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameNmThe database field name.
API identifiernameThe API identifier used in GraphQL.
Number16086 

Organisation no.

The ID at the authorities for the customer/supplier.

When addresses are transferred to the Associate table, this field is used for validations.
Note:
This is not the same as VAT no.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainOrganisation no.Text (24)
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameBsNoThe database field name.
API identifiercompanyNoThe API identifier used in GraphQL.
Number16100 

Organisational unit 1

The organisational unit for the customer/supplier/general ledger account/capital asset.

Organisational units fields can be used freely according to company needs to split accounting, sales and purchases into organisational units. The most common types are department, project and campaign. It is also possible to limit the organisational units a user should see by limiting the organisational units in the Limitation groups, User limitation groups and Limitations. The field appear with the name assigned to it in the Company information table.

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.
DomainOrganisational unit no.Integer
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameR1The database field name.
API identifierorgUnit1The API identifier used in GraphQL.
Number16105 
Table 5. Table relations
To tablePurposeFrom columnsTo columnsComments
Organisational unit 1OrgUnit1
  • Organisational unit 1

Organisational unit 2

The organisational unit for the customer/supplier/general ledger account/capital asset.

Organisational units fields can be used freely according to company needs to split accounting, sales and purchases into organisational units. The most common types are department, project and campaign. It is also possible to limit the organisational units a user should see by limiting the organisational units in the Limitation groups, User limitation groups and Limitations. The field appear with the name assigned to it in the Company information table.

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.
DomainOrganisational unit no.Integer
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameR2The database field name.
API identifierorgUnit2The API identifier used in GraphQL.
Number16106 
Table 6. Table relations
To tablePurposeFrom columnsTo columnsComments
Organisational unit 2OrgUnit2
  • Organisational unit 2

Organisational unit 3

The organisational unit for the customer/supplier/general ledger account/capital asset.

Organisational units fields can be used freely according to company needs to split accounting, sales and purchases into organisational units. The most common types are department, project and campaign. It is also possible to limit the organisational units a user should see by limiting the organisational units in the Limitation groups, User limitation groups and Limitations. The field appear with the name assigned to it in the Company information table.

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.
DomainOrganisational unit no.Integer
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameR3The database field name.
API identifierorgUnit3The API identifier used in GraphQL.
Number16107 
Table 7. Table relations
To tablePurposeFrom columnsTo columnsComments
Organisational unit 3OrgUnit3
  • Organisational unit 3

Organisational unit 4

The organisational unit for the customer/supplier/general ledger account/capital asset.

Organisational units fields can be used freely according to company needs to split accounting, sales and purchases into organisational units. The most common types are department, project and campaign. It is also possible to limit the organisational units a user should see by limiting the organisational units in the Limitation groups, User limitation groups and Limitations. The field appear with the name assigned to it in the Company information table.

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.
DomainOrganisational unit no.Integer
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameR4The database field name.
API identifierorgUnit4The API identifier used in GraphQL.
Number16108 
Table 8. Table relations
To tablePurposeFrom columnsTo columnsComments
Organisational unit 4OrgUnit4
  • Organisational unit 4

Organisational unit 5

The organisational unit for the customer/supplier/general ledger account/capital asset.

Organisational units fields can be used freely according to company needs to split accounting, sales and purchases into organisational units. The most common types are department, project and campaign. It is also possible to limit the organisational units a user should see by limiting the organisational units in the Limitation groups, User limitation groups and Limitations. The field appear with the name assigned to it in the Company information table.

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.
DomainOrganisational unit no.Integer
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameR5The database field name.
API identifierorgUnit5The API identifier used in GraphQL.
Number16109 
Table 9. Table relations
To tablePurposeFrom columnsTo columnsComments
Organisational unit 5OrgUnit5
  • Organisational unit 5

Organisational unit 6

The organisational unit for the customer/supplier/general ledger account/capital asset.

Organisational units fields can be used freely according to company needs to split accounting, sales and purchases into organisational units. The most common types are department, project and campaign. It is also possible to limit the organisational units a user should see by limiting the organisational units in the Limitation groups, User limitation groups and Limitations. The field appear with the name assigned to it in the Company information table.

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.
DomainOrganisational unit no.Integer
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameR6The database field name.
API identifierorgUnit6The API identifier used in GraphQL.
Number16110 
Table 10. Table relations
To tablePurposeFrom columnsTo columnsComments
Organisational unit 6OrgUnit6
  • Organisational unit 6

Organisational unit 7

The organisational unit for the customer/supplier/general ledger account/capital asset.

The field appear with the name assigned to it in the Company information table.

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.
DomainLong alphanumeric organisational unit no.Text (40)
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameR7The database field name.
API identifierorgUnit7The API identifier used in GraphQL.
Number16111 
Table 11. Table relations
To tablePurposeFrom columnsTo columnsComments
Organisational unit 7OrgUnit7
  • Organisational unit 7

Organisational unit 8

The organisational unit for the customer/supplier/general ledger account/capital asset.

The field appear with the name assigned to it in the Company information table.

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.
DomainShort alphanumeric organisational unit no.Text (10)
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameR8The database field name.
API identifierorgUnit8The API identifier used in GraphQL.
Number16112 
Table 12. Table relations
To tablePurposeFrom columnsTo columnsComments
Organisational unit 8OrgUnit8
  • Organisational unit 8

Organisational unit 9

The organisational unit for the customer/supplier/general ledger account/capital asset.

The field appear with the name assigned to it in the Company information table.

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.
DomainShort alphanumeric organisational unit no.Text (10)
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameR9The database field name.
API identifierorgUnit9The API identifier used in GraphQL.
Number16113 
Table 13. Table relations
To tablePurposeFrom columnsTo columnsComments
Organisational unit 9OrgUnit9
  • Organisational unit 9

Organisational unit 10

The organisational unit for the customer/supplier/general ledger account/capital asset.

The field appear with the name assigned to it in the Company information table.

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.
DomainShort alphanumeric organisational unit no.Text (10)
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameR10The database field name.
API identifierorgUnit10The API identifier used in GraphQL.
Number16114 
Table 14. Table relations
To tablePurposeFrom columnsTo columnsComments
Organisational unit 10OrgUnit10
  • Organisational unit 10

Organisational unit 11

The organisational unit for the customer/supplier/general ledger account/capital asset.

The field appear with the name assigned to it in the Company information table.

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.
DomainShort alphanumeric organisational unit no.Text (10)
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameR11The database field name.
API identifierorgUnit11The API identifier used in GraphQL.
Number16115 
Table 15. Table relations
To tablePurposeFrom columnsTo columnsComments
Organisational unit 11OrgUnit11
  • Organisational unit 11

Organisational unit 12

The organisational unit for the customer/supplier/general ledger account/capital asset.

The field appear with the name assigned to it in the Company information table.

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.
DomainShort alphanumeric organisational unit no.Text (10)
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameR12The database field name.
API identifierorgUnit12The API identifier used in GraphQL.
Number16116 
Table 16. Table relations
To tablePurposeFrom columnsTo columnsComments
Organisational unit 12OrgUnit12
  • Organisational unit 12

Phone

The phone number for the customer/supplier.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainPhoneText (20)
Write AccessNoneYou are not allowed to modify the value in this field.
SQL namePhoneThe database field name.
API identifierphoneThe API identifier used in GraphQL.
Number16104 

Postal area

The postal area for the customer/supplier.

If you enter a postcode that exists in the Postal address table, Business NXT fills in the Postal area field and the cursor jumps to the next field.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAddress lineText (60)
Write AccessNoneYou are not allowed to modify the value in this field.
SQL namePAreaThe database field name.
API identifierpostalAreaThe API identifier used in GraphQL.
Number16097 

Postal giro

The postal giro no. for the customer/supplier.

This is relevant if you want to print completed postal giro forms in connection with reminders, interest notes and payments, or if you use electronic funds transfer. You can restrict payments to associates for whom at least one of the Bank account or Postal giro fields is completed. To do this you must select the Payment if giro no. option in the Payment processing field in the Company information table.

Note:
For suppliers who are remitted via electronic funds transfer, you must enter the correct postal giro number. Otherwise they will be remitted by direct payment. (This depends on the settings in Z Data).
Note:
The postal giro can be validated according to different rules. The validation is controlled in the Country processing field in the Country table.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainBank accountText (35)
Write AccessNoneYou are not allowed to modify the value in this field.
SQL namePGiroThe database field name.
API identifierpostalGiroThe API identifier used in GraphQL.
Number16103 

Post code

The post code for the customer/supplier.

If you enter a Post code that exists in the Postal address table, the Postal area field is filled in and the cursor jumps to the next field. If the Post code does not exist you will see a warning in the Status bar and the cursor will then stop in the Postal area field so you can type in the Postal area manually.

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.
DomainPost codeText (40)
Write AccessNoneYou are not allowed to modify the value in this field.
SQL namePNoThe database field name.
API identifierpostCodeThe API identifier used in GraphQL.
Number16096 
Table 17. Table relations
To tablePurposeFrom columnsTo columnsComments
Postal addressPostalAddress
  • Post code

Short name

The short name for the customer/supplier/general ledger account.

Business NXT suggests the contents in the field when you enter a value in the Name field.

Note:
If you have accidentally deleted the name of the associate, this field contains the original name which was entered the first time. This enables you to restore names which have been deleted.

Example

If you enter the customer AS Ole Hansen in the Name field, this customer is sorted under A in an alphabetical list of names. To sort the customer under the letter H instead, you enter Hansen, Ole AS in the Short name field. For an alphabetical list of your customers, sort using the Short name field instead of the Name field.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainNameText (80)
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameShrtThe database field name.
API identifiershortNameThe API identifier used in GraphQL.
Number16091 

Suspended

Indicates whether the customer/supplier/general ledger account/capital asset is suspended.

We recommend that you suspend all account that you post via ledger. This makes sure that the ledger entries in the general ledger are posted via ledgers, thereby also reducing the risk of differences between the ledger and the general ledger. In the General ledger account table supplied with the standard table structure, this option is selected in the General ledger account for customers and suppliers (account numbers 1500 and 2410). These are only posted in the context of automated transactions.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainString of length 1Text (1)
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameSuspThe database field name.
API identifiersuspendedThe API identifier used in GraphQL.
Number16117 

Turnover class

The turnover class normally used for the customer/supplier/general ledger account/capital asset.

For customers and suppliers, the field is derived from the Trade area field in the Associate table.

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
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameTxClThe database field name.
API identifierturnoverClassThe API identifier used in GraphQL.
Number16088 

VAT code

The VAT code normally used for the customer/supplier/general ledger account/capital asset.

This VAT code is suggested whenever a Voucher is entered for this general ledger account. The VAT code determines the type of VAT and the VAT rate to apply to the voucher.

Note:
If the Ignore VAT code field is selected for the Voucher type used in posting the voucher, no suggestion for the VAT code will be made, even if one is defined for the account. In the Voucher type table supplied with the standard table structure, this only applies to the balance and foreign currency balance Voucher type (types 29 and 30). These Voucher type are used for entering opening balances.

If you imported the standard table structure during setup, the most common VAT code will have been entered in this table.

Note:
The VAT code must correspond with the account's Turnover class, otherwise there will be a difference in the VAT statement.

A General ledger account which is taxable (i.e. turnover class 1 or 4), MUST have a VAT code which calculates received or paid VAT respectively. The VAT class determines which accounts are added up in the total taxable purchases and sales for the VAT statement. These figures will not agree with the automatically posted taxes if vouchers have been posted with a VAT code that does NOT correspond to the VAT class.

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
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameTxCdThe database field name.
API identifiertaxCodeThe API identifier used in GraphQL.
Number16087 
Table 18. Table relations
To tablePurposeFrom columnsTo columnsComments
VAT codeTaxCode
  • VAT code

VAT reg. no.

The VAT registration no. for the customer/supplier.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainOrganisation no.Text (24)
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameEUTaxNoThe database field name.
API identifiereuVatRegistrationNoThe API identifier used in GraphQL.
Number16101 

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 provenance

The provenance for the record change.

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

0 - None

1 - UI

10 - External API

20 - GAiA

21 - AI Connect

100 - Internal service

101 - Task automation

102 - AutoInvoice download

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

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 provenance

The provenance for the record creation.

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

0 - None

1 - UI

10 - External API

20 - GAiA

21 - AI Connect

100 - Internal service

101 - Task automation

102 - AutoInvoice download

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainProvenanceInteger
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameCrePvnThe database field name.
API identifiercreatedByProvenanceThe 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 19. Table relations
To table Purpose From columns To columns Comments
Active company process CompanyProcess Process no. Process no.