# ActualBenefitsAndDeductionsByEmployerId List of actual benefitsanddeductions for an employer __Activity name:__ GetActualBenefitsAndDeductionsByEmployerId Get the list of actual benefitsanddeductions for an employer 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: `Actuals` ## Parameters of Table Function | Name | Data Type | Required | Default Value | Documentation | |---|:---:|:---:|:---:|---| | `employerId` | `guid` | ☑ | | The unique identifier of the employer | | `referenceDate` | `datetime` | ☐ | | Set a reference date for choosing the date dependent data. | ## Columns The columns of the table `ActualBenefitsAndDeductionsByEmployerId` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `benefitsAndDeductions_endDate` | `datetime` | | ☐ | The end date for the information in the record. | | `benefitsAndDeductions_id` | `guid` | | ☐ | The unique identifier of an object (GUID/UUID) | | `benefitsAndDeductions_payrollComponent_category_key` | `int32` | | ☐ | | | `benefitsAndDeductions_payrollComponent_category_value` | `string` | | ☐ | | | `benefitsAndDeductions_payrollComponent_deductionOrPayment_key` | `int32` | | ☐ | | | `benefitsAndDeductions_payrollComponent_deductionOrPayment_value` | `string` | | ☐ | | | `benefitsAndDeductions_payrollComponent_description` | `string(14)` | | ☐ | The description of the payroll component | | `benefitsAndDeductions_payrollComponent_key` | `int32` | | ☐ | The number for the payroll component. | | `benefitsAndDeductions_startDate` | `datetime` | | ☐ | The start date for the information in the record. A (linked chain)[./#section/Data/Date-chains] per payroll component is maintained within this resource. | | `benefitsAndDeductions_value` | `decimal` | | ☐ | The value for the selected payroll component. <br/> | | `employmentId` | `guid` | Employment ID | ☐ | The unique identifier of an object (GUID/UUID) |