invantive documentation
Invantive Support ForumsLog In / Sign Up

TaskAssigneesV2All: Teamleader Focus Task Assignees

read only

  • Catalog: Teamleader
  • Schema: V2Flat
  • Label: Task Assignees

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 TaskAssigneesV2All 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
id varchar2 ID filters on the platform, writable
task_amount_billed_amount decimal Amount Billed Amount filters on the platform, writable
task_amount_billed_currency varchar2 Amount Billed Currency filters on the platform, writable
task_billing_method varchar2 Billing Method filters on the platform, writable
task_billing_status varchar2 Billing Status filters on the platform, writable
task_c_autoincrement int32 itgen_teamleader_c_autoincrement filters on the platform, writable
task_c_company guid itgen_teamleader_c_company filters on the platform, writable
task_c_date datetime itgen_teamleader_c_date filters on the platform, writable
task_c_emailaddress varchar2 itgen_teamleader_c_emailaddress filters on the platform, writable
task_c_integer int32 itgen_teamleader_c_integer filters on the platform, writable
task_c_maximale_waarde decimal itgen_teamleader_c_maximale_waarde filters on the platform, writable
task_c_number decimal itgen_teamleader_c_number filters on the platform, writable
task_c_phonenumber varchar2 itgen_teamleader_c_phonenumber filters on the platform, writable
task_c_singlelinetext varchar2 itgen_teamleader_c_singlelinetext filters on the platform, writable
task_c_singleselection varchar2 itgen_teamleader_c_singleselection filters on the platform, writable
task_c_url varchar2 itgen_teamleader_c_url filters on the platform, writable
task_c_yesno char itgen_teamleader_c_yesno filters on the platform, writable
task_cost_amount decimal Cost Amount filters on the platform, writable
task_cost_currency varchar2 Cost Currency filters on the platform, writable
task_custom_rate_amount decimal Custom Rate Amount filters on the platform, writable
task_custom_rate_currency varchar2 Custom Rate Currency filters on the platform, writable
task_end_date datetime End Date filters on the platform, writable
task_external_budget_amount decimal External Budget Amount filters on the platform, writable
task_external_budget_currency varchar2 External Budget Currency filters on the platform, writable
task_external_budget_spent_amount decimal External Budget Spent Amount filters on the platform, writable
task_external_budget_spent_currency varchar2 External Budget Spent Currency filters on the platform, writable
task_fixed_price_amount decimal Fixed Price Amount filters on the platform, writable
task_fixed_price_currency varchar2 Fixed Price Currency filters on the platform, writable
task_group_id varchar2 Group ID filters on the platform, writable
task_group_type varchar2 Group Type filters on the platform, writable
task_id varchar2 Task ID filters on the platform, writable
task_id2 varchar2 ID filters on the platform, writable
task_internal_budget_amount decimal Internal Budget Amount filters on the platform, writable
task_internal_budget_currency varchar2 Internal Budget Currency filters on the platform, writable
task_margin_amount decimal Margin Amount filters on the platform, writable
task_margin_currency varchar2 Margin Currency filters on the platform, writable
task_margin_percentage decimal Margin Percentage filters on the platform, writable Null if the user does not have access to "Costs on projects".
task_price_amount decimal Price Amount filters on the platform, writable
task_price_currency varchar2 Price Currency filters on the platform, writable
task_project_id varchar2 Project ID filters on the platform, writable
task_project_type varchar2 Project Type filters on the platform, writable
task_start_date datetime Start Date filters on the platform, writable
task_status varchar2 itgen_teamleader_task_status filters on the platform, writable
task_status2 varchar2 Status filters on the platform, writable
task_task_type_id varchar2 itgen_teamleader_task_type_id filters on the platform, writable
task_task_type_type varchar2 itgen_teamleader_task_type_type filters on the platform, writable
task_time_estimated_unit varchar2 Time Estimated Unit filters on the platform, writable
task_time_estimated_value decimal Time Estimated Value filters on the platform, writable
task_time_tracked_unit varchar2 Time Tracked Unit filters on the platform, writable
task_time_tracked_value decimal Time Tracked Value filters on the platform, writable
task_title varchar2 itgen_teamleader_task_title filters on the platform, writable
task_title2 varchar2 Title filters on the platform, writable
task_unit_cost_amount decimal Unit Cost Amount filters on the platform, writable
task_unit_cost_currency varchar2 Unit Cost Currency filters on the platform, writable
task_unit_price_amount decimal Unit Price Amount filters on the platform, writable
task_unit_price_currency varchar2 Unit Price Currency filters on the platform, writable
task_work_type_id varchar2 Work Type ID filters on the platform, writable
task_work_type_type varchar2 Work Type Type filters on the platform, writable
type varchar2 Type filters on the platform, writable

Release Notes

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