JDBC Driver for MYOB

Build 22.0.8462

TimesheetLineItems

Return timesheet entries for an AccountRight company file

Columns

Name Type ReadOnly Description
TimeSheetId [KEY] Uuid True

Unique category identifier in the form of a guid.

PayrollCategoryId Uuid False

Unique payroll wage category identifier in the form of a guid.

PayrollCategoryName String True

Name of the payroll wage category.

PayrollCategoryType String True

Indicates the type of payroll category ie: Wage, Deduction, Tax.

PayrollCategoryURI String True

Uniform resource identifier associated with the payroll wage category object.

JobId Uuid True

Unique guid identifier belonging to the job for this line of the timesheet entry.

JobNumber String True

Number assigned to the job.

JobName String True

Name assigned to the job.

JobURI String True

Uniform resource identifier associated with the job object.

ActivityId Uuid True

Unique guid identifier belonging to the activity assigned for this line of the timesheet entry.

ActivityName String True

Name of the activity.

ActivityURI String True

Uniform resource identifier associated with the activity object.

CustomerId Uuid True

Unique guid identifier belonging to the customer assigned for this line of the timesheet entry.

CustomerName String True

Name of the customer.

CustomerDisplayID String False

Customer contact Card ID, can also be used as a unique customer contact identifier.

CustomerURI String True

Uniform resource identifier associated with the customer object.

Notes String True

Notes attached to the timesheet entry.

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