PaySlipLeaveAccrual
Tracks leave accruals on the payslip. It helps manage and report on the amount of leave an employee has accrued over time.
Table Specific Information
This table supports the following operators server-side: =,IN
INSERT
To insert a single row, set the required fields. The 本製品 adds a new leave accrual line to the payslip.
INSERT INTO PaySlipLeaveAccrual (PaySlipID, LeaveAccrualLine_LeaveTypeId, LeaveAccrualLine_NumberOfUnits, LeaveAccrualLine_AutoCalculate) VALUES ('ea5aaaa7-c330-41d8-bfae-98ddc1f37680', '73f37030-b1ed-45fe-b7a2-f704a3a28ad4', 8, false)
Leave Accrual lines can also be added in bulk by specifying multiple items in the VALUES clause.
INSERT INTO PaySlipLeaveAccrual (PaySlipID, LeaveAccrualLine_LeaveTypeId, LeaveAccrualLine_NumberOfUnits, LeaveAccrualLine_AutoCalculate)
VALUES
('ea5aaaa7-c330-41d8-bfae-98ddc1f37680', '73f37030-b1ed-45fe-b7a2-f704a3a28ad4', 8, false),
('ea5aaaa7-c330-41d8-bfae-98ddc1f37680', '73f37030-b1ed-45fe-b7a2-f704a3a28ad4', 12, false)
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 PaySlipLeaveAccrual SET LeaveAccrualLine_NumberOfUnits = 5 WHERE Id = '2|ea5aaaa7-c330-41d8-bfae-98ddc1f37680'
DELETE
Supply the Id to delete leave accrual lines.
DELETE FROM PaySlipLeaveAccrual WHERE Id = '2|ea5aaaa7-c330-41d8-bfae-98ddc1f37680' PaySlipReimbursements
Columns
| Name | Type | ReadOnly | Filterable | Description |
| Id [KEY] | String | True |
A unique identifier for the earnings line item, which combines the specific line item and the Xero identifier of the associated payslip. This allows each leave accrual line to be uniquely identified and referenced in the payroll system. | |
| PayslipID | String | False |
The unique identifier for the payslip assigned by Xero. This links the leave accrual line to the specific payslip it belongs to, ensuring the payroll details are correctly associated with the employee's earnings and deductions. | |
| EmployeeID | String | True |
The unique identifier for the employee associated with this leave accrual. This links the leave accrual line to a specific employee's payslip and ensures accurate tracking of their leave entitlements. | |
| LeaveAccrualLine_LeaveTypeId | String | False |
The unique identifier of the leave type applied to the leave accrual line. This ensures that the type of leave being accrued (for example, annual leave or sick leave) is clearly tracked and correctly categorized. | |
| LeaveAccrualLine_NumberOfUnits | Double | False |
The number of leave units (for example, hours or days) being accrued for this leave type in this payslip. This value represents the amount of leave the employee is entitled to for the current period. | |
| LeaveAccrualLine_AutoCalculate | String | False |
Indicates whether the leave accrual should be automatically calculated based on predefined rules or entered manually. This helps automate the leave tracking process, reducing the need for manual data entry and potential errors. | |
| TenantId | String | False |
The unique identifier for the tenant (or organization) in Xero. This ensures that the leave accrual data is linked to the correct organization and helps maintain accurate records across multiple tenants. |