Navigation: » No topics above this level «

companies: Companies

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

Name: companies

Catalog: Teamleader

Schema: V1

Primary Keys: id

Label: Companies

Partition-specific: false

Select: true

Insert: false

Update: false

Delete: false

Select Service URL (OData-specific): getCompanies.php

Insert Service URL (OData-specific): getCompanies.php

Update Service URL (OData-specific): getCompanies.php

Delete Service URL (OData-specific): getCompanies.php

Field Selection Method (OData-specific): NotRequired

Table Columns

Name	Data Type	Label	Required
bic	string	BIC Number	☐
business_type	string	Business Type	☐
city	string	City	☐
country	string	Country	☐
date_added	datetime	Date Added	☐
date_edited	datetime	Date Edited	☐
deleted	boolean	Deleted	☑
email	string	Email	☐
fax	string	Fax	☐
iban	string	IBAN Number	☐
id	int32	ID	☑
language_code	string	Language Code	☐
language_name	string	Language Name	☐
name	string	Name	☐
number	string	Number	☐
payment_term	string	Payment Term	☐
status	string	Status	☐
street	string	Street	☐
taxcode	string	Tax Code	☐
telephone	string	Telephone	☐
vat_liability	string	VAT Liability	☐
website	string	Website	☐
zipcode	string	ZIP Code	☐

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