TimeSheetLines
Retrieve and modify timesheet lines.
Columns
| Name | Type | ReadOnly | References | Required | Description |
| Id [KEY] | String | False | False | ||
| Comment | String | False | False | ||
| LineClass | Int | False | False | ||
| ProjectName | String | False | False | ||
| Status | Int | False | False | ||
| TaskName | String | False | False | ||
| TotalWork | String | False | False | ||
| TotalWorkMilliseconds | Int | False | False | ||
| TotalWorkTimeSpan | Time | False | False | ||
| ValidationType | Int | False | False | ||
| Assignment_Id | String | True | False | ||
| TimeSheet_Id | String | True | False | ||
| LinkedAssignment | String | False | False | ||
| LinkedTimeSheet | String | False | False | ||
| LinkedWork | String | False | False | ||
| PeriodId [KEY] | String | True | False |
Id of the parent. This column only supports equality (=) and IN filters. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| Name | Type | Description |
| InsertMode | String |
Determines the Insert Mode. Set to 'ADD' to use standard MSProject Add functions. Set to 'ODATA' to use standard ODATA insert functionality. Only applicable during inserts. |