EstimateLineItems
Get the details of line items for estimates.
Table Specific Information
Select
The add-in 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 add-in.
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. | ||
| Discounts | String | Discounts applied to the line item. | ||
| Documents | String | Documents associated with the line item. | ||
| ImageDocumentId | String | ID of the image document for the line item. | ||
| InternalName | String | Internal name of the line item. | ||
| LineItemTaxes | String | Taxes applied to the line item. | ||
| PricingScheme | String | Pricing scheme of the line item. | ||
| TdsTaxAmount | Decimal | TDS tax amount for the line item. | ||
| TdsTaxId | String | ID of the TDS tax for the line item. | ||
| TdsTaxName | String | Name of the TDS tax for the line item. | ||
| TdsTaxPercentage | Decimal | Percentage of the TDS tax for the line item. | ||
| TdsTaxType | String | Type of the TDS tax for the line item. |