ChartOfAccountInlineTransactions
Retrieves the list of inline transactions.
Table Specific Information
Select
The add-in uses the Zoho Books API to process WHERE clause conditions built with the following column and operator:
- ChartAccountId supports the '=' comparison.
The rest of the filter is executed client-side in the add-in.
For example:
SELECT * FROM ChartOfAccountInlineTransactions WHERE ChartAccountId = '1894553000000003003'
Columns
| Name | Type | References | SupportedOperators | Description |
| ChartAccountId | String |
BankAccounts.AccountId | Id of the Bank Account. | |
| TransactionId [KEY] | String |
BankTransactions.TransactionId | Id of the Transaction. | |
| Credit | Decimal | Credit of inline transaction. | ||
| CustomerId | String |
Contacts.ContactId | Id of the customer or vendor. | |
| CustomerName | String | Name of the customer or vendor. | ||
| Date | Date | Date of an inline account transaction. | ||
| Debit | String | Debit of inline transaction. | ||
| EntityType | String | Entity type of inline transactions. | ||
| FcyCredit | Decimal | Foreign Currency credits. | ||
| FcyDebit | String | Foreign Currency debits. | ||
| ReferenceNumber | String | Reference number of inline transactions. |