Timesheets

Columns

Name	Type	ReadOnly	Filterable	Description
Id [KEY]	String	True		The timesheet line-item combined with the unique Xero identifier of the timesheet.
TimesheetID	String	True		The unique identifier of the Timesheet. This field is assigned by Xero.
EmployeeID	String	False		The Xero identifier for an employee.
StartDate	Date	False		Period start date.
EndDate	Date	False		Period end date.
Status	String	False		The status code for the timesheet. The valid values are DRAFT, PROCESSED, and APPROVED.
Hours	Double	False		Timesheet total hours.
Line_EarningsRateId	String	False		The Xero identifier for an Earnings Type.
Line_TrackingItemId	String	False		The Xero identifier for a Tracking Category TrackingOptionID. The TrackingOptionID must belong to the TrackingCategory selected as TimesheetCategories under Payroll Settings.
Line_WorkLocationId	String	False		The Xero identifier for a Work Location.
Line_NumberOfUnits_NumberOfUnit1	String	False		Number of units of a Timesheet line.
Line_NumberOfUnits_NumberOfUnit2	String	False		Number of units of a Timesheet line.
Line_NumberOfUnits_NumberOfUnit3	String	False		Number of units of a Timesheet line.
Line_NumberOfUnits_NumberOfUnit4	String	False		Number of units of a Timesheet line.
Line_NumberOfUnits_NumberOfUnit5	String	False		Number of units of a Timesheet line.
Line_NumberOfUnits_NumberOfUnit6	String	False		Number of units of a Timesheet line.
Line_NumberOfUnits_NumberOfUnit7	String	False		Number of units of a Timesheet line.
Line_UpdatedDateUTC	Datetime	True		Timestamp of the last change to the Timesheet Line record.
TimesheetLineAggregate	String	False		Used to define TimesheetLine rows using XML values. Should be provided on INSERT only.
TenantId	String	False		The ID of the tenant to query instead of the connection tenant