Please enable JavaScript to view this site.

Teamleader API Data Model

Navigation: Schema: V2Flat > Tables

ContactCustomFieldValues

Contents Previous Home Next More

Catalog: Teamleader

Schema: V2Flat

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 ContactCustomFieldValues are shown below. Each column has an SQL data type.

Name

Data Type

Label

Required

Documentation

cfd_group

string

Group

 

cfd_label

string

Label

 

cfd_required

boolean

Required

 

cfd_type

string

Type

 

cfe_contact_id

string

Contact ID

 

cfe_definition_id

string

 

 

cfe_definition_type

string

 

 

cfe_value_as_array

string

 

 

cfe_value_as_boolean

boolean

 

 

cfe_value_as_number

decimal

 

 

cfe_value_as_string

string

 

 

cfe_value_object_id

string

 

 

cfe_value_object_type

string

 

 

ctt_added_at

datetime

Added At

 

ctt_bic

string

BIC Number

 

ctt_birthdate

datetime

Date of Birth

 

ctt_first_name

string

First Name

 

ctt_gender

string

Gender

 

ctt_iban

string

IBAN Number

 

ctt_id

string

ID

 

ctt_invoicing_preferences_electronic_invoicing_address

string

 

 

ctt_language

string

Language

 

ctt_last_name

string

Last Name

 

ctt_local_business_number

string

Local Business Number

Also known as Chamber of Commerce number in many countries.

ctt_national_identification_number

string

 

Also known as Chamber of Commerce number in many countries.

ctt_payment_term_days

decimal

Payment Term (days)

 

ctt_payment_term_type

string

Payment Term Type

 

ctt_primary_address_city

string

Primary Address City

 

ctt_primary_address_country

string

Primary Address Country

 

ctt_primary_address_line1

string

Primary Address Line 1

 

ctt_primary_address_postal_code

string

Primary Address Postal Code

 

ctt_salutation

string

Salutation

 

ctt_updated_at

datetime

Updated At

 

ctt_web_url

string

Web (URL)

 

ctt_website

string

Website

 

 

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