EmployeePayTemplateEarnings
Queries the earnings lines of the employee's pay template. It helps track different types of earnings, such as regular wages, bonuses, and commissions.
Columns
| Name | Type | Filterable | Description |
| EmployeeID | String | The unique identifier for the employee, automatically assigned by Xero. | |
| EarningsRateID | String | The unique identifier for the earnings rate applied to this line item. It links to a predefined earnings rate. | |
| CalculationType | String | Specifies how the earnings amount is calculated. Possible values are 'USEEARNINGSRATE' (uses the predefined earnings rate), 'ENTEREARNINGSRATE' (custom rate entered by the user), or 'ANNUALSALARY' (based on an annual salary). | |
| NumberOfUnitsPerWeek | Int | The number of hours the employee works per week, applicable only when the 'ANNUALSALARY' calculation type is used. | |
| AnnualSalary | Decimal | The annual salary of the employee, used when the 'ANNUALSALARY' calculation type is chosen. | |
| RatePerUnit | Decimal | The rate per unit of earnings (for example, hourly rate), used when 'USEEARNINGSRATE' or 'ENTEREARNINGSRATE' is selected. | |
| NormalNumberOfUnits | Decimal | The units of time (for example, hours worked) associated with the earnings line. | |
| TenantId | String | The unique identifier for the tenant, allowing the query to target a specific tenant instead of the default connection tenant. |