BankTransactionLineItems
Get details of bank transaction line items.
Table Specific Information
Select
The add-in 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 add-in.
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. |