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.
Select
The provider 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 provider.
- 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. |
| Sequence_Number | Long | Serial number of the item in the purchase order. |
| Created_Time | Datetime | Date and time when the purchase item was created. |
| Modified_Time | Datetime | Date and time when the purchase item was last modified. |
| Parent_Id_Id | String | Unique identifier of the associated purchase order. |
| Product_Name_Id | String | Unique identifier of the associated product. |
| Description | String | Description of the product or item. |
| Quantity | Double | Number of units ordered for the product. |
| Price_Book_Name_Id | String | Unique identifier of the price book associated with the item. |
| List_Price | Decimal | List price per unit of the product. |
| Total | String | Total amount before applying any discounts or taxes. |
| Discount | Decimal | Discount applied to the item. |
| Total_After_Discount | String | Amount after applying the discount but before tax. |
| Tax | Decimal | Tax applied to the item. |
| Net_Total | String | Final amount including tax and discounts. |
| Line_Tax | String | Tax applied as a percentage value. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer more granular control over the data returned from the data source.
| Name | Type | Description |
| DuplicateCheckFields | String | The field(s) to be used for checking duplicate records in an upsert. The REST API allows for more than one field in the duplicate check but the BULK API only allows one field. |
| Trigger | String | To trigger the rule while inserting record into CRM account. |