InvoicedItems
Displays each product or service line item that appears on customer invoices, along with quantities, rates, and taxes.
View-Specific Information
The InvoicedItems 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 invoiced item by its unique ID
SELECT * FROM InvoicedItems WHERE Id = '3152079000000301143'
Columns
| Name | Type | Description |
| Id [KEY] | String | Unique identifier for the invoiced item. |
| S.NO | Long | The serial number representing the order of the invoiced item. |
| CreatedTime | Datetime | The date and time when the invoiced item was created. |
| ParentID_Id | String | Unique identifier of the invoice this item is associated with. |
| ParentID_Name | String | Name of the invoice this item is associated with. |
| ProductName_Id | String | Unique identifier of the product being invoiced. |
| ProductName_Name | String | Name of the product being invoiced. |
| PriceBook_Id | String | Unique identifier of the price book associated with the item. |
| PriceBook_Name | String | Name of the price book associated with the item. |
| Description | String | Description of the invoiced item. |
| Quantity | String | Quantity of the product included in the invoice. |
| ListPrice | Decimal | The list price of the product before discounts. |
| Amount | String | The total amount before applying any discount. |
| Discount | Decimal | The discount applied to the item. |
| TotalAfterDiscount | String | The total amount after applying the discount. |
| Tax | Decimal | The tax amount applied to the item. |
| Total | String | The final total amount after applying discount and tax. |
| TaxbyPercentage | String | The tax applied to the item 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 field or fields used for checking duplicate records during upsert operations. |
| CustomViewId | Long | The custom view identifier used to filter this record. Works when the useCOQL parameter is set to false. |
| Trigger | String | Triggers the rule when inserting the record into the CRM account. |