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
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| toDate | Datetime | Starting date. |
| fromDate | Datetime | Closing date. |
| PaymentsOnly | Boolean | Set this to true to get cash transactions only. |