Cmdlets for Zoho Books

Build 24.0.8963

EstimateLineItems

Get the details of line items for estimates.

Table Specific Information

Select

The 本製品 uses the Zoho Books API to process WHERE clause conditions built with the following column and operator:

  • EstimateId supports the '=' and IN operators.

NOTE: EstimateId is required to query EstimateLineItems.

The rest of the filter is executed client-side in the 本製品.

For example:

    SELECT * FROM EstimateLineItems WHERE EstimateId = '1894553000000077244'
	SELECT * FROM EstimateLineItems WHERE EstimateId IN (SELECT EstimateId FROM Estimates)
	SELECT * FROM EstimateLineItems WHERE EstimateId IN ('1894553000000077244','1894553000000077245')

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.
SKU String The SKU of the Line Item.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.8963