Visma.net AutoPay log
This table contains one row for each transfer to/from Visma.net AutoPay.
| Property | Value | Description |
|---|---|---|
| Database | Company | This table is in the company databases. |
| SQL name | APLog | The table name in the database. |
| API identifier | autopayLog | The API identifier used in GraphQL. |
| Table no. | 397 | The table number in the data model. |
The following fields exist in this table:
Bank account
Bank account used on the payment.
Note:
For log entries with File type = 5 - Status changes report:
- The bank account is taken from the import file and can have different format than the bank account on the bank partner (IBAN vs. BBAN).
- If the payment batch contains more than one bank account, the text Multiple is shown.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Bank account | Text (35) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | BGiro | The database field name. |
| API identifier | bankAccount | The API identifier used in GraphQL. |
| Number | 17745 |
File data
Contains the imported XML file.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | File in BLOB | Unlimited text |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | FlData | The database field name. |
| API identifier | autopayFile | The API identifier used in GraphQL. |
| Number | 18564 |
File type
Content type for the file sent/received.
- 1 - Incoming payment
- 2 - Direct Debit customer information
- 3 - Direct Debit payment
- 4 - Outgoing payment
- 5 - Status changes report
- 6 - Status changes update
- 7 - Currency exchange rates import
- 8 - Account statement
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | File type | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | APType | The database field name. |
| API identifier | fileType | The API identifier used in GraphQL. |
| Number | 17747 |
Identifier
Unique file identifier in Visma.net AutoPay.
Only applicable for incoming file types 1 - Incoming payment and 2 - Direct Debit customer information.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | String of length 80 | Text (80) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | FileId | The database field name. |
| API identifier | identifier | The API identifier used in GraphQL. |
| Number | 17746 |
No.
A unique number identifying the Visma.net AutoPay log row.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | No. | Integer |
| Primary key | Yes | No. |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | SeqNo | The database field name. |
| API identifier | entryNo | The API identifier used in GraphQL. |
| Number | 17744 |
Origin
Manually or automatically started transfer.
- 1 - Automatic entry
- The file/message was automatically imported by the Visma Business Host for OD MessageQueue.
- 2 - Manual
- The file/message was processed manually by running the processing Upload data or Download data.
- 3 - 2100***Manually uploaded
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Origin | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | APOrig | The database field name. |
| API identifier | origin | The API identifier used in GraphQL. |
| Number | 17749 |
Status
Status of the import/export.
- 1 - Processed
- Processing of the file/message completed successfully.
- 2 - Pending
- Processing of the file/message started, but did not complete correctly.
- 3 - Downloaded previously, not processed
- The file has already been processed. Multiple downloads of the same file, either via the Download data processing or automatically (MessageQueue), is not allowed. However, for error situation, it is possible to force processing of the file via the Process file processing from the Visma.net AutoPay log table.
- 4 - Error while processing file
- Can indicate a deserialization or file interpretation error.
- 5 - Connection/operation error
- Service connection errors when attempting to download.
- 6 - Error: No content to process
- The downloaded file did not have any content.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Status | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | APSt | The database field name. |
| API identifier | status | The API identifier used in GraphQL. |
| Number | 17748 |
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.
Note:
If you double-click or press * in this field, you
can look up a value in the related table.
| 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. |