# ActualBenefitsInKindByEmployerId List of actual benefits in kind for an employer __Activity name:__ GetActualBenefitsInKindByEmployerId Get the list of actual benefits in kind for all employments of 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 `ActualBenefitsInKindByEmployerId` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `benefitsInKind_benefitInKindType_description` | `string` | | ☐ | | | `benefitsInKind_benefitInKindType_id` | `guid` | | ☐ | The unique identifier of an object (GUID/UUID) | | `benefitsInKind_brand` | `string(30)` | | ☐ | The brand of the benefit in kind. | | `benefitsInKind_endDate` | `datetime` | | ☐ | The end date of the entity. The date is up to and including. | | `benefitsInKind_id` | `guid` | | ☐ | The unique identifier of an object (GUID/UUID) | | `benefitsInKind_particularities` | `string(4000)` | | ☐ | Extra information about the benefit in kind | | `benefitsInKind_startDate` | `datetime` | | ☐ | The date on which this BenefitInKind starts. So multiple Benefits in kind can be active at the same time but one specific BenefitsInKind can never be active multiple times at the same time. | | `benefitsInKind_supplier` | `string(30)` | | ☐ | The supplier of the benefit in kind. | | `benefitsInKind_type` | `string(30)` | | ☐ | The type of the benefit in kind. | | `benefitsInKind_value` | `decimal` | | ☐ | The value for the selected benefit of kind. | | `employmentId` | `guid` | Employment ID | ☐ | The unique identifier of an object (GUID/UUID) |