Capital asset transaction

This table contains transactions posted on capital assets.

PropertyValueDescription
DatabaseCompanyThis table is in the company databases.
SQL namePropTrThe table name in the database.
API identifiercapitalAssetTransactionThe API identifier used in GraphQL.
Table no.171The table number in the data model.

The following fields exist in this table:

Account. year/period

The accounting year and accounting period saved as one field. This value can be used by external applications, e.g. reporting tools, to avoid having to merge the two fields accounting year and accounting period.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainYear/Per.Integer
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameAcYrPrThe database field name.
API identifieraccountingYearAndPeriodThe API identifier used in GraphQL.
Number11023 

Accounting document no.

The accounting document no refers to Incoming accounting document table.

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.
DomainNo.Integer
Write AccessSystem supervisor userOnly users who are marked as System supervisor in the User table are allowed to modify the value in this field.
SQL nameInAcDocNoThe database field name.
API identifierincomingAccountingDocumentNoThe API identifier used in GraphQL.
Number17962 
Table 1. Table relations
To tablePurposeFrom columnsTo columnsComments
Accounting documentIncomingAccountingDocument
  • Accounting document no.

Active approval task no.

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.
DomainApproval Task no.Integer
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameAcAppTskNoThe database field name.
API identifieractiveApprovalTaskNoThe API identifier used in GraphQL.
Number18977 
Table 2. Table relations
To tablePurposeFrom columnsTo columnsComments
Approval taskApprovalTask
  • Active approval task no.

Additional text

Any additional information entered in the voucher.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainTextText (200)
SQL nameTxt2The database field name.
API identifieradditionalTextThe API identifier used in GraphQL.
Number5820 

Amount in currency

Amount expressed in the foreign currency. The preceding sign is reversed if the transaction concerns a credit account number.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAmountDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameCurAmThe database field name.
API identifieramountInCurrencyThe API identifier used in GraphQL.
Number14226 

Amount in currency 2

Amount expressed in the currency2. The preceding sign is reversed if the transaction concerns a credit account number.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainAmountDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameCurAm2The database field name.
API identifieramountInCurrency2The API identifier used in GraphQL.
Number14322 

Amount in EURO

The Amount field converted to EURO.

If the standard currency, given in the Company information table is defined as Currency type 2 or 3 in the Currency table, the Amount in EURO will be calculated with the exchange rate given for Euro in Sales rate field in the Currency table.

If the standard currency, defined in the Company information table is defined as Currency type 0 or 1, please read the field help for the Currency table for explanation of how the amount in Euro is calculated.
Note:
The column is a calculated column, not stored in the database, which means that Amount in EURO in all tables where it exists will be updated if the Euro exchange rate in Currency table is changed.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainAmountDecimal
Source columnAmount in currencyEuro
Write AccessNoneYou are not allowed to modify the value in this field.
Memory fieldYesThe value in this field is only displayed in the program, it is not stored in the database.
API identifieramountInEuroThe API identifier used in GraphQL.
Number14229 

Audit no.

Part of the records unique identification together with the Voucher jour. no.

Every record that is added to the table carries a Voucher jour. no. that refers to the Updated journal table. The records created from the update carries an audit no that are allocated in consecutive order.
Note:
The audit no is distributed in consecutive order when the records for the General ledger transaction table, Customer transaction table, Supplier transaction table and Capital asset transaction table are updated. This means that the audit no sequence is not consecutive within the singel Translation table.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAudit no.Integer
Primary keyYesVoucher jour. no., Audit no.
SQL nameEntNoThe database field name.
API identifierauditNoThe API identifier used in GraphQL.
Number5420 

Balances not updated

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainBooleanInteger
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameBalUpdThe database field name.
API identifierbalancesNotUpdatedYetThe API identifier used in GraphQL.
Number19698 

Basis

Shows the basic amount for the calculation of VAT.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAmountDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameBasThe database field name.
API identifierbasisDomesticThe API identifier used in GraphQL.
Number5785 

Cap. asset no.

Shows the capital asset to which the transaction applies.

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.
DomainCap. asset no.Integer
Write AccessNoneYou are not allowed to modify the value in this field.
SQL namePropNoThe database field name.
API identifiercapitalAssetNoThe API identifier used in GraphQL.
Number5421 
Table 3. Table relations
To tablePurposeFrom columnsTo columnsComments
Capital assetCapitalAsset
  • Cap. asset no.
Capital asset balanceCapitalAssetBalance
  • Cap. asset no.
  • Year
  • Period
This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others.
Product transactionProductTransaction
  • Cap. asset no.
  • Invoice no.
This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others.
Product transaction before compressionProductTransaction2
  • Cap. asset no.
  • Invoice no.
This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others.

Capital asset proc.

Shows how the capital asset transaction was processed.

Note:
Entering a valid value in this field is mandatory, when a voucher line is entered, where the debit account or credit account contains a capital asset no. If not, the voucher line will not be possible to update. On capital asset transactions, therefore the field will always contain a valid value.
The capital asset processing determines which fields in the Capital asset balance table that will be updated and is essential to achieve correct depreciations.
A look-up in this field gives you the following list of possible values:
1 - Acquisition
To be used on records concerning the main acquisition of capital assets. E.g. cars, or buildings.
2 - Addition
To be used on records concerning additions. The definition of an "addition" is e.g. winter tyres for a car or marquises on a building. Additions can be given a lifetime, that differs from the main acquisition.
3 - Revaluation
To be used on records meant to adjust the total value of a capital asset. An example when a revaluation can be performed is when a very old real estate has a much higher market value, than the book value.
Note:
Revaluation shall NOT be performed when a capital asset has a lower value than expected due to under-usage, in this case the lifetime, and consequently the periodic depreciations, shall be adjusted instead.
Note:
Revaluation of capital assets is in most countries surrounded by legal restrictions and shall be performed only after accurate consideration.
4 - Devaluation
To be used on records meant to adjust the total value of a capital asset. An example when a devaluation can be performed is when the value of a real estate falls under the book value due to a financial crisis or another extraordinary occurrence.
Note:
Devaluation shall NOT be performed when a capital asset has a higher value than expected due to over-usage, in this case the lifetime, and consequently the periodic depreciations, shall be adjusted instead.
Note:
Devaluation of capital assets might be surrounded by legal restrictions in your country and shall be performed only after accurate consideration.
5 - Sale
To be used on records concerning sales of capital assets.
6 - Discarded
To be used on records concerning discard of capital assets.
7 - (Not in use)
Not in use.
8 - Back transfer
Resets depreciation when capital assets are sold or discarded.
9 - Depreciation on investment
10 - Depreciation on addition
11 - Depreciation on revaluation
12 - Depreciation on devaluation
PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainCapital asset proc.Integer
Write AccessNoneYou are not allowed to modify the value in this field.
SQL namePropPrcThe database field name.
API identifiercapitalAssetProcessingThe API identifier used in GraphQL.
Number5429 

Control status

Can be used by the user to give the record a freely definable status, for selecting during reporting / analysis routines.

Control status/Accounting trans. texts for different languages can be defined in the Text table. These texts has text type 55.
Note:
If you double-click or press * in this field, you can look up a Control status/Accounting trans. in the Text table.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainControl status/Accounting trans.Integer
SQL nameCtrlThe database field name.
API identifiercontrolStatusThe API identifier used in GraphQL.
Number5446 

Cost %

Stores the rate on which the system has based the calculation of the tax amount.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainPercentDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameCstPThe database field name.
API identifiercostPercentThe API identifier used in GraphQL.
Number5793 

Cost amount

Shows non-deductible received VAT amounts.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainAmountDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameCstAmThe database field name.
API identifiercostAmountDomesticThe API identifier used in GraphQL.
Number5794 

Country no.

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.
DomainCountry no.Integer
SQL nameCtryThe database field name.
API identifiercountryNoThe API identifier used in GraphQL.
Number17534 
Table 4. Table relations
To tablePurposeFrom columnsTo columnsComments
CountryCountry
  • Country no.

Credit

Defines that the amount is < 0.

The field can be used for selection of credit amounts. Eg for reporting and analysis purposes

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainBooleanInteger
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameCrThe database field name.
API identifiercreditThe API identifier used in GraphQL.
Number5431 

Credit amount in currency

The absolute value of the Amount in currency. The field is updated only if the Amount in currency is negative.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainAmountDecimal
Source columnAmount in currencyCredit
Write AccessNoneYou are not allowed to modify the value in this field.
Memory fieldYesThe value in this field is only displayed in the program, it is not stored in the database.
API identifiercreditAmountInCurrencyThe API identifier used in GraphQL.
Number14228 

Credit amount in EURO

The absolute value of the Amount in EURO. The field is updated only if the Amount in EURO is negative.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainAmountDecimal
Source columnCredit amount in currencyEuro
Write AccessNoneYou are not allowed to modify the value in this field.
Memory fieldYesThe value in this field is only displayed in the program, it is not stored in the database.
API identifiercreditAmountInEuroThe API identifier used in GraphQL.
Number14231 

Credit entered amount

The credit amount originally entered on the voucher line.

The amount can be incl VAT if it refers to purchase of a capital asset.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainAmountDecimal
Source columnEntered amountCredit
Write AccessNoneYou are not allowed to modify the value in this field.
Memory fieldYesThe value in this field is only displayed in the program, it is not stored in the database.
API identifiercreditEnteredAmountDomesticThe API identifier used in GraphQL.
Number5784 

Credit posted amount

The credit amount posted.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainAmountDecimal
Source columnPosted amountCredit
Write AccessNoneYou are not allowed to modify the value in this field.
Memory fieldYesThe value in this field is only displayed in the program, it is not stored in the database.
API identifiercreditPostedAmountDomesticThe API identifier used in GraphQL.
Number5433 

Cross-account no.

The cross account no that existed on the original voucher line.

If postings are made to both debit and credit accounts in the same voucher line, the Cross-account no. and Cross-account type fields indicate the customer, supplier, Capital assetor General ledger accountaccount relating to the other transaction generated from the voucher line.

If the Posting errors account from the Company information table has been used, because the original account is non-existent, the Cross-account no. and Cross-account type fields indicate instead the customer, supplier, Capital asset or General ledger account to which you attempted to post the voucher.

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.
DomainAccount no.Integer
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameAgAcNoThe database field name.
API identifiercrossAccountNoThe API identifier used in GraphQL.
Number5445 
Table 5. Table relations
To tablePurposeFrom columnsTo columnsComments
AssociateCrossCustomer
  • Cross-account no.
AssociateCrossSupplier
  • Cross-account no.
General ledger accountCrossGeneralLedgerAccount
  • Cross-account no.
Capital assetCrossCapitalAsset
  • Cross-account no.

Cross-account type

The cross account no that existed on the original voucher line.

If postings are made to both debit and credit accounts in the same voucher line, the Cross-account no. and Cross-account type fields indicate the customer, supplier, Capital asset or General ledger account account relating to the other transaction.

If the Posting errors account from the Company information table has been used, because the original account is non-existent, the Cross-account no. and Cross-account type fields indicate instead the customer, supplier, Capital asset or General ledger account to which you attempted to post the voucher.

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 defaultNoThis field is not visible by default in the table display.
DomainAccount typeInteger
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameAgAcClThe database field name.
API identifiercrossAccountTypeThe API identifier used in GraphQL.
Number5444 

Curr. corr. amount

The product of the most recent Curr. corr. exch. rate and the amount.

The field originally contains the same value as the Outstanding amount, or the Posted amount field if the correction is run on General ledger transaction or Capital asset transaction.

Each time the Currency correction processing is run, the field will be updated with the product of Curr. corr. exch. rate and Outstanding amount in currency or the Amount in currency if the correction is run on General ledger transaction or Capital asset transaction.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainAmountDecimal
SQL nameCurCAmThe database field name.
API identifiercurrencyCorrectionAmountThe API identifier used in GraphQL.
Number14233 

Curr. corr. date

The date for the last run of the Currency correction processing.

If no exchange rate adjustment has been performed, the field shows the same value as the Value date field.

The date is validated using the regional settings in Windows.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainDateInteger
SQL nameCurCDtThe database field name.
API identifiercurrencyCorrectionDateThe API identifier used in GraphQL.
Number14234 

Curr. corr. exch. rate

The Curr. corr. exch. rate from the latest run of the currency correction processing.

The field is updated when you run the Transfer corrections to table processing from the Currency correction data table. If no exchange rate adjustment has ever been performed, the field shows the same value as the Exchange rate field, which is inherited from the voucher.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainExchange rateDecimal
SQL nameCurCExRtThe database field name.
API identifiercurrencyCorrectionExchangeRateThe API identifier used in GraphQL.
Number14232 

Curr. corr. run no.

A unique number identifying the last run of the Currency correction processing.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainNo.Integer
SQL nameCurCRNoThe database field name.
API identifiercurrencyCorrectionRunNoThe API identifier used in GraphQL.
Number14235 

Currency no.

The records currency number.

The currency number is normally inherited from the voucher. If no currency number was entered on the voucher, the field will anyway be updated with the Currency no. from 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.
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.
Number14224 
Table 6. Table relations
To tablePurposeFrom columnsTo columnsComments
CurrencyCurrency
  • Currency no.

Currency no. 2

The records currency no 2 number, which is inherited from the voucher.

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.
DomainCurrency no.Integer
SQL nameCur2The database field name.
API identifiercurrencyNo2The API identifier used in GraphQL.
Number14320 
Table 7. Table relations
To tablePurposeFrom columnsTo columnsComments
CurrencyCurrency2
  • Currency no. 2

Debit amount in currency

The value of the Amount in currency. The field is updated only if the Amount in currency is positive.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainAmountDecimal
Source columnAmount in currencyDebit
Write AccessNoneYou are not allowed to modify the value in this field.
Memory fieldYesThe value in this field is only displayed in the program, it is not stored in the database.
API identifierdebitAmountInCurrencyThe API identifier used in GraphQL.
Number14227 

Debit amount in EURO

The value of the Amount in EURO. The field is updated only if the Amount in EURO is positive.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainAmountDecimal
Source columnDebit amount in currencyEuro
Write AccessNoneYou are not allowed to modify the value in this field.
Memory fieldYesThe value in this field is only displayed in the program, it is not stored in the database.
API identifierdebitAmountInEuroThe API identifier used in GraphQL.
Number14230 

Debit entered amount

The debit amount originally entered on the voucher line.

The amount can be incl VAT if it refers to sale of a capital asset.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainAmountDecimal
Source columnEntered amountDebit
Write AccessNoneYou are not allowed to modify the value in this field.
Memory fieldYesThe value in this field is only displayed in the program, it is not stored in the database.
API identifierdebitEnteredAmountDomesticThe API identifier used in GraphQL.
Number5783 

Debit posted amount

The debit amount posted.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainAmountDecimal
Source columnPosted amountDebit
Write AccessNoneYou are not allowed to modify the value in this field.
Memory fieldYesThe value in this field is only displayed in the program, it is not stored in the database.
API identifierdebitPostedAmountDomesticThe API identifier used in GraphQL.
Number5432 

Entered amount

Shows the amount you entered in the voucher line.

If the transaction line refers to a purchase or a sale of capital asset it can be incl VAT. Credit amounts will be shown with negative sign.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAmountDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameEntAmThe database field name.
API identifierenteredAmountDomesticThe API identifier used in GraphQL.
Number5782 

Error message

Any errors detected during a batch update.

If several errors are detected, they are listed with a comma separating them.

A look-up opens the dialog box where you can see the following check boxes and options:
Illegal value date
Unknown organisational unit 1
Unknown organisational unit 2
Unknown organisational unit 3
Unknown organisational unit 4
Unknown organisational unit 5
Unknown organisational unit 6
Unknown debit account, Cust. no., Account no. or Cap. asset no.
Unknown credit account, Cust. no., Account no. or Cap. asset no.
Unknown debit VAT code or VAT code
Unknown credit VAT code or VAT code
Unknown debit VAT rate
Unknown credit VAT rate
Unknown debit investment tax
Unknown credit investment tax
Unknown debit payment terms
Unknown credit payment terms
Unknown distribution key
Illegal debit turnover cl. or Turnover class
Illegal credit turnover cl. or Turnover class
Missing credit turnover cl. or Turnover class
The grace period for the debit has exceeded
The grace period for the credit has exceeded
Unknown organisational unit 7
Unknown organisational unit 8
Unknown organisational unit 9
Unknown organisational unit 10
Unknown organisational unit 11
Unknown organisational unit 12
Missing accounting period
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainError messageInteger
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameErrThe database field name.
API identifiererrorMessageThe API identifier used in GraphQL.
Number5443 

Exchange rate

The exchange rate for the currency.

Is updated from the Voucher table.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainExchange rateDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameExRtThe database field name.
API identifierexchangeRateThe API identifier used in GraphQL.
Number14225 

Exchange rate 2

The exchange rate for currency 2.

Is updated from the Voucher table.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainExchange rateDecimal
SQL nameExRt2The database field name.
API identifierexchangeRate2The API identifier used in GraphQL.
Number14321 

Free 1

Additional numeric information about the transaction.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainQuantityDecimal
SQL nameFree1The database field name.
API identifierfree1The API identifier used in GraphQL.
Number9169 

Free 2

Additional numeric information about the transaction.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainQuantityDecimal
SQL nameFree2The database field name.
API identifierfree2The API identifier used in GraphQL.
Number9170 

Free 3

Additional numeric information about the transaction.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainQuantityDecimal
SQL nameFree3The database field name.
API identifierfree3The API identifier used in GraphQL.
Number9171 

Free 4

Additional numeric information about the transaction.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainQuantityDecimal
SQL nameFree4The database field name.
API identifierfree4The API identifier used in GraphQL.
Number9172 

GL account

The General ledger account in which the transaction has been accumulated.

The General ledger account to which the transaction shall be accumulated can be defined in (in priority order)
  1. The Associate table for the specific associate.
  2. The Account no. series table.
  3. 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 defaultNoThis field is not visible by default in the table display.
DomainAccount no.Integer
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameGenAcNoThe database field name.
API identifiergeneralLedgerAccountNoThe API identifier used in GraphQL.
Number5434 
Table 8. Table relations
To tablePurposeFrom columnsTo columnsComments
General ledger accountGeneralLedgerAccount
  • GL account

Inv. tax rate

Not in use. (Relates to a former Norwegian tax, that has been removed.)

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainPercentDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameInvTxRtThe database field name.
API identifierinvestmentTaxRateThe API identifier used in GraphQL.
Number5790 

Invest. tax amount

Not in use. (Relates to a former Norwegian tax, that has been removed.)

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainAmountDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameInvTxAmThe database field name.
API identifierinvestmentTaxAmountDomesticThe API identifier used in GraphQL.
Number5787 

Invoice no.

The invoice number from the Voucher.

If the Invoice no. field is empty on the Voucher, this field will be updated with the Voucher no. field instead. This requires that Affects turn./purch. is selected in the Voucher type table.

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.
DomainDoc. no.Text (40)
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameInvoNoThe database field name.
API identifierinvoiceNoThe API identifier used in GraphQL.
Number14299 
Table 9. Table relations
To tablePurposeFrom columnsTo columnsComments
Product transactionProductTransaction
  • Cap. asset no.
  • Invoice no.
This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others.
Product transaction before compressionProductTransaction2
  • Cap. asset no.
  • Invoice no.
This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others.

Last curr. corr. amount

The last recalculated amount from the Currency correction processing.

The field will equal the Amount field if no Currency correction processing has been performed.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainAmountDecimal
SQL nameLastCAmThe database field name.
API identifierlastCurrencyCorrectionAmountThe API identifier used in GraphQL.
Number14237 

Memo file name

The file name for the Memo attached to the Customer transaction.

On the Editing menu, click Memo to create a new memo or to view the existing memo. The memo file name is saved in this text box.

Double-click or press * to open the Select file dialog box to manually select a memo file.

Note:
It is important that you save the file on a server and in a folder that is available to all users, otherwise users who try to open the memo will receive an error message.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainMemo file nameText (260)
SQL nameNoteNmThe database field name.
API identifiermemoFileNameThe API identifier used in GraphQL.
Number5447 

Memo no.

Link to the memo for the entry.

The actual memo is stored in the Memo table.

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.
DomainMemo no.Integer
SQL nameMemoNoThe database field name.
API identifiermemoNoThe API identifier used in GraphQL.
Number19214 
Table 10. Table relations
To tablePurposeFrom columnsTo columnsComments
MemoMemo
  • Memo no.

Order no.

Displays the order number for the purchase of the capital asset.

The number of the Order from which the transaction has its origin.

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.
DomainOrder no.Integer
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameOrdNoThe database field name.
API identifierorderNoThe API identifier used in GraphQL.
Number6528 
Table 11. Table relations
To tablePurposeFrom columnsTo columnsComments
OrderOrder
  • Order no.

Organisational unit 1

The organisational unit you entered in vouchers, possibly via the distribution key in vouchers.

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
SQL nameR1The database field name.
API identifierorgUnit1The API identifier used in GraphQL.
Number5435 
Table 12. Table relations
To tablePurposeFrom columnsTo columnsComments
Organisational unit 1OrgUnit1
  • Organisational unit 1

Organisational unit 2

The organisational unit you entered in vouchers, possibly via the distribution key in vouchers.

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
SQL nameR2The database field name.
API identifierorgUnit2The API identifier used in GraphQL.
Number5436 
Table 13. Table relations
To tablePurposeFrom columnsTo columnsComments
Organisational unit 2OrgUnit2
  • Organisational unit 2

Organisational unit 3

The organisational unit you entered in vouchers, possibly via the distribution key in vouchers.

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
SQL nameR3The database field name.
API identifierorgUnit3The API identifier used in GraphQL.
Number5437 
Table 14. Table relations
To tablePurposeFrom columnsTo columnsComments
Organisational unit 3OrgUnit3
  • Organisational unit 3

Organisational unit 4

The organisational unit you entered in vouchers, possibly via the distribution key in vouchers.

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
SQL nameR4The database field name.
API identifierorgUnit4The API identifier used in GraphQL.
Number5438 
Table 15. Table relations
To tablePurposeFrom columnsTo columnsComments
Organisational unit 4OrgUnit4
  • Organisational unit 4

Organisational unit 5

The organisational unit you entered in vouchers, possibly via the distribution key in vouchers.

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
SQL nameR5The database field name.
API identifierorgUnit5The API identifier used in GraphQL.
Number5439 
Table 16. Table relations
To tablePurposeFrom columnsTo columnsComments
Organisational unit 5OrgUnit5
  • Organisational unit 5

Organisational unit 6

The organisational unit you entered in vouchers, possibly via the distribution key in vouchers.

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
SQL nameR6The database field name.
API identifierorgUnit6The API identifier used in GraphQL.
Number5440 
Table 17. Table relations
To tablePurposeFrom columnsTo columnsComments
Organisational unit 6OrgUnit6
  • Organisational unit 6

Organisational unit 7

The organisational unit you entered in vouchers, possibly via the distribution key in vouchers.

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)
SQL nameR7The database field name.
API identifierorgUnit7The API identifier used in GraphQL.
Number9576 
Table 18. Table relations
To tablePurposeFrom columnsTo columnsComments
Organisational unit 7OrgUnit7
  • Organisational unit 7

Organisational unit 8

The organisational unit you entered in vouchers, possibly via the distribution key in vouchers.

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)
SQL nameR8The database field name.
API identifierorgUnit8The API identifier used in GraphQL.
Number9577 
Table 19. Table relations
To tablePurposeFrom columnsTo columnsComments
Organisational unit 8OrgUnit8
  • Organisational unit 8

Organisational unit 9

The organisational unit you entered in vouchers, possibly via the distribution key in vouchers.

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)
SQL nameR9The database field name.
API identifierorgUnit9The API identifier used in GraphQL.
Number9578 
Table 20. Table relations
To tablePurposeFrom columnsTo columnsComments
Organisational unit 9OrgUnit9
  • Organisational unit 9

Organisational unit 10

The organisational unit you entered in vouchers, possibly via the distribution key in vouchers.

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)
SQL nameR10The database field name.
API identifierorgUnit10The API identifier used in GraphQL.
Number9579 
Table 21. Table relations
To tablePurposeFrom columnsTo columnsComments
Organisational unit 10OrgUnit10
  • Organisational unit 10

Organisational unit 11

The organisational unit you entered in vouchers, possibly via the distribution key in vouchers.

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)
SQL nameR11The database field name.
API identifierorgUnit11The API identifier used in GraphQL.
Number9580 
Table 22. Table relations
To tablePurposeFrom columnsTo columnsComments
Organisational unit 11OrgUnit11
  • Organisational unit 11

Organisational unit 12

The organisational unit you entered in vouchers, possibly via the distribution key in vouchers.

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)
SQL nameR12The database field name.
API identifierorgUnit12The API identifier used in GraphQL.
Number9581 
Table 23. Table relations
To tablePurposeFrom columnsTo columnsComments
Organisational unit 12OrgUnit12
  • Organisational unit 12

Origin

Indicates whether the Voucher was entered manually or generated automatically.

The automatically generated transactions are labelled as to their origin (for example reminder, interest note or payment).

A look-up in this field gives you the following list of possible values:
1 - Manually entered
2 - Automatically generated
13 - Automatic entry
3 - VAT report
41 - OSS VAT report
10 - Direct debiting
4 - Reminder
5 - Interest note
8 - OCR payment
21 - Write off payments
6 - Giro payment
7 - Direct payment
11 - Depreciation on capital assets
9 - Order processing
23 - Incoming invoice
12 - Import
Normal text import.
14 - Previous batch
15 - Compressing transactions
16 - Posting of costs
18 - Internal invoicing
17 - Differences
When you update a batch with this origin code debit/credit control is not carried out.
19 - EDI invoice import
20 - Payroll
22 - Visma Business Services
24 - Activate Capital asset
25 - Calculate client interest
26 - Document Center temporary batch
27 - Document Center finished batch
28 - Debt collector
29 - Split invoice
30 - Currency correction
31 - External application
If this origin code is used, this value can be used by other applications that use BIG or SQL and create batches.
32 - Cash order document
33 - Sell or scrap capital asset
34 - Initializing capital asset
35 - EDI read dirdeb vouchers
37 - Accrual accounting
38 - Order processing with picking after invoicing
39 - Picked after invoicing
40 - Correction of costs
42 - Accounting document
Batch was created from Accounting document table.
43 - Order match pre-registration
44 - Self billing invoice
45 - Split batch, supplier transactions
Batch was created by Update supplier transactions processing for supplier transactions only.
46 - Split batch, cost transactions
Batch was created by Update supplier transactions processing for cost and capital transactions to be adjusted after payment.
47 - Account statement vouchers
Batch was created by Create voucher processing in the Account statement transaction table.
48 - WebFaktura
49 - Central
PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainOriginInteger
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameSrcTpThe database field name.
API identifieroriginThe API identifier used in GraphQL.
Number5441 

Original run no.

The Order journal number from which the transaction origin.

The number can be used to trace the transactions generated from orders.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainJournal no.Integer
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameSrcJNoThe database field name.
API identifieroriginalRunNoThe API identifier used in GraphQL.
Number5442 

Original voucher no.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainVoucher no.Integer
SQL nameOrVoNoThe database field name.
API identifieroriginalVoucherNoThe API identifier used in GraphQL.
Number18626 

Period

Shows the accounting period to which the transaction was posted.

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.
DomainPeriodInteger
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameAcPrThe database field name.
API identifierperiodThe API identifier used in GraphQL.
Number5426 
Table 24. Table relations
To tablePurposeFrom columnsTo columnsComments
Accounting periodAccountingPeriod
  • Year
  • Period
This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others.
Capital asset balanceCapitalAssetBalance
  • Cap. asset no.
  • Year
  • Period
This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others.

Period batch no.

The period batch number and the value is retrieved from the Batch.

The period batch number is included in automatic entries. On normal transactions, the value is taken from the Batch unless it is given on vouchers.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainNo.Integer
Write AccessNoneYou are not allowed to modify the value in this field.
SQL namePrBtThe database field name.
API identifierperiodBatchNoThe API identifier used in GraphQL.
Number10551 

Picture file name

the file name for the scanned image file for the vouchers.

Tip:
Double-clicking or pressing * in this box opens the picture. If the box is empty, a dialog box for selecting a picture file will open.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainPicture file nameText (260)
SQL namePictNoThe database field name.
API identifierpictureFileNameThe API identifier used in GraphQL.
Number9167 

Posted amount

The amount actually posted on the capital asset account in credit.

The amount is always shown excl VAT

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAmountDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameAcAmThe database field name.
API identifierpostedAmountDomesticThe API identifier used in GraphQL.
Number5430 

Previous voucher no.

The original voucher number when you reverse transactions.

Note:
This field is mainly to be used on credit notes
When transactions are reversed through the authorisation routine in the batches and vouchers, this field stores the original voucher no

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainVoucher no.Integer
SQL namePrevVoNoThe database field name.
API identifierpreviousVoucherNoThe API identifier used in GraphQL.
Number6258 

Running total

Use this field for account statements to show a running total in the printout.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainAmountDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
Memory fieldYesThe value in this field is only displayed in the program, it is not stored in the database.
API identifierrunningTotalDomesticThe API identifier used in GraphQL.
Number11006 

Running total in curr.

Use this field for account statements to show a running total in the printout.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainAmountDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
Memory fieldYesThe value in this field is only displayed in the program, it is not stored in the database.
API identifierrunningTotalInCurrencyThe API identifier used in GraphQL.
Number14236 

Scan doc. no.

The ID of the scanned document.

Is used in connection with Visma Document Center.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainNo.Integer
SQL namePLDNoThe database field name.
API identifierscanDocumentNoThe API identifier used in GraphQL.
Number11178 

Scan status

The status of the scanned document.

Is used in connection with Visma Document Center.

A look-up in this field gives you the following list of possible values:
1 - Scanned document
2 - Document on flow
4 - Document finished
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainScan statusInteger
SQL namePLDFlowThe database field name.
API identifierscanStatusThe API identifier used in GraphQL.
Number11179 

Sup. no.

Supplier number that was entered on the voucher line.

If the original voucher line contained a supplier no in the Debit account field or in the Credit account field, the supplier no will be automatically entered and inherited to the capital asset transaction

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.
DomainSup. no.Integer
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameSupThe database field name.
API identifiersupplierNoThe API identifier used in GraphQL.
Number5767 
Table 25. Table relations
To tablePurposeFrom columnsTo columnsComments
AssociateSupplier
  • Sup. no.

Text

The text of the transaction.

For automatically generated transactions Visma Business takes the Voucher type from the Voucher series for automatically generated transactions and the text field is filled in with the default text for this Voucher type.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainTextText (200)
SQL nameTxtThe database field name.
API identifiertextThe API identifier used in GraphQL.
Number5428 

Trans. status

Various transaction statuses, inherited from Voucher table.

A look-up opens the dialog box where you can see the following check boxes and options:

Overwritten

Amount excl. VAT
When you complete the Amount excl. VAT field in the Voucher table, this check box is selected.
VAT amount
This field is checked if you have overridden the VAT amount in the voucher line.
Org. unit
If organisational units are overridden in the General ledger transaction table, Business NXT defines a value here that indicates that the organisational unit has been corrected after updating.

Debt collector

Transferred to debt collector
This field applies only to open customer entries and customer transactions. Business NXT updates the field when you run the Transfer to debt collection processing.
Returned from debt collector
This field applies only to open customer entries and customer transactions. Business NXT updates the field when you run the Return from debt collection processing.
Added during debt collection
This field applies only to open customer entries and customer transactions. Business NXT updates the field when you run the List debt collection related transactions processing.

Duration

Permanent
All regular transactions.
Temporary
Business NXT uses this field in connection with reversal of transactions.
Reversing
Business NXT uses this field in connection with reversal of transactions.

Accounting rule

Created by an accounting rule
The option is automatically enabled when a voucher line is created by an accounting rule.
The field is greyed out in the following tables:
  • Customer transaction
  • Supplier transaction
  • General ledger transaction
  • Capital asset transaction
  • Open customer entry
  • Open supplier entry
Do not apply accounting rule

Per.

Per. Debit acc.
Per. Credit acc.

____

Do not create open entries
Business NXT does not produce open entries for the voucher line. This field overrides the Matching method parameter in the Company information table and Matching method cust./Matching method sup. in the Associate table. You can use this parameter, for example, when converting from other systems in which you want to refer to earlier transactions. You can also increase the speed when updating a batch if you define this flag for vouchers that you know are fully matched.
The field is greyed out in the following tables:
  • Customer transaction
  • Supplier transaction
  • General ledger transaction
  • Capital asset transaction
  • Open customer entry
  • Open supplier entry
Ref. Entry Free of interest
This comes from the order module and will exempt this entry and the cross-reference from interest computation in connection with updating.
Ref. Entry Free of reminder fee
If you in the Order table have selected the Ref. Entry Free of interest check box in Order options, this check box is selected. When you update the batch the post and the cross-references are exempted from interest calculation.
Credit note
Business NXT checks for credit note if the transaction is a credit entry for a customer or a debit entry for a supplier. Business NXT assumes that you have checked the Affects turn./purch. box in the Voucher type table for the relevant voucher type.

This field is used for customer transactions and supplier transactions, and is therefore greyed out in the voucher line.

Authorised
This field is checked if you have authorised a general ledger transaction. You can also check the field manually if the transaction has already been authorised.
Factoring performed
You only use this check box for open customer entries, and it is therefore greyed out in the voucher lines.
Period flow processed
Business NXT will select this field when you execute the Automatic entries processing in the General ledger account table.
Paid
Business NXT will select this field when you transfer the open entry to payment lines. You cannot select the field manually.

Business NXT inserts a cross in this field when you save a cross reference line which has a cross in the Payment reg. field. When you delete a voucher line, transaction status Paid is deleted if you press Delete in the cross reference line or the voucher line, and not in the batch head.

Partly paid in AutoPay
Automatically set when an open customer/supplier entry is updated as a partial payment, i.e. when an approver has overridden the payment amount in Visma.net AutoPay.
Cancelled/Rejected payment
This check box is selected when a payment line is cancelled or rejected. The Paid and Payment no. fields are then deleted, so that you can create payment for the entry once more. This requires that the parameter Set to "Cancelled" for payments not transferred in the EFT processing field of the Bank partner table has been checked.
Prepayment
This check box is selected when OCR transactions are imported containing advance payment. The routine enters the order number in the voucher line. This requires that you have selected the parameter Prepayment in Payment processing in the Company information or Factoring company tables.
Accept transactions with amount 0
If you select this field in a voucher line, transactions are produced even if both the amount and quantity are 0 (zero) in the voucher line.

In these voucher lines and updated voucher lines, 0 (zero) is shown instead of a blank Amount field (in default currency).

The Accept transactions with amount 0 field are greyed out when you open the dialog box in the Trans. status field from tables other than the Voucher table.

Direct debit from order
When posting invoices from the order system, Business NXT checks whether the customer has a direct debiting agreement, and whether the voucher date is within the applicable from and to dates for this. If so, the flag from Direct debit from order is placed in the Trans. status field in the voucher line. If this amount exceeds a maximum amount specified by the customer, the Exceeded max amount flag is inserted.
Exceeded max amount
When posting invoices from the order system, Business NXT checks whether the customer has a direct debiting agreement, and whether the voucher date is within the applicable from and to dates for this. If so, the flag from Direct debit from order is placed in the Trans. status field in the voucher line. If this amount exceeds a maximum amount specified by the customer, the Exceeded max amount flag is inserted.
Do not update exchange rate from voucher date
The voucher line’s exchange rate from the Currency rate or Currency rate 2 table will not be updated when you change the voucher date.
Debt collection voucher lines already expanded
Value date overridden
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainTrans. statusInteger
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameTransStThe database field name.
API identifiertransactionStatusThe API identifier used in GraphQL.
Number6269 

Turnover class

Shows the turnover class for the transaction.

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

Unit

The field is transferred from vouchers when Batch are updated.

Unit texts for different languages can be defined in the Text table. These texts has text type 16.
Note:
If you double-click or press * in this field, you can look up a Unit in the Text table.
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.
DomainUnitInteger
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameUnThe database field name.
API identifierunitThe API identifier used in GraphQL.
Number10550 
Table 26. Table relations
To tablePurposeFrom columnsTo columnsComments
UnitUnit
  • Unit

Updated batch no.

When batches are updated, a reference is filled in to transaction records produced from the batch.

The reference is important for the case when it is demanded to withdraw the record with the Create new voucher processing in the Updated voucher table.

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.
DomainBatch no.Integer
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameUpdBndNoThe database field name.
API identifierupdatedBatchNoThe API identifier used in GraphQL.
Number10958 
Table 27. Table relations
To tablePurposeFrom columnsTo columnsComments
Updated batchUpdatedBatch
  • Voucher jour. no.
  • Updated batch no.
This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others.
Updated voucherUpdatedVoucher
  • Voucher jour. no.
  • Updated batch no.
  • Updated voucher line no.
This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others.

Updated voucher line no.

When batches are updated, a reference is filled in to vouchers from which the voucher is produced in this field.

The reference is important for the case when it is demanded to withdraw the record with the Create new voucher processing in the Updated voucher table.

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.
DomainNo.Integer
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameUpdLnNoThe database field name.
API identifierupdatedVoucherLineNoThe API identifier used in GraphQL.
Number10959 
Table 28. Table relations
To tablePurposeFrom columnsTo columnsComments
Updated voucherUpdatedVoucher
  • Voucher jour. no.
  • Updated batch no.
  • Updated voucher line no.
This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others.

Value date

The value date for the voucher.

The date is validated using the regional settings in Windows.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainDateInteger
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameValDtThe database field name.
API identifiervalueDateThe API identifier used in GraphQL.
Number5424 

VAT amount

Is inherited from the Voucher line. If not entered on the voucher line, it will be inherited from the Batch.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAmountDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameVatAmThe database field name.
API identifiervatAmountDomesticThe API identifier used in GraphQL.
Number5786 

VAT amount in currency

Is inherited from the Voucher line. If not entered on the voucher line, it will be inherited from the Batch.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainAmountDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameCurVatAmThe database field name.
API identifiervatAmountInCurrencyThe API identifier used in GraphQL.
Number18153 

VAT code

Displays the VAT code for the transaction.

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.
Number5788 
Table 29. Table relations
To tablePurposeFrom columnsTo columnsComments
VAT codeTaxCode
  • VAT code

VAT period from voucher date

Shows the VAT period within which the voucher date falls and is in addition to the VAT term field.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainPeriodInteger
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameTxTrmVoDThe database field name.
API identifiertaxTermFromVoucherDateThe API identifier used in GraphQL.
Number8525 

VAT rate

Stores the rate on which the system has based the calculation of the tax amount.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainPercentDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameVatRtThe database field name.
API identifiervatRateThe API identifier used in GraphQL.
Number5789 

VAT report no.

Not in use.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainNo.Integer
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameTxStNoThe database field name.
API identifiertaxStatementNoThe API identifier used in GraphQL.
Number8896 

VAT term

Shows the VAT period to which the transaction belongs.

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.
DomainPeriodInteger
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameTxTrmThe database field name.
API identifiertaxTermThe API identifier used in GraphQL.
Number5781 
Table 30. Table relations
To tablePurposeFrom columnsTo columnsComments
VAT periodTaxTerm
  • VAT year
  • VAT term
This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others.

VAT year

Shows the VAT year to which the transaction belongs.

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.
DomainYearInteger
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameTxYrThe database field name.
API identifiertaxYearThe API identifier used in GraphQL.
Number5780 
Table 31. Table relations
To tablePurposeFrom columnsTo columnsComments
VAT periodTaxTerm
  • VAT year
  • VAT term
This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others.

VAT year from voucher date

Shows the VAT year within which the voucher date falls and is in addition to the VAT year field.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainYearInteger
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameTxYrVoDThe database field name.
API identifiertaxYearFromVoucherDateThe API identifier used in GraphQL.
Number8524 

Visma ID

The ID of the scanned document.

Is used in connection with Visma Document Center.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainNo.Integer
SQL nameWfIdThe database field name.
API identifiervismaIdThe API identifier used in GraphQL.
Number11177 

Voucher date

The date of the voucher. If the field is missing, the voucher date is set equal to the Value date.

The date is validated using the regional settings in Windows.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainDateInteger
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameVoDtThe database field name.
API identifiervoucherDateThe API identifier used in GraphQL.
Number5423 

Voucher group 1

The voucher group the transaction belongs to. It is inherited from the voucher line and can be defined in the Text table.

Voucher group 1 texts for different languages can be defined in the Text table. These texts has text type 163.
Note:
If you double-click or press * in this field, you can look up a Voucher group 1 in the Text table.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainVoucher group 1Integer
SQL nameVoGr1The database field name.
API identifiervoucherGroup1The API identifier used in GraphQL.
Number6160 

Voucher group 2

The voucher group the transaction belongs to. It is inherited from the voucher line and can be defined in the Text table.

Voucher group 2 texts for different languages can be defined in the Text table. These texts has text type 164.
Note:
If you double-click or press * in this field, you can look up a Voucher group 2 in the Text table.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainVoucher group 2Integer
SQL nameVoGr2The database field name.
API identifiervoucherGroup2The API identifier used in GraphQL.
Number6161 

Voucher jour. no.

A unique number identifying voucher journal number.

The same voucher journal number is allocated to customer, supplier, general ledger and capital asset transactions in each batch update. It is also allocated to the tables Updated batch, Updated voucher and Updated cross reference and is the major key to trace both the transactions origin and related transactions, such as automatically generated G/L transactions and VAT transactions.

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.
DomainJournal no.Integer
Primary keyYesVoucher jour. no., Audit no.
SQL nameJNoThe database field name.
API identifiervoucherJournalNoThe API identifier used in GraphQL.
Number5419 
Table 32. Table relations
To tablePurposeFrom columnsTo columnsComments
Updated journalUpdateJournal
  • Voucher jour. no.
Updated batchUpdatedBatch
  • Voucher jour. no.
  • Updated batch no.
This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others.
Updated voucherUpdatedVoucher
  • Voucher jour. no.
  • Updated batch no.
  • Updated voucher line no.
This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others.

Voucher no.

The voucher number the transaction applies to. For automatically generated transactions, the voucher number is taken from the voucher series for automatically generated transactions.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainVoucher no.Integer
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameVoNoThe database field name.
API identifiervoucherNoThe API identifier used in GraphQL.
Number5422 

Voucher type

The voucher type for the transaction. For automatically generated transactions, the voucher type is taken from the Voucher series for automatically generated transactions.

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.
DomainVoucher typeInteger
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameVoTpThe database field name.
API identifiervoucherTypeThe API identifier used in GraphQL.
Number5427 
Table 33. Table relations
To tablePurposeFrom columnsTo columnsComments
Voucher typeVoucherType
  • Voucher type

Web page

If you want to link a special web page to one of your vouchers, you can enter the address here.

The value in the field is transferred from vouchers to Updated voucher and on to the transactions and open entries.

If you use the Design/Add/Visualise menu item, Visma Business uses what is in this field.

Double-click or press * to open the web page in your web browser.

Alternatively the field can be used to refer to documents or other files. Double-click or press * in the empty field to open the Select file dialog box.

On the Design tab, in the Insert group, you can click on Web page to visualise the document or web page on the screen.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainWeb pageText (260)
SQL nameWebPgThe database field name.
API identifierwebPageThe API identifier used in GraphQL.
Number9168 

Withholding tax amount

Shows the withholding tax amount that the system has arrived at.

This type of tax is specific for the lithuanian market.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainAmountDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameWthAmThe database field name.
API identifierwithholdingTaxAmountDomesticThe API identifier used in GraphQL.
Number5792 

Withholding tax rate

This type of tax is specific for the lithuanian market.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainPercentDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameWthRtThe database field name.
API identifierwithholdingTaxRateThe API identifier used in GraphQL.
Number5791 

Workflow document ID

An identifier for a document, such as an invoice or a voucher, that is processed via Visma Business Workflow.

Workflow document ID is assigned when sending the document for approval. The identifier can be used to find the document for example in Visma.net Approval.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainWorkflow document IDInteger
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameWfDocIdThe database field name.
API identifierworkflowDocumentIdThe API identifier used in GraphQL.
Number18978 

Year

The relevant accounting year for the transactions. The year is deducted from the value date.

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.
DomainYearInteger
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameAcYrThe database field name.
API identifieryearThe API identifier used in GraphQL.
Number5425 
Table 34. Table relations
To tablePurposeFrom columnsTo columnsComments
Accounting periodAccountingPeriod
  • Year
  • Period
This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others.
Capital asset balanceCapitalAssetBalance
  • Cap. asset no.
  • Year
  • Period
This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others.

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