Manages payslip deduction line items for employees. It tracks the various deductions applied to an employee's pay, such as tax or superannuation.

Table Specific Information

This table supports the following operators server-side: =,IN

INSERT

To insert a single row, set the required fields. The connector 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)

Deductions lines can also be added in bulk by specifying multiple items in the VALUES clause.

INSERT INTO PaySlipDeductions (PayslipID, DeductionLine_DeductionTypeId, DeductionLine_CalculationType, DeductionLine_Amount)
	VALUES 
	('ea5aaaa7-c330-41d8-bfae-98ddc1f37680', 'b78b5ddd-6a20-4992-8e77-1243a122265d', 'FIXEDAMOUNT', 50),
	('ea5aaaa7-c330-41d8-bfae-98ddc1f37680', 'b78b5ddd-6a20-4992-8e77-1243a122265d', 'FIXEDAMOUNT', 75)

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		A unique identifier for the earnings line item, combined with the Xero-generated ID of the associated payslip. This helps in tracking and referencing each specific line of earnings in the payslip.
PayslipID	String	False		The unique identifier assigned by Xero to the payslip. This field helps to uniquely track and manage individual payslips within the system.
EmployeeID	String	True		The unique identifier assigned to the employee for this particular payslip. This ties the payslip to the specific employee it pertains to.
DeductionLine_DeductionTypeId	String	False		The unique identifier for the deduction type applied to this line item. This helps categorize the deduction (for example, tax or insurance) based on the predefined deduction type in Xero.
DeductionLine_CalculationType	String	False		The method by which the deduction is applied to the employee's earnings. It can be one of the following: 'PRETAX' (applied before taxes), 'POSTTAX' (applied after taxes), or 'FIXEDAMOUNT' (a set, non-variable amount).
DeductionLine_Amount	Decimal	False		The total monetary amount of the deduction applied to the employee's earnings for this particular line. This is the dollar value of the deduction.
DeductionLine_Percentage	Double	False		The percentage of the employee's income that is deducted for this line. This is typically used for deductions that apply as a percentage of wages, such as a tax rate or contribution percentage.
TenantId	String	False		The unique identifier of the tenant (organization) in Xero. This ensures the payslip and its details are correctly linked to the correct tenant (or organization) in the system.