Please enable JavaScript to view this site.

Error itgendoc001X

xMsg javascript has not been loaded.

Teamleader API Data Model

Navigation: Schema: V2 > Tables

Projects: Teamleader Projects

Contents Previous Home Next More

Catalog: Teamleader

Schema: V2

Primary Keys: id

Label: Projects

This is a read-only table. 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.

Select Teamleader API URL: projects.list

Insert Teamleader API URL: projects.list

Update Teamleader API URL: projects.list

Delete Teamleader API URL: projects.list

Field Selection Method: NotRequired

Table Columns

The columns of the table Projects are shown below. Each column has an SQL data type.

Name

Data Type

Label

Required

Documentation

actuals_billable_amount_amount

decimal

 

 

actuals_billable_amount_currency

string

 

 

actuals_costs_amount

string

 

 

actuals_costs_currency

string

 

 

actuals_profit_percentage

string

 

 

actuals_result_amount

string

 

 

actuals_result_currency

string

 

 

budget_allocated_amount

decimal

 

 

budget_allocated_currency

string

 

 

budget_forecasted_amount

decimal

 

 

budget_forecasted_currency

string

 

 

budget_provided_amount

decimal

 

 

budget_provided_currency

string

 

 

budget_remaining_amount

decimal

 

 

budget_remaining_currency

string

 

 

budget_spent_materials_amount

decimal

 

 

budget_spent_materials_currency

string

 

 

budget_spent_time_amount

decimal

 

 

budget_spent_time_currency

string

 

 

budget_spent_total_amount

decimal

 

 

budget_spent_total_currency

string

 

 

customer_id

string

Customer ID

 

customer_type

string

Customer Type

 

description

string

Description

 

due_on

datetime

Due on

 

id

string

ID

 

reference

string

Reference

 

source_id

string

Source ID

 

source_type

string

Source Type

 

starts_on

datetime

Starts on

 

status

string

Status

 

title

string

Title

 

 

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