# LedgerAccountsByJournalProfileId List of ledger accounts __Activity name:__ GetLedgerAccountsByJournalProfileId Get the list of ledger accounts for a journal profile for a specific payroll administration. 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: `JournalProfile` ## Parameters of Table Function | Name | Data Type | Required | Default Value | Documentation | |---|:---:|:---:|:---:|---| | `journalProfileId` | `guid` | ☑ | | The unique identifier of a journal profile | ## Columns The columns of the table `LedgerAccountsByJournalProfileId` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `consolidate` | `boolean` | | ☐ | If set to true and multiple payrollcomponents are linked to this account only the sum of all values is booked. If set to false and multiple payrollcomponents are linked to this account all individual values is booked. If payroll component is not shown this will result in multiple lines with the same ledger account, cost center and cost unit probably with different values. | | `costAccount` | `boolean` | | ☐ | If set to true it is possible to devide costs for this account between cost centers and units. If set to false it is not possible to devide costs for this account between cost centers and units. | | `description` | `string(50)` | Description | ☐ | The description for a ledger account | | `id` | `guid` | ID | ☐ | The unique identifier of an object (GUID/UUID) | | `number` | `string(20)` | | ☐ | The "number" for a ledger account (is a string) | | `origin_consolidate` | `int64` | | ☐ | Meaning of the integer: * 1 = CAO * 2 = Loonmodel * 3 = Administratie (Ulsa werkgever) * 4 = Provider | | `origin_costAccount` | `int64` | | ☐ | Meaning of the integer: * 1 = CAO * 2 = Loonmodel * 3 = Administratie (Ulsa werkgever) * 4 = Provider | | `origin_description` | `int64` | | ☐ | Meaning of the integer: * 1 = CAO * 2 = Loonmodel * 3 = Administratie (Ulsa werkgever) * 4 = Provider | | `origin_number` | `int64` | | ☐ | Meaning of the integer: * 1 = CAO * 2 = Loonmodel * 3 = Administratie (Ulsa werkgever) * 4 = Provider |