xMsg javascript has not been loaded.
Catalog: Teamleader
Schema: V1Flat
Label: Contacts
This is a read-only view. The Teamleader API may not support changing the data or the Invantive SQL driver for Teamleader does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Teamleader API.
The columns of the view ContactsAll are shown below. Each column has an SQL data type.
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_eerst_tekst_dan_getal |
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(60) |
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 |
☐ |
|
12-12-2020 19:52 Version 20.1.301-BETA+3023