PaySlipDeductions

Query payslip deduction line-items for a Xero organisation.

Table Specific Information

Equal operator

The equal operator is supported on the server side:

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

IN operator

The IN operator is supported on the client side:

SELECT * FROM PaySlipDeductions 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.
DeductionLine_DeductionTypeId	String		The unique identifier of the line-item's deduction type
DeductionLine_CalculationType	String		How the deduction is applied to earnings, either PRETAX, POSTTAX or FIXEDAMOUNT
DeductionLine_Amount	Decimal		The total amount of the deduction
DeductionLine_Percentage	Double		The percentage of income this deduction applies to
TenantId	String		The ID of the tenant to query instead of the connection tenant