BankTransactionLineItems

Get details of bank transaction line items.

Table Specific Information

Select

The 本製品 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 本製品.
Note: TransactionId is required in order to query BankTransactionLineItems.

TransactionId supports the '=' comparison.

For example:

    SELECT * FROM BankTransactionLineItems WHERE TransactionId = '1894553000000098001'

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.

ADO.NET Provider for Zoho Books

BankTransactionLineItems

Table Specific Information

Select

Columns