BankAccountLastImportedStatementTransactions
Get the details of transaction related to previously imported statement for the account.
Table Specific Information
Select
The component uses the Zoho Books API to process WHERE clause conditions built with the following columns and operators:
- AccountId supports the '=,IN' comparison.
The rest of the filter is executed client-side in the component.
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 | Transaction Id | ||
AccountId | String |
BankAccounts.AccountId | = | ID of the Bank/Credit Card account |
TransactionType | String | Transaction Type | ||
Status | String | Status | ||
ReferenceNumber | String | Reference Number | ||
Payee | String | Payee involved in the transaction | ||
DebitOrCredit | String | Indicates if transaction is Debit or Credit | ||
Date | Date | Date of the transaction | ||
CustomerId | Long | Customer ID | ||
Amount | Integer | Amount involved in the transaction |