invantive documentation
Invantive Support ForumsLog In / Sign Up

ProjectItems: Teamleader Focus Project Items

popular read only

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

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 ProjectItems 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
activity_type_id varchar2 Activity Type ID filters on the platform, writable
activity_type_type varchar2 Activity Type Type filters on the platform, writable
added_at datetime Added At filters on the platform, writable
billable_price_per_unit_amount decimal Billable Price Amount per Unit filters on the platform, writable
billable_price_per_unit_currency varchar2 Billable Price Currency per Unit filters on the platform, writable
description varchar2 Description filters on the platform, writable
id varchar2 ID filters on the platform, writable
internal_cost_per_unit decimal Internal Cost per Unit 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
occurred_at datetime Occurred at filters on the platform, writable
participant_id varchar2 Participant ID filters on the platform, writable
participant_type varchar2 Participant Type filters on the platform, writable
product_id varchar2 Product ID filters on the platform, writable
product_type varchar2 Product Type filters on the platform, writable
project_actuals_billable_amount_amount decimal Actuals Billable Amount Amount filters on the platform, writable
project_actuals_billable_amount_currency varchar2 Actuals Billable Amount Currency filters on the platform, writable
project_actuals_costs_amount decimal Actuals Costs Amount filters on the platform, writable
project_actuals_costs_currency varchar2 Actuals Costs Currency filters on the platform, writable
project_actuals_profit_percentage decimal Actuals Profit Percentage filters on the platform, writable
project_actuals_result_amount decimal Actuals Result Amount filters on the platform, writable
project_actuals_result_currency varchar2 Actuals Result Currency filters on the platform, writable
project_budget_allocated_amount decimal Budget Allocated Amount filters on the platform, writable
project_budget_allocated_currency varchar2 Budget Allocated Currency filters on the platform, writable
project_budget_forecasted_amount decimal Budget Forecasted Amount filters on the platform, writable
project_budget_forecasted_currency varchar2 Budget Forecasted Currency filters on the platform, writable
project_budget_provided_amount decimal Budget Provided Amount filters on the platform, writable
project_budget_provided_currency varchar2 Budget Provided Currency filters on the platform, writable
project_budget_remaining_amount decimal Budget Remaining Amount filters on the platform, writable
project_budget_remaining_currency varchar2 Budget Remaining Currency filters on the platform, writable
project_budget_spent_materials_amount decimal Budget Spent Materials Amount filters on the platform, writable
project_budget_spent_materials_currency varchar2 Budget Spent Materials Currency filters on the platform, writable
project_budget_spent_time_amount decimal Budget Spent Time Amount filters on the platform, writable
project_budget_spent_time_currency varchar2 Budget Spent Time Currency filters on the platform, writable
project_budget_spent_total_amount decimal Budget Spent Total Amount filters on the platform, writable
project_budget_spent_total_currency varchar2 Budget Spent Total Currency 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_created_at datetime Created at filters on the platform, writable
project_customer_id varchar2 Customer ID filters on the platform, writable
project_customer_type varchar2 Customer Type filters on the platform, writable
project_description varchar2 Description filters on the platform, writable
project_due_on datetime Due on filters on the platform, writable
project_id varchar2 ID filters on the platform, writable
project_reference varchar2 Reference filters on the platform, writable
project_source_id varchar2 Source ID filters on the platform, writable
project_source_type varchar2 Source Type filters on the platform, writable
project_starts_on datetime Starts on filters on the platform, writable
project_status varchar2 Status filters on the platform, writable
project_title varchar2 Title filters on the platform, writable
quantity decimal Quantity filters on the platform, writable
total_billable_price_amount decimal Total Billable Price Amount filters on the platform, writable
total_billable_price_currency varchar2 Total Billable Price Currency filters on the platform, writable
total_internal_cost decimal Total Internal Cost filters on the platform, writable
tracked_time varchar2 Tracked Time filters on the platform, writable
unit varchar2 Unit filters on the platform, writable
updated_at datetime Updated At filters on the platform, writable
worktype_id varchar2 Worktype ID filters on the platform, writable
worktype_type varchar2 Worktype Type filters on the platform, writable

Release Notes

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