EstimateLineItems
Get the details of line items for estimates.
Table Specific Information
Select
The connector 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 connector.
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. |