PaySlipTaxes
Query payslip tax line-items for a Xero organisation.
Table Specific Information
Queries
Equal operatorThe equal operator is supported on the server side:
SELECT * FROM PaySlipTaxes WHERE PayslipID ='218db321-b72e-4aa1-9067-477d63705f95'
IN operator
The IN operator is supported on the client side:
SELECT * FROM PaySlipTaxes WHERE PayslipID IN ('1843c739-aa8b-4d58-956a-3e097708cd84','218db321-b72e-4aa1-9067-477d63705f95')
Columns
Name | Type | Filterable | Description |
Id [KEY] | String | The earnings line-item combined with the unique Xero identifier of the payslip | |
PayslipID | String | The unique identifier of the payslip. This field is assigned by Xero. | |
EmployeeID | String | The unique identifier of the payslip's employee. | |
TaxLine_TaxTypeName | String | The name of the line-item's tax type | |
TaxLine_Description | String | The description of the tax | |
TaxLine_Amount | Decimal | The tax's amount | |
TaxLine_LiabilityAccount | String | The liability account used to pay the tax | |
TenantId | String | The ID of the tenant to query instead of the connection tenant |