PaySlipDeductions
Query payslip deduction line-items for a Xero organisation.
Table Specific Information
This table supports the following operators server-side: =,IN
INSERT
To insert a single row, set the required fields. The driver adds a new deduction line to the payslip.
INSERT INTO PaySlipDeductions (PayslipID, DeductionLine_DeductionTypeId, DeductionLine_CalculationType, DeductionLine_Amount) VALUES ('ea5aaaa7-c330-41d8-bfae-98ddc1f37680', 'b78b5ddd-6a20-4992-8e77-1243a122265d', 'FIXEDAMOUNT', 50)
UPDATE
You can update any field that is not read-only.
Note: UPDATE operations will count as two operations against the Xero API. One is required to retrieve the existing record, and another to update the record with new data.
UPDATE PaySlipDeductions SET DeductionLine_Amount=5 WHERE Id='2|ea5aaaa7-c330-41d8-bfae-98ddc1f37680'
DELETE
Supply the Id to delete payslip deduction lines.
DELETE FROM PaySlipDeductions WHERE Id = '2|ea5aaaa7-c330-41d8-bfae-98ddc1f37680'
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 | False |
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 |