---
title: "Mileages (Simplicate)"
description: "Mileages"
language: nl
source_language: en
translation_state: complete
canonical: https://documentation.invantive.eu/nl/datamodels/simplicate/Simplicate.Mileage.Mileages
original: https://documentation.invantive.eu/en/datamodels/simplicate/Simplicate.Mileage.Mileages
updated: 2026-11-18T23:54:04Z
license: https://documentation.invantive.eu/nl/
---

# Kilometers: Simplicate kilometers

`insert` `update` `delete` `REST`

- Catalogus: `Simplicate`
- Schema: `Mileage`
- Primaire sleutels: `id`
- Label: Kilometers

Haalt alle kilometerregistraties op

Je kunt gegevens ophalen en wijzigen met `insert`, `update` en `delete`.

## API-bron

- Eindpunt: `/mileage/mileage`
- Operatie: `get /mileage/mileage`

## Tabelkolommen

De kolommen van de tabel `Mileages` worden hieronder weergegeven. Elke kolom heeft een SQL-gegevenstype. Voor elke vereiste kolom moet bij het invoegen en bijwerken steeds een nieuwe, niet-lege waarde worden opgegeven.

| Name | Datatype | Label | Required | Marks | Documentation |
|---|---|---|:---:|---|---|
| `approvalstatus_description` | `varchar2` | Goedkeuringsstatus Omschrijving | [ ] |  |  |
| `approvalstatus_id` | `varchar2` | Goedkeuringsstatus ID | [ ] |  |  |
| `approvalstatus_label` | `varchar2` | Goedkeuringsstatuslabel | [ ] |  |  |
| `created_at` | `varchar2` | Aangemaakt op | [ ] |  |  |
| `employee_amount` | `double` | Medewerkerbedrag | [ ] |  |  |
| `employee_declarable` | `varchar2` | Declarabele Medewerker | [ ] |  |  |
| `employee_employee_id` | `varchar2` | Werknemer ID | [ ] |  |  |
| `employee_id` | `varchar2` | Werknemer ID | [ ] |  |  |
| `employee_name` | `varchar2` | Naam Werknemer | [ ] |  |  |
| `employee_person_id` | `varchar2` | Werknemer Persoon ID | [ ] |  | Toegevoegd om te voldoen aan de oorspronkelijke sales/sales responsible_employee-reactie |
| `employee_tariff` | `double` | Personeelstarief | [ ] |  |  |
| `id` | `varchar2` | ID | [ ] |  |  |
| `invoice_id` | `varchar2` | Factuur ID | [ ] |  | Zie /invoices/invoice |
| `invoice_status` | `varchar2` | Factuurstatus | [ ] |  |  |
| `invoiceline_id` | `varchar2` | Factuurregel ID | [ ] |  | Zie /invoices/invoice |
| `mileage` | `double` | Mileage | [ ] |  |  |
| `note` | `varchar2` | Note | [ ] |  |  |
| `project_has_register_mileage_enabled` | `char` | itgen_spe_project_has_register_mileage_enabled | [ ] |  |  |
| `project_id` | `varchar2` | Project ID | [ ] |  |  |
| `project_name` | `varchar2` | Projectnaam | [ ] |  |  |
| `project_organization_id` | `varchar2` | Projectorganisatie-ID | [ ] |  |  |
| `project_organization_name` | `varchar2` | Naam Projectorganisatie | [ ] |  |  |
| `project_organization_relation_number` | `varchar2` | itgen_spe_project_organization_relation_number | [ ] |  |  |
| `project_person_full_name` | `varchar2` | Project Persoon Volledige naam | [ ] |  |  |
| `project_person_id` | `varchar2` | Projectpersoon-ID | [ ] |  |  |
| `project_person_relation_number` | `varchar2` | itgen_spe_project_person_relation_number | [ ] |  |  |
| `project_project_manager_amount` | `double` | Projectmanager Bedrag | [ ] |  |  |
| `project_project_manager_declarable` | `varchar2` | Projectmanager Declarable | [ ] |  |  |
| `project_project_manager_employee_id` | `varchar2` | Projectmanager Werknemer ID | [ ] |  |  |
| `project_project_manager_id` | `varchar2` | Projectmanager ID | [ ] |  |  |
| `project_project_manager_name` | `varchar2` | Projectmanager Naam | [ ] |  |  |
| `project_project_manager_person_id` | `varchar2` | Projectmanager Persoon ID | [ ] |  | Toegevoegd om te voldoen aan de oorspronkelijke sales/sales responsible_employee-reactie |
| `project_project_manager_tariff` | `double` | Projectmanager Tarief | [ ] |  |  |
| `project_project_number` | `varchar2` | Projectnummer | [ ] |  |  |
| `related_hours_id` | `varchar2` | itgen_spe_related_hours_id | [ ] |  |  |
| `source` | `varchar2` | Source | [ ] |  |  |
| `start_date` | `varchar2` | Startdatum | [ ] |  |  |
| `tariff` | `double` | Tariff | [ ] |  |  |
| `type_billable` | `double` | Soort Factureerbaar | [ ] |  |  |
| `type_blocked` | `char` | Soort Geblokkeerd | [ ] |  |  |
| `type_color` | `varchar2` | Kleursoort | [ ] |  |  |
| `type_id` | `varchar2` | Type ID | [ ] |  |  |
| `type_label` | `varchar2` | Soort Label | [ ] |  |  |
| `type_tariff` | `double` | Soort Tarief | [ ] |  |  |
| `type_type` | `varchar2` | Type | [ ] |  |  |
| `type_vatclass_code` | `varchar2` | Soort BTW-Klasse Code | [ ] |  |  |
| `type_vatclass_id` | `varchar2` | Soort BTW-Klasse ID | [ ] |  |  |
| `type_vatclass_label` | `varchar2` | Soort BTW-klasselabel | [ ] |  |  |
| `type_vatclass_name` | `varchar2` | Type BTW-klasse Naam | [ ] |  |  |
| `type_vatclass_percentage` | `double` | Type BTW-klasse Percentage | [ ] |  |  |
| `updated_at` | `varchar2` | Bijgewerkt op | [ ] |  |  |
| `vatclass_code` | `varchar2` | BTW-klassecode | [ ] |  |  |
| `vatclass_id` | `varchar2` | BTW-klasse ID | [ ] |  |  |
| `vatclass_label` | `varchar2` | Btw-Klasse Label | [ ] |  |  |
| `vatclass_name` | `varchar2` | BTW-klasse Naam | [ ] |  |  |
| `vatclass_percentage` | `double` | BTW-Klasse Percentage | [ ] |  |  |


## Release Notes

Wat is er per release veranderd in de tabellen, kolommen, attributen en mogelijkheden van de driver:

- [Simplicate](/nl/release-notes/drivers?driver=simplicate)
