Power BI Connector for Xero

Build 24.0.9060

EmployeePayTemplateEarnings

Query the pay template earnings lines for an Employee in a Xero organisation.

Columns

Name Type Filterable Description
EmployeeID String The Id of the Employee. This field is assigned by Xero.
EarningsRateID String The Id of the Earnings Rate used for this line item
CalculationType String One of USEEARNINGSRATE, ENTEREARNINGSRATE or ANNUALSALARY
NumberOfUnitsPerWeek Int How many hours the employee works per week. Only used for ANNUALSALARY.
AnnualSalary Decimal The annual salary of the employee
RatePerUnit Decimal The rate per unit of the earnings line
NormalNumberOfUnits Decimal The units of time in the earnings line
TenantId String The ID of the tenant to query instead of the connection tenant

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060