JDBC Driver for Zoho Books

Build 22.0.8479


Get the details of line items of a recurring invoice.

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

  • RecurringInvoiceId supports the '=' comparison.
For example:
    SELECT * FROM RecurringInvoiceLineItems WHERE RecurringInvoiceId = '1895453000000042244'


Name Type References SupportedOperators Description
LineItemId [KEY] String ID of line item.
RecurringInvoiceId String


ID of recurring invoice.
ItemId String


ID of the item.
ItemOrder Integer Order of the item.
ItemTotal Decimal Total number of item.
Description String Description of the recurring invoice line item.
Discount String Amount of discount applied for items of recurring invoice.
DiscountAmount Decimal Amount of discount.
HeaderId String ID of the header.
HeaderName String Name of the header.
Name String Name of the recurring invoice line item.
ProjectId String


Id of the project.
Quantity String Total number of item.
Rate Decimal Rate for recurring invoice..
TaxId String


Id of tax.
TaxName String Name of the tax.
TaxPercentage Integer Percentage applied for tax.
TaxType String Type of tax.
Unit String Total quantity included in recurring invoice items.

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