Supplier transaction
This table contains transactions posted on suppliers.
| Property | Value | Description |
|---|---|---|
| Database | Company | This table is in the company databases. |
| SQL name | SupTr | The table name in the database. |
| API identifier | supplierTransaction | The API identifier used in GraphQL. |
| Table no. | 61 | The table number in the data model. |
The following fields exist in this table:
Account. year/period
The accounting year and accounting period saved as one field. This value can be used by external applications, e.g. reporting tools, to avoid having to merge the two fields accounting year and accounting period.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Year/Per. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | AcYrPr | The database field name. |
| API identifier | accountingYearAndPeriod | The API identifier used in GraphQL. |
| Number | 11021 |
Accounting document no.
The accounting document no refers to Incoming accounting document table.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | No. | Integer |
| Write Access | System supervisor user | Only users who are marked as System supervisor in the User table are allowed to modify the value in this field. |
| SQL name | InAcDocNo | The database field name. |
| API identifier | incomingAccountingDocumentNo | The API identifier used in GraphQL. |
| Number | 17960 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Accounting document | IncomingAccountingDocument |
|
Active approval task no.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Approval Task no. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | AcAppTskNo | The database field name. |
| API identifier | activeApprovalTaskNo | The API identifier used in GraphQL. |
| Number | 18973 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Approval task | ApprovalTask |
|
Additional text
Any additional information entered in the voucher.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Text | Text (200) |
| SQL name | Txt2 | The database field name. |
| API identifier | additionalText | The API identifier used in GraphQL. |
| Number | 5823 |
Amount
This is taken from vouchers. The preceding sign is reversed if the transaction concerns a credit account number.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Amount | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | Am | The database field name. |
| API identifier | amountDomestic | The API identifier used in GraphQL. |
| Number | 1385 |
Amount in currency
Amount expressed in the foreign currency. The preceding sign is reversed if the transaction concerns a credit account number.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Amount | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | CurAm | The database field name. |
| API identifier | amountInCurrency | The API identifier used in GraphQL. |
| Number | 1383 |
Amount in currency 2
Amount expressed in the currency2. The preceding sign is reversed if the transaction concerns a credit account number.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | CurAm2 | The database field name. |
| API identifier | amountInCurrency2 | The API identifier used in GraphQL. |
| Number | 14312 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Source column | Amount in currency | Euro |
| Write Access | None | You are not allowed to modify the value in this field. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | amountInEuro | The API identifier used in GraphQL. |
| Number | 7740 |
Approval token
Token for payment pre-approved in Visma.net AutoPay.
The transaction has been approved for payment in Visma.net Approval. When this token follows the payment, approval of the payment in Visma.net AutoPay should not be required.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Approval token | Text (40) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | ApTk | The database field name. |
| API identifier | approvalToken | The API identifier used in GraphQL. |
| Number | 18559 |
Approval workflow handle
Reference to a workflow in Visma.net Approval.
Used in Visma.net AutoPay for viewing of invoices.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Approval workflow handle | Text (36) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | ApWfH | The database field name. |
| API identifier | approvalWorkflowHandle | The API identifier used in GraphQL. |
| Number | 18816 |
Att. voucher no.
Set equal to the Voucher no. field in the authorisation voucher line. It is assumed that the Voucher no. field for the entry is equal to Previous voucher no. in the voucher line.
See also: Authorisation
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Voucher no. | Integer |
| SQL name | AttVoNo | The database field name. |
| API identifier | attestationVoucherNo | The API identifier used in GraphQL. |
| Number | 6462 |
Audit no.
Part of the records unique identification together with the Voucher jour. no.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Audit no. | Integer |
| Primary key | Yes | Voucher jour. no., Audit no. |
| SQL name | EntNo | The database field name. |
| API identifier | auditNo | The API identifier used in GraphQL. |
| Number | 1371 |
Auth. date 1
Up to two authorisation dates can be entered. The fields are information fields only, and can be used for selection.
The fields can for example be used in connection with electronic funds transfer. In some companies, incoming invoices must be authorised by several people, for example invoices that are to be distributed between several organisational units. Business NXT sets the Auth. date 1 field to the current date when entries are authorised. If you delete the field in the Open supplier entry table, the transaction status for the general ledger transaction that it has been authorised is withdrawn.
The date is validated using the regional settings in Windows.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Date | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | AttDt1 | The database field name. |
| API identifier | authorisationDate1 | The API identifier used in GraphQL. |
| Number | 1399 |
Auth. date 2
Up to two authorisation dates can be entered. The fields are information fields only, and can be used for selection.
The fields can for example be used in connection with electronic funds transfer. In some companies, incoming invoices must be authorised by several people, for example invoices that are to be distributed between several organisational units. Business NXT sets the Auth. date 1 field to the current date when entries are authorised. If you delete the field in the Open supplier entry table, the transaction status for the general ledger transaction that it has been authorised is withdrawn.
The date is validated using the regional settings in Windows.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Date | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | AttDt2 | The database field name. |
| API identifier | authorisationDate2 | The API identifier used in GraphQL. |
| Number | 1400 |
Auth. responsible
You can make an entry in this field when you enter vouchers, or in the Open supplier entry table. If an incoming invoice is to be authorised, the employee number of the authorising official is entered here.
The Empl. no. is a unique number identifying one specific Employee.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Empl. no. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | Att | The database field name. |
| API identifier | approvalOfficial | The API identifier used in GraphQL. |
| Number | 1398 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Associate | ApprovalOfficial |
|
Balances not updated
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Boolean | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | BalUpd | The database field name. |
| API identifier | balancesNotUpdatedYet | The API identifier used in GraphQL. |
| Number | 19696 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Bank account | Text (35) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | BankG | The database field name. |
| API identifier | bankAccount | The API identifier used in GraphQL. |
| Number | 5824 |
Bank account line no.
The recipient's bank account can here be overridden by other entered bank accounts.
In this way, the outlay retrieves data from a bank account other than the default bank account.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | No. | Integer |
| SQL name | BankAcLn | The database field name. |
| API identifier | bankAccountLineNo | The API identifier used in GraphQL. |
| Number | 11454 |
Bank no.
The number of the bank.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Bank no. | Integer |
| SQL name | BankCon | The database field name. |
| API identifier | bankNo | The API identifier used in GraphQL. |
| Number | 11453 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Bank | Bank |
|
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
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | CshAm | The database field name. |
| API identifier | cashAmountDomestic | The API identifier used in GraphQL. |
| Number | 4968 |
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
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | CshCurAm | The database field name. |
| API identifier | cashAmountInCurrency | The API identifier used in GraphQL. |
| Number | 4967 |
Cash amount in EURO
Comes from vouchers or is calculated on the basis of the Payment terms.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Source column | Cash amount in currency | Euro |
| Write Access | None | You are not allowed to modify the value in this field. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | cashAmountInEuro | The API identifier used in GraphQL. |
| Number | 7749 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Date | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | CshDueDt | The database field name. |
| API identifier | cashDueDate | The API identifier used in GraphQL. |
| Number | 4966 |
CID code
Code used for electronic funds transfer.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | CID code | Text (30) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | CID | The database field name. |
| API identifier | cid | The API identifier used in GraphQL. |
| Number | 1397 |
Control status
Can be used by the user to give the record a freely definable status, for selecting during reporting / analysis routines.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Control status/Accounting trans. | Integer |
| SQL name | Ctrl | The database field name. |
| API identifier | controlStatus | The API identifier used in GraphQL. |
| Number | 3546 |
Country no.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Country no. | Integer |
| SQL name | Ctry | The database field name. |
| API identifier | countryNo | The API identifier used in GraphQL. |
| Number | 17532 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Country | Country |
|
Credit
Defines that the amount is < 0.
The field can be used for selection of credit amounts. Eg for reporting and analysis purposes
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Boolean | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | Cr | The database field name. |
| API identifier | credit | The API identifier used in GraphQL. |
| Number | 4813 |
Credit amount
The absolute value of the Amount The field is updated only if the Amount is negative.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Source column | Amount | Credit |
| Write Access | None | You are not allowed to modify the value in this field. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | creditAmountDomestic | The API identifier used in GraphQL. |
| Number | 4634 |
Credit amount in currency
The absolute value of the Amount in currency. The field is updated only if the Amount in currency is negative.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Source column | Amount in currency | Credit |
| Write Access | None | You are not allowed to modify the value in this field. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | creditAmountInCurrency | The API identifier used in GraphQL. |
| Number | 4630 |
Credit amount in EURO
The absolute value of the Amount in EURO. The field is updated only if the Amount in EURO is negative.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Source column | Credit amount in currency | Euro |
| Write Access | None | You are not allowed to modify the value in this field. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | creditAmountInEuro | The API identifier used in GraphQL. |
| Number | 7742 |
Credit outstanding amount
The absolute value of the Outstanding amount field. The field is updated only if the Outstanding amount is negative.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Source column | Outstanding amount | Credit |
| Write Access | None | You are not allowed to modify the value in this field. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | creditOutstandingAmountDomestic | The API identifier used in GraphQL. |
| Number | 4636 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Source column | Outstanding amount in currency | Credit |
| Write Access | None | You are not allowed to modify the value in this field. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | creditOutstandingAmountInCurrency | The API identifier used in GraphQL. |
| Number | 4632 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Source column | Credit outstanding amount in currency | Euro |
| Write Access | None | You are not allowed to modify the value in this field. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | creditOutstandingAmountInEuro | The API identifier used in GraphQL. |
| Number | 7745 |
Credit quantity
The absolute value of the Quantity field. The field is updated only if the Amount field is negative.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Quantity | Decimal |
| Source column | Quantity | Credit |
| Write Access | None | You are not allowed to modify the value in this field. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | creditQuantity | The API identifier used in GraphQL. |
| Number | 4640 |
Credited amount
The field is not in use.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | CNAm | The database field name. |
| API identifier | creditedAmountDomestic | The API identifier used in GraphQL. |
| Number | 8473 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Doc. no. | Text (40) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | AgRef | The database field name. |
| API identifier | crossReference | The API identifier used in GraphQL. |
| Number | 1392 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Account no. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | AgAcNo | The database field name. |
| API identifier | crossAccountNo | The API identifier used in GraphQL. |
| Number | 4367 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Associate | CrossCustomer |
| ||
| Associate | CrossSupplier |
| ||
| General ledger account | CrossGeneralLedgerAccount |
| ||
| Capital asset | CrossCapitalAsset |
|
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.
- 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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Account type | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | AgAcCl | The database field name. |
| API identifier | crossAccountType | The API identifier used in GraphQL. |
| Number | 4366 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| SQL name | CurCAm | The database field name. |
| API identifier | currencyCorrectionAmount | The API identifier used in GraphQL. |
| Number | 11926 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Date | Integer |
| SQL name | CurCDt | The database field name. |
| API identifier | currencyCorrectionDate | The API identifier used in GraphQL. |
| Number | 11928 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Exchange rate | Decimal |
| SQL name | CurCExRt | The database field name. |
| API identifier | currencyCorrectionExchangeRate | The API identifier used in GraphQL. |
| Number | 11925 |
Curr. corr. run no.
A unique number identifying the last run of the Currency correction processing.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | No. | Integer |
| SQL name | CurCRNo | The database field name. |
| API identifier | currencyCorrectionRunNo | The API identifier used in GraphQL. |
| Number | 11929 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Currency no. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | Cur | The database field name. |
| API identifier | currencyNo | The API identifier used in GraphQL. |
| Number | 1381 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Currency | Currency |
|
Currency no. 2
The records currency no 2 number, which is inherited from the voucher.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Currency no. | Integer |
| SQL name | Cur2 | The database field name. |
| API identifier | currencyNo2 | The API identifier used in GraphQL. |
| Number | 14310 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Currency | Currency2 |
|
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Date | Integer |
| SQL name | Dt1 | The database field name. |
| API identifier | date1 | The API identifier used in GraphQL. |
| Number | 12775 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Date | Integer |
| SQL name | Dt2 | The database field name. |
| API identifier | date2 | The API identifier used in GraphQL. |
| Number | 12776 |
Debit amount
The value of the Amount field. The field is updated only if the Amount is positive.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Source column | Amount | Debit |
| Write Access | None | You are not allowed to modify the value in this field. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | debitAmountDomestic | The API identifier used in GraphQL. |
| Number | 4633 |
Debit amount in currency
The value of the Amount in currency. The field is updated only if the Amount in currency is positive.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Source column | Amount in currency | Debit |
| Write Access | None | You are not allowed to modify the value in this field. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | debitAmountInCurrency | The API identifier used in GraphQL. |
| Number | 4629 |
Debit amount in EURO
The value of the Amount in EURO. The field is updated only if the Amount in EURO is positive.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Source column | Debit amount in currency | Euro |
| Write Access | None | You are not allowed to modify the value in this field. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | debitAmountInEuro | The API identifier used in GraphQL. |
| Number | 7741 |
Debit outstanding amount
The value of the Outstanding amount field. The field is updated only if the Outstanding amount is positive.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Source column | Outstanding amount | Debit |
| Write Access | None | You are not allowed to modify the value in this field. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | debitOutstandingAmountDomestic | The API identifier used in GraphQL. |
| Number | 4635 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Source column | Outstanding amount in currency | Debit |
| Write Access | None | You are not allowed to modify the value in this field. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | debitOutstandingAmountInCurrency | The API identifier used in GraphQL. |
| Number | 4631 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Source column | Debit outstanding amount in currency | Euro |
| Write Access | None | You are not allowed to modify the value in this field. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | debitOutstandingAmountInEuro | The API identifier used in GraphQL. |
| Number | 7744 |
Debit quantity
The value of the Quantity field. The field is updated only if the Amount field is positive.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Quantity | Decimal |
| Source column | Quantity | Debit |
| Write Access | None | You are not allowed to modify the value in this field. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | debitQuantity | The API identifier used in GraphQL. |
| Number | 4639 |
Deduct currency no.
The currency number you want to use for the payment.
The currency number you want Business NXT to use for the payment if it diverts from the suppliers standard currency.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Currency no. | Integer |
| SQL name | PmtCur | The database field name. |
| API identifier | deductCurrencyNo | The API identifier used in GraphQL. |
| Number | 11455 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Currency | ChargeDebitCurrency |
|
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Associate no. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | DelActNo | The database field name. |
| API identifier | deliveryAssociateNo | The API identifier used in GraphQL. |
| Number | 8925 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Associate | DeliveryAssociate |
|
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Date | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | DueDt | The database field name. |
| API identifier | dueDate | The API identifier used in GraphQL. |
| Number | 1387 |
EFT bank fee code
Used in connection with electronic funds transfer.
The values are included on open supplier entries and supplier transactions.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | EFT bank fee | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | EFT2 | The database field name. |
| API identifier | eftBankFeeCode | The API identifier used in GraphQL. |
| Number | 6636 |
EFT currency code
Used in connection with electronic funds transfer.
The values are included on open supplier entries and supplier transactions.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | EFT Currency code | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | EFT1 | The database field name. |
| API identifier | eftCurrencyCode | The API identifier used in GraphQL. |
| Number | 6635 |
EFT decl. code
Used in connection with electronic funds transfer.
For payment abroad, this field is used to enter the declaration code in accordance with national rules. You define valid values and related texts in the Declaration code table. The values are included on open supplier entries and supplier transactions.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | EFT declaration code | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | EFT3 | The database field name. |
| API identifier | eftDeclarationCode | The API identifier used in GraphQL. |
| Number | 6637 |
EFT form type
Used in connection with electronic funds transfer. (Danish formats only.)
- 1 = giro transfer with notification without payment ID
- 4 = giro transfer without notification with payment ID
- 15 = giro transfer with notification and payment ID
- 71 = money order without notification with payment ID
- 73 = money order with notification without payment ID
- 75 = money order with notification and payment ID
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | EFT form type | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | EftFrmTp | The database field name. |
| API identifier | eftFormType | The API identifier used in GraphQL. |
| Number | 15464 |
EFT paym. method
Used in connection with electronic funds transfer.
The values are included on open supplier entries and supplier transactions.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | EFT payment method | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | EFT4 | The database field name. |
| API identifier | eftPaymentMethod | The API identifier used in GraphQL. |
| Number | 6638 |
Error message
Any errors detected during a batch update.
If several errors are detected, they are listed with a comma separating them.
- 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
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Error message | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | Err | The database field name. |
| API identifier | errorMessage | The API identifier used in GraphQL. |
| Number | 1411 |
Estimated pay date
The date on which you intend an invoice to be paid. Business NXT initially sets the field equal to the cash due date or the due date in the invoice.
This date is used as basis for transactions to be picked when processing Create payment suggestion in table Open supplier entry is run.
You can automatically have the estimated payment date set to a workday in the voucher line before update, if the calculated payment date is a Saturday for example. You can thus have payment-free days. To make use of this, proceed as follows:
- Select the Move payment to weekday column in the Voucher type table.
- Select the days which are to be payment free in the Days without payment field in the Company information table. You should also choose whether you want to move the payment date to before or after the payment free days.
- Enter incoming invoices.
The date is validated using the regional settings in Windows.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Date | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | EstPayDt | The database field name. |
| API identifier | estimatedPayDate | The API identifier used in GraphQL. |
| Number | 1395 |
Exchange rate
The exchange rate for the currency.
Is updated from the Voucher table.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Exchange rate | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | ExRt | The database field name. |
| API identifier | exchangeRate | The API identifier used in GraphQL. |
| Number | 1382 |
Exchange rate 2
The exchange rate for currency 2.
Is updated from the Voucher table.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Exchange rate | Decimal |
| SQL name | ExRt2 | The database field name. |
| API identifier | exchangeRate2 | The API identifier used in GraphQL. |
| Number | 14311 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | String of length 20 | Text (20) |
| SQL name | ExtRef1 | The database field name. |
| API identifier | externalReference1 | The API identifier used in GraphQL. |
| Number | 12773 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | String of length 20 | Text (20) |
| SQL name | ExtRef2 | The database field name. |
| API identifier | externalReference2 | The API identifier used in GraphQL. |
| Number | 12774 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | String of length 20 | Text (20) |
| SQL name | ExtRef3 | The database field name. |
| API identifier | externalReference3 | The API identifier used in GraphQL. |
| Number | 12797 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| SQL name | FixAm | The database field name. |
| API identifier | fixedAmountDomestic | The API identifier used in GraphQL. |
| Number | 6247 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| SQL name | FixCurAm | The database field name. |
| API identifier | fixedAmountInCurrency | The API identifier used in GraphQL. |
| Number | 6246 |
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
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Source column | Fixed amount in currency | Euro |
| Write Access | None | You are not allowed to modify the value in this field. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | fixedAmountInEuro | The API identifier used in GraphQL. |
| Number | 7751 |
Free 1
Additional numeric information about the transaction.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Quantity | Decimal |
| SQL name | Free1 | The database field name. |
| API identifier | free1 | The API identifier used in GraphQL. |
| Number | 9157 |
Free 2
Additional numeric information about the transaction.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Quantity | Decimal |
| SQL name | Free2 | The database field name. |
| API identifier | free2 | The API identifier used in GraphQL. |
| Number | 9158 |
Free 3
Additional numeric information about the transaction.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Quantity | Decimal |
| SQL name | Free3 | The database field name. |
| API identifier | free3 | The API identifier used in GraphQL. |
| Number | 9159 |
Free 4
Additional numeric information about the transaction.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Quantity | Decimal |
| SQL name | Free4 | The database field name. |
| API identifier | free4 | The API identifier used in GraphQL. |
| Number | 9160 |
Giro no. check sum
When you use a bank giro number, Business NXT can check, via BIG, that the cheque sum stated agrees with the giro number on the same line.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | No. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | GiroChSm | The database field name. |
| API identifier | giroNoCheckSum | The API identifier used in GraphQL. |
| Number | 10497 |
GL account
The General ledger account in which the transaction has been accumulated.
- The Associate table for the specific associate.
- The Account no. series table.
- The Company information table.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Account no. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | GenAcNo | The database field name. |
| API identifier | generalLedgerAccountNo | The API identifier used in GraphQL. |
| Number | 1410 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| General ledger account | GeneralLedgerAccount |
|
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | invoiceAmountInCurrency | The API identifier used in GraphQL. |
| Number | 4490 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Doc. no. | Text (40) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | InvoNo | The database field name. |
| API identifier | invoiceNo | The API identifier used in GraphQL. |
| Number | 1389 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Product transaction | ProductTransaction |
| 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 compression | ProductTransaction2 |
| 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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| SQL name | LastCAm | The database field name. |
| API identifier | lastCurrencyCorrectionAmount | The API identifier used in GraphQL. |
| Number | 11965 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Memo file name | Text (260) |
| SQL name | NoteNm | The database field name. |
| API identifier | memoFileName | The API identifier used in GraphQL. |
| Number | 4368 |
Memo no.
Link to the memo for the entry.
The actual memo is stored in the Memo table.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Memo no. | Integer |
| SQL name | MemoNo | The database field name. |
| API identifier | memoNo | The API identifier used in GraphQL. |
| Number | 19210 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Memo | Memo |
|
Order no.
Is updated from the Voucher.
The number of the Order from which the transaction has its origin.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Order no. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | OrdNo | The database field name. |
| API identifier | orderNo | The API identifier used in GraphQL. |
| Number | 3366 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Order | Order |
|
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Organisational unit no. | Integer |
| SQL name | R1 | The database field name. |
| API identifier | orgUnit1 | The API identifier used in GraphQL. |
| Number | 1402 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 1 | OrgUnit1 |
|
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Organisational unit no. | Integer |
| SQL name | R2 | The database field name. |
| API identifier | orgUnit2 | The API identifier used in GraphQL. |
| Number | 1403 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 2 | OrgUnit2 |
|
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Organisational unit no. | Integer |
| SQL name | R3 | The database field name. |
| API identifier | orgUnit3 | The API identifier used in GraphQL. |
| Number | 1404 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 3 | OrgUnit3 |
|
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Organisational unit no. | Integer |
| SQL name | R4 | The database field name. |
| API identifier | orgUnit4 | The API identifier used in GraphQL. |
| Number | 1405 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 4 | OrgUnit4 |
|
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Organisational unit no. | Integer |
| SQL name | R5 | The database field name. |
| API identifier | orgUnit5 | The API identifier used in GraphQL. |
| Number | 1406 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 5 | OrgUnit5 |
|
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Organisational unit no. | Integer |
| SQL name | R6 | The database field name. |
| API identifier | orgUnit6 | The API identifier used in GraphQL. |
| Number | 1407 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 6 | OrgUnit6 |
|
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Long alphanumeric organisational unit no. | Text (40) |
| SQL name | R7 | The database field name. |
| API identifier | orgUnit7 | The API identifier used in GraphQL. |
| Number | 9432 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 7 | OrgUnit7 |
|
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Short alphanumeric organisational unit no. | Text (10) |
| SQL name | R8 | The database field name. |
| API identifier | orgUnit8 | The API identifier used in GraphQL. |
| Number | 9433 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 8 | OrgUnit8 |
|
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Short alphanumeric organisational unit no. | Text (10) |
| SQL name | R9 | The database field name. |
| API identifier | orgUnit9 | The API identifier used in GraphQL. |
| Number | 9434 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 9 | OrgUnit9 |
|
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Short alphanumeric organisational unit no. | Text (10) |
| SQL name | R10 | The database field name. |
| API identifier | orgUnit10 | The API identifier used in GraphQL. |
| Number | 9435 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 10 | OrgUnit10 |
|
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Short alphanumeric organisational unit no. | Text (10) |
| SQL name | R11 | The database field name. |
| API identifier | orgUnit11 | The API identifier used in GraphQL. |
| Number | 9436 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 11 | OrgUnit11 |
|
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Short alphanumeric organisational unit no. | Text (10) |
| SQL name | R12 | The database field name. |
| API identifier | orgUnit12 | The API identifier used in GraphQL. |
| Number | 9437 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 12 | OrgUnit12 |
|
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).
- 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
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Origin | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | SrcTp | The database field name. |
| API identifier | origin | The API identifier used in GraphQL. |
| Number | 1408 |
Original run no.
The Order journal number from which the transaction origin.
The number can be used to trace the transactions generated from orders.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Journal no. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | SrcJNo | The database field name. |
| API identifier | originalRunNo | The API identifier used in GraphQL. |
| Number | 1409 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Order journal | OrderJournal |
|
Original voucher no.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Voucher no. | Integer |
| SQL name | OrVoNo | The database field name. |
| API identifier | originalVoucherNo | The API identifier used in GraphQL. |
| Number | 18624 |
Outstanding amount
The outstanding amount in standard currency that remains before the invoice is fully matched.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Amount | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | RAm | The database field name. |
| API identifier | outstandingAmountDomestic | The API identifier used in GraphQL. |
| Number | 1386 |
Outstanding amount in currency
The outstanding amount in currency that remains before the invoice is fully matched.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Amount | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | RCurAm | The database field name. |
| API identifier | outstandingAmountInCurrency | The API identifier used in GraphQL. |
| Number | 1384 |
Outstanding amount in EURO
The outstanding amount in currency, converted into EURO, that remains before the invoice is fully matched.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Source column | Outstanding amount in currency | Euro |
| Write Access | None | You are not allowed to modify the value in this field. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | outstandingAmountInEuro | The API identifier used in GraphQL. |
| Number | 7743 |
Paid
Shows a "x", if a payment suggestion was created.
The field can be reset to not paid if the entry has been processed to a payment suggestion by mistake. You can then delete the payment suggestion in the payment lines table and run the payment suggestion processing again.
The field is set as soon as you have approved the payment suggestion. This means as soon as you have pressed OK in the dialog box which appears when you run Create payment suggestion. If you run Create payment suggestion for a part payment, the field will be left blank. If the part payment is equal to the amount that you are to pay, the field is not left blank.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Boolean | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | ExcRmt | The database field name. |
| API identifier | remitted | The API identifier used in GraphQL. |
| Number | 1396 |
Paid curr. amount
Paid amount in the current currency.
Accumulates remitted part payments.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| SQL name | RemCAm | The database field name. |
| API identifier | remittedCurrencyAmount | The API identifier used in GraphQL. |
| Number | 12256 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Date | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | PayedDt | The database field name. |
| API identifier | paidLast | The API identifier used in GraphQL. |
| Number | 1388 |
Paid status
Indicates whether the entry is fully open, partially paid, paid late or fully processed.
- 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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Paid status | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | St | The database field name. |
| API identifier | paidStatus | The API identifier used in GraphQL. |
| Number | 1393 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | PrtAm | The database field name. |
| API identifier | partPaymentDomestic | The API identifier used in GraphQL. |
| Number | 4970 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | PrtCurAm | The database field name. |
| API identifier | partPaymentInCurrency | The API identifier used in GraphQL. |
| Number | 4969 |
Part payment in EURO
This field is derived from the Part payment in currency field.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Source column | Part payment in currency | Euro |
| Write Access | None | You are not allowed to modify the value in this field. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | partPaymentInEuro | The API identifier used in GraphQL. |
| Number | 7750 |
Paym. run no.
Updated when you approve printouts in connection with payments.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | No. | Integer |
| SQL name | RmtRnNo | The database field name. |
| API identifier | remittanceRunNo | The API identifier used in GraphQL. |
| Number | 1401 |
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).
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Payment method | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | PmtMt | The database field name. |
| API identifier | paymentMethod | The API identifier used in GraphQL. |
| Number | 10546 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Payment method | PaymentMethod |
|
Payment supplier no.
Supplier used as the payee when creating payment suggestions.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Sup. no. | Integer |
| SQL name | RmtSup | The database field name. |
| API identifier | remittanceSupplierNo | The API identifier used in GraphQL. |
| Number | 17875 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Associate | RemittanceSupplier |
|
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Payment no. | Integer |
| SQL name | BPmtNo | The database field name. |
| API identifier | paymentNo | The API identifier used in GraphQL. |
| Number | 6964 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Payment | Payment |
|
Payment terms
Is updated from vouchers. If it is not filled in on vouchers, it is fetched from the Associate table.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Payment terms | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | PmtTrm | The database field name. |
| API identifier | paymentTerms | The API identifier used in GraphQL. |
| Number | 4965 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Payment term | PaymentTerms |
|
Period
Shows the accounting period to which the transaction was posted.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Period | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | AcPr | The database field name. |
| API identifier | period | The API identifier used in GraphQL. |
| Number | 1378 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Accounting period | AccountingPeriod |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. | |
| Supplier balance | SupplierBalance |
| 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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | No. | Integer |
| SQL name | PrBt | The database field name. |
| API identifier | periodBatchNo | The API identifier used in GraphQL. |
| Number | 10548 |
Picture file name
the file name for the scanned image file for the vouchers.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Picture file name | Text (260) |
| SQL name | PictNo | The database field name. |
| API identifier | pictureFileName | The API identifier used in GraphQL. |
| Number | 9155 |
Pre-approved
Pre-approved for payment in Visma.net AutoPay.
The transaction has been approved for payment in Visma.net Approval. Approval of the payment in Visma.net AutoPay should not be required. This value can be removed, but not be set.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Boolean | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | preapproved | The API identifier used in GraphQL. |
| Number | 18571 |
Previous voucher no.
The original voucher number when you reverse transactions.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Voucher no. | Integer |
| SQL name | PrevVoNo | The database field name. |
| API identifier | previousVoucherNo | The API identifier used in GraphQL. |
| Number | 6256 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Payment priority | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | Pri | The database field name. |
| API identifier | priority | The API identifier used in GraphQL. |
| Number | 1394 |
Purchases
Set equal to the Amount field if you have used a voucher type for which Affects turn./purch. has been checked.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | Purc | The database field name. |
| API identifier | purchases | The API identifier used in GraphQL. |
| Number | 1390 |
Quantity
Comes from vouchers and has the same sign as the Amount field.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Quantity | Decimal |
| SQL name | Qty | The database field name. |
| API identifier | quantity | The API identifier used in GraphQL. |
| Number | 2274 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Doc. no. | Text (40) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | Ref | The database field name. |
| API identifier | reference | The API identifier used in GraphQL. |
| Number | 1391 |
Rate comp. with domestic curr.
Shows the exchange rate against domestic currency on the payment line.
In use only on records concerning payments and used in those cases when the payment exchange rate differs from the exchange rate on the (paid) invoice.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Exchange rate | Decimal |
| SQL name | TrfExRt | The database field name. |
| API identifier | exchangeRateAgainstDomesticCurrency | The API identifier used in GraphQL. |
| Number | 11456 |
Rest cash amount
The outstanding cash amount in standard currency that remains before the invoice is fully matched.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | RCshAm | The database field name. |
| API identifier | outstandingCashAmountDomestic | The API identifier used in GraphQL. |
| Number | 7864 |
Rest cash amount in currency
The outstanding cash amount in the current foreign currency that remains before the invoice is fully matched.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | CRCshAm | The database field name. |
| API identifier | outstandingCashAmountInCurrency | The API identifier used in GraphQL. |
| Number | 7862 |
Rest cash amount in EURO
The outstanding amount in the current currency converted into EUROS that remains before the invoice is fully matched.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Source column | Rest cash amount in currency | Euro |
| Write Access | None | You are not allowed to modify the value in this field. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | outstandingCashAmountInEuro | The API identifier used in GraphQL. |
| Number | 7863 |
Running total
Use this field for account statements to show a running total in the printout.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | runningTotalDomestic | The API identifier used in GraphQL. |
| Number | 11005 |
Running total in curr.
Use this field for account statements to show a running total in the printout.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | runningTotalInCurrency | The API identifier used in GraphQL. |
| Number | 12235 |
Scan doc. no.
The ID of the scanned document.
Is used in connection with Visma Document Center.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | No. | Integer |
| SQL name | PLDNo | The database field name. |
| API identifier | scanDocumentNo | The API identifier used in GraphQL. |
| Number | 11172 |
Scan status
The status of the scanned document.
Is used in connection with Visma Document Center.
- 1 - Scanned document
- 2 - Document on flow
- 4 - Document finished
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Scan status | Integer |
| SQL name | PLDFlow | The database field name. |
| API identifier | scanStatus | The API identifier used in GraphQL. |
| Number | 11173 |
Sup. no.
Shows the supplier number to which the transaction applies.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Sup. no. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | SupNo | The database field name. |
| API identifier | supplierNo | The API identifier used in GraphQL. |
| Number | 1372 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Associate | Supplier |
| ||
| Supplier balance | SupplierBalance |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. | |
| Product transaction | ProductTransaction |
| 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 compression | ProductTransaction2 |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. |
Text
The text of the transaction.
For automatically generated transactions Visma Business takes the Voucher type from the Voucher series for automatically generated transactions and the text field is filled in with the default text for this Voucher type.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Text | Text (200) |
| SQL name | Txt | The database field name. |
| API identifier | text | The API identifier used in GraphQL. |
| Number | 1380 |
Trans. status
Various transaction statuses, inherited from Voucher table.
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
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Trans. status | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | TransSt | The database field name. |
| API identifier | transactionStatus | The API identifier used in GraphQL. |
| Number | 6630 |
Unit
The field is transferred from vouchers when Batch are updated.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Unit | Integer |
| SQL name | Un | The database field name. |
| API identifier | unit | The API identifier used in GraphQL. |
| Number | 10547 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Unit | 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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Batch no. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | UpdBndNo | The database field name. |
| API identifier | updatedBatchNo | The API identifier used in GraphQL. |
| Number | 10954 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Updated batch | UpdatedBatch |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. | |
| Updated voucher | UpdatedVoucher |
| 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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | No. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | UpdLnNo | The database field name. |
| API identifier | updatedVoucherLineNo | The API identifier used in GraphQL. |
| Number | 10955 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Updated voucher | UpdatedVoucher |
| 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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Date | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | ValDt | The database field name. |
| API identifier | valueDate | The API identifier used in GraphQL. |
| Number | 1376 |
VAT amount
Is inherited from the Voucher line. If not entered on the voucher line, it will be inherited from the Batch.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | VatAm | The database field name. |
| API identifier | vatAmountDomestic | The API identifier used in GraphQL. |
| Number | 6673 |
VAT amount in currency
Is inherited from the Voucher line. If not entered on the voucher line, it will be inherited from the Batch.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | CurVatAm | The database field name. |
| API identifier | vatAmountInCurrency | The API identifier used in GraphQL. |
| Number | 18149 |
Visma ID
The ID of the scanned document.
Is used in connection with Visma Document Center.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | No. | Integer |
| SQL name | WfId | The database field name. |
| API identifier | vismaId | The API identifier used in GraphQL. |
| Number | 11171 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Date | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | VoDt | The database field name. |
| API identifier | voucherDate | The API identifier used in GraphQL. |
| Number | 1375 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Voucher group 1 | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | VoGr1 | The database field name. |
| API identifier | voucherGroup1 | The API identifier used in GraphQL. |
| Number | 6164 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Voucher group 2 | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | VoGr2 | The database field name. |
| API identifier | voucherGroup2 | The API identifier used in GraphQL. |
| Number | 6165 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Journal no. | Integer |
| Primary key | Yes | Voucher jour. no., Audit no. |
| SQL name | JNo | The database field name. |
| API identifier | voucherJournalNo | The API identifier used in GraphQL. |
| Number | 1370 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Updated journal | UpdateJournal |
| ||
| Updated batch | UpdatedBatch |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. | |
| Updated voucher | UpdatedVoucher |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. | |
| Realisation journal | RealisationJournalVoucherJournalNo |
|
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Voucher no. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | VoNo | The database field name. |
| API identifier | voucherNo | The API identifier used in GraphQL. |
| Number | 1374 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Voucher type | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | VoTp | The database field name. |
| API identifier | voucherType | The API identifier used in GraphQL. |
| Number | 1379 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Voucher type | VoucherType |
|
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.
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | writeOffVarianceCashDiscountDomestic | The API identifier used in GraphQL. |
| Number | 8624 |
W/off variance cash discount %
Shows the difference in the default currency as a percentage of the original amount in the default currency.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Percent | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | writeOffVarianceCashDiscountPercent | The API identifier used in GraphQL. |
| Number | 8625 |
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.
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | writeOffVarianceCashDiscountInCurrency | The API identifier used in GraphQL. |
| Number | 8622 |
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.
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Source column | W/off variance cash discount in currency | Euro |
| Write Access | None | You are not allowed to modify the value in this field. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | writeOffVarianceCashDiscountInEuro | The API identifier used in GraphQL. |
| Number | 8623 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Web page | Text (260) |
| SQL name | WebPg | The database field name. |
| API identifier | webPage | The API identifier used in GraphQL. |
| Number | 9156 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Workflow document ID | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | WfDocId | The database field name. |
| API identifier | workflowDocumentId | The API identifier used in GraphQL. |
| Number | 18974 |
Year
The relevant accounting year for the transactions. The year is deducted from the value date.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Year | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | AcYr | The database field name. |
| API identifier | year | The API identifier used in GraphQL. |
| Number | 1377 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Accounting period | AccountingPeriod |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. | |
| Supplier balance | SupplierBalance |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. |
Control columns
Control columns include information about who has changed the record last and when, and which process that is currently editing the record.
Changed by provenance
The provenance for the record change.
A look-up in this field gives you the following list of possible values:
0 - None
1 - UI
10 - External API
20 - GAiA
21 - AI Connect
100 - Internal service
101 - Task automation
102 - AutoInvoice download
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Provenance | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | ChPvn | The database field name. |
| API identifier | changedByProvenance | The API identifier used in GraphQL. |
| Number | A unique column number. |
Changed by user
The name of the user that changed the record.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | User name | Text (24) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | ChUsr | The database field name. |
| API identifier | changedByUser | The API identifier used in GraphQL. |
| Number | A unique column number. |
Changed date
The date when the record was changed.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Date | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | ChDt | The database field name. |
| API identifier | changedDate | The API identifier used in GraphQL. |
| Number | A unique column number. |
Changed time
The time when the record was changed.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Time | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | ChTm | The database field name. |
| API identifier | changedTime | The API identifier used in GraphQL. |
| Number | A unique column number. |
Changed time stamp
The date and time when the record was changed.
The field is updated with the UTC time.
This value can be used by external systems to replicate changed data. The column is indexed.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Date/time | DateTime |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | ChTs | The database field name. |
| API identifier | changedTimestamp | The API identifier used in GraphQL. |
| Number | A unique column number. |
Created by provenance
The provenance for the record creation.
A look-up in this field gives you the following list of possible values:
0 - None
1 - UI
10 - External API
20 - GAiA
21 - AI Connect
100 - Internal service
101 - Task automation
102 - AutoInvoice download
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Provenance | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | CrePvn | The database field name. |
| API identifier | createdByProvenance | The API identifier used in GraphQL. |
| Number | A unique column number. |
Created by user
The name of the user that created the record.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | User name | Text (24) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | CreUsr | The database field name. |
| API identifier | createdByUser | The API identifier used in GraphQL. |
| Number | A unique column number. |
Created date
The date when the record was created.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Date | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | CreDt | The database field name. |
| API identifier | createdDate | The API identifier used in GraphQL. |
| Number | A unique column number. |
Created time
The time when the record was created.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Time | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | CreTm | The database field name. |
| API identifier | createdTime | The API identifier used in GraphQL. |
| Number | A unique column number. |
Created time stamp
The date and time when the record was created.
The field is updated with the UTC time.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Date/time | DateTime |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | CreTs | The database field name. |
| API identifier | createdTimestamp | The API identifier used in GraphQL. |
| Number | A unique column number. |
Edit status
The current status of the record.
A look-up in this field gives you the following list of possible values:
0 - Unchanged: The record is read, but not changed.
1 - Inserted: The record is new.
2 - Changed: The record is changed.
3 - Deleted: The record is deleted.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Edit status | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | LckSt | The database field name. |
| API identifier | editStatus | The API identifier used in GraphQL. |
| Number | A unique column number. |
Process no
The Process no. from the Active company process table which is currently using or has control of this record.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Process no. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | ChPrc | The database field name. |
| API identifier | lockedByProcessNo | The API identifier used in GraphQL. |
| Number | A unique column number. |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Active company process | CompanyProcess | Process no. | Process no. |