invantive documentation
Invantive Support ForumsLog In / Sign Up

TasksAll: Teamleader Focus Tasks

read only

  • Catalog: Teamleader
  • Schema: V2Flat
  • Label: Tasks

Can only retrieve data.

Performance Characteristics

Characteristic Value
Average access latency (ms) 39

The result can be cached on the client.

Table Columns

The columns of the table TasksAll 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 and update.

Name Data Type Label Required Marks Documentation
added_at datetime Added At filters on the platform, writable
assignee_id varchar2 Assignee ID filters on the platform, writable
assignee_type varchar2 Assignee Type filters on the platform, writable
c_autoincrement int32 itgen_teamleader_c_autoincrement filters on the platform, writable
c_autoincrement2 int32 itgen_teamleader_c_autoincrement filters on the platform, writable
c_company guid itgen_teamleader_c_company filters on the platform, writable
c_company2 guid itgen_teamleader_c_company filters on the platform, writable
c_date datetime itgen_teamleader_c_date filters on the platform, writable
c_date2 datetime itgen_teamleader_c_date filters on the platform, writable
c_emailaddress varchar2 itgen_teamleader_c_emailaddress filters on the platform, writable
c_emailaddress2 varchar2 itgen_teamleader_c_emailaddress filters on the platform, writable
c_integer int32 itgen_teamleader_c_integer filters on the platform, writable
c_integer2 int32 itgen_teamleader_c_integer filters on the platform, writable
c_maximale_waarde decimal itgen_teamleader_c_maximale_waarde filters on the platform, writable
c_maximale_waarde2 decimal itgen_teamleader_c_maximale_waarde filters on the platform, writable
c_number decimal itgen_teamleader_c_number filters on the platform, writable
c_number2 decimal itgen_teamleader_c_number filters on the platform, writable
c_phonenumber varchar2 itgen_teamleader_c_phonenumber filters on the platform, writable
c_phonenumber2 varchar2 itgen_teamleader_c_phonenumber filters on the platform, writable
c_singlelinetext varchar2 itgen_teamleader_c_singlelinetext filters on the platform, writable
c_singlelinetext2 varchar2 itgen_teamleader_c_singlelinetext filters on the platform, writable
c_singleselection varchar2 itgen_teamleader_c_singleselection filters on the platform, writable
c_singleselection2 varchar2 itgen_teamleader_c_singleselection filters on the platform, writable
c_url varchar2 itgen_teamleader_c_url filters on the platform, writable
c_url2 varchar2 itgen_teamleader_c_url filters on the platform, writable
c_yesno char itgen_teamleader_c_yesno filters on the platform, writable
c_yesno2 char itgen_teamleader_c_yesno filters on the platform, writable
completed char Completed filters on the platform, writable
completed_at datetime Completed at filters on the platform, writable
customer_id varchar2 Customer ID filters on the platform, writable
customer_type varchar2 Customer Type filters on the platform, writable
deal_id varchar2 Deal ID filters on the platform, writable
deal_type varchar2 Deal Type filters on the platform, writable
description varchar2 Description filters on the platform, writable
due_on datetime Due on filters on the platform, writable
estimated_duration_unit varchar2 Estimated Duration Unit filters on the platform, writable
estimated_duration_value decimal Estimated Duration Value filters on the platform, writable
id varchar2 ID filters on the platform, writable
milestone_id varchar2 Milestone ID filters on the platform, writable
milestone_type varchar2 Milestone Type filters on the platform, writable
priority varchar2 Priority filters on the platform, writable
project_id varchar2 Project ID filters on the platform, writable
project_type varchar2 Project Type filters on the platform, writable
ticket_id varchar2 Ticket ID filters on the platform, writable
ticket_id2 varchar2 Ticket ID filters on the platform, writable
title varchar2 Title filters on the platform, writable
work_type_id varchar2 Work Type ID filters on the platform, writable
work_type_type varchar2 Work Type Type filters on the platform, writable

Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver: