JDBC Driver for Zoho Books

Build 22.0.8479


Get the details of line items for estimates.

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

  • EstimateId supports the '=' comparison.
For example:
    SELECT * FROM EstimateLineItems WHERE EstimateId = '1894553000000077244'


Name Type References SupportedOperators Description
LineItemId [KEY] String Id of the line item.
EstimateId String


ID of an estimate.
BcyRate Decimal Rate of base currency.
CustomFields String Custom Fields defined for the line item
Description String Description of the estimate line items.
Discount String Discount given to specific item in estimate.
DiscountAmount Decimal Amount of discount given to estimate.
HeaderId String ID of the header.
HeaderName String Name of the header.
ItemId String


ID of the item.
ItemOrder Integer Order of the item.
ItemTotal Decimal Total number of items.
Name String Name of the line item.
PricebookId String Id of a pricebook.
Quantity Decimal Quantity of the line item.
Rate Decimal Rate of the line item.
Tags String Details of tags related to estimates.
TaxId String


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

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