Organizations: Simplicate Organisaties |
Fetches all organizations
Catalogus: Simplicate
Schema: CRM
Primaire Sleutels: id
Label: Organisaties
Kan gegevens ophalen en wijzigen met behulp van toevoegen, bijwerken en verwijderen.
Tabelkolommen
De kolommen van de tabel Organizations worden hieronder weergegeven. Elke kolom heeft een SQL-gegevenstype. Voor elke vereiste kolom moet bij het invoegen en bijwerken steeds een nieuwe, niet-lege waarde worden opgegeven.
Naam |
Datatype |
Label |
Verplicht |
Documentatie |
---|---|---|---|---|
accountancy_is_tax_unit_vat |
boolean |
Boekhouding - Is Belastingeenheid BTW |
☐ |
|
accountancy_is_tax_unit_vpb |
boolean |
Boekhouding - Is Belastingeenheid VPB |
☐ |
|
accountancy_tax_unit_vat_role |
string |
Accountancy - Is Belastingeenheid BTW-rol |
☐ |
|
accountancy_tax_unit_vpb_role |
string |
Boekhouding - Is Belastingdienst VPB-rol |
☐ |
|
accountancy_vat_number_fe |
string |
Boekhouding - BTW-nummer Fiscale Eenheid |
☐ |
|
allow_autocollect |
boolean |
Automatisch verzamelen |
☐ |
|
bank_account |
string |
Bankrekening |
☐ |
|
bank_bic |
string |
Bank BIC |
☐ |
|
coc_code |
string |
KvK Nummer |
☐ |
|
created_at |
string |
Aangemaakt op |
☐ |
|
created |
string |
Gemaakt |
☐ |
|
customer_group_id |
string |
|
☐ |
|
customer_group_name |
string |
|
☐ |
|
debtor_attention_to_fixed |
string |
Debiteur Aandacht voor (vast) |
☐ |
|
debtor_attention_to_person_id |
string |
Debiteur Aandacht voor Persoon ID |
☐ |
Zie /crm/person |
debtor_attention_to |
string |
Debiteur Aandacht voor |
☐ |
|
debtor_autocollect |
boolean |
Debiteur Automatisch Incasseren |
☐ |
|
debtor_autosend_subscription_invoice |
boolean |
|
☐ |
|
debtor_invoicetemplate_id |
string |
Debiteurenfactuur Sjabloon-ID |
☐ |
|
debtor_payment_term_days |
int64 |
Debiteurbetalingstermijn (dagen) |
☐ |
|
debtor_payment_term_id |
string |
Debiteur Betalingstermijn ID |
☐ |
|
debtor_payment_term_method |
string |
Debiteur Betalingstermijn Methode |
☐ |
|
debtor_payment_term_name |
string |
Debiteur Betalingstermijn Naam |
☐ |
|
debtor_provision_contactperson_id |
string |
|
☐ |
Zie /crm/person |
debtor_provision_method |
string |
Voorzieningsmethode |
☐ |
|
debtor_reminders |
boolean |
Herinneringen |
☐ |
|
debtor_send_email_email |
string |
E-mail Verzenden |
☐ |
|
debtor_send_email_type |
string |
Versturen E-mailsoort |
☐ |
|
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 |
|
☐ |
|
string |
☐ |
|
||
has_different_postal_address |
boolean |
Ander postadres |
☐ |
|
id |
string |
ID |
☐ |
|
industry_id |
string |
Industrie ID |
☐ |
|
industry_name |
string |
Branchenaam |
☐ |
|
invoice_receiver |
string |
Factuurontvanger |
☐ |
|
is_active |
boolean |
|
☐ |
|
linkedin_url |
string |
LinkedIn-URL |
☐ |
|
modified |
string |
Gewijzigd |
☐ |
|
name |
string |
Naam |
☐ |
|
note |
string |
Notitie |
☐ |
|
organizationsize_id |
string |
Organisatiegoote ID |
☐ |
|
organizationsize_name |
string |
Naam Organisatiegrootte |
☐ |
|
phone |
string |
Telefoon |
☐ |
|
postal_address_country_code |
string |
Postadres Landcode |
☐ |
|
postal_address_country_id |
string |
Postadres Land ID |
☐ |
|
postal_address_country |
string |
Postadres Land |
☐ |
|
postal_address_id |
string |
Postadres ID |
☐ |
|
postal_address_line_1 |
string |
Postadresregel 1 |
☐ |
|
postal_address_line_2 |
string |
Postadresregel 2 |
☐ |
|
postal_address_locality |
string |
Postadres Plaats |
☐ |
|
postal_address_postal_code |
string |
Postadres Postcode |
☐ |
|
postal_address_province |
string |
Postadres Provincie |
☐ |
|
postal_address_type |
string |
Postadrestype |
☐ |
|
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 |
Relatiemanager ID |
☐ |
|
relation_manager_is_user |
boolean |
|
☐ |
|
relation_manager_marital_status |
string |
|
☐ |
|
relation_manager_modified |
string |
|
☐ |
|
relation_manager_name |
string |
Relatiemanager Naam |
☐ |
|
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 |
Relatiemanager E-mailadres |
☐ |
|
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 |
Relatienummer: |
☐ |
|
relation_type_color |
string |
Kleur Relatiesoort |
☐ |
|
relation_type_id |
string |
Relatietype-ID |
☐ |
|
relation_type_label |
string |
Relatietypelabel |
☐ |
|
relation_type_type |
string |
Relatiesoort |
☐ |
|
simplicate_url |
string |
Simplicate URL |
☐ |
|
timeline_email_address |
string |
Tijdlijn e-mailadres |
☐ |
|
updated_at |
string |
Bijgewerkt op |
☐ |
|
url |
string |
URL |
☐ |
|
vat_number |
string |
BTW-nummer |
☐ |
|
visiting_address_country_code |
string |
Bezoekadres Country Code |
☐ |
|
visiting_address_country_id |
string |
Bezoekadres Land ID |
☐ |
|
visiting_address_country |
string |
Bezoekadres Land |
☐ |
|
visiting_address_id |
string |
Bezoekadres-ID |
☐ |
|
visiting_address_line_1 |
string |
Bezoekadres Adresregel 1 |
☐ |
|
visiting_address_line_2 |
string |
Bezoekadres Adresregel 2 |
☐ |
|
visiting_address_locality |
string |
Bezoekadres Plaats |
☐ |
|
visiting_address_postal_code |
string |
Bezoekadres Postcode |
☐ |
|
visiting_address_province |
string |
Bezoekadres Provincie |
☐ |
|
visiting_address_type |
string |
Type Bezoekadres |
☐ |
|
18-10-2024 06:48 Versie 24.0.345-PROD+4945