InvoicedItems
Shows each product or service line item that appears on invoices, with quantity, rate, tax, and discount information.
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.
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 invoiced item by its unique ID
SELECT * FROM InvoicedItems WHERE Id = '3152079000000301143'
Columns
| Name | Type | Description |
| Id [KEY] | String | The unique identifier for the invoiced item. |
| Sequence_Number | Long | The serial number of the invoiced item in the invoice. |
| Created_Time | Datetime | The date and time when the invoiced item was created. |
| Modified_Time | Datetime | The date and time when the invoiced item was last modified. |
| Parent_Id_Id | String | The unique identifier of the invoice to which this item belongs. |
| Product_Name_Id | String | The unique identifier of the product associated with this item. |
| Description | String | The description of the invoiced item. |
| Quantity | Double | The quantity of the product invoiced. |
| Price_Book_Name_Id | String | The unique identifier of the price book associated with this item. |
| List_Price | Decimal | The list price of the product. |
| Total | String | The amount before any discount or tax is applied. |
| Discount | Decimal | The discount amount applied to the item. |
| Total_After_Discount | String | The total amount after applying the discount but before tax. |
| Tax | Decimal | The tax applied to the invoiced item. |
| Net_Total | String | The final total of the item including tax. |
| Line_Tax | String | The tax rate as a percentage 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. |