# Organizations: Simplicate Organisations Fetches all organizations Can retrieve and modify data using insert, update and delete. - Catalog: `Simplicate` - Schema: `CRM` - Primary Keys: `id` - Label: Organisations ## Table Columns The columns of the table `Organizations` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `accountancy_is_tax_unit_vat` | `boolean` | Accounting - Is Tax Unit VAT | ☐ | | | `accountancy_is_tax_unit_vpb` | `boolean` | Accounting - Is Tax Unit CIT | ☐ | | | `accountancy_tax_unit_vat_role` | `string` | Accounting - Is Tax Unit VAT Role | ☐ | | | `accountancy_tax_unit_vpb_role` | `string` | Accounting - Is Tax Unit CIT Role | ☐ | | | `accountancy_vat_number_fe` | `string` | Accounting - VAT Number Fiscal Unit | ☐ | | | `allow_autocollect` | `boolean` | Collect Automatically | ☐ | | | `bank_account` | `string` | Bank Account | ☐ | | | `bank_bic` | `string` | Bank BIC | ☐ | | | `coc_code` | `string` | Chamber of Commerce Number | ☐ | | | `created_at` | `string` | Created On | ☐ | | | `created` | `string` | Created | ☐ | | | `customer_group_id` | `string` | | ☐ | | | `customer_group_name` | `string` | | ☐ | | | `debtor_attention_to_fixed` | `string` | Customer Attention To (Fixed) | ☐ | | | `debtor_attention_to_person_id` | `string` | Customer Attention To Person ID | ☐ | See /crm/person | | `debtor_attention_to` | `string` | Customer Attention To | ☐ | | | `debtor_autocollect` | `boolean` | Customer Automatic Direct Debit | ☐ | | | `debtor_autosend_subscription_invoice` | `boolean` | | ☐ | | | `debtor_invoicetemplate_id` | `string` | Customer Invoice Template ID | ☐ | | | `debtor_payment_term_days` | `int64` | Customer Payment Term (days) | ☐ | | | `debtor_payment_term_id` | `string` | Customer Payment Term ID | ☐ | | | `debtor_payment_term_method` | `string` | Customer Payment Term Method | ☐ | | | `debtor_payment_term_name` | `string` | Customer 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 | ☐ | | | `debtor_send_invoice_email_to_cc` | `boolean` | | ☐ | | | `debtor_send_invoice_email_to_contact` | `boolean` | | ☐ | | | `debtor_send_invoice_email_to_fixed_email` | `boolean` | | ☐ | | | `debtor_send_invoice_email_to_project_contact` | `boolean` | | ☐ | | | `email` | `string` | E-mail | ☐ | | | `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 Recipient | ☐ | | | `is_active` | `boolean` | | ☐ | | | `linkedin_url` | `string` | LinkedIn URL | ☐ | | | `modified` | `string` | Modified | ☐ | | | `name` | `string` | Name | ☐ | | | `note` | `string` | Note | ☐ | | | `organizationsize_id` | `string` | Organisation Size ID | ☐ | | | `organizationsize_name` | `string` | Organisation 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 City | ☐ | | | `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 Address | ☐ | | | `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_2` | `string` | | ☐ | | | `relation_manager_person_id` | `string` | | ☐ | | | `relation_manager_person_initials` | `string` | | ☐ | | | `relation_manager_person_invoice_receiver` | `string` | | ☐ | | | `relation_manager_person_is_active` | `boolean` | | ☐ | | | `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_2` | `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_active` | `boolean` | | ☐ | | | `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 Colour | ☐ | | | `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 On | ☐ | | | `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 Line 1 | ☐ | | | `visiting_address_line_2` | `string` | Visiting Address Line 2 | ☐ | | | `visiting_address_locality` | `string` | Visiting Address City | ☐ | | | `visiting_address_postal_code` | `string` | Visiting Address Postal Code | ☐ | | | `visiting_address_province` | `string` | Visiting Address Province | ☐ | | | `visiting_address_type` | `string` | Visiting Address Type | ☐ | |