invantive documentation
Invantive Support ForumsLog In / Sign Up

ProjectAssigneesV2All: Teamleader Focus Project Assignees

read only

  • Catalog: Teamleader
  • Schema: V2Flat
  • Label: Project 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 ProjectAssigneesV2All 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
project_id varchar2 Project ID filters on the platform, writable
project_status varchar2 Project Status filters on the platform, writable
project_title varchar2 Project Title 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_amount_paid_amount decimal Amount Paid Amount filters on the platform, writable
task_amount_paid_currency varchar2 Amount Paid Currency filters on the platform, writable
task_billing_method varchar2 Billing Method filters on the platform, writable
task_c_betaling_project varchar2 itgen_teamleader_c_betaling_project filters on the platform, writable
task_c_budget_volgende_fase varchar2 itgen_teamleader_c_budget_volgende_fase filters on the platform, writable
task_c_dealnummer varchar2 itgen_teamleader_c_dealnummer filters on the platform, writable
task_c_fase varchar2 itgen_teamleader_c_fase filters on the platform, writable
task_calculated_price_amount decimal Calculated Price Amount filters on the platform, writable
task_calculated_price_currency varchar2 Calculated Price Currency filters on the platform, writable
task_color varchar2 Colour filters on the platform, writable
task_company_entity_id varchar2 Company Entity ID filters on the platform, writable
task_company_entity_type varchar2 Company Entity Type 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_description varchar2 Description 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_amount_billed_amount decimal Fixed Amount Billed Amount filters on the platform, writable
task_fixed_amount_billed_currency varchar2 Fixed Amount Billed 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_id 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_key int32 Project Key filters on the platform, writable Positive, sequential integer representing the index of the project for the account
task_start_date datetime Start Date filters on the platform, writable
task_status varchar2 Status filters on the platform, writable
task_time_budget_unit varchar2 Time Budget Unit filters on the platform, writable
task_time_budget_value decimal Time Budget 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 Title 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: