Bank partner

This table contains one row for each bank partner that is used for electronic funds transfer.

PropertyValueDescription
DatabaseCompanyThis table is in the company databases.
SQL nameBPartThe table name in the database.
API identifierbankPartnerThe API identifier used in GraphQL.
Table no.188The table number in the data model.

The following fields exist in this table:

Alert code

The alert code for the bank partner.

The alert code in this field is used as the default. It is used in connection with electronic funds transfer.

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.
DomainAlert codeText (5)
SQL nameNtfCdThe database field name.
API identifieralertCodeThe API identifier used in GraphQL.
Number13836 
Table 1. Table relations
To tablePurposeFrom columnsTo columnsComments
Notification codeBankAlertCode
  • Alert code

Alert text

Free text field for the alert text. Used in connection with electronic funds transfer.

This field is filled in when you enter a value in the Alert code field. The alert text in this field is used as the default.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainAlert textText (25)
SQL nameNtfTxtThe database field name.
API identifieralertTextThe API identifier used in GraphQL.
Number13837 

Balance available

Available balance on the bank account.

Updated when import of account statements from Visma.net AutoPay is in use.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainAmountDecimal
SQL nameBalAvThe database field name.
API identifierbalanceAvailableThe API identifier used in GraphQL.
Number18611 

Balance booked

Booked balance on the bank account.

Updated when import of account statements from Visma.net AutoPay is in use.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainAmountDecimal
SQL nameBalBkThe database field name.
API identifierbalanceBookedThe API identifier used in GraphQL.
Number18612 

Balance date

Valid date for the Balance available and Balance booked fields.

Updated when import of account statements from Visma.net AutoPay is in use.

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 nameBalDtThe database field name.
API identifierbalanceDateThe API identifier used in GraphQL.
Number18613 

Bank account name

Name of the bank account in the bank.

Updated when import of account statements from Visma.net AutoPay is in use.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainString of length 100Text (100)
SQL nameBankAcNmThe database field name.
API identifierbankAccountNameThe API identifier used in GraphQL.
Number18614 

Bank name

The name of the bank.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainNameText (80)
SQL nameBankNmThe database field name.
API identifierbankNameThe API identifier used in GraphQL.
Number11434 

Bank partner no.

A unique number identifying Bank partner.

Note:
If you press + in this field, the next available number is suggested. Gaps in the number series resulting from any deleted rows are not suggested. If you enter an existing number you will receive an error message. The number cannot be changed once it is entered.
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.
DomainNo.Integer
Primary keyYesBank partner no.
SQL nameBPartNoThe database field name.
API identifierbankPartnerNoThe API identifier used in GraphQL.
Number6903 
Table 2. Table relations
To tablePurposeFrom columnsTo columnsComments
Declaration codeStandardEftDeclarationCode
  • Std. EFT decl. code
  • Bank partner no.
This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others.

Bank system

The bank system which is used for the bank partner.

A look-up in this field gives you the following list of possible values:
1 - Unibank (Denmark)
Obsolete format.
2 - DnB Telebank (Norway)
Obsolete format.
3 - Kreditkassen K-Link (Norway)
Obsolete format.
4 - Sparnett (Norway)
Obsolete format.
5 - Fokus Telebank (Norway)
Obsolete format.
90 - Visma Payment (BabelBank) - not in use
Obsolete format.
95 - Visma.net AutoPay
The recommended bank system today.
96 - Liinos
An internal format for finding Finnish customers only and has not yet been fully developed.
97 - Visma Services payment routine
An internal format for customers who want to use Visma Services’ own bank service.
98 - Visma AutoPay - not in use
The previous on premises version of AutoPay. Also known as AutoPay 3.
99 - Z Data Converter
Bank system provided by third party supplier of Visma.
PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainBank systemInteger
SQL nameBankSysThe database field name.
API identifierbankSystemThe API identifier used in GraphQL.
Number11419 

Charge (debit) bank relations

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 identifierchargeBankNoThe API identifier used in GraphQL.
Number11421 
Table 3. Table relations
To tablePurposeFrom columnsTo columnsComments
BankBank
  • Charge (debit) bank relations

Chargeable bank account no.

The bank account number to be remitted (debited).

This means you avoid having to change the account number in the Company information table when exporting. You can also enter the bank account number that is to be debited other places, and this applies in the following priority order:

  1. Chargeable bank account no. from the Bank partner table.
  2. Our payment acc. from the Payment line table.
  3. Bank account for the currency line from the Currency table.
  4. Bank account from Company information.
  5. Postal giro from Company information.

This allows to set up several payment accounts without having to alter the table Company information, and you can select the various bank partners through generating suggestions.

Credit note due dates are also taken from the Bank partner table if the field is blank on the payment line.

Note:
The Bank account can be validated according to different rules. The validations are controlled in the Country processing field in the Country table.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainBank accountText (35)
SQL nameBankGThe database field name.
API identifierchargeBankAccountThe API identifier used in GraphQL.
Number11420 

Currency no.

The currency no for the bank partner.

Visma.net AutoPay is using this field to differentiate between different "Currency pockets" for payment formats for Nordea in Sweden.

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
SQL nameCurThe database field name.
API identifiercurrencyNoThe API identifier used in GraphQL.
Number11435 
Table 4. Table relations
To tablePurposeFrom columnsTo columnsComments
CurrencyCurrency
  • Currency no.

Customer no. in bank

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainOrganisation no.Text (24)
SQL nameCustNoThe database field name.
API identifiercustomerNoInBankThe API identifier used in GraphQL.
Number6906 

Decl. text

The declaration text used for electronic funds transfer.

It gets automatically filled when you select a value from the Std. EFT decl. code.

The authorities require the report of currency payments from the bank to contain a declaration code and a declaration text.

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.
DomainDecl. textText (40)
SQL nameDeclTxtThe database field name.
API identifierdeclarationTextThe API identifier used in GraphQL.
Number14556 
Table 5. Table relations
To tablePurposeFrom columnsTo columnsComments
Declaration codeBankDeclarationText
  • Decl. text

Division

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainDivisionText (11)
SQL nameDivThe database field name.
API identifierdivisionThe API identifier used in GraphQL.
Number6907 

EFT processing

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

Payment suggestion

Estimated transfer date is payment date for all transactions
All transactions, regardless of the payment date, will be assigned the same payment date that you used in the Create payment suggestion processing.
Set extra text on payment post
You will be able to transfer text (40 characters) on an open post in the Additional text field. This has been implemented for the 96 - Liinos and 99 - Z Data Converter bank systems. Only Telepay (NO), Postal giro and Bankgiro (SE) can use this function.
No debit balance
Some EFT systems will test whether the payments per supplier exceed the total amount owed, and rejects this supplier and transactions that will create a debit balance for the supplier will not be paid.
Net credit notes towards invoices

Posting

Generate batch/vouchers for settlement from EFT system
Automatically create batch/vouchers when receiving settled payments from the EFT system. Recommendation is to have this setting selected. If not selected the Create account batch processing in the Payment line table can be ran manually at a later stage.
Automatically update batch for outgoing payments from Visma.net AutoPay
After return data for payments are received from Visma.net AutoPay, the Update batch processing will start automatically.
Update all settled payments in a single batch
When selected, one common batch with voucher lines is created for the settlements of outgoing payments received in the same status change report from Visma.net AutoPay. If this option is not selected, separate batches will be created for each <OriginalPaymentBatch> section in the status change report.

Incoming payments

Automatically update batch for incoming payments from Visma.net AutoPay
After incoming payments are received from Visma.net AutoPay, the Update batch processing will start automatically.
Use value date on Visma.net AutoPay incoming payments
When selected, the bank's "Value date" is used for the Value date field in the Voucher table, instead of the bank's "Booking date". With this the user can configure what suites best for optimizing their bank reconciliation.
Create voucher lines if charges from incoming payments from Visma.net AutoPay
When selected, charges will be posted when importing incoming payments from Visma.net AutoPay. Charges will be posted if they are specified in the <ChargesDeducted> tag in the import file. Alternatively, charges will posted if the value in the <PaidCurrencyAmount> is higher than amount in the <ReceivedAmount> tag (meaning the customer has paid more than we have received), the difference will be considered as charges (currency must be identical for both amounts).
Create bank posting for each incoming payment from Visma.net AutoPay
When selected, a separate bank voucher will be created for each incoming payment when importing from Visma.net AutoPay.
Ignore the group value when creating bank posting for incoming payments from Visma.net AutoPay
In the XML file for incoming payments from Visma.net AutoPay (VIP file) there is a tag named <Group>. Import of the incoming payments creates bank vouchers, with grouping based on payment date and <Group> values. When this setting is selected, the <Group> tag is not taken into account when creating bank vouchers.
Do not match CID payment when paid amount is larger than outstanding amount
Relevant for incoming payments which has a CID code, and where the paid amount is larger than open entry's outstanding amount (e.g. when the payer has used same CID code for payment of multiple invoices).

When this setting is selected, the Cross reference and Credit account fields will not be filled out on the voucher. The batch will then have a difference, making it easier for the user to see that something needs manual handling (e.g. matching of open entries).

Check for double payment by CID in customer transactions
When incoming payments are imported, but no match is found in the Open customer entry table, an activation of this parameter will result in an additional search for the CID code in the Customer transaction table. If the CID code is found; the customer no. is added to the voucher line and the batch will balance. In addition the text "Warning - double payment?" will be added to the Additional text field.
Do not check reminders in Customer document when matching payments
When selected, the content in Customer document tables will not be used for matching of incoming payments from Visma.net AutoPay.

Sweden

Accept negative payments
Negative amounts will also be processed. This check box is also present under Accounting processing field in the Company information table. By using this selection in the Bank partner table, you can set different processing for each bank partner.
Note:
For negative payments you are meant to transfer larger amounts of credit notes than invoices. This is selected when it is permitted to send this to the bank for monitoring, so that with the next invoice the bank reduces the payment amount with the remaining credit note value. This is only used when paying to Swedish banks.
Always use Post giro if exists
Post account is used in EFT processing. This applies for Sweden and is only used by some external EFT systems.
Numeric cost codes
The cost codes "OUR" and "BEN" will be replaced by numerical values that are used in Sweden.
Allow uploading payments with 0-amounts
When selected, the Create payment suggestion processing will create payment lines also for suppliers where the sum of the transactions is zero (e.g. one invoice with amount 2000 and one credit note with amount 2000). Check that your bank accept zero-payments, this is accepted by several banks in Sweden.

Denmark

Joint Transactions
Some EFT systems produces a joint transaction for the bank. If you use this parameter you cannot retrieve return data to match the payments. This field is only used in some external EFT systems.
Short message to receiver
The recipient receives a short message. This field is only used by some EFT systems.

Bank reconciliation

Update general ledger transactions with reconciliation amount
When selected, new transaction in the General ledger transaction table with Account no. = the bank partner's GL bank account will be assigned values in the Reconciliation rest amount fields. This makes it possible to later reconcile the transactions against the Account statement transaction table.
Match transactions even if amounts are different
Enables the possibility to match transactions with different amounts when running the Manual reconciliation processing.
Reconciling single transactions before multiple transactions
When selected, the 4 - Single transactions on same date reconciliation algorithm will be executed before the 2 - Multiple general ledger transactions on same date and 3 - Multiple account statement transactions on same date algorithms.
Reconcile using value date
Bank reconciliation based on principle Value date instead of Voucher date. When enabling Reconcile using value date, the algorithms will look into the value date instead of voucher date when executing the processes. Also, when running the bank reconciliation statement report, the value in the field Balance according to general ledger is calculated based on the value date for the transactions.

AutoInvoice

Do not send CID to AutoInvoice
When selected, no CID will be sent to AutoInvoice.

Miscellaneous

Use database connection for ZData
This field is not in use in this table.
Payments for active company only
You cannot export data from other clients than the client from whom the export was started.
Process active settling only for payments
You can only process the selected payment line for the company where Upload data or Download data was started from.
Update bank account/organisation no. from EFT system
You get updated bank account and organisation numbers of customers who are paying by OCR. Not all formats support this. It depends on the information in the file that comes from the bank.
Get currency exchange rate when creating payments
You will be able to get exchange rates from the bank, and update the Currency and Currency rate tables with updated exchange rates from the bank. Not all bank formats are supported at present.
Set to "Cancelled" for payments not transferred
Some EFT systems sets the Paym. line status field in the Payment line table to 4 - Cancelled in the lines that have status 1 - Estimate after you have run the Upload data processing in the Payment table. It is the EFT system that performs the cancellation of the open entries for everything that is rejected before you send data to the bank.
Set "Cancelled" on payments that are refused
Some external EFT systems will set the Paym. line status field in the Payment line table to 4 - Cancelled in the lines that are being cancelled by the control routines in the EFT system, while suggestions that you selected manually so that they will not be transferred remain as Paym. line status equal 1 - Estimate, and will be ready for paying the next time the EFT system is started.
Domestic payments to foreign countries (payment method 43/TBIO)
Foreign transactions will be sent over and processed as domestic transactions in the recipient country. This depends on what is offered by the bank that you use for the payments.
No exchange rate on processed payments
This field is not in use.

Accounting

Duty/Fees included in amount
Fees will be included in the total amount.
Fees per record
Fees and duties will be recorded per supplier and payment.
Do not post duty and fees
Fees and duties will not be posted with the payment. Select this field when you have a separate agreement with the bank that fees and duties are debited separately.
Taxes and fees in foreign currency
Fees and duties are in a currency other than default currency. Then the account currency is used for the fees.
Use bank reference, domestic
The bank reference will be used to gather the posting in the general ledger account for bank postings on domestic payments.
Use bank reference in foreign countries
The bank reference is used to gather posting in the general ledger account for bank postings in foreign payments.

Telepay

Only one invoice per transaction
Some EFT systems will only produces transactions for the bank. If you use this parameter, several payments will not be batched for the same account.
PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainEFT processingInteger
SQL nameEFTProcThe database field name.
API identifiereftProcessingThe API identifier used in GraphQL.
Number11425 

EFT processing 2

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

Payment suggestion

Estimated transfer date is payment date for all transactions
All transactions, regardless of the payment date, will be assigned the same payment date that you used in the Create payment suggestion processing.
Set extra text on payment post
You will be able to transfer text (40 characters) on an open post in the Additional text field. This has been implemented for the 96 - Liinos and 99 - Z Data Converter bank systems. Only Telepay (NO), Postal giro and Bankgiro (SE) can use this function.
No debit balance
Some EFT systems will test whether the payments per supplier exceed the total amount owed, and rejects this supplier and transactions that will create a debit balance for the supplier will not be paid.
Net credit notes towards invoices

Posting

Generate batch/vouchers for settlement from EFT system
Automatically create batch/vouchers when receiving settled payments from the EFT system. Recommendation is to have this setting selected. If not selected the Create account batch processing in the Payment line table can be ran manually at a later stage.
Automatically update batch for outgoing payments from Visma.net AutoPay
After return data for payments are received from Visma.net AutoPay, the Update batch processing will start automatically.
Update all settled payments in a single batch
When selected, one common batch with voucher lines is created for the settlements of outgoing payments received in the same status change report from Visma.net AutoPay. If this option is not selected, separate batches will be created for each <OriginalPaymentBatch> section in the status change report.

Incoming payments

Automatically update batch for incoming payments from Visma.net AutoPay
After incoming payments are received from Visma.net AutoPay, the Update batch processing will start automatically.
Use value date on Visma.net AutoPay incoming payments
When selected, the bank's "Value date" is used for the Value date field in the Voucher table, instead of the bank's "Booking date". With this the user can configure what suites best for optimizing their bank reconciliation.
Create voucher lines if charges from incoming payments from Visma.net AutoPay
When selected, charges will be posted when importing incoming payments from Visma.net AutoPay. Charges will be posted if they are specified in the <ChargesDeducted> tag in the import file. Alternatively, charges will posted if the value in the <PaidCurrencyAmount> is higher than amount in the <ReceivedAmount> tag (meaning the customer has paid more than we have received), the difference will be considered as charges (currency must be identical for both amounts).
Create bank posting for each incoming payment from Visma.net AutoPay
When selected, a separate bank voucher will be created for each incoming payment when importing from Visma.net AutoPay.
Ignore the group value when creating bank posting for incoming payments from Visma.net AutoPay
In the XML file for incoming payments from Visma.net AutoPay (VIP file) there is a tag named <Group>. Import of the incoming payments creates bank vouchers, with grouping based on payment date and <Group> values. When this setting is selected, the <Group> tag is not taken into account when creating bank vouchers.
Do not match CID payment when paid amount is larger than outstanding amount
Relevant for incoming payments which has a CID code, and where the paid amount is larger than open entry's outstanding amount (e.g. when the payer has used same CID code for payment of multiple invoices).

When this setting is selected, the Cross reference and Credit account fields will not be filled out on the voucher. The batch will then have a difference, making it easier for the user to see that something needs manual handling (e.g. matching of open entries).

Check for double payment by CID in customer transactions
When incoming payments are imported, but no match is found in the Open customer entry table, an activation of this parameter will result in an additional search for the CID code in the Customer transaction table. If the CID code is found; the customer no. is added to the voucher line and the batch will balance. In addition the text "Warning - double payment?" will be added to the Additional text field.
Do not check reminders in Customer document when matching payments
When selected, the content in Customer document tables will not be used for matching of incoming payments from Visma.net AutoPay.

Sweden

Accept negative payments
Negative amounts will also be processed. This check box is also present under Accounting processing field in the Company information table. By using this selection in the Bank partner table, you can set different processing for each bank partner.
Note:
For negative payments you are meant to transfer larger amounts of credit notes than invoices. This is selected when it is permitted to send this to the bank for monitoring, so that with the next invoice the bank reduces the payment amount with the remaining credit note value. This is only used when paying to Swedish banks.
Always use Post giro if exists
Post account is used in EFT processing. This applies for Sweden and is only used by some external EFT systems.
Numeric cost codes
The cost codes "OUR" and "BEN" will be replaced by numerical values that are used in Sweden.
Allow uploading payments with 0-amounts
When selected, the Create payment suggestion processing will create payment lines also for suppliers where the sum of the transactions is zero (e.g. one invoice with amount 2000 and one credit note with amount 2000). Check that your bank accept zero-payments, this is accepted by several banks in Sweden.

Denmark

Joint Transactions
Some EFT systems produces a joint transaction for the bank. If you use this parameter you cannot retrieve return data to match the payments. This field is only used in some external EFT systems.
Short message to receiver
The recipient receives a short message. This field is only used by some EFT systems.

Bank reconciliation

Update general ledger transactions with reconciliation amount
When selected, new transaction in the General ledger transaction table with Account no. = the bank partner's GL bank account will be assigned values in the Reconciliation rest amount fields. This makes it possible to later reconcile the transactions against the Account statement transaction table.
Match transactions even if amounts are different
Enables the possibility to match transactions with different amounts when running the Manual reconciliation processing.
Reconciling single transactions before multiple transactions
When selected, the 4 - Single transactions on same date reconciliation algorithm will be executed before the 2 - Multiple general ledger transactions on same date and 3 - Multiple account statement transactions on same date algorithms.
Reconcile using value date
Bank reconciliation based on principle Value date instead of Voucher date. When enabling Reconcile using value date, the algorithms will look into the value date instead of voucher date when executing the processes. Also, when running the bank reconciliation statement report, the value in the field Balance according to general ledger is calculated based on the value date for the transactions.

AutoInvoice

Do not send CID to AutoInvoice
When selected, no CID will be sent to AutoInvoice.

Miscellaneous

Use database connection for ZData
This field is not in use in this table.
Payments for active company only
You cannot export data from other clients than the client from whom the export was started.
Process active settling only for payments
You can only process the selected payment line for the company where Upload data or Download data was started from.
Update bank account/organisation no. from EFT system
You get updated bank account and organisation numbers of customers who are paying by OCR. Not all formats support this. It depends on the information in the file that comes from the bank.
Get currency exchange rate when creating payments
You will be able to get exchange rates from the bank, and update the Currency and Currency rate tables with updated exchange rates from the bank. Not all bank formats are supported at present.
Set to "Cancelled" for payments not transferred
Some EFT systems sets the Paym. line status field in the Payment line table to 4 - Cancelled in the lines that have status 1 - Estimate after you have run the Upload data processing in the Payment table. It is the EFT system that performs the cancellation of the open entries for everything that is rejected before you send data to the bank.
Set "Cancelled" on payments that are refused
Some external EFT systems will set the Paym. line status field in the Payment line table to 4 - Cancelled in the lines that are being cancelled by the control routines in the EFT system, while suggestions that you selected manually so that they will not be transferred remain as Paym. line status equal 1 - Estimate, and will be ready for paying the next time the EFT system is started.
Domestic payments to foreign countries (payment method 43/TBIO)
Foreign transactions will be sent over and processed as domestic transactions in the recipient country. This depends on what is offered by the bank that you use for the payments.
No exchange rate on processed payments
This field is not in use.

Accounting

Duty/Fees included in amount
Fees will be included in the total amount.
Fees per record
Fees and duties will be recorded per supplier and payment.
Do not post duty and fees
Fees and duties will not be posted with the payment. Select this field when you have a separate agreement with the bank that fees and duties are debited separately.
Taxes and fees in foreign currency
Fees and duties are in a currency other than default currency. Then the account currency is used for the fees.
Use bank reference, domestic
The bank reference will be used to gather the posting in the general ledger account for bank postings on domestic payments.
Use bank reference in foreign countries
The bank reference is used to gather posting in the general ledger account for bank postings in foreign payments.

Telepay

Only one invoice per transaction
Some EFT systems will only produces transactions for the bank. If you use this parameter, several payments will not be batched for the same account.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainEFT processing 2Integer
SQL nameEFTProc2The database field name.
API identifiereftProcessing2The API identifier used in GraphQL.
Number18999 

EFT separator

The separator you want to use for batch payments. The field is then processed some external EFT systems.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainEFT separatorText (3)
SQL nameEftSepThe database field name.
API identifiereftSeparatorThe API identifier used in GraphQL.
Number13019 

From file name

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainData filenameText (260)
SQL nameFrFileNmThe database field name.
API identifierfromFileNameThe API identifier used in GraphQL.
Number6904 

GL account, bank fee

The general ledger account number used for fees.

When generating a batch, GL account, bank fee is used as follows:

  1. If you have filled in the GL account, bank fee field, the field in the Currency table will not be used.
  2. If the Payment fee account field for the relevant currency is blank for other currency in the Currency table, the value for domestic currency will be used.
  3. If you have not filled in the fields in points 1 and 2, the Posting errors account in the Company information table will be used.

Note:
If you double-click or press * in this field, you can look up a value in the related table.
PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAccount no.Integer
SQL nameRmtFeeAcThe database field name.
API identifiergeneralLedgerAccountNoForFeeThe API identifier used in GraphQL.
Number11423 
Table 6. Table relations
To tablePurposeFrom columnsTo columnsComments
General ledger accountFeeAccount
  • GL account, bank fee

GL bank account

The general ledger account for the bank account.

When generating a batch, General ledger account bank is used as follows:

  1. If you have filled in the GL account, bank fee field, the field in the Currency table will not be used.
  2. If the Payments account field for the relevant currency is blank for other currency in the Currency table, the value for domestic currency will be used.
  3. If you have not filled in the fields in points 1 and 2, the Posting errors account in the Company information table will be used.

Note:
If you double-click or press * in this field, you can look up a value in the related table.
PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAccount no.Integer
SQL nameRmtAcThe database field name.
API identifiergeneralLedgerAccountNoForBankThe API identifier used in GraphQL.
Number11422 
Table 7. Table relations
To tablePurposeFrom columnsTo columnsComments
General ledger accountBankAccount
  • GL bank account

Inf. 1

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainInf. @Text (40)
SQL nameInfThe database field name.
API identifierinformation1The API identifier used in GraphQL.
Number11426 

Inf. 2

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainInf. @Text (40)
SQL nameInf2The database field name.
API identifierinformation2The API identifier used in GraphQL.
Number11427 

Inf. 3

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainInf. @Text (40)
SQL nameInf3The database field name.
API identifierinformation3The API identifier used in GraphQL.
Number11428 

Inf. 4

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainInf. @Text (40)
SQL nameInf4The database field name.
API identifierinformation4The API identifier used in GraphQL.
Number11429 

Last day-seq. no.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainNo.Integer
SQL nameLstDySqThe database field name.
API identifierlastDaySequenceNoThe API identifier used in GraphQL.
Number6910 

Last seq. no.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainNo.Integer
SQL nameLstSqThe database field name.
API identifierlastSequenceNoThe API identifier used in GraphQL.
Number6911 

Last transf. 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 nameLstTrfDtThe database field name.
API identifierlastTransferDateThe API identifier used in GraphQL.
Number6909 

Layout

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainData filenameText (260)
SQL nameImFileNmThe database field name.
API identifierlayoutFileNameThe API identifier used in GraphQL.
Number7044 

No. of reconciliation deviation days

Number of days transactions can deviate in bank reconciliation.

Number of days the transaction dates in the General ledger transaction and Account statement transaction tables can differ when executing the Automatic reconciliation processing.

The dates can differ e.g. when the payment date is set on a weekend/Holy day, but the transaction is not processed before the first working day.

Valid values are 0-7 (note that when no value is set, the standard value 1 day will apply). Larger values can give a better result with more matched transactions, but it can also increase the possibility for wrong matching (especially when having many identical amounts).

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainNo.Integer
SQL nameRecDDaysThe database field name.
API identifiernoOfReconciliationDeviationDaysThe API identifier used in GraphQL.
Number19543 

Operator

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainOperatorText (11)
SQL nameOperThe database field name.
API identifieroperatorThe API identifier used in GraphQL.
Number6908 

Organisational unit 1

The organisational unit for the bank account.

When a batch is created for a settled outgoing payment, this field is used to set organisation unit on the bank voucher. E.g. can different organisation units then be set for different bank accounts. If the field is blank, the organisational unit entered for the account in the General ledger account table will be used.

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.
Number12236 
Table 8. Table relations
To tablePurposeFrom columnsTo columnsComments
Organisational unit 1OrgUnit1
  • Organisational unit 1

Organisational unit 2

The organisational unit for the bank account.

When a batch is created for a settled outgoing payment, this field is used to set organisation unit on the bank voucher. E.g. can different organisation units then be set for different bank accounts. If the field is blank, the organisational unit entered for the account in the General ledger account table will be used.

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.
Number12237 
Table 9. Table relations
To tablePurposeFrom columnsTo columnsComments
Organisational unit 2OrgUnit2
  • Organisational unit 2

Organisational unit 3

The organisational unit for the bank account.

When a batch is created for a settled outgoing payment, this field is used to set organisation unit on the bank voucher. E.g. can different organisation units then be set for different bank accounts. If the field is blank, the organisational unit entered for the account in the General ledger account table will be used.

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.
Number12238 
Table 10. Table relations
To tablePurposeFrom columnsTo columnsComments
Organisational unit 3OrgUnit3
  • Organisational unit 3

Organisational unit 4

The organisational unit for the bank account.

When a batch is created for a settled outgoing payment, this field is used to set organisation unit on the bank voucher. E.g. can different organisation units then be set for different bank accounts. If the field is blank, the organisational unit entered for the account in the General ledger account table will be used.

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.
Number12239 
Table 11. Table relations
To tablePurposeFrom columnsTo columnsComments
Organisational unit 4OrgUnit4
  • Organisational unit 4

Organisational unit 5

The organisational unit for the bank account.

When a batch is created for a settled outgoing payment, this field is used to set organisation unit on the bank voucher. E.g. can different organisation units then be set for different bank accounts. If the field is blank, the organisational unit entered for the account in the General ledger account table will be used.

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.
Number12240 
Table 12. Table relations
To tablePurposeFrom columnsTo columnsComments
Organisational unit 5OrgUnit5
  • Organisational unit 5

Organisational unit 6

The organisational unit for the bank account.

When a batch is created for a settled outgoing payment, this field is used to set organisation unit on the bank voucher. E.g. can different organisation units then be set for different bank accounts. If the field is blank, the organisational unit entered for the account in the General ledger account table will be used.

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.
Number12241 
Table 13. Table relations
To tablePurposeFrom columnsTo columnsComments
Organisational unit 6OrgUnit6
  • Organisational unit 6

Organisational unit 7

The organisational unit for the bank account.

When a batch is created for a settled outgoing payment, this field is used to set organisation unit on the bank voucher. E.g. can different organisation units then be set for different bank accounts. If the field is blank, the organisational unit entered for the account in the General ledger account table will be used.

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.
Number12242 
Table 14. Table relations
To tablePurposeFrom columnsTo columnsComments
Organisational unit 7OrgUnit7
  • Organisational unit 7

Organisational unit 8

The organisational unit for the bank account.

When a batch is created for a settled outgoing payment, this field is used to set organisation unit on the bank voucher. E.g. can different organisation units then be set for different bank accounts. If the field is blank, the organisational unit entered for the account in the General ledger account table will be used.

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.
Number12243 
Table 15. Table relations
To tablePurposeFrom columnsTo columnsComments
Organisational unit 8OrgUnit8
  • Organisational unit 8

Organisational unit 9

The organisational unit for the bank account.

When a batch is created for a settled outgoing payment, this field is used to set organisation unit on the bank voucher. E.g. can different organisation units then be set for different bank accounts. If the field is blank, the organisational unit entered for the account in the General ledger account table will be used.

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.
Number12244 
Table 16. Table relations
To tablePurposeFrom columnsTo columnsComments
Organisational unit 9OrgUnit9
  • Organisational unit 9

Organisational unit 10

The organisational unit for the bank account.

When a batch is created for a settled outgoing payment, this field is used to set organisation unit on the bank voucher. E.g. can different organisation units then be set for different bank accounts. If the field is blank, the organisational unit entered for the account in the General ledger account table will be used.

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.
Number12245 
Table 17. Table relations
To tablePurposeFrom columnsTo columnsComments
Organisational unit 10OrgUnit10
  • Organisational unit 10

Organisational unit 11

The organisational unit for the bank account.

When a batch is created for a settled outgoing payment, this field is used to set organisation unit on the bank voucher. E.g. can different organisation units then be set for different bank accounts. If the field is blank, the organisational unit entered for the account in the General ledger account table will be used.

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.
Number12246 
Table 18. Table relations
To tablePurposeFrom columnsTo columnsComments
Organisational unit 11OrgUnit11
  • Organisational unit 11

Organisational unit 12

The organisational unit for the bank account.

When a batch is created for a settled outgoing payment, this field is used to set organisation unit on the bank voucher. E.g. can different organisation units then be set for different bank accounts. If the field is blank, the organisational unit entered for the account in the General ledger account table will be used.

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.
Number12247 
Table 19. Table relations
To tablePurposeFrom columnsTo columnsComments
Organisational unit 12OrgUnit12
  • Organisational unit 12

Std. credit note credit days

The number of days that a credit note must remain in the bank before being cancelled.

The fields are in use for Swedish payment paths.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainNo.Integer
SQL nameCNtDyThe database field name.
API identifierstandardCreditNoteDueDaysThe API identifier used in GraphQL.
Number11424 

Std. EFT bank fee code

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 defaultYesThis field is visible by default in the table display.
DomainEFT bank feeInteger
SQL nameAbCstThe database field name.
API identifierstandardEftBankFeeCodeThe API identifier used in GraphQL.
Number11431 

Std. EFT curr. code

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 defaultYesThis field is visible by default in the table display.
DomainEFT Currency codeInteger
SQL nameCurCdThe database field name.
API identifierstandardEftCurrencyCodeThe API identifier used in GraphQL.
Number11430 

Std. EFT decl. code

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 defaultYesThis field is visible by default in the table display.
DomainEFT declaration codeInteger
SQL nameDeclCdThe database field name.
API identifierstandardEftDeclarationCodeThe API identifier used in GraphQL.
Number11432 
Table 20. Table relations
To tablePurposeFrom columnsTo columnsComments
Declaration codeStandardEftDeclarationCode
  • Std. EFT decl. code
  • Bank partner no.
This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others.

Std. EFT form type

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 defaultYesThis field is visible by default in the table display.
DomainEFT form typeInteger
SQL nameEftFrmTpThe database field name.
API identifierstandardEftFormTypeThe API identifier used in GraphQL.
Number15465 

Std. EFT paym. method

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 defaultYesThis field is visible by default in the table display.
DomainEFT payment methodInteger
SQL namePmtLnProThe database field name.
API identifierstandardEftPaymentMethodThe API identifier used in GraphQL.
Number11433 

Text code

Applies only to the payment type domestic payment (UBT033).

The text code in this field is used as the default.

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.
DomainText codeText (10)
SQL nameTxtCdThe database field name.
API identifiertextCodeThe API identifier used in GraphQL.
Number13838 
Table 21. Table relations
To tablePurposeFrom columnsTo columnsComments
Text codeBankTextCode
  • Text code

Text line

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainText lineText (200)
SQL nameTxtLnThe database field name.
API identifiertextLineThe API identifier used in GraphQL.
Number13839 

To file name

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainData filenameText (260)
SQL nameToFileNmThe database field name.
API identifiertoFileNameThe API identifier used in GraphQL.
Number6905 

Voucher series no.

Only used by EFT systems to generate vouchers and has no function in Visma Business.

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.
DomainVoucher series no.Integer
SQL nameVoSrNoThe database field name.
API identifiervoucherSeriesNoThe API identifier used in GraphQL.
Number14535 
Table 22. Table relations
To tablePurposeFrom columnsTo columnsComments
Voucher seriesVoucherSeries
  • Voucher series no.

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