Get the details of previously imported statement for the account.

Table Specific Information

Select

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

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.