Please enable JavaScript to view this site.

Error itgendoc001X

xMsg javascript has not been loaded.

Teamleader API Data Model

Navigation: Schema: V1Flat > Tables

V1ToV2Contacts

Contents Previous Home Next More

Catalog: Teamleader

Schema: V1Flat

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.

View Columns

The columns of the view V1ToV2Contacts are shown below. Each column has an SQL data type.

Name

Data Type

Label

Required

Documentation

bic

string(15)

BIC Number

 

city

string(70)

City

 

country

string

Country

 

date_added

datetime

Date Added

 

date_edited

datetime

Date Edited

 

deleted

int32

Deleted

 

dob

datetime

Date of Birth

 

email

string(100)

Email

 

fax

string(30)

Fax

 

forename

string(60)

First Name

 

gender

string

Gender

 

gsm

string(30)

Mobile Phone

 

iban

string

IBAN Number

 

id

int32

ID

 

id_v2

guid

ID (V2)

 

language_code

string

Language Code

 

language_name

string

Language Name

 

number

string(12)

Number

 

salutation

string

Salutation

 

status

string

Status

 

street

string(120)

Street

 

surname

string(60)

Last Name

 

telephone

string(30)

Telephone

 

website

string(100)

Website

 

zipcode

string(10)

ZIP Code

 

 

12-12-2020 19:52 Version 20.1.301-BETA+3023