Account statement transaction
This table contains bank account transactions received from Visma.net AutoPay and is used for bank reconciliation.
| Property | Value | Description |
|---|---|---|
| Database | Company | This table is in the company databases. |
| SQL name | AcStmtTr | The table name in the database. |
| API identifier | accountStatementTransaction | The API identifier used in GraphQL. |
| Table no. | 434 | The table number in the data model. |
The following fields exist in this table:
Account statement ID
Reference identifying the account statement.
| 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) |
| SQL name | AcStmtId | The database field name. |
| API identifier | accountStatementId | The API identifier used in GraphQL. |
| Number | 18676 |
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. |
| SQL name | AcStmtTrNo | The database field name. |
| API identifier | accountStatementTransactionNo | The API identifier used in GraphQL. |
| Number | 18630 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Account statement detail | AccountStatementDetail |
|
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 |
| SQL name | Am | The database field name. |
| API identifier | amountDomestic | The API identifier used in GraphQL. |
| Number | 18683 |
Amount in currency
Bank transaction amount in foreign currency.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Amount | Decimal |
| SQL name | InstAm | The database field name. |
| API identifier | amountInCurrency | The API identifier used in GraphQL. |
| Number | 18682 |
Bank account no.
Bank account for the account statement.
| 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 | bankAccountNo | The API identifier used in GraphQL. |
| Number | 18675 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Bank partner | BankPartner |
|
Bank 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 | Bank reference | Text (30) |
| SQL name | BankRef | The database field name. |
| API identifier | bankReference | The API identifier used in GraphQL. |
| Number | 18681 |
Bank trans. no.
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 | No. | Integer |
| SQL name | TranNo | The database field name. |
| API identifier | entryNo | The API identifier used in GraphQL. |
| Number | 18679 |
Booking date
Booking date for the transaction.
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 | BkDt | The database field name. |
| API identifier | bookingDate | The API identifier used in GraphQL. |
| Number | 18686 |
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) |
| SQL name | ChgBr | The database field name. |
| API identifier | chargeBearer | The API identifier used in GraphQL. |
| Number | 18689 |
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 |
| SQL name | ChgAm | The database field name. |
| API identifier | chargesAmount | The API identifier used in GraphQL. |
| Number | 18688 |
Closing balance
The transaction date's closing balance.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| SQL name | ClBal | The database field name. |
| API identifier | closingBalance | The API identifier used in GraphQL. |
| Number | 18696 |
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 |
| SQL name | Cur | The database field name. |
| API identifier | currencyNo | The API identifier used in GraphQL. |
| Number | 18684 |
| 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) |
| SQL name | DmCd | The database field name. |
| API identifier | domainCode | The API identifier used in GraphQL. |
| Number | 18690 |
Electronic seq. no.
Reference identifying the account statement.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | No. | Integer |
| SQL name | ElSeqNo | The database field name. |
| API identifier | electronicSequenceNo | The API identifier used in GraphQL. |
| Number | 18677 |
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 |
| SQL name | ExRt | The database field name. |
| API identifier | exchangeRate | The API identifier used in GraphQL. |
| Number | 18685 |
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) |
| SQL name | FmCd | The database field name. |
| API identifier | familyCode | The API identifier used in GraphQL. |
| Number | 18691 |
Interest date
Interest date for the transaction.
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 | IntDt | The database field name. |
| API identifier | interestDate | The API identifier used in GraphQL. |
| Number | 18687 |
Legal seq. no.
Reference identifying the account statement.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | No. | Integer |
| SQL name | LgSeqNo | The database field name. |
| API identifier | legalSequenceNo | The API identifier used in GraphQL. |
| Number | 18678 |
Opening balance
The transaction date's opening balance.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| SQL name | OpBal | The database field name. |
| API identifier | openingBalance | The API identifier used in GraphQL. |
| Number | 18695 |
Origin
The origin of the transaction.
- 1 - Manually entered
- The row has been manually created.
- 2 - Imported from AutoPay
- The row has been imported from Visma.net AutoPay.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Origin | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | Orig | The database field name. |
| API identifier | origin | The API identifier used in GraphQL. |
| Number | 18775 |
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) |
| SQL name | PrpCd | The database field name. |
| API identifier | proprietaryCode | The API identifier used in GraphQL. |
| Number | 18693 |
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) |
| SQL name | PrpIs | The database field name. |
| API identifier | proprietaryIssuer | The API identifier used in GraphQL. |
| Number | 18694 |
Reconciliation rest amount
Amount not reconciled.
Used for bank reconciliation of bank accounts in domestic currency.
Can be edited manually. The value must be between 0 and the transaction amount. The Reconciliation rest amount in currency field will then be calculated automatically.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Amount | Decimal |
| SQL name | RecRAm | The database field name. |
| API identifier | reconciliationRestAmountDomestic | The API identifier used in GraphQL. |
| Number | 18699 |
Reconciliation rest amount in currency
Amount not reconciled in currency.
Used for bank reconciliation of bank accounts in foreign currency.
Can be edited manually. The value must be between 0 and the transaction amount. The Reconciliation rest amount field will then be calculated automatically.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Amount | Decimal |
| SQL name | CurRecRAm | The database field name. |
| API identifier | reconciliationRestAmountInCurrency | The API identifier used in GraphQL. |
| Number | 18697 |
Reconciliation rest amount in EURO
The Reconciliation rest amount field converted to EURO.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Source column | Reconciliation rest amount in currency | Euro |
| Write Access | None | You are not allowed to modify the value in this field. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | reconciliationRestAmountInEuro | The API identifier used in GraphQL. |
| Number | 18698 |
Reconciliation status
Status telling if the transaction has been manually enabled/disabled for reconciliation.
Status is set when the Disable reconciliation or the Enable reconciliation processing is executed for the row.
- 0 - None
- 1 - Reconciliation disabled
- 2 - Reconciliation enabled
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Reconciliation status | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | RecSt | The database field name. |
| API identifier | reconciliationStatus | The API identifier used in GraphQL. |
| Number | 19537 |
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) |
| SQL name | Ref | The database field name. |
| API identifier | reference | The API identifier used in GraphQL. |
| Number | 18680 |
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) |
| SQL name | SubFmCd | The database field name. |
| API identifier | subFamilyCode | The API identifier used in GraphQL. |
| Number | 18692 |
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. |