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 component 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 component.
- 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. |