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 |
☐ |
|
string |
☐ |
|
||
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