Navigation: » No topics above this level «

Companies: Companies

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

Name: Companies

Catalog: Teamleader

Schema: V2

Primary Keys: id

Label: Companies

Partition-specific: false

Select: true

Insert: false

Update: false

Delete: false

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

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

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

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

Field Selection Method (OData-specific): NotRequired

Table Columns

Name	Data Type	Label	Required	Documentation
added_at	datetime	Added At	☑
bic	string	BIC Number	☐
business_type_id	string	Business Type ID	☐
business_type_type	string	Business Type	☐
iban	string	IBAN Number	☐
id	string	ID	☑
invoicing_preferences_electronic_invoicing_address	string		☐
language	string	Language	☐
local_business_number	string	Local Business Number	☐	Also known as Chamber of Commerce number in many countries.
name	string	Name	☑
national_identification_number	string		☐	Also known as Chamber of Commerce number in many countries.
payment_term_days	decimal	Payment Term (days)	☐
payment_term_type	string	Payment Term Type	☐
preferred_currency	string	Preferred Currency	☐
primary_address_city	string	Primary Address City	☐
primary_address_country	string	Primary Address Country	☐
primary_address_line1	string	Primary Address Line 1	☐
primary_address_postal_code	string	Primary Address Postal Code	☐
responsible_user_id	string	Responsible User ID	☐
responsible_user_type	string	Responsible User Type	☐
updated_at	datetime	Updated At	☑
vat_number	string	VAT Number	☐
web_url	string	Web (URL)	☑
website	string	Website	☐

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