company: Company |
https://online-sql-editor.com/teamleader/eu/stable/Sql?appendSqlQuery=select+*%0D%0Afrom+++Teamleader.V1.company%0D%0Alimit++1000
Name: company
Catalog: Teamleader
Schema: V1
Primary Keys: id
Label: Company
Partition-specific: false
Select: true
Insert: false
Update: false
Delete: false
Select Service URL (OData-specific): getCompany.php
Insert Service URL (OData-specific): getCompany.php
Update Service URL (OData-specific): getCompany.php
Delete Service URL (OData-specific): getCompany.php
Field Selection Method (OData-specific): NotRequired
Table Columns
Name |
Data Type |
Label |
Required |
Documentation |
---|---|---|---|---|
account_manager_id |
int32 |
Account Manager ID |
☐ |
|
background_info_html |
string |
Background Information (HTML) |
☐ |
|
bic |
string |
BIC Number |
☐ |
|
c_test_id |
int32 |
|
☐ |
|
c_test_value |
string |
|
☐ |
|
city |
string |
City |
☐ |
|
country |
string |
Country |
☐ |
|
date_added |
datetime |
Date Added |
☐ |
|
deleted |
boolean |
Deleted |
☑ |
|
delivery_address_address_name |
string |
Delivery Address Address Name |
☐ |
|
delivery_address_city |
string |
Delivery Address City |
☐ |
|
delivery_address_country |
string |
Delivery Address Country |
☐ |
|
delivery_address_number |
string |
Delivery Address Number |
☐ |
|
delivery_address_street |
string |
Delivery Address Street |
☐ |
|
delivery_address_zipcode |
string |
Delivery Address ZIP Code |
☐ |
|
string |
☐ |
|
||
external_customer_id |
string |
External Customer ID |
☐ |
|
fax |
string |
Fax |
☐ |
|
iban |
string |
IBAN Number |
☐ |
|
id |
int32 |
ID |
☑ |
|
invoice_email_address |
string |
Invoice Email Address |
☐ |
|
invoicing_address_address_name |
string |
Invoicing Address Address name |
☐ |
|
invoicing_address_city |
string |
Invoicing Address City |
☐ |
|
invoicing_address_country |
string |
Invoicing Address Country |
☐ |
|
invoicing_address_number |
string |
Invoicing Address Number |
☐ |
|
invoicing_address_street |
string |
Invoicing Address Street |
☐ |
|
invoicing_address_zipcode |
string |
Invoicing Address ZIP Code |
☐ |
|
kvk_nummer |
string |
Chamber of Commerce Number |
☐ |
|
language_code |
string |
Language Code |
☐ |
|
local_business_number |
string |
Local Business Number |
☐ |
|
name |
string |
Name |
☐ |
|
number |
string |
Number |
☐ |
|
payment_term |
string |
Payment Term |
☐ |
|
pricelist_id |
int32 |
Pricelist ID |
☐ |
|
sector_name |
string |
Sector Name |
☐ |
|
street |
string |
Street |
☐ |
|
taxcode |
string |
Tax Code |
☐ |
|
telephone |
string |
Telephone |
☐ |
|
vat_liability |
string |
VAT Liability |
☐ |
|
visiting_address_address_name |
string |
Visiting Address Address Name |
☐ |
|
visiting_address_city |
string |
Visiting Address City |
☐ |
|
visiting_address_country |
string |
Visiting Address Country |
☐ |
|
visiting_address_number |
string |
Visiting Address Number |
☐ |
|
visiting_address_street |
string |
Visiting Address Street |
☐ |
|
visiting_address_zipcode |
string |
Visiting Address ZIP Code |
☐ |
|
website |
string |
Website |
☐ |
|
zipcode |
string |
ZIP Code |
☐ |
|
10-09-2020 00:0920.1.206-BETA+2915