# JournalRunResultsByJournalRunId Get journal results for a journal run __Activity name :__ GetJournalRunResultsByJournalRunId Returns the journal run results for the journal run. Journal runs with journalRunStatus = 0,1,2,3 dont have results and this endpoint will return an error if called for a journal run with that status. Select loket.nl (REST) API URL: /providers/employers/payrolladministrations/journalruns/{journalrunId}/results Insert loket.nl (REST) API URL: /providers/employers/payrolladministrations/journalruns/{journalrunId}/results Update loket.nl (REST) API URL: /providers/employers/payrolladministrations/journalruns/{journalrunId}/results Delete loket.nl (REST) API URL: /providers/employers/payrolladministrations/journalruns/{journalrunId}/results Select loket.nl (REST) API Operation: get /providers/employers/payrolladministrations/journalruns/{journalrunId}/results - Catalog: `LoketNlRest` - Schema: `JournalRunResults` - Field Selection Method: NotRequired - Base Path: `_embedded[*]` This is a read-only table function. The loket.nl (REST) API may not support changing the data or the Invantive SQL driver for loket.nl (REST) does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the loket.nl (REST) API. ## Parameters of Table Function | Name | Data Type | Required | Default Value | Documentation | |---|:---:|:---:|:---:|---| | `journalrunId` | `guid` | ☑ | | The unique identifier of the payroll run | ## Columns of Table Function The columns of the table function `JournalRunResultsByJournalRunId` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `costCenter_code` | `string` | | ☐ | | | `costCenter_description` | `string` | | ☐ | | | `costCenter_key` | `int32` | | ☐ | | | `costUnit_code` | `string` | | ☐ | | | `costUnit_description` | `string` | | ☐ | | | `costUnit_key` | `int32` | | ☐ | | | `creditAmount` | `decimal` | | ☐ | The credit amount for the ledger entry. | | `debetAmount` | `decimal` | | ☐ | The debet amount for the ledger entry. | | `generalLedgerAccount_code` | `string` | | ☐ | The general ledger accounting number (grootboekrekeningnummer) | | `generalLedgerAccount_description` | `string` | | ☐ | Description for the general ledger accounting number. | | `generalLedgerAccount_key` | `int32` | | ☐ | Database id (unique per administration). | | `payrollComponent_description` | `string(14)` | | ☐ | The description of the payroll component | | `payrollComponent_key` | `int32` | | ☐ | The number for the payroll component. This number has meaning to payroll professionals using Loket.nl who often know it by heart. |