# WageImportDataByPayrollAdministrationId 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) This is a read-only table function. The Loket.nl REST API may not support changing the data, or the Invantive UniversalSQL driver for Loket.nl REST does not support it. In the latter case, use the table NativePlatformScalarRequests to upload data to the Loket.nl REST API. - Catalog: `LoketNlRest` - Schema: `WageImport` ## Parameters of Table Function | Name | Data Type | Required | Default Value | Documentation | |---|:---:|:---:|:---:|---| | `payrollAdministrationId` | `guid` | ☑ | | The unique identifier of an administration | ## Columns The columns of the table `WageImportDataByPayrollAdministrationId` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `clientNumber` | `int32` | Customer 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` | | ☐ | | | `formattedName` | `string` | | ☐ | preformated user name for displaying. \<lastname\>\", \"\<initials\>\" \"\<prefix\> | | `grossWage` | `double` | Gross Wage | ☐ | The gross wage for the employee | | `grossWageTypeKey` | `int32` | | ☐ | | | `netWage` | `double` | Net Wage | ☐ | Net wage for the employment | | `netWageTypeKey` | `int32` | | ☐ | | | `payrollEmployeeNumber` | `int32` | | ☐ | The number of the employment in relation to the payroll administration. | | `startDate` | `datetime` | Start Date | ☐ | The start date of the Wage |