# PayrollRunBalanceSheetByPayrollRunIdAsCsv Get payroll run balance sheet __Activity name :__ GetPayrollRunBalanceSheetByPayrollRunId This endpoint returns per payroll components, marked as relevant for the general ledge (balance sheet), the sum of the values. If for the given payroll period of the payroll run a "journal profile" is configured the endpoint also returns the ledger account and costcenter/costunit linked to the given payroll component in the "journal profile" 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: `PayrollRunDownloads` ## Parameters of Table Function | Name | Data Type | Required | Default Value | Documentation | |---|:---:|:---:|:---:|---| | `payrollrunId` | `guid` | ☑ | | The unique identifier of the payroll run | ## Columns The columns of the table `PayrollRunBalanceSheetByPayrollRunIdAsCsv` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `DOCUMENT` | `byte[]` | Document | ☐ | The output in CSV |