IncidentsBilledMinutes
The work time applied to incidents through the Time Billed feature.
Table-Specific Information
SELECT
The cmdlet will use the Oracle Service Cloud API to process WHERE clause conditions built with =,!=,<,>,<=,>=,IN,NOT_IN,IS,IS_NOT,LIKE operators. The rest of the filters are executed client side within the cmdlet.
SELECT * FROM IncidentsBilledMinutes WHERE id = 12 SELECT * FROM IncidentsBilledMinutes WHERE id > 15 SELECT * FROM IncidentsBilledMinutes WHERE comment LIKE '%test' SELECT * FROM IncidentsBilledMinutes WHERE id IN (12, 23, 123) SELECT * FROM IncidentsBilledMinutes WHERE comment IS NOT NULL
Columns
| Name | Type | Description |
| IncidentsId | Long | The unique identifier of the incident. |
| AccountId | Long | Id of account. The staff member who billed the time. This is part of the key for the list entry. |
| AccountlookUpName | String | LookUpName of account. The staff member who billed the time. This is part of the key for the list entry. |
| BillTime | Datetime | The date and time when the work was performed. This is part of the key for the list entry. |
| BillableTaskId | Long | Id of billableTask. The associated billable task. |
| BillableTasklookUpName | String | LookUpName of billableTask. The associated billable task. |
| Comment | String | The comments associated with the timeBilled record. |
| Id [KEY] | Long | The unique identifier of the timeBilled record. |
| Minutes | Int | The number of minutes billed. |