invantive documentation
Invantive Support ForumsLog In / Sign Up

WageImportDataByPayrollAdministrationId: Loket.nl REST itgen_loketnl_wageimportdatabypayrolladministrationid_plural

read only REST

  • Catalog: LoketNlRest
  • Schema: WageImport
  • Label: itgen_loketnl_wageimportdatabypayrolladministrationid_plural

Get data to create an importfile Activity name : GetWageImportDataByPayrollAdministrationId

Returns, for the given payrolladministration, a set of data that can be used as a base for importing wage through a csv file.

Note that on importing, the columnnames must be in Dutch. (Clientnr PersnrVerl Persnr Naam Ingangsdatum Basisloon BasisloonEenheid Nettoloon NettoloonEenheid Loonkosten LoonkostenEenheid)

Can only retrieve data.

API Source

  • Endpoint: /providers/employers/payrolladministrations/{payrollAdministrationId}/import/wage"
  • Operation: get /providers/employers/payrolladministrations/{payrollAdministrationId}/import/wage"

Parameters

Name Data Type Required Default Documentation
payrollAdministrationId `` The unique identifier of an administration

Table Columns

The columns of the table WageImportDataByPayrollAdministrationId are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.

Name Data Type Label Required Marks Documentation
clientNumber int32 Client Number The employer number is used in various overviews and exports to identify a specific employer in Loket (please note: this is not the identifier used in the REST API).
employeeNumber int32 Employee Number The employee number to uniquely identify an employee within an employer
employerCosts double Employer Costs The cost for the employer for this employee.
employerCostsTypeKey int32 itgen_loketnl_employercoststypekey
formattedName varchar2 itgen_loketnl_formattedname preformated user name for displaying. <lastname>", "<initials>" "<prefix>
grossWage double Gross Wage The gross wage for the employee
grossWageTypeKey int32 itgen_loketnl_grosswagetypekey
netWage double Net Wage Net wage for the employment
netWageTypeKey int32 itgen_loketnl_netwagetypekey
payrollEmployeeNumber int32 itgen_loketnl_payrollemployeenumber The number of the employment in relation to the payroll administration.
startDate datetime Start Date The start date of the Wage

Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver: