PaySlipTimesheetEarnings

Query payslip timesheet-earnings line-items for a Xero organisation.

Table Specific Information

Equal operator

The equal operator is supported on the server side:

SELECT * FROM PaySlipTimesheetEarnings WHERE PayslipID ='218db321-b72e-4aa1-9067-477d63705f95'

IN operator

The IN operator is supported on the client side:

SELECT * FROM PaySlipTimesheetEarnings WHERE PayslipID IN ('1843c739-aa8b-4d58-956a-3e097708cd84','218db321-b72e-4aa1-9067-477d63705f95')


Name	Type	ReadOnly	Filterable	Description
Id [KEY]	String	True		The earnings line-item combined with the unique Xero identifier of the payslip
PayslipID	String	True		The unique identifier of the payslip. This field is assigned by Xero.
EmployeeID	String	True		The unique identifier of the payslip's employee.
TimesheetEarningsLine_EarningsRateId	String	False		The unique identifier of the line-item's earnings rate
TimesheetEarningsLine_RatePerUnit	Decimal	False		The line-item's rate per time unit (e.g. hours)
TimesheetEarningsLine_NumberOfUnits	Decimal	False		The number of time units (e.g. hours)
TenantId	String	False		The ID of the tenant to query instead of the connection tenant