# CompanyCarsByEmploymentId List of company cars for an employment __Activity name:__ GetCompanyCarsByEmploymentId Get the list of company cars for an employment. Please note this resource is related for the registration of the company car for HRM purposes. This resource is NOT related to the registration of the fiscal company car(s) which is used in salary calculations. Select loket.nl (REST) API URL: /providers/employers/employees/employments/{employmentId}/companycars Insert loket.nl (REST) API URL: /providers/employers/employees/employments/{employmentId}/companycars Update loket.nl (REST) API URL: /providers/employers/employees/employments/{employmentId}/companycars Delete loket.nl (REST) API URL: /providers/employers/employees/employments/{employmentId}/companycars Select loket.nl (REST) API Operation: get /providers/employers/employees/employments/{employmentId}/companycars Insert loket.nl (REST) API Operation: post /providers/employers/employees/employments/{employmentId}/companycars - Catalog: `LoketNlRest` - Schema: `CompanyCar` - 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 `CompanyCarsByEmploymentId` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `brand` | `string` | | ☐ | Brand of the vehicle. | | `catalogValue` | `double` | | ☐ | The catalog value of the car. | | `comments` | `string` | | ☐ | Any comments on the car or the contract. | | `endDate` | `datetime` | | ☐ | The end date of the entity. The date is up to and including. | | `fuelCardNumber` | `string` | | ☐ | Registration number of the fuel card. | | `id` | `guid` | | ☐ | The unique identifier of an object (GUID/UUID) | | `kilometersPrivateUse` | `int32` | | ☐ | The number kilometers per year the employee can use the car for private purposes. | | `lease_contractNumber` | `string` | | ☐ | Registration number of the lease contract. | | `lease_endDate` | `datetime` | | ☐ | The end date of the entity. The date is up to and including. | | `lease_startDate` | `datetime` | | ☐ | The start date of the entity. | | `leaseOrBuy_key` | `int32` | | ☐ | | | `leaseOrBuy_value` | `string` | | ☐ | | | `licensePlateNumber` | `string(8)` | | ☐ | Vehicle registration number (license plate) of the company car. The number should be provided with or without any hyphens (-). | | `model` | `string` | | ☐ | Model of the vehicle. | | `startDate` | `datetime` | | ☐ | The start date of the entity. | | `supplier` | `string` | | ☐ | Name of the company the delivered the company car. |