Account statement detail
This table contains details for the bank account transactions received from Visma.net AutoPay.
It includes more details about the transactions in the Account statement transaction table, for example when one row in the table covers several incoming payments, then they are specified here.
| Property | Value | Description |
|---|---|---|
| Database | Company | This table is in the company databases. |
| SQL name | AcStmtDe | The table name in the database. |
| API identifier | accountStatementDetail | The API identifier used in GraphQL. |
| Table no. | 437 | The table number in the data model. |
The following fields exist in this table:
Account servicer reference
Reference identifying the bank account transaction.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | String of length 40 | Text (40) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | AcSrvRef | The database field name. |
| API identifier | accountServicerReference | The API identifier used in GraphQL. |
| Number | 18703 |
Account statement trans. no.
Reference identifying the bank account transaction.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | No. | Integer |
| Primary key | Yes | Account statement trans. no., Line no. |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | AcStmtTrNo | The database field name. |
| API identifier | accountStatementTransactionNo | The API identifier used in GraphQL. |
| Number | 18700 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Account statement transaction | AccountStatementTransaction |
|
Additional information
Additional information about the payment transaction.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Text line | Text (200) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | AdInf | The database field name. |
| API identifier | additionalInformation | The API identifier used in GraphQL. |
| Number | 18737 |
Amount
Bank transaction amount in standard currency.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Amount | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | Am | The database field name. |
| API identifier | amountDomestic | The API identifier used in GraphQL. |
| Number | 18713 |
Amount in currency
Bank transaction amount in foreign currency.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | InstAm | The database field name. |
| API identifier | amountInCurrency | The API identifier used in GraphQL. |
| Number | 18712 |
Charge bearer
Responsible for paying the charges.
- DEBT: Debtor pays all charges
- CRED: Creditor pays all charges
- SHAR: Debtor and Creditor pay their own charges
- SLEV: Charges follow the service level; the only allowed alternative for SEPA payments
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | String of length 4 | Text (4) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | ChgBr | The database field name. |
| API identifier | chargeBearer | The API identifier used in GraphQL. |
| Number | 18717 |
Charges amount
Charges amount.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | ChgAm | The database field name. |
| API identifier | chargesAmount | The API identifier used in GraphQL. |
| Number | 18716 |
Clearing system reference
Reference identifying the bank transaction's payment type.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | String of length 40 | Text (40) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | ClrSysRef | The database field name. |
| API identifier | clearingSystemReference | The API identifier used in GraphQL. |
| Number | 18709 |
Currency no.
Currency for the transaction.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Currency no. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | Cur | The database field name. |
| API identifier | currencyNo | The API identifier used in GraphQL. |
| Number | 18714 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Currency | Currency |
|
Domain code
Reference identifying the bank transaction's payment type.
- PMNT=Payments
- ACMT=Account Management
- NTAV=Not available
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | String of length 4 | Text (4) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | DmCd | The database field name. |
| API identifier | domainCode | The API identifier used in GraphQL. |
| Number | 18718 |
End-to-end ID
Reference identifying the bank account transaction.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | String of length 40 | Text (40) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | EteId | The database field name. |
| API identifier | endToEndId | The API identifier used in GraphQL. |
| Number | 18706 |
Exchange rate
Exchange rate used for the transaction.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Exchange rate | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | ExRt | The database field name. |
| API identifier | exchangeRate | The API identifier used in GraphQL. |
| Number | 18715 |
Family code
Reference identifying the bank transaction's payment type.
- RCDT=Received credit transfers
- RDDT=Received direct debit
- RCCN=Received Cash Concentration Transactions
- MCOP=Miscellaneous credit operations
- MDOP=Miscellaneous debit operations
- ICDT=Issued Credit transfers
- ICCN=Issued Cash Concentration Transactions
- ICHQ=Issued cheques
- IDDT=Issued Direct Debits
- OTHR=Other
- NTAV=Not available
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | String of length 4 | Text (4) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | FmCd | The database field name. |
| API identifier | familyCode | The API identifier used in GraphQL. |
| Number | 18719 |
Instructed ID
Reference identifying the bank account transaction.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | String of length 40 | Text (40) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | InstId | The database field name. |
| API identifier | instructedId | The API identifier used in GraphQL. |
| Number | 18705 |
Invoice no.
Invoice no. for the payment.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Doc. no. | Text (40) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | InvoNo | The database field name. |
| API identifier | invoiceNo | The API identifier used in GraphQL. |
| Number | 18735 |
Line no.
Each line in the table is given a consecutive number in the order in which they are entered.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | No. | Integer |
| Primary key | Yes | Account statement trans. no., Line no. |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | LnNo | The database field name. |
| API identifier | lineNo | The API identifier used in GraphQL. |
| Number | 18701 |
Mandate ID
Reference identifying the bank account transaction.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | String of length 40 | Text (40) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | ManId | The database field name. |
| API identifier | mandateId | The API identifier used in GraphQL. |
| Number | 18708 |
Message
Information about the transaction.
Contains e.g. invoice number, when CID code is not used.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Text line | Text (200) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | InfMsg | The database field name. |
| API identifier | informationMessage | The API identifier used in GraphQL. |
| Number | 18736 |
Message ID
Reference identifying the bank account transaction.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | String of length 40 | Text (40) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | MsgId | The database field name. |
| API identifier | messageId | The API identifier used in GraphQL. |
| Number | 18702 |
Payment ERP reference
Reference identifying the bank account transaction.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | String of length 40 | Text (40) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | PmtErpRef | The database field name. |
| API identifier | paymentErpReference | The API identifier used in GraphQL. |
| Number | 18711 |
Payment information ID
Reference identifying the bank account transaction.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | String of length 40 | Text (40) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | PmtInfId | The database field name. |
| API identifier | paymentInformationId | The API identifier used in GraphQL. |
| Number | 18704 |
Proprietary
Reference identifying the bank account transaction.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | String of length 40 | Text (40) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | Prp | The database field name. |
| API identifier | proprietary | The API identifier used in GraphQL. |
| Number | 18710 |
Proprietary code
Reference identifying the bank transaction's payment type.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | String of length 40 | Text (40) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | PrpCd | The database field name. |
| API identifier | proprietaryCode | The API identifier used in GraphQL. |
| Number | 18721 |
Proprietary issuer
Reference identifying the bank transaction's payment type.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | String of length 40 | Text (40) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | PrpIs | The database field name. |
| API identifier | proprietaryIssuer | The API identifier used in GraphQL. |
| Number | 18722 |
Receivers reference ID
The payment receiver's reference for the payment.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | String of length 40 | Text (40) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | RecRefId | The database field name. |
| API identifier | receiversReferenceId | The API identifier used in GraphQL. |
| Number | 18732 |
Referred doc. amount
The payment amount.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Amount | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | RfDocAm | The database field name. |
| API identifier | referredDocumentAmount | The API identifier used in GraphQL. |
| Number | 18731 |
Referred doc. type
Identifies if the payment is an invoice or a credit note.
- CINV = Commercial Invoice
- CREN = Credit Note
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | String of length 4 | Text (4) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | RfDocTp | The database field name. |
| API identifier | referredDocumentType | The API identifier used in GraphQL. |
| Number | 18734 |
Referred document no.
CID code, or other reference, for the payment.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | String of length 40 | Text (40) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | RfDocNo | The database field name. |
| API identifier | referredDocumentNo | The API identifier used in GraphQL. |
| Number | 18733 |
Relation account no.
Bank account no. on the payment transaction.
Supplier information on outgoing payments, customer information on incoming payments.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not 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 | RelAcNo | The database field name. |
| API identifier | relationAccountNo | The API identifier used in GraphQL. |
| Number | 18730 |
Relation address line
Address line on the payment transaction.
Supplier information on outgoing payments, customer information on incoming payments.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Address line | Text (60) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | RelAd | The database field name. |
| API identifier | relationAddressLine | The API identifier used in GraphQL. |
| Number | 18724 |
Relation BIC
BIC/SWIFT on the payment transaction.
Supplier information on outgoing payments, customer information on incoming payments.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Swift code | Text (11) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | RelBic | The database field name. |
| API identifier | relationBic | The API identifier used in GraphQL. |
| Number | 18728 |
Relation country no.
Country on the payment transaction.
Supplier information on outgoing payments, customer information on incoming payments.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Country no. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | RelCtry | The database field name. |
| API identifier | relationCountryNo | The API identifier used in GraphQL. |
| Number | 18727 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Country | RelationCountry |
|
Relation ID
Id on the payment transaction.
Supplier information on outgoing payments, customer information on incoming payments.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | String of length 20 | Text (20) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | RelId | The database field name. |
| API identifier | relationId | The API identifier used in GraphQL. |
| Number | 18729 |
Relation name
Name on the payment transaction.
Supplier information on outgoing payments, customer information on incoming payments.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Name | Text (80) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | RelNm | The database field name. |
| API identifier | relationName | The API identifier used in GraphQL. |
| Number | 18723 |
Relation post code
Post code on the payment transaction.
Supplier information on outgoing payments, customer information on incoming payments.
If you enter a Post code that exists in the Postal address table, the Postal area field is filled in and the cursor jumps to the next field. If the Post code does not exist you will see a warning in the Status bar and the cursor will then stop in the Postal area field so you can type in the Postal area manually.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Post code | Text (40) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | RelPNo | The database field name. |
| API identifier | relationPostCode | The API identifier used in GraphQL. |
| Number | 18725 |
Relation postal area
Postal area on the payment transaction.
Supplier information on outgoing payments, customer information on incoming payments.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Address line | Text (60) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | RelPArea | The database field name. |
| API identifier | relationPostalArea | The API identifier used in GraphQL. |
| Number | 18726 |
Sub family code
Reference identifying the bank transaction's payment type.
- DMCT=Domestic credit transfer
- XBCT=Cross-border credit transfer
- ESCT=SEPA credit transfer
- ICCT=Intra company Transfer
- ATXN=ACH Transaction
- BCHQ=Bank Cheque
- BBDD=SEPA B2B Direct Debit
- ESDD=SEPA Core Direct Debit
- UPDD=Reversal Due To Return/Unpaid Direct Debit
- PRDD=Reversal Due to Payment Reversal
- OTHR=Other
- NTAV=Not available
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | String of length 4 | Text (4) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | SubFmCd | The database field name. |
| API identifier | subFamilyCode | The API identifier used in GraphQL. |
| Number | 18720 |
Transaction ID
Reference identifying the bank account transaction.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | String of length 40 | Text (40) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | TransId | The database field name. |
| API identifier | transactionId | The API identifier used in GraphQL. |
| Number | 18707 |
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. |