Project Report with internal rate from Exact Online in Invantive SQL

67 views Asked by At

I would like to make a report in Invantive using the internal rate from Exact Online Projectmanagement. I am not able to find the right table for this report. I can't find the information which has the dates with corresponding internal rate per employee.

1

There are 1 answers

0
Bram Reemers On

The internal rates with coresponding dates of activement can be found in the EmploymentSalaries table, see REST documentation and XML documentation.

With the following statement you will find the relevant data:

select EMPLOYMENTSALARIES_EMPLOYMENTCLA_EMPLOYMENTCLAS_EMPLOYMENT_EMPLOYEE_EMPLOYEEHID_ATTR
,      InternalRate
,      Startdate
,      enddate
from   ExactOnlineXML.XML.EmploymentSalaries