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 |
|---|---|---|---|---|
payroll |
`` | 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 |
|---|---|---|---|---|---|
client |
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). | ||
employee |
int32 |
Employee Number | The employee number to uniquely identify an employee within an employer | ||
employer |
double |
Employer Costs | The cost for the employer for this employee. | ||
employer |
int32 |
itgen_loketnl_employercoststypekey | |||
formatted |
varchar2 |
itgen_loketnl_formattedname | preformated user name for displaying. <lastname>", "<initials>" "<prefix> | ||
gross |
double |
Gross Wage | The gross wage for the employee | ||
gross |
int32 |
itgen_loketnl_grosswagetypekey | |||
net |
double |
Net Wage | Net wage for the employment | ||
net |
int32 |
itgen_loketnl_netwagetypekey | |||
payroll |
int32 |
itgen_loketnl_payrollemployeenumber | The number of the employment in relation to the payroll administration. | ||
start |
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: