contact: Contact |
https://online-sql-editor.com/teamleader/eu/stable/Sql?appendSqlQuery=select+*%0D%0Afrom+++Teamleader.V1.contact%0D%0Alimit++1000
Name: contact
Catalog: Teamleader
Schema: V1
Primary Keys: id
Label: Contact
Partition-specific: false
Select: true
Insert: false
Update: false
Delete: false
Select Service URL (OData-specific): getContact.php
Insert Service URL (OData-specific): getContact.php
Update Service URL (OData-specific): getContact.php
Delete Service URL (OData-specific): getContact.php
Field Selection Method (OData-specific): NotRequired
Table Columns
Name |
Data Type |
Label |
Required |
Documentation |
---|---|---|---|---|
background_info_html |
string |
Background Information (HTML) |
☐ |
|
bic |
string(15) |
BIC Number |
☐ |
|
c_activiteit_en |
string |
|
☐ |
|
c_backup_verkoper_employee_id |
int32 |
|
☐ |
|
c_bijnaam |
string |
|
☐ |
|
c_geslacht_uitgebreid_id |
int32 |
|
☐ |
|
c_geslacht_uitgebreid_value |
string |
|
☐ |
|
c_licentiecoordinator_contact_id |
int32 |
|
☐ |
|
c_licentieproduct_product_id |
int32 |
|
☐ |
|
c_rare_ee_u |
string |
|
☐ |
|
c_toelichting_lang_clob |
string |
|
☐ |
|
c_verkoper_employee_id |
int32 |
|
☐ |
|
city |
string(70) |
City |
☐ |
|
country |
string |
Country |
☐ |
|
date_added |
datetime |
Date Added |
☐ |
|
date_edited |
datetime |
Date Edited |
☐ |
|
deleted |
int32 |
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 |
☐ |
|
dob |
datetime |
Date of Birth |
☐ |
|
string(100) |
☐ |
|
||
external_customer_id |
string |
External Customer ID |
☐ |
|
fax |
string(30) |
Fax |
☐ |
|
forename |
string(40) |
First Name |
☐ |
|
gender |
string |
Gender |
☐ |
|
gsm |
string(30) |
Mobile Phone |
☐ |
|
iban |
string |
IBAN Number |
☐ |
|
id |
int32 |
ID |
☑ |
|
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 |
☐ |
|
language_code |
string |
Language Code |
☐ |
|
language_name |
string |
Language Name |
☐ |
|
linked_company_ids |
string |
Linked Company IDs |
☐ |
|
number |
string(12) |
Number |
☐ |
|
salutation |
string |
Salutation |
☐ |
|
street |
string(120) |
Street |
☐ |
|
surname |
string(60) |
Last Name |
☐ |
|
telephone |
string(30) |
Telephone |
☐ |
|
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(100) |
Website |
☐ |
|
zipcode |
string(10) |
ZIP Code |
☐ |
|
10-09-2020 00:0920.1.206-BETA+2915