BankSummary
Query the balances and cash movements for each bank account.
Columns
| Name | Type | Description |
| ID [KEY] | Integer | The row number. |
| BankAccount | String | The Bank account number. |
| OpeningBalance | Decimal | Amount of funds in the account at the beginning of the financial period. |
| CashReceived | Decimal | Amount added to the account. |
| CashSpent | Decimal | Amount subtracted from the account. |
| FXGain | Decimal | Changes in the account caused by currency conversions |
| ClosingBalance | Decimal | Amount of funds in the account at the end of the financial period. |
| TenantId | String | The ID of the tenant to query instead of the connection tenant |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| Name | Type | Description |
| toDate | Datetime | Starting date. |
| fromDate | Datetime | Closing date. |
| PaymentsOnly | Boolean | Set this to true to get cash transactions only. |