Please enable JavaScript to view this site.

Navigation: » No topics above this level «

contact: Contact

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

 

email

string(100)

Email

 

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