Please enable JavaScript to view this site.

Error itgendoc001X

xMsg javascript has not been loaded.

Teamleader API Data Model

Navigation: Schema: V1Flat > Tables

ProjectsAll: Teamleader Projects

Contents Previous Home Next More

Catalog: Teamleader

Schema: V1Flat

Label: Projects

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 ProjectsAll are shown below. Each column has an SQL data type.

Name

Data Type

Label

Required

Documentation

budget_indication

double

Budget Indication

 

budget_spent_external

double

Budget Spent External

 

budget_spent_internal

double

Budget Spent Internal

 

c_betaling_project_id

int32

 

 

c_betaling_project_value

string

 

 

c_budget_volgende_fase

string

 

 

c_dealnummer

string

 

 

c_fase_id

int32

 

 

c_fase_value

string

 

 

contact_or_company

string

Contact or Company

 

contact_or_company_id

int32

Contact or Company ID

 

description_html

string

Description (HTML)

 

id

int32

ID

 

phase

string

Phase

 

project_nr

int32

Project Number

 

start_date

datetime

Start Date

 

start_date_formatted

string(20)

Start Date (Formatted)

 

title

string

Title

 

 

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