Retrieves Imported Transactions.

Table Specific Information

Select

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

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

For example:

    SELECT * FROM BankTransactionImportedTransaction WHERE transactionid = '3255827000000101458'

    SELECT * FROM BankTransactionImportedTransaction WHERE transactionid IN ('3255827000000101458', '3255827000000102354')

Columns

Name	Type	References	SupportedOperators	Description
ImportedTransactionId [KEY]	Long			Imported Transaction Id.
TransactionId	String	BankTransactions.TransactionId	=	The Transaction Id.
AccountId	String	BankAccounts.AccountId		The Id of the Bank/Credit Card account.
Amount	Integer			The Amount.
Date	Date			The Date of the transaction.
Description	String			A Description.
Payee	String			The Payee involved in the transaction.
ReferenceNumber	String			A Reference Number.
Status	String			Status.