CData Python Connector for Xero

Build 22.0.8479

PaySlipDeductions

Query payslip deduction line-items for a Xero organisation.

Table Specific Information

Queries

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

Columns

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.

DeductionLine_DeductionTypeId String False

The unique identifier of the line-item's deduction type

DeductionLine_CalculationType String False

How the deduction is applied to earnings, either PRETAX, POSTTAX or FIXEDAMOUNT

DeductionLine_Amount Decimal False

The total amount of the deduction

DeductionLine_Percentage Double False

The percentage of income this deduction applies to

TenantId String False

The ID of the tenant to query instead of the connection tenant

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