Get details of bank transaction line items.
Table Specific Information
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.
Note: TransactionId is required in order to query BankTransactionLineItems.
- TransactionId supports the '=' comparison.
SELECT * FROM BankTransactionLineItems WHERE TransactionId = '1894553000000098001'
|ID of the Transaction.|
|BcyTotal||Decimal||Total Base Currency.|
|ID of the customer or vendor.|
|CustomerName||String||Name of the customer or vendor.|
|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.|