ADO.NET Provider for Zoho CRM

Build 24.0.9062

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.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062