Please enable JavaScript to view this site.

Navigation: Schema: CRM > Tables

Organizations: Simplicate Organizations

Fetches all organizations

Catalog: Simplicate

Schema: CRM

Label: Organizations

Can retrieve data and change data using insert, update and delete.

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

Select Simplicate API Operation: get /crm/organization

Insert Simplicate API Operation: post /crm/organization

Update Simplicate API Operation: put /crm/organization/{id}

Delete Simplicate API Operation: delete /crm/organization/{id}

Table Function Columns

The columns of the table function Organizations are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert or update.

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

 

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

 

has_different_postal_address

boolean

Different Postal Address

 

id

string

ID

 

industry_id

string

Industry ID

 

industry_name

string

Industry Name

 

invoice_receiver

string

Invoice Receiver

 

linkedin_url

string

LinkedIn URL

 

modified

string

Modified

 

name

string

Name

 

note

string

Note

 

organizationsize_id

string

Organization Size ID

 

organizationsize_name

string

Organization Size Name

 

phone

string

Phone

 

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

 

simplicate_url

string

Simplicate URL

 

timeline_email_address

string

Timeline Email Address

 

updated_at

string

Updated at

 

url

string

URL

 

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