ChartOfAccountInlineTransactions
Retrieves the list of inline transactions.
Table Specific Information
Select
The connector will use the Zoho Books API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the connector.
- ChartAccountId supports the '=' comparison.
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. |