Bank partner
This table contains one row for each bank partner that is used for electronic funds transfer.
| Property | Value | Description |
|---|---|---|
| Database | Company | This table is in the company databases. |
| SQL name | BPart | The table name in the database. |
| API identifier | bankPartner | The API identifier used in GraphQL. |
| Table no. | 188 | The table number in the data model. |
The following fields exist in this table:
Alert code
The alert code for the bank partner.
The alert code in this field is used as the default. It is used in connection with electronic funds transfer.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Alert code | Text (5) |
| SQL name | NtfCd | The database field name. |
| API identifier | alertCode | The API identifier used in GraphQL. |
| Number | 13836 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Notification code | BankAlertCode |
|
Alert text
Free text field for the alert text. Used in connection with electronic funds transfer.
This field is filled in when you enter a value in the Alert code field. The alert text in this field is used as the default.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Alert text | Text (25) |
| SQL name | NtfTxt | The database field name. |
| API identifier | alertText | The API identifier used in GraphQL. |
| Number | 13837 |
Balance available
Available balance on the bank account.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| SQL name | BalAv | The database field name. |
| API identifier | balanceAvailable | The API identifier used in GraphQL. |
| Number | 18611 |
Balance booked
Booked balance on the bank account.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| SQL name | BalBk | The database field name. |
| API identifier | balanceBooked | The API identifier used in GraphQL. |
| Number | 18612 |
Balance date
Valid date for the Balance available and Balance booked fields.
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 | BalDt | The database field name. |
| API identifier | balanceDate | The API identifier used in GraphQL. |
| Number | 18613 |
Bank account name
Name of the bank account in the bank.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | String of length 100 | Text (100) |
| SQL name | BankAcNm | The database field name. |
| API identifier | bankAccountName | The API identifier used in GraphQL. |
| Number | 18614 |
Bank name
The name of the bank.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Name | Text (80) |
| SQL name | BankNm | The database field name. |
| API identifier | bankName | The API identifier used in GraphQL. |
| Number | 11434 |
Bank partner no.
A unique number identifying Bank partner.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | No. | Integer |
| Primary key | Yes | Bank partner no. |
| SQL name | BPartNo | The database field name. |
| API identifier | bankPartnerNo | The API identifier used in GraphQL. |
| Number | 6903 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Declaration code | StandardEftDeclarationCode |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. |
Bank system
The bank system which is used for the bank partner.
- 1 - Unibank (Denmark)
- Obsolete format.
- 2 - DnB Telebank (Norway)
- Obsolete format.
- 3 - Kreditkassen K-Link (Norway)
- Obsolete format.
- 4 - Sparnett (Norway)
- Obsolete format.
- 5 - Fokus Telebank (Norway)
- Obsolete format.
- 90 - Visma Payment (BabelBank) - not in use
- Obsolete format.
- 95 - Visma.net AutoPay
- The recommended bank system today.
- 96 - Liinos
- An internal format for finding Finnish customers only and has not yet been fully developed.
- 97 - Visma Services payment routine
- An internal format for customers who want to use Visma Services’ own bank service.
- 98 - Visma AutoPay - not in use
- The previous on premises version of AutoPay. Also known as AutoPay 3.
- 99 - Z Data Converter
- Bank system provided by third party supplier of Visma.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Bank system | Integer |
| SQL name | BankSys | The database field name. |
| API identifier | bankSystem | The API identifier used in GraphQL. |
| Number | 11419 |
Charge (debit) bank relations
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Bank no. | Integer |
| SQL name | BankCon | The database field name. |
| API identifier | chargeBankNo | The API identifier used in GraphQL. |
| Number | 11421 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Bank | Bank |
|
Chargeable bank account no.
The bank account number to be remitted (debited).
This means you avoid having to change the account number in the Company information table when exporting. You can also enter the bank account number that is to be debited other places, and this applies in the following priority order:
- Chargeable bank account no. from the Bank partner table.
- Our payment acc. from the Payment line table.
- Bank account for the currency line from the Currency table.
- Bank account from Company information.
- Postal giro from Company information.
This allows to set up several payment accounts without having to alter the table Company information, and you can select the various bank partners through generating suggestions.
Credit note due dates are also taken from the Bank partner table if the field is blank on the payment line.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Bank account | Text (35) |
| SQL name | BankG | The database field name. |
| API identifier | chargeBankAccount | The API identifier used in GraphQL. |
| Number | 11420 |
Currency no.
The currency no for the bank partner.
Visma.net AutoPay is using this field to differentiate between different "Currency pockets" for payment formats for Nordea in Sweden.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Currency no. | Integer |
| SQL name | Cur | The database field name. |
| API identifier | currencyNo | The API identifier used in GraphQL. |
| Number | 11435 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Currency | Currency |
|
Customer no. in bank
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Organisation no. | Text (24) |
| SQL name | CustNo | The database field name. |
| API identifier | customerNoInBank | The API identifier used in GraphQL. |
| Number | 6906 |
Decl. text
The declaration text used for electronic funds transfer.
It gets automatically filled when you select a value from the Std. EFT decl. code.
The authorities require the report of currency payments from the bank to contain a declaration code and a declaration text.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Decl. text | Text (40) |
| SQL name | DeclTxt | The database field name. |
| API identifier | declarationText | The API identifier used in GraphQL. |
| Number | 14556 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Declaration code | BankDeclarationText |
|
Division
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Division | Text (11) |
| SQL name | Div | The database field name. |
| API identifier | division | The API identifier used in GraphQL. |
| Number | 6907 |
EFT processing
Payment suggestion
- Estimated transfer date is payment date for all transactions
- All transactions, regardless of the payment date, will be assigned the same payment date that you used in the Create payment suggestion processing.
- Set extra text on payment post
- You will be able to transfer text (40 characters) on an open post in the Additional text field. This has been implemented for the 96 - Liinos and 99 - Z Data Converter bank systems. Only Telepay (NO), Postal giro and Bankgiro (SE) can use this function.
- No debit balance
- Some EFT systems will test whether the payments per supplier exceed the total amount owed, and rejects this supplier and transactions that will create a debit balance for the supplier will not be paid.
- Net credit notes towards invoices
Posting
- Generate batch/vouchers for settlement from EFT system
- Automatically create batch/vouchers when receiving settled payments from the EFT system. Recommendation is to have this setting selected. If not selected the Create account batch processing in the Payment line table can be ran manually at a later stage.
- Automatically update batch for outgoing payments from Visma.net AutoPay
- After return data for payments are received from Visma.net AutoPay, the Update batch processing will start automatically.
- Update all settled payments in a single batch
- When selected, one common batch with voucher lines is created for the settlements of outgoing payments received in the same status change report from Visma.net AutoPay. If this option is not selected, separate batches will be created for each <OriginalPaymentBatch> section in the status change report.
Incoming payments
- Automatically update batch for incoming payments from Visma.net AutoPay
- After incoming payments are received from Visma.net AutoPay, the Update batch processing will start automatically.
- Use value date on Visma.net AutoPay incoming payments
- When selected, the bank's "Value date" is used for the Value date field in the Voucher table, instead of the bank's "Booking date". With this the user can configure what suites best for optimizing their bank reconciliation.
- Create voucher lines if charges from incoming payments from Visma.net AutoPay
- When selected, charges will be posted when importing incoming payments from Visma.net AutoPay. Charges will be posted if they are specified in the <ChargesDeducted> tag in the import file. Alternatively, charges will posted if the value in the <PaidCurrencyAmount> is higher than amount in the <ReceivedAmount> tag (meaning the customer has paid more than we have received), the difference will be considered as charges (currency must be identical for both amounts).
- Create bank posting for each incoming payment from Visma.net AutoPay
- When selected, a separate bank voucher will be created for each incoming payment when importing from Visma.net AutoPay.
- Ignore the group value when creating bank posting for incoming payments from Visma.net AutoPay
- In the XML file for incoming payments from Visma.net AutoPay (VIP file) there is a tag named
<Group>. Import of the incoming payments creates bank vouchers, with grouping based on payment date and<Group>values. When this setting is selected, the<Group>tag is not taken into account when creating bank vouchers. - Do not match CID payment when paid amount is larger than outstanding amount
- Relevant for incoming payments which has a CID code, and where the
paid amount is larger than open entry's outstanding amount (e.g. when the payer has
used same CID code for payment of multiple invoices).
When this setting is selected, the Cross reference and Credit account fields will not be filled out on the voucher. The batch will then have a difference, making it easier for the user to see that something needs manual handling (e.g. matching of open entries).
- Check for double payment by CID in customer transactions
- When incoming payments are imported, but no match is found in the Open customer entry table, an activation of this parameter will result in an additional search for the CID code in the Customer transaction table. If the CID code is found; the customer no. is added to the voucher line and the batch will balance. In addition the text "Warning - double payment?" will be added to the Additional text field.
- Do not check reminders in Customer document when matching payments
- When selected, the content in Customer document tables will not be used for matching of incoming payments from Visma.net AutoPay.
Sweden
- Accept negative payments
- Negative amounts will also be processed. This check box is also
present under Accounting processing field in the Company information
table. By using this selection in the Bank partner table, you
can set different processing for each bank partner.Note:For negative payments you are meant to transfer larger amounts of credit notes than invoices. This is selected when it is permitted to send this to the bank for monitoring, so that with the next invoice the bank reduces the payment amount with the remaining credit note value. This is only used when paying to Swedish banks.
- Always use Post giro if exists
- Post account is used in EFT processing. This applies for Sweden and is only used by some external EFT systems.
- Numeric cost codes
- The cost codes "OUR" and "BEN" will be replaced by numerical values that are used in Sweden.
- Allow uploading payments with 0-amounts
- When selected, the Create payment suggestion processing will create payment lines also for suppliers where the sum of the transactions is zero (e.g. one invoice with amount 2000 and one credit note with amount 2000). Check that your bank accept zero-payments, this is accepted by several banks in Sweden.
Denmark
- Joint Transactions
- Some EFT systems produces a joint transaction for the bank. If you use this parameter you cannot retrieve return data to match the payments. This field is only used in some external EFT systems.
- Short message to receiver
- The recipient receives a short message. This field is only used by some EFT systems.
Bank reconciliation
- Update general ledger transactions with reconciliation amount
- When selected, new transaction in the General ledger transaction table with Account no. = the bank partner's GL bank account will be assigned values in the Reconciliation rest amount fields. This makes it possible to later reconcile the transactions against the Account statement transaction table.
- Match transactions even if amounts are different
- Enables the possibility to match transactions with different amounts when running the Manual reconciliation processing.
- Reconciling single transactions before multiple transactions
- When selected, the 4 - Single transactions on same date reconciliation algorithm will be executed before the 2 - Multiple general ledger transactions on same date and 3 - Multiple account statement transactions on same date algorithms.
- Reconcile using value date
- Bank reconciliation based on principle Value date instead of Voucher date. When enabling Reconcile using value date, the algorithms will look into the value date instead of voucher date when executing the processes. Also, when running the bank reconciliation statement report, the value in the field Balance according to general ledger is calculated based on the value date for the transactions.
AutoInvoice
- Do not send CID to AutoInvoice
- When selected, no CID will be sent to AutoInvoice.
Miscellaneous
- Use database connection for ZData
- This field is not in use in this table.
- Payments for active company only
- You cannot export data from other clients than the client from whom the export was started.
- Process active settling only for payments
- You can only process the selected payment line for the company where Upload data or Download data was started from.
- Update bank account/organisation no. from EFT system
- You get updated bank account and organisation numbers of customers who are paying by OCR. Not all formats support this. It depends on the information in the file that comes from the bank.
- Get currency exchange rate when creating payments
- You will be able to get exchange rates from the bank, and update the Currency and Currency rate tables with updated exchange rates from the bank. Not all bank formats are supported at present.
- Set to "Cancelled" for payments not transferred
- Some EFT systems sets the Paym. line status field in the Payment line table to 4 - Cancelled in the lines that have status 1 - Estimate after you have run the Upload data processing in the Payment table. It is the EFT system that performs the cancellation of the open entries for everything that is rejected before you send data to the bank.
- Set "Cancelled" on payments that are refused
- Some external EFT systems will set the Paym. line status field in the Payment line table to 4 - Cancelled in the lines that are being cancelled by the control routines in the EFT system, while suggestions that you selected manually so that they will not be transferred remain as Paym. line status equal 1 - Estimate, and will be ready for paying the next time the EFT system is started.
- Domestic payments to foreign countries (payment method 43/TBIO)
- Foreign transactions will be sent over and processed as domestic transactions in the recipient country. This depends on what is offered by the bank that you use for the payments.
- No exchange rate on processed payments
- This field is not in use.
Accounting
- Duty/Fees included in amount
- Fees will be included in the total amount.
- Fees per record
- Fees and duties will be recorded per supplier and payment.
- Do not post duty and fees
- Fees and duties will not be posted with the payment. Select this field when you have a separate agreement with the bank that fees and duties are debited separately.
- Taxes and fees in foreign currency
- Fees and duties are in a currency other than default currency. Then the account currency is used for the fees.
- Use bank reference, domestic
- The bank reference will be used to gather the posting in the general ledger account for bank postings on domestic payments.
- Use bank reference in foreign countries
- The bank reference is used to gather posting in the general ledger account for bank postings in foreign payments.
Telepay
- Only one invoice per transaction
- Some EFT systems will only produces transactions for the bank. If you use this parameter, several payments will not be batched for the same account.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | EFT processing | Integer |
| SQL name | EFTProc | The database field name. |
| API identifier | eftProcessing | The API identifier used in GraphQL. |
| Number | 11425 |
EFT processing 2
Payment suggestion
- Estimated transfer date is payment date for all transactions
- All transactions, regardless of the payment date, will be assigned the same payment date that you used in the Create payment suggestion processing.
- Set extra text on payment post
- You will be able to transfer text (40 characters) on an open post in the Additional text field. This has been implemented for the 96 - Liinos and 99 - Z Data Converter bank systems. Only Telepay (NO), Postal giro and Bankgiro (SE) can use this function.
- No debit balance
- Some EFT systems will test whether the payments per supplier exceed the total amount owed, and rejects this supplier and transactions that will create a debit balance for the supplier will not be paid.
- Net credit notes towards invoices
Posting
- Generate batch/vouchers for settlement from EFT system
- Automatically create batch/vouchers when receiving settled payments from the EFT system. Recommendation is to have this setting selected. If not selected the Create account batch processing in the Payment line table can be ran manually at a later stage.
- Automatically update batch for outgoing payments from Visma.net AutoPay
- After return data for payments are received from Visma.net AutoPay, the Update batch processing will start automatically.
- Update all settled payments in a single batch
- When selected, one common batch with voucher lines is created for the settlements of outgoing payments received in the same status change report from Visma.net AutoPay. If this option is not selected, separate batches will be created for each <OriginalPaymentBatch> section in the status change report.
Incoming payments
- Automatically update batch for incoming payments from Visma.net AutoPay
- After incoming payments are received from Visma.net AutoPay, the Update batch processing will start automatically.
- Use value date on Visma.net AutoPay incoming payments
- When selected, the bank's "Value date" is used for the Value date field in the Voucher table, instead of the bank's "Booking date". With this the user can configure what suites best for optimizing their bank reconciliation.
- Create voucher lines if charges from incoming payments from Visma.net AutoPay
- When selected, charges will be posted when importing incoming payments from Visma.net AutoPay. Charges will be posted if they are specified in the <ChargesDeducted> tag in the import file. Alternatively, charges will posted if the value in the <PaidCurrencyAmount> is higher than amount in the <ReceivedAmount> tag (meaning the customer has paid more than we have received), the difference will be considered as charges (currency must be identical for both amounts).
- Create bank posting for each incoming payment from Visma.net AutoPay
- When selected, a separate bank voucher will be created for each incoming payment when importing from Visma.net AutoPay.
- Ignore the group value when creating bank posting for incoming payments from Visma.net AutoPay
- In the XML file for incoming payments from Visma.net AutoPay (VIP file) there is a tag named
<Group>. Import of the incoming payments creates bank vouchers, with grouping based on payment date and<Group>values. When this setting is selected, the<Group>tag is not taken into account when creating bank vouchers. - Do not match CID payment when paid amount is larger than outstanding amount
- Relevant for incoming payments which has a CID code, and where the
paid amount is larger than open entry's outstanding amount (e.g. when the payer has
used same CID code for payment of multiple invoices).
When this setting is selected, the Cross reference and Credit account fields will not be filled out on the voucher. The batch will then have a difference, making it easier for the user to see that something needs manual handling (e.g. matching of open entries).
- Check for double payment by CID in customer transactions
- When incoming payments are imported, but no match is found in the Open customer entry table, an activation of this parameter will result in an additional search for the CID code in the Customer transaction table. If the CID code is found; the customer no. is added to the voucher line and the batch will balance. In addition the text "Warning - double payment?" will be added to the Additional text field.
- Do not check reminders in Customer document when matching payments
- When selected, the content in Customer document tables will not be used for matching of incoming payments from Visma.net AutoPay.
Sweden
- Accept negative payments
- Negative amounts will also be processed. This check box is also
present under Accounting processing field in the Company information
table. By using this selection in the Bank partner table, you
can set different processing for each bank partner.Note:For negative payments you are meant to transfer larger amounts of credit notes than invoices. This is selected when it is permitted to send this to the bank for monitoring, so that with the next invoice the bank reduces the payment amount with the remaining credit note value. This is only used when paying to Swedish banks.
- Always use Post giro if exists
- Post account is used in EFT processing. This applies for Sweden and is only used by some external EFT systems.
- Numeric cost codes
- The cost codes "OUR" and "BEN" will be replaced by numerical values that are used in Sweden.
- Allow uploading payments with 0-amounts
- When selected, the Create payment suggestion processing will create payment lines also for suppliers where the sum of the transactions is zero (e.g. one invoice with amount 2000 and one credit note with amount 2000). Check that your bank accept zero-payments, this is accepted by several banks in Sweden.
Denmark
- Joint Transactions
- Some EFT systems produces a joint transaction for the bank. If you use this parameter you cannot retrieve return data to match the payments. This field is only used in some external EFT systems.
- Short message to receiver
- The recipient receives a short message. This field is only used by some EFT systems.
Bank reconciliation
- Update general ledger transactions with reconciliation amount
- When selected, new transaction in the General ledger transaction table with Account no. = the bank partner's GL bank account will be assigned values in the Reconciliation rest amount fields. This makes it possible to later reconcile the transactions against the Account statement transaction table.
- Match transactions even if amounts are different
- Enables the possibility to match transactions with different amounts when running the Manual reconciliation processing.
- Reconciling single transactions before multiple transactions
- When selected, the 4 - Single transactions on same date reconciliation algorithm will be executed before the 2 - Multiple general ledger transactions on same date and 3 - Multiple account statement transactions on same date algorithms.
- Reconcile using value date
- Bank reconciliation based on principle Value date instead of Voucher date. When enabling Reconcile using value date, the algorithms will look into the value date instead of voucher date when executing the processes. Also, when running the bank reconciliation statement report, the value in the field Balance according to general ledger is calculated based on the value date for the transactions.
AutoInvoice
- Do not send CID to AutoInvoice
- When selected, no CID will be sent to AutoInvoice.
Miscellaneous
- Use database connection for ZData
- This field is not in use in this table.
- Payments for active company only
- You cannot export data from other clients than the client from whom the export was started.
- Process active settling only for payments
- You can only process the selected payment line for the company where Upload data or Download data was started from.
- Update bank account/organisation no. from EFT system
- You get updated bank account and organisation numbers of customers who are paying by OCR. Not all formats support this. It depends on the information in the file that comes from the bank.
- Get currency exchange rate when creating payments
- You will be able to get exchange rates from the bank, and update the Currency and Currency rate tables with updated exchange rates from the bank. Not all bank formats are supported at present.
- Set to "Cancelled" for payments not transferred
- Some EFT systems sets the Paym. line status field in the Payment line table to 4 - Cancelled in the lines that have status 1 - Estimate after you have run the Upload data processing in the Payment table. It is the EFT system that performs the cancellation of the open entries for everything that is rejected before you send data to the bank.
- Set "Cancelled" on payments that are refused
- Some external EFT systems will set the Paym. line status field in the Payment line table to 4 - Cancelled in the lines that are being cancelled by the control routines in the EFT system, while suggestions that you selected manually so that they will not be transferred remain as Paym. line status equal 1 - Estimate, and will be ready for paying the next time the EFT system is started.
- Domestic payments to foreign countries (payment method 43/TBIO)
- Foreign transactions will be sent over and processed as domestic transactions in the recipient country. This depends on what is offered by the bank that you use for the payments.
- No exchange rate on processed payments
- This field is not in use.
Accounting
- Duty/Fees included in amount
- Fees will be included in the total amount.
- Fees per record
- Fees and duties will be recorded per supplier and payment.
- Do not post duty and fees
- Fees and duties will not be posted with the payment. Select this field when you have a separate agreement with the bank that fees and duties are debited separately.
- Taxes and fees in foreign currency
- Fees and duties are in a currency other than default currency. Then the account currency is used for the fees.
- Use bank reference, domestic
- The bank reference will be used to gather the posting in the general ledger account for bank postings on domestic payments.
- Use bank reference in foreign countries
- The bank reference is used to gather posting in the general ledger account for bank postings in foreign payments.
Telepay
- Only one invoice per transaction
- Some EFT systems will only produces transactions for the bank. If you use this parameter, several payments will not be batched for the same account.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | EFT processing 2 | Integer |
| SQL name | EFTProc2 | The database field name. |
| API identifier | eftProcessing2 | The API identifier used in GraphQL. |
| Number | 18999 |
EFT separator
The separator you want to use for batch payments. The field is then processed some external EFT systems.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | EFT separator | Text (3) |
| SQL name | EftSep | The database field name. |
| API identifier | eftSeparator | The API identifier used in GraphQL. |
| Number | 13019 |
From file name
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Data filename | Text (260) |
| SQL name | FrFileNm | The database field name. |
| API identifier | fromFileName | The API identifier used in GraphQL. |
| Number | 6904 |
GL account, bank fee
The general ledger account number used for fees.
When generating a batch, GL account, bank fee is used as follows:
- If you have filled in the GL account, bank fee field, the field in the Currency table will not be used.
- If the Payment fee account field for the relevant currency is blank for other currency in the Currency table, the value for domestic currency will be used.
- If you have not filled in the fields in points 1 and 2, the Posting errors account in the Company information table will be used.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Account no. | Integer |
| SQL name | RmtFeeAc | The database field name. |
| API identifier | generalLedgerAccountNoForFee | The API identifier used in GraphQL. |
| Number | 11423 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| General ledger account | FeeAccount |
|
GL bank account
The general ledger account for the bank account.
When generating a batch, General ledger account bank is used as follows:
- If you have filled in the GL account, bank fee field, the field in the Currency table will not be used.
- If the Payments account field for the relevant currency is blank for other currency in the Currency table, the value for domestic currency will be used.
- If you have not filled in the fields in points 1 and 2, the Posting errors account in the Company information table will be used.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Account no. | Integer |
| SQL name | RmtAc | The database field name. |
| API identifier | generalLedgerAccountNoForBank | The API identifier used in GraphQL. |
| Number | 11422 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| General ledger account | BankAccount |
|
Inf. 1
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Inf. @ | Text (40) |
| SQL name | Inf | The database field name. |
| API identifier | information1 | The API identifier used in GraphQL. |
| Number | 11426 |
Inf. 2
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Inf. @ | Text (40) |
| SQL name | Inf2 | The database field name. |
| API identifier | information2 | The API identifier used in GraphQL. |
| Number | 11427 |
Inf. 3
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Inf. @ | Text (40) |
| SQL name | Inf3 | The database field name. |
| API identifier | information3 | The API identifier used in GraphQL. |
| Number | 11428 |
Inf. 4
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Inf. @ | Text (40) |
| SQL name | Inf4 | The database field name. |
| API identifier | information4 | The API identifier used in GraphQL. |
| Number | 11429 |
Last day-seq. no.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | No. | Integer |
| SQL name | LstDySq | The database field name. |
| API identifier | lastDaySequenceNo | The API identifier used in GraphQL. |
| Number | 6910 |
Last seq. no.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | No. | Integer |
| SQL name | LstSq | The database field name. |
| API identifier | lastSequenceNo | The API identifier used in GraphQL. |
| Number | 6911 |
Last transf. 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 | LstTrfDt | The database field name. |
| API identifier | lastTransferDate | The API identifier used in GraphQL. |
| Number | 6909 |
Layout
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Data filename | Text (260) |
| SQL name | ImFileNm | The database field name. |
| API identifier | layoutFileName | The API identifier used in GraphQL. |
| Number | 7044 |
No. of reconciliation deviation days
Number of days transactions can deviate in bank reconciliation.
Number of days the transaction dates in the General ledger transaction and Account statement transaction tables can differ when executing the Automatic reconciliation processing.
The dates can differ e.g. when the payment date is set on a weekend/Holy day, but the transaction is not processed before the first working day.
Valid values are 0-7 (note that when no value is set, the standard value 1 day will apply). Larger values can give a better result with more matched transactions, but it can also increase the possibility for wrong matching (especially when having many identical amounts).
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | No. | Integer |
| SQL name | RecDDays | The database field name. |
| API identifier | noOfReconciliationDeviationDays | The API identifier used in GraphQL. |
| Number | 19543 |
Operator
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Operator | Text (11) |
| SQL name | Oper | The database field name. |
| API identifier | operator | The API identifier used in GraphQL. |
| Number | 6908 |
Organisational unit 1
The organisational unit for the bank account.
When a batch is created for a settled outgoing payment, this field is used to set organisation unit on the bank voucher. E.g. can different organisation units then be set for different bank accounts. If the field is blank, the organisational unit entered for the account in the General ledger account table will be used.
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 | 12236 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 1 | OrgUnit1 |
|
Organisational unit 2
The organisational unit for the bank account.
When a batch is created for a settled outgoing payment, this field is used to set organisation unit on the bank voucher. E.g. can different organisation units then be set for different bank accounts. If the field is blank, the organisational unit entered for the account in the General ledger account table will be used.
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 | 12237 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 2 | OrgUnit2 |
|
Organisational unit 3
The organisational unit for the bank account.
When a batch is created for a settled outgoing payment, this field is used to set organisation unit on the bank voucher. E.g. can different organisation units then be set for different bank accounts. If the field is blank, the organisational unit entered for the account in the General ledger account table will be used.
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 | 12238 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 3 | OrgUnit3 |
|
Organisational unit 4
The organisational unit for the bank account.
When a batch is created for a settled outgoing payment, this field is used to set organisation unit on the bank voucher. E.g. can different organisation units then be set for different bank accounts. If the field is blank, the organisational unit entered for the account in the General ledger account table will be used.
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 | 12239 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 4 | OrgUnit4 |
|
Organisational unit 5
The organisational unit for the bank account.
When a batch is created for a settled outgoing payment, this field is used to set organisation unit on the bank voucher. E.g. can different organisation units then be set for different bank accounts. If the field is blank, the organisational unit entered for the account in the General ledger account table will be used.
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 | 12240 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 5 | OrgUnit5 |
|
Organisational unit 6
The organisational unit for the bank account.
When a batch is created for a settled outgoing payment, this field is used to set organisation unit on the bank voucher. E.g. can different organisation units then be set for different bank accounts. If the field is blank, the organisational unit entered for the account in the General ledger account table will be used.
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 | 12241 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 6 | OrgUnit6 |
|
Organisational unit 7
The organisational unit for the bank account.
When a batch is created for a settled outgoing payment, this field is used to set organisation unit on the bank voucher. E.g. can different organisation units then be set for different bank accounts. If the field is blank, the organisational unit entered for the account in the General ledger account table will be used.
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 | 12242 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 7 | OrgUnit7 |
|
Organisational unit 8
The organisational unit for the bank account.
When a batch is created for a settled outgoing payment, this field is used to set organisation unit on the bank voucher. E.g. can different organisation units then be set for different bank accounts. If the field is blank, the organisational unit entered for the account in the General ledger account table will be used.
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 | 12243 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 8 | OrgUnit8 |
|
Organisational unit 9
The organisational unit for the bank account.
When a batch is created for a settled outgoing payment, this field is used to set organisation unit on the bank voucher. E.g. can different organisation units then be set for different bank accounts. If the field is blank, the organisational unit entered for the account in the General ledger account table will be used.
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 | 12244 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 9 | OrgUnit9 |
|
Organisational unit 10
The organisational unit for the bank account.
When a batch is created for a settled outgoing payment, this field is used to set organisation unit on the bank voucher. E.g. can different organisation units then be set for different bank accounts. If the field is blank, the organisational unit entered for the account in the General ledger account table will be used.
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 | 12245 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 10 | OrgUnit10 |
|
Organisational unit 11
The organisational unit for the bank account.
When a batch is created for a settled outgoing payment, this field is used to set organisation unit on the bank voucher. E.g. can different organisation units then be set for different bank accounts. If the field is blank, the organisational unit entered for the account in the General ledger account table will be used.
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 | 12246 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 11 | OrgUnit11 |
|
Organisational unit 12
The organisational unit for the bank account.
When a batch is created for a settled outgoing payment, this field is used to set organisation unit on the bank voucher. E.g. can different organisation units then be set for different bank accounts. If the field is blank, the organisational unit entered for the account in the General ledger account table will be used.
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 | 12247 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 12 | OrgUnit12 |
|
Std. credit note credit days
The number of days that a credit note must remain in the bank before being cancelled.
The fields are in use for Swedish payment paths.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | No. | Integer |
| SQL name | CNtDy | The database field name. |
| API identifier | standardCreditNoteDueDays | The API identifier used in GraphQL. |
| Number | 11424 |
Std. EFT bank fee code
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | EFT bank fee | Integer |
| SQL name | AbCst | The database field name. |
| API identifier | standardEftBankFeeCode | The API identifier used in GraphQL. |
| Number | 11431 |
Std. EFT curr. code
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | EFT Currency code | Integer |
| SQL name | CurCd | The database field name. |
| API identifier | standardEftCurrencyCode | The API identifier used in GraphQL. |
| Number | 11430 |
Std. EFT decl. code
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | EFT declaration code | Integer |
| SQL name | DeclCd | The database field name. |
| API identifier | standardEftDeclarationCode | The API identifier used in GraphQL. |
| Number | 11432 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Declaration code | StandardEftDeclarationCode |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. |
Std. EFT form type
- 1 = giro transfer with notification without payment ID
- 4 = giro transfer without notification with payment ID
- 15 = giro transfer with notification and payment ID
- 71 = money order without notification with payment ID
- 73 = money order with notification without payment ID
- 75 = money order with notification and payment ID
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | EFT form type | Integer |
| SQL name | EftFrmTp | The database field name. |
| API identifier | standardEftFormType | The API identifier used in GraphQL. |
| Number | 15465 |
Std. EFT paym. method
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | EFT payment method | Integer |
| SQL name | PmtLnPro | The database field name. |
| API identifier | standardEftPaymentMethod | The API identifier used in GraphQL. |
| Number | 11433 |
Text code
Applies only to the payment type domestic payment (UBT033).
The text code in this field is used as the default.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Text code | Text (10) |
| SQL name | TxtCd | The database field name. |
| API identifier | textCode | The API identifier used in GraphQL. |
| Number | 13838 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Text code | BankTextCode |
|
Text line
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Text line | Text (200) |
| SQL name | TxtLn | The database field name. |
| API identifier | textLine | The API identifier used in GraphQL. |
| Number | 13839 |
To file name
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Data filename | Text (260) |
| SQL name | ToFileNm | The database field name. |
| API identifier | toFileName | The API identifier used in GraphQL. |
| Number | 6905 |
Voucher series no.
Only used by EFT systems to generate vouchers and has no function in Visma Business.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Voucher series no. | Integer |
| SQL name | VoSrNo | The database field name. |
| API identifier | voucherSeriesNo | The API identifier used in GraphQL. |
| Number | 14535 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Voucher series | VoucherSeries |
|
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. |