JDBC Driver for Xero

Build 22.0.8462

PaySlipTimesheetEarnings

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

Table Specific Information

Queries

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') 

Columns

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

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462