JDBC Driver for Xero

Build 25.0.9434

PaySlipTaxes

Tracks tax-related line items in payslips. It includes information on the tax deductions applied to an employee's pay, such as income tax and other levies.

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 tax line to the payslip. 

INSERT INTO PaySlipTaxes (PayslipID, TaxLine_Amount) VALUES ('ea5aaaa7-c330-41d8-bfae-98ddc1f37680', 5)

Tax lines can also be added in bulk by specifying multiple items in the VALUES clause. 
INSERT INTO PaySlipTaxes (PayslipID, TaxLine_Amount) 
	VALUES 
	('ea5aaaa7-c330-41d8-bfae-98ddc1f37680', 5),
	('ea5aaaa7-c330-41d8-bfae-98ddc1f37680', 8)

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 PaySlipTaxes SET TaxLine_Amount = 10 WHERE Id = '2|ea5aaaa7-c330-41d8-bfae-98ddc1f37680'

DELETE

Supply the Id to delete payslip tax lines. 

DELETE FROM PaySlipTaxes WHERE Id = '2|ea5aaaa7-c330-41d8-bfae-98ddc1f37680'

Columns

Name Type ReadOnly Filterable Description
Id [KEY] String True

The earnings line-item identifier that combines the specific payslip's unique Xero identifier with the tax line item details, uniquely identifying each tax line entry within a payslip.

PayslipID String False

The unique identifier for a specific payslip, assigned by Xero. This ensures that each payslip is individually identifiable and can be uniquely processed or queried in payroll systems.

EmployeeID String True

The unique identifier for the employee associated with the payslip, linking the tax line to the specific employee's pay records.

TaxLine_TaxTypeName String False

The name of the tax type associated with this line item, such as income tax, payroll tax, or other relevant taxes, which helps in classifying the type of tax applied.

TaxLine_Description String False

A description that provides details on the nature of the tax applied to this line item, helping to clarify the type or reason for the tax.

TaxLine_Amount Decimal False

The actual amount of tax applied to the employee's earnings for this line item, calculated based on the tax rate and relevant tax rules.

TaxLine_LiabilityAccount String False

The account code assigned to track the liability of the tax owed. This account is used to manage the amounts due for payment to tax authorities.

TenantId String False

The unique identifier for the tenant (organization) in Xero. This ensures the tax line item is linked to the correct organization's payroll system and tenant information.

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