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.
| Property | Value | Description |
|---|---|---|
| Database | Company | This table is a view in the company databases. |
| View name | AllAcNo | This table is a view and only displayed in the program, it is not stored in the database. |
| API identifier | allAccounts | The API identifier used in GraphQL. |
| Table no. | 368 | The 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.
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Account no. | Integer |
| Primary key | Yes | Account no., Account type |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | AcNo | The database field name. |
| API identifier | accountNo | The API identifier used in GraphQL. |
| Number | 16084 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Associate | SwitchCustomer |
| ||
| Associate | SwitchSupplier |
| ||
| General ledger account | SwitchGeneralLedgerAccount |
| ||
| Capital asset | SwitchCapitalAsset |
|
Account type
The type of account.
- 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.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Account type | Integer |
| Primary key | Yes | Account no., Account type |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | AcTp | The database field name. |
| API identifier | accountType | The API identifier used in GraphQL. |
| Number | 16085 |
Address line 1
The address for the customer/supplier.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Address line | Text (60) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | Ad1 | The database field name. |
| API identifier | addressLine1 | The API identifier used in GraphQL. |
| Number | 16092 |
Address line 2
The address for the customer/supplier.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Address line | Text (60) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | Ad2 | The database field name. |
| API identifier | addressLine2 | The API identifier used in GraphQL. |
| Number | 16093 |
Address line 3
The address for the customer/supplier.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Address line | Text (60) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | Ad3 | The database field name. |
| API identifier | addressLine3 | The API identifier used in GraphQL. |
| Number | 16094 |
Address line 4
The address for the customer/supplier.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Address line | Text (60) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | Ad4 | The database field name. |
| API identifier | addressLine4 | The API identifier used in GraphQL. |
| Number | 16095 |
Associate no.
The associate no. for the customer/supplier.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Associate no. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | ActNo | The database field name. |
| API identifier | associateNo | The API identifier used in GraphQL. |
| Number | 16118 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Associate | Associate |
|
Bank account
The bank account no. for the customer/supplier.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Bank account | Text (35) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | BGiro | The database field name. |
| API identifier | bankAccount | The API identifier used in GraphQL. |
| Number | 16102 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Country no. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | Ctry | The database field name. |
| API identifier | countryNo | The API identifier used in GraphQL. |
| Number | 16098 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Country | Country |
|
Currency no.
The currency for the customer/supplier/general ledger account/capital asset.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Currency no. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | Cur | The database field name. |
| API identifier | currencyNo | The API identifier used in GraphQL. |
| Number | 16089 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Currency | Currency |
|
ISO code
The ISO code found in the Country table for the country referred to in the Country no. field.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | ISO code | Text (3) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | ISOCtry | The database field name. |
| API identifier | countryIsoCode | The API identifier used in GraphQL. |
| Number | 16099 |
ISO code
The ISO code found in the Currency table for the currency referred to in the Currency no. field.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | ISO code | Text (3) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | ISOCur | The database field name. |
| API identifier | currencyIsoCode | The API identifier used in GraphQL. |
| Number | 16090 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Name | Text (80) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | Nm | The database field name. |
| API identifier | name | The API identifier used in GraphQL. |
| Number | 16086 |
Organisation no.
The ID at the authorities for the customer/supplier.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Organisation no. | Text (24) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | BsNo | The database field name. |
| API identifier | companyNo | The API identifier used in GraphQL. |
| Number | 16100 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Organisational unit no. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | R1 | The database field name. |
| API identifier | orgUnit1 | The API identifier used in GraphQL. |
| Number | 16105 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 1 | OrgUnit1 |
|
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Organisational unit no. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | R2 | The database field name. |
| API identifier | orgUnit2 | The API identifier used in GraphQL. |
| Number | 16106 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 2 | OrgUnit2 |
|
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Organisational unit no. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | R3 | The database field name. |
| API identifier | orgUnit3 | The API identifier used in GraphQL. |
| Number | 16107 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 3 | OrgUnit3 |
|
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Organisational unit no. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | R4 | The database field name. |
| API identifier | orgUnit4 | The API identifier used in GraphQL. |
| Number | 16108 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 4 | OrgUnit4 |
|
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Organisational unit no. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | R5 | The database field name. |
| API identifier | orgUnit5 | The API identifier used in GraphQL. |
| Number | 16109 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 5 | OrgUnit5 |
|
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Organisational unit no. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | R6 | The database field name. |
| API identifier | orgUnit6 | The API identifier used in GraphQL. |
| Number | 16110 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 6 | OrgUnit6 |
|
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Long alphanumeric organisational unit no. | Text (40) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | R7 | The database field name. |
| API identifier | orgUnit7 | The API identifier used in GraphQL. |
| Number | 16111 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 7 | OrgUnit7 |
|
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Short alphanumeric organisational unit no. | Text (10) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | R8 | The database field name. |
| API identifier | orgUnit8 | The API identifier used in GraphQL. |
| Number | 16112 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 8 | OrgUnit8 |
|
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Short alphanumeric organisational unit no. | Text (10) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | R9 | The database field name. |
| API identifier | orgUnit9 | The API identifier used in GraphQL. |
| Number | 16113 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 9 | OrgUnit9 |
|
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Short alphanumeric organisational unit no. | Text (10) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | R10 | The database field name. |
| API identifier | orgUnit10 | The API identifier used in GraphQL. |
| Number | 16114 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 10 | OrgUnit10 |
|
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Short alphanumeric organisational unit no. | Text (10) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | R11 | The database field name. |
| API identifier | orgUnit11 | The API identifier used in GraphQL. |
| Number | 16115 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 11 | OrgUnit11 |
|
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Short alphanumeric organisational unit no. | Text (10) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | R12 | The database field name. |
| API identifier | orgUnit12 | The API identifier used in GraphQL. |
| Number | 16116 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 12 | OrgUnit12 |
|
Phone
The phone number for the customer/supplier.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Phone | Text (20) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | Phone | The database field name. |
| API identifier | phone | The API identifier used in GraphQL. |
| Number | 16104 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Address line | Text (60) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | PArea | The database field name. |
| API identifier | postalArea | The API identifier used in GraphQL. |
| Number | 16097 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Bank account | Text (35) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | PGiro | The database field name. |
| API identifier | postalGiro | The API identifier used in GraphQL. |
| Number | 16103 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Post code | Text (40) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | PNo | The database field name. |
| API identifier | postCode | The API identifier used in GraphQL. |
| Number | 16096 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Postal address | PostalAddress |
|
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.
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.| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Name | Text (80) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | Shrt | The database field name. |
| API identifier | shortName | The API identifier used in GraphQL. |
| Number | 16091 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | String of length 1 | Text (1) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | Susp | The database field name. |
| API identifier | suspended | The API identifier used in GraphQL. |
| Number | 16117 |
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.
- 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 |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | TxCl | The database field name. |
| API identifier | turnoverClass | The API identifier used in GraphQL. |
| Number | 16088 |
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.
If you imported the standard table structure during setup, the most common VAT code will have been entered in this table.
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | VAT code | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | TxCd | The database field name. |
| API identifier | taxCode | The API identifier used in GraphQL. |
| Number | 16087 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| VAT code | TaxCode |
|
VAT reg. no.
The VAT registration no. for the customer/supplier.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Organisation no. | Text (24) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | EUTaxNo | The database field name. |
| API identifier | euVatRegistrationNo | The API identifier used in GraphQL. |
| Number | 16101 |
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
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Provenance | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | ChPvn | The database field name. |
| API identifier | changedByProvenance | The API identifier used in GraphQL. |
| Number | A unique column number. |
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 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
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Provenance | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | CrePvn | The database field name. |
| API identifier | createdByProvenance | 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. |