Please enable JavaScript to view this site.

Error itgendoc001X

xMsg javascript has not been loaded.

Teamleader API Data Model

Navigation: Schema: V1Flat > Tables

V1ToV2Milestones

Contents Previous Home Next More

Catalog: Teamleader

Schema: V1Flat

This is a read-only view. The Teamleader API may not support changing the data or the Invantive SQL driver for Teamleader does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Teamleader API.

View Columns

The columns of the view V1ToV2Milestones are shown below. Each column has an SQL data type.

Name

Data Type

Label

Required

Documentation

billing_type

string

Billing Type

 

budget

double

Budget

 

closed

boolean

Closed

 

due_date

datetime

Due Date

 

id

int32

ID

 

id_v2

guid

ID (V2)

 

project_id

int32

ID

 

project_phase

string

Phase

 

project_start_date

datetime

Start Date

 

project_start_date_formatted

string(20)

Start Date (Formatted)

 

project_title

string

Title

 

responsible_user_id

int32

Responsible User ID

 

tasks_time_overrun_minutes

int32

Tasks Time Overrun (Minutes)

 

tasks_time_remaining_minutes

int32

Tasks Time Remaining (Minutes)

 

time_tracked_minutes

int32

Time Tracked (Minutes)

 

title

string

Title

 

 

12-12-2020 19:52 Version 20.1.301-BETA+3023