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. |