OrderedItems
Shows product line items that appear on sales orders or quotes, including quantity, unit price, and discount.
View-Specific Information
The OrderedItems 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 cmdlet 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 cmdlet.
- Id supports the '=' operator.
The following example demonstrates a basic query processed server-side:
-- Query a specific ordered item by its unique ID
SELECT * FROM OrderedItems WHERE Id = '3152079000000301143'
Columns
| Name | Type | Description |
| Id [KEY] | String | Unique identifier of the ordered item record. |
| S.NO | Long | The serial number of the item in the order list. |
| CreatedTime | Datetime | Date and time when the ordered item record was created. |
| ParentID_Id | String | Identifier of the parent record associated with the order. |
| ParentID_Name | String | Name of the parent record associated with the order. |
| ProductName_Id | String | Identifier of the product included in the order. |
| ProductName_Name | String | Name of the product included in the order. |
| PriceBook_Id | String | Identifier of the price book associated with the product. |
| PriceBook_Name | String | Name of the price book associated with the product. |
| Description | String | Detailed description of the ordered item. |
| Quantity | String | Quantity of the product ordered. |
| ListPrice | Decimal | The listed price of the product before discounts or adjustments. |
| Amount | String | The amount calculated for the item based on price and quantity. |
| Discount | Decimal | The discount applied to the ordered item. |
| TotalAfterDiscount | String | The total amount after the discount has been applied. |
| Tax | Decimal | The tax amount applied to the ordered item. |
| Total | String | Final total amount for the item including tax and discount. |
| TaxbyPercentage | String | Tax percentage applied to calculate the tax for the item. |
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 to be used for checking duplicate records during upsert operations. |
| CustomViewId | Long | The custom view identifier used to filter this record. Only works when the useCOQL parameter is set to false. |
| Trigger | String | Specifies whether to trigger automation rules while inserting this record into the CRM account. |