# AccumulationsAndBalancesReportByPayrollAdministrationIdAsPdf Download accumulations and balances reports __Activity name :__ GetAccumulationsAndBalancesReportByPayrollAdministrationId Acquire the reports for either accumulations or balances at the payroll administration level. Currently this endpoint supports following report types to be requested: * baseForCalculationBalancesAtStartOfYear (grondslag begin jaar) * leaveBalancesAtStartOfYear (verlof begin jaar) * leaveAccrualWithinYear (opbouw verlof ulsa) 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 | |---|:---:|:---:|:---:|---| | `includeEmploymentsThatEndedBeforeStartOfTheYear` | `boolean` | ☐ | | If set to true employments with an enddate before the start of the reportYear will be included in the output. | | `payrollAdministrationId` | `guid` | ☑ | | The unique identifier of an administration | | `reportType` | `string` | ☑ | | The type of report that is requested. (Waarden: baseForCalculationBalancesAtStartOfYear, leaveBalancesAtStartOfYear, leaveAccrualWithinYear) | | `reportYear` | `int64` | ☑ | | A valid year for which the information is requested. | ## Columns The columns of the table `AccumulationsAndBalancesReportByPayrollAdministrationIdAsPdf` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `DOCUMENT` | `byte[]` | Document | ☐ | |