PurchaseItems
Query information regarding purchase items.
View-Specific Information
Select
The connector 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 connector.
- Id supports the '=' operator.
For example, the following queries are processed server side:
SELECT * FROM PurchaseItems WHERE Id = '3152079000000301143'
NOTE: This table is not supported in v2.
Columns
| Name | Type | Description |
| Id [KEY] | String | |
| S.NO | Long | |
| CreatedTime | Datetime | |
| ModifiedTime | 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
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| 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. |