RequestWorklogs
ServiceDeskPlus request worklog management for time tracking and billing
Columns
| Name | Type | References | |
| Id [KEY] | Long | ||
| CurrencyId | Long | ||
| CreatedByEmployeeId | Long | ||
| OwnerEmployeeId | Long | ||
| RequestId | Long |
Requests.Id | |
| CreatedBySiteId | Long | ||
| OwnerSiteId | Long | ||
| CreatedById | Long | ||
| OwnerId | Long | ||
| Description | String | ||
| WorklogType | String | ||
| StartTime | Datetime | ||
| EndTime | Datetime | ||
| RecordedTime | Datetime | ||
| CreatedByCostPerHour | Decimal | ||
| CreatedByDepartment | String | ||
| CreatedByEmail | String | ||
| CreatedByFirstName | String | ||
| CreatedByJobTitle | String | ||
| CreatedByLastName | String | ||
| CreatedByMobile | String | ||
| CreatedByName | String | ||
| CreatedByPhone | String | ||
| CreatedBySiteName | String | ||
| IsCreatedBySiteDeleted | Boolean | ||
| CreatedBySmsEmail | String | ||
| CreatedBySmsEmailId | String | ||
| CreatedByUserScope | String | ||
| CurrencyCode | String | ||
| IsCurrencyDeleted | Boolean | ||
| CurrencyExchangeRate | Decimal | ||
| CurrencyName | String | ||
| CurrencySymbol | String | ||
| EndTimeDisplay | String | ||
| ExchangeRate | Decimal | ||
| DoesIncludeNonoperationalHours | Boolean | ||
| IsCreatedBySiteDefault | Boolean | ||
| IsCreatedByTechnician | Boolean | ||
| IsCreatedByVipUser | Boolean | ||
| IsOwnerSiteDefault | Boolean | ||
| IsOwnerTechnician | Boolean | ||
| IsOwnerVipUser | Boolean | ||
| OtherChargeDisplay | String | ||
| OtherChargeCurrencySymbol | String | ||
| OtherChargeSecondaryDisplay | String | ||
| OtherChargeSecondaryCurrencySymbol | String | ||
| OtherChargeSecondaryValue | Decimal | ||
| OtherChargeValue | Decimal | ||
| OwnerCostPerHour | Decimal | ||
| OwnerDepartment | String | ||
| OwnerEmail | String | ||
| OwnerFirstName | String | ||
| OwnerJobTitle | String | ||
| OwnerLastName | String | ||
| OwnerMobile | String | ||
| OwnerName | String | ||
| OwnerPhone | String | ||
| IsOwnerSiteDeleted | Boolean | ||
| OwnerSiteName | String | ||
| OwnerSmsEmail | String | ||
| OwnerSmsEmailId | String | ||
| OwnerUserScope | String | ||
| RecordedTimeDisplay | String | ||
| StartTimeDisplay | String | ||
| TechChargeDisplay | String | ||
| TechChargeCurrencySymbol | String | ||
| TechChargeSecondaryDisplay | String | ||
| TechChargeSecondaryCurrencySymbol | String | ||
| TechChargeSecondaryValue | Decimal | ||
| TechChargeValue | Decimal | ||
| TimeSpentHours | Integer | ||
| TimeSpentMinutes | Integer | ||
| TimeSpentValue | Long | ||
| TotalChargeDisplay | String | ||
| TotalChargeCurrencySymbol | String | ||
| TotalChargeSecondaryDisplay | String | ||
| TotalChargeSecondaryCurrencySymbol | String | ||
| TotalChargeSecondaryValue | Decimal | ||
| TotalChargeValue | Decimal |