# PayrollResultsInColumnsPerPeriodByPayrollAdministrationIdAsExcelXlsx Download payrollresults in columns __Activity name :__ GetPayrollResultsInColumnsPerPeriodByPayrollAdministrationId This overview contains wage results. The wage results are subdivided per period. A column is included for each period. A total column is included per year. The overview contains the wage results of all components as standard. The number of components can be limited by specifying a component set. 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: `PayrollAdministrationReports` ## Parameters of Table Function | Name | Data Type | Required | Default Value | Documentation | |---|:---:|:---:|:---:|---| | `payrollAdministrationId` | `guid` | ☑ | | The unique identifier of an administration | | `payrollComponentSetId` | `guid` | ☐ | | A predefined set of payroll components to filter what payroll components are returned | | `payrollPeriodIdEnd` | `int32` | ☑ | | The unique identifier of the payroll period | | `payrollPeriodIdStart` | `int32` | ☑ | | The unique identifier of the payroll period | ## Columns The columns of the table `PayrollResultsInColumnsPerPeriodByPayrollAdministrationIdAsExcelXlsx` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `DOCUMENT` | `byte[]` | Document | ☐ | |