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 connector 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 connector.
- 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
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| 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. |