PurchaseItems
Displays product line items on purchase orders, including 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 server 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 server.
- 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 record. |
| S.NO | Long | Serial number of the item in the purchase order. |
| CreatedTime | Datetime | Date and time when the purchase item was created. |
| ModifiedTime | Datetime | Date and time when the purchase item was last modified. |
| ParentID_Id | String | Unique identifier of the associated purchase order. |
| ParentID_Name | String | Name of the associated purchase order. |
| ProductName_Id | String | Unique identifier of the associated product. |
| ProductName_Name | String | Name of the associated product. |
| PriceBook_Id | String | Unique identifier of the price book associated with the item. |
| PriceBook_Name | String | Name of the price book associated with the item. |
| Description | String | Description of the product or item. |
| Quantity | String | Number of units ordered for the product. |
| ListPrice | Decimal | List price per unit of the product. |
| Amount | String | Total amount before applying any discounts or taxes. |
| Discount | Decimal | Discount applied to the item. |
| TotalAfterDiscount | String | Amount after applying the discount but before tax. |
| Tax | Decimal | Tax applied to the item. |
| Total | String | Final amount including tax and discounts. |
| TaxbyPercentage | String | Tax applied as a percentage value. |
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 | Fields used to check for duplicates during an upsert operation. |
| CustomViewId | Long | Custom view identifier used to filter this record when the useCOQL parameter is set to false. |
| Trigger | String | Specifies whether to trigger associated rules when inserting this record into the CRM account. |