invantive documentation
Invantive Support ForumsLog In / Sign Up

MilestoneCustomFieldValues: Teamleader Focus Milestone Custom Field Values

read only

  • Catalog: Teamleader
  • Schema: V2Flat
  • Label: Milestone 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 MilestoneCustomFieldValues 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'.
mfe_definition_id varchar2 Definition ID filters on the platform, writable
mfe_definition_type varchar2 Definition Type filters on the platform, writable Type of the custom field definition.
mfe_milestone_id varchar2 Record ID filters on the platform, writable ID of the milestone for which these custom field values provide additional information.
mfe_value_as_array varchar2 Array Value filters on the platform, writable
mfe_value_as_boolean char Boolean Value filters on the platform, writable
mfe_value_as_number decimal Numeric Value filters on the platform, writable
mfe_value_as_string varchar2 Text Value filters on the platform, writable
mfe_value_object_id varchar2 ID of Undefined Type filters on the platform, writable
mfe_value_object_type varchar2 Value of Undefined Type filters on the platform, writable
mse_actuals_billable_amount_amount decimal Actuals Billable Amount Amount filters on the platform, writable
mse_actuals_billable_amount_currency varchar2 Actuals Billable Amount Currency filters on the platform, writable
mse_actuals_costs_amount decimal Actuals Costs Amount filters on the platform, writable
mse_actuals_costs_currency varchar2 Actuals Costs Currency filters on the platform, writable
mse_actuals_result_amount decimal Actuals Result Amount filters on the platform, writable
mse_actuals_result_currency varchar2 Actuals Result Currency filters on the platform, writable
mse_budget_allocated_amount decimal Budget Allocated Amount filters on the platform, writable
mse_budget_allocated_currency varchar2 Budget Allocated Currency filters on the platform, writable
mse_budget_forecasted_amount decimal Budget Forecasted Amount filters on the platform, writable
mse_budget_forecasted_currency varchar2 Budget Forecasted Currency filters on the platform, writable
mse_budget_provided_amount decimal Budget Provided Amount filters on the platform, writable
mse_budget_provided_currency varchar2 Budget Provided Currency filters on the platform, writable
mse_budget_remaining_amount decimal Budget Remaining Amount filters on the platform, writable
mse_budget_remaining_currency varchar2 Budget Remaining Currency filters on the platform, writable
mse_budget_spent_amount decimal Budget Spent Amount filters on the platform, writable
mse_budget_spent_currency varchar2 Budget Spent Currency filters on the platform, writable
mse_c_strategisch char itgen_teamleader_c_strategisch filters on the platform, writable
mse_dependency_for_id varchar2 Dependency for ID filters on the platform, writable
mse_dependency_for_type varchar2 Dependency for Type filters on the platform, writable
mse_depends_on_id varchar2 Depends on ID filters on the platform, writable
mse_depends_on_type varchar2 Depends on Type filters on the platform, writable
mse_due_on datetime Due on filters on the platform, writable
mse_id varchar2 ID filters on the platform, writable
mse_invoicing_method varchar2 Invoicing Method filters on the platform, writable
mse_name varchar2 Name filters on the platform, writable
mse_project_id varchar2 Project ID filters on the platform, writable
mse_project_type varchar2 Project Type filters on the platform, writable
mse_responsible_user_id varchar2 Responsible User ID filters on the platform, writable
mse_responsible_user_type varchar2 Responsible User Type filters on the platform, writable
mse_starts_on datetime Starts on filters on the platform, writable
mse_status varchar2 Status filters on the platform, writable

Release Notes

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