Please enable JavaScript to view this site.

Error itgendoc001X

xMsg javascript has not been loaded.

Simplicate API Data Model

Navigation: Schema: CRM > Tables

InterestOrganizations

Contents Previous Home Next More

Fetches all organizations

Catalog: Simplicate

Schema: CRM

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[*].interests[*]

Select Simplicate API Operation: get /crm/organization

Table Function Columns

The columns of the table function InterestOrganizations 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_vpb

boolean

 

 

accountancy_tax_unit_vat_role

string

 

 

accountancy_tax_unit_vpb_role

string

 

 

accountancy_vat_number_fe

string

 

 

allow_autocollect

boolean

 

 

api_name

string

 

 

bank_account

string

Bank Account

 

bank_bic

string

 

 

coc_code

string

 

 

contact

boolean

 

 

created_at

string

Created at

 

created

string

Created

 

debtor_attention_to_fixed

string

 

 

debtor_attention_to_person_id

string

 

See /crm/person

debtor_attention_to

string

 

 

debtor_autocollect

boolean

 

 

debtor_autosend_subscription_invoice

boolean

 

 

debtor_invoicetemplate_id

string

 

 

debtor_payment_term_days

int64

 

 

debtor_payment_term_id

string

 

 

debtor_payment_term_method

string

 

 

debtor_payment_term_name

string

 

 

debtor_provision_contactperson_id

string

 

See /crm/person

debtor_provision_method

string

 

 

debtor_reminders

boolean

 

 

debtor_send_email_email

string

 

 

debtor_send_email_type

string

 

 

email

string

 

 

has_different_postal_address

boolean

 

 

id_1

string

 

 

id

string

ID

 

industry_id

string

 

 

industry_name

string

 

 

invoice_receiver

string

 

 

linkedin_url

string

 

 

modified

string

Modified

 

name_1

string

 

 

name

string

Name

 

note

string

Note

 

organization

boolean

 

 

organizationsize_id

string

 

 

organizationsize_name

string

 

 

person

boolean

 

 

phone

string

 

 

postal_address_country_code

string

 

 

postal_address_country_id

string

 

 

postal_address_country

string

 

 

postal_address_id

string

 

 

postal_address_line_1

string

 

 

postal_address_line_2

string

 

 

postal_address_locality

string

 

 

postal_address_postal_code

string

 

 

postal_address_province

string

 

 

postal_address_type

string

 

 

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_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

 

 

relation_manager_is_user

boolean

 

 

relation_manager_marital_status

string

 

 

relation_manager_modified

string

 

 

relation_manager_name

string

 

 

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_date_of_birth

string

 

 

relation_manager_person_email

string

 

 

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_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_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_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_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_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_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_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_type_color

string

 

 

relation_type_id

string

 

 

relation_type_label

string

 

 

relation_type_type

string

 

 

simplicate_url

string

Simplicate URL

 

timeline_email_address

string

 

 

updated_at

string

Updated at

 

url

string

 

 

value

string

Value

 

vat_number

string

 

 

visiting_address_country_code

string

 

 

visiting_address_country_id

string

 

 

visiting_address_country

string

 

 

visiting_address_id

string

 

 

visiting_address_line_1

string

 

 

visiting_address_line_2

string

 

 

visiting_address_locality

string

 

 

visiting_address_postal_code

string

 

 

visiting_address_province

string

 

 

visiting_address_type

string

 

 

 

06-04-2021 14:59 Version 20.1.393-BETA+3152