Manages payslip timesheet earnings line items. It tracks earnings that are calculated based on time worked, such as hourly wages or overtime.

Table Specific Information

This table supports the following operators server-side: =,IN

INSERT

To insert a single row, set the required fields. The connector adds a new timesheet earnings line to the payslip.

INSERT INTO PaySlipTimesheetEarnings (PayslipID, TimesheetEarningsLine_EarningsRateId, TimesheetEarningsLine_RatePerUnit, TimesheetEarningsLine_NumberOfUnits) VALUES ('ea5aaaa7-c330-41d8-bfae-98ddc1f37680', 'c8602c7c-5f6f-433e-b7a7-bcbbd8386818', 32, 10)

Timesheet earnings lines can also be added in bulk by specifying multiple items in the VALUES clause.

INSERT INTO PaySlipTimesheetEarnings (PayslipID, TimesheetEarningsLine_EarningsRateId, TimesheetEarningsLine_RatePerUnit, TimesheetEarningsLine_NumberOfUnits)
	VALUES 
	('ea5aaaa7-c330-41d8-bfae-98ddc1f37680', 'c8602c7c-5f6f-433e-b7a7-bcbbd8386818', 32, 10),
	('ea5aaaa7-c330-41d8-bfae-98ddc1f37680', 'c8602c7c-5f6f-433e-b7a7-bcbbd8386818', 36, 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 PaySlipTimesheetEarnings SET TimesheetEarningsLine_NumberOfUnits = 5 WHERE Id = '2|ea5aaaa7-c330-41d8-bfae-98ddc1f37680'

DELETE

Supply the Id to delete timesheet earnings lines.

DELETE FROM PaySlipTimesheetEarnings WHERE Id = '2|ea5aaaa7-c330-41d8-bfae-98ddc1f37680'

Columns

Name	Type	ReadOnly	Filterable	Description
Id [KEY]	String	True		The earnings line-item identifier that combines the unique Xero identifier of the payslip with the specific timesheet earnings line details. This ensures each timesheet earnings line can be uniquely referenced within the payslip.
PayslipID	String	False		The unique identifier of the payslip, assigned by Xero. This identifier is used to link each timesheet earnings line to a specific payslip for processing and record-keeping.
EmployeeID	String	True		The unique identifier of the employee associated with the payslip. This links the timesheet earnings line to a specific employee's pay details.
TimesheetEarningsLine_EarningsRateId	String	False		The unique identifier of the earnings rate associated with this line item. This specifies the rate at which the employee is compensated for the time worked, whether it's based on hourly, unit, or salary rate.
TimesheetEarningsLine_RatePerUnit	Decimal	False		The rate per unit of time worked (such as hourly wage) for this line item. This amount is used to calculate the earnings based on the number of time units worked.
TimesheetEarningsLine_NumberOfUnits	Decimal	False		The number of time units worked (such as hours worked) for this timesheet earnings line. This value, when multiplied by the rate per unit, determines the total earnings for this line item.
TenantId	String	False		The unique identifier of the tenant (organization) in Xero. This ensures the timesheet earnings line is correctly associated with the appropriate organization's payroll system and tenant information.