ADO.NET Provider for Zoho Books

Build 22.0.8462

EstimateLineItems

Get the details of line items for estimates.

Table Specific Information

Select

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

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

Columns

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

Estimates.EstimateId

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

Items.ItemId

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

Taxes.TaxId

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.8462