invantive documentation
Invantive Support ForumsLog In / Sign Up

DealCustomFieldValues: Teamleader Focus Deal Custom Field Values

read only

  • Catalog: Teamleader
  • Schema: V2Flat
  • Label: Deal 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 DealCustomFieldValues 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'.
del_c_omzetwaarde_volgens_methode_2 decimal itgen_teamleader_c_omzetwaarde_volgens_methode_2 filters on the platform, writable
del_c_success varchar2 itgen_teamleader_c_success filters on the platform, writable
del_closed_at datetime Closed at filters on the platform, writable
del_created_at datetime Created at filters on the platform, writable
del_currency_exchange_rate_from varchar2 Currency Exchange Rate From filters on the platform, writable
del_currency_exchange_rate_rate decimal Currency Exchange Rate filters on the platform, writable
del_currency_exchange_rate_to varchar2 Currency Exchange Rate To filters on the platform, writable
del_current_phase_id varchar2 Current Phase ID filters on the platform, writable
del_current_phase_type varchar2 Current Phase Type filters on the platform, writable
del_department_id varchar2 Department ID filters on the platform, writable
del_department_type varchar2 Department Type filters on the platform, writable
del_estimated_closing_date datetime Estimated Closing Date filters on the platform, writable
del_estimated_probability decimal Estimated Probability filters on the platform, writable
del_estimated_value_amount decimal Estimated Value Amount filters on the platform, writable
del_estimated_value_currency varchar2 Currency of Estimated Value Amount filters on the platform, writable
del_id varchar2 ID filters on the platform, writable
del_lead_contact_person_id varchar2 Lead Contact Person ID filters on the platform, writable
del_lead_contact_person_type varchar2 Lead Contact Person Type filters on the platform, writable
del_lead_customer_id varchar2 Lead Customer ID filters on the platform, writable
del_lead_customer_type varchar2 Lead Customer Type filters on the platform, writable
del_lost_reason_id varchar2 Lost Reason ID filters on the platform, writable
del_lost_reason_remark varchar2 Lost Reason Remark filters on the platform, writable
del_lost_reason_type varchar2 Lost Reason Type filters on the platform, writable
del_pipeline_id varchar2 Pipeline ID filters on the platform, writable
del_pipeline_type varchar2 Pipeline Type filters on the platform, writable
del_purchase_order_number varchar2 Purchase Order Number filters on the platform, writable
del_reference varchar2 Reference filters on the platform, writable
del_responsible_user_id varchar2 Responsible User ID filters on the platform, writable
del_responsible_user_type varchar2 Responsible User Type filters on the platform, writable
del_source_id varchar2 Source ID filters on the platform, writable
del_source_type varchar2 Source Type filters on the platform, writable
del_status varchar2 Status filters on the platform, writable
del_summary varchar2 Summary filters on the platform, writable
del_title varchar2(120) Title filters on the platform, writable
del_updated_at datetime Updated At filters on the platform, writable
del_web_url varchar2 Web (URL) filters on the platform, writable
del_weighted_value_amount decimal Weighted Value Amount filters on the platform, writable
del_weighted_value_currency varchar2 Weighted Value Currency filters on the platform, writable
dfe_deal_id varchar2 Record ID filters on the platform, writable ID of the deal for which these custom field values provide additional information.
dfe_definition_id varchar2 Definition ID filters on the platform, writable
dfe_definition_type varchar2 Definition Type filters on the platform, writable Type of the custom field definition.
dfe_value_as_array varchar2 Array Value filters on the platform, writable
dfe_value_as_boolean char Boolean Value filters on the platform, writable
dfe_value_as_number decimal Numeric Value filters on the platform, writable
dfe_value_as_string varchar2 Text Value filters on the platform, writable
dfe_value_object_id varchar2 ID of Undefined Type filters on the platform, writable
dfe_value_object_type varchar2 Value of Undefined Type filters on the platform, writable

Release Notes

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