BankTransactionLineItems
Get details of bank transaction line items.
Table Specific Information
Select
The connector uses the Zoho Books API to process WHERE clause conditions built with the following column and operator:
- TransactionId supports the '=' and IN operators.
NOTE: TransactionId is required to query BankTransactionLineItems.
The rest of the filter is executed client-side in the connector.
For example:
SELECT * FROM BankTransactionLineItems WHERE TransactionId = '1894553000000098001'
SELECT * FROM BankTransactionLineItems WHERE TransactionId IN (SELECT TransactionId FROM BankTransactions)
SELECT * FROM BankTransactionLineItems WHERE TransactionId IN ('1894553000000098001','1894553000000098002')
Columns
| Name | Type | References | SupportedOperators | Description |
| TransactionId [KEY] | String |
BankTransactions.TransactionId | Id of the Transaction. | |
| BcyTotal | Decimal | Total Base Currency. | ||
| CustomerId | String |
Contacts.ContactId | Id of the customer or vendor. | |
| CustomerName | String | Name of the customer or vendor. | ||
| FromAccountId | String |
BankAccounts.AccountId | Transaction from account Id. | |
| FromAccountName | String | Transaction from account name. | ||
| PaymentMode | String | Mode through which payment is made. | ||
| SubTotal | Decimal | Sub total of bank transaction line items. | ||
| Tags | String | Details of tags related to bank transactions. | ||
| Total | Decimal | Total of bank transaction line items. | ||
| VendorId | String | Id of the vendor the bank transaction line items has been made. | ||
| VendorName | String | Name of the vendor the bank transaction line items has been made. |