# JournalAllocationBasedOnFixedWeightsByJournalAllocationId Details of a journal allocation __Activity name:__ GetJournalAllocationByJournalAllocationId Get the details of a financial journal allocation record (journaliseren module). Select loket.nl (REST) API URL: /providers/employers/employees/employments/journalallocations/{journalAllocationId} Insert loket.nl (REST) API URL: /providers/employers/employees/employments/journalallocations/{journalAllocationId} Update loket.nl (REST) API URL: /providers/employers/employees/employments/journalallocations/{journalAllocationId} Delete loket.nl (REST) API URL: /providers/employers/employees/employments/journalallocations/{journalAllocationId} Select loket.nl (REST) API Operation: get /providers/employers/employees/employments/journalallocations/{journalAllocationId} - Catalog: `LoketNlRest` - Schema: `JournalAllocation` - Field Selection Method: NotRequired - Base Path: `content.allocationBasedOnFixedWeights[*]` 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 | |---|:---:|:---:|:---:|---| | `journalAllocationId` | `guid` | ☑ | | The unique identifier of the journal allocation | ## Columns of Table Function The columns of the table function `JournalAllocationBasedOnFixedWeightsByJournalAllocationId` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `allocationBasedOnActualHours_costCenter_code` | `string` | | ☐ | | | `allocationBasedOnActualHours_costCenter_description` | `string` | | ☐ | | | `allocationBasedOnActualHours_costCenter_key` | `int32` | | ☐ | | | `allocationBasedOnActualHours_costUnit_code` | `string` | | ☐ | | | `allocationBasedOnActualHours_costUnit_description` | `string` | | ☐ | | | `allocationBasedOnActualHours_costUnit_key` | `int32` | | ☐ | | | `costCenter_code` | `string` | | ☐ | | | `costCenter_description` | `string` | | ☐ | | | `costCenter_key` | `int32` | | ☐ | | | `costUnit_code` | `string` | | ☐ | | | `costUnit_description` | `string` | | ☐ | | | `costUnit_key` | `int32` | | ☐ | | | `endPeriod_periodEndDate` | `datetime` | | ☐ | The last day of the payroll period. | | `endPeriod_periodNumber` | `int32` | | ☐ | The period (month [1 to 12] , 4 weeks [1 to 13] or week [1 to 53]) of the last payroll period for which the journal allocation is applicable. | | `endPeriod_periodStartDate` | `datetime` | | ☐ | The first day of the payroll period. | | `endPeriod_year` | `int32` | | ☐ | The year of the last payroll period for which the journal allocation is applicable. | | `id` | `guid` | | ☐ | The unique identifier of an object (GUID/UUID) | | `journalProfileConfiguration_endPeriod_periodEndDate` | `datetime` | | ☐ | The last day of the payroll period. | | `journalProfileConfiguration_endPeriod_periodNumber` | `int32` | | ☐ | The period (month [1 to 12] , 4 weeks [1 to 13] or week [1 to 53]) of the last payroll period for which the journal allocation is applicable. | | `journalProfileConfiguration_endPeriod_periodStartDate` | `datetime` | | ☐ | The first day of the payroll period. | | `journalProfileConfiguration_endPeriod_year` | `int32` | | ☐ | The year of the first payroll period for which the journal allocation is applicable. | | `journalProfileConfiguration_id` | `guid` | | ☐ | The unique identifier of an object (GUID/UUID) | | `journalProfileConfiguration_journalProfile_key` | `int32` | | ☐ | | | `journalProfileConfiguration_journalProfile_value` | `string` | | ☐ | | | `journalProfileConfiguration_startPeriod_periodEndDate` | `datetime` | | ☐ | The last day of the payroll period. | | `journalProfileConfiguration_startPeriod_periodNumber` | `int32` | | ☐ | The period (month [1 to 12] , 4 weeks [1 to 13] or week [1 to 53]) of the last payroll period for which the journal allocation is applicable. | | `journalProfileConfiguration_startPeriod_periodStartDate` | `datetime` | | ☐ | The first day of the payroll period. | | `journalProfileConfiguration_startPeriod_year` | `int32` | | ☐ | The year of the first payroll period for which the journal allocation is applicable. | | `startPeriod_periodEndDate` | `datetime` | | ☐ | The last day of the payroll period. | | `startPeriod_periodNumber` | `int32` | | ☐ | The period (month [1 to 12] , 4 weeks [1 to 13] or week [1 to 53]) of the last payroll period for which the journal allocation is applicable. | | `startPeriod_periodStartDate` | `datetime` | | ☐ | The first day of the payroll period. | | `startPeriod_year` | `int32` | | ☐ | The year of the first payroll period for which the journal allocation is applicable. | | `weight` | `int32` | | ☐ | The weight (factor) determines the relative weight when allocating the costs for this specific combination of costCenter and costUnit. |