Retrieves the details of transactions related to previously imported statements for the account.

Table Specific Information

Select

The connector uses the Zoho Books API to process WHERE clause conditions built with AccountId column, which supports '=,IN' comparisons.

The rest of the filter is executed client-side in the connector.

For example:

    SELECT * FROM BankAccountLastImportedStatementTransactions WHERE accountid = '3255827000000101306'

    SELECT * FROM BankAccountLastImportedStatementTransactions WHERE accountid IN ('3255827000000101306', '3255827000000101223')

Columns

Name	Type	References	SupportedOperators	Description
TransactionId [KEY]	Long			The Transaction Id.
AccountId	String	BankAccounts.AccountId	=	The Id of the Bank/Credit Card account.
TransactionType	String			The Transaction Type.
Status	String			Status.
ReferenceNumber	String			A Reference Number.
Payee	String			The Payee involved in the transaction.
DebitOrCredit	String			Indicates if transaction is Debit or Credit.
Date	Date			The Date of the transaction.
CustomerId	Long			The Customer Id.
Amount	Integer			The Amount involved in the transaction.