JDBC Driver for MYOB

Build 22.0.8462

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.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462