# Organisations - Catalog: `Dummy` - Schema: `Demo` This is a read-only view. The Dummy API may not support changing the data or the Invantive UniversalSQL driver for Dummy does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Dummy API. ## View Columns The columns of the view `Organisations` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `action_requested` | `varchar2` | | ☐ | | | `bce_btw_percentage` | `double` | | ☐ | | | `bce_code` | `varchar2` | | ☐ | | | `bce_id` | `int64` | | ☐ | | | `bce_omschrijving` | `varchar2` | | ☐ | | | `bnk_code` | `varchar2` | | ☐ | | | `bnk_id` | `int64` | | ☐ | | | `bnk_omschrijving` | `varchar2` | | ☐ | | | `cdi_k_code` | `varchar2` | | ☐ | | | `cdi_k_id` | `int64` | | ☐ | | | `cdi_k_koppel_ind` | `char` | | ☐ | | | `cdi_k_omschrijving` | `varchar2` | | ☐ | | | `cdi_o_code` | `varchar2` | | ☐ | | | `cdi_o_id` | `int64` | | ☐ | | | `cdi_o_koppel_ind` | `char` | | ☐ | | | `cdi_o_omschrijving` | `varchar2` | | ☐ | | | `dsk_aantal_documenten_c` | `varchar2` | | ☐ | | | `dsk_aantal_documenten` | `int32` | | ☐ | | | `dsk_eerste_document_param1` | `decimal` | | ☐ | | | `dsk_eerste_document_url` | `varchar2` | | ☐ | | | `dsk_eerste_document` | `varchar2` | | ☐ | | | `dsk_id` | `int64` | | ☐ | | | `dsk_laatste_document_param1` | `decimal` | | ☐ | | | `dsk_laatste_document_url` | `varchar2` | | ☐ | | | `dsk_laatste_document` | `varchar2` | | ☐ | | | `dsk_label_nn` | `varchar2` | | ☐ | | | `dsk_meerdere_aanwezig` | `varchar2` | | ☐ | | | `dsk_ref_sleutel` | `int64` | | ☐ | | | `dsk_ref_tabel` | `varchar2` | | ☐ | | | `dsk_som_bestand_omvang_c` | `varchar2` | | ☐ | | | `gbr_cp_aanmeld_code` | `varchar2` | | ☐ | | | `gbr_cp_achternaam` | `varchar2` | | ☐ | | | `gbr_cp_email_adres_workflow` | `varchar2` | | ☐ | | | `gbr_cp_email_adres` | `varchar2` | | ☐ | | | `gbr_cp_functie` | `varchar2` | | ☐ | | | `gbr_cp_geslacht_ind` | `char` | | ☐ | | | `gbr_cp_id` | `int64` | | ☐ | | | `gbr_cp_initialen` | `varchar2` | | ☐ | | | `gbr_cp_naam` | `varchar2` | | ☐ | | | `gbr_cp_pasfoto_url_ult` | `varchar2` | | ☐ | | | `gbr_cp_pasfoto_url` | `varchar2` | | ☐ | | | `gbr_cp_personeelsnummer` | `varchar2` | | ☐ | | | `gbr_cp_taakhouder_vlag` | `char` | | ☐ | | | `gbr_cp_tussenvoegsel` | `varchar2` | | ☐ | | | `gbr_cp_voorletters` | `varchar2` | | ☐ | | | `gbr_cp_voornaam` | `varchar2` | | ☐ | | | `gbr_cp_werk_afdeling` | `varchar2` | | ☐ | | | `gbr_cp_werk_tel` | `varchar2` | | ☐ | | | `gbr_ik_aanmeld_code` | `varchar2` | | ☐ | | | `gbr_ik_achternaam` | `varchar2` | | ☐ | | | `gbr_ik_email_adres_workflow` | `varchar2` | | ☐ | | | `gbr_ik_email_adres` | `varchar2` | | ☐ | | | `gbr_ik_functie` | `varchar2` | | ☐ | | | `gbr_ik_geslacht_ind` | `char` | | ☐ | | | `gbr_ik_id` | `int64` | | ☐ | | | `gbr_ik_initialen` | `varchar2` | | ☐ | | | `gbr_ik_naam` | `varchar2` | | ☐ | | | `gbr_ik_pasfoto_url_ult` | `varchar2` | | ☐ | | | `gbr_ik_pasfoto_url` | `varchar2` | | ☐ | | | `gbr_ik_personeelsnummer` | `varchar2` | | ☐ | | | `gbr_ik_taakhouder_vlag` | `char` | | ☐ | | | `gbr_ik_tussenvoegsel` | `varchar2` | | ☐ | | | `gbr_ik_voorletters` | `varchar2` | | ☐ | | | `gbr_ik_voornaam` | `varchar2` | | ☐ | | | `gbr_ik_werk_afdeling` | `varchar2` | | ☐ | | | `gbr_ik_werk_tel` | `varchar2` | | ☐ | | | `gbr_in_aanmeld_code` | `varchar2` | | ☐ | | | `gbr_in_achternaam` | `varchar2` | | ☐ | | | `gbr_in_email_adres_workflow` | `varchar2` | | ☐ | | | `gbr_in_email_adres` | `varchar2` | | ☐ | | | `gbr_in_functie` | `varchar2` | | ☐ | | | `gbr_in_geslacht_ind` | `char` | | ☐ | | | `gbr_in_id` | `int64` | | ☐ | | | `gbr_in_initialen` | `varchar2` | | ☐ | | | `gbr_in_naam` | `varchar2` | | ☐ | | | `gbr_in_pasfoto_url_ult` | `varchar2` | | ☐ | | | `gbr_in_pasfoto_url` | `varchar2` | | ☐ | | | `gbr_in_personeelsnummer` | `varchar2` | | ☐ | | | `gbr_in_taakhouder_vlag` | `char` | | ☐ | | | `gbr_in_tussenvoegsel` | `varchar2` | | ☐ | | | `gbr_in_voorletters` | `varchar2` | | ☐ | | | `gbr_in_voornaam` | `varchar2` | | ☐ | | | `gbr_in_werk_afdeling` | `varchar2` | | ☐ | | | `gbr_in_werk_tel` | `varchar2` | | ☐ | | | `gbr_se1_aanmeld_code` | `varchar2` | | ☐ | | | `gbr_se1_achternaam` | `varchar2` | | ☐ | | | `gbr_se1_email_adres_workflow` | `varchar2` | | ☐ | | | `gbr_se1_email_adres` | `varchar2` | | ☐ | | | `gbr_se1_functie` | `varchar2` | | ☐ | | | `gbr_se1_geslacht_ind` | `char` | | ☐ | | | `gbr_se1_id` | `int64` | | ☐ | | | `gbr_se1_initialen` | `varchar2` | | ☐ | | | `gbr_se1_naam` | `varchar2` | | ☐ | | | `gbr_se1_pasfoto_url_ult` | `varchar2` | | ☐ | | | `gbr_se1_pasfoto_url` | `varchar2` | | ☐ | | | `gbr_se1_personeelsnummer` | `varchar2` | | ☐ | | | `gbr_se1_taakhouder_vlag` | `char` | | ☐ | | | `gbr_se1_tussenvoegsel` | `varchar2` | | ☐ | | | `gbr_se1_voorletters` | `varchar2` | | ☐ | | | `gbr_se1_voornaam` | `varchar2` | | ☐ | | | `gbr_se1_werk_afdeling` | `varchar2` | | ☐ | | | `gbr_se1_werk_tel` | `varchar2` | | ☐ | | | `gbr_se2_aanmeld_code` | `varchar2` | | ☐ | | | `gbr_se2_achternaam` | `varchar2` | | ☐ | | | `gbr_se2_email_adres_workflow` | `varchar2` | | ☐ | | | `gbr_se2_email_adres` | `varchar2` | | ☐ | | | `gbr_se2_functie` | `varchar2` | | ☐ | | | `gbr_se2_geslacht_ind` | `char` | | ☐ | | | `gbr_se2_id` | `int64` | | ☐ | | | `gbr_se2_initialen` | `varchar2` | | ☐ | | | `gbr_se2_naam` | `varchar2` | | ☐ | | | `gbr_se2_pasfoto_url_ult` | `varchar2` | | ☐ | | | `gbr_se2_pasfoto_url` | `varchar2` | | ☐ | | | `gbr_se2_personeelsnummer` | `varchar2` | | ☐ | | | `gbr_se2_taakhouder_vlag` | `char` | | ☐ | | | `gbr_se2_tussenvoegsel` | `varchar2` | | ☐ | | | `gbr_se2_voorletters` | `varchar2` | | ☐ | | | `gbr_se2_voornaam` | `varchar2` | | ☐ | | | `gbr_se2_werk_afdeling` | `varchar2` | | ☐ | | | `gbr_se2_werk_tel` | `varchar2` | | ☐ | | | `gbr_vk_aanmeld_code` | `varchar2` | | ☐ | | | `gbr_vk_achternaam` | `varchar2` | | ☐ | | | `gbr_vk_email_adres_workflow` | `varchar2` | | ☐ | | | `gbr_vk_email_adres` | `varchar2` | | ☐ | | | `gbr_vk_functie` | `varchar2` | | ☐ | | | `gbr_vk_geslacht_ind` | `char` | | ☐ | | | `gbr_vk_id` | `int64` | | ☐ | | | `gbr_vk_initialen` | `varchar2` | | ☐ | | | `gbr_vk_naam` | `varchar2` | | ☐ | | | `gbr_vk_pasfoto_url_ult` | `varchar2` | | ☐ | | | `gbr_vk_pasfoto_url` | `varchar2` | | ☐ | | | `gbr_vk_personeelsnummer` | `varchar2` | | ☐ | | | `gbr_vk_taakhouder_vlag` | `char` | | ☐ | | | `gbr_vk_tussenvoegsel` | `varchar2` | | ☐ | | | `gbr_vk_voorletters` | `varchar2` | | ☐ | | | `gbr_vk_voornaam` | `varchar2` | | ☐ | | | `gbr_vk_werk_afdeling` | `varchar2` | | ☐ | | | `gbr_vk_werk_tel` | `varchar2` | | ☐ | | | `lge_code` | `varchar2` | | ☐ | | | `lge_description_i18n` | `varchar2` | | ☐ | | | `lge_description` | `varchar2` | | ☐ | | | `lge_id` | `int64` | | ☐ | | | `lvr_aangemaakt_door` | `varchar2` | | ☑ | | | `lvr_aangemaakt_in` | `varchar2` | | ☑ | | | `lvr_aantal_medewerkers_ft` | `int32` | | ☐ | | | `lvr_aantal_medewerkers` | `int32` | | ☐ | | | `lvr_adres_regel_1` | `varchar2` | | ☐ | | | `lvr_adres_regel_2` | `varchar2` | | ☐ | | | `lvr_bic` | `varchar2` | | ☐ | | | `lvr_bijgewerkt_door` | `varchar2` | | ☑ | | | `lvr_bijgewerkt_in` | `varchar2` | | ☑ | | | `lvr_btw_nummer` | `varchar2` | | ☐ | | | `lvr_bzk_adres_regel_1` | `varchar2` | | ☐ | | | `lvr_bzk_adres_regel_2` | `varchar2` | | ☐ | | | `lvr_bzk_land` | `varchar2` | | ☐ | | | `lvr_bzk_plaats` | `varchar2` | | ☐ | | | `lvr_bzk_postcode` | `varchar2` | | ☐ | | | `lvr_bzk_provincie` | `varchar2` | | ☐ | | | `lvr_code` | `varchar2` | | ☑ | | | `lvr_codering_activiteiten` | `varchar2` | | ☐ | | | `lvr_datum_aangemaakt` | `datetime` | | ☑ | | | `lvr_datum_bijgewerkt` | `datetime` | | ☑ | | | `lvr_datum_intrf_bijgewerkt` | `datetime` | | ☐ | | | `lvr_datum_intrf_geladen` | `datetime` | | ☐ | | | `lvr_datum_laatste_review` | `datetime` | | ☐ | | | `lvr_datum_opgeheven` | `datetime` | | ☐ | | | `lvr_datum_opgericht` | `datetime` | | ☐ | | | `lvr_datum_volgende_review` | `datetime` | | ☐ | | | `lvr_duns_nummer` | `varchar2` | | ☐ | | | `lvr_email_adres_url` | `varchar2` | | ☐ | | | `lvr_email_adres` | `varchar2` | | ☐ | | | `lvr_facebook_adres` | `varchar2` | | ☐ | | | `lvr_failliet_vlag` | `char` | | ☑ | | | `lvr_fax_tel` | `varchar2` | | ☐ | | | `lvr_ftr_adres_naam` | `varchar2` | | ☐ | | | `lvr_ftr_adres_regel_1` | `varchar2` | | ☐ | | | `lvr_ftr_adres_regel_2` | `varchar2` | | ☐ | | | `lvr_ftr_email_adres` | `varchar2` | | ☐ | | | `lvr_ftr_land` | `varchar2` | | ☐ | | | `lvr_ftr_plaats` | `varchar2` | | ☐ | | | `lvr_ftr_postcode` | `varchar2` | | ☐ | | | `lvr_ftr_provincie` | `varchar2` | | ☐ | | | `lvr_g_rekening` | `varchar2` | | ☐ | | | `lvr_gm_adres` | `varchar2` | | ☐ | | | `lvr_googleplus_adres` | `varchar2` | | ☐ | | | `lvr_graydon_nummer` | `varchar2` | | ☐ | | | `lvr_handelsnamen` | `varchar2` | | ☐ | | | `lvr_hyves_adres` | `varchar2` | | ☐ | | | `lvr_iban_nummer` | `varchar2` | | ☐ | | | `lvr_icq_adres` | `varchar2` | | ☐ | | | `lvr_id` | `int64` | | ☑ | | | `lvr_ikoon_url_ult` | `varchar2` | | ☐ | | | `lvr_ikoon_url` | `varchar2` | | ☐ | | | `lvr_ip_adres_lijst` | `varchar2` | | ☐ | | | `lvr_job_seq_geladen` | `int64` | | ☐ | | | `lvr_klant_actief_vlag` | `char` | | ☑ | | | `lvr_klant_vlag` | `char` | | ☑ | | | `lvr_klassificatie_reeks_c` | `clob` | | ☐ | | | `lvr_klassificatie_reeks` | `clob` | | ☐ | | | `lvr_kolom_soort` | `varchar2` | | ☐ | | | `lvr_kolom1` | `varchar2` | | ☐ | | | `lvr_kolom10` | `varchar2` | | ☐ | | | `lvr_kolom2` | `varchar2` | | ☐ | | | `lvr_kolom3` | `varchar2` | | ☐ | | | `lvr_kolom4` | `varchar2` | | ☐ | | | `lvr_kolom5` | `varchar2` | | ☐ | | | `lvr_kolom6` | `varchar2` | | ☐ | | | `lvr_kolom7` | `varchar2` | | ☐ | | | `lvr_kolom8` | `varchar2` | | ☐ | | | `lvr_kolom9` | `varchar2` | | ☐ | | | `lvr_kvk_nummer` | `varchar2` | | ☐ | | | `lvr_label` | `varchar2` | | ☐ | | | `lvr_land` | `varchar2` | | ☐ | | | `lvr_linkedin_adres` | `varchar2` | | ☐ | | | `lvr_logo_url` | `varchar2` | | ☐ | | | `lvr_lvr_datum_volgende_review` | `datetime` | | ☐ | | | `lvr_lvr_ikoon_url` | `varchar2` | | ☐ | | | `lvr_mobiel_tel` | `varchar2` | | ☐ | | | `lvr_myspace_adres` | `varchar2` | | ☐ | | | `lvr_naam_kort` | `varchar2` | | ☐ | | | `lvr_naam` | `varchar2` | | ☑ | | | `lvr_nc` | `varchar2` | | ☐ | | | `lvr_nk` | `varchar2` | | ☑ | | | `lvr_notities_l` | `clob` | | ☐ | | | `lvr_omschrijving_activiteiten` | `varchar2` | | ☐ | | | `lvr_onze_klt_code_bij_lvr` | `varchar2` | | ☐ | | | `lvr_onze_lvr_code_bij_klt` | `varchar2` | | ☐ | | | `lvr_opdrachtnemer_actief_vlag` | `char` | | ☑ | | | `lvr_opdrachtnemer_vlag` | `char` | | ☑ | | | `lvr_orig_system_group` | `varchar2` | | ☐ | | | `lvr_orig_system_reference` | `varchar2` | | ☐ | | | `lvr_partitie` | `int64` | | ☑ | | | `lvr_paypal_identifier` | `varchar2` | | ☐ | | | `lvr_pjt_ent_actief_vlag` | `char` | | ☑ | | | `lvr_plaats` | `varchar2` | | ☐ | | | `lvr_plaxo_adres` | `varchar2` | | ☐ | | | `lvr_postcode` | `varchar2` | | ☐ | | | `lvr_project_entiteit_vlag` | `char` | | ☑ | | | `lvr_provincie` | `varchar2` | | ☐ | | | `lvr_pst_adres_regel_1` | `varchar2` | | ☐ | | | `lvr_pst_adres_regel_2` | `varchar2` | | ☐ | | | `lvr_pst_land` | `varchar2` | | ☐ | | | `lvr_pst_plaats` | `varchar2` | | ☐ | | | `lvr_pst_postcode` | `varchar2` | | ☐ | | | `lvr_pst_provincie` | `varchar2` | | ☐ | | | `lvr_rsin_nummer` | `varchar2` | | ☐ | | | `lvr_rss_url` | `varchar2` | | ☐ | | | `lvr_sessie_aangemaakt` | `varchar2` | | ☑ | | | `lvr_sessie_bijgewerkt` | `varchar2` | | ☑ | | | `lvr_skype_adres` | `varchar2` | | ☐ | | | `lvr_statutaire_naam` | `varchar2` | | ☐ | | | `lvr_surseance_vlag` | `char` | | ☑ | | | `lvr_thuis_tel` | `varchar2` | | ☐ | | | `lvr_transactie_aangemaakt` | `int64` | | ☑ | | | `lvr_transactie_bijgewerkt` | `int64` | | ☑ | | | `lvr_twitter_adres` | `varchar2` | | ☐ | | | `lvr_volledig_adres` | `varchar2` | | ☐ | | | `lvr_voorkeur_email_adres` | `varchar2` | | ☐ | | | `lvr_website_url` | `varchar2` | | ☐ | | | `lvr_werk_tel` | `varchar2` | | ☐ | | | `lvr_xing_adres` | `varchar2` | | ☐ | | | `lvr_youtube_adres` | `varchar2` | | ☐ | | | `rvm_code` | `varchar2` | | ☐ | | | `rvm_id` | `int64` | | ☐ | | | `rvm_omschrijving` | `varchar2` | | ☐ | |