This article explains how to receive an overview of IBAN account used by Loket.nl payrolling. The overview can be used as an additional measure to prevent fraud.

Instructions

Execute the following steps:

  • Start Invantive Query Tool.

  • Connect to loket.nl (REST) using your Loket.nl credentials.

  • Execute the following query:

--
-- Overview of IBAN accounts used per employee and employment.
--
select eet.epr_companyName
,      eet.ept_employee_formattedName
,      eet.ept_startDate
,      eet.ept_endDate
,      eet.ept_employee_dateOfBirth
,      pit.payrollComponent_value
,      pit.iban
from   employeremployments eet
join   PaymentInformationSepaByEmploymentId(eet.ept_id) pit
order
by     eet.epr_companyName
,      eet.ept_employee_formattedName
,      eet.ept_startDate
SQL
  • Optionally export the results using “local export results“ or the Export button.