Xero Payroll (New Zealand) Endpoint: TimesheetsExpanded

From OdataLink
Jump to navigation Jump to search

Overview

The Xero Timesheets endpoint provides the list of timesheets including lines.

To make full use of the data in this endpoint may require using endpoints belonging to a Xero Accounting Model.


Fields

The following fields are available for the Timesheets endpoint.

timesheetID
A guid field that provides the id of the timesheet.
payrollCalendarID
A guid field that provides the payroll calendar id associated with the leave application.
employeeID
A guid field that provides the employee id associated with the leave application.
startDate
A date field that provides the first date of the timesheet.
endDate
A date field that provides the last date of the timesheet.
status
A text field that indicates the status of the timesheet.
Possible values are:
  • Draft: Timesheet entry is still in draft and has not been submitted for approval
  • Requested: Timesheet entry has been submitted for approval
  • Approved: Timesheet entry has been approved but the pay run has not been posted
  • Declined: Timesheet entry has been submitted for approval and declined by the approver
  • Completed: Timesheet entry has been approved and the pay run has been posted
totalHours
A decimal field that provides the total hours on the timesheet.
timesheetLines
A table field that provides the lines of the timesheet.
See TimesheetLines Fields for more information.
updatedDateUTC
A date time field that indicates the last time this record was updated.


TimesheetLines Fields

The TimesheetLines Fields include the following sub fields.

timesheetLineID
A guid field that provides the internal id associated with this timesheet line.
earningsRateID
A guid field that provides the earnings rate id associated with this timesheet line.
trackingItemID
A guid field that provides the tracking category option id associated with this timesheet line.
date
A date field that provides the date for the timesheet line.
numberOfUnits
A table field that provides the units and days associated with this combination of earnings rate and tracking category option.
See TimesheetLines.NumberOfUnits Fields for more information.


Xero API

For a detailed run through of the endpoint, you can see the Xero API.


Related Fields

None


Related Endpoints

Employees
PayrollCalendars
Timesheets
TrackingCategories


Related Topics

Xero Payroll (New Zealand) Models
Xero Payroll (New Zealand) Endpoints