Timesheet
Captures timesheet entries at a summary level, including employee data, total hours, and project or department allocations.
Table Specific Information
Insert
Insert is only supported when UseLegacy=False.
The following example illustrates how to insert into Timesheet table:
INSERT INTO Timesheet (Employeeid, Begindate, Itemaggregate) VALUES ('1', '10/05/2014', '<TIMESHEETENTRY><entrydate>10/05/2014</entrydate><qty>1</qty><itemid>901</itemid><projectid>4321</projectid></TIMESHEETENTRY>');
Note: Inserts are not supported with the Legacy API.
Columns
| Name | Type | ReadOnly | Description |
| Recordno [KEY] | String | False |
Unique identifier for the timesheet record. |
| Description | String | False |
A description of the timesheet. |
| Employeekey | Int64 | False |
The unique identifier for the employee associated with the timesheet. |
| Begindate | Datetime | False |
The start date for the timesheet period. |
| Enddate | Datetime | False |
The end date for the timesheet period. |
| Employeeid | String | False |
The employee ID associated with the timesheet. |
| Employeename | String | False |
The name of the employee associated with the timesheet. |
| State | String | False |
The state or status of the timesheet. |
| LinesNUM | Int64 | False |
The number of lines or entries in the timesheet. |
| Employeefirstname | String | False |
The first name of the employee associated with the timesheet. |
| Employeelastname | String | False |
The last name of the employee associated with the timesheet. |
| Config | String | False |
The configuration settings for the timesheet. |
| Uom | String | False |
The unit of measurement for time entries in the timesheet. |
| Hoursinday | Double | False |
The total number of hours worked per day in the timesheet. |
| Employee_locationid | String | False |
The location ID of the employee associated with the timesheet. |
| Employee_departmentid | String | False |
The department ID of the employee associated with the timesheet. |
| Employee_classid | String | False |
The class ID of the employee associated with the timesheet. |
| Method | String | False |
The method used for calculating time or cost in the timesheet. |
| Actualcost | Boolean | False |
Indicates whether actual cost data is included in the timesheet. |
| Locationkey | Int64 | False |
The identifier for the location associated with the timesheet. |
| Whencreated | Datetime | False |
The date and time when the timesheet was created. |
| Whenmodified | Datetime | False |
The date and time when the timesheet was last modified. |
| Createdby | Int64 | False |
The identifier of the user who created the timesheet. |
| Modifiedby | Int64 | False |
The identifier of the user who last modified the timesheet. |
| Megaentitykey | Int64 | False |
The unique identifier for the mega entity associated with the timesheet. |
| Megaentityid | String | False |
The ID of the mega entity associated with the timesheet. |
| Megaentityname | String | False |
The name of the mega entity associated with the timesheet. |
| Record_url | String | False |
The URL for accessing the timesheet record. |