QuotedItems
Shows itemized products on customer quotes, including list price, taxes, and applied discounts.
View-Specific Information
The QuotedItems view is only accessible when connected to a ZohoCRM Enterprise Edition account. If using a different edition, this view may not be available.
Select
The provider uses the Zoho CRM API to process WHERE clause conditions built with the following column and operator. The remainder of the filter is executed client-side within the provider.
- Id supports the '=' operator.
The following example demonstrates a basic query processed server-side:
-- Query a specific quoted item by its unique ID
SELECT * FROM QuotedItems WHERE Id = '3152079000000301143'
Columns
| Name | Type | Description |
| Id [KEY] | String | Unique identifier for the quoted item. |
| Sequence_Number | Long | Serial number indicating the item's position in the list. |
| Created_Time | Datetime | Date and time when the quoted item record was created. |
| Modified_Time | Datetime | Date and time when the quoted item record was last modified. |
| Parent_Id_Id | String | Unique identifier of the quote to which this item belongs. |
| Product_Name_Id | String | Unique identifier of the product being quoted. |
| Description | String | Description of the quoted item. |
| Quantity | Double | Quantity of the product being quoted. |
| Price_Book_Name_Id | String | Unique identifier of the price book associated with the quoted item. |
| List_Price | Decimal | List price of the product. |
| Total | String | Total amount for the item before discount and tax. |
| Discount | Decimal | Discount applied to the quoted item. |
| Total_After_Discount | String | Amount after applying the discount, before tax. |
| Tax | Decimal | Tax amount applied to the quoted item. |
| Net_Total | String | Final total amount after applying discount and tax. |
| Line_Tax | String | Tax applied as a percentage value. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer more granular control over the data returned from the data source.
| Name | Type | Description |
| DuplicateCheckFields | String | The field(s) to be used for checking duplicate records in an upsert. The REST API allows for more than one field in the duplicate check but the BULK API only allows one field. |
| Trigger | String | To trigger the rule while inserting record into CRM account. |