Accounting transaction
This table contains transactions for accounts of different account types, such as customers, suppliers, general ledger accounts and capital assets.
This table is defined as a view in the database.
| Property | Value | Description |
|---|---|---|
| Database | Company | This table is a view in the company databases. |
| View name | AllAcTr | This table is a view and only displayed in the program, it is not stored in the database. |
| API identifier | accountingTransaction | The API identifier used in GraphQL. |
| Table no. | 350 | The table number in the data model. |
The following fields exist in this table:
Acc. w/off variance %
Shows the accumulated variance in the default currency as a percentage of the original amount in the default currency.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is 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 | writeOffVariancePercent | The API identifier used in GraphQL. |
| Number | 14665 |
Acc. w/off variance amount
Acc. w/off variance amount in EURO and Acc. w/off variance amount in currency fields show how much has been written off on the entries.
Visma Business accumulates the fields for invoice entries which are matched with entries with the origination code for writing off payments
| 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 | AcDPmtV | The database field name. |
| API identifier | writeOffVarianceAmountDomestic | The API identifier used in GraphQL. |
| Number | 14666 |
Acc. w/off variance amount in currency
Acc. w/off variance amount in EURO and Acc. w/off variance amount in currency fields show how much has been written off on the entries.
Visma Business accumulates the fields for invoice entries which are matched with entries with the origination code for writing off payments
| 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 | AcCPmtV | The database field name. |
| API identifier | writeOffVarianceAmountInCurrency | The API identifier used in GraphQL. |
| Number | 14667 |
Acc. w/off variance amount in EURO
Acc. w/off variance amount in EURO and Acc. w/off variance amount in currency fields show how much has been written off on the entries.
Visma Business accumulates the fields for invoice entries which are matched with entries with the origination code for writing off payments. Acc. w/off variance amount in EURO is not in the database, but shows Acc. w/off variance amount in currency.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Amount | Decimal |
| Source column | Acc. w/off variance 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 | writeOffVarianceAmountInEuro | The API identifier used in GraphQL. |
| Number | 14676 |
Account no.
General ledger account to which the transaction applies.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is 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 | AcNo | The database field name. |
| API identifier | accountNo | The API identifier used in GraphQL. |
| Number | 14801 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Associate | SwitchCustomer |
| ||
| Associate | SwitchSupplier |
| ||
| General ledger account | SwitchGeneralLedgerAccount |
| ||
| Capital asset | SwitchCapitalAsset |
| ||
| General ledger balance | GeneralLedgerBalance |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. | |
| General ledger balance/Organisational unit 1 | GeneralLedgerBalance1 |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. | |
| General ledger balance/Organisational unit 2 | GeneralLedgerBalance2 |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. | |
| General ledger balance/Organisational unit 3 | GeneralLedgerBalance3 |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. | |
| General ledger balance/Organisational unit 4 | GeneralLedgerBalance4 |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. | |
| General ledger balance/Organisational unit 5 | GeneralLedgerBalance5 |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. | |
| General ledger balance/Organisational unit 6 | GeneralLedgerBalance6 |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. | |
| General ledger balance/Organisational unit 7 | GeneralLedgerBalance7 |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. | |
| General ledger balance/Organisational unit 8 | GeneralLedgerBalance8 |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. | |
| General ledger balance/Organisational unit 9 | GeneralLedgerBalance9 |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. | |
| General ledger balance/Organisational unit 10 | GeneralLedgerBalance10 |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. | |
| General ledger balance/Organisational unit 11 | GeneralLedgerBalance11 |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. | |
| General ledger balance/Organisational unit 12 | GeneralLedgerBalance12 |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. |
Account type
The origin of the transaction.
- 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 | Yes | This field is 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 | AcCl | The database field name. |
| API identifier | accountType | The API identifier used in GraphQL. |
| Number | 14561 |
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 | Yes | This field is 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 | 14584 |
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 | None | You are not 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 | 17963 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Accounting document | IncomingAccountingDocument |
|
Active approval task no.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is 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 | 18979 |
| 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 | Yes | This field is visible by default in the table display. |
| Domain | Text | Text (200) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | Txt2 | The database field name. |
| API identifier | additionalText | The API identifier used in GraphQL. |
| Number | 14596 |
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 | 14602 |
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 | 14605 |
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 | Yes | This field is 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 | 14615 |
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 | 18561 |
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 | 18818 |
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 | 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 | AttVoNo | The database field name. |
| API identifier | attestationVoucherNo | The API identifier used in GraphQL. |
| Number | 14721 |
Audit no.
Part of the records unique identification together with the Voucher jour. no.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Audit no. | Integer |
| Primary key | Yes | Voucher jour. no., Audit no. |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | EntNo | The database field name. |
| API identifier | auditNo | The API identifier used in GraphQL. |
| Number | 14560 |
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 | 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 | AttDt1 | The database field name. |
| API identifier | authorisationDate1 | The API identifier used in GraphQL. |
| Number | 14718 |
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 | 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 | AttDt2 | The database field name. |
| API identifier | authorisationDate2 | The API identifier used in GraphQL. |
| Number | 14719 |
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 | Yes | This field is 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 | 14720 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Associate | ApprovalOfficial |
|
AutoPay log seq. no.
Reference to the Identifier column in Visma.net AutoPay log table where the actual incoming payment file is stored.
| 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 | ApLSeqNo | The database field name. |
| API identifier | autopayLogEntryNo | The API identifier used in GraphQL. |
| Number | 19620 |
AutoPay payment reference
Reference to an incoming payment imported from Visma.net AutoPay.
Details about the payment can be seen using the View payment details processing.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | AutoPay payment reference | Text (100) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | ApPmtRef | The database field name. |
| API identifier | autopayPaymentReference | The API identifier used in GraphQL. |
| Number | 18211 |
Balances not updated
| 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 | BalUpd | The database field name. |
| API identifier | balancesNotUpdatedYet | The API identifier used in GraphQL. |
| Number | 19699 |
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 | Yes | This field is visible by default in the table display. |
| Domain | Bank account | Text (35) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | BankG | The database field name. |
| API identifier | bankAccount | The API identifier used in GraphQL. |
| Number | 14693 |
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 | Yes | This field is visible by default in the table display. |
| Domain | No. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | BankAcLn | The database field name. |
| API identifier | bankAccountLineNo | The API identifier used in GraphQL. |
| Number | 14691 |
Bank no.
The number of the bank.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Bank no. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | BankCon | The database field name. |
| API identifier | bankNo | The API identifier used in GraphQL. |
| Number | 14692 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Bank | Bank |
|
Bank reference
The bank's reference for the transaction.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Bank reference | Text (30) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | BankRef | The database field name. |
| API identifier | bankReference | The API identifier used in GraphQL. |
| Number | 18777 |
Basis
Base amount for the calculation of VAT, rounded to two decimals.
| 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 | Bas | The database field name. |
| API identifier | basisDomestic | The API identifier used in GraphQL. |
| Number | 14621 |
Calculated VAT amount
To compare with the actually posted VAT amount if this was changed before voucher update.
The field is used for VAT control, to reveal any manual changes in VAT amounts that have been made before updating.
| 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 | CalcVAm | The database field name. |
| API identifier | calculatedVatAmount | The API identifier used in GraphQL. |
| Number | 14630 |
Cap. asset no.
The capital asset number if this entered it in the voucher line during voucher entry.
The field is mainly used to track the capital asset no on General ledger transactions concerning automatically generated postings on capital asset General ledger account.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Cap. asset no. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | PropNo | The database field name. |
| API identifier | capitalAssetNo | The API identifier used in GraphQL. |
| Number | 14565 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Capital asset | CapitalAsset |
| ||
| Capital asset balance | CapitalAssetBalance |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. |
Capital asset proc.
Shows how the capital asset transaction was processed.
- 1 - Acquisition
- To be used on records concerning the main acquisition of capital assets. E.g. cars, or buildings.
- 2 - Addition
- To be used on records concerning additions. The definition of an "addition" is e.g. winter tyres for a car or marquises on a building. Additions can be given a lifetime, that differs from the main acquisition.
- 3 - Revaluation
- To be used on records meant to adjust the total value of a capital
asset. An example when a revaluation can be performed is when a very old real estate
has a much higher market value, than the book value.Note:Revaluation shall NOT be performed when a capital asset has a lower value than expected due to under-usage, in this case the lifetime, and consequently the periodic depreciations, shall be adjusted instead.Note:Revaluation of capital assets is in most countries surrounded by legal restrictions and shall be performed only after accurate consideration.
- 4 - Devaluation
- To be used on records meant to adjust the total value of a capital
asset. An example when a devaluation can be performed is when the value of a real
estate falls under the book value due to a financial crisis or another extraordinary
occurrence.Note:Devaluation shall NOT be performed when a capital asset has a higher value than expected due to over-usage, in this case the lifetime, and consequently the periodic depreciations, shall be adjusted instead.Note:Devaluation of capital assets might be surrounded by legal restrictions in your country and shall be performed only after accurate consideration.
- 5 - Sale
- To be used on records concerning sales of capital assets.
- 6 - Discarded
- To be used on records concerning discard of capital assets.
- 7 - (Not in use)
- Not in use.
- 8 - Back transfer
- Resets depreciation when capital assets are sold or discarded.
- 9 - Depreciation on investment
- 10 - Depreciation on addition
- 11 - Depreciation on revaluation
- 12 - Depreciation on devaluation
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Capital asset proc. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | PropPrc | The database field name. |
| API identifier | capitalAssetProcessing | The API identifier used in GraphQL. |
| Number | 14598 |
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 | 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 | CshAm | The database field name. |
| API identifier | cashAmountDomestic | The API identifier used in GraphQL. |
| Number | 14645 |
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 | 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 | CshCurAm | The database field name. |
| API identifier | cashAmountInCurrency | The API identifier used in GraphQL. |
| Number | 14646 |
Cash amount in EURO
Comes from vouchers or is calculated on the basis of the Payment terms.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is 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 | 14649 |
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 | 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 | CshDueDt | The database field name. |
| API identifier | cashDueDate | The API identifier used in GraphQL. |
| Number | 14644 |
CID code
Code used for electronic funds transfer.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is 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 | 14694 |
Client interest amount
The field is updated when you post client interest by running the Post interest proposal processing in the Associate table. Used for the integration with Visma Lawyer.
The amount fields for the transaction are updated with the accumulated Client interest amount plus the value in the Client interest proposal amount field.
If you have selected Convert client interest in foreign exchange to default exchange in the Bank account processing field in the Bank account table, the Client interest amount field is converted at the current exchange rate with reference to the Client interest proposal amount in currency field.
| 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 | ClIntAm | The database field name. |
| API identifier | clientInterestAmountDomestic | The API identifier used in GraphQL. |
| Number | 14750 |
Client interest amount in currency
The field is updated when you post client interest by running the Post interest proposal processing in the Associate table. Used for the integration with Visma Lawyer.
Visma Business updates the client interest amount fields for the transaction with the accumulated Client interest amount in currency plus the value in the Client interest proposal amount in currency field.
The amount is converted using the current exchange rate with reference to the currency for the transaction. If you have selected Convert client interest rates in currency to default currency in the Bank account processing field in the Bank account table, the Client interest amount field is converted at the current exchange rate with reference to the Client interest proposal amount in currency field.
| 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 | ClIntCAm | The database field name. |
| API identifier | clientInterestAmountInCurrency | The API identifier used in GraphQL. |
| Number | 14751 |
Client interest amount in EURO
Is not in the database. It is calculated on the basis of the amount field in the relevant currency. Used for the integration with Visma Lawyer.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Amount | Decimal |
| Source column | Client interest 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 | clientInterestAmountInEuro | The API identifier used in GraphQL. |
| Number | 14752 |
Client interest from date
When you post entries running the Post interest proposal processing, Visma Business updates the Client interest from date and Client interest to date fields for the transactions. This field is updated with the value from the Client interest proposal from date field. Used for the integration with Visma Lawyer.
The date is validated using the regional settings in Windows.
| 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 | ClIntFrD | The database field name. |
| API identifier | clientInterestFromDate | The API identifier used in GraphQL. |
| Number | 14748 |
Client interest proposal amount
When running the Calculate client interest processing in the Associate table, this field is updated with the correct rate from the Interest rate table. Used for the integration with Visma Lawyer.
Settings from the Bank account and Client processing fields are taken into account. The value in the field is not accumulated, but is overwritten with new values. Client interest proposal amount and Client interest proposal amount in currency are calculated using the same interest rate. When you post this, reference is made to whether it is to be processed in domestic amount or in currency amount. You can change the value in the field, and the change is taken into account when you post client interest. The field is emptied when you run the Delete interest proposal processing in the Associate table.
| 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 | ClSugAm | The database field name. |
| API identifier | clientInterestProposalAmountDomestic | The API identifier used in GraphQL. |
| Number | 14745 |
Client interest proposal amount in currency
This field is updated with the Client interest proposal amount in currency. Used for the integration with Visma Lawyer.
Client interest proposal amount in currency is calculated using the same Interest rate as Client interest rate amount. When you post this, reference is made to whether it is to be processed in domestic amount or in currency amount. You can change the value in the field, and the change is taken into account when you post client interest. The field is emptied when you run the Delete interest proposal processing in the Associate table.
| 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 | ClSugCAm | The database field name. |
| API identifier | clientInterestProposalAmountInCurrency | The API identifier used in GraphQL. |
| Number | 14746 |
Client interest proposal amount in EURO
This field is calculated on the basis of the Client interest proposal amount field. Used for the integration with Visma Lawyer.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Amount | Decimal |
| Source column | Client interest proposal 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 | clientInterestProposalAmountInEuro | The API identifier used in GraphQL. |
| Number | 14747 |
Client interest proposal from date
When running the Calculate client interest processing in the Associate table, this field is updated with the value in the Client interest to date field. Used for the integration with Visma Lawyer.
If the Client interest to date field is blank, this field is updated with the voucher date. You can change the value in the field, and the change is taken into account when you post client interest. The field is emptied when you run the Delete interest proposal processing in the Associate table.
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 | ClSugFrD | The database field name. |
| API identifier | clientInterestProposalFromDate | The API identifier used in GraphQL. |
| Number | 14743 |
Client interest proposal to date
When you run the Calculate client interest processing in the Associate table, this field is updated with the value in the To date field in the Calculate client interest dialog box. Used for the integration with Visma Lawyer.
This field is used when calculating the Client interest proposal amount. You can change the value in the field, and the change is taken into account when you post client interest. The field is emptied when you run the Delete interest proposal processing in the Associate table.
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 | ClSugToD | The database field name. |
| API identifier | clientInterestProposalToDate | The API identifier used in GraphQL. |
| Number | 14744 |
Client interest to date
When you post entries running the Post interest proposal processing, Visma Business updates the Client interest from date and Client interest to date fields for the transactions. This field is updated with the value from the Client interest proposal to date field. Used for the integration with Visma Lawyer.
The date is validated using the regional settings in Windows.
| 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 | ClIntToD | The database field name. |
| API identifier | clientInterestToDate | The API identifier used in GraphQL. |
| Number | 14749 |
Client processing
Comes from vouchers and defines whether the client processing is outlay or a client responsibility, that can be used for client interest calculation.
- 1 - Outlay
- 2 - Client responsibility 1
- 3 - Client responsibility 2
- 4 - Client responsibility 3
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Client processing | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | ClPrc | The database field name. |
| API identifier | clientProcessing | The API identifier used in GraphQL. |
| Number | 14742 |
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 | Yes | This field is visible by default in the table display. |
| Domain | Control status/Accounting trans. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | Ctrl | The database field name. |
| API identifier | controlStatus | The API identifier used in GraphQL. |
| Number | 14775 |
Cost amount
Non-deductible input VAT.
Shows the fraction of the VAT amount that is not deductible. Occurs only on transactions with a VAT code that has Cost % defined in the VAT code table. Occurs in companies with a mix of VAT-liable and non-VAT-liable activities.
| 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 | CstAm | The database field name. |
| API identifier | costAmountDomestic | The API identifier used in GraphQL. |
| Number | 14627 |
Cost %
Percentage fraction of non-deductible input VAT.
Shows the fraction of the VAT percentage that is not deductible. Occurs only on transactions with a VAT code that has Cost % defined in the VAT code table. Occurs in companies with a mix of VAT-liable and non-VAT-liable activities.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Percent | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | CstP | The database field name. |
| API identifier | costPercent | The API identifier used in GraphQL. |
| Number | 14625 |
Country no.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Country no. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | Ctry | The database field name. |
| API identifier | countryNo | The API identifier used in GraphQL. |
| Number | 17535 |
| 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 | 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 | Cr | The database field name. |
| API identifier | credit | The API identifier used in GraphQL. |
| Number | 14606 |
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 | Yes | This field is 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 | 14612 |
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 | Yes | This field is 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 | 14617 |
Credit entered amount
The amount that was originally entered on the voucher line for a credit account.
In general ledger transactions, Business NXT makes a distinction between the amount entered and the amount posted. The amount entered shows the amount as it was typed in during voucher entry, inclusive of VAT, but exclusive of any investment tax. Business NXT deducts any input or output VAT, using the result as the base amount for the taxes. The amount posted is equal to this base amount plus any tax.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Amount | Decimal |
| Source column | Entered 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 | creditEnteredAmountDomestic | The API identifier used in GraphQL. |
| Number | 14608 |
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 | Yes | This field is 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 | 14642 |
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 | Yes | This field is 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 | 14643 |
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 | Yes | This field is 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 | 14650 |
Credit posted amount
The amount actually posted on the general ledger account in credit.
Business NXT makes a distinction between the amount entered and the amount posted. The amount entered shows the amount as it was typed in during voucher entry, inclusive of VAT, but exclusive of any investment tax. Business NXT deducts any input or output VAT, using the result as the base amount for the taxes. The amount posted is equal to this base amount plus any tax.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Amount | Decimal |
| Source column | Posted 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 | creditPostedAmountDomestic | The API identifier used in GraphQL. |
| Number | 14611 |
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 | Yes | This field is 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 | 14688 |
Credited amount
The field is not in use.
| 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 | CNAm | The database field name. |
| API identifier | creditedAmountDomestic | The API identifier used in GraphQL. |
| Number | 14635 |
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 | 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 | AgRef | The database field name. |
| API identifier | crossReference | The API identifier used in GraphQL. |
| Number | 14714 |
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 | Yes | This field is 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 | 14715 |
| 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 | Yes | This field is 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 | 14716 |
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 | 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 | CurCAm | The database field name. |
| API identifier | currencyCorrectionAmount | The API identifier used in GraphQL. |
| Number | 14663 |
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 | 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 | CurCDt | The database field name. |
| API identifier | currencyCorrectionDate | The API identifier used in GraphQL. |
| Number | 14661 |
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 | 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 | CurCExRt | The database field name. |
| API identifier | currencyCorrectionExchangeRate | The API identifier used in GraphQL. |
| Number | 14662 |
Curr. corr. run no.
A unique number identifying the last run of the Currency correction processing.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | No. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | CurCRNo | The database field name. |
| API identifier | currencyCorrectionRunNo | The API identifier used in GraphQL. |
| Number | 14660 |
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 | 14600 |
| 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 |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | Cur2 | The database field name. |
| API identifier | currencyNo2 | The API identifier used in GraphQL. |
| Number | 14603 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Currency | Currency2 |
|
Cust. no.
The Cust. no. the transaction applies to.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Cust. no. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | CustNo | The database field name. |
| API identifier | customerNo | The API identifier used in GraphQL. |
| Number | 14562 |
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 | 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 | Dt1 | The database field name. |
| API identifier | date1 | The API identifier used in GraphQL. |
| Number | 14785 |
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 | 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 | Dt2 | The database field name. |
| API identifier | date2 | The API identifier used in GraphQL. |
| Number | 14786 |
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 | Yes | This field is 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 | 14610 |
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 | Yes | This field is 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 | 14616 |
Debit entered amount
The amount that was originally entered on the voucher line for a debit account.
In general ledger transactions, Business NXT makes a distinction between the amount entered and the amount posted. The amount entered shows the amount as it was typed in during voucher entry, inclusive of VAT, but exclusive of any investment tax. Business NXT deducts any input or output VAT, using the result as the base amount for the taxes. The amount posted is equal to this base amount plus any tax.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Amount | Decimal |
| Source column | Entered 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 | debitEnteredAmountDomestic | The API identifier used in GraphQL. |
| Number | 14607 |
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 | Yes | This field is 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 | 14640 |
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 | Yes | This field is 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 | 14641 |
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 | Yes | This field is 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 | 14651 |
Debit posted amount
The amount actually posted on the general ledger account in debit.
Business NXT makes a distinction between the amount entered and the amount posted. The amount entered shows the amount as it was typed in during voucher entry, inclusive of VAT, but exclusive of any investment tax. Business NXT deducts any input or output VAT, using the result as the base amount for the taxes. The amount posted is equal to this base amount plus any tax.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Amount | Decimal |
| Source column | Posted 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 | debitPostedAmountDomestic | The API identifier used in GraphQL. |
| Number | 14609 |
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 | Yes | This field is 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 | 14687 |
Debt collection run no.
A Debt collection run no. will be inserted in this field when you run the Transfer to debt collection processing in the Associate table.
The number is visualised and can be changed in the Change counters processings dialog in the Company information table.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | No. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | LegRRNo | The database field name. |
| API identifier | debtCollectionRunNo | The API identifier used in GraphQL. |
| Number | 14728 |
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 | 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 | PmtCur | The database field name. |
| API identifier | deductCurrencyNo | The API identifier used in GraphQL. |
| Number | 14697 |
| 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 | Yes | This field is 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 | 14766 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Associate | DeliveryAssociate |
|
Direct deb. run no.
This field is no longer in use. Be aware the field may be removed in later versions.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | No. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | DebRnNo | The database field name. |
| API identifier | directDebitingRunNo | The API identifier used in GraphQL. |
| Number | 14699 |
Document product no.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Document product no. | Text (40) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | DocProdNo | The database field name. |
| API identifier | documentProductNo | The API identifier used in GraphQL. |
| Number | 19691 |
Document quantity
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Quantity | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | DocQty | The database field name. |
| API identifier | documentQuantity | The API identifier used in GraphQL. |
| Number | 19723 |
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 | 14636 |
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 | Yes | This field is 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 | 14703 |
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 | Yes | This field is 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 | 14700 |
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 | Yes | This field is 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 | 14701 |
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 | Yes | This field is 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 | 15467 |
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 | Yes | This field is 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 | 14702 |
Empl. no.
The employee entered in the Voucher.
The Empl. no. is a unique number identifying one specific Employee.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is 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 | EmpNo | The database field name. |
| API identifier | employeeNo | The API identifier used in GraphQL. |
| Number | 14765 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Associate | Employee |
|
Entered amount
The amount that was originally entered on the voucher line for an account.
In general ledger transactions, Business NXT makes a distinction between the amount entered and the amount posted. The amount entered shows the amount as it was typed in during voucher entry, inclusive of VAT, but exclusive of any tax. Business NXT deducts any input or output VAT, using the result as the base amount for the taxes. The amount posted is equal to this base amount plus any tax.
| 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 | EntAm | The database field name. |
| API identifier | enteredAmountDomestic | The API identifier used in GraphQL. |
| Number | 14597 |
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 | Yes | This field is 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 | 14779 |
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 | 14690 |
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 | 14601 |
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 |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | ExRt2 | The database field name. |
| API identifier | exchangeRate2 | The API identifier used in GraphQL. |
| Number | 14604 |
Exempt from auto entry
This field shows whether you selected that the voucher line is to be exempt from automatic entries during voucher entry.
| 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 | ExAut | The database field name. |
| API identifier | exemptFromAutomaticEntry | The API identifier used in GraphQL. |
| Number | 14774 |
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 | Yes | This field is visible by default in the table display. |
| Domain | String of length 20 | Text (20) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | ExtRef1 | The database field name. |
| API identifier | externalReference1 | The API identifier used in GraphQL. |
| Number | 14782 |
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 | Yes | This field is visible by default in the table display. |
| Domain | String of length 20 | Text (20) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | ExtRef2 | The database field name. |
| API identifier | externalReference2 | The API identifier used in GraphQL. |
| Number | 14783 |
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 | Yes | This field is visible by default in the table display. |
| Domain | String of length 20 | Text (20) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | ExtRef3 | The database field name. |
| API identifier | externalReference3 | The API identifier used in GraphQL. |
| Number | 14784 |
Factoring run no.
Is filled in when you run the Factoring processing from the Open customer entry table. The number is assigned from the counter in the Change counters processings dialog in the Company information table.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | No. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | FactRNo | The database field name. |
| API identifier | factoringRunNo | The API identifier used in GraphQL. |
| Number | 14722 |
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 | 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 | FixAm | The database field name. |
| API identifier | fixedAmountDomestic | The API identifier used in GraphQL. |
| Number | 14656 |
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 | 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 | FixCurAm | The database field name. |
| API identifier | fixedAmountInCurrency | The API identifier used in GraphQL. |
| Number | 14657 |
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 | Yes | This field is 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 | 14658 |
Free 1
Additional numeric information about the transaction.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Quantity | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | Free1 | The database field name. |
| API identifier | free1 | The API identifier used in GraphQL. |
| Number | 14787 |
Free 2
Additional numeric information about the transaction.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Quantity | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | Free2 | The database field name. |
| API identifier | free2 | The API identifier used in GraphQL. |
| Number | 14788 |
Free 3
Additional numeric information about the transaction.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Quantity | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | Free3 | The database field name. |
| API identifier | free3 | The API identifier used in GraphQL. |
| Number | 14789 |
Free 4
Additional numeric information about the transaction.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Quantity | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | Free4 | The database field name. |
| API identifier | free4 | The API identifier used in GraphQL. |
| Number | 14790 |
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 | Yes | This field is visible by default in the table display. |
| Domain | No. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | GiroChSm | The database field name. |
| API identifier | giroNoCheckSum | The API identifier used in GraphQL. |
| Number | 14704 |
GL account
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is 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 | accumulatedOnGeneralLedgerAccountNo | The API identifier used in GraphQL. |
| Number | 14717 |
GL account no.
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 | Yes | This field is 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 | GlAcNo | The database field name. |
| API identifier | generalLedgerAccountNo | The API identifier used in GraphQL. |
| Number | 14564 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| General ledger account | GeneralLedgerAccount |
|
Interest amount
How much interest has been calculated on an entry.
If interest method 1 or 2 applies, the value in the field will be accumulated after each interest invoicing. If interest method 3 or 4 applies, the field will be updated only once. Interest method is defined in the Country table.
| 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 | IntAm | The database field name. |
| API identifier | interestAmountDomestic | The API identifier used in GraphQL. |
| Number | 14733 |
Interest amount in currency
How much interest has been calculated on an entry in currency.
If interest method 1 or 2 applies, the value in the field will be accumulated after each interest invoicing. If interest method 3 or 4 applies, the field will be updated only once. Interest method is defined in the Country table.
| 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 | CurIntAm | The database field name. |
| API identifier | interestAmountInCurrency | The API identifier used in GraphQL. |
| Number | 14734 |
Interest amount in EURO
How much interest has been calculated on an entry converted into EUROS.
If interest method 1 or 2 applies, the value in the field will be accumulated after each interest invoicing. If interest method 3 or 4 applies, the field will be updated only once. Interest method is defined in the Country table.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Amount | Decimal |
| Source column | Interest 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 | interestAmountInEuro | The API identifier used in GraphQL. |
| Number | 14739 |
Interest free amount
A fraction of the Amount that is exempt from interest calculation in the default currency.
The amount can be entered on the voucher line and inherited to the transaction. It can also be entered (or overridden) directly on the transaction record.
| 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 | FreeAm | The database field name. |
| API identifier | interestFreeAmountDomestic | The API identifier used in GraphQL. |
| Number | 14735 |
Interest free amount in currency
A fraction of the Amount in currency that is exempt from interest calculation in the default currency.
The amount can be entered on the voucher line and inherited to the transaction. It can also be entered (or overridden) directly on the transaction record.
| 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 | FreeCurA | The database field name. |
| API identifier | interestFreeAmountInCurrency | The API identifier used in GraphQL. |
| Number | 14736 |
Interest free amount in EURO
A fraction of the Amount in EURO that is exempt from interest calculation in the default currency.
The amount can be entered on the voucher line and inherited to the transaction. It can also be entered (or overridden) directly on the transaction record.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Amount | Decimal |
| Source column | Interest free 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 | interestFreeAmountInEuro | The API identifier used in GraphQL. |
| Number | 14740 |
Interest from date
See the explanation for the Interest to date field.
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 | IntFrDt | The database field name. |
| API identifier | interestFromDate | The API identifier used in GraphQL. |
| Number | 14730 |
Interest rate
Can be entered on vouchers, or in the Open customer entry table.
If not filled in, Visma Business uses the interest rate specified for the customer or for the customer's Country no. in the Country table when the interest note is printed. Interest rate can also be changed for one single entry, in this case interest can be calculated for the same customer at different rates in the same interest note.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Percent | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | IntRt | The database field name. |
| API identifier | interestRate | The API identifier used in GraphQL. |
| Number | 14731 |
Interest this run
Shows how much interest has been calculated for an entry on this run.
| 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. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | interestThisRunDomestic | The API identifier used in GraphQL. |
| Number | 14737 |
Interest this run in currency
Shows how much interest has been calculated for an entry in the current currency on this run.
| 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. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | interestThisRunInCurrency | The API identifier used in GraphQL. |
| Number | 14738 |
Interest this run in EURO
Shows how much interest has been calculated for an entry converted into EUROS on this run.
The field will show values only on the interest invoice print-out and NOT on the screen.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Amount | Decimal |
| Source column | Interest this run 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 | interestThisRunInEuro | The API identifier used in GraphQL. |
| Number | 14741 |
Interest to date
Is updated when you run an interest note for an entry.
Interest is calculated from the Due date up to the current date when Interest method 1 or 2 is defined in the Country table, and to the payment date when interest method 3 or 4 is defined in the Country table. If you want to calculate interest manually, you can fill in the fields as information. If you have agreed no interest for a particular period after the Due date, this field can be filled in with the date to which you want interest to be calculated.
If you have filled in the Maximum number of interest days field in the Payment term table, the field will show Interest to date as Interest from date + Maximum number of interest days. If you are using the Interest free days in the Payment term table, the field will show Interest from date as Due date + Interest free days.
The date is validated using the regional settings in Windows.
| 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 | IntToDt | The database field name. |
| API identifier | interestToDate | The API identifier used in GraphQL. |
| Number | 14732 |
Invest. tax amount
Not in use. (Relates to a former Norwegian tax, that has been removed.)
| 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 | InvTxAm | The database field name. |
| API identifier | investmentTaxAmountDomestic | The API identifier used in GraphQL. |
| Number | 14624 |
Inv. tax rate
Not in use. (Relates to a former Norwegian tax, that has been removed.)
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Percent | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | InvTxRt | The database field name. |
| API identifier | investmentTaxRate | The API identifier used in GraphQL. |
| Number | 14626 |
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 | 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. |
| 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 | 14634 |
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 | 14631 |
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 | 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 | LastCAm | The database field name. |
| API identifier | lastCurrencyCorrectionAmount | The API identifier used in GraphQL. |
| Number | 14664 |
Last reminder date
Updated from the print dialog when printing the last reminder.
It must be set back in time if you want to reprint a reminder after you have approved the printout, or dispatch the next reminder earlier than warranted by the reminder interval in the Reminder table.
The date is validated using the regional settings in Windows.
| 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 | RemRnNo | The database field name. |
| API identifier | lastReminderDate | The API identifier used in GraphQL. |
| Number | 14723 |
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 | Yes | This field is visible by default in the table display. |
| Domain | Memo file name | Text (260) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | NoteNm | The database field name. |
| API identifier | memoFileName | The API identifier used in GraphQL. |
| Number | 14791 |
Memo no.
Link to the memo for the entry.
The actual memo is stored in the Memo table.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Memo no. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | MemoNo | The database field name. |
| API identifier | memoNo | The API identifier used in GraphQL. |
| Number | 19215 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Memo | Memo |
|
Name
The name of account.
The field is joined in from either General ledger account, Associate (through Cust. no. or Sup. no. field) or Capital asset tables based on the value in the Account type field.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Name | Text (80) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | Nm | The database field name. |
| API identifier | name | The API identifier used in GraphQL. |
| Number | 14935 |
No interest
Exempts the record from interest calculation when filled in.
If you want to have automatic interest exemption for a debit invoice when crediting, you can tick the Ref. Entry Free of interest parameter in the Order options field in the Order table. The transaction that a credit note with interest exemption generates inserts a check in the No interest field. When the entry has been paid, it will be concluded. If it has been part-paid, the check for No interest will remain for the entry with the outstanding amount.
The processing Calculate client interest also takes this field into account. If you select Set entry free of interest on suspended cases in the Company information table in the Accounting processing field, blocked cases will be exempted from interest when you post client interest.
| 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 | ExcInt | The database field name. |
| API identifier | noInterest | The API identifier used in GraphQL. |
| Number | 14729 |
No reminders
An entry can be exempted from reminders either when vouchers are entered or in the Open customer entry table.
You can also stipulate that a Customer is not to be subject to reminders by selecting the flag No reminders in the Customer options field in the Associate table.
- 1 - No reminders
- 2 - Exempt from debt recovery
- Will stop an invoice from going to debt collection.
- 3 - Sent to debt collection
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | No reminders | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | ExcRem | The database field name. |
| API identifier | noReminders | The API identifier used in GraphQL. |
| Number | 14724 |
No. of reminders sent
Updated when approving printed reminders, or received from Visma AutoCollect.
You can change the number of reminders in order to reprint a reminder. If you choose to update the reminder fee automatically when reminders are printed, you must manually reverse it in the accounts if they are resent.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Number of reminders | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | Rems | The database field name. |
| API identifier | noOfRemindersSent | The API identifier used in GraphQL. |
| Number | 14725 |
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 | Yes | This field is 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 | 14683 |
| 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.
It is possible to change this subsequently for transactions. However, you must then regenerate the general ledger balances to ensure that the reports are correct. The fields are blocked by default in Column access for security reasons.
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 | Yes | This field is visible by default in the table display. |
| Domain | Organisational unit no. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | R1 | The database field name. |
| API identifier | orgUnit1 | The API identifier used in GraphQL. |
| Number | 14753 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 1 | OrgUnit1 |
| ||
| General ledger balance/Organisational unit 1 | GeneralLedgerBalance1 |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. |
Organisational unit 2
The organisational unit you entered in vouchers, possibly via the distribution key in vouchers.
It is possible to change this subsequently for transactions. However, you must then regenerate the general ledger balances to ensure that the reports are correct. The fields are blocked by default in Column access for security reasons.
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 | Yes | This field is visible by default in the table display. |
| Domain | Organisational unit no. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | R2 | The database field name. |
| API identifier | orgUnit2 | The API identifier used in GraphQL. |
| Number | 14754 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 2 | OrgUnit2 |
| ||
| General ledger balance/Organisational unit 2 | GeneralLedgerBalance2 |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. |
Organisational unit 3
The organisational unit you entered in vouchers, possibly via the distribution key in vouchers.
It is possible to change this subsequently for transactions. However, you must then regenerate the general ledger balances to ensure that the reports are correct. The fields are blocked by default in Column access for security reasons.
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 | Yes | This field is visible by default in the table display. |
| Domain | Organisational unit no. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | R3 | The database field name. |
| API identifier | orgUnit3 | The API identifier used in GraphQL. |
| Number | 14755 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 3 | OrgUnit3 |
| ||
| General ledger balance/Organisational unit 3 | GeneralLedgerBalance3 |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. |
Organisational unit 4
The organisational unit you entered in vouchers, possibly via the distribution key in vouchers.
It is possible to change this subsequently for transactions. However, you must then regenerate the general ledger balances to ensure that the reports are correct. The fields are blocked by default in Column access for security reasons.
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 | Yes | This field is visible by default in the table display. |
| Domain | Organisational unit no. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | R4 | The database field name. |
| API identifier | orgUnit4 | The API identifier used in GraphQL. |
| Number | 14756 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 4 | OrgUnit4 |
| ||
| General ledger balance/Organisational unit 4 | GeneralLedgerBalance4 |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. |
Organisational unit 5
The organisational unit you entered in vouchers, possibly via the distribution key in vouchers.
It is possible to change this subsequently for transactions. However, you must then regenerate the general ledger balances to ensure that the reports are correct. The fields are blocked by default in Column access for security reasons.
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 | Yes | This field is visible by default in the table display. |
| Domain | Organisational unit no. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | R5 | The database field name. |
| API identifier | orgUnit5 | The API identifier used in GraphQL. |
| Number | 14757 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 5 | OrgUnit5 |
| ||
| General ledger balance/Organisational unit 5 | GeneralLedgerBalance5 |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. |
Organisational unit 6
The organisational unit you entered in vouchers, possibly via the distribution key in vouchers.
It is possible to change this subsequently for transactions. However, you must then regenerate the general ledger balances to ensure that the reports are correct. The fields are blocked by default in Column access for security reasons.
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 | Yes | This field is visible by default in the table display. |
| Domain | Organisational unit no. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | R6 | The database field name. |
| API identifier | orgUnit6 | The API identifier used in GraphQL. |
| Number | 14758 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 6 | OrgUnit6 |
| ||
| General ledger balance/Organisational unit 6 | GeneralLedgerBalance6 |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. |
Organisational unit 7
The organisational unit you entered in vouchers, possibly via the distribution key in vouchers.
It is possible to change this subsequently for transactions. However, you must then regenerate the general ledger balances to ensure that the reports are correct. The fields are blocked by default in Column access for security reasons.
The field appear with the name assigned to it in the Company information table.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Long alphanumeric organisational unit no. | Text (40) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | R7 | The database field name. |
| API identifier | orgUnit7 | The API identifier used in GraphQL. |
| Number | 14759 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 7 | OrgUnit7 |
| ||
| General ledger balance/Organisational unit 7 | GeneralLedgerBalance7 |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. |
Organisational unit 8
The organisational unit you entered in vouchers, possibly via the distribution key in vouchers.
It is possible to change this subsequently for transactions. However, you must then regenerate the general ledger balances to ensure that the reports are correct. The fields are blocked by default in Column access for security reasons.
The field appear with the name assigned to it in the Company information table.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Short alphanumeric organisational unit no. | Text (10) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | R8 | The database field name. |
| API identifier | orgUnit8 | The API identifier used in GraphQL. |
| Number | 14760 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 8 | OrgUnit8 |
| ||
| General ledger balance/Organisational unit 8 | GeneralLedgerBalance8 |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. |
Organisational unit 9
The organisational unit you entered in vouchers, possibly via the distribution key in vouchers.
It is possible to change this subsequently for transactions. However, you must then regenerate the general ledger balances to ensure that the reports are correct. The fields are blocked by default in Column access for security reasons.
The field appear with the name assigned to it in the Company information table.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Short alphanumeric organisational unit no. | Text (10) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | R9 | The database field name. |
| API identifier | orgUnit9 | The API identifier used in GraphQL. |
| Number | 14761 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 9 | OrgUnit9 |
| ||
| General ledger balance/Organisational unit 9 | GeneralLedgerBalance9 |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. |
Organisational unit 10
The organisational unit you entered in vouchers, possibly via the distribution key in vouchers.
It is possible to change this subsequently for transactions. However, you must then regenerate the general ledger balances to ensure that the reports are correct. The fields are blocked by default in Column access for security reasons.
The field appear with the name assigned to it in the Company information table.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Short alphanumeric organisational unit no. | Text (10) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | R10 | The database field name. |
| API identifier | orgUnit10 | The API identifier used in GraphQL. |
| Number | 14762 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 10 | OrgUnit10 |
| ||
| General ledger balance/Organisational unit 10 | GeneralLedgerBalance10 |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. |
Organisational unit 11
The organisational unit you entered in vouchers, possibly via the distribution key in vouchers.
It is possible to change this subsequently for transactions. However, you must then regenerate the general ledger balances to ensure that the reports are correct. The fields are blocked by default in Column access for security reasons.
The field appear with the name assigned to it in the Company information table.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Short alphanumeric organisational unit no. | Text (10) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | R11 | The database field name. |
| API identifier | orgUnit11 | The API identifier used in GraphQL. |
| Number | 14763 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 11 | OrgUnit11 |
| ||
| General ledger balance/Organisational unit 11 | GeneralLedgerBalance11 |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. |
Organisational unit 12
The organisational unit you entered in vouchers, possibly via the distribution key in vouchers.
It is possible to change this subsequently for transactions. However, you must then regenerate the general ledger balances to ensure that the reports are correct. The fields are blocked by default in Column access for security reasons.
The field appear with the name assigned to it in the Company information table.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Short alphanumeric organisational unit no. | Text (10) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | R12 | The database field name. |
| API identifier | orgUnit12 | The API identifier used in GraphQL. |
| Number | 14764 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 12 | OrgUnit12 |
| ||
| General ledger balance/Organisational unit 12 | GeneralLedgerBalance12 |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. |
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 | Yes | This field is 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 | 14773 |
Original due date
Is updated with the value from the Due date field if due date is altered. This is only of significance to the interest calculation routine. The default is the due date that forms the basis of interest calculation.
In the Company information table, you can control the interest calculation using the parameter Use original due date for interest calculation, which can be found under Accounting processing. The customer will then pay interest from the original due date, even though the due date has been moved.
The date is validated using the regional settings in Windows.
| 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 | OrgDueDt | The database field name. |
| API identifier | originalDueDate | The API identifier used in GraphQL. |
| Number | 14637 |
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 | Yes | This field is visible by default in the table display. |
| Domain | Journal no. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | SrcJNo | The database field name. |
| API identifier | originalRunNo | The API identifier used in GraphQL. |
| Number | 14767 |
| 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 |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | OrVoNo | The database field name. |
| API identifier | originalVoucherNo | The API identifier used in GraphQL. |
| Number | 18627 |
OSS VAT report no.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | No. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | EsTxStNo | The database field name. |
| API identifier | ossTaxStatementNo | The API identifier used in GraphQL. |
| Number | 17584 |
OSS VAT term
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is 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 | EsTxTrm | The database field name. |
| API identifier | ossTaxTerm | The API identifier used in GraphQL. |
| Number | 17562 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| OSS VAT period | OssTaxTerm |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. |
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 | 14638 |
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 | 14639 |
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 | Yes | This field is 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 | 14652 |
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 | 14710 |
Paid curr. amount
Paid amount in the current currency.
Accumulates remitted part payments.
| 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 | RemCAm | The database field name. |
| API identifier | remittedCurrencyAmount | The API identifier used in GraphQL. |
| Number | 14711 |
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 | 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 | PayedDt | The database field name. |
| API identifier | paidLast | The API identifier used in GraphQL. |
| Number | 14706 |
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 | Yes | This field is 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 | 14776 |
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 | 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 | PrtAm | The database field name. |
| API identifier | partPaymentDomestic | The API identifier used in GraphQL. |
| Number | 14654 |
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 | 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 | PrtCurAm | The database field name. |
| API identifier | partPaymentInCurrency | The API identifier used in GraphQL. |
| Number | 14655 |
Part payment in EURO
This field is derived from the Part payment in currency field.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is 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 | 14659 |
Paym. run no.
Updated when you approve printouts in connection with payments.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | No. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | RmtRnNo | The database field name. |
| API identifier | remittanceRunNo | The API identifier used in GraphQL. |
| Number | 14712 |
Payment element index
Reference to the relevant <Payment> element in the incoming payment file.
| 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 | PayIdx | The database field name. |
| API identifier | paymentIndex | The API identifier used in GraphQL. |
| Number | 19621 |
Payment line element index
Reference to the relevant <PaymentLine> element in the incoming payment file.
| 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 | PayLnIdx | The database field name. |
| API identifier | paymentLineIndex | The API identifier used in GraphQL. |
| Number | 19622 |
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 | Yes | This field is 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 | 14707 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Payment method | PaymentMethod |
|
Payment no., customer
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Payment no. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | PmtNo | The database field name. |
| API identifier | customerPaymentNo | The API identifier used in GraphQL. |
| Number | 14708 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Payment | CustomerPayment |
|
Payment no., supplier
Used during electronic funds transfer.
This field is fetched from Supplier transactions.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Payment no. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | BPmtNo | The database field name. |
| API identifier | supplierPaymentNo | The API identifier used in GraphQL. |
| Number | 14695 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Payment | SupplierPayment |
|
Payment suggested
Shows a "x", if a payment suggestion has been created.
| 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 | DebDir | The database field name. |
| API identifier | paymentSuggested | The API identifier used in GraphQL. |
| Number | 14698 |
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 |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | RmtSup | The database field name. |
| API identifier | remittanceSupplierNo | The API identifier used in GraphQL. |
| Number | 17876 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Associate | RemittanceSupplier |
|
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 | Yes | This field is 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 | 14709 |
| 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 | Yes | This field is 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 | 14566 |
| 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. | |
| Customer balance | CustomerBalance |
| 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. | |
| General ledger balance | GeneralLedgerBalance |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. | |
| Capital asset balance | CapitalAssetBalance |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. | |
| General ledger balance/Organisational unit 1 | GeneralLedgerBalance1 |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. | |
| General ledger balance/Organisational unit 2 | GeneralLedgerBalance2 |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. | |
| General ledger balance/Organisational unit 3 | GeneralLedgerBalance3 |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. | |
| General ledger balance/Organisational unit 4 | GeneralLedgerBalance4 |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. | |
| General ledger balance/Organisational unit 5 | GeneralLedgerBalance5 |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. | |
| General ledger balance/Organisational unit 6 | GeneralLedgerBalance6 |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. | |
| General ledger balance/Organisational unit 7 | GeneralLedgerBalance7 |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. | |
| General ledger balance/Organisational unit 8 | GeneralLedgerBalance8 |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. | |
| General ledger balance/Organisational unit 9 | GeneralLedgerBalance9 |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. | |
| General ledger balance/Organisational unit 10 | GeneralLedgerBalance10 |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. | |
| General ledger balance/Organisational unit 11 | GeneralLedgerBalance11 |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. | |
| General ledger balance/Organisational unit 12 | GeneralLedgerBalance12 |
| 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 | Yes | This field is visible by default in the table display. |
| Domain | No. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | PrBt | The database field name. |
| API identifier | periodBatchNo | The API identifier used in GraphQL. |
| Number | 14768 |
Picture file name
the file name for the scanned image file for the vouchers.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Picture file name | Text (260) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | PictNo | The database field name. |
| API identifier | pictureFileName | The API identifier used in GraphQL. |
| Number | 14793 |
Posted amount
In general ledger transactions, Business NXT makes a distinction between the amount entered on the voucher line and the amount actually posted.
The amount posted shows the amount as it is posted, regardless of if another amount, eg an amount incl VAT was entered on the voucher line. Business NXT deducts any input or output VAT from the amount entered on voucher line, using the result as the base amount for the taxes. The amount posted is equal to this base amount.
| 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 | AcAm | The database field name. |
| API identifier | postedAmountDomestic | The API identifier used in GraphQL. |
| Number | 14599 |
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 | 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. |
| 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 | 18573 |
Previous voucher no.
The original voucher number when you reverse 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 | PrevVoNo | The database field name. |
| API identifier | previousVoucherNo | The API identifier used in GraphQL. |
| Number | 14769 |
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 | Yes | This field is 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 | 14689 |
Product no.
Product number you entered in the voucher line.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Product no. | Text (40) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | Act | The database field name. |
| API identifier | productNo | The API identifier used in GraphQL. |
| Number | 14684 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Product | Product |
| ||
| Search product | SearchProduct |
|
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 | 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 | Purc | The database field name. |
| API identifier | purchases | The API identifier used in GraphQL. |
| Number | 14632 |
Quantity
Comes from vouchers and has the same sign as the Amount field.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Quantity | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | Qty | The database field name. |
| API identifier | quantity | The API identifier used in GraphQL. |
| Number | 14686 |
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 | 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 | TrfExRt | The database field name. |
| API identifier | exchangeRateAgainstDomesticCurrency | The API identifier used in GraphQL. |
| Number | 14696 |
Realisation journal no.
| 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 | RealJNo | The database field name. |
| API identifier | realisationJournalNo | The API identifier used in GraphQL. |
| Number | 16593 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Realisation journal | RealisationJournal |
| ||
| Realisation journal line | RealisationJournalLine |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. |
Reconciliation rest amount
Amount not reconciled.
Used for bank reconciliation of bank accounts in domestic currency.
Filled out when the Account no. on the transactions is found in the Bank partner table, and Update general ledger transactions with reconciliation amount is selected under the EFT processing field on the relevant bank partner.
Can be edited manually. The value must be between 0 and the Posted amount. The Reconciliation rest amount in currency field will then be calculated automatically.
| 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 | RecRAm | The database field name. |
| API identifier | reconciliationRestAmountDomestic | The API identifier used in GraphQL. |
| Number | 18620 |
Reconciliation rest amount in currency
Amount not reconciled in currency.
Used for bank reconciliation of bank accounts in foreign currency.
Filled out when the Account no. on the transactions is found in the Bank partner table, and Update general ledger transactions with reconciliation amount is selected under the EFT processing field on the relevant bank partner.
Can be edited manually. The value must be between 0 and the Amount in currency. The Reconciliation rest amount field will then be calculated automatically.
| 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 | CurRecRAm | The database field name. |
| API identifier | reconciliationRestAmountInCurrency | The API identifier used in GraphQL. |
| Number | 18618 |
Reconciliation rest amount in EURO
The Reconciliation rest amount field converted to EURO.
| 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 | reconciliationRestAmountInEuro | The API identifier used in GraphQL. |
| Number | 18619 |
Reconciliation status
Status telling if the transaction has been manually enabled/disabled for reconciliation.
Status is set when the Disable reconciliation or the Enable reconciliation processing is executed for the row.
- 0 - None
- 1 - Reconciliation disabled
- 2 - Reconciliation enabled
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Reconciliation status | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | RecSt | The database field name. |
| API identifier | reconciliationStatus | The API identifier used in GraphQL. |
| Number | 19538 |
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 | 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 | Ref | The database field name. |
| API identifier | reference | The API identifier used in GraphQL. |
| Number | 14713 |
Reminder doc. no.
When you approve a reminder, the Reminder document number is updated with the open entry.
You can use the reminder document number in the CID code. This field is used by some external EFT system.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | No. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | RemDocNo | The database field name. |
| API identifier | reminderDocumentNo | The API identifier used in GraphQL. |
| Number | 14726 |
Reminder printing date
Shows the printing date for the reminder and you cannot override the value.
The date is validated using the regional settings in Windows.
| 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 | RemPrDt | The database field name. |
| API identifier | reminderPrintingDate | The API identifier used in GraphQL. |
| Number | 14727 |
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 | 14647 |
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 | 14648 |
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 | Yes | This field is 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 | 14653 |
Running total
Use this field for account statements to show a running total in the printout.
| 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. |
| 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 | 14613 |
Running total in curr.
Use this field for account statements to show a running total in the printout.
| 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. |
| 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 | 14614 |
Scan doc. no.
The ID of the scanned document.
Is used in connection with Visma Document Center.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | No. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | PLDNo | The database field name. |
| API identifier | scanDocumentNo | The API identifier used in GraphQL. |
| Number | 14770 |
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 | Yes | This field is visible by default in the table display. |
| Domain | Scan status | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | PLDFlow | The database field name. |
| API identifier | scanStatus | The API identifier used in GraphQL. |
| Number | 14772 |
Structured element index
Reference to the relevant <Structured> element within the <PaymentLine> element in the incoming payment file.
| 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 | StrElIdx | The database field name. |
| API identifier | structuredElementIndex | The API identifier used in GraphQL. |
| Number | 19623 |
Sup. no.
Shows the supplier number to which the transaction applies.
If the original voucher line contained a supplier no in the debit account field or in the credit account field, the supplier no will be automatically entered and inherited to the general ledger transaction.
| 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 | 14563 |
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) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | Txt | The database field name. |
| API identifier | text | The API identifier used in GraphQL. |
| Number | 14595 |
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 | Yes | This field is 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 | 14778 |
Turnover
Is 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 | 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 | Trn | The database field name. |
| API identifier | turnover | The API identifier used in GraphQL. |
| Number | 14633 |
Turnover class
Determines the posted amounts turnover class.
- The voucher line from which the transaction origins
- If the original voucher line contained a customer or supplier no in the debit account field or in the credit account field: From the supplier / customers trade area. (Derived)
- If the original voucher line contained general ledger accounts only:
- From the General ledger account.
- From the VAT code.
On vouchers with general ledger entries for sales and purchases that are generated on the basis of orders, the turnover class is defined on the basis of the Transaction type, Trade area and Service type fields.
- 1 - Taxable sales
- Is used for sales of taxable products. I.e. when
- the Transaction type is 1 - Sales or 2 - Hire
- the Trade area is 0 - Taxable domestic according to VAT- and accounting inf./VAT code
- 2 - Non-taxable domestic sales
- Is used for sales of non-taxable products. I.e. when
- the Transaction type is 1 - Sales or 2 - Hire
- the Trade area is 1 - Non-taxable domestic
- 10 - Transfer of goods to EU countries
- Used when
- the Transaction type is 1 - Sales or 2 - Hire
- the Trade area is 4 - Subsidiary in another EU country
- Service type1 - Services is not selected
- 5 - Sale of goods to EU countries
- Used when
- the Transaction type is 1 - Sales or 2 - Hire
- the Trade area is 2 - Within other EU country
- Service type1 - Services is not selected
- 3 - Sale of goods outside EU/Abroad
- Used when
- the Transaction type is 1 - Sales or 2 - Hire
- the Trade area is 3 - Outside EU/Abroad
- Service type1 - Services is not selected
- 9 - Sale of services abroad
- Used when
- the Transaction type is 1 - Sales or 2 - Hire
- the Trade area is 2 - Within other EU country, 3 - Outside EU/Abroad or 4 - Subsidiary in another EU country
- Service type1 - Services is selected
- 13 - Non-taxable sales
- 16 - Sales outside tax area
- 18 - Sales, taxable for purchaser
- 20 - Agent sales to third party
- 22 - Sales of services to EU countries
- 26 - Rent income voluntary
- 27 - OSS union scheme services
- 28 - OSS union scheme goods
- 29 - OSS import scheme
- 4 - Taxable purchases
- Is used for purchases of taxable products. I.e. when
- the Transaction type is 6 - Purchase
- the Trade area is 0 - Taxable domestic according to VAT- and accounting inf./VAT code
- 7 - Non-taxable domestic purchases
- Is used for purchases of non-taxable products. I.e. when
- the Transaction type is 6 - Purchase
- the Trade area is 1 - Non-taxable domestic
- 15 - Domestic purchases with reversed VAT deduction
- 11 - Transfer of goods between other EU countries
- Used when
- the Transaction type is 6 - Purchase
- the Trade area is 5 - Transfer between other EU countries
- Service type1 - Services is not selected
- 6 - Purchase of goods from EU countries
- Used when
- the Transaction type is 6 - Purchase
- the Trade area is 2 - Within other EU country
- Service type1 - Services is not selected
- 8 - Purchase of goods outside EU/Abroad
- Used when
- the Transaction type is 6 - Purchase
- the Trade area is 3 - Outside EU/Abroad
- Service type1 - Services is not selected
- 12 - Purchase of services abroad
- Used when
- the Transaction type is 6 - Purchase
- the Trade area is 2 - Within other EU country or 5 - Transfer between other EU countries
- Service type1 - Services is selected
- 14 - Non-taxable purchases
- 17 - Purchase outside tax area
- 19 - Purchase, taxable by purchaser
- 21 - Purchase of services from EU countries
- 23 - Domestic purchase of services
- 24 - Taxable product consumption
- 25 - Domestic purchases with reversed VAT liability
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Turnover class | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | TxCl | The database field name. |
| API identifier | turnoverClass | The API identifier used in GraphQL. |
| Number | 14618 |
Unit
The field is transferred from vouchers when Batch are updated.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Unit | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | Un | The database field name. |
| API identifier | unit | The API identifier used in GraphQL. |
| Number | 14685 |
| 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 | Yes | This field is 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 | 14590 |
| 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 | Yes | This field is visible by default in the table display. |
| Domain | No. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | UpdLnNo | The database field name. |
| API identifier | updatedVoucherLineNo | The API identifier used in GraphQL. |
| Number | 14591 |
| 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 | 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 | ValDt | The database field name. |
| API identifier | valueDate | The API identifier used in GraphQL. |
| Number | 14567 |
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 | 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 | VatAm | The database field name. |
| API identifier | vatAmountDomestic | The API identifier used in GraphQL. |
| Number | 14622 |
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 | 18155 |
VAT base account no.
| 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 | BasAcNo | The database field name. |
| API identifier | vatBaseAccountNo | The API identifier used in GraphQL. |
| Number | 19165 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| General ledger account | VatBaseAccountGlAccount |
|
VAT code
Shows the tax code was used in the voucher line during voucher entry.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | VAT code | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | TxCd | The database field name. |
| API identifier | taxCode | The API identifier used in GraphQL. |
| Number | 14619 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| VAT code | TaxCode |
|
VAT difference
The value of Amount excl. VAT from the original voucher * Rate in the VAT rate table.
If you have manually changed the VAT amount in the voucher line before updating, this field shows the difference between "VAT amount" and what the VAT amount would have been, if unchanged
| 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 | VATDiff | The database field name. |
| API identifier | vatDifference | The API identifier used in GraphQL. |
| Number | 14623 |
VAT period from voucher date
VAT period within which the voucher date falls.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is 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 | TxTrmVoD | The database field name. |
| API identifier | taxTermFromVoucherDate | The API identifier used in GraphQL. |
| Number | 14586 |
VAT rate
The rate Business NXT used for the calculation of VAT.
The VAT rate is defined in the VAT rate table and derived from the VAT code, that relates to the VAT rate table.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Percent | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | VatRt | The database field name. |
| API identifier | vatRate | The API identifier used in GraphQL. |
| Number | 14620 |
VAT report no.
VAT report number on which the transaction has been reported.
- Transactions with a VAT-code
- Transactions related to transactions with a VAT-code
The VAT-report no will be deleted from transactions if a VAT-report is withdrawn with the processing Withdraw tax statement from the table Tax statement log.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | No. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | TxStNo | The database field name. |
| API identifier | taxStatementNo | The API identifier used in GraphQL. |
| Number | 14589 |
VAT term
VAT term is allocated to the voucher line during voucher entry.
The value date determines to which VAT term the transaction is allocated. The VAT terms are defined in the table VAT period. The field is only updated for transactions which have a turnover class. The VAT term field is the basis for VAT reports together with the VAT year field.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is 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 | TxTrm | The database field name. |
| API identifier | taxTerm | The API identifier used in GraphQL. |
| Number | 14585 |
VAT year
VAT year allocated to the voucher line during voucher entry.
The value date determines to which VAT year the transaction is allocated. The VAT years are defined in the table VAT period. The field is only updated for transactions which have a turnover class. The VAT year field is the basis for VAT reports together with the VAT term field.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is 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 | TxYr | The database field name. |
| API identifier | taxYear | The API identifier used in GraphQL. |
| Number | 14587 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| VAT period | TaxTerm |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. | |
| OSS VAT period | OssTaxTerm |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. |
VAT year from voucher date
VAT year within which the voucher date falls.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is 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 | TxYrVoD | The database field name. |
| API identifier | taxYearFromVoucherDate | The API identifier used in GraphQL. |
| Number | 14588 |
Visma ID
The ID of the scanned document.
Is used in connection with Visma Document Center.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | No. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | WfId | The database field name. |
| API identifier | vismaId | The API identifier used in GraphQL. |
| Number | 14771 |
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 | 14592 |
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 | Yes | This field is 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 | 14780 |
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 | Yes | This field is 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 | 14781 |
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 | Yes | This field is visible by default in the table display. |
| Domain | Journal no. | Integer |
| Primary key | Yes | Voucher jour. no., Audit no. |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | JNo | The database field name. |
| API identifier | voucherJournalNo | The API identifier used in GraphQL. |
| Number | 14559 |
| 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. |
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 | 14593 |
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 | 14594 |
| 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 | 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 | PmVaAmCD | The database field name. |
| API identifier | writeOffVarianceCashDiscountDomestic | The API identifier used in GraphQL. |
| Number | 14669 |
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 | Yes | This field is 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 | 14668 |
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 | 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. |
| 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 | 14670 |
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 | Yes | This field is 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 | 14677 |
W/off variance misc.
This field is no longer in use. Be aware the field may be removed in later versions.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Amount | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | PmVaAm | The database field name. |
| API identifier | writeOffVarianceMiscDomestic | The API identifier used in GraphQL. |
| Number | 14672 |
W/off variance misc. %
This field is no longer in use. Be aware the field may be removed in later versions.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | 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 | writeOffVarianceMiscPercent | The API identifier used in GraphQL. |
| Number | 14671 |
W/off variance misc. in currency
This field is no longer in use. Be aware the field may be removed in later versions.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Amount | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | PmVaCAm | The database field name. |
| API identifier | writeOffVarianceMiscInCurrency | The API identifier used in GraphQL. |
| Number | 14673 |
W/off variance misc. in EURO
This field is no longer in use. Be aware the field may be removed in later versions.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Amount | Decimal |
| Source column | W/off variance misc. 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 | writeOffVarianceMiscInEuro | The API identifier used in GraphQL. |
| Number | 14678 |
W/off variance total
This field is no longer in use. Be aware the field may be removed in later versions.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | 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 | writeOffVarianceTotalDomestic | The API identifier used in GraphQL. |
| Number | 14674 |
W/off variance total in currency
This field is no longer in use. Be aware the field may be removed in later versions.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | 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 | writeOffVarianceTotalInCurrency | The API identifier used in GraphQL. |
| Number | 14675 |
W/off variance total in EURO
This field is no longer in use. Be aware the field may be removed in later versions.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Amount | Decimal |
| Source column | W/off variance total 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 | writeOffVarianceTotalInEuro | The API identifier used in GraphQL. |
| Number | 14679 |
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 | Yes | This field is visible by default in the table display. |
| Domain | Web page | Text (260) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | WebPg | The database field name. |
| API identifier | webPage | The API identifier used in GraphQL. |
| Number | 14792 |
Withholding tax amount
Investment tax amount which Business NXT has calculated.
| 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 | WthAm | The database field name. |
| API identifier | withholdingTaxAmountDomestic | The API identifier used in GraphQL. |
| Number | 14629 |
Withholding tax rate
Tax rate which Business NXT has used as the basis for the calculation of withholding tax.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Percent | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | WthRt | The database field name. |
| API identifier | withholdingTaxRate | The API identifier used in GraphQL. |
| Number | 14628 |
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 | Yes | This field is 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 | 18980 |
Write off status
The write off status.
If you have not entered any thing in the Part payment field, or in the Maximum write off amount misc. or Maximum write off % misc. fields in the Company information table, the field will be blank. Visma Business enters 1 in the field when you enter a part payment amount and 3 if the variance lies within or outside the limits in the Company information table.
You can change it from 1 to 2 if you want to write off the variance yourself if it is within acceptable limits. You can also change it from 3 to 4 if you want to write off the variance yourself if it is outside that which Visma Business suggests is acceptable.
You can also change the values back again.
In the Access group table you can specify which user/user group is to have access to change the value from 3 to 4.
- 0 - No discrepancy
- 1 - Write off accepted variance
- 2 - No write off
- 3 - Difference o/s limit
- 4 - Write off variance o/s limit
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Write off status | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | WO | The database field name. |
| API identifier | writeOffStatus | The API identifier used in GraphQL. |
| Number | 14682 |
Year
The relevant accounting year for the transactions. The year is deducted from the value date.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is 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 | 14568 |
| 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. | |
| Customer balance | CustomerBalance |
| 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. | |
| General ledger balance | GeneralLedgerBalance |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. | |
| Capital asset balance | CapitalAssetBalance |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. | |
| General ledger balance/Organisational unit 1 | GeneralLedgerBalance1 |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. | |
| General ledger balance/Organisational unit 2 | GeneralLedgerBalance2 |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. | |
| General ledger balance/Organisational unit 3 | GeneralLedgerBalance3 |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. | |
| General ledger balance/Organisational unit 4 | GeneralLedgerBalance4 |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. | |
| General ledger balance/Organisational unit 5 | GeneralLedgerBalance5 |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. | |
| General ledger balance/Organisational unit 6 | GeneralLedgerBalance6 |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. | |
| General ledger balance/Organisational unit 7 | GeneralLedgerBalance7 |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. | |
| General ledger balance/Organisational unit 8 | GeneralLedgerBalance8 |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. | |
| General ledger balance/Organisational unit 9 | GeneralLedgerBalance9 |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. | |
| General ledger balance/Organisational unit 10 | GeneralLedgerBalance10 |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. | |
| General ledger balance/Organisational unit 11 | GeneralLedgerBalance11 |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. | |
| General ledger balance/Organisational unit 12 | GeneralLedgerBalance12 |
| 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. |