Customer transaction

This table contains transactions posted on customers.

PropertyValueDescription
DatabaseCompanyThis table is in the company databases.
SQL nameCustTrThe table name in the database.
API identifiercustomerTransactionThe API identifier used in GraphQL.
Table no.54The table number in the data model.

The following fields exist in this table:

Acc. w/off variance %

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

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

Acc. w/off variance amount

Acc. w/off variance amount in EURO and Acc. w/off variance amount in currency fields show how much has been written off on the entries.

Visma Business accumulates the fields for invoice entries which are matched with entries with the origination code for writing off payments

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

Acc. w/off variance amount in currency

Acc. w/off variance amount in EURO and Acc. w/off variance amount in currency fields show how much has been written off on the entries.

Visma Business accumulates the fields for invoice entries which are matched with entries with the origination code for writing off payments

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

Acc. w/off variance amount in EURO

Acc. w/off variance amount in EURO and Acc. w/off variance amount in currency fields show how much has been written off on the entries.

Visma Business accumulates the fields for invoice entries which are matched with entries with the origination code for writing off payments. Acc. w/off variance amount in EURO is not in the database, but shows Acc. w/off variance amount in currency.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainAmountDecimal
Source columnAcc. w/off variance amount in currencyEuro
Write AccessNoneYou are not allowed to modify the value in this field.
Memory fieldYesThe value in this field is only displayed in the program, it is not stored in the database.
API identifierwriteOffVarianceAmountInEuroThe API identifier used in GraphQL.
Number8744 

Account. year/period

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

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

Accounting document no.

The accounting document no refers to Incoming accounting document table.

Note:
If you double-click or press * in this field, you can look up a value in the related table.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainNo.Integer
Write AccessSystem supervisor userOnly users who are marked as System supervisor in the User table are allowed to modify the value in this field.
SQL nameInAcDocNoThe database field name.
API identifierincomingAccountingDocumentNoThe API identifier used in GraphQL.
Number17957 
Table 1. Table relations
To tablePurposeFrom columnsTo columnsComments
Accounting documentIncomingAccountingDocument
  • Accounting document no.

Active approval task no.

Note:
If you double-click or press * in this field, you can look up a value in the related table.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainApproval Task no.Integer
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameAcAppTskNoThe database field name.
API identifieractiveApprovalTaskNoThe API identifier used in GraphQL.
Number18969 
Table 2. Table relations
To tablePurposeFrom columnsTo columnsComments
Approval taskApprovalTask
  • Active approval task no.

Additional text

Any additional information entered in the voucher.

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

Amount

This is taken from vouchers. The preceding sign is reversed if the transaction concerns a credit account number.

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

Amount in currency

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

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

Amount in currency 2

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

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

Amount in EURO

The Amount field converted to EURO.

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

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

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

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.

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

Approval workflow handle

Reference to a workflow in Visma.net Approval.

Used in Visma.net AutoPay for viewing of invoices.

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

Audit no.

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

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

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

AutoPay log seq. no.

Reference to the Identifier column in Visma.net AutoPay log table where the actual incoming payment file is stored.

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

AutoPay payment reference

Reference to an incoming payment imported from Visma.net AutoPay.

Details about the payment can be seen using the View payment details processing.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainAutoPay payment referenceText (100)
SQL nameApPmtRefThe database field name.
API identifierautopayPaymentReferenceThe API identifier used in GraphQL.
Number18208 

Balances not updated

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

Bank account

Updated from the Bank account field on the vouchers.

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

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

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

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

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

Case user status

A look-up in this field gives you the following list of possible values:
1 - Change due date
2 - Pause debt
3 - Cancel pause
9 - Close debt
10 - Approve for debt collection
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainCase user statusInteger
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameDColUsrStThe database field name.
API identifiercaseUserStatusThe API identifier used in GraphQL.
Number18859 

Cash amount

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

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

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

Cash amount in currency

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

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

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

Cash amount in EURO

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

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

Cash due date

Comes from vouchers.

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

The date is validated using the regional settings in Windows.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainDateInteger
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameCshDueDtThe database field name.
API identifiercashDueDateThe API identifier used in GraphQL.
Number4956 

CID code

Code used for electronic funds transfer.

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

Client interest amount

The field is updated when you post client interest by running the Post interest proposal processing in the Associate table. Used for the integration with Visma Lawyer.

The amount fields for the transaction are updated with the accumulated Client interest amount plus the value in the Client interest proposal amount field.

If you have selected Convert client interest in foreign exchange to default exchange in the Bank account processing field in the Bank account table, the Client interest amount field is converted at the current exchange rate with reference to the Client interest proposal amount in currency field.

Note:
You calculate client interest rates and post client interest proposals in the Associate table.

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

Client interest amount in currency

The field is updated when you post client interest by running the Post interest proposal processing in the Associate table. Used for the integration with Visma Lawyer.

Visma Business updates the client interest amount fields for the transaction with the accumulated Client interest amount in currency plus the value in the Client interest proposal amount in currency field.

The amount is converted using the current exchange rate with reference to the currency for the transaction. If you have selected Convert client interest rates in currency to default currency in the Bank account processing field in the Bank account table, the Client interest amount field is converted at the current exchange rate with reference to the Client interest proposal amount in currency field.

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

Client interest amount in EURO

Is not in the database. It is calculated on the basis of the amount field in the relevant currency. Used for the integration with Visma Lawyer.

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

Client interest from date

When you post entries running the Post interest proposal processing, Visma Business updates the Client interest from date and Client interest to date fields for the transactions. This field is updated with the value from the Client interest proposal from date field. Used for the integration with Visma Lawyer.

The date is validated using the regional settings in Windows.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainDateInteger
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameClIntFrDThe database field name.
API identifierclientInterestFromDateThe API identifier used in GraphQL.
Number11225 

Client interest proposal amount

When running the Calculate client interest processing in the Associate table, this field is updated with the correct rate from the Interest rate table. Used for the integration with Visma Lawyer.

Settings from the Bank account and Client processing fields are taken into account. The value in the field is not accumulated, but is overwritten with new values. Client interest proposal amount and Client interest proposal amount in currency are calculated using the same interest rate. When you post this, reference is made to whether it is to be processed in domestic amount or in currency amount. You can change the value in the field, and the change is taken into account when you post client interest. The field is emptied when you run the Delete interest proposal processing in the Associate table.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainAmountDecimal
SQL nameClSugAmThe database field name.
API identifierclientInterestProposalAmountDomesticThe API identifier used in GraphQL.
Number13088 

Client interest proposal amount in currency

This field is updated with the Client interest proposal amount in currency. Used for the integration with Visma Lawyer.

Client interest proposal amount in currency is calculated using the same Interest rate as Client interest rate amount. When you post this, reference is made to whether it is to be processed in domestic amount or in currency amount. You can change the value in the field, and the change is taken into account when you post client interest. The field is emptied when you run the Delete interest proposal processing in the Associate table.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainAmountDecimal
SQL nameClSugCAmThe database field name.
API identifierclientInterestProposalAmountInCurrencyThe API identifier used in GraphQL.
Number13086 

Client interest proposal amount in EURO

This field is calculated on the basis of the Client interest proposal amount field. Used for the integration with Visma Lawyer.

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

Client interest proposal from date

When running the Calculate client interest processing in the Associate table, this field is updated with the value in the Client interest to date field. Used for the integration with Visma Lawyer.

If the Client interest to date field is blank, this field is updated with the voucher date. You can change the value in the field, and the change is taken into account when you post client interest. The field is emptied when you run the Delete interest proposal processing in the Associate table.

Note:
The client interest amount is changed when you change the value in the Client interest proposal from date field.

The date is validated using the regional settings in Windows.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainDateInteger
SQL nameClSugFrDThe database field name.
API identifierclientInterestProposalFromDateThe API identifier used in GraphQL.
Number13084 

Client interest proposal to date

When you run the Calculate client interest processing in the Associate table, this field is updated with the value in the To date field in the Calculate client interest dialog box. Used for the integration with Visma Lawyer.

This field is used when calculating the Client interest proposal amount. You can change the value in the field, and the change is taken into account when you post client interest. The field is emptied when you run the Delete interest proposal processing in the Associate table.

Note:
The Client interest amount is changed when you change the value in the Client interest proposal from date field.

The date is validated using the regional settings in Windows.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainDateInteger
SQL nameClSugToDThe database field name.
API identifierclientInterestProposalToDateThe API identifier used in GraphQL.
Number13085 

Client interest to date

When you post entries running the Post interest proposal processing, Visma Business updates the Client interest from date and Client interest to date fields for the transactions. This field is updated with the value from the Client interest proposal to date field. Used for the integration with Visma Lawyer.

The date is validated using the regional settings in Windows.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainDateInteger
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameClIntToDThe database field name.
API identifierclientInterestToDateThe API identifier used in GraphQL.
Number11226 

Client processing

Comes from vouchers and defines whether the client processing is outlay or a client responsibility, that can be used for client interest calculation.

A look-up in this field gives you the following list of possible values:
1 - Outlay
2 - Client responsibility 1
3 - Client responsibility 2
4 - Client responsibility 3
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainClient processingInteger
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameClPrcThe database field name.
API identifierclientProcessingThe API identifier used in GraphQL.
Number8435 

Control status

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

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

Country no.

Note:
If you double-click or press * in this field, you can look up a value in the related table.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainCountry no.Integer
SQL nameCtryThe database field name.
API identifiercountryNoThe API identifier used in GraphQL.
Number17530 
Table 3. Table relations
To tablePurposeFrom columnsTo columnsComments
CountryCountry
  • Country no.

Credit

Defines that the amount is < 0.

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

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

Credit amount

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

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

Credit amount in currency

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

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

Credit amount in EURO

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

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

Credit outstanding amount

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

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

Credit outstanding amount in currency

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

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

Credit outstanding amount in EURO

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

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

Credit quantity

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

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

Credited amount

The field is not in use.

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

Cross reference

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

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

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

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

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

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainDoc. no.Text (40)
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameAgRefThe database field name.
API identifiercrossReferenceThe API identifier used in GraphQL.
Number1191 

Cross-account no.

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

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

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

Note:
If you double-click or press * in this field, you can look up a value in the related table.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainAccount no.Integer
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameAgAcNoThe database field name.
API identifiercrossAccountNoThe API identifier used in GraphQL.
Number4357 
Table 4. Table relations
To tablePurposeFrom columnsTo columnsComments
AssociateCrossCustomer
  • Cross-account no.
AssociateCrossSupplier
  • Cross-account no.
General ledger accountCrossGeneralLedgerAccount
  • Cross-account no.
Capital assetCrossCapitalAsset
  • Cross-account no.

Cross-account type

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

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

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

A look-up in this field gives you the following list of possible values:
1 - Customer
The account number refer to a customer.
2 - Supplier
The account number refer to a supplier.
3 - General ledger account
The account number refer to a general ledger account.
4 - Capital asset
The account number refer to a capital asset.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainAccount typeInteger
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameAgAcClThe database field name.
API identifiercrossAccountTypeThe API identifier used in GraphQL.
Number4356 

Curr. corr. amount

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

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

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

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

Curr. corr. date

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

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

The date is validated using the regional settings in Windows.

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

Curr. corr. exch. rate

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

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

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

Curr. corr. run no.

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

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

Currency no.

The records currency number.

The currency number is normally inherited from the voucher. If no currency number was entered on the voucher, the field will anyway be updated with the Currency no. from the Company information table.

Note:
If you double-click or press * in this field, you can look up a value in the related table.
PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainCurrency no.Integer
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameCurThe database field name.
API identifiercurrencyNoThe API identifier used in GraphQL.
Number1180 
Table 5. Table relations
To tablePurposeFrom columnsTo columnsComments
CurrencyCurrency
  • Currency no.

Currency no. 2

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

Note:
If you double-click or press * in this field, you can look up a value in the related table.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainCurrency no.Integer
SQL nameCur2The database field name.
API identifiercurrencyNo2The API identifier used in GraphQL.
Number14304 
Table 6. Table relations
To tablePurposeFrom columnsTo columnsComments
CurrencyCurrency2
  • Currency no. 2

Cust. no.

The Cust. no. the transaction applies to.

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.
DomainCust. no.Integer
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameCustNoThe database field name.
API identifiercustomerNoThe API identifier used in GraphQL.
Number1171 
Table 7. Table relations
To tablePurposeFrom columnsTo columnsComments
AssociateCustomer
  • Cust. no.
Customer balanceCustomerBalance
  • Cust. no.
  • Year
  • Period
This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others.
Product transactionProductTransaction
  • Cust. no.
  • Invoice no.
This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others.
Product transaction before compressionProductTransaction2
  • Cust. no.
  • Invoice no.
This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others.

Date 1

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

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

The date is validated using the regional settings in Windows.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainDateInteger
SQL nameDt1The database field name.
API identifierdate1The API identifier used in GraphQL.
Number11092 

Date 2

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

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

The date is validated using the regional settings in Windows.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainDateInteger
SQL nameDt2The database field name.
API identifierdate2The API identifier used in GraphQL.
Number11093 

Debit amount

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

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

Debit amount in currency

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

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

Debit amount in EURO

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

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

Debit outstanding amount

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

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

Debit outstanding amount in currency

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

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

Debit outstanding amount in EURO

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

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

Debit quantity

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

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

Debt collection approval

A look-up in this field gives you the following list of possible values:
0 - No action required
1 - Suggested
2 - Approved
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainDebt collection approvalInteger
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameDColLstThe database field name.
API identifierdebtCollectionApprovalThe API identifier used in GraphQL.
Number18855 

Debt collection case no.

The debt collection company's case no.

The case no from the debt collection company will be updated when the debt collection company's web portal responds after Open customer entry has been exported to the debt collection company.

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

Debt collection case type

The debt collection company's case type.

An "x" in the field indicates that the Open customer entry is subject to debt collection. If blank, indicates that the Open customer entry is subject to reminder process.

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

Debt collection ID

A unique ID for the invoice.

The field contains a GUID value generated by Visma Business when running the processing Send to AutoCollect. The value follows the Open customer entry to the debt collection company.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainGUIDText (40)
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameDColIdThe database field name.
API identifierdebtCollectIdThe API identifier used in GraphQL.
Number18992 

Debt collection last updated date

Date for the last update.

Date when the Open customer entry row was updated from the debt collection company.

The date is validated using the regional settings in Windows.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainDateInteger
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameDColLUDtThe database field name.
API identifierdebtCollectionLastUpdatedDateThe API identifier used in GraphQL.
Number18850 

Debt collection last updated time

Time for the last update.

Time when row was updated from the debt collection company.

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 nameDColLUTmThe database field name.
API identifierdebtCollectionLastUpdatedTimeThe API identifier used in GraphQL.
Number18851 

Debt collection matching amount

Amount to be matched against Open customer entry subject to debt collection.

Amount in standard currency that has been remitted and processed in Visma Business and shall be matched against the Open customer entry subject to debt collection by the debt collection company.

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

Debt collection matching acknowledgement

Response message from the debt collection company.

Response message from the debt collection company after matching amount against Open customer entry subject to debt collection by the debt collection company.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainTextText (200)
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameDColMRThe database field name.
API identifierdebtCollectMatchingAcknowledgementThe API identifier used in GraphQL.
Number18866 

Debt collection matching sent date

Date when amount to be matched was sent to Visma AutoCollect.

The date is validated using the regional settings in Windows.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainDateInteger
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameDColMSDtThe database field name.
API identifierdebtCollectMatchingSentDateThe API identifier used in GraphQL.
Number18863 

Debt collection matching sent time

Time when amount to be matched was sent to Visma AutoCollect.

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 nameDColMSTmThe database field name.
API identifierdebtCollectMatchingSentTimeThe API identifier used in GraphQL.
Number18864 

Debt collection outstanding fee in currency

The debt collection company's fee.

The field contains the unpaid/remaining fee amount debited by the debt collection company.

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

Debt collection outstanding interest in currency

Accrued interest for the invoice.

The field contains the unpaid/remaining interest amount calculated and debited by the debt collection company.

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

Debt collection response status

Contains response from the debt collection company.

The values in this field are given by the debt collection company after using the processing Send to AutoCollect or Change debt collection status.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainTextText (200)
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameDColRStThe database field name.
API identifierdebtCollectionResponseStatusThe API identifier used in GraphQL.
Number18849 

Debt collection rest amount

The Outstanding amount in standard currency for the invoice.

The Outstanding amount also contains accrued Interest amount calculated by the debt collection company.

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

Debt collection run no.

A Debt collection run no. will be inserted in this field when you run the Transfer to debt collection processing in the Associate table.

The number is visualised and can be changed in the Change counters processings dialog in the Company information table.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainNo.Integer
SQL nameLegRRNoThe database field name.
API identifierdebtCollectionRunNoThe API identifier used in GraphQL.
Number11866 

Debt collection sent date

Date when the invoice was sent to debt collection company.

Date when Open customer entry was sent to debt collection company with the Send to AutoCollect processing.

The date is validated using the regional settings in Windows.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainDateInteger
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameDColSDtThe database field name.
API identifierdebtCollectionSentDateThe API identifier used in GraphQL.
Number18847 

Debt collection sent time

Time when the invoice was sent to debt collection company.

Time when Open customer entry was sent to debt collection company with the Send to AutoCollect processing.

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 nameDColSTmThe database field name.
API identifierdebtCollectionSentTimeThe API identifier used in GraphQL.
Number18848 

Debt collection status

The status of the case at the debt collection company.

Possible statuses are given by the debt collection agency and will be updated from debt collection agency when running the Retrieve AutoCollect information processing.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainTextText (200)
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameDColStThe database field name.
API identifierdebtCollectionStatusThe API identifier used in GraphQL.
Number18854 

Debt collection status sent date

Date when user status was sent to Visma AutoCollect.

The date is validated using the regional settings in Windows.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainDateInteger
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameDColUsrSDtThe database field name.
API identifierdebtCollectUserStatusSentDateThe API identifier used in GraphQL.
Number18860 

Debt collection status sent time

Time when user status was sent to Visma AutoCollect.

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 nameDColUsrSTmThe database field name.
API identifierdebtCollectUserStatusSentTimeThe API identifier used in GraphQL.
Number18861 

Debt collection user acknowledgement

Response message from Visma AutoCollect for the user.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainTextText (200)
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameDColUsrRThe database field name.
API identifierdebtCollectUserAcknowledgementThe API identifier used in GraphQL.
Number18862 

Debt collection validation status

Shows eventual errors that can have occurred when transferring invoices to debt collection company with the Send to AutoCollect processing.

The field will contain a bit value if an Open customer entry remains unprocessed when running the processing Send to AutoCollect. Double-click or press <*> in the field will visualise a dialog with check boxes where the reason(s) for excluding the Open customer entry from being sent will be ticked. There are three types of reasons:
  • Conditions on the Open customer entry line is missing or invalid
  • Conditions in the Debt collection agreement is not met
  • Conditions for the customer in the Associate table is not met

A look-up opens the dialog box where you can see the following check boxes and options:
Already sent to AutoCollect
Invoice free of reminders
Sent to debt collection
Invoice exempt from debt collection
Not within the days of grace in the debt collection agreement
Outstanding amount in currency for the invoice is not greater than 0
Outstanding amount for the invoice is not within the minimum amount in the debt collection agreement
No. of reminders sent not 0
No. of reminders sent not greater than 0
No. of reminders sent in debt collection agreement not fulfilled
Cannot find customer in Associate table
Customer exempt from debt collection
Customer is free of reminders
Cannot find name on customer in Associate table
Cannot find post code on customer in Associate table
Cannot find postal area on customer in Associate table
Voucher type is empty
Cannot find voucher type in voucher type table
Debt collection voucher type is empty on voucher type
Current customer balance is less than or equal to zero
Not sent to AutoCollect because unmatched payments or credit notes
Cannot find person ID on customer in Associate table
Cannot find organisation no. on customer in Associate table
Debt collection voucher type is not set as an invoice
Debt collection voucher type has multiple selections that are illegal
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainDebt collection validation statusInteger
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameDColValStThe database field name.
API identifierdebtCollectionValidationStatusThe API identifier used in GraphQL.
Number18997 

Delivery associate no.

This field is updated from the vouchers.

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

Note:
If you double-click or press * in this field, you can look up a value in the related table.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainAssociate no.Integer
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameDelActNoThe database field name.
API identifierdeliveryAssociateNoThe API identifier used in GraphQL.
Number8894 
Table 8. Table relations
To tablePurposeFrom columnsTo columnsComments
AssociateDeliveryAssociate
  • Delivery associate no.

Direct deb. run no.

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

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainNo.Integer
SQL nameDebRnNoThe database field name.
API identifierdirectDebitingRunNoThe API identifier used in GraphQL.
Number5513 

Due date

Is updated from the Voucher.

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

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

The Due date field is also used when you execute the Create payment suggestion processing from the corresponding open entry table. A selection will be made in relation to the outlay date.

The date is validated using the regional settings in Windows.

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

Empl. no.

The employee entered in the Voucher.

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

Note:
If you double-click or press * in this field, you can look up a value in the related table.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainEmpl. no.Integer
SQL nameEmpNoThe database field name.
API identifieremployeeNoThe API identifier used in GraphQL.
Number3072 
Table 9. Table relations
To tablePurposeFrom columnsTo columnsComments
AssociateEmployee
  • Empl. no.

Error message

Any errors detected during a batch update.

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

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

Exchange rate

The exchange rate for the currency.

Is updated from the Voucher table.

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

Exchange rate 2

The exchange rate for currency 2.

Is updated from the Voucher table.

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

External reference 1

Used by some bank reconciliation system to show processed transactions.

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

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

External reference 2

Used by some bank reconciliation system to show processed transactions.

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

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

External reference 3

Used by some bank reconciliation system to show processed transactions.

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

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

Factoring run no.

Is filled in when you run the Factoring processing from the Open customer entry table. The number is assigned from the counter in the Change counters processings dialog in the Company information table.

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

Fixed amount

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

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

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

Fixed amount in currency

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

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

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

Fixed amount in EURO

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

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

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

Free 1

Additional numeric information about the transaction.

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

Free 2

Additional numeric information about the transaction.

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

Free 3

Additional numeric information about the transaction.

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

Free 4

Additional numeric information about the transaction.

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

GL account

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

The General ledger account to which the transaction shall be accumulated can be defined in (in priority order)
  1. The Associate table for the specific associate.
  2. The Account no. series table.
  3. The Company information table.

Note:
If you double-click or press * in this field, you can look up a value in the related table.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainAccount no.Integer
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameGenAcNoThe database field name.
API identifiergeneralLedgerAccountNoThe API identifier used in GraphQL.
Number1209 
Table 10. Table relations
To tablePurposeFrom columnsTo columnsComments
General ledger accountGeneralLedgerAccount
  • GL account

Interest amount

How much interest has been calculated on an entry.

If interest method 1 or 2 applies, the value in the field will be accumulated after each interest invoicing. If interest method 3 or 4 applies, the field will be updated only once. Interest method is defined in the Country table.

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

Interest amount in currency

How much interest has been calculated on an entry in currency.

If interest method 1 or 2 applies, the value in the field will be accumulated after each interest invoicing. If interest method 3 or 4 applies, the field will be updated only once. Interest method is defined in the Country table.

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

Interest amount in EURO

How much interest has been calculated on an entry converted into EUROS.

If interest method 1 or 2 applies, the value in the field will be accumulated after each interest invoicing. If interest method 3 or 4 applies, the field will be updated only once. Interest method is defined in the Country table.

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

Interest free amount

A fraction of the Amount that is exempt from interest calculation in the default currency.

The amount can be entered on the voucher line and inherited to the transaction. It can also be entered (or overridden) directly on the transaction record.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainAmountDecimal
SQL nameFreeAmThe database field name.
API identifierinterestFreeAmountDomesticThe API identifier used in GraphQL.
Number11606 

Interest free amount in currency

A fraction of the Amount in currency that is exempt from interest calculation in the default currency.

The amount can be entered on the voucher line and inherited to the transaction. It can also be entered (or overridden) directly on the transaction record.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainAmountDecimal
SQL nameFreeCurAThe database field name.
API identifierinterestFreeAmountInCurrencyThe API identifier used in GraphQL.
Number11607 

Interest free amount in EURO

A fraction of the Amount in EURO that is exempt from interest calculation in the default currency.

The amount can be entered on the voucher line and inherited to the transaction. It can also be entered (or overridden) directly on the transaction record.

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

Interest from date

See the explanation for the Interest to date field.

The date is validated using the regional settings in Windows.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainDateInteger
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameIntFrDtThe database field name.
API identifierinterestFromDateThe API identifier used in GraphQL.
Number2244 

Interest rate

Can be entered on vouchers, or in the Open customer entry table.

If not filled in, Visma Business uses the interest rate specified for the customer or for the customer's Country no. in the Country table when the interest note is printed. Interest rate can also be changed for one single entry, in this case interest can be calculated for the same customer at different rates in the same interest note.

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

Interest this run

Shows how much interest has been calculated for an entry on this run.

Note:
The field will show values only on the interest invoice print-out and NOT on the screen.

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

Interest this run in currency

Shows how much interest has been calculated for an entry in the current currency on this run.

Note:
The field will show values only on the interest invoice print-out and NOT on the screen.

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

Interest this run in EURO

Shows how much interest has been calculated for an entry converted into EUROS on this run.

The field will show values only on the interest invoice print-out and NOT on the screen.

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

Interest to date

Is updated when you run an interest note for an entry.

Interest is calculated from the Due date up to the current date when Interest method 1 or 2 is defined in the Country table, and to the payment date when interest method 3 or 4 is defined in the Country table. If you want to calculate interest manually, you can fill in the fields as information. If you have agreed no interest for a particular period after the Due date, this field can be filled in with the date to which you want interest to be calculated.

If you have filled in the Maximum number of interest days field in the Payment term table, the field will show Interest to date as Interest from date + Maximum number of interest days. If you are using the Interest free days in the Payment term table, the field will show Interest from date as Due date + Interest free days.

The date is validated using the regional settings in Windows.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainDateInteger
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameIntToDtThe database field name.
API identifierinterestToDateThe API identifier used in GraphQL.
Number1195 

Invoice currency amount

The amount in the invoice currency on printouts.

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

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

Invoice no.

The invoice number from the Voucher.

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

Note:
If you double-click or press * in this field, you can look up a value in the related table.
PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainDoc. no.Text (40)
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameInvoNoThe database field name.
API identifierinvoiceNoThe API identifier used in GraphQL.
Number1188 
Table 11. Table relations
To tablePurposeFrom columnsTo columnsComments
Product transactionProductTransaction
  • Cust. no.
  • Invoice no.
This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others.
Product transaction before compressionProductTransaction2
  • Cust. no.
  • Invoice no.
This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others.

Last curr. corr. amount

The last recalculated amount from the Currency correction processing.

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

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

Last reminder date

Updated from the print dialog when printing the last reminder.

It must be set back in time if you want to reprint a reminder after you have approved the printout, or dispatch the next reminder earlier than warranted by the reminder interval in the Reminder table.

The date is validated using the regional settings in Windows.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainDateInteger
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameRemRnNoThe database field name.
API identifierlastReminderDateThe API identifier used in GraphQL.
Number1200 

Memo file name

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

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

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

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

Memo no.

Link to the memo for the entry.

The actual memo is stored in the Memo table.

Note:
If you double-click or press * in this field, you can look up a value in the related table.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainMemo no.Integer
SQL nameMemoNoThe database field name.
API identifiermemoNoThe API identifier used in GraphQL.
Number19206 
Table 12. Table relations
To tablePurposeFrom columnsTo columnsComments
MemoMemo
  • Memo no.

No interest

Exempts the record from interest calculation when filled in.

If you want to have automatic interest exemption for a debit invoice when crediting, you can tick the Ref. Entry Free of interest parameter in the Order options field in the Order table. The transaction that a credit note with interest exemption generates inserts a check in the No interest field. When the entry has been paid, it will be concluded. If it has been part-paid, the check for No interest will remain for the entry with the outstanding amount.

The processing Calculate client interest also takes this field into account. If you select Set entry free of interest on suspended cases in the Company information table in the Accounting processing field, blocked cases will be exempted from interest when you post client interest.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainBooleanInteger
SQL nameExcIntThe database field name.
API identifiernoInterestThe API identifier used in GraphQL.
Number1198 

No. of reminders sent

Updated when approving printed reminders, or received from Visma AutoCollect.

You can change the number of reminders in order to reprint a reminder. If you choose to update the reminder fee automatically when reminders are printed, you must manually reverse it in the accounts if they are resent.

When Visma AutoCollect integration is active, this field is automatically update with values received from Visma AutoCollect.
Note:
Updates for this field is not received from Visma AutoCollect if Collect only is selected in AutoCollect processing in the Debt collection agreement table. The reminder process is then handled by processes inside Business NXT.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainNumber of remindersInteger
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameRemsThe database field name.
API identifiernoOfRemindersSentThe API identifier used in GraphQL.
Number1196 

No reminders

An entry can be exempted from reminders either when vouchers are entered or in the Open customer entry table.

You can also stipulate that a Customer is not to be subject to reminders by selecting the flag No reminders in the Customer options field in the Associate table.

A look-up in this field gives you the following list of possible values:
1 - No reminders
2 - Exempt from debt recovery
Will stop an invoice from going to debt collection.
3 - Sent to debt collection
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainNo remindersInteger
SQL nameExcRemThe database field name.
API identifiernoRemindersThe API identifier used in GraphQL.
Number1197 

Order no.

Is updated from the Voucher.

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

Note:
If you double-click or press * in this field, you can look up a value in the related table.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainOrder no.Integer
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameOrdNoThe database field name.
API identifierorderNoThe API identifier used in GraphQL.
Number3364 
Table 13. Table relations
To tablePurposeFrom columnsTo columnsComments
OrderOrder
  • Order no.

Organisational unit 1

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

Organisational units fields can be used freely according to company needs to split accounting, sales and purchases into organisational units. The most common types are department, project and campaign. It is also possible to limit the organisational units a user should see by limiting the organisational units in the Limitation groups, User limitation groups and Limitations. The field appear with the name assigned to it in the Company information table.

Note:
If you double-click or press * in this field, you can look up a value in the related table.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainOrganisational unit no.Integer
SQL nameR1The database field name.
API identifierorgUnit1The API identifier used in GraphQL.
Number1201 
Table 14. Table relations
To tablePurposeFrom columnsTo columnsComments
Organisational unit 1OrgUnit1
  • Organisational unit 1

Organisational unit 2

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

Organisational units fields can be used freely according to company needs to split accounting, sales and purchases into organisational units. The most common types are department, project and campaign. It is also possible to limit the organisational units a user should see by limiting the organisational units in the Limitation groups, User limitation groups and Limitations. The field appear with the name assigned to it in the Company information table.

Note:
If you double-click or press * in this field, you can look up a value in the related table.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainOrganisational unit no.Integer
SQL nameR2The database field name.
API identifierorgUnit2The API identifier used in GraphQL.
Number1202 
Table 15. Table relations
To tablePurposeFrom columnsTo columnsComments
Organisational unit 2OrgUnit2
  • Organisational unit 2

Organisational unit 3

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

Organisational units fields can be used freely according to company needs to split accounting, sales and purchases into organisational units. The most common types are department, project and campaign. It is also possible to limit the organisational units a user should see by limiting the organisational units in the Limitation groups, User limitation groups and Limitations. The field appear with the name assigned to it in the Company information table.

Note:
If you double-click or press * in this field, you can look up a value in the related table.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainOrganisational unit no.Integer
SQL nameR3The database field name.
API identifierorgUnit3The API identifier used in GraphQL.
Number1203 
Table 16. Table relations
To tablePurposeFrom columnsTo columnsComments
Organisational unit 3OrgUnit3
  • Organisational unit 3

Organisational unit 4

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

Organisational units fields can be used freely according to company needs to split accounting, sales and purchases into organisational units. The most common types are department, project and campaign. It is also possible to limit the organisational units a user should see by limiting the organisational units in the Limitation groups, User limitation groups and Limitations. The field appear with the name assigned to it in the Company information table.

Note:
If you double-click or press * in this field, you can look up a value in the related table.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainOrganisational unit no.Integer
SQL nameR4The database field name.
API identifierorgUnit4The API identifier used in GraphQL.
Number1204 
Table 17. Table relations
To tablePurposeFrom columnsTo columnsComments
Organisational unit 4OrgUnit4
  • Organisational unit 4

Organisational unit 5

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

Organisational units fields can be used freely according to company needs to split accounting, sales and purchases into organisational units. The most common types are department, project and campaign. It is also possible to limit the organisational units a user should see by limiting the organisational units in the Limitation groups, User limitation groups and Limitations. The field appear with the name assigned to it in the Company information table.

Note:
If you double-click or press * in this field, you can look up a value in the related table.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainOrganisational unit no.Integer
SQL nameR5The database field name.
API identifierorgUnit5The API identifier used in GraphQL.
Number1205 
Table 18. Table relations
To tablePurposeFrom columnsTo columnsComments
Organisational unit 5OrgUnit5
  • Organisational unit 5

Organisational unit 6

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

Organisational units fields can be used freely according to company needs to split accounting, sales and purchases into organisational units. The most common types are department, project and campaign. It is also possible to limit the organisational units a user should see by limiting the organisational units in the Limitation groups, User limitation groups and Limitations. The field appear with the name assigned to it in the Company information table.

Note:
If you double-click or press * in this field, you can look up a value in the related table.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainOrganisational unit no.Integer
SQL nameR6The database field name.
API identifierorgUnit6The API identifier used in GraphQL.
Number1206 
Table 19. Table relations
To tablePurposeFrom columnsTo columnsComments
Organisational unit 6OrgUnit6
  • Organisational unit 6

Organisational unit 7

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

The field appear with the name assigned to it in the Company information table.

Note:
If you double-click or press * in this field, you can look up a value in the related table.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainLong alphanumeric organisational unit no.Text (40)
SQL nameR7The database field name.
API identifierorgUnit7The API identifier used in GraphQL.
Number9420 
Table 20. Table relations
To tablePurposeFrom columnsTo columnsComments
Organisational unit 7OrgUnit7
  • Organisational unit 7

Organisational unit 8

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

The field appear with the name assigned to it in the Company information table.

Note:
If you double-click or press * in this field, you can look up a value in the related table.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainShort alphanumeric organisational unit no.Text (10)
SQL nameR8The database field name.
API identifierorgUnit8The API identifier used in GraphQL.
Number9421 
Table 21. Table relations
To tablePurposeFrom columnsTo columnsComments
Organisational unit 8OrgUnit8
  • Organisational unit 8

Organisational unit 9

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

The field appear with the name assigned to it in the Company information table.

Note:
If you double-click or press * in this field, you can look up a value in the related table.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainShort alphanumeric organisational unit no.Text (10)
SQL nameR9The database field name.
API identifierorgUnit9The API identifier used in GraphQL.
Number9422 
Table 22. Table relations
To tablePurposeFrom columnsTo columnsComments
Organisational unit 9OrgUnit9
  • Organisational unit 9

Organisational unit 10

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

The field appear with the name assigned to it in the Company information table.

Note:
If you double-click or press * in this field, you can look up a value in the related table.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainShort alphanumeric organisational unit no.Text (10)
SQL nameR10The database field name.
API identifierorgUnit10The API identifier used in GraphQL.
Number9423 
Table 23. Table relations
To tablePurposeFrom columnsTo columnsComments
Organisational unit 10OrgUnit10
  • Organisational unit 10

Organisational unit 11

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

The field appear with the name assigned to it in the Company information table.

Note:
If you double-click or press * in this field, you can look up a value in the related table.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainShort alphanumeric organisational unit no.Text (10)
SQL nameR11The database field name.
API identifierorgUnit11The API identifier used in GraphQL.
Number9424 
Table 24. Table relations
To tablePurposeFrom columnsTo columnsComments
Organisational unit 11OrgUnit11
  • Organisational unit 11

Organisational unit 12

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

The field appear with the name assigned to it in the Company information table.

Note:
If you double-click or press * in this field, you can look up a value in the related table.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainShort alphanumeric organisational unit no.Text (10)
SQL nameR12The database field name.
API identifierorgUnit12The API identifier used in GraphQL.
Number9425 
Table 25. Table relations
To tablePurposeFrom columnsTo columnsComments
Organisational unit 12OrgUnit12
  • Organisational unit 12

Origin

Indicates whether the Voucher was entered manually or generated automatically.

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

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

Original due date

Is updated with the value from the Due date field if due date is altered. This is only of significance to the interest calculation routine. The default is the due date that forms the basis of interest calculation.

In the Company information table, you can control the interest calculation using the parameter Use original due date for interest calculation, which can be found under Accounting processing. The customer will then pay interest from the original due date, even though the due date has been moved.

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 nameOrgDueDtThe database field name.
API identifieroriginalDueDateThe API identifier used in GraphQL.
Number11601 

Original run no.

The Order journal number from which the transaction origin.

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

Note:
If you double-click or press * in this field, you can look up a value in the related table.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainJournal no.Integer
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameSrcJNoThe database field name.
API identifieroriginalRunNoThe API identifier used in GraphQL.
Number1208 
Table 26. Table relations
To tablePurposeFrom columnsTo columnsComments
Order journalOrderJournal
  • Original run no.

Original voucher no.

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

Outstanding amount

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

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

Outstanding amount in currency

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

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

Outstanding amount in EURO

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

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

Paid curr. amount

Paid amount in the current currency.

Accumulates remitted part payments.

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

Paid last

The voucher date of the last matched payment voucher.

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

The date is validated using the regional settings in Windows.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainDateInteger
Write AccessNoneYou are not allowed to modify the value in this field.
SQL namePayedDtThe database field name.
API identifierpaidLastThe API identifier used in GraphQL.
Number1187 

Paid status

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

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

Part payment

Is updated from vouchers and cannot be overridden.

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

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

Part payment in currency

Is updated from vouchers and cannot be overridden.

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

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

Part payment in EURO

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

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

Payment element index

Reference to the relevant <Payment> element in the incoming payment file.

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

Payment line element index

Reference to the relevant <PaymentLine> element in the incoming payment file.

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

Payment method

Is updated from vouchers.

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

Payment method texts for different languages can be defined in the Text table. These texts has text type 7.
Note:
If you double-click or press * in this field, you can look up a Payment method in the Text table.
Note:
If you double-click or press * in this field, you can look up a value in the related table.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainPayment methodInteger
Write AccessNoneYou are not allowed to modify the value in this field.
SQL namePmtMtThe database field name.
API identifierpaymentMethodThe API identifier used in GraphQL.
Number10540 
Table 27. Table relations
To tablePurposeFrom columnsTo columnsComments
Payment methodPaymentMethod
  • Payment method

Payment no.

The Payment no. from the Payment table.

This field is updated with the payment number when you run the processing Create payment suggestion in the Open customer entry table.

Note:
If you double-click or press * in this field, you can look up a value in the related table.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainPayment no.Integer
SQL namePmtNoThe database field name.
API identifierpaymentNoThe API identifier used in GraphQL.
Number11094 
Table 28. Table relations
To tablePurposeFrom columnsTo columnsComments
PaymentPayment
  • Payment no.

Payment suggested

Shows a "x", if a payment suggestion has been created.

The field can be reset to payment suggestion not created, if the entry has been processed to a payment suggestion by mistake. You can then delete the payment suggestion in the Payment line table and run the Create payment suggestion processing again.
Note:
The field is used both for creating payment suggestion for payments to customers, and for Direct debit claims.

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

Payment terms

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

Payment terms texts for different languages can be defined in the Text table. These texts has text type 6.
Note:
If you double-click or press * in this field, you can look up a Payment terms in the Text table.
Note:
If you double-click or press * in this field, you can look up a value in the related table.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainPayment termsInteger
Write AccessNoneYou are not allowed to modify the value in this field.
SQL namePmtTrmThe database field name.
API identifierpaymentTermsThe API identifier used in GraphQL.
Number4955 
Table 29. Table relations
To tablePurposeFrom columnsTo columnsComments
Payment termPaymentTerms
  • Payment terms

Period

Shows the accounting period to which the transaction was posted.

Note:
If you double-click or press * in this field, you can look up a value in the related table.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainPeriodInteger
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameAcPrThe database field name.
API identifierperiodThe API identifier used in GraphQL.
Number1177 
Table 30. Table relations
To tablePurposeFrom columnsTo columnsComments
Accounting periodAccountingPeriod
  • Year
  • Period
This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others.
Customer balanceCustomerBalance
  • Cust. no.
  • Year
  • Period
This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others.

Period batch no.

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

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

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainNo.Integer
SQL namePrBtThe database field name.
API identifierperiodBatchNoThe API identifier used in GraphQL.
Number10542 

Picture file name

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

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

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.

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

Previous voucher no.

The original voucher number when you reverse transactions.

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

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

Priority

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

The field is mainly used for sorting and selecting purposes.

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

Quantity

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

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

Ready for reminder

In use for Open customer entry to display due date including days of grace.

This makes it easier to see when the entry is actually ready to be sent as a reminder, for example by using Task overview. The order in which the correct days of grace is found:
  1. Payment terms table. If the payment term used have a Days of grace value, this will be used.
  2. Open customer entry table. If the Country no. field is set, the Days of grace value for this country will be used.
  3. Associate table. If the Country no. field is set for the customer, the Days of grace value for this country will be used.
  4. Company information table. The Days of grace value for the Country no. will be used.

When changing either Country no. or Payment terms on the Open customer entry record, the Ready for reminder value will be updated automatically. On new entries, Ready for reminder will be automatically calculated. On existing records, the new processing Recalculate Ready for Reminder date must be used.

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 nameRfRDtThe database field name.
API identifierreadyForReminderThe API identifier used in GraphQL.
Number18395 

Reference

Comes from vouchers.

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

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainDoc. no.Text (40)
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameRefThe database field name.
API identifierreferenceThe API identifier used in GraphQL.
Number1190 

Reminder doc. no.

When you approve a reminder, the Reminder document number is updated with the open entry.

You can use the reminder document number in the CID code. This field is used by some external EFT system.

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

Reminder printing date

Shows the printing date for the reminder and you cannot override the value.

The date is validated using the regional settings in Windows.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainDateInteger
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameRemPrDtThe database field name.
API identifierreminderPrintingDateThe API identifier used in GraphQL.
Number11011 

Reminder suggestion status

The processing chosen in Associate table decides the value.

This will simplify the review and cleaning up in the customer ledger when issuing reminders. When reminders are printed and approved, the values in this column in the Associate table is deleted.

A look-up in this field gives you the following list of possible values:
1 - Reminder next time
Set when you run the Update reminder suggestion status processing in the Associate table for all open customer entries that satisfy the criteria for being reminded.
2 - No reminder next time
Set when you run the Exempt from reminder processing in the Associate table.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainReminder suggestion statusInteger
SQL nameRemStThe database field name.
API identifierreminderSuggestionStatusThe API identifier used in GraphQL.
Number15381 

Rest cash amount

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

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

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

Rest cash amount in currency

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

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

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

Rest cash amount in EURO

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

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

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

Running total

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

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

Running total in curr.

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

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

Scan doc. no.

The ID of the scanned document.

Is used in connection with Visma Document Center.

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

Scan status

The status of the scanned document.

Is used in connection with Visma Document Center.

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

Structured element index

Reference to the relevant <Structured> element within the <PaymentLine> element in the incoming payment file.

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

Text

The text of the transaction.

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

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

Trans. status

Various transaction statuses, inherited from Voucher table.

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

Overwritten

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

Debt collector

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

Duration

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

Accounting rule

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

Per.

Per. Debit acc.
Per. Credit acc.

____

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

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

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

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

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

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

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

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

Turnover

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

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

Unit

The field is transferred from vouchers when Batch are updated.

Unit texts for different languages can be defined in the Text table. These texts has text type 16.
Note:
If you double-click or press * in this field, you can look up a Unit in the Text table.
Note:
If you double-click or press * in this field, you can look up a value in the related table.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainUnitInteger
SQL nameUnThe database field name.
API identifierunitThe API identifier used in GraphQL.
Number10541 
Table 31. Table relations
To tablePurposeFrom columnsTo columnsComments
UnitUnit
  • Unit

Updated batch no.

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

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

Note:
If you double-click or press * in this field, you can look up a value in the related table.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainBatch no.Integer
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameUpdBndNoThe database field name.
API identifierupdatedBatchNoThe API identifier used in GraphQL.
Number10950 
Table 32. Table relations
To tablePurposeFrom columnsTo columnsComments
Updated batchUpdatedBatch
  • Voucher jour. no.
  • Updated batch no.
This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others.
Updated voucherUpdatedVoucher
  • Voucher jour. no.
  • Updated batch no.
  • Updated voucher line no.
This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others.

Updated voucher line no.

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

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

Note:
If you double-click or press * in this field, you can look up a value in the related table.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainNo.Integer
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameUpdLnNoThe database field name.
API identifierupdatedVoucherLineNoThe API identifier used in GraphQL.
Number10951 
Table 33. Table relations
To tablePurposeFrom columnsTo columnsComments
Updated voucherUpdatedVoucher
  • Voucher jour. no.
  • Updated batch no.
  • Updated voucher line no.
This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others.

Value date

The value date for the voucher.

The date is validated using the regional settings in Windows.

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

VAT amount

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

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

VAT amount in currency

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

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

Visma ID

The ID of the scanned document.

Is used in connection with Visma Document Center.

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

Voucher date

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

The date is validated using the regional settings in Windows.

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

Voucher group 1

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

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

Voucher group 2

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

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

Voucher jour. no.

A unique number identifying voucher journal number.

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

Note:
If you double-click or press * in this field, you can look up a value in the related table.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainJournal no.Integer
Primary keyYesVoucher jour. no., Audit no.
SQL nameJNoThe database field name.
API identifiervoucherJournalNoThe API identifier used in GraphQL.
Number1169 
Table 34. Table relations
To tablePurposeFrom columnsTo columnsComments
Updated journalUpdateJournal
  • Voucher jour. no.
Updated batchUpdatedBatch
  • Voucher jour. no.
  • Updated batch no.
This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others.
Updated voucherUpdatedVoucher
  • Voucher jour. no.
  • Updated batch no.
  • Updated voucher line no.
This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others.
Realisation journalRealisationJournalVoucherJournalNo
  • Voucher jour. no.

Voucher no.

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

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

Voucher type

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

Note:
If you double-click or press * in this field, you can look up a value in the related table.
PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainVoucher typeInteger
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameVoTpThe database field name.
API identifiervoucherTypeThe API identifier used in GraphQL.
Number1178 
Table 35. Table relations
To tablePurposeFrom columnsTo columnsComments
Voucher typeVoucherType
  • Voucher type

W/off variance cash discount

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

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

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

Note:
The difference is only calculated for invoice entries.

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

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainAmountDecimal
SQL namePmVaAmCDThe database field name.
API identifierwriteOffVarianceCashDiscountDomesticThe API identifier used in GraphQL.
Number8612 

W/off variance cash discount %

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

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

W/off variance cash discount in currency

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

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

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

Note:
The difference is only calculated for invoice entries.

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

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

W/off variance cash discount in EURO

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

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

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

Note:
The difference is only calculated for invoice entries.

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

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainAmountDecimal
Source columnW/off variance cash discount in currencyEuro
Write AccessNoneYou are not allowed to modify the value in this field.
Memory fieldYesThe value in this field is only displayed in the program, it is not stored in the database.
API identifierwriteOffVarianceCashDiscountInEuroThe API identifier used in GraphQL.
Number8611 

W/off variance misc.

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

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainAmountDecimal
SQL namePmVaAmThe database field name.
API identifierwriteOffVarianceMiscDomesticThe API identifier used in GraphQL.
Number11052 

W/off variance misc. %

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

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

W/off variance misc. in currency

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

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainAmountDecimal
SQL namePmVaCAmThe database field name.
API identifierwriteOffVarianceMiscInCurrencyThe API identifier used in GraphQL.
Number11050 

W/off variance misc. in EURO

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

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainAmountDecimal
Source columnW/off variance misc. in currencyEuro
Write AccessNoneYou are not allowed to modify the value in this field.
Memory fieldYesThe value in this field is only displayed in the program, it is not stored in the database.
API identifierwriteOffVarianceMiscInEuroThe API identifier used in GraphQL.
Number11051 

W/off variance total

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

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

W/off variance total in currency

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

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

W/off variance total in EURO

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

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainAmountDecimal
Source columnW/off variance total in currencyEuro
Write AccessNoneYou are not allowed to modify the value in this field.
Memory fieldYesThe value in this field is only displayed in the program, it is not stored in the database.
API identifierwriteOffVarianceTotalInEuroThe API identifier used in GraphQL.
Number11048 

Web page

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

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

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

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

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

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

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

Workflow document ID

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

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

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

Write off status

The write off status.

If you have not entered any thing in the Part payment field, or in the Maximum write off amount misc. or Maximum write off % misc. fields in the Company information table, the field will be blank. Visma Business enters 1 in the field when you enter a part payment amount and 3 if the variance lies within or outside the limits in the Company information table.

You can change it from 1 to 2 if you want to write off the variance yourself if it is within acceptable limits. You can also change it from 3 to 4 if you want to write off the variance yourself if it is outside that which Visma Business suggests is acceptable.

You can also change the values back again.

In the Access group table you can specify which user/user group is to have access to change the value from 3 to 4.

A look-up in this field gives you the following list of possible values:
0 - No discrepancy
1 - Write off accepted variance
2 - No write off
3 - Difference o/s limit
4 - Write off variance o/s limit
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainWrite off statusInteger
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameWOThe database field name.
API identifierwriteOffStatusThe API identifier used in GraphQL.
Number8518 

Year

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

Note:
If you double-click or press * in this field, you can look up a value in the related table.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainYearInteger
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameAcYrThe database field name.
API identifieryearThe API identifier used in GraphQL.
Number1176 
Table 36. Table relations
To tablePurposeFrom columnsTo columnsComments
Accounting periodAccountingPeriod
  • Year
  • Period
This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others.
Customer balanceCustomerBalance
  • Cust. no.
  • Year
  • Period
This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others.

Control columns

Control columns include information about who has changed the record last and when, and which process that is currently editing the record.

Changed by provenance

The provenance for the record change.

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

0 - None

1 - UI

10 - External API

20 - GAiA

21 - AI Connect

100 - Internal service

101 - Task automation

102 - AutoInvoice download

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainProvenanceInteger
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameChPvnThe database field name.
API identifierchangedByProvenanceThe API identifier used in GraphQL.
NumberA unique column number. 

Changed by user

The name of the user that changed the record.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainUser nameText (24)
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameChUsrThe database field name.
API identifierchangedByUserThe API identifier used in GraphQL.
NumberA unique column number. 

Changed date

The date when the record was changed.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainDateInteger
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameChDtThe database field name.
API identifierchangedDateThe API identifier used in GraphQL.
NumberA unique column number. 

Changed time

The time when the record was changed.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainTimeInteger
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameChTmThe database field name.
API identifierchangedTimeThe API identifier used in GraphQL.
NumberA unique column number. 

Changed time stamp

The date and time when the record was changed.

The field is updated with the UTC time.

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

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainDate/timeDateTime
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameChTsThe database field name.
API identifierchangedTimestampThe API identifier used in GraphQL.
NumberA unique column number. 

Created by provenance

The provenance for the record creation.

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

0 - None

1 - UI

10 - External API

20 - GAiA

21 - AI Connect

100 - Internal service

101 - Task automation

102 - AutoInvoice download

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainProvenanceInteger
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameCrePvnThe database field name.
API identifiercreatedByProvenanceThe API identifier used in GraphQL.
NumberA unique column number. 

Created by user

The name of the user that created the record.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainUser nameText (24)
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameCreUsrThe database field name.
API identifiercreatedByUserThe API identifier used in GraphQL.
NumberA unique column number. 

Created date

The date when the record was created.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainDateInteger
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameCreDtThe database field name.
API identifiercreatedDateThe API identifier used in GraphQL.
NumberA unique column number. 

Created time

The time when the record was created.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainTimeInteger
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameCreTmThe database field name.
API identifiercreatedTimeThe API identifier used in GraphQL.
NumberA unique column number. 

Created time stamp

The date and time when the record was created.

The field is updated with the UTC time.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainDate/timeDateTime
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameCreTsThe database field name.
API identifiercreatedTimestampThe API identifier used in GraphQL.
NumberA unique column number. 

Edit status

The current status of the record.

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

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

1 - Inserted: The record is new.

2 - Changed: The record is changed.

3 - Deleted: The record is deleted.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainEdit statusInteger
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameLckStThe database field name.
API identifiereditStatusThe API identifier used in GraphQL.
NumberA unique column number. 

Process no

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

Note:
If you double-click or press * in this field, you can look up a value in the related table.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainProcess no.Integer
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameChPrcThe database field name.
API identifierlockedByProcessNoThe API identifier used in GraphQL.
NumberA unique column number. 
Table 37. Table relations
To table Purpose From columns To columns Comments
Active company process CompanyProcess Process no. Process no.