invantive documentation
Invantive Support ForumsLog In / Sign Up

ProjectCustomFieldValues: Teamleader Focus Project Custom Field Values

read only

  • Catalog: Teamleader
  • Schema: V2Flat
  • Label: Project Custom Field Values

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 ProjectCustomFieldValues 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
cfd_group varchar2 Group filters on the platform, writable, cfd_group Group for grouping multiple custom fields in the web frontend.
cfd_label varchar2 Label filters on the platform, writable, cfd_label Label for display with the value in the web frontend.
cfd_required char Required filters on the platform, writable, cfd_required Whether a value must be provided.
cfd_type varchar2 Type filters on the platform, writable, cfd_type Type of the values stored, such as 'auto_increment', 'integer', 'contact', 'number' or 'multi_line'.
pfe_definition_id varchar2 Definition ID filters on the platform, writable
pfe_definition_type varchar2 Definition Type filters on the platform, writable Type of the custom field definition.
pfe_project_id varchar2 Record ID filters on the platform, writable ID of the project for which these custom field values provide additional information.
pfe_value_as_array varchar2 Array Value filters on the platform, writable
pfe_value_as_boolean char Boolean Value filters on the platform, writable
pfe_value_as_number decimal Numeric Value filters on the platform, writable
pfe_value_as_string varchar2 Text Value filters on the platform, writable
pfe_value_object_id varchar2 ID of Undefined Type filters on the platform, writable
pfe_value_object_type varchar2 Value of Undefined Type filters on the platform, writable
pjt_actuals_billable_amount_amount decimal Actuals Billable Amount Amount filters on the platform, writable
pjt_actuals_billable_amount_currency varchar2 Actuals Billable Amount Currency filters on the platform, writable
pjt_actuals_costs_amount decimal Actuals Costs Amount filters on the platform, writable
pjt_actuals_costs_currency varchar2 Actuals Costs Currency filters on the platform, writable
pjt_actuals_profit_percentage decimal Actuals Profit Percentage filters on the platform, writable
pjt_actuals_result_amount decimal Actuals Result Amount filters on the platform, writable
pjt_actuals_result_currency varchar2 Actuals Result Currency filters on the platform, writable
pjt_budget_allocated_amount decimal Budget Allocated Amount filters on the platform, writable
pjt_budget_allocated_currency varchar2 Budget Allocated Currency filters on the platform, writable
pjt_budget_forecasted_amount decimal Budget Forecasted Amount filters on the platform, writable
pjt_budget_forecasted_currency varchar2 Budget Forecasted Currency filters on the platform, writable
pjt_budget_provided_amount decimal Budget Provided Amount filters on the platform, writable
pjt_budget_provided_currency varchar2 Budget Provided Currency filters on the platform, writable
pjt_budget_remaining_amount decimal Budget Remaining Amount filters on the platform, writable
pjt_budget_remaining_currency varchar2 Budget Remaining Currency filters on the platform, writable
pjt_budget_spent_materials_amount decimal Budget Spent Materials Amount filters on the platform, writable
pjt_budget_spent_materials_currency varchar2 Budget Spent Materials Currency filters on the platform, writable
pjt_budget_spent_time_amount decimal Budget Spent Time Amount filters on the platform, writable
pjt_budget_spent_time_currency varchar2 Budget Spent Time Currency filters on the platform, writable
pjt_budget_spent_total_amount decimal Budget Spent Total Amount filters on the platform, writable
pjt_budget_spent_total_currency varchar2 Budget Spent Total Currency filters on the platform, writable
pjt_c_betaling_project varchar2 itgen_teamleader_c_betaling_project filters on the platform, writable
pjt_c_budget_volgende_fase varchar2 itgen_teamleader_c_budget_volgende_fase filters on the platform, writable
pjt_c_dealnummer varchar2 itgen_teamleader_c_dealnummer filters on the platform, writable
pjt_c_fase varchar2 itgen_teamleader_c_fase filters on the platform, writable
pjt_created_at datetime Created at filters on the platform, writable
pjt_customer_id varchar2 Customer ID filters on the platform, writable
pjt_customer_type varchar2 Customer Type filters on the platform, writable
pjt_description varchar2 Description filters on the platform, writable
pjt_due_on datetime Due on filters on the platform, writable
pjt_id varchar2 ID filters on the platform, writable
pjt_reference varchar2 Reference filters on the platform, writable
pjt_source_id varchar2 Source ID filters on the platform, writable
pjt_source_type varchar2 Source Type filters on the platform, writable
pjt_starts_on datetime Starts on filters on the platform, writable
pjt_status varchar2 Status filters on the platform, writable
pjt_title varchar2 Title filters on the platform, writable

Release Notes

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