# JournalAllocationsByEmploymentId List of journal allocations for an employment __Activity name:__ GetJournalAllocationsByEmploymentId Get the list of financial journal allocations (journaliseren module) for an employment. Select loket.nl (REST) API URL: /providers/employers/employees/employments/{employmentId}/journalallocations Insert loket.nl (REST) API URL: /providers/employers/employees/employments/{employmentId}/journalallocations Update loket.nl (REST) API URL: /providers/employers/employees/employments/{employmentId}/journalallocations Delete loket.nl (REST) API URL: /providers/employers/employees/employments/{employmentId}/journalallocations Select loket.nl (REST) API Operation: get /providers/employers/employees/employments/{employmentId}/journalallocations Insert loket.nl (REST) API Operation: post /providers/employers/employees/employments/{employmentId}/journalallocations - Catalog: `LoketNlRest` - Schema: `JournalAllocation` - Retrieve: true - Insert: true - Update: false - Delete: false - Field Selection Method: NotRequired - Base Path: `_embedded[*]` ## Parameters of Table Function | Name | Data Type | Required | Default Value | Documentation | |---|:---:|:---:|:---:|---| | `employmentId` | `guid` | ☑ | | The unique identifier of the employment | ## Columns of Table Function The columns of the table function `JournalAllocationsByEmploymentId` 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` | | ☐ | | | `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. |