Retrieves Imported Transactions.

Table Specific Information

Select

The add-in 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 add-in.

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			The Imported Transaction Id
TransactionId	String	BankTransactions.TransactionId	=	The Transaction Id
AccountId	String	BankAccounts.AccountId		The Id of the Bank/Credit Card account
Amount	Integer			Amount
Date	Date			The Date of the transaction
Description	String			Description
Payee	String			The Payee involved in the transaction
ReferenceNumber	String			A Reference Number
Status	String			Status