Please enable JavaScript to view this site.

Error itgendoc001X

xMsg javascript has not been loaded.

Teamleader API Data Model

Navigation: Schema: V1Flat > Tables

ProjectMilestones: Teamleader Project Milestones

Contents Previous Home Next More

Catalog: Teamleader

Schema: V1Flat

Label: Project Milestones

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 ProjectMilestones 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

☑

 

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