Navigation: » No topics above this level «

Deals: Deals

https://online-sql-editor.com/teamleader/eu/stable/Sql?appendSqlQuery=select+*%0D%0Afrom+++Teamleader.V2.Deals%0D%0Alimit++1000

Name: Deals

Catalog: Teamleader

Schema: V2

Primary Keys: id

Label: Deals

Partition-specific: false

Select: true

Insert: false

Update: false

Delete: false

Select Service URL (OData-specific): deals.list

Insert Service URL (OData-specific): deals.list

Update Service URL (OData-specific): deals.list

Delete Service URL (OData-specific): deals.list

Field Selection Method (OData-specific): NotRequired

Table Columns

Name	Data Type	Label	Required
closed_at	datetime	Closed at	☐
created_at	datetime		☑
current_phase_id	string	Current Phase ID	☐
current_phase_type	string	Current Phase Type	☐
department_id	string	Department ID	☐
department_type	string	Department Type	☐
estimated_closing_date	datetime	Estimated Closing Date	☐
estimated_probability	decimal	Estimated Probability	☐
estimated_value_amount	decimal	Estimated Value Amount	☐
estimated_value_currency	string	Currency of Estimated Value Amount	☐
id	string	ID	☑
lead_contact_person_id	string	Lead Contact Person ID	☐
lead_contact_person_type	string	Lead Contact Person Type	☐
lead_customer_id	string	Lead Customer ID	☐
lead_customer_type	string	Lead Customer Type	☐
lost_reason_id	string		☐
lost_reason_remark	string		☐
lost_reason_type	string		☐
purchase_order_number	string		☐
reference	string	Reference	☐
responsible_user_id	string	Responsible User ID	☐
responsible_user_type	string	Responsible User Type	☐
source_id	string	Source ID	☐
source_type	string	Source Type	☐
status	string	Status	☑
summary	string		☐
title	string(80)	Title	☐
updated_at	datetime	Updated At	☑
web_url	string	Web (URL)	☑
weighted_value_amount	decimal		☐
weighted_value_currency	string		☐

10-09-2020 00:0920.1.206-BETA+2915