BankAccountLastImportedStatement
Get the details of previously imported statement for the account.
Table Specific Information
Select
The add-in uses the Zoho Books API to process WHERE clause conditions built with the AccountId column, which supports '=,IN' comparisons.The rest of the filter is executed client-side in the add-in.
For example:
SELECT * FROM BankAccountLastImportedStatement WHERE accountid = '3255827000000101306'
SELECT * FROM BankAccountLastImportedStatement WHERE accountid IN ('3255827000000101306', '3255827000000101223')
Columns
| Name | Type | References | SupportedOperators | Description |
| StatementId [KEY] | Long | The Statement Id. | ||
| AccountId | String |
BankAccounts.AccountId | = | The Id of the Bank/Credit Card account. |
| FromDate | Date | From Date. | ||
| Source | String | Source. | ||
| ToDate | Date | To Date. | ||
| Transactions | String | Transactions. |