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
- Optionally export the results using “local export results“ or the Export button.