invantive documentation
Invantive Support ForumsLog In / Sign Up

ProjectNotesV2All: Teamleader Focus Project Notes

read only

  • Catalog: Teamleader
  • Schema: V2Flat
  • Label: Project Notes

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 ProjectNotesV2All 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
content varchar2 Content filters on the platform, writable
id varchar2 ID filters on the platform, writable
project_amount_billed_amount decimal Amount Billed Amount filters on the platform, writable
project_amount_billed_currency varchar2 Amount Billed Currency filters on the platform, writable
project_amount_paid_amount decimal Amount Paid Amount filters on the platform, writable
project_amount_paid_currency varchar2 Amount Paid Currency filters on the platform, writable
project_billing_method varchar2 Billing Method filters on the platform, writable
project_c_betaling_project varchar2 itgen_teamleader_c_betaling_project filters on the platform, writable
project_c_budget_volgende_fase varchar2 itgen_teamleader_c_budget_volgende_fase filters on the platform, writable
project_c_dealnummer varchar2 itgen_teamleader_c_dealnummer filters on the platform, writable
project_c_fase varchar2 itgen_teamleader_c_fase filters on the platform, writable
project_calculated_price_amount decimal Calculated Price Amount filters on the platform, writable
project_calculated_price_currency varchar2 Calculated Price Currency filters on the platform, writable
project_color varchar2 Colour filters on the platform, writable
project_company_entity_id varchar2 Company Entity ID filters on the platform, writable
project_company_entity_type varchar2 Company Entity Type filters on the platform, writable
project_cost_amount decimal Cost Amount filters on the platform, writable
project_cost_currency varchar2 Cost Currency filters on the platform, writable
project_description varchar2 Description filters on the platform, writable
project_end_date datetime End Date filters on the platform, writable
project_external_budget_amount decimal External Budget Amount filters on the platform, writable
project_external_budget_currency varchar2 External Budget Currency filters on the platform, writable
project_external_budget_spent_amount decimal External Budget Spent Amount filters on the platform, writable
project_external_budget_spent_currency varchar2 External Budget Spent Currency filters on the platform, writable
project_fixed_amount_billed_amount decimal Fixed Amount Billed Amount filters on the platform, writable
project_fixed_amount_billed_currency varchar2 Fixed Amount Billed Currency filters on the platform, writable
project_fixed_price_amount decimal Fixed Price Amount filters on the platform, writable
project_fixed_price_currency varchar2 Fixed Price Currency filters on the platform, writable
project_id varchar2 ID filters on the platform, writable
project_internal_budget_amount decimal Internal Budget Amount filters on the platform, writable
project_internal_budget_currency varchar2 Internal Budget Currency filters on the platform, writable
project_margin_amount decimal Margin Amount filters on the platform, writable
project_margin_currency varchar2 Margin Currency filters on the platform, writable
project_margin_percentage decimal Margin Percentage filters on the platform, writable Null if the user does not have access to "Costs on projects".
project_price_amount decimal Price Amount filters on the platform, writable
project_price_currency varchar2 Price Currency filters on the platform, writable
project_project_key int32 Project Key filters on the platform, writable Positive, sequential integer representing the index of the project for the account
project_start_date datetime Start Date filters on the platform, writable
project_status varchar2 Status filters on the platform, writable
project_time_budget_unit varchar2 Time Budget Unit filters on the platform, writable
project_time_budget_value decimal Time Budget Value filters on the platform, writable
project_time_tracked_unit varchar2 Time Tracked Unit filters on the platform, writable
project_time_tracked_value decimal Time Tracked Value filters on the platform, writable
project_title varchar2 Title filters on the platform, writable
subject_id varchar2 Subject ID filters on the platform, writable
subject_type varchar2 Subject Type filters on the platform, writable

Release Notes

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