SSIS Components for Xero

Build 25.0.9434

EmployeePayTemplateDeductions

Queries the deduction lines of the employee's pay template. It is used to manage and track various types of deductions, such as tax, superannuation, and garnishments.

Columns

Name Type Filterable Description
EmployeeID String The unique identifier for the employee. This field is automatically assigned by Xero.
DeductionTypeID String The unique identifier for the deduction rate applied to this specific line item. It links to a predefined deduction type.
CalculationType String Specifies the method of calculation for the deduction. Possible values are 'FIXEDAMOUNT' (a set amount), 'PRETAX' (deduction before tax), or 'POSTTAX' (deduction after tax).
Percentage Decimal The percentage rate for the deduction, used when 'PRETAX' or 'POSTTAX' calculation types are applied.
Amount Decimal The fixed deduction amount, used when the 'FIXEDAMOUNT' calculation type is applied. This is a specific monetary value.
TenantId String The unique identifier for the tenant. This allows the query to target a specific tenant, overriding the connection's default tenant.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9434