PurchaseItems
Provides product line items included on purchase orders, with cost, quantity, and vendor references.
View-Specific Information
The PurchaseItems 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 add-in 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 add-in.
- Id supports the '=' operator.
The following example demonstrates a basic query processed server-side:
-- Query a specific purchase item by its unique ID
SELECT * FROM PurchaseItems WHERE Id = '3152079000000301143'
Columns
| Name | Type | Description |
| Id [KEY] | String | Unique identifier for the purchase item. |
| S.NO | Long | Serial number of the item in the list. |
| CreatedTime | Datetime | Date and time when the purchase item record was created. |
| ParentID_Id | String | Unique identifier of the parent record associated with the purchase item. |
| ParentID_Name | String | Name of the parent record associated with the purchase item. |
| ProductName_Id | String | Unique identifier of the product linked to this item. |
| ProductName_Name | String | Name of the product linked to this item. |
| PriceBook_Id | String | Unique identifier of the price book used for this item. |
| PriceBook_Name | String | Name of the price book used for this item. |
| Description | String | Description of the purchase item. |
| Quantity | String | Quantity of the item purchased. |
| ListPrice | Decimal | Listed price of a single unit of the item. |
| Amount | String | Total amount for the item before discounts and taxes. |
| Discount | Decimal | Discount applied to the item. |
| TotalAfterDiscount | String | Total amount after applying the discount. |
| Tax | Decimal | Tax amount applicable to the item. |
| Total | String | Final total amount for the item including discounts and tax. |
| TaxbyPercentage | String | Tax value represented as a percentage. |
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 fields used to check for duplicate records during an upsert operation. |
| CustomViewId | Long | The 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. |