PaySlipReimbursements
Query payslip reimbursements line-items for a Xero organisation.
Table Specific Information
Queries
Equal operatorThe equal operator is supported on the server side:
SELECT * FROM PaySlipReimbursements WHERE PayslipID ='218db321-b72e-4aa1-9067-477d63705f95'
IN operator
The IN operator is supported on the client side:
SELECT * FROM PaySlipReembursements 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. | |
ReimbursementLine_ReimbursementTypeId | String | The unique identifier of the line-item's reimbursement type | |
ReimbursementLine_Description | String | A description of the reimbursement | |
ReimbursementLine_ExpenseAccount | String | The account the reimbursement is paid from | |
ReimbursementLine_Amount | Decimal | The amount of the reimbursement | |
TenantId | String | The ID of the tenant to query instead of the connection tenant |