Teamleader API Data Model
CompanyCustomFieldValues: Teamleader Focus Company Custom Field Values |
Catalog: Teamleader
Schema: V2Flat
Label: Company Custom Field Values
This is a read-only view. The Teamleader Focus API may not support changing the data or the Invantive SQL driver for Teamleader Focus does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Teamleader Focus 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 |
☐ |
Group for grouping multiple custom fields in the web frontend. |
cfd_label |
string |
Label |
☐ |
Label for display with the value in the web frontend. |
cfd_required |
boolean |
Required |
☑ |
Whether a value must be provided. |
cfd_type |
string |
Type |
☑ |
Type of the values stored, such as 'auto_increment', 'integer', 'contact', 'number' or 'multi_line'. |
cfe_company_id |
string |
Record ID |
☑ |
ID of the company for which these custom field values provide additional information. |
cfe_definition_id |
string |
Definition ID |
☑ |
|
cfe_definition_type |
string |
Definition Type |
☑ |
Type of the custom field definition. |
cfe_value_as_array |
string |
Array Value |
☐ |
|
cfe_value_as_boolean |
boolean |
Boolean Value |
☐ |
|
cfe_value_as_number |
decimal |
Numeric Value |
☐ |
|
cfe_value_as_string |
string |
Text Value |
☐ |
|
cfe_value_object_id |
string |
ID of Undefined Type |
☐ |
|
cfe_value_object_type |
string |
Value of Undefined Type |
☐ |
|
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 |
Invoicing Preferences Electronic Invoicing Address |
☐ |
|
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 |
National Identification Number |
☐ |
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 |
☐ |
VAT number. |
cpy_web_url |
string |
Web (URL) |
☑ |
|
cpy_website |
string |
Website |
☐ |
|
22-12-2022 21:06 Version 22.1.101-BETA+3681
