Open customer entry
This table contains customer entries that awaits matching or interest calculation.
| Property | Value | Description |
|---|---|---|
| Database | Company | This table is in the company databases. |
| SQL name | OpCustTr | The table name in the database. |
| API identifier | openCustomerEntry | The API identifier used in GraphQL. |
| Table no. | 52 | 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 | No | This field is not visible by default in the table display. |
| Domain | Percent | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | writeOffVariancePercent | The API identifier used in GraphQL. |
| Number | 8741 |
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 | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| SQL name | AcDPmtV | The database field name. |
| API identifier | writeOffVarianceAmountDomestic | The API identifier used in GraphQL. |
| Number | 8742 |
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 | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| SQL name | AcCPmtV | The database field name. |
| API identifier | writeOffVarianceAmountInCurrency | The API identifier used in GraphQL. |
| Number | 8739 |
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 | No | This field is not 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 | 8740 |
Account. year/period
The accounting year and accounting period saved as one field. This value can be used by external applications, e.g. reporting tools, to avoid having to merge the two fields accounting year and accounting period.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Year/Per. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | AcYrPr | The database field name. |
| API identifier | accountingYearAndPeriod | The API identifier used in GraphQL. |
| Number | 11018 |
Accounting document no.
The accounting document no refers to Incoming accounting document table.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | No. | Integer |
| Write Access | System supervisor user | Only users who are marked as System supervisor in the User table are allowed to modify the value in this field. |
| SQL name | InAcDocNo | The database field name. |
| API identifier | incomingAccountingDocumentNo | The API identifier used in GraphQL. |
| Number | 17956 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Accounting document | IncomingAccountingDocument |
|
Active approval task no.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Approval Task no. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | AcAppTskNo | The database field name. |
| API identifier | activeApprovalTaskNo | The API identifier used in GraphQL. |
| Number | 18967 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Approval task | ApprovalTask |
|
Additional text
Any additional information entered in the voucher.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Text | Text (200) |
| SQL name | Txt2 | The database field name. |
| API identifier | additionalText | The API identifier used in GraphQL. |
| Number | 5813 |
Amount
This is taken from vouchers. The preceding sign is reversed if the transaction concerns a credit account number.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Amount | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | Am | The database field name. |
| API identifier | amountDomestic | The API identifier used in GraphQL. |
| Number | 1124 |
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 | 1122 |
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 | 14303 |
Amount in EURO
The Amount field converted to EURO.
If the standard currency, given in the Company information table is defined as Currency type 2 or 3 in the Currency table, the Amount in EURO will be calculated with the exchange rate given for Euro in Sales rate field in the Currency table.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Source column | Amount in currency | Euro |
| Write Access | None | You are not allowed to modify the value in this field. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | amountInEuro | The API identifier used in GraphQL. |
| Number | 7716 |
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 | 18556 |
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 | 18813 |
Audit no.
Part of the records unique identification together with the Voucher jour. no.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Audit no. | Integer |
| Primary key | Yes | Voucher jour. no., Audit no. |
| SQL name | EntNo | The database field name. |
| API identifier | auditNo | The API identifier used in GraphQL. |
| Number | 1110 |
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 | 19612 |
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 | No | This field is not visible by default in the table display. |
| Domain | AutoPay payment reference | Text (100) |
| SQL name | ApPmtRef | The database field name. |
| API identifier | autopayPaymentReference | The API identifier used in GraphQL. |
| Number | 18207 |
Bank account
Updated from the Bank account field on the vouchers.
If you did not complete the field during entry, Visma Business will retrieve the giro number from the Bank account or Postal giro field for the relevant associate in the Associate table.
The value in the field is also transferred to the Payment line table when you create a payment suggestion.
This field is also used for IBAN bank account numbers, depending on the recipient's country. You must in some cases also complete the Bank branch and Swift code fields. Which fields you must complete depend on the recipients country requirements. You can contact your bank or supplier for more information about this.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Bank account | Text (35) |
| SQL name | BankG | The database field name. |
| API identifier | bankAccount | The API identifier used in GraphQL. |
| Number | 12369 |
Case user status
- 1 - Change due date
- 2 - Pause debt
- 3 - Cancel pause
- 9 - Close debt
- 10 - Approve for debt collection
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Case user status | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | DColUsrSt | The database field name. |
| API identifier | caseUserStatus | The API identifier used in GraphQL. |
| Number | 18839 |
Cash amount
Comes from vouchers or is calculated on the basis of the Payment terms.
If no cash amount is entered on the voucher line, but a payment term with a cash discount has been entered, the cash amount will be calculated during the update and inserted on this record
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| SQL name | CshAm | The database field name. |
| API identifier | cashAmountDomestic | The API identifier used in GraphQL. |
| Number | 4954 |
Cash amount in currency
Comes from the Voucher or is calculated on the basis of the Payment terms.
If no Cash amount is entered on the Voucher line, but a payment term with a cash discount has been entered, the cash amount will be calculated during the update and inserted on this record
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| SQL name | CshCurAm | The database field name. |
| API identifier | cashAmountInCurrency | The API identifier used in GraphQL. |
| Number | 4953 |
Cash amount in EURO
Comes from vouchers or is calculated on the basis of the Payment terms.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Source column | Cash amount in currency | Euro |
| Write Access | None | You are not allowed to modify the value in this field. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | cashAmountInEuro | The API identifier used in GraphQL. |
| Number | 7730 |
Cash due date
Comes from vouchers.
If you have not entered the cash due date on an invoice, it is calculated on the basis of the Voucher date and Payment terms if the Payment terms carries a cash discount %.
The date is validated using the regional settings in Windows.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Date | Integer |
| SQL name | CshDueDt | The database field name. |
| API identifier | cashDueDate | The API identifier used in GraphQL. |
| Number | 4952 |
CID code
Code used for electronic funds transfer.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | CID code | Text (30) |
| SQL name | CID | The database field name. |
| API identifier | cid | The API identifier used in GraphQL. |
| Number | 11589 |
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 | 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 | ClIntAm | The database field name. |
| API identifier | clientInterestAmountDomestic | The API identifier used in GraphQL. |
| Number | 11224 |
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 | 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 | ClIntCAm | The database field name. |
| API identifier | clientInterestAmountInCurrency | The API identifier used in GraphQL. |
| Number | 11222 |
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 | No | This field is not 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 | 11223 |
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 | 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 | ClIntFrD | The database field name. |
| API identifier | clientInterestFromDate | The API identifier used in GraphQL. |
| Number | 11220 |
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 | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| SQL name | ClSugAm | The database field name. |
| API identifier | clientInterestProposalAmountDomestic | The API identifier used in GraphQL. |
| Number | 13083 |
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 | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| SQL name | ClSugCAm | The database field name. |
| API identifier | clientInterestProposalAmountInCurrency | The API identifier used in GraphQL. |
| Number | 13081 |
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 | No | This field is not 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 | 13082 |
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 | No | This field is not visible by default in the table display. |
| Domain | Date | Integer |
| SQL name | ClSugFrD | The database field name. |
| API identifier | clientInterestProposalFromDate | The API identifier used in GraphQL. |
| Number | 13079 |
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 | No | This field is not visible by default in the table display. |
| Domain | Date | Integer |
| SQL name | ClSugToD | The database field name. |
| API identifier | clientInterestProposalToDate | The API identifier used in GraphQL. |
| Number | 13080 |
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 | 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 | ClIntToD | The database field name. |
| API identifier | clientInterestToDate | The API identifier used in GraphQL. |
| Number | 11221 |
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 | No | This field is not 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 | 8434 |
Control status
Can be used by the user to give the record a freely definable status, for selecting during reporting / analysis routines.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Control status/Accounting trans. | Integer |
| SQL name | Ctrl | The database field name. |
| API identifier | controlStatus | The API identifier used in GraphQL. |
| Number | 3543 |
Country no.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Country no. | Integer |
| SQL name | Ctry | The database field name. |
| API identifier | countryNo | The API identifier used in GraphQL. |
| Number | 17529 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Country | Country |
|
Credit
Defines that the amount is < 0.
The field can be used for selection of credit amounts. Eg for reporting and analysis purposes
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Boolean | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | Cr | The database field name. |
| API identifier | credit | The API identifier used in GraphQL. |
| Number | 4810 |
Credit amount
The absolute value of the Amount The field is updated only if the Amount is negative.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Source column | Amount | Credit |
| Write Access | None | You are not allowed to modify the value in this field. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | creditAmountDomestic | The API identifier used in GraphQL. |
| Number | 4606 |
Credit amount in currency
The absolute value of the Amount in currency. The field is updated only if the Amount in currency is negative.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Source column | Amount in currency | Credit |
| Write Access | None | You are not allowed to modify the value in this field. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | creditAmountInCurrency | The API identifier used in GraphQL. |
| Number | 4602 |
Credit amount in EURO
The absolute value of the Amount in EURO. The field is updated only if the Amount in EURO is negative.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Source column | Credit amount in currency | Euro |
| Write Access | None | You are not allowed to modify the value in this field. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | creditAmountInEuro | The API identifier used in GraphQL. |
| Number | 7718 |
Credit outstanding amount
The absolute value of the Outstanding amount field. The field is updated only if the Outstanding amount is negative.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Source column | Outstanding amount | Credit |
| Write Access | None | You are not allowed to modify the value in this field. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | creditOutstandingAmountDomestic | The API identifier used in GraphQL. |
| Number | 4608 |
Credit outstanding amount in currency
The absolute value of the Outstanding amount in currency field. The field is updated only if the Outstanding amount in currency is negative.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Source column | Outstanding amount in currency | Credit |
| Write Access | None | You are not allowed to modify the value in this field. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | creditOutstandingAmountInCurrency | The API identifier used in GraphQL. |
| Number | 4604 |
Credit outstanding amount in EURO
The absolute value of the Outstanding amount in EURO field. The field is updated only if the Outstanding amount in EURO is negative.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Source column | Credit outstanding amount in currency | Euro |
| Write Access | None | You are not allowed to modify the value in this field. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | creditOutstandingAmountInEuro | The API identifier used in GraphQL. |
| Number | 7721 |
Credit quantity
The absolute value of the Quantity field. The field is updated only if the Amount field is negative.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Quantity | Decimal |
| Source column | Quantity | Credit |
| Write Access | None | You are not allowed to modify the value in this field. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | creditQuantity | The API identifier used in GraphQL. |
| Number | 4618 |
Credited amount
The field is not in use.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | CNAm | The database field name. |
| API identifier | creditedAmountDomestic | The API identifier used in GraphQL. |
| Number | 8470 |
Cross reference
You use this field to match an invoice against payments or credit notes.
The cross reference can be entered in the Cross reference field on the voucher and will update this field on customer transactions, open customer entries, supplier transactions and open supplier entries.
If a cross reference has been entered on a voucher, this voucher will match against the open supplier entry or an open customer entry with the same value in its reference field.
The cross reference can also be entered or overridden direct in the Open supplier entry or the Open supplier entry table, to complete the entries before running the Match references processing in these tables.
The Cross reference field in the Customer transaction table and the Supplier transaction table will show the reference of the open entry to which the transaction was matched, but only if the matching was performed by running the processing Match entry-for-entry.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Doc. no. | Text (40) |
| SQL name | AgRef | The database field name. |
| API identifier | crossReference | The API identifier used in GraphQL. |
| Number | 1131 |
Cross-account no.
The cross account no that existed on the original voucher line.
If postings are made to both debit and credit accounts in the same voucher line, the Cross-account no. and Cross-account type fields indicate the customer, supplier, Capital assetor General ledger accountaccount relating to the other transaction generated from the voucher line.
If the Posting errors account from the Company information table has been used, because the original account is non-existent, the Cross-account no. and Cross-account type fields indicate instead the customer, supplier, Capital asset or General ledger account to which you attempted to post the voucher.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Account no. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | AgAcNo | The database field name. |
| API identifier | crossAccountNo | The API identifier used in GraphQL. |
| Number | 4354 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Associate | CrossCustomer |
| ||
| Associate | CrossSupplier |
| ||
| General ledger account | CrossGeneralLedgerAccount |
| ||
| Capital asset | CrossCapitalAsset |
|
Cross-account type
The cross account no that existed on the original voucher line.
If postings are made to both debit and credit accounts in the same voucher line, the Cross-account no. and Cross-account type fields indicate the customer, supplier, Capital asset or General ledger account account relating to the other transaction.
If the Posting errors account from the Company information table has been used, because the original account is non-existent, the Cross-account no. and Cross-account type fields indicate instead the customer, supplier, Capital asset or General ledger account to which you attempted to post the voucher.
- 1 - Customer
- The account number refer to a customer.
- 2 - Supplier
- The account number refer to a supplier.
- 3 - General ledger account
- The account number refer to a general ledger account.
- 4 - Capital asset
- The account number refer to a capital asset.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Account type | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | AgAcCl | The database field name. |
| API identifier | crossAccountType | The API identifier used in GraphQL. |
| Number | 4353 |
Curr. corr. amount
The product of the most recent Curr. corr. exch. rate and the amount.
The field originally contains the same value as the Outstanding amount, or the Posted amount field if the correction is run on General ledger transaction or Capital asset transaction.
Each time the Currency correction processing is run, the field will be updated with the product of Curr. corr. exch. rate and Outstanding amount in currency or the Amount in currency if the correction is run on General ledger transaction or Capital asset transaction.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| SQL name | CurCAm | The database field name. |
| API identifier | currencyCorrectionAmount | The API identifier used in GraphQL. |
| Number | 11913 |
Curr. corr. date
The date for the last run of the Currency correction processing.
If no exchange rate adjustment has been performed, the field shows the same value as the Value date field.
The date is validated using the regional settings in Windows.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Date | Integer |
| SQL name | CurCDt | The database field name. |
| API identifier | currencyCorrectionDate | The API identifier used in GraphQL. |
| Number | 11914 |
Curr. corr. exch. rate
The Curr. corr. exch. rate from the latest run of the currency correction processing.
The field is updated when you run the Transfer corrections to table processing from the Currency correction data table. If no exchange rate adjustment has ever been performed, the field shows the same value as the Exchange rate field, which is inherited from the voucher.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Exchange rate | Decimal |
| SQL name | CurCExRt | The database field name. |
| API identifier | currencyCorrectionExchangeRate | The API identifier used in GraphQL. |
| Number | 11912 |
Curr. corr. run no.
A unique number identifying the last run of the Currency correction processing.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | No. | Integer |
| SQL name | CurCRNo | The database field name. |
| API identifier | currencyCorrectionRunNo | The API identifier used in GraphQL. |
| Number | 11915 |
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 | 1120 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Currency | Currency |
|
Currency no. 2
The records currency no 2 number, which is inherited from the voucher.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Currency no. | Integer |
| SQL name | Cur2 | The database field name. |
| API identifier | currencyNo2 | The API identifier used in GraphQL. |
| Number | 14301 |
| 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 | 1111 |
Date 1
Used by some bank reconciliation systems to assign a date to processed transactions.
If the field is already filled in, the value is overwritten by the bank reconciliation system. If bank reconciliation is not in use the field can be used manually.
The date is validated using the regional settings in Windows.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Date | Integer |
| SQL name | Dt1 | The database field name. |
| API identifier | date1 | The API identifier used in GraphQL. |
| Number | 11087 |
Date 2
Used by some bank reconciliation systems to assign a date to processed transactions.
If the field is already filled in, the value is overwritten by the bank reconciliation system. If bank reconciliation is not in use the field can be used manually.
The date is validated using the regional settings in Windows.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Date | Integer |
| SQL name | Dt2 | The database field name. |
| API identifier | date2 | The API identifier used in GraphQL. |
| Number | 11088 |
Debit amount
The value of the Amount field. The field is updated only if the Amount is positive.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Source column | Amount | Debit |
| Write Access | None | You are not allowed to modify the value in this field. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | debitAmountDomestic | The API identifier used in GraphQL. |
| Number | 4605 |
Debit amount in currency
The value of the Amount in currency. The field is updated only if the Amount in currency is positive.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Source column | Amount in currency | Debit |
| Write Access | None | You are not allowed to modify the value in this field. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | debitAmountInCurrency | The API identifier used in GraphQL. |
| Number | 4601 |
Debit amount in EURO
The value of the Amount in EURO. The field is updated only if the Amount in EURO is positive.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Source column | Debit amount in currency | Euro |
| Write Access | None | You are not allowed to modify the value in this field. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | debitAmountInEuro | The API identifier used in GraphQL. |
| Number | 7717 |
Debit outstanding amount
The value of the Outstanding amount field. The field is updated only if the Outstanding amount is positive.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Source column | Outstanding amount | Debit |
| Write Access | None | You are not allowed to modify the value in this field. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | debitOutstandingAmountDomestic | The API identifier used in GraphQL. |
| Number | 4607 |
Debit outstanding amount in currency
The value of the Outstanding amount in currency field. The field is updated only if the Outstanding amount in currency is positive.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Source column | Outstanding amount in currency | Debit |
| Write Access | None | You are not allowed to modify the value in this field. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | debitOutstandingAmountInCurrency | The API identifier used in GraphQL. |
| Number | 4603 |
Debit outstanding amount in EURO
The value of the Outstanding amount in EURO field. The field is updated only if the Outstanding amount in EURO is positive.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Source column | Debit outstanding amount in currency | Euro |
| Write Access | None | You are not allowed to modify the value in this field. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | debitOutstandingAmountInEuro | The API identifier used in GraphQL. |
| Number | 7720 |
Debit quantity
The value of the Quantity field. The field is updated only if the Amount field is positive.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Quantity | Decimal |
| Source column | Quantity | Debit |
| Write Access | None | You are not allowed to modify the value in this field. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | debitQuantity | The API identifier used in GraphQL. |
| Number | 4617 |
Debt collection approval
- 0 - No action required
- 1 - Suggested
- 2 - Approved
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Debt collection approval | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | DColLst | The database field name. |
| API identifier | debtCollectionApproval | The API identifier used in GraphQL. |
| Number | 18835 |
Debt collection case no.
The debt collection company's case no.
The case no from the debt collection company will be updated when the debt collection company's web portal responds after Open customer entry has been exported to the debt collection company.
| 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 | DColCNo | The database field name. |
| API identifier | debtCollectionCaseNo | The API identifier used in GraphQL. |
| Number | 18832 |
Debt collection case type
The debt collection company's case type.
An "x" in the field indicates that the Open customer entry is subject to debt collection. If blank, indicates that the Open customer entry is subject to reminder process.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Boolean | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | DColCT | The database field name. |
| API identifier | debtCollectionCaseType | The API identifier used in GraphQL. |
| Number | 18833 |
Debt collection ID
A unique ID for the invoice.
The field contains a GUID value generated by Visma Business when running the processing Send to AutoCollect. The value follows the Open customer entry to the debt collection company.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | GUID | Text (40) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | DColId | The database field name. |
| API identifier | debtCollectId | The API identifier used in GraphQL. |
| Number | 18991 |
Debt collection last updated date
Date for the last update.
Date when the Open customer entry row was updated from the debt collection company.
The date is validated using the regional settings in Windows.
| 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 | DColLUDt | The database field name. |
| API identifier | debtCollectionLastUpdatedDate | The API identifier used in GraphQL. |
| Number | 18830 |
Debt collection last updated time
Time for the last update.
Time when row was updated from the debt collection company.
| 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 | DColLUTm | The database field name. |
| API identifier | debtCollectionLastUpdatedTime | The API identifier used in GraphQL. |
| Number | 18831 |
Debt collection matching acknowledgement
Response message from the debt collection company.
Response message from the debt collection company after matching amount against Open customer entry subject to debt collection by the debt collection company.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not 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 | DColMR | The database field name. |
| API identifier | debtCollectMatchingAcknowledgement | The API identifier used in GraphQL. |
| Number | 18846 |
Debt collection matching amount
Amount to be matched against Open customer entry subject to debt collection.
Amount in standard currency that has been remitted and processed in Visma Business and shall be matched against the Open customer entry subject to debt collection by the debt collection company.
| 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 | DColMAm | The database field name. |
| API identifier | debtCollectMatchingAmountDomestic | The API identifier used in GraphQL. |
| Number | 18845 |
Debt collection matching sent date
Date when amount to be matched was sent to Visma AutoCollect.
The date is validated using the regional settings in Windows.
| 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 | DColMSDt | The database field name. |
| API identifier | debtCollectMatchingSentDate | The API identifier used in GraphQL. |
| Number | 18843 |
Debt collection matching sent time
Time when amount to be matched was sent to Visma AutoCollect.
| 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 | DColMSTm | The database field name. |
| API identifier | debtCollectMatchingSentTime | The API identifier used in GraphQL. |
| Number | 18844 |
Debt collection outstanding fee in currency
The debt collection company's fee.
The field contains the unpaid/remaining fee amount debited by the debt collection company.
| 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 | DColFeeCur | The database field name. |
| API identifier | debtCollectionOutstandingFeeInCurrency | The API identifier used in GraphQL. |
| Number | 19139 |
Debt collection outstanding interest in currency
Accrued interest for the invoice.
The field contains the unpaid/remaining interest amount calculated and debited by the debt collection company.
| 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 | DColIntCur | The database field name. |
| API identifier | debtCollectionOutstandingInterestInCurrency | The API identifier used in GraphQL. |
| Number | 19138 |
Debt collection response status
Contains response from the debt collection company.
The values in this field are given by the debt collection company after using the processing Send to AutoCollect or Change debt collection status.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not 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 | DColRSt | The database field name. |
| API identifier | debtCollectionResponseStatus | The API identifier used in GraphQL. |
| Number | 18829 |
Debt collection rest amount
The Outstanding amount in standard currency for the invoice.
The Outstanding amount also contains accrued Interest amount calculated by the debt collection company.
| 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 | DColRAm | The database field name. |
| API identifier | debtCollectionRestAmountDomestic | The API identifier used in GraphQL. |
| Number | 18836 |
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 | No | This field is not visible by default in the table display. |
| Domain | No. | Integer |
| SQL name | LegRRNo | The database field name. |
| API identifier | debtCollectionRunNo | The API identifier used in GraphQL. |
| Number | 11865 |
Debt collection sent date
Date when the invoice was sent to debt collection company.
Date when Open customer entry was sent to debt collection company with the Send to AutoCollect processing.
The date is validated using the regional settings in Windows.
| 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 | DColSDt | The database field name. |
| API identifier | debtCollectionSentDate | The API identifier used in GraphQL. |
| Number | 18827 |
Debt collection sent time
Time when the invoice was sent to debt collection company.
Time when Open customer entry was sent to debt collection company with the Send to AutoCollect processing.
| 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 | DColSTm | The database field name. |
| API identifier | debtCollectionSentTime | The API identifier used in GraphQL. |
| Number | 18828 |
Debt collection status
The status of the case at the debt collection company.
Possible statuses are given by the debt collection agency and will be updated from debt collection agency when running the Retrieve AutoCollect information processing.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not 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 | DColSt | The database field name. |
| API identifier | debtCollectionStatus | The API identifier used in GraphQL. |
| Number | 18834 |
Debt collection status sent date
Date when user status was sent to Visma AutoCollect.
The date is validated using the regional settings in Windows.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Date | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | DColUsrSDt | The database field name. |
| API identifier | debtCollectUserStatusSentDate | The API identifier used in GraphQL. |
| Number | 18840 |
Debt collection status sent time
Time when user status was sent to Visma AutoCollect.
| 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 | DColUsrSTm | The database field name. |
| API identifier | debtCollectUserStatusSentTime | The API identifier used in GraphQL. |
| Number | 18841 |
Debt collection user acknowledgement
Response message from Visma AutoCollect for the user.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not 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 | DColUsrR | The database field name. |
| API identifier | debtCollectUserAcknowledgement | The API identifier used in GraphQL. |
| Number | 18842 |
Debt collection validation status
Shows eventual errors that can have occurred when transferring invoices to debt collection company with the Send to AutoCollect processing.
- Conditions on the Open customer entry line is missing or invalid
- Conditions in the Debt collection agreement is not met
- Conditions for the customer in the Associate table is not met
- Already sent to AutoCollect
- Invoice free of reminders
- Sent to debt collection
- Invoice exempt from debt collection
- Not within the days of grace in the debt collection agreement
- Outstanding amount in currency for the invoice is not greater than 0
- Outstanding amount for the invoice is not within the minimum amount in the debt collection agreement
- No. of reminders sent not 0
- No. of reminders sent not greater than 0
- No. of reminders sent in debt collection agreement not fulfilled
- Cannot find customer in Associate table
- Customer exempt from debt collection
- Customer is free of reminders
- Cannot find name on customer in Associate table
- Cannot find post code on customer in Associate table
- Cannot find postal area on customer in Associate table
- Voucher type is empty
- Cannot find voucher type in voucher type table
- Debt collection voucher type is empty on voucher type
- Current customer balance is less than or equal to zero
- Not sent to AutoCollect because unmatched payments or credit notes
- Cannot find person ID on customer in Associate table
- Cannot find organisation no. on customer in Associate table
- Debt collection voucher type is not set as an invoice
- Debt collection voucher type has multiple selections that are illegal
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Debt collection validation status | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | DColValSt | The database field name. |
| API identifier | debtCollectionValidationStatus | The API identifier used in GraphQL. |
| Number | 18996 |
Delivery associate no.
This field is updated from the vouchers.
The receiver of the products. It will only have a value if the receiver of the product is different from the receiver of the invoice.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Associate no. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | DelActNo | The database field name. |
| API identifier | deliveryAssociateNo | The API identifier used in GraphQL. |
| Number | 8893 |
| 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 | No | This field is not visible by default in the table display. |
| Domain | No. | Integer |
| SQL name | DebRnNo | The database field name. |
| API identifier | directDebitingRunNo | The API identifier used in GraphQL. |
| Number | 5511 |
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 |
| SQL name | DueDt | The database field name. |
| API identifier | dueDate | The API identifier used in GraphQL. |
| Number | 1126 |
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 | No | This field is not visible by default in the table display. |
| Domain | Empl. no. | Integer |
| SQL name | EmpNo | The database field name. |
| API identifier | employeeNo | The API identifier used in GraphQL. |
| Number | 3071 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Associate | Employee |
|
Error message
Any errors detected during a batch update.
If several errors are detected, they are listed with a comma separating them.
- Illegal value date
- Unknown organisational unit 1
- Unknown organisational unit 2
- Unknown organisational unit 3
- Unknown organisational unit 4
- Unknown organisational unit 5
- Unknown organisational unit 6
- Unknown debit account, Cust. no., Account no. or Cap. asset no.
- Unknown credit account, Cust. no., Account no. or Cap. asset no.
- Unknown debit VAT code or VAT code
- Unknown credit VAT code or VAT code
- Unknown debit VAT rate
- Unknown credit VAT rate
- Unknown debit investment tax
- Unknown credit investment tax
- Unknown debit payment terms
- Unknown credit payment terms
- Unknown distribution key
- Illegal debit turnover cl. or Turnover class
- Illegal credit turnover cl. or Turnover class
- Missing credit turnover cl. or Turnover class
- The grace period for the debit has exceeded
- The grace period for the credit has exceeded
- Unknown organisational unit 7
- Unknown organisational unit 8
- Unknown organisational unit 9
- Unknown organisational unit 10
- Unknown organisational unit 11
- Unknown organisational unit 12
- Missing accounting period
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Error message | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | Err | The database field name. |
| API identifier | errorMessage | The API identifier used in GraphQL. |
| Number | 1150 |
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 | 1121 |
Exchange rate 2
The exchange rate for currency 2.
Is updated from the Voucher table.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Exchange rate | Decimal |
| SQL name | ExRt2 | The database field name. |
| API identifier | exchangeRate2 | The API identifier used in GraphQL. |
| Number | 14302 |
External reference 1
Used by some bank reconciliation system to show processed transactions.
If the field is already filled in, the value is overwritten by the bank reconciliation system. The value is updated from Voucher. If a bank reconciliation system is not in use the field can be used manually.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | String of length 20 | Text (20) |
| SQL name | ExtRef1 | The database field name. |
| API identifier | externalReference1 | The API identifier used in GraphQL. |
| Number | 11085 |
External reference 2
Used by some bank reconciliation system to show processed transactions.
If the field is already filled in, the value is overwritten by the bank reconciliation system. The value is updated from Voucher. If a bank reconciliation system is not in use the field can be used manually.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | String of length 20 | Text (20) |
| SQL name | ExtRef2 | The database field name. |
| API identifier | externalReference2 | The API identifier used in GraphQL. |
| Number | 11086 |
External reference 3
Used by some bank reconciliation system to show processed transactions.
If the field is already filled in, the value is overwritten by the bank reconciliation system. The value is updated from Voucher. If a bank reconciliation system is not in use the field can be used manually.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | String of length 20 | Text (20) |
| SQL name | ExtRef3 | The database field name. |
| API identifier | externalReference3 | The API identifier used in GraphQL. |
| Number | 12794 |
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 | No | This field is not visible by default in the table display. |
| Domain | No. | Integer |
| SQL name | FactRNo | The database field name. |
| API identifier | factoringRunNo | The API identifier used in GraphQL. |
| Number | 7829 |
Fixed amount
A fraction of the Amount from which no cash discount shall be deducted.
The fixed amount is given on the voucher and can contain of eg freight, packaging, insurance or other parts of the total invoice amount from which no cash discount shall be deducted.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| SQL name | FixAm | The database field name. |
| API identifier | fixedAmountDomestic | The API identifier used in GraphQL. |
| Number | 6241 |
Fixed amount in currency
A fraction of the Amount in currency from which no cash discount shall be deducted.
The fixed amount in currency is given on the voucher and can contain of eg freight, packaging, insurance or other parts of the total invoice amount from which no cash discount shall be deducted.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| SQL name | FixCurAm | The database field name. |
| API identifier | fixedAmountInCurrency | The API identifier used in GraphQL. |
| Number | 6240 |
Fixed amount in EURO
A fraction of the Amount in EURO from which no cash discount shall be deducted.
The fixed Amount in EURO is derived from the fixed Amount in currency
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Source column | Fixed amount in currency | Euro |
| Write Access | None | You are not allowed to modify the value in this field. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | fixedAmountInEuro | The API identifier used in GraphQL. |
| Number | 7731 |
Free 1
Additional numeric information about the transaction.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Quantity | Decimal |
| SQL name | Free1 | The database field name. |
| API identifier | free1 | The API identifier used in GraphQL. |
| Number | 9139 |
Free 2
Additional numeric information about the transaction.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Quantity | Decimal |
| SQL name | Free2 | The database field name. |
| API identifier | free2 | The API identifier used in GraphQL. |
| Number | 9140 |
Free 3
Additional numeric information about the transaction.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Quantity | Decimal |
| SQL name | Free3 | The database field name. |
| API identifier | free3 | The API identifier used in GraphQL. |
| Number | 9141 |
Free 4
Additional numeric information about the transaction.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Quantity | Decimal |
| SQL name | Free4 | The database field name. |
| API identifier | free4 | The API identifier used in GraphQL. |
| Number | 9142 |
GL account
The General ledger account in which the transaction has been accumulated.
- The Associate table for the specific associate.
- The Account no. series table.
- The Company information table.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Account no. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | GenAcNo | The database field name. |
| API identifier | generalLedgerAccountNo | The API identifier used in GraphQL. |
| Number | 1149 |
| 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 | 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 | IntAm | The database field name. |
| API identifier | interestAmountDomestic | The API identifier used in GraphQL. |
| Number | 1134 |
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 | 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 | CurIntAm | The database field name. |
| API identifier | interestAmountInCurrency | The API identifier used in GraphQL. |
| Number | 1964 |
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 | No | This field is not 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 | 7728 |
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 | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| SQL name | FreeAm | The database field name. |
| API identifier | interestFreeAmountDomestic | The API identifier used in GraphQL. |
| Number | 11603 |
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 | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| SQL name | FreeCurA | The database field name. |
| API identifier | interestFreeAmountInCurrency | The API identifier used in GraphQL. |
| Number | 11604 |
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 | No | This field is not 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 | 11602 |
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 | No | This field is not visible by default in the table display. |
| Domain | Date | Integer |
| SQL name | IntFrDt | The database field name. |
| API identifier | interestFromDate | The API identifier used in GraphQL. |
| Number | 2243 |
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 | No | This field is not visible by default in the table display. |
| Domain | Percent | Decimal |
| SQL name | IntRt | The database field name. |
| API identifier | interestRate | The API identifier used in GraphQL. |
| Number | 1139 |
Interest this run
Shows how much interest has been calculated for an entry on this run.
| 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 | interestThisRunDomestic | The API identifier used in GraphQL. |
| Number | 11956 |
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 | 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 | interestThisRunInCurrency | The API identifier used in GraphQL. |
| Number | 11957 |
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 | No | This field is not 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 | 11958 |
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 | No | This field is not visible by default in the table display. |
| Domain | Date | Integer |
| SQL name | IntToDt | The database field name. |
| API identifier | interestToDate | The API identifier used in GraphQL. |
| Number | 1135 |
Invoice currency amount
The amount in the invoice currency on printouts.
Only relevant on payments where the currency differ from the currency on the matched invoice.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | invoiceAmountInCurrency | The API identifier used in GraphQL. |
| Number | 4487 |
Invoice no.
The invoice number from the Voucher.
Will be updated with voucher number if there is no invoice number on the voucher and you have selected Affects turn./purch. 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) |
| SQL name | InvoNo | The database field name. |
| API identifier | invoiceNo | The API identifier used in GraphQL. |
| Number | 1128 |
Last curr. corr. amount
The last recalculated amount from the Currency correction processing.
The field will equal the Amount field if no Currency correction processing has been performed.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| SQL name | LastCAm | The database field name. |
| API identifier | lastCurrencyCorrectionAmount | The API identifier used in GraphQL. |
| Number | 11962 |
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 | No | This field is not visible by default in the table display. |
| Domain | Date | Integer |
| SQL name | RemRnNo | The database field name. |
| API identifier | lastReminderDate | The API identifier used in GraphQL. |
| Number | 1140 |
Memo file name
The file name for the Memo attached to the Customer transaction.
On the Editing menu, click Memo to create a new memo or to view the existing memo. The memo file name is saved in this text box.
Double-click or press * to open the Select file dialog box to manually select a memo file.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Memo file name | Text (260) |
| SQL name | NoteNm | The database field name. |
| API identifier | memoFileName | The API identifier used in GraphQL. |
| Number | 4355 |
Memo no.
Link to the memo for the entry.
The actual memo is stored in the Memo table.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Memo no. | Integer |
| SQL name | MemoNo | The database field name. |
| API identifier | memoNo | The API identifier used in GraphQL. |
| Number | 19205 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Memo | Memo |
|
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 | No | This field is not visible by default in the table display. |
| Domain | Boolean | Integer |
| SQL name | ExcInt | The database field name. |
| API identifier | noInterest | The API identifier used in GraphQL. |
| Number | 1138 |
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 | No | This field is not visible by default in the table display. |
| Domain | No reminders | Integer |
| SQL name | ExcRem | The database field name. |
| API identifier | noReminders | The API identifier used in GraphQL. |
| Number | 1137 |
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 | No | This field is not visible by default in the table display. |
| Domain | Number of reminders | Integer |
| SQL name | Rems | The database field name. |
| API identifier | noOfRemindersSent | The API identifier used in GraphQL. |
| Number | 1136 |
Order no.
Is updated from the Voucher.
The number of the Order from which the transaction has its origin.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Order no. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | OrdNo | The database field name. |
| API identifier | orderNo | The API identifier used in GraphQL. |
| Number | 3363 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Order | Order |
|
Organisational unit 1
The organisational unit you entered in vouchers, possibly via the distribution key in vouchers.
Organisational units fields can be used freely according to company needs to split accounting, sales and purchases into organisational units. The most common types are department, project and campaign. It is also possible to limit the organisational units a user should see by limiting the organisational units in the Limitation groups, User limitation groups and Limitations. The field appear with the name assigned to it in the Company information table.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Organisational unit no. | Integer |
| SQL name | R1 | The database field name. |
| API identifier | orgUnit1 | The API identifier used in GraphQL. |
| Number | 1141 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 1 | OrgUnit1 |
|
Organisational unit 2
The organisational unit you entered in vouchers, possibly via the distribution key in vouchers.
Organisational units fields can be used freely according to company needs to split accounting, sales and purchases into organisational units. The most common types are department, project and campaign. It is also possible to limit the organisational units a user should see by limiting the organisational units in the Limitation groups, User limitation groups and Limitations. The field appear with the name assigned to it in the Company information table.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Organisational unit no. | Integer |
| SQL name | R2 | The database field name. |
| API identifier | orgUnit2 | The API identifier used in GraphQL. |
| Number | 1142 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 2 | OrgUnit2 |
|
Organisational unit 3
The organisational unit you entered in vouchers, possibly via the distribution key in vouchers.
Organisational units fields can be used freely according to company needs to split accounting, sales and purchases into organisational units. The most common types are department, project and campaign. It is also possible to limit the organisational units a user should see by limiting the organisational units in the Limitation groups, User limitation groups and Limitations. The field appear with the name assigned to it in the Company information table.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Organisational unit no. | Integer |
| SQL name | R3 | The database field name. |
| API identifier | orgUnit3 | The API identifier used in GraphQL. |
| Number | 1143 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 3 | OrgUnit3 |
|
Organisational unit 4
The organisational unit you entered in vouchers, possibly via the distribution key in vouchers.
Organisational units fields can be used freely according to company needs to split accounting, sales and purchases into organisational units. The most common types are department, project and campaign. It is also possible to limit the organisational units a user should see by limiting the organisational units in the Limitation groups, User limitation groups and Limitations. The field appear with the name assigned to it in the Company information table.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Organisational unit no. | Integer |
| SQL name | R4 | The database field name. |
| API identifier | orgUnit4 | The API identifier used in GraphQL. |
| Number | 1144 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 4 | OrgUnit4 |
|
Organisational unit 5
The organisational unit you entered in vouchers, possibly via the distribution key in vouchers.
Organisational units fields can be used freely according to company needs to split accounting, sales and purchases into organisational units. The most common types are department, project and campaign. It is also possible to limit the organisational units a user should see by limiting the organisational units in the Limitation groups, User limitation groups and Limitations. The field appear with the name assigned to it in the Company information table.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Organisational unit no. | Integer |
| SQL name | R5 | The database field name. |
| API identifier | orgUnit5 | The API identifier used in GraphQL. |
| Number | 1145 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 5 | OrgUnit5 |
|
Organisational unit 6
The organisational unit you entered in vouchers, possibly via the distribution key in vouchers.
Organisational units fields can be used freely according to company needs to split accounting, sales and purchases into organisational units. The most common types are department, project and campaign. It is also possible to limit the organisational units a user should see by limiting the organisational units in the Limitation groups, User limitation groups and Limitations. The field appear with the name assigned to it in the Company information table.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Organisational unit no. | Integer |
| SQL name | R6 | The database field name. |
| API identifier | orgUnit6 | The API identifier used in GraphQL. |
| Number | 1146 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 6 | OrgUnit6 |
|
Organisational unit 7
The organisational unit you entered in vouchers, possibly via the distribution key in vouchers.
The field appear with the name assigned to it in the Company information table.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Long alphanumeric organisational unit no. | Text (40) |
| SQL name | R7 | The database field name. |
| API identifier | orgUnit7 | The API identifier used in GraphQL. |
| Number | 9414 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 7 | OrgUnit7 |
|
Organisational unit 8
The organisational unit you entered in vouchers, possibly via the distribution key in vouchers.
The field appear with the name assigned to it in the Company information table.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Short alphanumeric organisational unit no. | Text (10) |
| SQL name | R8 | The database field name. |
| API identifier | orgUnit8 | The API identifier used in GraphQL. |
| Number | 9415 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 8 | OrgUnit8 |
|
Organisational unit 9
The organisational unit you entered in vouchers, possibly via the distribution key in vouchers.
The field appear with the name assigned to it in the Company information table.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Short alphanumeric organisational unit no. | Text (10) |
| SQL name | R9 | The database field name. |
| API identifier | orgUnit9 | The API identifier used in GraphQL. |
| Number | 9416 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 9 | OrgUnit9 |
|
Organisational unit 10
The organisational unit you entered in vouchers, possibly via the distribution key in vouchers.
The field appear with the name assigned to it in the Company information table.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Short alphanumeric organisational unit no. | Text (10) |
| SQL name | R10 | The database field name. |
| API identifier | orgUnit10 | The API identifier used in GraphQL. |
| Number | 9417 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 10 | OrgUnit10 |
|
Organisational unit 11
The organisational unit you entered in vouchers, possibly via the distribution key in vouchers.
The field appear with the name assigned to it in the Company information table.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Short alphanumeric organisational unit no. | Text (10) |
| SQL name | R11 | The database field name. |
| API identifier | orgUnit11 | The API identifier used in GraphQL. |
| Number | 9418 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 11 | OrgUnit11 |
|
Organisational unit 12
The organisational unit you entered in vouchers, possibly via the distribution key in vouchers.
The field appear with the name assigned to it in the Company information table.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Short alphanumeric organisational unit no. | Text (10) |
| SQL name | R12 | The database field name. |
| API identifier | orgUnit12 | The API identifier used in GraphQL. |
| Number | 9419 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 12 | OrgUnit12 |
|
Origin
Indicates whether the Voucher was entered manually or generated automatically.
The automatically generated transactions are labelled as to their origin (for example reminder, interest note or payment).
- 1 - Manually entered
- 2 - Automatically generated
- 13 - Automatic entry
- 3 - VAT report
- 41 - OSS VAT report
- 10 - Direct debiting
- 4 - Reminder
- 5 - Interest note
- 8 - OCR payment
- 21 - Write off payments
- 6 - Giro payment
- 7 - Direct payment
- 11 - Depreciation on capital assets
- 9 - Order processing
- 23 - Incoming invoice
- 12 - Import
- Normal text import.
- 14 - Previous batch
- 15 - Compressing transactions
- 16 - Posting of costs
- 18 - Internal invoicing
- 17 - Differences
- When you update a batch with this origin code debit/credit control is not carried out.
- 19 - EDI invoice import
- 20 - Payroll
- 22 - Visma Business Services
- 24 - Activate Capital asset
- 25 - Calculate client interest
- 26 - Document Center temporary batch
- 27 - Document Center finished batch
- 28 - Debt collector
- 29 - Split invoice
- 30 - Currency correction
- 31 - External application
- If this origin code is used, this value can be used by other applications that use BIG or SQL and create batches.
- 32 - Cash order document
- 33 - Sell or scrap capital asset
- 34 - Initializing capital asset
- 35 - EDI read dirdeb vouchers
- 37 - Accrual accounting
- 38 - Order processing with picking after invoicing
- 39 - Picked after invoicing
- 40 - Correction of costs
- 42 - Accounting document
- Batch was created from Accounting document table.
- 43 - Order match pre-registration
- 44 - Self billing invoice
- 45 - Split batch, supplier transactions
- Batch was created by Update supplier transactions processing for supplier transactions only.
- 46 - Split batch, cost transactions
- Batch was created by Update supplier transactions processing for cost and capital transactions to be adjusted after payment.
- 47 - Account statement vouchers
- Batch was created by Create voucher processing in the Account statement transaction table.
- 48 - WebFaktura
- 49 - Central
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Origin | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | SrcTp | The database field name. |
| API identifier | origin | The API identifier used in GraphQL. |
| Number | 1147 |
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 | No | This field is not visible by default in the table display. |
| Domain | Date | Integer |
| SQL name | OrgDueDt | The database field name. |
| API identifier | originalDueDate | The API identifier used in GraphQL. |
| Number | 11600 |
Original run no.
The Order journal number from which the transaction origin.
The number can be used to trace the transactions generated from orders.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Journal no. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | SrcJNo | The database field name. |
| API identifier | originalRunNo | The API identifier used in GraphQL. |
| Number | 1148 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Order journal | OrderJournal |
|
Original voucher no.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Voucher no. | Integer |
| SQL name | OrVoNo | The database field name. |
| API identifier | originalVoucherNo | The API identifier used in GraphQL. |
| Number | 18621 |
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 | 1125 |
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 | 1123 |
Outstanding amount in EURO
The outstanding amount in currency, converted into EURO, that remains before the invoice is fully matched.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Source column | Outstanding amount in currency | Euro |
| Write Access | None | You are not allowed to modify the value in this field. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | outstandingAmountInEuro | The API identifier used in GraphQL. |
| Number | 7719 |
Paid curr. amount
Paid amount in the current currency.
Accumulates remitted part payments.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| SQL name | RemCAm | The database field name. |
| API identifier | remittedCurrencyAmount | The API identifier used in GraphQL. |
| Number | 19607 |
Paid last
The voucher date of the last matched payment voucher.
Updated each time you match a payment against an open entry.
The date is validated using the regional settings in Windows.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Date | Integer |
| SQL name | PayedDt | The database field name. |
| API identifier | paidLast | The API identifier used in GraphQL. |
| Number | 1127 |
Paid status
Indicates whether the entry is fully open, partially paid, paid late or fully processed.
- 1 - Fully open entry
- Has not been matched against any entry yet.
- 2 - Partially open entry
- Has been matched against one or more entries, but an amount remains outstanding.
- 3 - Paid late
- The entry is retained pending the backdated calculation of interest.
- 4 - Paid on time
- The entries were settled before the payment deadline and their processing as an open entry is complete. Open entries are deleted as soon as they have status 4, after which they are stored in the transactions tables. If any entries with this status remain, you can terminate them by selecting the lines and running the Terminate entry processing in the Open customer entry table.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Paid status | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | St | The database field name. |
| API identifier | paidStatus | The API identifier used in GraphQL. |
| Number | 1132 |
Part payment
Is updated from vouchers and can be overridden.
This amount will be suggested for the next payment suggestion. The field is emptied when you run the Create payment suggestion processing. The Part payment in currency field will be accumulated to the Paid curr. amount field, when the payment suggestion is created.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| SQL name | PrtAm | The database field name. |
| API identifier | partPaymentDomestic | The API identifier used in GraphQL. |
| Number | 7984 |
Part payment in currency
Is updated from vouchers and can be overridden.
This amount will be suggested for the next payment suggestion. The field is emptied when you run the Create payment suggestion processing. The Part payment in currency field will be accumulated to the Paid curr. amount field, when the payment suggestion is created.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| SQL name | PrtCurAm | The database field name. |
| API identifier | partPaymentInCurrency | The API identifier used in GraphQL. |
| Number | 7982 |
Part payment in EURO
This field is derived from the Part payment in currency field.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Source column | Part payment in currency | Euro |
| Write Access | None | You are not allowed to modify the value in this field. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | partPaymentInEuro | The API identifier used in GraphQL. |
| Number | 7983 |
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 | 19613 |
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 | 19614 |
Payment method
Is updated from vouchers.
This field is normally to be used only on entries with its origin from cash orders. (Orders with order type = 3).
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Payment method | Integer |
| SQL name | PmtMt | The database field name. |
| API identifier | paymentMethod | The API identifier used in GraphQL. |
| Number | 10537 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Payment method | PaymentMethod |
|
Payment no.
The Payment no. from the Payment table.
This field is updated with the payment number when you run the processing Create payment suggestion in the Open customer entry table.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Payment no. | Integer |
| SQL name | PmtNo | The database field name. |
| API identifier | paymentNo | The API identifier used in GraphQL. |
| Number | 11089 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Payment | Payment |
|
Payment suggested
Shows a "x", if a payment suggestion has been created.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Boolean | Integer |
| SQL name | DebDir | The database field name. |
| API identifier | paymentSuggested | The API identifier used in GraphQL. |
| Number | 5510 |
Payment terms
Is updated from vouchers. If it is not filled in on vouchers, it is fetched from the Associate table.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Payment terms | Integer |
| SQL name | PmtTrm | The database field name. |
| API identifier | paymentTerms | The API identifier used in GraphQL. |
| Number | 4951 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Payment term | PaymentTerms |
|
Period
Shows the accounting period to which the transaction was posted.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Period | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | AcPr | The database field name. |
| API identifier | period | The API identifier used in GraphQL. |
| Number | 1117 |
| 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. |
Period batch no.
The period batch number and the value is retrieved from the Batch.
The period batch number is included in automatic entries. On normal transactions, the value is taken from the Batch unless it is given on vouchers.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | No. | Integer |
| SQL name | PrBt | The database field name. |
| API identifier | periodBatchNo | The API identifier used in GraphQL. |
| Number | 10539 |
Picture file name
the file name for the scanned image file for the vouchers.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Picture file name | Text (260) |
| SQL name | PictNo | The database field name. |
| API identifier | pictureFileName | The API identifier used in GraphQL. |
| Number | 9137 |
Pre-approved
Pre-approved for payment in Visma.net AutoPay.
The transaction has been approved for payment in Visma.net Approval. Approval of the payment in Visma.net AutoPay should not be required. This value can be removed, but not be set.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Boolean | Integer |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | preapproved | The API identifier used in GraphQL. |
| Number | 18568 |
Previous voucher no.
The original voucher number when you reverse transactions.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Voucher no. | Integer |
| SQL name | PrevVoNo | The database field name. |
| API identifier | previousVoucherNo | The API identifier used in GraphQL. |
| Number | 6253 |
Priority
Comes from vouchers or can be edited manually in the corresponding open entries table.
The field is mainly used for sorting and selecting purposes.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Payment priority | Integer |
| SQL name | Pri | The database field name. |
| API identifier | priority | The API identifier used in GraphQL. |
| Number | 1133 |
Quantity
Comes from vouchers and has the same sign as the Amount field.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Quantity | Decimal |
| SQL name | Qty | The database field name. |
| API identifier | quantity | The API identifier used in GraphQL. |
| Number | 2271 |
Ready for reminder
In use for Open customer entry to display due date including days of grace.
- Payment terms table. If the payment term used have a Days of grace value, this will be used.
- Open customer entry table. If the Country no. field is set, the Days of grace value for this country will be used.
- Associate table. If the Country no. field is set for the customer, the Days of grace value for this country will be used.
- Company information table. The Days of grace value for the Country no. will be used.
When changing either Country no. or Payment terms on the Open customer entry record, the Ready for reminder value will be updated automatically. On new entries, Ready for reminder will be automatically calculated. On existing records, the new processing Recalculate Ready for Reminder date must be used.
The date is validated using the regional settings in Windows.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Date | Integer |
| SQL name | RfRDt | The database field name. |
| API identifier | readyForReminder | The API identifier used in GraphQL. |
| Number | 18394 |
Reference
Comes from vouchers.
If the Reference field is not filled in on the voucher line, Visma Business will set this field equal to the Invoice no. field. If the Invoice no. field is also not filled in on the voucher line, then the Voucher no. field will be used.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Doc. no. | Text (40) |
| SQL name | Ref | The database field name. |
| API identifier | reference | The API identifier used in GraphQL. |
| Number | 1130 |
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 | 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 | RemDocNo | The database field name. |
| API identifier | reminderDocumentNo | The API identifier used in GraphQL. |
| Number | 13016 |
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 | 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 | RemPrDt | The database field name. |
| API identifier | reminderPrintingDate | The API identifier used in GraphQL. |
| Number | 11010 |
Reminder suggestion status
The processing chosen in Associate table decides the value.
This will simplify the review and cleaning up in the customer ledger when issuing reminders. When reminders are printed and approved, the values in this column in the Associate table is deleted.
- 1 - Reminder next time
- Set when you run the Update reminder suggestion status processing in the Associate table for all open customer entries that satisfy the criteria for being reminded.
- 2 - No reminder next time
- Set when you run the Exempt from reminder processing in the Associate table.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Reminder suggestion status | Integer |
| SQL name | RemSt | The database field name. |
| API identifier | reminderSuggestionStatus | The API identifier used in GraphQL. |
| Number | 15380 |
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 |
| SQL name | RCshAm | The database field name. |
| API identifier | outstandingCashAmountDomestic | The API identifier used in GraphQL. |
| Number | 7855 |
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 |
| SQL name | CRCshAm | The database field name. |
| API identifier | outstandingCashAmountInCurrency | The API identifier used in GraphQL. |
| Number | 7853 |
Rest cash amount in EURO
The outstanding amount in the current currency converted into EUROS that remains before the invoice is fully matched.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Source column | Rest cash amount in currency | Euro |
| Write Access | None | You are not allowed to modify the value in this field. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | outstandingCashAmountInEuro | The API identifier used in GraphQL. |
| Number | 7854 |
Scan doc. no.
The ID of the scanned document.
Is used in connection with Visma Document Center.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | No. | Integer |
| SQL name | PLDNo | The database field name. |
| API identifier | scanDocumentNo | The API identifier used in GraphQL. |
| Number | 11163 |
Scan status
The status of the scanned document.
Is used in connection with Visma Document Center.
- 1 - Scanned document
- 2 - Document on flow
- 4 - Document finished
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Scan status | Integer |
| SQL name | PLDFlow | The database field name. |
| API identifier | scanStatus | The API identifier used in GraphQL. |
| Number | 11164 |
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 | 19615 |
Text
The text of the transaction.
For automatically generated transactions Visma Business takes the Voucher type from the Voucher series for automatically generated transactions and the text field is filled in with the default text for this Voucher type.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Text | Text (200) |
| SQL name | Txt | The database field name. |
| API identifier | text | The API identifier used in GraphQL. |
| Number | 1119 |
Trans. status
Various transaction statuses, inherited from Voucher table.
Overwritten
- Amount excl. VAT
- When you complete the Amount excl. VAT field in the Voucher table, this check box is selected.
- VAT amount
- This field is checked if you have overridden the VAT amount in the voucher line.
- Org. unit
- If organisational units are overridden in the General ledger transaction table, Business NXT defines a value here that indicates that the organisational unit has been corrected after updating.
Debt collector
- Transferred to debt collector
- This field applies only to open customer entries and customer transactions. Business NXT updates the field when you run the Transfer to debt collection processing.
- Returned from debt collector
- This field applies only to open customer entries and customer transactions. Business NXT updates the field when you run the Return from debt collection processing.
- Added during debt collection
- This field applies only to open customer entries and customer transactions. Business NXT updates the field when you run the List debt collection related transactions processing.
Duration
- Permanent
- All regular transactions.
- Temporary
- Business NXT uses this field in connection with reversal of transactions.
- Reversing
- Business NXT uses this field in connection with reversal of transactions.
Accounting rule
- Created by an accounting rule
- The option is automatically enabled when a voucher line is created by
an accounting rule.The field is greyed out in the following tables:
- Customer transaction
- Supplier transaction
- General ledger transaction
- Capital asset transaction
- Open customer entry
- Open supplier entry
- Do not apply accounting rule
Per.
- Per. Debit acc.
- Per. Credit acc.
____
- Do not create open entries
- Business NXT does not produce open entries for the voucher line. This field overrides the
Matching method
parameter in the Company information table and
Matching method cust./Matching method sup.
in the Associate table. You can use this parameter, for example, when converting from other systems
in which you want to refer to earlier transactions. You can also increase the speed
when updating a batch if you define this flag for vouchers that you know are fully
matched.The field is greyed out in the following tables:
- Customer transaction
- Supplier transaction
- General ledger transaction
- Capital asset transaction
- Open customer entry
- Open supplier entry
- Ref. Entry Free of interest
- This comes from the order module and will exempt this entry and the cross-reference from interest computation in connection with updating.
- Ref. Entry Free of reminder fee
- If you in the Order table have selected the Ref. Entry Free of interest check box in Order options, this check box is selected. When you update the batch the post and the cross-references are exempted from interest calculation.
- Credit note
- Business NXT checks for credit note if the transaction is a credit entry for a customer or a
debit entry for a supplier. Business NXT assumes that you have checked the Affects turn./purch. box in the Voucher type
table for the relevant voucher type.
This field is used for customer transactions and supplier transactions, and is therefore greyed out in the voucher line.
- Authorised
- This field is checked if you have authorised a general ledger transaction. You can also check the field manually if the transaction has already been authorised.
- Factoring performed
- You only use this check box for open customer entries, and it is therefore greyed out in the voucher lines.
- Period flow processed
- Business NXT will select this field when you execute the Automatic entries processing in the General ledger account table.
- Paid
- Business NXT will select this field when you transfer the open entry to payment lines. You
cannot select the field manually.
Business NXT inserts a cross in this field when you save a cross reference line which has a cross in the Payment reg. field. When you delete a voucher line, transaction status Paid is deleted if you press Delete in the cross reference line or the voucher line, and not in the batch head.
- Partly paid in AutoPay
- Automatically set when an open customer/supplier entry is updated as a partial payment, i.e. when an approver has overridden the payment amount in Visma.net AutoPay.
- Cancelled/Rejected payment
- This check box is selected when a payment line is cancelled or rejected. The Paid and Payment no. fields are then deleted, so that you can create payment for the entry once more. This requires that the parameter Set to "Cancelled" for payments not transferred in the EFT processing field of the Bank partner table has been checked.
- Prepayment
- This check box is selected when OCR transactions are imported containing advance payment. The routine enters the order number in the voucher line. This requires that you have selected the parameter Prepayment in Payment processing in the Company information or Factoring company tables.
- Accept transactions with amount 0
- If you select this field in a voucher line, transactions are produced
even if both the amount and quantity are 0 (zero) in the voucher line.
In these voucher lines and updated voucher lines, 0 (zero) is shown instead of a blank Amount field (in default currency).
The Accept transactions with amount 0 field are greyed out when you open the dialog box in the Trans. status field from tables other than the Voucher table.
- Direct debit from order
- When posting invoices from the order system, Business NXT checks whether the customer has a direct debiting agreement, and whether the voucher date is within the applicable from and to dates for this. If so, the flag from Direct debit from order is placed in the Trans. status field in the voucher line. If this amount exceeds a maximum amount specified by the customer, the Exceeded max amount flag is inserted.
- Exceeded max amount
- When posting invoices from the order system, Business NXT checks whether the customer has a direct debiting agreement, and whether the voucher date is within the applicable from and to dates for this. If so, the flag from Direct debit from order is placed in the Trans. status field in the voucher line. If this amount exceeds a maximum amount specified by the customer, the Exceeded max amount flag is inserted.
- Do not update exchange rate from voucher date
- The voucher line’s exchange rate from the Currency rate or Currency rate 2 table will not be updated when you change the voucher date.
- Debt collection voucher lines already expanded
- Value date overridden
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Trans. status | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | TransSt | The database field name. |
| API identifier | transactionStatus | The API identifier used in GraphQL. |
| Number | 6627 |
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 | 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 | Trn | The database field name. |
| API identifier | turnover | The API identifier used in GraphQL. |
| Number | 1129 |
Unit
The field is transferred from vouchers when Batch are updated.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Unit | Integer |
| SQL name | Un | The database field name. |
| API identifier | unit | The API identifier used in GraphQL. |
| Number | 10538 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Unit | Unit |
|
Updated batch no.
When batches are updated, a reference is filled in to transaction records produced from the batch.
The reference is important for the case when it is demanded to withdraw the record with the Create new voucher processing in the Updated voucher table.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Batch no. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | UpdBndNo | The database field name. |
| API identifier | updatedBatchNo | The API identifier used in GraphQL. |
| Number | 10948 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Updated batch | UpdatedBatch |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. | |
| Updated voucher | UpdatedVoucher |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. |
Updated voucher line no.
When batches are updated, a reference is filled in to vouchers from which the voucher is produced in this field.
The reference is important for the case when it is demanded to withdraw the record with the Create new voucher processing in the Updated voucher table.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | No. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | UpdLnNo | The database field name. |
| API identifier | updatedVoucherLineNo | The API identifier used in GraphQL. |
| Number | 10949 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Updated voucher | UpdatedVoucher |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. |
Value date
The value date for the voucher.
The date is validated using the regional settings in Windows.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Date | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | ValDt | The database field name. |
| API identifier | valueDate | The API identifier used in GraphQL. |
| Number | 1115 |
VAT amount
Is inherited from the Voucher line. If not entered on the voucher line, it will be inherited from the Batch.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | VatAm | The database field name. |
| API identifier | vatAmountDomestic | The API identifier used in GraphQL. |
| Number | 6677 |
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 | 18143 |
Visma ID
The ID of the scanned document.
Is used in connection with Visma Document Center.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | No. | Integer |
| SQL name | WfId | The database field name. |
| API identifier | vismaId | The API identifier used in GraphQL. |
| Number | 11162 |
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 | 1114 |
Voucher group 1
The voucher group the transaction belongs to. It is inherited from the voucher line and can be defined in the Text table.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Voucher group 1 | Integer |
| SQL name | VoGr1 | The database field name. |
| API identifier | voucherGroup1 | The API identifier used in GraphQL. |
| Number | 6154 |
Voucher group 2
The voucher group the transaction belongs to. It is inherited from the voucher line and can be defined in the Text table.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Voucher group 2 | Integer |
| SQL name | VoGr2 | The database field name. |
| API identifier | voucherGroup2 | The API identifier used in GraphQL. |
| Number | 6155 |
Voucher jour. no.
A unique number identifying voucher journal number.
The same voucher journal number is allocated to customer, supplier, general ledger and capital asset transactions in each batch update. It is also allocated to the tables Updated batch, Updated voucher and Updated cross reference and is the major key to trace both the transactions origin and related transactions, such as automatically generated G/L transactions and VAT transactions.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Journal no. | Integer |
| Primary key | Yes | Voucher jour. no., Audit no. |
| SQL name | JNo | The database field name. |
| API identifier | voucherJournalNo | The API identifier used in GraphQL. |
| Number | 1109 |
| 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 | 1113 |
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 | 1118 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Voucher type | VoucherType |
|
W/off variance cash discount
If you want to pay an amount less than the Outstanding amount for an entry, enter the amount in the Part payment field in the current currency or default currency.
When the part payment is updated, the W/off variance cash discount, W/off variance cash discount in EURO and W/off variance cash discount in currency fields show the difference in relation to the Outstanding amount.
Visma Business refreshes the fields if you change the part payment amount.
If you enter 0 (zero) as the part payment amount, the part payment fields show 0 (zero) instead of being blank. If you delete the part payment amount, Visma Business also deletes the difference calculations.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| SQL name | PmVaAmCD | The database field name. |
| API identifier | writeOffVarianceCashDiscountDomestic | The API identifier used in GraphQL. |
| Number | 8608 |
W/off variance cash discount %
Shows the difference in the default currency as a percentage of the original amount in the default currency.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Percent | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | writeOffVarianceCashDiscountPercent | The API identifier used in GraphQL. |
| Number | 8609 |
W/off variance cash discount in currency
If you want to pay an amount less than the Outstanding amount for an entry, enter the amount in the Part payment field in the current currency or default currency.
When the Part payment is updated, the W/off variance cash discount, W/off variance cash discount in EURO and W/off variance cash discount in currency fields show the difference in relation to the Outstanding amount.
Visma Business refreshes the fields if you change the part payment amount.
If you enter 0 (zero) as the part payment amount, the part payment fields show 0 (zero) instead of being blank. If you delete the part payment amount, Visma Business also deletes the difference calculations.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | writeOffVarianceCashDiscountInCurrency | The API identifier used in GraphQL. |
| Number | 8606 |
W/off variance cash discount in EURO
If you want to pay an amount less than the Outstanding amount for an entry, enter the amount in the Payment method field in the current currency or default currency.
When the part payment is updated, the W/off variance cash discount, W/off variance cash discount in EURO and W/off variance cash discount in currency fields show the difference in relation to the Outstanding amount.
Visma Business refreshes the fields if you change the part payment amount.
If you enter 0 (zero) as the part payment amount, the part payment fields show 0 (zero) instead of being blank. If you delete the part payment amount, Visma Business also deletes the difference calculations.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Source column | W/off variance cash discount in currency | Euro |
| Write Access | None | You are not allowed to modify the value in this field. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | writeOffVarianceCashDiscountInEuro | The API identifier used in GraphQL. |
| Number | 8607 |
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 | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| SQL name | PmVaAm | The database field name. |
| API identifier | writeOffVarianceMiscDomestic | The API identifier used in GraphQL. |
| Number | 11046 |
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 | No | This field is not visible by default in the table display. |
| Domain | Percent | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | writeOffVarianceMiscPercent | The API identifier used in GraphQL. |
| Number | 11489 |
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 | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| SQL name | PmVaCAm | The database field name. |
| API identifier | writeOffVarianceMiscInCurrency | The API identifier used in GraphQL. |
| Number | 11044 |
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 | No | This field is not 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 | 11045 |
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 | 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 | writeOffVarianceTotalInCurrency | The API identifier used in GraphQL. |
| Number | 11041 |
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 | No | This field is not 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 | 11042 |
Web page
If you want to link a special web page to one of your vouchers, you can enter the address here.
The value in the field is transferred from vouchers to Updated voucher and on to the transactions and open entries.
If you use the Design/Add/Visualise menu item, Visma Business uses what is in this field.
Double-click or press * to open the web page in your web browser.
Alternatively the field can be used to refer to documents or other files. Double-click or press * in the empty field to open the Select file dialog box.
On the Design tab, in the Insert group, you can click on Web page to visualise the document or web page on the screen.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Web page | Text (260) |
| SQL name | WebPg | The database field name. |
| API identifier | webPage | The API identifier used in GraphQL. |
| Number | 9138 |
Workflow document ID
An identifier for a document, such as an invoice or a voucher, that is processed via Visma Business Workflow.
Workflow document ID is assigned when sending the document for approval. The identifier can be used to find the document for example in Visma.net Approval.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Workflow document ID | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | WfDocId | The database field name. |
| API identifier | workflowDocumentId | The API identifier used in GraphQL. |
| Number | 18968 |
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 | No | This field is not visible by default in the table display. |
| Domain | Write off status | Integer |
| SQL name | WO | The database field name. |
| API identifier | writeOffStatus | The API identifier used in GraphQL. |
| Number | 8517 |
Year
The relevant accounting year for the transactions. The year is deducted from the value date.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Year | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | AcYr | The database field name. |
| API identifier | year | The API identifier used in GraphQL. |
| Number | 1116 |
| 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. |
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. |