# AccumulatedJournalRunResultsReportByPayrollAdministrationId Download accumulated journalrun results report __Activity name :__ GetAccumulatedJournalRunResultsReportByPayrollAdministrationId Acquire accumulated journalrun results report (CSV) at the payroll administration level. 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 | |---|:---:|:---:|:---:|---| | `date` | `datetime` | ☑ | | Date | | `endPeriod` | `int64` | ☑ | | Last period (=up to and including) of the requested timebox. Use the following 'YYYYPP' | | `financialYear` | `int32` | ☑ | | fiscal year. | | `payrollAdministrationId` | `guid` | ☑ | | The unique identifier of an administration | | `period` | `int32` | ☑ | | fiscal period. | | `reportDescription` | `string` | ☐ | | Description to be shown on the overview. | | `reportJournalNumber` | `int32` | ☑ | | Journal number. | | `reportVoucherNumber` | `int32` | ☑ | | Entry number. | | `startPeriod` | `int64` | ☑ | | First period (=from) of the requested timebox. Use the format 'YYYYPP' | ## Columns The columns of the table `AccumulatedJournalRunResultsReportByPayrollAdministrationId` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `DOCUMENT` | `byte[]` | Document | ☐ | |