TimesheetEntry
Provides line-level detail within timesheets, recording daily hours, tasks, projects, and cost allocation details.
View Specific Information
Select
- Legacy API: No restrictions
- Non-legacy API: SELECT works only if the property IncludeRelatedAttributes is set to NONE.
Columns
| Name | Type | Description |
| Recordno [KEY] | String | Unique identifier for the timesheet entry record. |
| Lineno | Int64 | The line number for the timesheet entry. |
| Timesheetkey | Int64 | The identifier for the timesheet associated with the entry. |
| Projectkey | Int64 | The identifier for the project associated with the timesheet entry. |
| Projectid | String | The project ID associated with the timesheet entry. |
| Projectname | String | The project name associated with the timesheet entry. |
| Project_classid | String | The project class ID associated with the timesheet entry. |
| Taskkey | Int64 | The identifier for the task associated with the timesheet entry. |
| Taskname | String | The task name associated with the timesheet entry. |
| Task_classid | String | The task class ID associated with the timesheet entry. |
| Customerkey | Int64 | The identifier for the customer associated with the timesheet entry. |
| Customerid | String | The customer ID associated with the timesheet entry. |
| Customername | String | The customer name associated with the timesheet entry. |
| Itemkey | Int64 | The item identifier associated with the timesheet entry. |
| Itemid | String | The item ID associated with the timesheet entry. |
| Itemname | String | The item name associated with the timesheet entry. |
| Entrydate | Datetime | The date the timesheet entry was recorded. |
| Qty | Double | The quantity of time or work recorded in the timesheet entry. |
| Description | String | A description of the timesheet entry. |
| Notes | String | Additional notes for the timesheet entry. |
| State | String | The state or status of the timesheet entry. |
| Locationkey | Int64 | The location key associated with the timesheet entry. |
| Locationid | String | The location ID associated with the timesheet entry. |
| Locationname | String | The location name associated with the timesheet entry. |
| Departmentkey | Int64 | The department key associated with the timesheet entry. |
| Departmentid | String | The department ID associated with the timesheet entry. |
| Departmentname | String | The department name associated with the timesheet entry. |
| Timetypekey | Int64 | The time type key associated with the timesheet entry. |
| Timetype | String | The time type associated with the timesheet entry. |
| Timetype_earningtypekey | Int64 | The earning type key for the time type in the timesheet entry. |
| Timetype_glaccountkey | Int64 | The general ledger account key for the time type in the timesheet entry. |
| Timetype_gloffsetaccountkey | Int64 | The general ledger offset account key for the time type in the timesheet entry. |
| Billable | Boolean | Indicates whether the timesheet entry is billable. |
| Billed | String | Indicates whether the timesheet entry has been billed. |
| Employeedimkey | Int64 | The employee dimension key for the timesheet entry. |
| Employeeid | String | The employee ID associated with the timesheet entry. |
| Employeename | String | The employee name associated with the timesheet entry. |
| Employee_earningtypekey | Int64 | The earning type key for the employee in the timesheet entry. |
| Ts_begindate | Datetime | The beginning date for the timesheet entry period. |
| Ts_enddate | Datetime | The end date for the timesheet entry period. |
| Ts_locationkey | Int64 | The location key for the timesheet entry. |
| Ts_locationid | String | The location ID for the timesheet entry. |
| Statjournalkey | Int64 | The journal key for the statistical entry of the timesheet entry. |
| Billuacctkey | Int64 | The billing account key for the timesheet entry. |
| Nonbilluacctkey | Int64 | The non-billing account key for the timesheet entry. |
| Billnuacctkey | Int64 | The billing number account key for the timesheet entry. |
| Nonbillnuacctkey | Int64 | The non-billing number account key for the timesheet entry. |
| Statglbatchkey | Int64 | The batch key for the general ledger entry of the timesheet entry. |
| Statglentrylineno | Int64 | The line number for the general ledger entry of the timesheet entry. |
| Laborglbatchkey | Int64 | The labor batch key for the timesheet entry. |
| Laborglentrylineno | Int64 | The line number for the labor entry in the timesheet. |
| Laborglentryoffsetlineno | Int64 | The offset line number for the labor entry in the timesheet. |
| Laborglentryamount | Double | The amount for the labor entry in the timesheet. |
| Laborglentrytrxamount | Double | The transaction amount for the labor entry in the timesheet. |
| Laborglentrycostrate | Double | The cost rate for the labor entry in the timesheet. |
| Statglentryamount | Double | The amount for the general ledger entry in the timesheet. |
| Varglentryamount | Double | The variable general ledger entry amount in the timesheet. |
| Varglentrytrxamount | Double | The variable transaction amount for the general ledger entry. |
| Varglbatchkey | Int64 | The batch key for the variable general ledger entry. |
| Varglentrylineno | Int64 | The line number for the variable general ledger entry. |
| Varglentryoffsetlineno | Int64 | The offset line number for the variable general ledger entry. |
| Clznamount | Double | The clearance amount for the timesheet entry. |
| Extcostrate | String | The external cost rate for the timesheet entry. |
| Extbillrate | String | The external bill rate for the timesheet entry. |
| Whencreated | Datetime | The date and time when the timesheet entry was created. |
| Whenmodified | Datetime | The date and time when the timesheet entry was last modified. |
| Createdby | Int64 | The identifier of the user who created the timesheet entry. |
| Modifiedby | Int64 | The identifier of the user who last modified the timesheet entry. |
| Projectdimkey | Int64 | The project dimension key associated with the timesheet entry. |
| Vendordimkey | Int64 | The vendor dimension key associated with the timesheet entry. |
| Vendorid | String | The vendor ID associated with the timesheet entry. |
| Vendorname | String | The vendor name associated with the timesheet entry. |
| Classdimkey | Int64 | The class dimension key associated with the timesheet entry. |
| Classid | String | The class ID associated with the timesheet entry. |
| Classname | String | The class name associated with the timesheet entry. |
| Record_url | String | The URL for accessing the timesheet entry record. |