Please enable JavaScript to view this site.

Error itgendoc001X

xMsg javascript has not been loaded.

Simplicate API Data Model

Navigation: Schema: Mileage > Tables

Mileages: Simplicate Mileages

 Contents Previous Home Next More

Fetches all mileages

Catalog: Simplicate

Schema: Mileage

Label: Mileages

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

Select Simplicate API URL: /mileage/mileage

Insert Simplicate API URL: /mileage/mileage

Update Simplicate API URL: /mileage/mileage

Delete Simplicate API URL: /mileage/mileage

Field Selection Method: NotRequired

Base Path: data[*]

Select Simplicate API Operation: get /mileage/mileage

Insert Simplicate API Operation: post /mileage/mileage

Update Simplicate API Operation: put /mileage/mileage/{id}

Delete Simplicate API Operation: delete /mileage/mileage/{id}

Table Function Columns

The columns of the table function 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 or update.

Name

Data Type

Label

Required

Documentation

approvalstatus_description

string

 

☐

 

approvalstatus_id

string

 

☐

 

approvalstatus_label

string

 

☐

 

created_at

string

Created at

☐

 

employee_amount

float

 

☐

 

employee_declarable

string

 

☐

 

employee_employee_id

string

 

☐

 

employee_id

string

Employee ID

☐

 

employee_name

string

 

☐

 

employee_person_id

string

 

☐

 

employee_tariff

float

 

☐

 

id

string

ID

☐

 

invoice_id

string

 

☐

See /invoices/invoice

invoice_status

string

 

☐

 

invoiceline_id

string

 

☐

See /invoices/invoice

note

string

Note

☐

 

project_id

string

Project ID

☐

 

project_name

string

 

☐

 

project_organization_id

string

 

☐

 

project_organization_name

string

 

☐

 

project_person_full_name

string

 

☐

 

project_person_id

string

 

☐

 

project_project_manager_amount

float

 

☐

 

project_project_manager_declarable

string

 

☐

 

project_project_manager_employee_id

string

 

☐

 

project_project_manager_id

string

 

☐

 

project_project_manager_name

string

 

☐

 

project_project_manager_person_id

string

 

☐

 

project_project_manager_tariff

float

 

☐

 

project_project_number

string

 

☐

 

project_separate_invoice_recipient_contact_id

string

 

☐

See 'linked_persons_contact' in /crm/organization, or 'linked_as_contact_to_organization' in /crm/person, or /crm/contactperson

project_separate_invoice_recipient_is_separate_invoice_recipient

boolean

 

☐

 

project_separate_invoice_recipient_organization_id

string

 

☐

See /crm/organization

project_separate_invoice_recipient_person_id

string

 

☐

See /crm/person

source

string

 

☐

 

start_date

string

Start Date

☐

 

tariff

float

 

☐

 

type_billable

float

 

☐

 

type_blocked

boolean

 

☐

 

type_color

string

 

☐

 

type_has_workflow

boolean

 

☐

 

type_id

string

 

☐

 

type_label

string

 

☐

 

type_tariff

float

 

☐

 

type_type

string

 

☐

 

type_vatclass_code

string

 

☐

 

type_vatclass_id

string

 

☐

 

type_vatclass_label

string

 

☐

 

type_vatclass_name

string

 

☐

 

type_vatclass_percentage

float

 

☐

 

updated_at

string

Updated at

☐

 

vatclass_code

string

 

☐

 

vatclass_id

string

 

☐

 

vatclass_label

string

 

☐

 

vatclass_name

string

 

☐

 

vatclass_percentage

float

 

☐

 

 

06-04-2021 14:59 Version 20.1.393-BETA+3152