0

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.

Guido Leenders
  • 4,232
  • 1
  • 23
  • 43
Bram Reemers
  • 99
  • 4
  • 1
    What tables did you check already? Is it a Exact Online configuration with Payrolling or without? (Since Exact Online has some weird options that remove fields when you have both Payrolling and PSA.) – Guido Leenders Sep 15 '17 at 13:40

1 Answers1

2

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
Guido Leenders
  • 4,232
  • 1
  • 23
  • 43
Bram Reemers
  • 99
  • 4