BankTransactionLineItems

Get details of bank transaction line items.

Table Specific Information

Select

The cmdlet 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 cmdlet.

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.

Cmdlets for Zoho Books

BankTransactionLineItems

Table Specific Information

Select

Columns