Debt collection agreement
This table contains necessary information for communication with the debt collection company.
Information such as contact name, organisation number and bank account is included, as well as requirements for invoices to be sent to the debt collection company, for example minimum amount per invoice and minimum number of reminders sent.
| Property | Value | Description |
|---|---|---|
| Database | Company | This table is in the company databases. |
| SQL name | DColAg | The table name in the database. |
| API identifier | debtCollectionAgreement | The API identifier used in GraphQL. |
| Table no. | 441 | The table number in the data model. |
The following fields exist in this table:
Account balances
Clearing account.
The clearing account to be used vis-a-vis the debt collection company.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Account no. | Integer |
| SQL name | AcBal | The database field name. |
| API identifier | accountBalances | The API identifier used in GraphQL. |
| Number | 18915 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| General ledger account | GlAccountForBalances |
|
Account costs incl. VAT
Account for debt collection costs.
Shall contain the cost account incl. VAT for debt collection shall be posted.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Account no. | Integer |
| SQL name | AcCst | The database field name. |
| API identifier | accountCostsInclVat | The API identifier used in GraphQL. |
| Number | 18918 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| General ledger account | GlAccountForCostsInclVat |
|
Account fee
Account for debt collection fees.
hall contain the cost account for fees for debt collection shall be posted.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Account no. | Integer |
| SQL name | AcFee | The database field name. |
| API identifier | accountFee | The API identifier used in GraphQL. |
| Number | 18917 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| General ledger account | GlAccountForFee |
|
Account interest
Account for interests.
Shall contain the financial revenue account for interests generated from overdue invoices handled by the debt collection company.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Account no. | Integer |
| SQL name | AcInt | The database field name. |
| API identifier | accountInterest | The API identifier used in GraphQL. |
| Number | 18916 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| General ledger account | GlAccountForInterest |
|
Accountant processing
Processing rules for the accountant.
- Contact for invoice inquiries
- Marked when the accountant shall receive information about invoices subject to debt collection from the debt collection company.
- Receiver of payment reports
- Marked when the accountant shall receive remittance reports from the debt collection company.
- Receiver of order confirmation
- Marked when the accountant shall receive order confirmations from the debt collection company.
- Receiver of debt collection list
- Marked when the accountant shall receive debt collection lists from the debt collection company.
- Web access
- Marked when the accountant is registered as a user at the debt collection company portal.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Accountant processing | Integer |
| SQL name | AcProc | The database field name. |
| API identifier | accountantProcessing | The API identifier used in GraphQL. |
| Number | 19090 |
Accountant's e-mail address
The accountants e-mail address.
The e-mail address of the accountant responsible for contacts with the debt collection company.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | E-mail address | Text (60) |
| SQL name | AcMailAd | The database field name. |
| API identifier | accountantsEmailAddress | The API identifier used in GraphQL. |
| Number | 18894 |
Accountant's name
The accounting contacts name.
Name of the accountant responsible for contacts with the debt collection company.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Name | Text (80) |
| SQL name | AcNm | The database field name. |
| API identifier | accountantsName | The API identifier used in GraphQL. |
| Number | 18892 |
Accountant's phone
The accountants phone no.
The phone no. of the accountant responsible for contacts with the debt collection company.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Phone | Text (20) |
| SQL name | AcPhone | The database field name. |
| API identifier | accountantsPhone | The API identifier used in GraphQL. |
| Number | 18893 |
Activated
Marked with a "x" if the AutoCollect agreement has been activated.
This field is a visualisation of the Activated flag in the AutoCollect processing.
When this option is not set, invoices will not be sent by the Send to AutoCollect processing. The message "No invoices sent, agreement not activated" will be given.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Boolean | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | activated | The API identifier used in GraphQL. |
| Number | 19123 |
AutoCollect manual matching
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Voucher series no. | Integer |
| SQL name | DCorVoSr | The database field name. |
| API identifier | autoCollectManualMatchingSeries | The API identifier used in GraphQL. |
| Number | 19169 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Voucher series | AutoCollectManualMatchingSeries |
|
AutoCollect processing
Processing rules for Visma AutoCollect.
- Activated
- Marked if the AutoCollect agreement has been activated (i.e. the Enable AutoCollect processing has been executed successfully).
- Collect only
- Marked if the agreement covers only debt collection. No reminder service will be performed by the debt collection company.
- Automatic transfer to AutoCollect
- Automatic transfer to Visma AutoCollect is allowed.
- Not VAT registered
- Marked if the client is not VAT registered.
- Mixed VAT
- Supports sending mixed VAT values to Visma AutoCollect.
- Use "Send to associate no."
- Marked if reminders are to go to the associate specified in the "Send
to associate no." field instead of to the debtor.
Can e.g. be used if reminders are to go to the group, while the receivable is linked to a subsidiary.
- Automatic update of settlement batch
- Marked if batches with settlements transferred from the debt collection company shall be automatically updated.
- Foreign debtors
- Marked if the client have foreign debtors.Note:When selected, the IBAN and Swift code fields must be filled out on the agreement.
- Invoices in foreign currency
- Marked if the client have debtors invoiced in foreign
currency.Note:When selected, the IBAN and Swift code fields must be filled out on the agreement.
- Automatic update of correction batch
- Automatic handling of credit suspension
When you use the Retrieve AutoCollect information processing and there are open entries with the Debt collection case type field set to true, then the Credit suspension field in the Associate table is set to true if Automatic handling of credit suspension is set to true in the AutoCollect processing field in the Debt collection agreement table.
When you use the Retrieve AutoCollect information and there are open entries with the Debt collection case type field changed from true to false and the outstanding amount exceeds 0 and you do not have any open entries with the Debt collection case type set to true, then the Credit suspension field in the Associate table is set to true if Automatic handling of credit suspension is set to true in the AutoCollect processing field in the Debt collection agreement table.
When Automatic handling of credit suspension is set false in the AutoCollect processing field in the Debt collection agreement table, then you need to manually configure the Credit suspension field in the Associate table.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | AutoCollect processing | Integer |
| SQL name | AutColPr | The database field name. |
| API identifier | autoCollectProcessing | The API identifier used in GraphQL. |
| Number | 19092 |
Bank account
The clients bank account.
Enter the clients bank account in this field, to be used for remittances from the debt collection company in those cases when the debtor pays their debt directly to the debt collection company.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Bank account | Text (35) |
| SQL name | BGiro | The database field name. |
| API identifier | bankAccount | The API identifier used in GraphQL. |
| Number | 18881 |
Contact e-mail
The contact persons e-mail address.
Enter e-mail address to the contact person in this field.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | E-mail address | Text (60) |
| SQL name | LiaMailAd | The database field name. |
| API identifier | contactEmailAddress | The API identifier used in GraphQL. |
| Number | 18886 |
Contact name
The clients contact with the debt collection company.
This field shall contain the name of the clients contact person with the debt collect company.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Name | Text (80) |
| SQL name | LiaActNm | The database field name. |
| API identifier | contactName | The API identifier used in GraphQL. |
| Number | 18884 |
Contact phone
The phone no. of the contact person.
Enter the phone no. of the contact person here.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Phone | Text (20) |
| SQL name | LiaPhone | The database field name. |
| API identifier | contactPhone | The API identifier used in GraphQL. |
| Number | 18885 |
Contact processing
Processing rules for the contact person.
- Contact for invoice inquiries
- Marked when the contact person shall receive information about invoices subject to debt collection from the debt collection company.
- Receiver of payment reports
- Marked when the contact person shall receive remittance reports from the debt collection company.
- Receiver of order confirmation
- Marked when the contact person shall receive order confirmations from the debt collection company.
- Receiver of debt collection list
- Marked when the contact person shall receive debt collection lists from the debt collection company.
- Web access
- Marked when the contact person is registered as a user at the debt collection company portal.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Contact processing | Integer |
| SQL name | LiaProc | The database field name. |
| API identifier | contactProcessing | The API identifier used in GraphQL. |
| Number | 19091 |
Days of grace debt collection
Shows the days of grace applied for invoices before becoming subject to debt collection.
The value in the field shows the no of days that have to go between an invoices due date and today's date before an invoice can be sent to debt collection. E.g.: invoices with a number of days between due date and today's date < number of days given in this field will be ignored when performing the Send to AutoCollect processing in the Open customer entry table.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Days | Integer |
| SQL name | GrcDy | The database field name. |
| API identifier | daysOfGraceDebtCollection | The API identifier used in GraphQL. |
| Number | 18908 |
Debt collection User ID
User ID for access to the debt collection company.
Defines the user id to be used when transferring invoices to the debt collection company.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | User name | Text (24) |
| SQL name | Usr | The database field name. |
| API identifier | debtCollectionUserID | The API identifier used in GraphQL. |
| Number | 18923 |
IBAN
The clients IBAN code.
Enter the clients bank account in this field, to be used for remittances from the debt collection company in those cases when the debtor pays their debt directly to the debt collection company.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Bank account | Text (35) |
| SQL name | IBAN | The database field name. |
| API identifier | iban | The API identifier used in GraphQL. |
| Number | 18883 |
Inf.
Information about the debt collection agreement.
The field can be filled out with information about the debt collection agreement.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | String of length 1000 | Text (1000) |
| SQL name | Inf | The database field name. |
| API identifier | information | The API identifier used in GraphQL. |
| Number | 18905 |
Invoice distribution
- 1 - AutoInvoice
- 2 - Compello
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Invoice distribution | Integer |
| SQL name | InvDistr | The database field name. |
| API identifier | invoiceDistribution | The API identifier used in GraphQL. |
| Number | 19597 |
Invoice e-mail address
Invoice address to be used by the debt collection company.
Enter the e-mail address for the clients person responsible for invoices from the debt collection company in this field.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | E-mail address | Text (60) |
| SQL name | MailAd | The database field name. |
| API identifier | invoiceEmailAddress | The API identifier used in GraphQL. |
| Number | 18880 |
Invoice information
Additional information on invoices sent to debt collection company.
Contains a free additional info to be added to invoices sent to the debt collection company.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | String of length 50 | Text (50) |
| SQL name | AddInf | The database field name. |
| API identifier | invoiceInformation | The API identifier used in GraphQL. |
| Number | 18911 |
Invoice information field
Additional information on invoices sent to debt collection company.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Invoice information field | Integer |
| SQL name | AddInfF | The database field name. |
| API identifier | invoiceInformationField | The API identifier used in GraphQL. |
| Number | 18913 |
Invoice information type
Additional information on invoices sent to debt collection company.
Defines type of additional information to be given with invoices transferred to the debt collection company. The information types are given are given by the debt collection company.
- 0 - No info
- 10 - Customer
- 20 - Order
- 30 - Cost unit from open entry
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Invoice information type | Integer |
| SQL name | AddInfT | The database field name. |
| API identifier | invoiceInformationType | The API identifier used in GraphQL. |
| Number | 18912 |
Minimum amount debt collection
Min amount for a debtors invoice to be sent to debt collection.
The min. amount (incl vat) that is required for an invoice to be sent to debt collection. When invoices are sent to debt collection using the Send to AutoCollect processing in the Open customer entry table, invoices with an amount > the amount entered in this field will be ignored.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Amount | Decimal |
| SQL name | MinAm | The database field name. |
| API identifier | minimumAmountDebtCollection | The API identifier used in GraphQL. |
| Number | 18907 |
No. of reminders sent
Min. no. of reminders sent for an invoice before it can become subject to debt collection.
When performing the Send to AutoCollect processing in the Open customer entry table, invoices with a value in the No. of reminders sent field < than the value in this field will be ignored.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Number of reminders | Integer |
| SQL name | Rems | The database field name. |
| API identifier | numberOfRemindersSent | The API identifier used in GraphQL. |
| Number | 18909 |
Organisation no. AO
Organisational no. for the accounting office.
The field contains the organisational no. for the accounting office when the client is linked to a main multi-agreement administered by an accounting office.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Organisation no. | Text (24) |
| SQL name | AOBsNo | The database field name. |
| API identifier | aOBusinessNo | The API identifier used in GraphQL. |
| Number | 18877 |
Organisational unit 1
Organisational unit to be used for debt collection costs and fees.
Used when posting settlements from Visma AutoCollect.
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 | 19093 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 1 | OrgUnit1 |
|
Organisational unit 2
Organisational unit to be used for debt collection costs and fees.
Used when posting settlements from Visma AutoCollect.
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 | 19094 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 2 | OrgUnit2 |
|
Organisational unit 3
Organisational unit to be used for debt collection costs and fees.
Used when posting settlements from Visma AutoCollect.
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 | 19095 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 3 | OrgUnit3 |
|
Organisational unit 4
Organisational unit to be used for debt collection costs and fees.
Used when posting settlements from Visma AutoCollect.
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 | 19096 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 4 | OrgUnit4 |
|
Organisational unit 5
Organisational unit to be used for debt collection costs and fees.
Used when posting settlements from Visma AutoCollect.
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 | 19097 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 5 | OrgUnit5 |
|
Organisational unit 6
Organisational unit to be used for debt collection costs and fees.
Used when posting settlements from Visma AutoCollect.
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 | 19098 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 6 | OrgUnit6 |
|
Organisational unit 7
Organisational unit to be used for debt collection costs and fees.
Used when posting settlements from Visma AutoCollect.
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 | 19099 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 7 | OrgUnit7 |
|
Organisational unit 8
Organisational unit to be used for debt collection costs and fees.
Used when posting settlements from Visma AutoCollect.
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 | 19100 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 8 | OrgUnit8 |
|
Organisational unit 9
Organisational unit to be used for debt collection costs and fees.
Used when posting settlements from Visma AutoCollect.
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 | 19101 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 9 | OrgUnit9 |
|
Organisational unit 10
Organisational unit to be used for debt collection costs and fees.
Used when posting settlements from Visma AutoCollect.
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 | 19102 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 10 | OrgUnit10 |
|
Organisational unit 11
Organisational unit to be used for debt collection costs and fees.
Used when posting settlements from Visma AutoCollect.
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 | 19103 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 11 | OrgUnit11 |
|
Organisational unit 12
Organisational unit to be used for debt collection costs and fees.
Used when posting settlements from Visma AutoCollect.
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 | 19104 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 12 | OrgUnit12 |
|
Primary key
The rows primary key.
The primary is the identity of the record and is given automatically by the program.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | No. | Integer |
| Primary key | Yes | Primary key |
| SQL name | PK | The database field name. |
| API identifier | primaryKey | The API identifier used in GraphQL. |
| Number | 18876 |
Reminder flow
Contains different definitions for the reminder flow.
Defines how invoices sent to the debt collection company for reminder administration shall be processed. The different definitions for the reminder flow is given by the debt collection company.
- 10 - Debt collection notice customer account
- 20 - Debt collection notice without charge customer account
- 30 - Payment reminder without charge customer account
- 40 - Payment reminder with charge customer account
- 50 - Collective reminder customer account
- 60 - Debt collection notice
- The debt collection notice is sent as the first and only reminder with 14 days due. The debt collection notice contains a fee and late payment interest. It can be sent on the 14th day after the invoice is due at the earliest, and includes payment information from Visma Amili AS.
- 70 - Payment reminder without charge
- Two letters are sent before debt collection: payment reminder and debt collection notice. A payment reminder does not contain a reminder fee, only late payment interest. The debt collection notice contains a fee and late payment interest. These can be sent on the 5th day after the invoice is due at the earliest, and include payment information from Visma Amili AS.
- 80 - Text message before debt collection notice
- An SMS is sent no earlier than 5 days after the invoice is due. The debt collection notice after SMS contains a reminder fee and late payment interest. The SMS contains the customer's payment information, and the debt collection notice contains payment information from Visma Amili AS.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Reminder flow | Integer |
| SQL name | RemFlow | The database field name. |
| API identifier | reminderFlow | The API identifier used in GraphQL. |
| Number | 18900 |
Swift code
The clients SWIFT code.
Enter the clients bank account in this field, to be used for remittances from the debt collection company in those cases when the debtor pays their debt directly to the debt collection company.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Swift code | Text (11) |
| SQL name | SwftCd | The database field name. |
| API identifier | swiftCode | The API identifier used in GraphQL. |
| Number | 18882 |
Transfer reminder to debt collection
Defines how transfer from reminder to debt collection shall be handled.
Defines for how invoices shall be transferred from reminder processing to debt collection after being transferred to the debt collection company. The definitions are given by the debt collection company.
- 10 - Automatic from reminder to debt collection
- 20 - Debt collection with automatic processing
- 30 - Debt collection manual processing
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Transfer reminder to debt collection | Integer |
| SQL name | TranType | The database field name. |
| API identifier | transferType | The API identifier used in GraphQL. |
| Number | 18901 |
VAT code
Tax code for costs and fees.
Defines what tax code to be used for costs and fees.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | VAT code | Integer |
| SQL name | TxCdTax | The database field name. |
| API identifier | taxCode | The API identifier used in GraphQL. |
| Number | 18919 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| VAT code | TaxCode |
|
VAT code outside customs area
Tax code for costs outside customs area.
Defines the tax code to be used for costs related to areas outside the customs area.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | VAT code | Integer |
| SQL name | TxCdOut | The database field name. |
| API identifier | taxCodeOutsideCustomsArea | The API identifier used in GraphQL. |
| Number | 18920 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| VAT code | TaxCodeOutsideCustomsArea |
|
Voucher series for settlements
Voucher series to be used when posting settlements from Visma AutoCollect.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Voucher series no. | Integer |
| SQL name | StlmVoSr | The database field name. |
| API identifier | settlementsVoucherSeriesNo | The API identifier used in GraphQL. |
| Number | 19088 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Voucher series | SettlementsVoucherSeries |
|
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. |