BankAccountLastImportedStatement
Retrieves 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 | The From Date | ||
| Source | String | Source | ||
| ToDate | Date | The To Date | ||
| Transactions | String | Transactions |