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_ |
varchar2 |
Approval Status Description | |||
approvalstatus_ |
varchar2 |
Approval Status ID | |||
approvalstatus_ |
varchar2 |
Approval Status Label | |||
created_ |
varchar2 |
Created at | |||
employee_ |
double |
Employee Amount | |||
employee_ |
varchar2 |
Employee Declarable | |||
employee_ |
varchar2 |
Employee ID | |||
employee_ |
varchar2 |
Employee ID | |||
employee_ |
varchar2 |
Employee Name | |||
employee_ |
varchar2 |
Employee Person ID | Added in order to comply with the original sales/sales responsible_employee response | ||
employee_ |
double |
Employee Tariff | |||
id |
varchar2 |
ID | |||
invoice_ |
varchar2 |
Invoice ID | See /invoices/invoice | ||
invoice_ |
varchar2 |
Invoice Status | |||
invoiceline_ |
varchar2 |
Invoice Line ID | See /invoices/invoice | ||
mileage |
double |
Mileage | |||
note |
varchar2 |
Note | |||
project_ |
char |
itgen_spe_project_has_register_mileage_enabled | |||
project_ |
varchar2 |
Project ID | |||
project_ |
varchar2 |
Project Name | |||
project_ |
varchar2 |
Project Organisation ID | |||
project_ |
varchar2 |
Project Organisation Name | |||
project_ |
varchar2 |
itgen_spe_project_organization_relation_number | |||
project_ |
varchar2 |
Project Person Full Name | |||
project_ |
varchar2 |
Project Person ID | |||
project_ |
varchar2 |
itgen_spe_project_person_relation_number | |||
project_ |
double |
Project Manager Amount | |||
project_ |
varchar2 |
Project Manager Declarable | |||
project_ |
varchar2 |
Project Manager Employee ID | |||
project_ |
varchar2 |
Project Manager ID | |||
project_ |
varchar2 |
Project Manager Name | |||
project_ |
varchar2 |
Project Manager Person ID | Added in order to comply with the original sales/sales responsible_employee response | ||
project_ |
double |
Project Manager Tariff | |||
project_ |
varchar2 |
Project Number | |||
related_ |
varchar2 |
itgen_spe_related_hours_id | |||
source |
varchar2 |
Source | |||
start_ |
varchar2 |
Start Date | |||
tariff |
double |
Tariff | |||
type_ |
double |
Type Billable | |||
type_ |
char |
Type Blocked | |||
type_ |
varchar2 |
Type Colour | |||
type_ |
varchar2 |
Type ID | |||
type_ |
varchar2 |
Type Label | |||
type_ |
double |
Type Tariff | |||
type_ |
varchar2 |
Type | |||
type_ |
varchar2 |
Type VAT Class Code | |||
type_ |
varchar2 |
Type VAT Class ID | |||
type_ |
varchar2 |
Type VAT Class Label | |||
type_ |
varchar2 |
Type VAT Class Name | |||
type_ |
double |
Type VAT Class Percentage | |||
updated_ |
varchar2 |
Updated at | |||
vatclass_ |
varchar2 |
VAT Class Code | |||
vatclass_ |
varchar2 |
VAT Class ID | |||
vatclass_ |
varchar2 |
VAT Class Label | |||
vatclass_ |
varchar2 |
VAT Class Name | |||
vatclass_ |
double |
VAT Class Percentage |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: