# Mileages: Simplicate Mileages Fetches all mileages Can retrieve and modify data using insert, update and delete. - Catalog: `Simplicate` - Schema: `Mileage` - Primary Keys: `id` - Label: Mileages ## Table Columns The columns of the table `Mileages` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `approvalstatus_description` | `string` | Approval Status Description | ☐ | | | `approvalstatus_id` | `string` | Approval Status ID | ☐ | | | `approvalstatus_label` | `string` | Approval Status Label | ☐ | | | `created_at` | `string` | Created On | ☐ | | | `employee_amount` | `float` | Employee Amount | ☐ | | | `employee_declarable` | `string` | Billable Employee | ☐ | | | `employee_employee_id` | `string` | Employee ID | ☐ | | | `employee_id` | `string` | Employee ID | ☐ | | | `employee_name` | `string` | Employee Name | ☐ | | | `employee_person_id` | `string` | Employee Person ID | ☐ | Added in order to comply with the original sales/sales responsible_employee response | | `employee_tariff` | `float` | Employee Rate | ☐ | | | `id` | `string` | ID | ☐ | | | `invoice_id` | `string` | Invoice ID | ☐ | See /invoices/invoice | | `invoice_status` | `string` | Invoice Status | ☐ | | | `invoiceline_id` | `string` | Invoice Line ID | ☐ | See /invoices/invoice | | `mileage` | `float` | Mileage | ☐ | | | `note` | `string` | Note | ☐ | | | `project_has_register_mileage_enabled` | `boolean` | | ☐ | | | `project_id` | `string` | Project ID | ☐ | | | `project_name` | `string` | Project Name | ☐ | | | `project_organization_id` | `string` | Project Organisation ID | ☐ | | | `project_organization_name` | `string` | Project Organisation Name | ☐ | | | `project_organization_relation_number` | `string` | | ☐ | | | `project_person_full_name` | `string` | Project Person Full Name | ☐ | | | `project_person_id` | `string` | Project Person ID | ☐ | | | `project_person_relation_number` | `string` | | ☐ | | | `project_project_manager_amount` | `float` | Project Manager Amount | ☐ | | | `project_project_manager_declarable` | `string` | Project Manager Billable | ☐ | | | `project_project_manager_employee_id` | `string` | Project Manager Employee ID | ☐ | | | `project_project_manager_id` | `string` | Project Manager ID | ☐ | | | `project_project_manager_name` | `string` | Project Manager Name | ☐ | | | `project_project_manager_person_id` | `string` | Project Manager Person ID | ☐ | Added in order to comply with the original sales/sales responsible_employee response | | `project_project_manager_tariff` | `float` | Project Manager Rate | ☐ | | | `project_project_number` | `string` | Project Number | ☐ | | | `related_hours_id` | `string` | | ☐ | | | `source` | `string` | Source | ☐ | | | `start_date` | `string` | Start Date | ☐ | | | `tariff` | `float` | Rate | ☐ | | | `type_billable` | `float` | Type Billable | ☐ | | | `type_blocked` | `boolean` | Type Blocked | ☐ | | | `type_color` | `string` | Type Colour | ☐ | | | `type_id` | `string` | Type ID | ☐ | | | `type_label` | `string` | Type Label | ☐ | | | `type_tariff` | `float` | Type Rate | ☐ | | | `type_type` | `string` | Type | ☐ | | | `type_vatclass_code` | `string` | Type VAT Class Code | ☐ | | | `type_vatclass_id` | `string` | Type VAT Class ID | ☐ | | | `type_vatclass_label` | `string` | Type VAT Class Label | ☐ | | | `type_vatclass_name` | `string` | Type VAT Class Name | ☐ | | | `type_vatclass_percentage` | `float` | Type VAT Class Percentage | ☐ | | | `updated_at` | `string` | Updated On | ☐ | | | `vatclass_code` | `string` | VAT Class Code | ☐ | | | `vatclass_id` | `string` | VAT Class ID | ☐ | | | `vatclass_label` | `string` | VAT Class Label | ☐ | | | `vatclass_name` | `string` | VAT Class Name | ☐ | | | `vatclass_percentage` | `float` | VAT Class Percentage | ☐ | |