PaySlipEarnings

Query payslip earning line-items for a Xero organisation.

Table Specific Information

Equal operator

The equal operator is supported on the server side:

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

IN operator

The IN operator is supported on the client side:

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


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.
EarningsLine_EarningsRateId	String		The unique identifier of the line-item's earnings rate
EarningsLine_RatePerUnit	Decimal		The line-item's wage per time unit (e.g. hours)
EarningsLine_NumberOfUnits	Double		The number of time units in this line-item (e.g. hours)
EarningsLine_FixedAmount	Decimal		The total earnings in this line-item. Only appears if the rate-type is FIXED.
EarningsLine_LumpSumETaxYear	String		The tax year that applies to these earnings. Only appears if the earnings type is LUMPSUME.
TenantId	String		The ID of the tenant to query instead of the connection tenant