PaySlipReimbursements
Manages payslip reimbursement line items. It tracks reimbursements made to employees for out-of-pocket expenses.
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 reimbursement line to the payslip.
INSERT INTO PaySlipReimbursements (PaySlipID, ReimbursementLine_ReimbursementTypeId, ReimbursementLine_Amount) VALUES ('ea5aaaa7-c330-41d8-bfae-98ddc1f37680', '3432120f-4d83-4bc2-8b5d-5a116838229e', 5)
Reimbursement lines can also be added in bulk by specifying multiple items in the VALUES clause.
INSERT INTO PaySlipReimbursements (PaySlipID, ReimbursementLine_ReimbursementTypeId, ReimbursementLine_Amount)
VALUES
('ea5aaaa7-c330-41d8-bfae-98ddc1f37680', '3432120f-4d83-4bc2-8b5d-5a116838229e', 5),
('ea5aaaa7-c330-41d8-bfae-98ddc1f37680', '3432120f-4d83-4bc2-8b5d-5a116838229e', 12)
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 PaySlipReimbursements SET ReimbursementLine_Amount = 6 WHERE Id = '2|ea5aaaa7-c330-41d8-bfae-98ddc1f37680'
DELETE
Supply the Id to delete payslip reimbursement lines.
DELETE FROM PaySlipReimbursements WHERE Id = '2|ea5aaaa7-c330-41d8-bfae-98ddc1f37680'
Columns
| Name | Type | ReadOnly | Filterable | Description |
| Id [KEY] | String | True |
A unique identifier for the reimbursement line item, combining the specific line item and the Xero identifier of the associated payslip. This ensures precise identification of the reimbursement in the payroll system. | |
| PayslipID | String | False |
The unique identifier of the payslip, as assigned by Xero. This links the reimbursement line item to a specific payslip and ensures that the reimbursement is accurately reflected in the employee's payroll record. | |
| EmployeeID | String | True |
The unique identifier of the employee associated with this reimbursement line. This links the reimbursement to the specific employee's payslip and payroll details. | |
| ReimbursementLine_ReimbursementTypeId | String | False |
The unique identifier for the type of reimbursement applied to this line item. This could include types such as travel expenses, meal allowances, or other employee reimbursements. | |
| ReimbursementLine_Description | String | False |
A brief description of the reimbursement, specifying what the reimbursement is for. This is important for tracking the nature of each reimbursement line in the payroll system. | |
| ReimbursementLine_ExpenseAccount | String | False |
The account from which the reimbursement is paid. This ensures that the financial transaction for the reimbursement is recorded in the correct expense account in the company's accounting system. | |
| ReimbursementLine_Amount | Decimal | False |
The amount of the reimbursement. This is the dollar value being reimbursed to the employee and should match the amount on the payslip for proper payroll and financial tracking. | |
| TenantId | String | False |
The unique identifier for the tenant (organization) in Xero. This ensures the reimbursement data is associated with the correct organization, enabling accurate payroll and financial reporting across multiple tenants or organizations. |