---
title: "Mileages (Simplicate)"
description: "Mileages"
language: en
source_language: en
translation_state: complete
canonical: https://documentation.invantive.eu/en/datamodels/simplicate/Simplicate.Mileage.Mileages
original: https://documentation.invantive.eu/en/datamodels/simplicate/Simplicate.Mileage.Mileages
updated: 2024-10-18T06:48:11Z
license: https://documentation.invantive.eu/en/
---

# Mileages: Simplicate Mileages

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

- Catalog: `Simplicate`
- Schema: `Mileage`
- Primary Keys: `id`
- Label: Mileages

Fetches all mileages

Can retrieve data and change data using `insert`, `update` and `delete`.

## API Source

- Endpoint: `/mileage/mileage`
- Operation: `get /mileage/mileage`

## Table Columns

The columns of the table `Mileages` are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.

| Name | Data Type | Label | Required | Marks | Documentation |
|---|---|---|:---:|---|---|
| `approvalstatus_description` | `varchar2` | Approval Status Description | [ ] |  |  |
| `approvalstatus_id` | `varchar2` | Approval Status ID | [ ] |  |  |
| `approvalstatus_label` | `varchar2` | Approval Status Label | [ ] |  |  |
| `created_at` | `varchar2` | Created at | [ ] |  |  |
| `employee_amount` | `double` | Employee Amount | [ ] |  |  |
| `employee_declarable` | `varchar2` | Employee Declarable | [ ] |  |  |
| `employee_employee_id` | `varchar2` | Employee ID | [ ] |  |  |
| `employee_id` | `varchar2` | Employee ID | [ ] |  |  |
| `employee_name` | `varchar2` | Employee Name | [ ] |  |  |
| `employee_person_id` | `varchar2` | Employee Person ID | [ ] |  | Added in order to comply with the original sales/sales responsible_employee response |
| `employee_tariff` | `double` | Employee Tariff | [ ] |  |  |
| `id` | `varchar2` | ID | [ ] |  |  |
| `invoice_id` | `varchar2` | Invoice ID | [ ] |  | See /invoices/invoice |
| `invoice_status` | `varchar2` | Invoice Status | [ ] |  |  |
| `invoiceline_id` | `varchar2` | Invoice Line ID | [ ] |  | See /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` | Project Name | [ ] |  |  |
| `project_organization_id` | `varchar2` | Project Organisation ID | [ ] |  |  |
| `project_organization_name` | `varchar2` | Project Organisation Name | [ ] |  |  |
| `project_organization_relation_number` | `varchar2` | itgen_spe_project_organization_relation_number | [ ] |  |  |
| `project_person_full_name` | `varchar2` | Project Person Full Name | [ ] |  |  |
| `project_person_id` | `varchar2` | Project Person ID | [ ] |  |  |
| `project_person_relation_number` | `varchar2` | itgen_spe_project_person_relation_number | [ ] |  |  |
| `project_project_manager_amount` | `double` | Project Manager Amount | [ ] |  |  |
| `project_project_manager_declarable` | `varchar2` | Project Manager Declarable | [ ] |  |  |
| `project_project_manager_employee_id` | `varchar2` | Project Manager Employee ID | [ ] |  |  |
| `project_project_manager_id` | `varchar2` | Project Manager ID | [ ] |  |  |
| `project_project_manager_name` | `varchar2` | Project Manager Name | [ ] |  |  |
| `project_project_manager_person_id` | `varchar2` | Project Manager Person ID | [ ] |  | Added in order to comply with the original sales/sales responsible_employee response |
| `project_project_manager_tariff` | `double` | Project Manager Tariff | [ ] |  |  |
| `project_project_number` | `varchar2` | Project Number | [ ] |  |  |
| `related_hours_id` | `varchar2` | itgen_spe_related_hours_id | [ ] |  |  |
| `source` | `varchar2` | Source | [ ] |  |  |
| `start_date` | `varchar2` | Start Date | [ ] |  |  |
| `tariff` | `double` | Tariff | [ ] |  |  |
| `type_billable` | `double` | Type Billable | [ ] |  |  |
| `type_blocked` | `char` | Type Blocked | [ ] |  |  |
| `type_color` | `varchar2` | Type Colour | [ ] |  |  |
| `type_id` | `varchar2` | Type ID | [ ] |  |  |
| `type_label` | `varchar2` | Type Label | [ ] |  |  |
| `type_tariff` | `double` | Type Tariff | [ ] |  |  |
| `type_type` | `varchar2` | Type | [ ] |  |  |
| `type_vatclass_code` | `varchar2` | Type VAT Class Code | [ ] |  |  |
| `type_vatclass_id` | `varchar2` | Type VAT Class ID | [ ] |  |  |
| `type_vatclass_label` | `varchar2` | Type VAT Class Label | [ ] |  |  |
| `type_vatclass_name` | `varchar2` | Type VAT Class Name | [ ] |  |  |
| `type_vatclass_percentage` | `double` | Type VAT Class Percentage | [ ] |  |  |
| `updated_at` | `varchar2` | Updated at | [ ] |  |  |
| `vatclass_code` | `varchar2` | VAT Class Code | [ ] |  |  |
| `vatclass_id` | `varchar2` | VAT Class ID | [ ] |  |  |
| `vatclass_label` | `varchar2` | VAT Class Label | [ ] |  |  |
| `vatclass_name` | `varchar2` | VAT Class Name | [ ] |  |  |
| `vatclass_percentage` | `double` | VAT Class Percentage | [ ] |  |  |



## Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver:

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

