Retrieves the details of transaction related to 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 AccountId column, which supports '=,IN' comparisons.

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

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