QuotedItems
Displays itemized products on customer quotes, including quantity, list price, and tax.
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.
Note: This view is not available in the v2 schema.
Select
The 本製品 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 本製品.
- 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 of the quoted item record. |
| S.NO | Long | Serial number of the quoted item. |
| CreatedTime | Datetime | Timestamp when the quoted item record was created. |
| ParentID_Id | String | Unique identifier of the parent quote. |
| ParentID_Name | String | Name of the parent quote. |
| ProductName_Id | String | Unique identifier of the quoted product. |
| ProductName_Name | String | Name of the quoted product. |
| PriceBook_Id | String | Unique identifier of the price book linked to the quoted product. |
| PriceBook_Name | String | Name of the price book linked to the quoted product. |
| Description | String | Description of the quoted item. |
| Quantity | String | Quantity of the product being quoted. |
| ListPrice | Decimal | List price of the product being quoted. |
| Amount | String | Total amount before discounts and taxes. |
| Discount | Decimal | Discount applied to the quoted item. |
| TotalAfterDiscount | String | Total amount after applying the discount. |
| Tax | Decimal | Tax applied to the quoted item. |
| Total | String | Total amount including tax. |
| TaxbyPercentage | String | Tax applied to the quoted item, expressed as a percentage. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| DuplicateCheckFields | String | The fields used to check for duplicate records during an upsert operation. |
| CustomViewId | Long | Custom view identifier used to filter this record. Only works when the useCOQL parameter is set to false. |
| Trigger | String | Used to trigger automation rules when inserting the record into the CRM account. |