QuotedItems
Query information regarding quoted items.
View-Specific Information
Select
The 本製品 uses the Zoho CRM API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client-side within the 本製品.
- Id supports the '=' operator.
For example, the following queries are processed server side:
SELECT * FROM QuotedItems WHERE Id = '3152079000000301143'
NOTE: This table is not supported in v2.
Columns
Name | Type | Description |
Id [KEY] | String | |
S.NO | Long | |
CreatedTime | Datetime | |
ParentID_Id | String | |
ParentID_Name | String | |
ProductName_Id | String | |
ProductName_Name | String | |
PriceBook_Id | String | |
PriceBook_Name | String | |
Description | String | |
Quantity | String | |
ListPrice | Decimal | |
Amount | String | |
Discount | Decimal | |
TotalAfterDiscount | String | |
Tax | Decimal | |
Total | String | |
TaxbyPercentage | String |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
Name | Type | Description |
DuplicateCheckFields | String | The field/s to be used for checking in an upsert. |
CustomViewId | Long | The custom view Id to be used for filtering this record. Will work when useCOQL=false. |
Trigger | String | To trigger the rule while inserting record into CRM account. |