Query payslip tax 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 add-in 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 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.
TaxLine_TaxTypeName	String	False		The name of the line-item's tax type
TaxLine_Description	String	False		The description of the tax
TaxLine_Amount	Decimal	False		The tax's amount
TaxLine_LiabilityAccount	String	False		The liability account used to pay the tax
TenantId	String	False		The ID of the tenant to query instead of the connection tenant