Please enable JavaScript to view this site.

Teamleader API Data Model

Navigation: Schema: V2Flat > Tables

CompanyCustomFieldValues

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 CompanyCustomFieldValues 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_company_id

string

Company 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

 

 

cpy_added_at

datetime

Added At

 

cpy_bic

string

BIC Number

 

cpy_business_type_id

string

Business Type ID

 

cpy_business_type_type

string

Business Type

 

cpy_iban

string

IBAN Number

 

cpy_id

string

ID

 

cpy_invoicing_preferences_electronic_invoicing_address

string

 

 

cpy_language

string

Language

 

cpy_local_business_number

string

Local Business Number

Also known as Chamber of Commerce number in many countries.

cpy_name

string

Name

 

cpy_national_identification_number

string

 

Also known as Chamber of Commerce number in many countries.

cpy_payment_term_days

decimal

Payment Term (days)

 

cpy_payment_term_type

string

Payment Term Type

 

cpy_preferred_currency

string

Preferred Currency

 

cpy_primary_address_city

string

Primary Address City

 

cpy_primary_address_country

string

Primary Address Country

 

cpy_primary_address_line1

string

Primary Address Line 1

 

cpy_primary_address_postal_code

string

Primary Address Postal Code

 

cpy_responsible_user_id

string

Responsible User ID

 

cpy_responsible_user_type

string

Responsible User Type

 

cpy_updated_at

datetime

Updated At

 

cpy_vat_number

string

VAT Number

 

cpy_web_url

string

Web (URL)

 

cpy_website

string

Website

 

 

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