invantive documentation
Invantive Support ForumsLog In / Sign Up

DealFilesAll: Teamleader Focus Deal Files

read only

  • Catalog: Teamleader
  • Schema: V2Flat
  • Label: Deal Files

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 DealFilesAll 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
deal_c_omzetwaarde_volgens_methode_2 decimal itgen_teamleader_c_omzetwaarde_volgens_methode_2 filters on the platform, writable
deal_c_success varchar2 itgen_teamleader_c_success filters on the platform, writable
deal_closed_at datetime Closed at filters on the platform, writable
deal_created_at datetime Created at filters on the platform, writable
deal_currency_exchange_rate_from varchar2 Currency Exchange Rate From filters on the platform, writable
deal_currency_exchange_rate_rate decimal Currency Exchange Rate filters on the platform, writable
deal_currency_exchange_rate_to varchar2 Currency Exchange Rate To filters on the platform, writable
deal_current_phase_id varchar2 Current Phase ID filters on the platform, writable
deal_current_phase_type varchar2 Current Phase Type filters on the platform, writable
deal_department_id varchar2 Department ID filters on the platform, writable
deal_department_type varchar2 Department Type filters on the platform, writable
deal_estimated_closing_date datetime Estimated Closing Date filters on the platform, writable
deal_estimated_probability decimal Estimated Probability filters on the platform, writable
deal_estimated_value_amount decimal Estimated Value Amount filters on the platform, writable
deal_estimated_value_currency varchar2 Currency of Estimated Value Amount filters on the platform, writable
deal_id varchar2 ID filters on the platform, writable
deal_lead_contact_person_id varchar2 Lead Contact Person ID filters on the platform, writable
deal_lead_contact_person_type varchar2 Lead Contact Person Type filters on the platform, writable
deal_lead_customer_id varchar2 Lead Customer ID filters on the platform, writable
deal_lead_customer_type varchar2 Lead Customer Type filters on the platform, writable
deal_lost_reason_id varchar2 Lost Reason ID filters on the platform, writable
deal_lost_reason_remark varchar2 Lost Reason Remark filters on the platform, writable
deal_lost_reason_type varchar2 Lost Reason Type filters on the platform, writable
deal_pipeline_id varchar2 Pipeline ID filters on the platform, writable
deal_pipeline_type varchar2 Pipeline Type filters on the platform, writable
deal_purchase_order_number varchar2 Purchase Order Number filters on the platform, writable
deal_reference varchar2 Reference filters on the platform, writable
deal_responsible_user_id varchar2 Responsible User ID filters on the platform, writable
deal_responsible_user_type varchar2 Responsible User Type filters on the platform, writable
deal_source_id varchar2 Source ID filters on the platform, writable
deal_source_type varchar2 Source Type filters on the platform, writable
deal_status varchar2 Status filters on the platform, writable
deal_summary varchar2 Summary filters on the platform, writable
deal_title varchar2(120) Title filters on the platform, writable
deal_updated_at datetime Updated At filters on the platform, writable
deal_web_url varchar2 Web (URL) filters on the platform, writable
deal_weighted_value_amount decimal Weighted Value Amount filters on the platform, writable
deal_weighted_value_currency varchar2 Weighted Value Currency filters on the platform, writable
folder varchar2 Folder filters on the platform, writable
id varchar2 ID filters on the platform, writable
mime_type varchar2 Mime Type filters on the platform, writable
name varchar2 Name filters on the platform, writable
size int64 Size 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
updated_at datetime Updated At filters on the platform, writable
uploaded_by_id varchar2 Uploaded By ID filters on the platform, writable

Release Notes

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