Open supplier entry

This table contains supplier entries that awaits matching.

Entries that are fully or partially open are included, indicated by one of the following values in the Paid status field:
  • 1 - Fully open entry
  • 2 - Partially open entry
The entries need to have one of the following values in the Matching method field in the Company information table:
  • 1 - Manual
  • 2 - Ascending date
  • 3 - Same amount
  • 4 - Entered references

Alternatively, the Matching method value may be overridden by the Matching method sup. field in the Associate table.

All entries appear in the Supplier transaction table, and edits are synchronized when they are saved.

PropertyValueDescription
DatabaseCompanyThis table is in the company databases.
SQL nameOpSupTrThe table name in the database.
API identifieropenSupplierEntryThe API identifier used in GraphQL.
Table no.59The 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.
Number11020 

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.
Number17959 
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.
Number18971 
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.
Number5821 

Amount

This is taken from vouchers. 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 nameAmThe database field name.
API identifieramountDomesticThe API identifier used in GraphQL.
Number1325 

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

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

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

Approval token

Token for payment pre-approved in Visma.net AutoPay.

The transaction has been approved for payment in Visma.net Approval. When this token follows the payment, approval of the payment in Visma.net AutoPay should not be required.

If the payment is rejected/cancelled in Visma.net AutoPay, the token will be removed from the row.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainApproval tokenText (40)
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameApTkThe database field name.
API identifierapprovalTokenThe API identifier used in GraphQL.
Number18558 

Approval workflow handle

Reference to a workflow in Visma.net Approval.

Used in Visma.net AutoPay for viewing of invoices.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainApproval workflow handleText (36)
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameApWfHThe database field name.
API identifierapprovalWorkflowHandleThe API identifier used in GraphQL.
Number18815 

Att. voucher no.

Set equal to the Voucher no. field in the authorisation voucher line. It is assumed that the Voucher no. field for the entry is equal to Previous voucher no. in the voucher line.

See also: Authorisation

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

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 defaultNoThis field is not 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.
Number1311 

Auth. date 1

Up to two authorisation dates can be entered. The fields are information fields only, and can be used for selection.

The fields can for example be used in connection with electronic funds transfer. In some companies, incoming invoices must be authorised by several people, for example invoices that are to be distributed between several organisational units. Business NXT sets the Auth. date 1 field to the current date when entries are authorised. If you delete the field in the Open supplier entry table, the transaction status for the general ledger transaction that it has been authorised is withdrawn.

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 nameAttDt1The database field name.
API identifierauthorisationDate1The API identifier used in GraphQL.
Number1339 

Auth. date 2

Up to two authorisation dates can be entered. The fields are information fields only, and can be used for selection.

The fields can for example be used in connection with electronic funds transfer. In some companies, incoming invoices must be authorised by several people, for example invoices that are to be distributed between several organisational units. Business NXT sets the Auth. date 1 field to the current date when entries are authorised. If you delete the field in the Open supplier entry table, the transaction status for the general ledger transaction that it has been authorised is withdrawn.

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 nameAttDt2The database field name.
API identifierauthorisationDate2The API identifier used in GraphQL.
Number1340 

Auth. responsible

You can make an entry in this field when you enter vouchers, or in the Open supplier entry table. If an incoming invoice is to be authorised, the employee number of the authorising official is entered here.

The Empl. no. is a unique number identifying one specific Employee.

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.
DomainEmpl. no.Integer
SQL nameAttThe database field name.
API identifierapprovalOfficialThe API identifier used in GraphQL.
Number1338 
Table 3. Table relations
To tablePurposeFrom columnsTo columnsComments
AssociateApprovalOfficial
  • Auth. responsible

Bank account

Updated from the Bank account field on the vouchers.

If you did not complete the field during entry, Visma Business will retrieve the giro number from the Bank account or Postal giro field for the relevant associate in the Associate table.

The value in the field is also transferred to the Payment line table when you create a payment suggestion.

This field is also used for IBAN bank account numbers, depending on the recipient's country. You must in some cases also complete the Bank branch and Swift code fields. Which fields you must complete depend on the recipients country requirements. You can contact your bank or supplier for more information about this.

Note:
The Bank account can be validated according to different rules and to disable this validation you have to set some option in the Country processing field in the Country table.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainBank accountText (35)
SQL nameBankGThe database field name.
API identifierbankAccountThe API identifier used in GraphQL.
Number5822 

Bank account line no.

The recipient's bank account can here be overridden by other entered bank accounts.

In this way, the outlay retrieves data from a bank account other than the default bank account.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainNo.Integer
SQL nameBankAcLnThe database field name.
API identifierbankAccountLineNoThe API identifier used in GraphQL.
Number11450 

Bank no.

The number of the bank.

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.
DomainBank no.Integer
SQL nameBankConThe database field name.
API identifierbankNoThe API identifier used in GraphQL.
Number11449 
Table 4. Table relations
To tablePurposeFrom columnsTo columnsComments
BankBank
  • Bank no.

Cash amount

Comes from vouchers or is calculated on the basis of the Payment terms.

If no cash amount is entered on the voucher line, but a payment term with a cash discount has been entered, the cash amount will be calculated during the update and inserted on this record

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainAmountDecimal
SQL nameCshAmThe database field name.
API identifiercashAmountDomesticThe API identifier used in GraphQL.
Number4962 

Cash amount in currency

Comes from the Voucher or is calculated on the basis of the Payment terms.

If no Cash amount is entered on the Voucher line, but a payment term with a cash discount has been entered, the cash amount will be calculated during the update and inserted on this record

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainAmountDecimal
SQL nameCshCurAmThe database field name.
API identifiercashAmountInCurrencyThe API identifier used in GraphQL.
Number4961 

Cash amount in EURO

Comes from vouchers or is calculated on the basis of the Payment terms.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainAmountDecimal
Source columnCash 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 identifiercashAmountInEuroThe API identifier used in GraphQL.
Number7746 

Cash due date

Comes from vouchers.

If you have not entered the cash due date on an invoice, it is calculated on the basis of the Voucher date and Payment terms if the Payment terms carries a cash discount %.

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 nameCshDueDtThe database field name.
API identifiercashDueDateThe API identifier used in GraphQL.
Number4960 

CID code

Code used for electronic funds transfer.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainCID codeText (30)
SQL nameCIDThe database field name.
API identifiercidThe API identifier used in GraphQL.
Number1337 

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

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.
Number17531 
Table 5. 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.
Number4812 

Credit amount

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

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainAmountDecimal
Source columnAmountCredit
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 identifiercreditAmountDomesticThe API identifier used in GraphQL.
Number4626 

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

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

Credit outstanding amount

The absolute value of the Outstanding amount field. The field is updated only if the Outstanding amount is negative.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainAmountDecimal
Source columnOutstanding 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 identifiercreditOutstandingAmountDomesticThe API identifier used in GraphQL.
Number4628 

Credit outstanding amount in currency

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

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainAmountDecimal
Source columnOutstanding amount 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 identifiercreditOutstandingAmountInCurrencyThe API identifier used in GraphQL.
Number4624 

Credit outstanding amount in EURO

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

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainAmountDecimal
Source columnCredit outstanding 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 identifiercreditOutstandingAmountInEuroThe API identifier used in GraphQL.
Number7739 

Credit quantity

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

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainQuantityDecimal
Source columnQuantityCredit
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 identifiercreditQuantityThe API identifier used in GraphQL.
Number4638 

Credited amount

The field is not in use.

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 nameCNAmThe database field name.
API identifiercreditedAmountDomesticThe API identifier used in GraphQL.
Number8472 

Cross reference

You use this field to match an invoice against payments or credit notes.

The cross reference can be entered in the Cross reference field on the voucher and will update this field on customer transactions, open customer entries, supplier transactions and open supplier entries.

If a cross reference has been entered on a voucher, this voucher will match against the open supplier entry or an open customer entry with the same value in its reference field.

The cross reference can also be entered or overridden direct in the Open supplier entry or the Open supplier entry table, to complete the entries before running the Match references processing in these tables.

The Cross reference field in the Customer transaction table and the Supplier transaction table will show the reference of the open entry to which the transaction was matched, but only if the matching was performed by running the processing Match entry-for-entry.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainDoc. no.Text (40)
SQL nameAgRefThe database field name.
API identifiercrossReferenceThe API identifier used in GraphQL.
Number1332 

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.
Number4360 
Table 6. 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.
Number4359 

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

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

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

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

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.
Number1321 
Table 7. 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.
Number14307 
Table 8. Table relations
To tablePurposeFrom columnsTo columnsComments
CurrencyCurrency2
  • Currency no. 2

Date 1

Used by some bank reconciliation systems to assign a date to processed transactions.

If the field is already filled in, the value is overwritten by the bank reconciliation system. If bank reconciliation is not in use the field can be used manually.

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 nameDt1The database field name.
API identifierdate1The API identifier used in GraphQL.
Number12771 

Date 2

Used by some bank reconciliation systems to assign a date to processed transactions.

If the field is already filled in, the value is overwritten by the bank reconciliation system. If bank reconciliation is not in use the field can be used manually.

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 nameDt2The database field name.
API identifierdate2The API identifier used in GraphQL.
Number12772 

Debit amount

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

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainAmountDecimal
Source columnAmountDebit
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 identifierdebitAmountDomesticThe API identifier used in GraphQL.
Number4625 

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

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

Debit outstanding amount

The value of the Outstanding amount field. The field is updated only if the Outstanding amount is positive.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainAmountDecimal
Source columnOutstanding 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 identifierdebitOutstandingAmountDomesticThe API identifier used in GraphQL.
Number4627 

Debit outstanding amount in currency

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

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainAmountDecimal
Source columnOutstanding amount 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 identifierdebitOutstandingAmountInCurrencyThe API identifier used in GraphQL.
Number4623 

Debit outstanding amount in EURO

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

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainAmountDecimal
Source columnDebit outstanding 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 identifierdebitOutstandingAmountInEuroThe API identifier used in GraphQL.
Number7738 

Debit quantity

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

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainQuantityDecimal
Source columnQuantityDebit
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 identifierdebitQuantityThe API identifier used in GraphQL.
Number4637 

Deduct currency no.

The currency number you want to use for the payment.

The currency number you want Business NXT to use for the payment if it diverts from the suppliers standard currency.

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 namePmtCurThe database field name.
API identifierdeductCurrencyNoThe API identifier used in GraphQL.
Number11451 
Table 9. Table relations
To tablePurposeFrom columnsTo columnsComments
CurrencyChargeDebitCurrency
  • Deduct currency no.

Delivery associate no.

This field is updated from the vouchers.

The receiver of the products. It will only have a value if the receiver of the product is different from the receiver of the invoice.

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.
DomainAssociate no.Integer
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameDelActNoThe database field name.
API identifierdeliveryAssociateNoThe API identifier used in GraphQL.
Number8924 
Table 10. Table relations
To tablePurposeFrom columnsTo columnsComments
AssociateDeliveryAssociate
  • Delivery associate no.

Due date

Is updated from the Voucher.

If you have not entered a due date on an invoice voucher, it will be calculated on the basis of the Voucher date and the Payment terms fields. If you have not entered the due date (i.e. the payment date) in payments and credit notes vouchers, it is set equal to the voucher date.

Due date can be overridden. The new date is used for Reminder, interest computation and payment history.

The Due date field is also used when you execute the Create payment suggestion processing from the corresponding open entry table. A selection will be made in relation to the outlay 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
SQL nameDueDtThe database field name.
API identifierdueDateThe API identifier used in GraphQL.
Number1327 

EFT bank fee code

Used in connection with electronic funds transfer.

The values are included on open supplier entries and supplier transactions.

EFT bank fee texts for different languages can be defined in the Text table. These texts has text type 130.
Note:
If you double-click or press * in this field, you can look up a EFT bank fee in the Text table.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainEFT bank feeInteger
SQL nameEFT2The database field name.
API identifiereftBankFeeCodeThe API identifier used in GraphQL.
Number6632 

EFT currency code

Used in connection with electronic funds transfer.

The values are included on open supplier entries and supplier transactions.

EFT Currency code texts for different languages can be defined in the Text table. These texts has text type 129.
Note:
If you double-click or press * in this field, you can look up a EFT Currency code in the Text table.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainEFT Currency codeInteger
SQL nameEFT1The database field name.
API identifiereftCurrencyCodeThe API identifier used in GraphQL.
Number6631 

EFT decl. code

Used in connection with electronic funds transfer.

For payment abroad, this field is used to enter the declaration code in accordance with national rules. You define valid values and related texts in the Declaration code table. The values are included on open supplier entries and supplier transactions.

EFT declaration code texts for different languages can be defined in the Text table. These texts has text type 131.
Note:
If you double-click or press * in this field, you can look up a EFT declaration code 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.
DomainEFT declaration codeInteger
SQL nameEFT3The database field name.
API identifiereftDeclarationCodeThe API identifier used in GraphQL.
Number6633 
Table 11. Table relations
To tablePurposeFrom columnsTo columnsComments
Declaration codeEftDeclarationCode
  • EFT decl. code

EFT form type

Used in connection with electronic funds transfer. (Danish formats only.)

For Danish payment formats, you can use:
  • 1 = giro transfer with notification without payment ID
  • 4 = giro transfer without notification with payment ID
  • 15 = giro transfer with notification and payment ID
  • 71 = money order without notification with payment ID
  • 73 = money order with notification without payment ID
  • 75 = money order with notification and payment ID
Note:
Run the Mandatory text types processing from the Company information table, and set the text type EFT form type to mandatory. This will prevent you from entering an incorrect code.
EFT form type texts for different languages can be defined in the Text table. These texts has text type 203.
Note:
If you double-click or press * in this field, you can look up a EFT form type in the Text table.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainEFT form typeInteger
SQL nameEftFrmTpThe database field name.
API identifiereftFormTypeThe API identifier used in GraphQL.
Number15463 

EFT paym. method

Used in connection with electronic funds transfer.

The values are included on open supplier entries and supplier transactions.

EFT payment method texts for different languages can be defined in the Text table. These texts has text type 132.
Note:
If you double-click or press * in this field, you can look up a EFT payment method in the Text table.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainEFT payment methodInteger
SQL nameEFT4The database field name.
API identifiereftPaymentMethodThe API identifier used in GraphQL.
Number6634 

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

Estimated pay date

The date on which you intend an invoice to be paid. Business NXT initially sets the field equal to the cash due date or the due date in the invoice.

This date is used as basis for transactions to be picked when processing Create payment suggestion in table Open supplier entry is run.

You can automatically have the estimated payment date set to a workday in the voucher line before update, if the calculated payment date is a Saturday for example. You can thus have payment-free days. To make use of this, proceed as follows:

  • Select the Move payment to weekday column in the Voucher type table.
  • Select the days which are to be payment free in the Days without payment field in the Company information table. You should also choose whether you want to move the payment date to before or after the payment free days.
  • Enter incoming invoices.

The date is validated using the regional settings in Windows.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainDateInteger
SQL nameEstPayDtThe database field name.
API identifierestimatedPayDateThe API identifier used in GraphQL.
Number1335 

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

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

External reference 1

Used by some bank reconciliation system to show processed transactions.

If the field is already filled in, the value is overwritten by the bank reconciliation system. The value is updated from Voucher. If a bank reconciliation system is not in use the field can be used manually.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainString of length 20Text (20)
SQL nameExtRef1The database field name.
API identifierexternalReference1The API identifier used in GraphQL.
Number12769 

External reference 2

Used by some bank reconciliation system to show processed transactions.

If the field is already filled in, the value is overwritten by the bank reconciliation system. The value is updated from Voucher. If a bank reconciliation system is not in use the field can be used manually.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainString of length 20Text (20)
SQL nameExtRef2The database field name.
API identifierexternalReference2The API identifier used in GraphQL.
Number12770 

External reference 3

Used by some bank reconciliation system to show processed transactions.

If the field is already filled in, the value is overwritten by the bank reconciliation system. The value is updated from Voucher. If a bank reconciliation system is not in use the field can be used manually.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainString of length 20Text (20)
SQL nameExtRef3The database field name.
API identifierexternalReference3The API identifier used in GraphQL.
Number12796 

Fixed amount

A fraction of the Amount from which no cash discount shall be deducted.

The fixed amount is given on the voucher and can contain of eg freight, packaging, insurance or other parts of the total invoice amount from which no cash discount shall be deducted.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainAmountDecimal
SQL nameFixAmThe database field name.
API identifierfixedAmountDomesticThe API identifier used in GraphQL.
Number6245 

Fixed amount in currency

A fraction of the Amount in currency from which no cash discount shall be deducted.

The fixed amount in currency is given on the voucher and can contain of eg freight, packaging, insurance or other parts of the total invoice amount from which no cash discount shall be deducted.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainAmountDecimal
SQL nameFixCurAmThe database field name.
API identifierfixedAmountInCurrencyThe API identifier used in GraphQL.
Number6244 

Fixed amount in EURO

A fraction of the Amount in EURO from which no cash discount shall be deducted.

The fixed Amount in EURO is derived from the fixed Amount in currency

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainAmountDecimal
Source columnFixed 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 identifierfixedAmountInEuroThe API identifier used in GraphQL.
Number7748 

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

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

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

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

Giro no. check sum

When you use a bank giro number, Business NXT can check, via BIG, that the cheque sum stated agrees with the giro number on the same line.

Note:
The use of a Giro no check sum on the voucher line is obsolete since version 5.10 when a default check sum functionality was implemented. This can be activated / deactivated for each country in the countries table

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainNo.Integer
SQL nameGiroChSmThe database field name.
API identifiergiroNoCheckSumThe API identifier used in GraphQL.
Number10496 

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.
Number1350 
Table 12. Table relations
To tablePurposeFrom columnsTo columnsComments
General ledger accountGeneralLedgerAccount
  • GL account

Invoice currency amount

The amount in the invoice currency on printouts.

Only relevant on payments where the currency differ from the currency on the matched invoice.

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 identifierinvoiceAmountInCurrencyThe API identifier used in GraphQL.
Number4489 

Invoice no.

The invoice number from the Voucher.

Will be updated with voucher number if there is no invoice number on the voucher and you have selected Affects turn./purch. in the Voucher type table.

Note:
You are not allowed to change the value in this field. To enable editing of the field you must select Allow change of invoice no. on open entries in the Accounting processing 2 field in the Company information table.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainDoc. no.Text (40)
SQL nameInvoNoThe database field name.
API identifierinvoiceNoThe API identifier used in GraphQL.
Number1329 

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

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

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.
Number19209 
Table 13. Table relations
To tablePurposeFrom columnsTo columnsComments
MemoMemo
  • Memo no.

Order no.

Is updated from the Voucher.

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.
Number3365 
Table 14. 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 defaultNoThis field is not visible by default in the table display.
DomainOrganisational unit no.Integer
SQL nameR1The database field name.
API identifierorgUnit1The API identifier used in GraphQL.
Number1342 
Table 15. 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 defaultNoThis field is not visible by default in the table display.
DomainOrganisational unit no.Integer
SQL nameR2The database field name.
API identifierorgUnit2The API identifier used in GraphQL.
Number1343 
Table 16. 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 defaultNoThis field is not visible by default in the table display.
DomainOrganisational unit no.Integer
SQL nameR3The database field name.
API identifierorgUnit3The API identifier used in GraphQL.
Number1344 
Table 17. 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 defaultNoThis field is not visible by default in the table display.
DomainOrganisational unit no.Integer
SQL nameR4The database field name.
API identifierorgUnit4The API identifier used in GraphQL.
Number1345 
Table 18. 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 defaultNoThis field is not visible by default in the table display.
DomainOrganisational unit no.Integer
SQL nameR5The database field name.
API identifierorgUnit5The API identifier used in GraphQL.
Number1346 
Table 19. 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 defaultNoThis field is not visible by default in the table display.
DomainOrganisational unit no.Integer
SQL nameR6The database field name.
API identifierorgUnit6The API identifier used in GraphQL.
Number1347 
Table 20. 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 defaultNoThis field is not 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.
Number9426 
Table 21. 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 defaultNoThis field is not 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.
Number9427 
Table 22. 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 defaultNoThis field is not 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.
Number9428 
Table 23. 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 defaultNoThis field is not 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.
Number9429 
Table 24. 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 defaultNoThis field is not 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.
Number9430 
Table 25. 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 defaultNoThis field is not 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.
Number9431 
Table 26. 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 defaultNoThis field is not 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.
Number1348 

Original run no.

The Order journal number from which the transaction origin.

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

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.
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.
Number1349 
Table 27. Table relations
To tablePurposeFrom columnsTo columnsComments
Order journalOrderJournal
  • Original run no.

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

Outstanding amount

The outstanding amount in standard currency that remains before the invoice is fully matched.

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 nameRAmThe database field name.
API identifieroutstandingAmountDomesticThe API identifier used in GraphQL.
Number1326 

Outstanding amount in currency

The outstanding amount in currency that remains before the invoice is fully matched.

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 nameRCurAmThe database field name.
API identifieroutstandingAmountInCurrencyThe API identifier used in GraphQL.
Number1324 

Outstanding amount in EURO

The outstanding amount in currency, converted into EURO, that remains before the invoice is fully matched.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainAmountDecimal
Source columnOutstanding 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 identifieroutstandingAmountInEuroThe API identifier used in GraphQL.
Number7737 

Paid

Shows a "x", if a payment suggestion was created.

The field can be reset to not paid if the entry has been processed to a payment suggestion by mistake. You can then delete the payment suggestion in the payment lines table and run the payment suggestion processing again.

Check the Paid field if you do not want the entry to be included in payment suggestions. All values other than 0 and blank result in the field being checked.

The field is set as soon as you have approved the payment suggestion. This means as soon as you have pressed OK in the dialog box which appears when you run Create payment suggestion. If you run Create payment suggestion for a part payment, the field will be left blank. If the part payment is equal to the amount that you are to pay, the field is not left blank.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainBooleanInteger
SQL nameExcRmtThe database field name.
API identifierremittedThe API identifier used in GraphQL.
Number1336 

Paid curr. amount

Paid amount in the current currency.

Accumulates remitted part payments.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainAmountDecimal
SQL nameRemCAmThe database field name.
API identifierremittedCurrencyAmountThe API identifier used in GraphQL.
Number12258 

Paid last

The voucher date of the last matched payment voucher.

Updated each time you match a payment against an open entry.

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 namePayedDtThe database field name.
API identifierpaidLastThe API identifier used in GraphQL.
Number1328 

Paid status

Indicates whether the entry is fully open, partially paid, paid late or fully processed.

A look-up in this field gives you the following list of possible values:
1 - Fully open entry
Has not been matched against any entry yet.
2 - Partially open entry
Has been matched against one or more entries, but an amount remains outstanding.
3 - Paid late
The entry is retained pending the backdated calculation of interest.
4 - Paid on time
The entries were settled before the payment deadline and their processing as an open entry is complete. Open entries are deleted as soon as they have status 4, after which they are stored in the transactions tables. If any entries with this status remain, you can terminate them by selecting the lines and running the Terminate entry processing in the Open customer entry table.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainPaid statusInteger
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameStThe database field name.
API identifierpaidStatusThe API identifier used in GraphQL.
Number1333 

Part payment

Is updated from vouchers and can be overridden.

This amount will be suggested for the next payment suggestion. The field is emptied when you run the Create payment suggestion processing. The Part payment in currency field will be accumulated to the Paid curr. amount field, when the payment suggestion is created.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainAmountDecimal
SQL namePrtAmThe database field name.
API identifierpartPaymentDomesticThe API identifier used in GraphQL.
Number4964 

Part payment in currency

Is updated from vouchers and can be overridden.

This amount will be suggested for the next payment suggestion. The field is emptied when you run the Create payment suggestion processing. The Part payment in currency field will be accumulated to the Paid curr. amount field, when the payment suggestion is created.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainAmountDecimal
SQL namePrtCurAmThe database field name.
API identifierpartPaymentInCurrencyThe API identifier used in GraphQL.
Number4963 

Part payment in EURO

This field is derived from the Part payment in currency field.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainAmountDecimal
Source columnPart payment 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 identifierpartPaymentInEuroThe API identifier used in GraphQL.
Number7747 

Paym. run no.

Updated when you approve printouts in connection with payments.

Note:
The field is only updated when printing payment giros, not when electronic funds transfer is used through the processing Create payment suggestion in the Open supplier entry table.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainNo.Integer
SQL nameRmtRnNoThe database field name.
API identifierremittanceRunNoThe API identifier used in GraphQL.
Number1341 

Payment method

Is updated from vouchers.

This field is normally to be used only on entries with its origin from cash orders. (Orders with order type = 3).

Payment method texts for different languages can be defined in the Text table. These texts has text type 7.
Note:
If you double-click or press * in this field, you can look up a Payment method 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.
DomainPayment methodInteger
SQL namePmtMtThe database field name.
API identifierpaymentMethodThe API identifier used in GraphQL.
Number10543 
Table 28. Table relations
To tablePurposeFrom columnsTo columnsComments
Payment methodPaymentMethod
  • Payment method

Payment no.

The Payment no. from the Payment table.

This field is updated with the payment number when you run the processing Create payment suggestion in the Open customer entry 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.
DomainPayment no.Integer
SQL nameBPmtNoThe database field name.
API identifierpaymentNoThe API identifier used in GraphQL.
Number6963 
Table 29. Table relations
To tablePurposeFrom columnsTo columnsComments
PaymentPayment
  • Payment no.

Payment supplier no.

Supplier used as the payee when creating payment suggestions.

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
SQL nameRmtSupThe database field name.
API identifierremittanceSupplierNoThe API identifier used in GraphQL.
Number17874 
Table 30. Table relations
To tablePurposeFrom columnsTo columnsComments
AssociateRemittanceSupplier
  • Payment supplier no.

Payment terms

Is updated from vouchers. If it is not filled in on vouchers, it is fetched from the Associate table.

Payment terms texts for different languages can be defined in the Text table. These texts has text type 6.
Note:
If you double-click or press * in this field, you can look up a Payment terms 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.
DomainPayment termsInteger
SQL namePmtTrmThe database field name.
API identifierpaymentTermsThe API identifier used in GraphQL.
Number4959 
Table 31. Table relations
To tablePurposeFrom columnsTo columnsComments
Payment termPaymentTerms
  • Payment terms

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.
Number1318 
Table 32. 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.
Supplier balanceSupplierBalance
  • Sup. 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
SQL namePrBtThe database field name.
API identifierperiodBatchNoThe API identifier used in GraphQL.
Number10545 

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

Pre-approved

Pre-approved for payment in Visma.net AutoPay.

The transaction has been approved for payment in Visma.net Approval. Approval of the payment in Visma.net AutoPay should not be required. This value can be removed, but not be set.

If the payment is rejected/cancelled in Visma.net AutoPay, the value will be removed from the row.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainBooleanInteger
Memory fieldYesThe value in this field is only displayed in the program, it is not stored in the database.
API identifierpreapprovedThe API identifier used in GraphQL.
Number18570 

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

Priority

Comes from vouchers or can be edited manually in the corresponding open entries table.

The field is mainly used for sorting and selecting purposes.

Payment priority texts for different languages can be defined in the Text table. These texts has text type 67.
Note:
If you double-click or press * in this field, you can look up a Payment priority in the Text table.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainPayment priorityInteger
SQL namePriThe database field name.
API identifierpriorityThe API identifier used in GraphQL.
Number1334 

Purchases

Set equal to the Amount field if you have used a voucher type for which Affects turn./purch. has been checked.

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 namePurcThe database field name.
API identifierpurchasesThe API identifier used in GraphQL.
Number1330 

Quantity

Comes from vouchers and has the same sign as the Amount field.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainQuantityDecimal
SQL nameQtyThe database field name.
API identifierquantityThe API identifier used in GraphQL.
Number2273 

Rate comp. with domestic curr.

Shows the exchange rate against domestic currency on the payment line.

In use only on records concerning payments and used in those cases when the payment exchange rate differs from the exchange rate on the (paid) invoice.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainExchange rateDecimal
SQL nameTrfExRtThe database field name.
API identifierexchangeRateAgainstDomesticCurrencyThe API identifier used in GraphQL.
Number11452 

Reference

Comes from vouchers.

If the Reference field is not filled in on the voucher line, Visma Business will set this field equal to the Invoice no. field. If the Invoice no. field is also not filled in on the voucher line, then the Voucher no. field will be used.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainDoc. no.Text (40)
SQL nameRefThe database field name.
API identifierreferenceThe API identifier used in GraphQL.
Number1331 

Rest cash amount

The outstanding cash amount in standard currency that remains before the invoice is fully matched.

Note:
This amount has relevance only if the entry has a payment term that includes cash discount and the current date is less or equal to the cash due date.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainAmountDecimal
SQL nameRCshAmThe database field name.
API identifieroutstandingCashAmountDomesticThe API identifier used in GraphQL.
Number7861 

Rest cash amount in currency

The outstanding cash amount in the current foreign currency that remains before the invoice is fully matched.

Note:
This amount has relevance only if the entry has a payment term that includes cash discount and the current date is less or equal to the cash due date.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainAmountDecimal
SQL nameCRCshAmThe database field name.
API identifieroutstandingCashAmountInCurrencyThe API identifier used in GraphQL.
Number7859 

Rest cash amount in EURO

The outstanding amount in the current currency converted into EUROS that remains before the invoice is fully matched.

Note:
This amount has relevance only if the entry has a payment term that includes cash discount and the current date is less or equal to the cash due date.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainAmountDecimal
Source columnRest cash 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 identifieroutstandingCashAmountInEuroThe API identifier used in GraphQL.
Number7860 

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

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

Sup. no.

Shows the supplier number 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.
DomainSup. no.Integer
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameSupNoThe database field name.
API identifiersupplierNoThe API identifier used in GraphQL.
Number1312 
Table 33. Table relations
To tablePurposeFrom columnsTo columnsComments
AssociateSupplier
  • Sup. no.
Supplier balanceSupplierBalance
  • Sup. 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.

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

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

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
SQL nameUnThe database field name.
API identifierunitThe API identifier used in GraphQL.
Number10544 
Table 34. 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.
Number10952 
Table 35. 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.
Number10953 
Table 36. 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 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 nameValDtThe database field name.
API identifiervalueDateThe API identifier used in GraphQL.
Number1316 

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 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 nameVatAmThe database field name.
API identifiervatAmountDomesticThe API identifier used in GraphQL.
Number6679 

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

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

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

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

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

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 defaultNoThis field is not 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.
Number1310 
Table 37. 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.

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 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.
Number1314 
Table 38. Table relations
To tablePurposeFrom columnsTo columnsComments
VoucherPreviousVoucher
  • Voucher no.

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.
Number1319 
Table 39. Table relations
To tablePurposeFrom columnsTo columnsComments
Voucher typeVoucherType
  • Voucher type

W/off variance cash discount

If you want to pay an amount less than the Outstanding amount for an entry, enter the amount in the Part payment field in the current currency or default currency.

When the part payment is updated, the W/off variance cash discount, W/off variance cash discount in EURO and W/off variance cash discount in currency fields show the difference in relation to the Outstanding amount.

Visma Business refreshes the fields if you change the part payment amount.

Note:
The difference is only calculated for invoice entries.

If you enter 0 (zero) as the part payment amount, the part payment fields show 0 (zero) instead of being blank. If you delete the part payment amount, Visma Business also deletes the difference calculations.

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 identifierwriteOffVarianceCashDiscountDomesticThe API identifier used in GraphQL.
Number8616 

W/off variance cash discount %

Shows the difference in the default currency as a percentage of the original amount in the default currency.

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.
Memory fieldYesThe value in this field is only displayed in the program, it is not stored in the database.
API identifierwriteOffVarianceCashDiscountPercentThe API identifier used in GraphQL.
Number8617 

W/off variance cash discount in currency

If you want to pay an amount less than the Outstanding amount for an entry, enter the amount in the Part payment field in the current currency or default currency.

When the Part payment is updated, the W/off variance cash discount, W/off variance cash discount in EURO and W/off variance cash discount in currency fields show the difference in relation to the Outstanding amount.

Visma Business refreshes the fields if you change the part payment amount.

Note:
The difference is only calculated for invoice entries.

If you enter 0 (zero) as the part payment amount, the part payment fields show 0 (zero) instead of being blank. If you delete the part payment amount, Visma Business also deletes the difference calculations.

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 identifierwriteOffVarianceCashDiscountInCurrencyThe API identifier used in GraphQL.
Number8614 

W/off variance cash discount in EURO

If you want to pay an amount less than the Outstanding amount for an entry, enter the amount in the Payment method field in the current currency or default currency.

When the part payment is updated, the W/off variance cash discount, W/off variance cash discount in EURO and W/off variance cash discount in currency fields show the difference in relation to the Outstanding amount.

Visma Business refreshes the fields if you change the part payment amount.

Note:
The difference is only calculated for invoice entries.

If you enter 0 (zero) as the part payment amount, the part payment fields show 0 (zero) instead of being blank. If you delete the part payment amount, Visma Business also deletes the difference calculations.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainAmountDecimal
Source columnW/off variance cash discount 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 identifierwriteOffVarianceCashDiscountInEuroThe API identifier used in GraphQL.
Number8615 

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

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

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.
Number1317 
Table 40. 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.
Supplier balanceSupplierBalance
  • Sup. 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 41. Table relations
To table Purpose From columns To columns Comments
Active company process CompanyProcess Process no. Process no.