# PayrollRunBalanceSheetByPayrollRunId__embeddedJournalAllocationAsJson 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 `PayrollRunBalanceSheetByPayrollRunId__embeddedJournalAllocationAsJson` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `costCenter_code` | `string(20)` | Cost Centre Code | ☐ | The code of the cost center | | `costCenter_key` | `int32` | Cost Centre Key | ☐ | The key of the cost center | | `costCenter_value` | `string(50)` | | ☐ | The description of the cost center | | `costUnit_code` | `string(20)` | Cost Unit Code | ☐ | The code of the cost unit | | `costUnit_key` | `int32` | Cost Key Code | ☐ | The key of the cost unit | | `costUnit_value` | `string(50)` | | ☐ | The description of the cost unit | | `generalLedgerAccount_generalLedgerAccountnumber` | `string(20)` | | ☐ | The account number for the general ledger account | | `generalLedgerAccount_key` | `int32` | Ledger Account Key | ☐ | The key of the general ledger account | | `generalLedgerAccount_value` | `string(50)` | | ☐ | The description of the general ledger account | | `payrollComponent_balanceSheetSide_key` | `int32` | | ☐ | Indicates on what side (debit or credit) the value should go | | `payrollComponent_balanceSheetSide_value` | `string(50)` | | ☐ | The description of the side of the balance sheet | | `payrollComponent_description` | `string(14)` | Payroll Component Description | ☐ | The description of the payroll component | | `payrollComponent_key` | `int32` | Payroll Component Key | ☐ | The number for the payroll component. This number has meaning to payroll professionals using Loket.nl who often know many of them by heart. | | `value` | `decimal` | Value | ☐ | The sum of all the values for the payrollcomponent in the specific payroll run. Payroll period, employment and normal/tarif payslip are not taken into account and simply summed up. |