Excel Add-In for Oracle Service Cloud

Build 24.0.9060

IncidentsBilledMinutes

The work time applied to incidents through the Time Billed feature.

Table-Specific Information

SELECT

The add-in 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 add-in.

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.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060