Please enable JavaScript to view this site.

Error itgendoc001X

xMsg javascript has not been loaded.

Teamleader API Data Model

Navigation: Schema: V1Flat > Tables

DealPhaseChangesAll: Teamleader Deal Phase Changes

Contents Previous Home Next More

Catalog: Teamleader

Schema: V1Flat

Label: Deal Phase Changes

This is a read-only view. The Teamleader API may not support changing the data or the Invantive SQL driver for Teamleader does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Teamleader API.

View Columns

The columns of the view DealPhaseChangesAll are shown below. Each column has an SQL data type.

Name

Data Type

Label

Required

Documentation

change_date

datetime

Change Date

 

change_date_formatted

string(20)

Change Date (Formatted)

 

deal_close_date

datetime

Close Date

 

deal_close_date_formatted

string(20)

Close Date (Formatted)

 

deal_date_lost

datetime

Date Lost

 

deal_date_lost_formatted

string(20)

Date Lost (Formatted)

 

deal_entry_date

datetime

Entry Date

 

deal_entry_date_formatted

string(20)

Entry Date (Formatted)

 

deal_for

string

Concerns

 

deal_for_id

int32

ID of Concerns

 

deal_id

int32

ID

 

deal_latest_activity_date

datetime

Latest Activity Date

 

deal_latest_activity_date_formatted

string(20)

Latest Activity Date (Formatted)

 

deal_phase_id

int32

Phase ID

 

deal_probability

int32

Probability

 

deal_quotation_nr

int32

Quotation Number

 

deal_reason_refused

string

Reason Refused

 

deal_responsible_user_id

int32

Responsible User ID

 

deal_source_id

int32

Source ID

 

deal_title

string(80)

Title

 

deal_total_price_excl_vat

decimal

Total Price excl. VAT

 

new_phase_id

int32

New Phase ID

 

old_phase_id

int32

Old Phase ID

 

related_user_id

int32

Related User ID

 

 

12-12-2020 19:52 Version 20.1.301-BETA+3023