JDBC Driver for MYOB

Build 24.0.9060

TimesheetLineItems

Return timesheet entries for an AccountRight company file

Columns

Name Type ReadOnly References Description
ID [KEY] Integer False

LineId which represents the index of the line.

TimeSheetId [KEY] Uuid True

Timesheets.Id

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.

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