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.
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 for the quoted item. |
| S.NO | Long | Serial number indicating the item's position in the list. |
| CreatedTime | Datetime | Date and time when the quoted item record was created. |
| ModifiedTime | Datetime | Date and time when the quoted item record was last modified. |
| ParentID_Id | String | Unique identifier of the quote to which this item belongs. |
| ParentID_Name | String | Name of the quote to which this item belongs. |
| ProductName_Id | String | Unique identifier of the product being quoted. |
| ProductName_Name | String | Name of the product being quoted. |
| PriceBook_Id | String | Unique identifier of the price book associated with the quoted item. |
| PriceBook_Name | String | Name of the price book associated with the quoted item. |
| Description | String | Description of the quoted item. |
| Quantity | String | Quantity of the product being quoted. |
| ListPrice | Decimal | List price of the product. |
| Amount | String | Total amount for the item before discount and tax. |
| Discount | Decimal | Discount applied to the quoted item. |
| TotalAfterDiscount | String | Amount after applying the discount, before tax. |
| Tax | Decimal | Tax amount applied to the quoted item. |
| Total | String | Final total amount after applying discount and tax. |
| TaxbyPercentage | String | Tax applied as a percentage value. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| DuplicateCheckFields | String | Field or fields used to check for duplicates during an upsert operation. |
| CustomViewId | Long | Custom view Id used to filter this record. Successful when the useCOQL parameter is set to false. |
| Trigger | String | Specifies whether to trigger associated rules when inserting the record into the CRM account. |