BankTransactionImportedTransaction
Retrieves Imported Transactions.
Table Specific Information
Select
The driver 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 driver.
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. |