MailingListPersons: Simplicate Mailinglijst Personen |
Fetches all persons
Catalogus: Simplicate
Schema: CRM
Label: Mailinglijst Personen
Dit is een alleen-lezen tabel. De Simplicate API biedt mogelijk geen ondersteuning voor het wijzigen van de data of het Invantive UniversalSQL-stuurprogramma voor Simplicate ondersteunt dit niet. In het laatste geval gebruikt u de tabel NativePlatformScalarRequests om gegevens te uploaden naar de Simplicate-API.
Tabelkolommen
De kolommen van de tabel MailingListPersons worden hieronder weergegeven. Elke kolom heeft een SQL-gegevenstype.
Naam |
Datatype |
Label |
Verplicht |
Documentatie |
---|---|---|---|---|
address_country_code |
string |
Adres Landcode |
☐ |
|
address_country_id |
string |
Adres Land-ID |
☐ |
|
address_country |
string |
Adres Land |
☐ |
|
address_id |
string |
Adres ID |
☐ |
|
address_line_1 |
string |
Adresregel 1 |
☐ |
|
address_line_2 |
string |
Adresregel 2 |
☐ |
|
address_locality |
string |
Adres Plaats |
☐ |
|
address_postal_code |
string |
Adres Postcode |
☐ |
|
address_province |
string |
Adres Provincie |
☐ |
|
address_type |
string |
Adressoort |
☐ |
|
avatar_color |
string |
Avatarkleur |
☐ |
|
avatar_initials |
string |
Avatar initialen |
☐ |
|
avatar_url_large |
string |
Avatar Groot (URL) |
☐ |
|
avatar_url_small |
string |
Avatar klein (URL) |
☐ |
|
bank_account |
string |
Bankrekening |
☐ |
|
bank_bic |
string |
Bank BIC |
☐ |
|
created_at |
string |
Aangemaakt op |
☐ |
|
custom_salutation |
string |
|
☐ |
|
date_of_birth |
string |
Geboortedatum |
☐ |
|
string |
☐ |
|
||
facebook_url |
string |
Facebook URL |
☐ |
|
family_name_prefix |
string |
Voorvoegsel Familienaam |
☐ |
|
family_name |
string |
Achternaam |
☐ |
|
first_name |
string |
Voornaam |
☐ |
|
full_name |
string |
Volledige Naam |
☐ |
|
gender_id |
string |
Geslacht ID |
☐ |
|
gender |
string |
Geslacht |
☐ |
|
id_2 |
string |
|
☐ |
|
id |
string |
ID |
☐ |
|
initials |
string |
Initialen |
☐ |
|
invoice_receiver |
string |
Factuurontvanger |
☐ |
|
is_active |
boolean |
|
☐ |
|
is_employee |
int64 |
Is Werknemer |
☐ |
|
linkedin_url |
string |
LinkedIn-URL |
☐ |
|
mailing_list_email |
string |
Mailinglijst E-mail |
☐ |
|
name |
string |
Naam |
☐ |
|
note |
string |
Notitie |
☐ |
|
phone |
string |
Telefoon |
☐ |
|
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 |
☐ |
|
twitter_url |
string |
Twitter-URL |
☐ |
|
updated_at |
string |
Bijgewerkt op |
☐ |
|
use_custom_salutation |
boolean |
|
☐ |
|
value |
boolean |
Waarde |
☐ |
|
website_url |
string |
Website URL |
☐ |
|
18-10-2024 06:48 Versie 24.0.345-PROD+4945