Timesheets
Return timesheet entries for an AccountRight company file
Table Specific Information
Select
MYOB allows a subset of columns to be used in the WHERE clause of a SELECT query. These columns may be used with the = operator. In addition, queries with multiple criterias can be executed by combining the criteria with AND and OR operators.
These columns support the above comparison type for server side filtering: ID, EmployeeName, EmployeeDisplayId, StartDate, EndDate. All the other columns and operators are processed client side.
SELECT * FROM Categories WHERE ID = "1bed306d-2da4-49b3-9023-153c3dc5b2e9" SELECT * FROM Timesheets WHERE EmployeeName = "Mary Jones" SELECT * FROM Timesheets WHERE EmployeeDisplayId = "EMP00001" SELECT * FROM Timesheets WHERE StartDate = "2019-10-28" SELECT * FROM Timesheets WHERE EndDate = "2019-11-03"
Columns
| Name | Type | ReadOnly | Description |
| Id [KEY] | Uuid | True |
Unique category identifier in the form of a guid. |
| EmployeeName | String | True |
Name of the employee. |
| EmployeeDisplayId | String | True |
Employee contact Card ID, can also be used as a unique employee contact identifier. |
| EmployeeURI | String | True |
Uniform resource identifier associated with the employee object. |
| StartDate | Datetime | False |
Date when the timesheet period starts, format YYYY-MM-DD HH:MM:SS |
| EndDate | Datetime | False |
Date when the timesheet period finishes, format YYYY-MM-DD HH:MM:SS |
| URI | String | True |
Uniform resource identifier associated with the employee object. |
| CompanyFileId | String | True |
The ID of the company file. Takes precedence over the CompanyFileId connection property. |