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 criteria 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	References	Description
Id [KEY]	Uuid		Unique category identifier in the form of a guid.
EmployeeName	String		Name of the employee.
EmployeeDisplayId	String		Employee contact Card ID, can also be used as a unique employee contact identifier.
EmployeeURI	String		Uniform resource identifier associated with the employee object.
StartDate	Datetime		Date when the timesheet period starts, format YYYY-MM-DD HH:MM:SS
EndDate	Datetime		Date when the timesheet period finishes, format YYYY-MM-DD HH:MM:SS
URI	String		Uniform resource identifier associated with the employee object.
CompanyFileId	String	CompanyFiles.ID	ID of the company file. Takes precedence over the CompanyFileId property.

Tableau Connector for MYOB

Timesheets

Table Specific Information

Select

Columns