Invoices
Query invoice lines for billing insights.
Select
The add-in uses the Talkdesk API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client-side within the add-in.
- AccountId supports the following operators: =, !=, IN, NOT_IN, IS, IS_NOT, CONTAINS, LIKE.
- Number supports the following operators: =, !=, IN, NOT_IN, IS, IS_NOT, CONTAINS, LIKE.
- InvoiceDate supports the following operators: =, !=, <, <=, >, >=, IS, IS_NOT.
For example, the following query is processed server-side:
SELECT * FROM Invoices WHERE AccountId = 'value'
The add-in pushes the ORDER BY clause to the Talkdesk API for the following columns. Sorting on any other column is performed client-side within the add-in.
- InvoiceDate supports the following sort directions: ASC, DESC.
For example, the following query is sorted server-side:
SELECT * FROM Invoices ORDER BY InvoiceDate ASC
Columns
| Name | Type | References | Description |
| Id [KEY] | String | The unique identifier of the invoice record. | |
| AccountId | String |
Account.Id | The Talkdesk account identifier. |
| Number | String | The invoice number. | |
| InvoiceLineNumber | String | The invoice line number. | |
| InvoiceDate | Date | The invoice date. | |
| DueDate | Datetime | The due date of the invoice. | |
| Currency | String | The ISO-4217 currency code for the invoice. | |
| TotalInvoiceAmount | Double | The total invoice amount. | |
| ProductId | String |
Products.Id | The Talkdesk product code. |
| Description | String | A description for the invoice line. | |
| ProductName | String | The name of the product. | |
| Quantity | Double | The quantity of product in the invoice line. | |
| Rate | Double | The rate applied to the invoice line product. | |
| Amount | Double | The total amount on the invoice line. | |
| TotalTaxAmount | Double | The total amount of taxes in the invoice. |