Payment line

This table contains one row for each line on a payment suggestion.

Property	Value	Description
Database	Company	This table is in the company databases.
SQL name	BPmtLn	The table name in the database.
API identifier	paymentLine	The API identifier used in GraphQL.
Table no.	190	The table number in the data model.

The following fields exist in this table:

Actual amount

The amount which got debited by the bank.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Amount	Decimal
Write Access	None	You are not allowed to modify the value in this field.
SQL name	ActAm	The database field name.
API identifier	actualAmount	The API identifier used in GraphQL.
Number	7103

Actual amount in account currency

The amount which got debited by the bank, in the currency of the bank account.

Property	Value	Description
Visible by default	No	This field is not visible by default in the table display.
Domain	Amount	Decimal
Write Access	None	You are not allowed to modify the value in this field.
SQL name	ActAmAcC	The database field name.
API identifier	actualAmountInAccountCurrency	The API identifier used in GraphQL.
Number	19106

Actual exch. rate

The exchange rate that was used by the bank for the payment.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Exchange rate	Decimal
SQL name	RlExchRt	The database field name.
API identifier	actualExchangeRate	The API identifier used in GraphQL.
Number	6952

Agreed exchange rate

The exchange rate that you have agreed with the bank.

The field is part of the file which gets sent to the bank. It applies only to international transactions.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Exchange rate	Decimal
SQL name	AgExchRt	The database field name.
API identifier	agreedExchangeRate	The API identifier used in GraphQL.
Number	7109

Agreed with

The first six letters of the surname of the person with whom the exchange rate was agreed.

The field is part of the file which gets sent to the bank. It applies only to international transactions.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Agreed with	Text (6)
SQL name	AgWt	The database field name.
API identifier	agreedWith	The API identifier used in GraphQL.
Number	7110

Alert code

The alert code for the payment line.

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.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Alert code	Text (5)
SQL name	NtfCd	The database field name.
API identifier	alertCode	The API identifier used in GraphQL.
Number	7119

Table 1. Table relations
To table	Purpose	From columns	To columns	Comments
Notification code	BankAlertCode	Alert code	Alert code

Alert text

Free text field for the alert text.

Used in connection with electronic funds transfer.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Alert text	Text (25)
SQL name	NtfTxt	The database field name.
API identifier	alertText	The API identifier used in GraphQL.
Number	7120

Amount

The Amount in domestic currency.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Amount	Decimal
Write Access	None	You are not allowed to modify the value in this field.
SQL name	DAm	The database field name.
API identifier	amountDomestic	The API identifier used in GraphQL.
Number	6941

Amount in currency

The amount in currency.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Amount	Decimal
Write Access	None	You are not allowed to modify the value in this field.
SQL name	CAm	The database field name.
API identifier	amountInCurrency	The API identifier used in GraphQL.
Number	6940

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.

Property	Value	Description
Visible by default	No	This field is not visible by default in the table display.
Domain	Approval token	Text (40)
Write Access	None	You are not allowed to modify the value in this field.
SQL name	ApTk	The database field name.
API identifier	approvalToken	The API identifier used in GraphQL.
Number	18560

Approval workflow handle

Reference to a workflow in Visma.net Approval.

Used in Visma.net AutoPay for viewing of invoices.

Property	Value	Description
Visible by default	No	This field is not visible by default in the table display.
Domain	Approval workflow handle	Text (36)
Write Access	None	You are not allowed to modify the value in this field.
SQL name	ApWfH	The database field name.
API identifier	approvalWorkflowHandle	The API identifier used in GraphQL.
Number	18817

Attention

Is used for Telepay international

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Attention	Text (20)
SQL name	Att	The database field name.
API identifier	attention	The API identifier used in GraphQL.
Number	7117

Audit no.

The Audit no. for the entry.

Note:

If you double-click or press * in this field, you can look up a value in the related table.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Audit no.	Integer
Write Access	None	You are not allowed to modify the value in this field.
SQL name	EntNo	The database field name.
API identifier	auditNo	The API identifier used in GraphQL.
Number	6945

Table 2. Table relations
To table	Purpose	From columns	To columns	Comments
Open customer entry	OpenCustomerEntry	Voucher jour. no. Audit no.	Voucher jour. no. Audit no.	This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others.
Open supplier entry	OpenSupplierEntry	Voucher jour. no. Audit no.	Voucher jour. no. Audit no.	This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others.

Bank account

The bank account for the payment. It is suggested from the open supplier entry table or open customer entry table, and can be overridden. Otherwise the value is retrieved from Bank giro/Postal giro for the supplier/customer when the file is created.

To see the recipient's account number for all entries you must retrieve it from the associate via the supplier number or customer number.

This field is also used for IBAN bank account numbers. Depending on the recipient's country, other fields like SWIFT code or bank branch need to be filled in combination with the IBAN.

Note:

The Bank account can be validated according to different rules. The validation is controlled in the Country processing field in the Country table.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Bank account	Text (35)
SQL name	BankG	The database field name.
API identifier	bankAccount	The API identifier used in GraphQL.
Number	7216

Bank batch Visma.net AutoPay

The internal Bank batch number in Visma.net AutoPay.

Updated when importing settled payments from Visma.net AutoPay.

The value is used by the Create account batch processing to make sure that the same bank transactions are created in Business NXT as the ones in the account statement from the bank. For the settled payment lines one bank transaction will be created for each unique value found in the Bank batch Visma.net AutoPay field.

Property	Value	Description
Visible by default	No	This field is not visible by default in the table display.
Domain	String of length 18	Text (18)
Write Access	None	You are not allowed to modify the value in this field.
SQL name	BBatchAp	The database field name.
API identifier	bankBatchVismaNetAutoPay	The API identifier used in GraphQL.
Number	19017

Bank partner no.

The bank partner that you selected for the payment suggestion in the Create payment suggestion dialog box.

Note:

The field cannot be changed. In case of changes the line should be deleted and recreated.

Note:

If you double-click or press * in this field, you can look up a value in the related table.

Property	Value	Description
Visible by default	No	This field is not visible by default in the table display.
Domain	No.	Integer
SQL name	BPartNo	The database field name.
API identifier	bankPartnerNo	The API identifier used in GraphQL.
Number	13840

Table 3. Table relations
To table	Purpose	From columns	To columns	Comments
Bank partner	BankPartner	Bank partner no.	Bank partner no.
Declaration code	EftDeclarationCode	EFT decl. code Bank partner no.	EFT declaration 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 reference

Contains the bank's reference.

Updated when importing settled payments from Visma.net AutoPay.

Note:

If you double-click or press * in this field, you can look up a value in the related table.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Bank reference	Text (30)
SQL name	BankRef	The database field name.
API identifier	bankReference	The API identifier used in GraphQL.
Number	6951

Table 4. Table relations
To table	Purpose	From columns	To columns
General ledger transaction	GeneralLedgerTransaction_BankReference	Bank reference	Bank reference
Account statement transaction	AccountStatementTransaction_BankReference	Bank reference	Bank reference
Accounting transaction	AccountingTransaction_BankReference	Bank reference	Bank reference
Voucher	Voucher_BankReference	Bank reference	Bank reference
Updated voucher	UpdatedVoucher_BankReference	Bank reference	Bank reference

Bank run no.

The run number for the payment line given by the bank.

The field is updated with the returned data from the bank.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	No.	Integer
SQL name	BankSeq	The database field name.
API identifier	bankRunNo	The API identifier used in GraphQL.
Number	7594

Batch date

The date when the Batch was created.

The date is set when running Create account batch on Payment line having Payment line status 5 - Settled.

The date is validated using the regional settings in Windows.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Date	Integer
Write Access	None	You are not allowed to modify the value in this field.
SQL name	BatDt	The database field name.
API identifier	batchDate	The API identifier used in GraphQL.
Number	6950

Check code

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	String of length 1	Text (1)
SQL name	ChkCd	The database field name.
API identifier	checkCode	The API identifier used in GraphQL.
Number	7113

CID code

Contains the CID (customer identification code) code from the open supplier entry or open customer entry.

Note:

If you have an invoice and a credit note from the same supplier, both payment lines must have CID code or be empty to be remitted, because transactions without and with CID code are handled differently in the bank.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	CID code	Text (30)
SQL name	Cid	The database field name.
API identifier	cid	The API identifier used in GraphQL.
Number	7118

Credit note credit days

Used by some EFT systems, states the number of days that a credit note must remain in the EFT system before being cancelled.

Property	Value	Description
Visible by default	No	This field is not visible by default in the table display.
Domain	No.	Integer
SQL name	CNtDy	The database field name.
API identifier	creditNoteDueDays	The API identifier used in GraphQL.
Number	11437

Currency no.

The currency for the payment line.

Note:

If you double-click or press * in this field, you can look up a value in the related table.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Currency no.	Integer
Write Access	None	You are not allowed to modify the value in this field.
SQL name	CurNo	The database field name.
API identifier	currencyNo	The API identifier used in GraphQL.
Number	6938

Table 5. Table relations
To table	Purpose	From columns	To columns	Comments
Currency	Currency	Currency no.	Currency no.

Cust. no.

The customer who receives the payment.

Note:

If you double-click or press * in this field, you can look up a value in the related table.

Property	Value	Description
Visible by default	No	This field is not visible by default in the table display.
Domain	Cust. no.	Integer
SQL name	CustNo	The database field name.
API identifier	customerNo	The API identifier used in GraphQL.
Number	11095

Table 6. Table relations
To table	Purpose	From columns	To columns	Comments
Associate	Customer	Cust. no.	Cust. no.

Day sequence no.

This field is no longer in use. Be aware the field may be removed in later versions.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	No.	Integer
Write Access	None	You are not allowed to modify the value in this field.
SQL name	DySq	The database field name.
API identifier	daySequenceNo	The API identifier used in GraphQL.
Number	6953

Debit date

Shows when the entry was debited by the bank.

The field is updated with the returned data from the bank.

The date is validated using the regional settings in Windows.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Date	Integer
SQL name	PmtDt	The database field name.
API identifier	debitDate	The API identifier used in GraphQL.
Number	7051

Decl. text

The declaration text for the payment line.

The authorities require a report of currency payments from the banks including a declaration code and a declaration text. If the Decl. text field is blank when you upload data, the declaration code in the EFT declaration code field is added instead as the declaration text.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Name	Text (80)
SQL name	DeclTxt	The database field name.
API identifier	declarationText	The API identifier used in GraphQL.
Number	6967

Deduct currency no.

The currency in which the entry is debited by the bank.

Note:

If you double-click or press * in this field, you can look up a value in the related table.

Property	Value	Description
Visible by default	No	This field is not visible by default in the table display.
Domain	Currency no.	Integer
SQL name	PmtCur	The database field name.
API identifier	deductCurrencyNo	The API identifier used in GraphQL.
Number	11439

Table 7. Table relations
To table	Purpose	From columns	To columns	Comments
Currency	ChargeDebitCurrency	Deduct currency no.	Currency no.

Domestic cost

Who is paying the cost of the payment in Norway.

Is used for Telepay international

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Post code	Text (3)
SQL name	DmCst	The database field name.
API identifier	costDomestic	The API identifier used in GraphQL.
Number	7107

EFT currency code

The currency code used for the payment.

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.

Property	Value	Description
Visible by default	No	This field is not visible by default in the table display.
Domain	EFT Currency code	Integer
SQL name	CurCd	The database field name.
API identifier	eftCurrencyCode	The API identifier used in GraphQL.
Number	11438

EFT decl. code

For payments abroad, declaration codes are required depending on national rules.

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.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	EFT declaration code	Integer
SQL name	DeclCd	The database field name.
API identifier	eftDeclarationCode	The API identifier used in GraphQL.
Number	6966

Table 8. Table relations
To table	Purpose	From columns	To columns	Comments
Declaration code	EftDeclarationCode	EFT decl. code Bank partner no.	EFT declaration 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.

EFT form type

The form type for Danish payment formats, or for other payment formats which must state the form type in the payments file.

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.

Property	Value	Description
Visible by default	No	This field is not visible by default in the table display.
Domain	EFT form type	Integer
SQL name	EftFrmTp	The database field name.
API identifier	eftFormType	The API identifier used in GraphQL.
Number	15466

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.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	EFT payment method	Integer
SQL name	PmtLnPro	The database field name.
API identifier	eftPaymentMethod	The API identifier used in GraphQL.
Number	7090

Empl. no.

The employee associated with the payment.

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.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Empl. no.	Integer
SQL name	EmpNo	The database field name.
API identifier	employeeNo	The API identifier used in GraphQL.
Number	8398

Table 9. Table relations
To table	Purpose	From columns	To columns	Comments
Associate	AssociateEmployee	Empl. no.	Empl. no.

Estimate date

The date when the payment line was created.

The date is validated using the regional settings in Windows.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Date	Integer
Write Access	None	You are not allowed to modify the value in this field.
SQL name	SugDt	The database field name.
API identifier	estimateDate	The API identifier used in GraphQL.
Number	6947

Expected exch. rate

The exchange rate which is expected to be used for the debit transaction.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Exchange rate	Decimal
Write Access	None	You are not allowed to modify the value in this field.
SQL name	ExchRt	The database field name.
API identifier	expectedExchangeRate	The API identifier used in GraphQL.
Number	6939

Fee

Fee for the outgoing payment, in domestic currency.

Updated when fee is received in the Visma Status Report (VSR) file from Visma.net AutoPay.

When batch is created for the settled payment, the fee voucher is posted against the account stated in the GL account, bank fee field in the Bank partner table.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Amount	Decimal
Write Access	None	You are not allowed to modify the value in this field.
SQL name	Fee	The database field name.
API identifier	feeDomestic	The API identifier used in GraphQL.
Number	19530

Fee currency no.

The currency for the fee.

Updated when fee is received in the Visma Status Report (VSR) file from Visma.net AutoPay.

When batch is created for the settled payment, the fee voucher is posted against the account stated in the GL account, bank fee field in the Bank partner table.

Note:

If you double-click or press * in this field, you can look up a value in the related table.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Currency no.	Integer
Write Access	None	You are not allowed to modify the value in this field.
SQL name	FeeCurNo	The database field name.
API identifier	feeCurrencyNo	The API identifier used in GraphQL.
Number	19531

Table 10. Table relations
To table	Purpose	From columns	To columns	Comments
Currency	FeeCurrency	Fee currency no.	Currency no.

Fee in currency

Fee for the outgoing payment, in currency.

Updated when fee is received in the Visma Status Report (VSR) file from Visma.net AutoPay.

When batch is created for the settled payment, the fee voucher is posted against the account stated in the GL account, bank fee field in the Bank partner table.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Amount	Decimal
Write Access	None	You are not allowed to modify the value in this field.
SQL name	CurFee	The database field name.
API identifier	feeInCurrency	The API identifier used in GraphQL.
Number	19529

Foreign cost

Who is paying the cost of the payment abroad.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Post code	Text (3)
SQL name	AbCst	The database field name.
API identifier	foreignCost	The API identifier used in GraphQL.
Number	7106

Giro no. check sum

The check sum for the account number you have registered in the Bank account field.

Third party applications can validate via BIG, if the stated Giro no. check sum belongs to the Bank account.

Property	Value	Description
Visible by default	No	This field is not visible by default in the table display.
Domain	No.	Integer
SQL name	GiroChSm	The database field name.
API identifier	giroNoCheckSum	The API identifier used in GraphQL.
Number	10498

Immediately acknow.

This option must be selected if you want the bank to notify the payee as soon as the transaction has taken place.

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

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Boolean	Integer
Memory field	Yes	The value in this field is only displayed in the program, it is not stored in the database.
API identifier	immediatelyAcknowledge	The API identifier used in GraphQL.
Number	7089

Line no.

Each line in the table is given a consecutive number in the order in which they are entered.

Note:

The Line no. does not change when inserting new lines between existing ones. The Sort seq. no. specifies the order of the lines and is affected when new lines are inserted between existing lines.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	No.	Integer
Primary key	Yes	Payment no., Line no.
SQL name	LnNo	The database field name.
API identifier	lineNo	The API identifier used in GraphQL.
Number	6937

Our payment acc.

Bank account fetched from the Currency table.

Used when the relevant currency has a bank account filled in. Otherwise this field is blank, and the bank account number is exported to the EFT system from underlying tables in the following order of priority:

Chargeable bank account no. in the Bank partner table (if filled in)
Our payment acc. in the Payment line table (if filled in)
Bank account in the Company information table (if filled in)
Postal giro in the Company information table (if filled in)

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Bank account	Text (35)
Write Access	None	You are not allowed to modify the value in this field.
SQL name	PmtAc	The database field name.
API identifier	ourPaymentAccount	The API identifier used in GraphQL.
Number	6954

Partly paid in AutoPay

Marked with a "x" if the payment amount has been changed by an approver in Visma.net AutoPay.

The approver can reduce the amount of a transaction in AutoPay before it is approved and sent to the bank. This applies to Norwegian domestic payments, for transactions that do not contain credit notes or multiple invoices in the remittance information (since it is then ambiguous how a partial amount should be distributed).

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Boolean	Integer
Write Access	None	You are not allowed to modify the value in this field.
SQL name	PartPayAp	The database field name.
API identifier	partlyPaidInAutopay	The API identifier used in GraphQL.
Number	19190

Paym. line status

The status of the payment.

The status is updated automatically by EFT systems. Manual changes might be required if you

do not receive a reconciliation report from the bank (change to status Settled).
notify the bank that an entry is to be disregarded (change to status Cancelled). This is keeps traceability of the payments, instead of deleting the payment line.

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

1 - Estimate: Payment suggestion has been created, but not been sent to the EFT system.
2 - Transferred: The payment has been transferred from the EFT system to the bank.
3 - Receipt: Updated according to the returned value from the bank. The Payment line get that status when you have imported the receipt file from the bank using the processing Download data in the Payment table and the bank only provides a receipt report.
4 - Cancelled: The payment has been cancelled in the EFT system.
5 - Settled: Updated according to the returned value from the bank. The Payment line get that status when you have imported the receipt file from the bank using the processing Download data in the Payment table and the bank provides a receipt and a reconciliation report.
6 - Posted: A accounting voucher has been generated.
7 - Rejected: The payment has been rejected by the bank.
8 - Transferred to EFT system, not to bank: A temporary status given when the external EFT system processes data before the bank file is generated. The payment gets this status after running of the processing Upload data in the Payment table.
9 - Missing payment lines: This status is given if the returned data refers to a payment that does not exist in the Payment line table.
10 - Rejected by EFT system: Payment is rejected by the EFT system.
11 - Estimate netted
21 - Estimate direct payment: Payment suggestion for Direct Debit has been created, but not been sent to the EFT system.
22 - Transferred direct payment: The Direct Debit claim has been transferred from the EFT system to the bank.
24 - Cancelled direct payment: The Direct Debit claim has been cancelled in the EFT system.
25 - Transferred cancellation

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Paym. line status	Integer
SQL name	LnSt	The database field name.
API identifier	paymentLineStatus	The API identifier used in GraphQL.
Number	6942

Payment no.

A unique number identifying the payment line.

Note:

If you double-click or press * in this field, you can look up a value in the related table.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Payment no.	Integer
Primary key	Yes	Payment no., Line no.
SQL name	BPmtNo	The database field name.
API identifier	paymentNo	The API identifier used in GraphQL.
Number	6936

Table 11. Table relations
To table	Purpose	From columns	To columns	Comments
Payment	Payment	Payment no.	Payment no.

Payment reference

Used by EFT systems to look up for matching references when import settled payments from bank.

Property	Value	Description
Visible by default	No	This field is not visible by default in the table display.
Domain	String of length 40	Text (40)
SQL name	PmtRef	The database field name.
API identifier	paymentReference	The API identifier used in GraphQL.
Number	17760

Payment return code

The status of the transaction given by the bank.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Payment return code	Text (260)
SQL name	RetCd	The database field name.
API identifier	paymentReturnCode	The API identifier used in GraphQL.
Number	6946

Payment supplier no.

Supplier used as the payee when creating payment suggestions.

Supplier used as the payee will be selected in the following order:

Payment supplier no. from the Payment line table, if filled out
Payment supplier no. from the Associate table, if filled out
Sup. no. the Payment line table

Note:

If you double-click or press * in this field, you can look up a value in the related table.

Property	Value	Description
Visible by default	No	This field is not visible by default in the table display.
Domain	Sup. no.	Integer
SQL name	RmtSup	The database field name.
API identifier	remittanceSupplierNo	The API identifier used in GraphQL.
Number	17914

Table 12. Table relations
To table	Purpose	From columns	To columns	Comments
Associate	RemittanceSupplier	Payment supplier no.	Sup. no.

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.

Property	Value	Description
Visible by default	No	This field is not visible by default in the table display.
Domain	Boolean	Integer
Memory field	Yes	The value in this field is only displayed in the program, it is not stored in the database.
API identifier	preapproved	The API identifier used in GraphQL.
Number	18572

Provision

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Amount	Decimal
SQL name	Prv	The database field name.
API identifier	provision	The API identifier used in GraphQL.
Number	8393

Rate comp. with domestic curr.

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

If this field has a value, the amount will be calculated using this rate and not the exchange rate returned from the bank.

Property	Value	Description
Visible by default	No	This field is not visible by default in the table display.
Domain	Exchange rate	Decimal
SQL name	TrfExRt	The database field name.
API identifier	exchangeRateAgainstDomesticCurrency	The API identifier used in GraphQL.
Number	11440

Receipt date

The date you received the receipt from the bank.

The date is validated using the regional settings in Windows.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Date	Integer
Write Access	None	You are not allowed to modify the value in this field.
SQL name	RecDt	The database field name.
API identifier	receiptDate	The API identifier used in GraphQL.
Number	6948

Receiver's bank account line no.

This field is no longer in use. Be aware the field may be removed in later versions.

Property	Value	Description
Visible by default	No	This field is not visible by default in the table display.
Domain	No.	Integer
SQL name	BankAcLn	The database field name.
API identifier	receiversBankAccountLineNo	The API identifier used in GraphQL.
Number	11436

Recipient reference

Must contain either the CID code or the invoice number for the entry, depending on the content in the corresponding fields in the Open supplier entry table.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Recipient reference	Text (40)
SQL name	RecRef	The database field name.
API identifier	recipientReference	The API identifier used in GraphQL.
Number	6955

Sup. no.

The supplier no for the payment line.

Note:

If you double-click or press * in this field, you can look up a value in the related table.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Sup. no.	Integer
Write Access	None	You are not allowed to modify the value in this field.
SQL name	SupNo	The database field name.
API identifier	supplierNo	The API identifier used in GraphQL.
Number	6943

Table 13. Table relations
To table	Purpose	From columns	To columns	Comments
Associate	Supplier	Sup. no.	Sup. no.

Telex country code

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	String of length 2	Text (2)
SQL name	TlxCtrCd	The database field name.
API identifier	telexCountryCode	The API identifier used in GraphQL.
Number	7115

Telex/fax

Enter T for Telex or F for Fax.

Is used for Telepay international

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	String of length 1	Text (1)
SQL name	TlxFax	The database field name.
API identifier	telexOrFax	The API identifier used in GraphQL.
Number	7114

Telex/fax no.

The telex or fax number.

Is used for Telepay international

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Phone	Text (20)
SQL name	TlxFaxNo	The database field name.
API identifier	telexOrFaxNo	The API identifier used in GraphQL.
Number	7116

Term contract

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	No.	Integer
SQL name	TrmCtr	The database field name.
API identifier	termContract	The API identifier used in GraphQL.
Number	7111

Term rate

The exchange rate according to the term contract.

Is used for Telepay international

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Amount	Decimal
SQL name	TrmRt	The database field name.
API identifier	termRate	The API identifier used in GraphQL.
Number	7112

Text code

The text code used by Unibank can be manually entered here.

Unibank publishes a separate document containing valid values.

Note:

Applies only to the payment type domestic payment (UBT033). The field is assigned the value 160 (invoice payment) if it is empty when data is uploaded to the bank.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Text code	Text (10)
SQL name	TxtCd	The database field name.
API identifier	textCode	The API identifier used in GraphQL.
Number	7087

Text line

Free text to be used in conjunction with Text code or Visma.net AutoPay.

This field is exported to Visma.net AutoPay.

The value in this field is inherited from the Additional text field in the Open supplier entry table. The option Set extra text on payment post in the EFT processing field in the Bank partner table must be turned on.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Text line	Text (200)
SQL name	TxtLn	The database field name.
API identifier	textLine	The API identifier used in GraphQL.
Number	7088

Trans. From payroll

The transaction comes from Visma Payroll if the box is selected.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Boolean	Integer
Memory field	Yes	The value in this field is only displayed in the program, it is not stored in the database.
API identifier	transactionFromPayroll	The API identifier used in GraphQL.
Number	8424

Urgent transmission

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Boolean	Integer
Memory field	Yes	The value in this field is only displayed in the program, it is not stored in the database.
API identifier	urgentTransmission	The API identifier used in GraphQL.
Number	7108

Value date

The value date provided by the bank.

The date is validated using the regional settings in Windows.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Date	Integer
SQL name	ValDt	The database field name.
API identifier	valueDate	The API identifier used in GraphQL.
Number	6949

Voucher jour. no.

The voucher journal number for the entry.

The number is set when running Create account batch on Payment line having Paym. line status = 5 - Settled.

Note:

If you double-click or press * in this field, you can look up a value in the related table.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Journal no.	Integer
Write Access	None	You are not allowed to modify the value in this field.
SQL name	JNo	The database field name.
API identifier	voucherJournalNo	The API identifier used in GraphQL.
Number	6944

Table 14. Table relations
To table	Purpose	From columns	To columns	Comments
Open customer entry	OpenCustomerEntry	Voucher jour. no. Audit no.	Voucher jour. no. Audit no.	This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others.
Open supplier entry	OpenSupplierEntry	Voucher jour. no. Audit no.	Voucher jour. no. Audit no.	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

Property	Value	Description
Visible by default	No	This field is not visible by default in the table display.
Domain	Provenance	Integer
Write Access	None	You are not allowed to modify the value in this field.
SQL name	ChPvn	The database field name.
API identifier	changedByProvenance	The API identifier used in GraphQL.
Number	A unique column number.

Changed by user

The name of the user that changed the record.

Property	Value	Description
Visible by default	No	This field is not visible by default in the table display.
Domain	User name	Text (24)
Write Access	None	You are not allowed to modify the value in this field.
SQL name	ChUsr	The database field name.
API identifier	changedByUser	The API identifier used in GraphQL.
Number	A unique column number.

Changed date

The date when the record was changed.

Property	Value	Description
Visible by default	No	This field is not visible by default in the table display.
Domain	Date	Integer
Write Access	None	You are not allowed to modify the value in this field.
SQL name	ChDt	The database field name.
API identifier	changedDate	The API identifier used in GraphQL.
Number	A unique column number.

Changed time

The time when the record was changed.

Property	Value	Description
Visible by default	No	This field is not visible by default in the table display.
Domain	Time	Integer
Write Access	None	You are not allowed to modify the value in this field.
SQL name	ChTm	The database field name.
API identifier	changedTime	The API identifier used in GraphQL.
Number	A unique column number.

Changed time stamp

The date and time when the record was changed.

The field is updated with the UTC time.

This value can be used by external systems to replicate changed data. The column is indexed.

Property	Value	Description
Visible by default	No	This field is not visible by default in the table display.
Domain	Date/time	DateTime
Write Access	None	You are not allowed to modify the value in this field.
SQL name	ChTs	The database field name.
API identifier	changedTimestamp	The API identifier used in GraphQL.
Number	A unique column number.

Created by provenance

The provenance for the record creation.

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

0 - None

1 - UI

10 - External API

20 - GAiA

21 - AI Connect

100 - Internal service

101 - Task automation

102 - AutoInvoice download

Property	Value	Description
Visible by default	No	This field is not visible by default in the table display.
Domain	Provenance	Integer
Write Access	None	You are not allowed to modify the value in this field.
SQL name	CrePvn	The database field name.
API identifier	createdByProvenance	The API identifier used in GraphQL.
Number	A unique column number.

Created by user

The name of the user that created the record.

Property	Value	Description
Visible by default	No	This field is not visible by default in the table display.
Domain	User name	Text (24)
Write Access	None	You are not allowed to modify the value in this field.
SQL name	CreUsr	The database field name.
API identifier	createdByUser	The API identifier used in GraphQL.
Number	A unique column number.

Created date

The date when the record was created.

Property	Value	Description
Visible by default	No	This field is not visible by default in the table display.
Domain	Date	Integer
Write Access	None	You are not allowed to modify the value in this field.
SQL name	CreDt	The database field name.
API identifier	createdDate	The API identifier used in GraphQL.
Number	A unique column number.

Created time

The time when the record was created.

Property	Value	Description
Visible by default	No	This field is not visible by default in the table display.
Domain	Time	Integer
Write Access	None	You are not allowed to modify the value in this field.
SQL name	CreTm	The database field name.
API identifier	createdTime	The API identifier used in GraphQL.
Number	A unique column number.

Created time stamp

The date and time when the record was created.

The field is updated with the UTC time.

Property	Value	Description
Visible by default	No	This field is not visible by default in the table display.
Domain	Date/time	DateTime
Write Access	None	You are not allowed to modify the value in this field.
SQL name	CreTs	The database field name.
API identifier	createdTimestamp	The API identifier used in GraphQL.
Number	A unique column number.

Edit status

The current status of the record.

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

0 - Unchanged: The record is read, but not changed.

1 - Inserted: The record is new.

2 - Changed: The record is changed.

3 - Deleted: The record is deleted.

Property	Value	Description
Visible by default	No	This field is not visible by default in the table display.
Domain	Edit status	Integer
Write Access	None	You are not allowed to modify the value in this field.
SQL name	LckSt	The database field name.
API identifier	editStatus	The API identifier used in GraphQL.
Number	A unique column number.

Process no

The Process no. from the Active company process table which is currently using or has control of this record.

Note:

If you double-click or press * in this field, you can look up a value in the related table.

Property	Value	Description
Visible by default	No	This field is not visible by default in the table display.
Domain	Process no.	Integer
Write Access	None	You are not allowed to modify the value in this field.
SQL name	ChPrc	The database field name.
API identifier	lockedByProcessNo	The API identifier used in GraphQL.
Number	A unique column number.

Table 15. Table relations
To table	Purpose	From columns	To columns	Comments
Active company process	CompanyProcess	Process no.	Process no.