# AccumulatedBasicJournalResultsReportByPayrollAdministrationId Download accumulated basic journal results report __Activity name :__ GetAccumulatedBasicJournalResultsReportByPayrollAdministrationId Acquire accumulated basic journal results reports (cumulatief journaal niet-verdicht en verdicht) at the payroll administration level. Currently this endpoint supports following report types to be requested: _Please note: this endpoint may only be used to acquire a report in the pdf-type format_ 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 | |---|:---:|:---:|:---:|---| | `endPeriod` | `int64` | ☑ | | Last period (=up to and including) of the requested timebox. Use the following 'YYYYPP' | | `groupingType` | `string` | ☑ | | The type of grouping that is requested. This affects the way the data is presented within the given report. (Waarden: perPeriod, perDistributionUnit, perPeriodPerDistributionUnit) | | `payrollAdministrationId` | `guid` | ☑ | | The unique identifier of an administration | | `reportType` | `string` | ☑ | | The type of report that is requested. (Values: nonAggregated, aggregatedPerGeneralLedgerAccount) | | `startPeriod` | `int64` | ☑ | | First period (=from) of the requested timebox. Use the format 'YYYYPP' | ## Columns The columns of the table `AccumulatedBasicJournalResultsReportByPayrollAdministrationId` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `DOCUMENT` | `byte[]` | Document | ☐ | |