JDBC Driver for Zoho Books

Build 22.0.8479


Retrieves detail of line items of retainer invoices.

Table Specific Information


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: RetainerInvoiceId is required in order to query RetainerInvoiceLineItems.

  • RetainerInvoiceId supports the '=' comparison.
For example:
    SELECT * FROM RetainerInvoiceLineItems WHERE RetainerInvoiceId = '1894663000000085023'


Name Type References SupportedOperators Description
RetainerInvoiceId String


ID of a retainer invoice.
LineItemId [KEY] String Id of line item.
AccountId String


ID of the Bank Account.
BcyRate Decimal Rate of Base Currency.
Description String Description of the retainer invoice line item.
ItemOrder Integer Order of items.
ItemTotal Decimal Total number of items in retainer invoice.
Rate Decimal Rate of the line item.
TaxId String


Id of tax.
TaxName String Name of the tax.
TaxPercentage Integer Percentage applied for tax.
TaxType String Type of tax.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8479