BankAccountLastImportedStatementTransactions
Get the details of transaction related to previously imported statement for the account.
Table Specific Information
Select
The 本製品 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 本製品.
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 |