JDBC Driver for MYOB

Build 24.0.9062

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 ReadOnly References 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.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062