# JournalApplicationByJournalConfigurationId Get the journal application for a journal configuration __Activity name:__ GetJournalApplicationByJournalConfigurationId Get the journal application for a journal configuration 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: `JournalApplication` ## Parameters of Table Function | Name | Data Type | Required | Default Value | Documentation | |---|:---:|:---:|:---:|---| | `journalConfigurationId` | `guid` | ☑ | | The unique identifier of a journal configuration | ## Columns The columns of the table `JournalApplicationByJournalConfigurationId` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `account_key` | `int32` | | ☐ | | | `account_value` | `string(250)` | | ☐ | | | `description` | `string(255)` | Description | ☐ | The description to be send in with the ledger lines | | `deviatingJournalSeries` | `string(1)` | | ☐ | Journal Entry Series Deviation | | `financialAdministration_code` | `string(255)` | | ☐ | The key of the financial administration | | `financialAdministration_externalValue` | `string(255)` | | ☐ | Name of the financial administration. This field is only set when a connection with an external API exists (via `account`) to aquire the name from. | | `includeCostCenter` | `boolean` | | ☐ | Indicates whether cost centers are included in the journal export | | `includeCostUnit` | `boolean` | | ☐ | Indicates whether cost units are included in the journal export | | `isAutomatedExportEnabled` | `boolean` | | ☐ | This field indicates whether journalruns will be exported automaticaly or not | | `journalApplication_key` | `int32` | | ☐ | The key of journal application | | `journalApplication_value` | `string(50)` | | ☐ | Name of the journal application | | `journalCode` | `string(255)` | | ☐ | JournalCode | | `linkCostCenterToGroup_code` | `string` | | ☐ | The code of the group | | `linkCostCenterToGroup_externalValue` | `string(255)` | | ☐ | Name of the group. This field is only set when a connection with an external API exists (via `account`) to aquire the name from. | | `linkCostUnitToGroup_code` | `string` | | ☐ | The code of the group | | `linkCostUnitToGroup_externalValue` | `string(255)` | | ☐ | Name of the group. This field is only set when a connection with an external API exists (via `account`) to aquire the name from. | | `methodForDeterminingAccountingPeriod_key` | `int32` | | ☐ | The key of accounting period determination method | | `methodForDeterminingAccountingPeriod_value` | `string(50)` | | ☐ | description of the method When "Op basis van schema" is used `payrollPeriodFinancialPeriodMapping` must have a value. Note that not all applications support "Op basis van schema" |