OrderedItems
Shows product line items included on sales orders or quotes, detailing 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.
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 ordered item by its unique ID
SELECT * FROM OrderedItems WHERE Id = '3152079000000301143'
Columns
| Name | Type | Description |
| Id [KEY] | String | Unique identifier (Id) of the ordered item record. |
| Sequence_Number | Long | Serial number of the item in the order. |
| Created_Time | Datetime | Date and time when the ordered item was created. |
| Modified_Time | Datetime | Date and time when the ordered item was last modified. |
| Parent_Id_Id | String | Id of the parent record associated with the ordered item. |
| Product_Name_Id | String | Id of the product included in the order. |
| Description | String | Description of the ordered item. |
| Quantity | Double | Number of units of the product ordered. |
| Price_Book_Name_Id | String | Id of the price book associated with the item. |
| List_Price | Decimal | Listed price per unit of the product. |
| Total | String | Total amount before applying discounts and taxes. |
| Discount | Decimal | Discount applied to the ordered item. |
| Total_After_Discount | String | Total amount after applying the discount but before tax. |
| Tax | Decimal | Tax amount applied to the ordered item. |
| Net_Total | String | Final total amount after applying both discount and tax. |
| Line_Tax | String | Percentage of tax applied to the item. |
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. |