Please enable JavaScript to view this site.

Navigation: Schema: CRM > Tables

OrganizationCustomFields: Simplicate Organization Custom Fields

Fetches all organizations

Catalog: Simplicate

Schema: CRM

Label: Organization Custom Fields

This is a read-only table function. The Simplicate API may not support changing the data or the Invantive SQL driver for Simplicate does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Simplicate API.

Select Simplicate API URL: /crm/organization

Insert Simplicate API URL: /crm/organization

Update Simplicate API URL: /crm/organization

Delete Simplicate API URL: /crm/organization

Field Selection Method: NotRequired

Base Path: data[*].custom_fields[*]

Select Simplicate API Operation: get /crm/organization

Table Function Columns

The columns of the table function OrganizationCustomFields are shown below. Each column has an SQL data type.

Name

Data Type

Label

Required

Documentation

accountancy_is_tax_unit_vat

boolean

Accountancy - Is Tax Unit VAT

 

accountancy_is_tax_unit_vpb

boolean

Accountancy - Is Tax Unit VPB

 

accountancy_tax_unit_vat_role

string

Accountancy - Is Tax Unit VAT Role

 

accountancy_tax_unit_vpb_role

string

Accountancy - Is Tax Unit VPB Role

 

accountancy_vat_number_fe

string

Accountancy - VAT Number Fiscal Unit

 

allow_autocollect

boolean

Auto Collect

 

bank_account

string

Bank Account

 

bank_bic

string

Bank BIC

 

coc_code

string

CoC Code

 

created_at

string

Created at

 

created

string

Created

 

custom_field_group_id

string

Custom Field Group ID

 

custom_field_group_model_id

string

Custom Field Group Model ID

 

custom_field_group_model_label

string

Custom Field Group Model Label

 

custom_field_group_name

string

Custom Field Group Name

 

custom_field_group_position

string

Custom Field Group Position

 

custom_field_group_type

string

Custom Field Group Type

 

debtor_attention_to_fixed

string

Debtor Attention to (fixed)

 

debtor_attention_to_person_id

string

Debtor Attention to Person ID

See /crm/person

debtor_attention_to

string

Debtor Attention to

 

debtor_autocollect

boolean

Debtor Auto Collect

 

debtor_autosend_subscription_invoice

boolean

 

 

debtor_invoicetemplate_id

string

Debtor Invoice Template ID

 

debtor_payment_term_days

int64

Debtor Payment Term (days)

 

debtor_payment_term_id

string

Debtor Payment Term ID

 

debtor_payment_term_method

string

Debtor Payment Term Method

 

debtor_payment_term_name

string

Debtor Payment Term Name

 

debtor_provision_contactperson_id

string

 

See /crm/person

debtor_provision_method

string

Provision Method

 

debtor_reminders

boolean

Reminders

 

debtor_send_email_email

string

Send Email

 

debtor_send_email_type

string

Send Email Type

 

email

string

Email

 

filterable

boolean

Filterable

 

has_different_postal_address

boolean

Different Postal Address

 

id_1

string

 

 

id

string

ID

 

industry_id

string

Industry ID

 

industry_name

string

Industry Name

 

invoice_receiver

string

Invoice Receiver

 

label

string

Label

 

linkedin_url

string

LinkedIn URL

 

modified

string

Modified

 

name_1

string

 

 

name

string

Name

 

note

string

Note

 

organizationsize_id

string

Organization Size ID

 

organizationsize_name

string

Organization Size Name

 

phone

string

Phone

 

position

int64

Position

 

postal_address_country_code

string

Postal Address Country Code

 

postal_address_country_id

string

Postal Address Country ID

 

postal_address_country

string

Postal Address Country

 

postal_address_id

string

Postal Address ID

 

postal_address_line_1

string

Postal Address Line 1

 

postal_address_line_2

string

Postal Address Line 2

 

postal_address_locality

string

Postal Address Locality

 

postal_address_postal_code

string

Postal Address Postal Code

 

postal_address_province

string

Postal Address Province

 

postal_address_type

string

Postal Address Type

 

relation_manager_avatar_color

string

 

 

relation_manager_avatar_initials

string

 

 

relation_manager_avatar_url_large

string

 

 

relation_manager_avatar_url_small

string

 

 

relation_manager_bank_account

string

 

 

relation_manager_civil_status

string

 

 

relation_manager_created_at

string

 

 

relation_manager_created

string

 

 

relation_manager_employment_status

string

 

 

relation_manager_function

string

 

 

relation_manager_hourly_cost_tariff

float

 

 

relation_manager_hourly_sales_tariff

float

 

 

relation_manager_id

string

Relationship Manager ID

 

relation_manager_is_user

boolean

 

 

relation_manager_marital_status

string

 

 

relation_manager_modified

string

 

 

relation_manager_name

string

Relationship Manager Name

 

relation_manager_person_address_country_code

string

 

 

relation_manager_person_address_country_id

string

 

 

relation_manager_person_address_country

string

 

 

relation_manager_person_address_id

string

 

 

relation_manager_person_address_line_1

string

 

 

relation_manager_person_address_line_2

string

 

 

relation_manager_person_address_locality

string

 

 

relation_manager_person_address_postal_code

string

 

 

relation_manager_person_address_province

string

 

 

relation_manager_person_address_type

string

 

 

relation_manager_person_avatar_color

string

 

 

relation_manager_person_avatar_initials

string

 

 

relation_manager_person_avatar_url_large

string

 

 

relation_manager_person_avatar_url_small

string

 

 

relation_manager_person_bank_account

string

 

 

relation_manager_person_bank_bic

string

 

 

relation_manager_person_created_at

string

 

 

relation_manager_person_custom_salutation

string

 

 

relation_manager_person_date_of_birth

string

 

 

relation_manager_person_email

string

Relationship Manager Email

 

relation_manager_person_facebook_url

string

 

 

relation_manager_person_family_name_prefix

string

 

 

relation_manager_person_family_name

string

 

 

relation_manager_person_first_name

string

 

 

relation_manager_person_full_name

string

 

 

relation_manager_person_gender_id

string

 

 

relation_manager_person_gender

string

 

 

relation_manager_person_id_1

string

 

 

relation_manager_person_id

string

 

 

relation_manager_person_initials

string

 

 

relation_manager_person_invoice_receiver

string

 

 

relation_manager_person_is_employee

int64

 

 

relation_manager_person_linkedin_url

string

 

 

relation_manager_person_mailing_list_email

string

 

 

relation_manager_person_note

string

 

 

relation_manager_person_phone

string

 

 

relation_manager_person_relation_manager_avatar_color

string

 

 

relation_manager_person_relation_manager_avatar_initials

string

 

 

relation_manager_person_relation_manager_avatar_url_large

string

 

 

relation_manager_person_relation_manager_avatar_url_small

string

 

 

relation_manager_person_relation_manager_bank_account

string

 

 

relation_manager_person_relation_manager_civil_status

string

 

 

relation_manager_person_relation_manager_created_at

string

 

 

relation_manager_person_relation_manager_created

string

 

 

relation_manager_person_relation_manager_employment_status

string

 

 

relation_manager_person_relation_manager_function

string

 

 

relation_manager_person_relation_manager_hourly_cost_tariff

float

 

 

relation_manager_person_relation_manager_hourly_sales_tariff

float

 

 

relation_manager_person_relation_manager_id

string

 

 

relation_manager_person_relation_manager_is_user

boolean

 

 

relation_manager_person_relation_manager_marital_status

string

 

 

relation_manager_person_relation_manager_modified

string

 

 

relation_manager_person_relation_manager_name

string

 

 

relation_manager_person_relation_manager_person_address_country_code

string

 

 

relation_manager_person_relation_manager_person_address_country_id

string

 

 

relation_manager_person_relation_manager_person_address_country

string

 

 

relation_manager_person_relation_manager_person_address_id

string

 

 

relation_manager_person_relation_manager_person_address_line_1

string

 

 

relation_manager_person_relation_manager_person_address_line_2

string

 

 

relation_manager_person_relation_manager_person_address_locality

string

 

 

relation_manager_person_relation_manager_person_address_postal_code

string

 

 

relation_manager_person_relation_manager_person_address_province

string

 

 

relation_manager_person_relation_manager_person_address_type

string

 

 

relation_manager_person_relation_manager_person_avatar_color

string

 

 

relation_manager_person_relation_manager_person_avatar_initials

string

 

 

relation_manager_person_relation_manager_person_avatar_url_large

string

 

 

relation_manager_person_relation_manager_person_avatar_url_small

string

 

 

relation_manager_person_relation_manager_person_bank_account

string

 

 

relation_manager_person_relation_manager_person_bank_bic

string

 

 

relation_manager_person_relation_manager_person_created_at

string

 

 

relation_manager_person_relation_manager_person_custom_salutation

string

 

 

relation_manager_person_relation_manager_person_date_of_birth

string

 

 

relation_manager_person_relation_manager_person_email

string

 

 

relation_manager_person_relation_manager_person_facebook_url

string

 

 

relation_manager_person_relation_manager_person_family_name_prefix

string

 

 

relation_manager_person_relation_manager_person_family_name

string

 

 

relation_manager_person_relation_manager_person_first_name

string

 

 

relation_manager_person_relation_manager_person_full_name

string

 

 

relation_manager_person_relation_manager_person_gender_id

string

 

 

relation_manager_person_relation_manager_person_gender

string

 

 

relation_manager_person_relation_manager_person_id_1

string

 

 

relation_manager_person_relation_manager_person_id

string

 

 

relation_manager_person_relation_manager_person_initials

string

 

 

relation_manager_person_relation_manager_person_invoice_receiver

string

 

 

relation_manager_person_relation_manager_person_is_employee

int64

 

 

relation_manager_person_relation_manager_person_linkedin_url

string

 

 

relation_manager_person_relation_manager_person_mailing_list_email

string

 

 

relation_manager_person_relation_manager_person_note

string

 

 

relation_manager_person_relation_manager_person_phone

string

 

 

relation_manager_person_relation_manager_person_relation_manager_bank_account

string

 

 

relation_manager_person_relation_manager_person_relation_manager_civil_status

string

 

 

relation_manager_person_relation_manager_person_relation_manager_created_at

string

 

 

relation_manager_person_relation_manager_person_relation_manager_created

string

 

 

relation_manager_person_relation_manager_person_relation_manager_employment_status

string

 

 

relation_manager_person_relation_manager_person_relation_manager_function

string

 

 

relation_manager_person_relation_manager_person_relation_manager_hourly_cost_tariff

float

 

 

relation_manager_person_relation_manager_person_relation_manager_hourly_sales_tariff

float

 

 

relation_manager_person_relation_manager_person_relation_manager_id

string

 

 

relation_manager_person_relation_manager_person_relation_manager_is_user

boolean

 

 

relation_manager_person_relation_manager_person_relation_manager_marital_status

string

 

 

relation_manager_person_relation_manager_person_relation_manager_modified

string

 

 

relation_manager_person_relation_manager_person_relation_manager_name

string

 

 

relation_manager_person_relation_manager_person_relation_manager_person_id

string

 

 

relation_manager_person_relation_manager_person_relation_manager_simplicate_url

string

 

 

relation_manager_person_relation_manager_person_relation_manager_social_security_number

string

 

 

relation_manager_person_relation_manager_person_relation_manager_timeline_email_address

string

 

 

relation_manager_person_relation_manager_person_relation_manager_updated_at

string

 

 

relation_manager_person_relation_manager_person_relation_manager_work_email

string

 

 

relation_manager_person_relation_manager_person_relation_manager_work_mobile

string

 

 

relation_manager_person_relation_manager_person_relation_manager_work_phone

string

 

 

relation_manager_person_relation_manager_person_relation_number

string

 

 

relation_manager_person_relation_manager_person_relation_type_color

string

 

 

relation_manager_person_relation_manager_person_relation_type_id

string

 

 

relation_manager_person_relation_manager_person_relation_type_label

string

 

 

relation_manager_person_relation_manager_person_relation_type_type

string

 

 

relation_manager_person_relation_manager_person_simplicate_url

string

 

 

relation_manager_person_relation_manager_person_timeline_email_address

string

 

 

relation_manager_person_relation_manager_person_twitter_url

string

 

 

relation_manager_person_relation_manager_person_updated_at

string

 

 

relation_manager_person_relation_manager_person_use_custom_salutation

boolean

 

 

relation_manager_person_relation_manager_person_website_url

string

 

 

relation_manager_person_relation_manager_simplicate_url

string

 

 

relation_manager_person_relation_manager_social_security_number

string

 

 

relation_manager_person_relation_manager_status_id

string

 

 

relation_manager_person_relation_manager_status_label

string

 

 

relation_manager_person_relation_manager_timeline_email_address

string

 

 

relation_manager_person_relation_manager_type_id

string

 

 

relation_manager_person_relation_manager_type_label

string

 

 

relation_manager_person_relation_manager_updated_at

string

 

 

relation_manager_person_relation_manager_work_email

string

 

 

relation_manager_person_relation_manager_work_mobile

string

 

 

relation_manager_person_relation_manager_work_phone

string

 

 

relation_manager_person_relation_number

string

 

 

relation_manager_person_relation_type_color

string

 

 

relation_manager_person_relation_type_id

string

 

 

relation_manager_person_relation_type_label

string

 

 

relation_manager_person_relation_type_type

string

 

 

relation_manager_person_simplicate_url

string

 

 

relation_manager_person_timeline_email_address

string

 

 

relation_manager_person_twitter_url

string

 

 

relation_manager_person_updated_at

string

 

 

relation_manager_person_use_custom_salutation

boolean

 

 

relation_manager_person_website_url

string

 

 

relation_manager_simplicate_url

string

 

 

relation_manager_social_security_number

string

 

 

relation_manager_status_id

string

 

 

relation_manager_status_label

string

 

 

relation_manager_timeline_email_address

string

 

 

relation_manager_type_id

string

 

 

relation_manager_type_label

string

 

 

relation_manager_updated_at

string

 

 

relation_manager_work_email

string

 

 

relation_manager_work_mobile

string

 

 

relation_manager_work_phone

string

 

 

relation_number

string

Relation Number

 

relation_type_color

string

Relation Type Color

 

relation_type_id

string

Relation Type ID

 

relation_type_label

string

Relation Type Label

 

relation_type_type

string

Relation Type

 

render_type

string

Render Type

 

searchable

boolean

Searchable

 

simplicate_url

string

Simplicate URL

 

timeline_email_address

string

Timeline Email Address

 

type

string

Type

 

updated_at

string

Updated at

 

url

string

URL

 

value_type

string

Value Type

 

value

string

Value

 

vat_number

string

VAT Number

 

visiting_address_country_code

string

Visiting Address Country Code

 

visiting_address_country_id

string

Visiting Address Country ID

 

visiting_address_country

string

Visiting Address Country

 

visiting_address_id

string

Visiting Address ID

 

visiting_address_line_1

string

Visiting Address Address Line 1

 

visiting_address_line_2

string

Visiting Address Address Line 2

 

visiting_address_locality

string

Visiting Address Locality

 

visiting_address_postal_code

string

Visiting Address Postal Code

 

visiting_address_province

string

Visiting Address Province

 

visiting_address_type

string

Visiting Address Type

 

 

15-06-2022 20:27 Version 22.0.232-PROD+3445