# Projects - 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 `Projects` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `action_requested` | `varchar2` | | ☐ | | | `bce_btw_percentage` | `decimal` | | ☐ | | | `bce_code` | `varchar2` | | ☐ | | | `bce_id` | `int64` | | ☐ | | | `bce_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_amr_aanmeld_code` | `varchar2` | | ☐ | | | `gbr_amr_achternaam` | `varchar2` | | ☐ | | | `gbr_amr_email_adres_workflow` | `varchar2` | | ☐ | | | `gbr_amr_email_adres` | `varchar2` | | ☐ | | | `gbr_amr_functie` | `varchar2` | | ☐ | | | `gbr_amr_geslacht_ind` | `char` | | ☑ | | | `gbr_amr_id` | `int64` | | ☑ | | | `gbr_amr_initialen` | `varchar2` | | ☐ | | | `gbr_amr_naam` | `varchar2` | | ☑ | | | `gbr_amr_pasfoto_url_ult` | `varchar2` | | ☐ | | | `gbr_amr_pasfoto_url` | `varchar2` | | ☐ | | | `gbr_amr_personeelsnummer` | `varchar2` | | ☐ | | | `gbr_amr_taakhouder_vlag` | `char` | | ☑ | | | `gbr_amr_tussenvoegsel` | `varchar2` | | ☐ | | | `gbr_amr_voorletters` | `varchar2` | | ☐ | | | `gbr_amr_voornaam` | `varchar2` | | ☐ | | | `gbr_amr_werk_afdeling` | `varchar2` | | ☐ | | | `gbr_amr_werk_tel` | `varchar2` | | ☐ | | | `gbr_cr_aanmeld_code` | `varchar2` | | ☐ | | | `gbr_cr_achternaam` | `varchar2` | | ☐ | | | `gbr_cr_email_adres_workflow` | `varchar2` | | ☐ | | | `gbr_cr_email_adres` | `varchar2` | | ☐ | | | `gbr_cr_functie` | `varchar2` | | ☐ | | | `gbr_cr_geslacht_ind` | `char` | | ☐ | | | `gbr_cr_id` | `int64` | | ☐ | | | `gbr_cr_initialen` | `varchar2` | | ☐ | | | `gbr_cr_naam` | `varchar2` | | ☐ | | | `gbr_cr_pasfoto_url_ult` | `varchar2` | | ☐ | | | `gbr_cr_pasfoto_url` | `varchar2` | | ☐ | | | `gbr_cr_personeelsnummer` | `varchar2` | | ☐ | | | `gbr_cr_taakhouder_vlag` | `char` | | ☐ | | | `gbr_cr_tussenvoegsel` | `varchar2` | | ☐ | | | `gbr_cr_voorletters` | `varchar2` | | ☐ | | | `gbr_cr_voornaam` | `varchar2` | | ☐ | | | `gbr_cr_werk_afdeling` | `varchar2` | | ☐ | | | `gbr_cr_werk_tel` | `varchar2` | | ☐ | | | `gbr_drr_aanmeld_code` | `varchar2` | | ☐ | | | `gbr_drr_achternaam` | `varchar2` | | ☐ | | | `gbr_drr_email_adres_workflow` | `varchar2` | | ☐ | | | `gbr_drr_email_adres` | `varchar2` | | ☐ | | | `gbr_drr_functie` | `varchar2` | | ☐ | | | `gbr_drr_geslacht_ind` | `char` | | ☑ | | | `gbr_drr_id` | `int64` | | ☑ | | | `gbr_drr_initialen` | `varchar2` | | ☐ | | | `gbr_drr_naam` | `varchar2` | | ☑ | | | `gbr_drr_pasfoto_url_ult` | `varchar2` | | ☐ | | | `gbr_drr_pasfoto_url` | `varchar2` | | ☐ | | | `gbr_drr_personeelsnummer` | `varchar2` | | ☐ | | | `gbr_drr_taakhouder_vlag` | `char` | | ☑ | | | `gbr_drr_tussenvoegsel` | `varchar2` | | ☐ | | | `gbr_drr_voorletters` | `varchar2` | | ☐ | | | `gbr_drr_voornaam` | `varchar2` | | ☐ | | | `gbr_drr_werk_afdeling` | `varchar2` | | ☐ | | | `gbr_drr_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_pl_aanmeld_code` | `varchar2` | | ☐ | | | `gbr_pl_achternaam` | `varchar2` | | ☐ | | | `gbr_pl_email_adres_workflow` | `varchar2` | | ☐ | | | `gbr_pl_email_adres` | `varchar2` | | ☐ | | | `gbr_pl_functie` | `varchar2` | | ☐ | | | `gbr_pl_geslacht_ind` | `char` | | ☐ | | | `gbr_pl_id` | `int64` | | ☐ | | | `gbr_pl_initialen` | `varchar2` | | ☐ | | | `gbr_pl_naam` | `varchar2` | | ☐ | | | `gbr_pl_pasfoto_url_ult` | `varchar2` | | ☐ | | | `gbr_pl_pasfoto_url` | `varchar2` | | ☐ | | | `gbr_pl_personeelsnummer` | `varchar2` | | ☐ | | | `gbr_pl_taakhouder_vlag` | `char` | | ☐ | | | `gbr_pl_tussenvoegsel` | `varchar2` | | ☐ | | | `gbr_pl_voorletters` | `varchar2` | | ☐ | | | `gbr_pl_voornaam` | `varchar2` | | ☐ | | | `gbr_pl_werk_afdeling` | `varchar2` | | ☐ | | | `gbr_pl_werk_tel` | `varchar2` | | ☐ | | | `gbr_por_aanmeld_code` | `varchar2` | | ☐ | | | `gbr_por_achternaam` | `varchar2` | | ☐ | | | `gbr_por_email_adres_workflow` | `varchar2` | | ☐ | | | `gbr_por_email_adres` | `varchar2` | | ☐ | | | `gbr_por_functie` | `varchar2` | | ☐ | | | `gbr_por_geslacht_ind` | `char` | | ☑ | | | `gbr_por_id` | `int64` | | ☑ | | | `gbr_por_initialen` | `varchar2` | | ☐ | | | `gbr_por_naam` | `varchar2` | | ☑ | | | `gbr_por_pasfoto_url_ult` | `varchar2` | | ☐ | | | `gbr_por_pasfoto_url` | `varchar2` | | ☐ | | | `gbr_por_personeelsnummer` | `varchar2` | | ☐ | | | `gbr_por_taakhouder_vlag` | `char` | | ☑ | | | `gbr_por_tussenvoegsel` | `varchar2` | | ☐ | | | `gbr_por_voorletters` | `varchar2` | | ☐ | | | `gbr_por_voornaam` | `varchar2` | | ☐ | | | `gbr_por_werk_afdeling` | `varchar2` | | ☐ | | | `gbr_por_werk_tel` | `varchar2` | | ☐ | | | `gbr_tak_aanmeld_code` | `varchar2` | | ☐ | | | `gbr_tak_achternaam` | `varchar2` | | ☐ | | | `gbr_tak_email_adres_workflow` | `varchar2` | | ☐ | | | `gbr_tak_email_adres` | `varchar2` | | ☐ | | | `gbr_tak_functie` | `varchar2` | | ☐ | | | `gbr_tak_geslacht_ind` | `char` | | ☐ | | | `gbr_tak_id` | `int64` | | ☐ | | | `gbr_tak_initialen` | `varchar2` | | ☐ | | | `gbr_tak_naam` | `varchar2` | | ☐ | | | `gbr_tak_pasfoto_url_ult` | `varchar2` | | ☐ | | | `gbr_tak_pasfoto_url` | `varchar2` | | ☐ | | | `gbr_tak_personeelsnummer` | `varchar2` | | ☐ | | | `gbr_tak_taakhouder_vlag` | `char` | | ☐ | | | `gbr_tak_tussenvoegsel` | `varchar2` | | ☐ | | | `gbr_tak_voorletters` | `varchar2` | | ☐ | | | `gbr_tak_voornaam` | `varchar2` | | ☐ | | | `gbr_tak_werk_afdeling` | `varchar2` | | ☐ | | | `gbr_tak_werk_tel` | `varchar2` | | ☐ | | | `gbr_uur_aanmeld_code` | `varchar2` | | ☐ | | | `gbr_uur_accordeur_uren_vlag` | `char` | | ☐ | | | `gbr_uur_achternaam` | `varchar2` | | ☐ | | | `gbr_uur_email_adres_workflow` | `varchar2` | | ☐ | | | `gbr_uur_email_adres` | `varchar2` | | ☐ | | | `gbr_uur_functie` | `varchar2` | | ☐ | | | `gbr_uur_geslacht_ind` | `char` | | ☐ | | | `gbr_uur_id` | `int64` | | ☐ | | | `gbr_uur_initialen` | `varchar2` | | ☐ | | | `gbr_uur_naam` | `varchar2` | | ☐ | | | `gbr_uur_pasfoto_url_ult` | `varchar2` | | ☐ | | | `gbr_uur_pasfoto_url` | `varchar2` | | ☐ | | | `gbr_uur_personeelsnummer` | `varchar2` | | ☐ | | | `gbr_uur_taakhouder_vlag` | `char` | | ☐ | | | `gbr_uur_tussenvoegsel` | `varchar2` | | ☐ | | | `gbr_uur_voorletters` | `varchar2` | | ☐ | | | `gbr_uur_voornaam` | `varchar2` | | ☐ | | | `gbr_uur_werk_afdeling` | `varchar2` | | ☐ | | | `gbr_uur_werk_tel` | `varchar2` | | ☐ | | | `gss_code` | `varchar2` | | ☐ | | | `gss_id` | `int64` | | ☐ | | | `gss_label` | `varchar2` | | ☐ | | | `gss_omschrijving` | `varchar2` | | ☐ | | | `hpt_afgesloten_vlag` | `char` | | ☐ | | | `hpt_code_kort` | `varchar2` | | ☐ | | | `hpt_code` | `varchar2` | | ☐ | | | `hpt_datum_expose` | `datetime` | | ☐ | | | `hpt_gemeente` | `varchar2` | | ☐ | | | `hpt_id` | `int64` | | ☐ | | | `hpt_ikoon_url` | `varchar2` | | ☐ | | | `hpt_logo_url` | `varchar2` | | ☐ | | | `hpt_naam` | `varchar2` | | ☐ | | | `hpt_overschot_comp_ind` | `char` | | ☐ | | | `hpt_projectvorm_ind` | `char` | | ☐ | | | `hpt_sorteer_volgorde` | `varchar2` | | ☐ | | | `hpt_volledige_naam` | `varchar2` | | ☐ | | | `lnd_code` | `varchar2` | | ☐ | | | `lnd_id` | `int64` | | ☐ | | | `lnd_omschrijving_i18n` | `varchar2` | | ☐ | | | `lnd_omschrijving` | `varchar2` | | ☐ | | | `lop_id` | `int64` | | ☑ | | | `lop_ikoon_url` | `varchar2` | | ☐ | | | `lop_label` | `varchar2` | | ☑ | | | `lpe_code` | `varchar2` | | ☑ | | | `lpe_id` | `int64` | | ☑ | | | `lpe_ikoon_url` | `varchar2` | | ☐ | | | `lpe_label` | `varchar2` | | ☑ | | | `lpm_code` | `varchar2` | | ☑ | | | `lpm_id` | `int64` | | ☑ | | | `lpm_ikoon_url` | `varchar2` | | ☐ | | | `lpm_label` | `varchar2` | | ☑ | | | `lpn_code` | `varchar2` | | ☑ | | | `lpn_id` | `int64` | | ☑ | | | `lpn_ikoon_url` | `varchar2` | | ☐ | | | `lpn_label` | `varchar2` | | ☑ | | | `lps_code` | `varchar2` | | ☑ | | | `lps_id` | `int64` | | ☑ | | | `lps_ikoon_url` | `varchar2` | | ☐ | | | `lps_label` | `varchar2` | | ☑ | | | `lst_id` | `int64` | | ☑ | | | `lst_ikoon_url` | `varchar2` | | ☐ | | | `lst_label` | `varchar2` | | ☑ | | | `lvr_klt_adres_regel_1` | `varchar2` | | ☐ | | | `lvr_klt_adres_regel_2` | `varchar2` | | ☐ | | | `lvr_klt_btw_nummer` | `varchar2` | | ☐ | | | `lvr_klt_code` | `varchar2` | | ☐ | | | `lvr_klt_fax_tel` | `varchar2` | | ☐ | | | `lvr_klt_id` | `int64` | | ☐ | | | `lvr_klt_ikoon_url_ult` | `varchar2` | | ☐ | | | `lvr_klt_ikoon_url` | `varchar2` | | ☐ | | | `lvr_klt_klant_actief_vlag` | `char` | | ☐ | | | `lvr_klt_klant_vlag` | `char` | | ☐ | | | `lvr_klt_kvk_nummer` | `varchar2` | | ☐ | | | `lvr_klt_land` | `varchar2` | | ☐ | | | `lvr_klt_logo_url` | `varchar2` | | ☐ | | | `lvr_klt_naam_kort` | `varchar2` | | ☐ | | | `lvr_klt_naam` | `varchar2` | | ☐ | | | `lvr_klt_plaats` | `varchar2` | | ☐ | | | `lvr_klt_postcode` | `varchar2` | | ☐ | | | `lvr_klt_project_entiteit_vlag` | `char` | | ☐ | | | `lvr_klt_statutaire_naam` | `varchar2` | | ☐ | | | `lvr_klt_website_url` | `varchar2` | | ☐ | | | `lvr_klt_werk_tel` | `varchar2` | | ☐ | | | `lvr_pe_adres_regel_1` | `varchar2` | | ☐ | | | `lvr_pe_adres_regel_2` | `varchar2` | | ☐ | | | `lvr_pe_btw_nummer` | `varchar2` | | ☐ | | | `lvr_pe_code` | `varchar2` | | ☑ | | | `lvr_pe_fax_tel` | `varchar2` | | ☐ | | | `lvr_pe_id` | `int64` | | ☑ | | | `lvr_pe_ikoon_url_ult` | `varchar2` | | ☐ | | | `lvr_pe_ikoon_url` | `varchar2` | | ☐ | | | `lvr_pe_klant_vlag` | `char` | | ☑ | | | `lvr_pe_kvk_nummer` | `varchar2` | | ☐ | | | `lvr_pe_label` | `varchar2` | | ☐ | | | `lvr_pe_land` | `varchar2` | | ☐ | | | `lvr_pe_logo_url_ult` | `varchar2` | | ☐ | | | `lvr_pe_logo_url` | `varchar2` | | ☐ | | | `lvr_pe_naam_kort` | `varchar2` | | ☐ | | | `lvr_pe_naam` | `varchar2` | | ☑ | | | `lvr_pe_pjt_ent_actief_vlag` | `char` | | ☑ | | | `lvr_pe_plaats` | `varchar2` | | ☐ | | | `lvr_pe_postcode` | `varchar2` | | ☐ | | | `lvr_pe_project_entiteit_vlag` | `char` | | ☑ | | | `lvr_pe_statutaire_naam` | `varchar2` | | ☐ | | | `lvr_pe_website_url` | `varchar2` | | ☐ | | | `lvr_pe_werk_tel` | `varchar2` | | ☐ | | | `mat_gbr_aanmeld_code` | `varchar2` | | ☐ | | | `mat_gbr_naam` | `varchar2` | | ☐ | | | `mat_id` | `decimal` | | ☐ | | | `mat_logo_bkg_url` | `varchar2` | | ☐ | | | `mat_request_prefix` | `varchar2` | | ☐ | | | `mat_request_url_hoofdmenu` | `varchar2` | | ☐ | | | `mat_request_url` | `varchar2` | | ☐ | | | `mat_rol_alle_pjt_wijzigen_vlag` | `varchar2` | | ☐ | | | `mat_server_prefix_url` | `varchar2` | | ☐ | | | `mat_tijdstip` | `varchar2` | | ☐ | | | `pae_id` | `decimal` | | ☐ | | | `pae_wijzigen_toegestaan_vlag` | `varchar2` | | ☐ | | | `pgp_code` | `varchar2` | | ☑ | | | `pgp_id` | `int64` | | ☑ | | | `pgp_ikoon_url` | `varchar2` | | ☐ | | | `pgp_label` | `varchar2` | | ☐ | | | `pgp_omschrijving` | `varchar2` | | ☑ | | | `pjt_aangemaakt_door` | `varchar2` | | ☑ | | | `pjt_aangemaakt_in` | `varchar2` | | ☑ | | | `pjt_aantal_garages` | `int32` | | ☐ | | | `pjt_aantal_m2_grond` | `int32` | | ☐ | | | `pjt_aantal_m2_kantoren` | `int32` | | ☐ | | | `pjt_aantal_m2_overige` | `int32` | | ☐ | | | `pjt_aantal_m2_winkels` | `int32` | | ☐ | | | `pjt_aantal_woningen` | `int32` | | ☐ | | | `pjt_admin_derden_vlag` | `char` | | ☑ | | | `pjt_adres_regel_1` | `varchar2` | | ☐ | | | `pjt_adres_regel_2` | `varchar2` | | ☐ | | | `pjt_afgesloten_vlag` | `char` | | ☑ | | | `pjt_bedrag_voorziening` | `decimal` | | ☐ | | | `pjt_bedrag_vrijgeg_budget` | `decimal` | | ☑ | | | `pjt_bedrag_vrwcht_inv` | `decimal` | | ☐ | | | `pjt_bijgewerkt_door` | `varchar2` | | ☑ | | | `pjt_bijgewerkt_in` | `varchar2` | | ☑ | | | `pjt_code_con` | `varchar2` | | ☐ | | | `pjt_code_kort` | `varchar2` | | ☐ | | | `pjt_code` | `varchar2` | | ☑ | | | `pjt_datum_aangemaakt` | `datetime` | | ☑ | | | `pjt_datum_aankoop_grond` | `datetime` | | ☐ | | | `pjt_datum_bijgewerkt` | `datetime` | | ☑ | | | `pjt_datum_bouwk_oplever` | `datetime` | | ☐ | | | `pjt_datum_einde_verkoop` | `datetime` | | ☐ | | | `pjt_datum_expose` | `datetime` | | ☐ | | | `pjt_datum_gepl_einde_verkoop` | `datetime` | | ☐ | | | `pjt_datum_gepl_start_oplvrng` | `datetime` | | ☐ | | | `pjt_datum_gepl_start_verkoop` | `datetime` | | ☐ | | | `pjt_datum_geplande_oplvrng` | `datetime` | | ☐ | | | `pjt_datum_geplande_start` | `datetime` | | ☐ | | | `pjt_datum_ingang_status_invoer` | `datetime` | | ☐ | | | `pjt_datum_ingang_status` | `datetime` | | ☑ | | | `pjt_datum_intrf_bijgewerkt` | `datetime` | | ☐ | | | `pjt_datum_intrf_geladen` | `datetime` | | ☐ | | | `pjt_datum_laatste_review` | `datetime` | | ☐ | | | `pjt_datum_start_bouw` | `datetime` | | ☐ | | | `pjt_datum_start_oplvrng` | `datetime` | | ☐ | | | `pjt_datum_start_verkoop` | `datetime` | | ☐ | | | `pjt_datum_volgende_review` | `datetime` | | ☐ | | | `pjt_definitie_tekst_l` | `clob` | | ☐ | | | `pjt_gemeente` | `varchar2` | | ☑ | | | `pjt_gm_adres` | `varchar2` | | ☐ | | | `pjt_groep_ikoon_url_ult` | `varchar2` | | ☐ | | | `pjt_groep_ikoon_url` | `varchar2` | | ☐ | | | `pjt_grond_positie` | `varchar2` | | ☐ | | | `pjt_id` | `int64` | | ☑ | | | `pjt_ikoon_url` | `varchar2` | | ☐ | | | `pjt_job_seq_geladen` | `int64` | | ☐ | | | `pjt_juridische_eenheid` | `varchar2` | | ☑ | | | `pjt_klassificatie_reeks_c` | `clob` | | ☐ | | | `pjt_klassificatie_reeks` | `clob` | | ☐ | | | `pjt_kolom_soort` | `varchar2` | | ☐ | | | `pjt_kolom_xml` | `xmltype` | | ☐ | | | `pjt_kolom1` | `varchar2` | | ☐ | | | `pjt_kolom10` | `varchar2` | | ☐ | | | `pjt_kolom2` | `varchar2` | | ☐ | | | `pjt_kolom3` | `varchar2` | | ☐ | | | `pjt_kolom4` | `varchar2` | | ☐ | | | `pjt_kolom5` | `varchar2` | | ☐ | | | `pjt_kolom6` | `varchar2` | | ☐ | | | `pjt_kolom7` | `varchar2` | | ☐ | | | `pjt_kolom8` | `varchar2` | | ☐ | | | `pjt_kolom9` | `varchar2` | | ☐ | | | `pjt_logo_url_ult` | `varchar2` | | ☐ | | | `pjt_logo_url` | `varchar2` | | ☐ | | | `pjt_naam` | `varchar2` | | ☑ | | | `pjt_nk` | `varchar2` | | ☑ | | | `pjt_omschrijving` | `varchar2` | | ☐ | | | `pjt_orig_system_group` | `varchar2` | | ☐ | | | `pjt_orig_system_reference` | `varchar2` | | ☐ | | | `pjt_overhead_vlag` | `char` | | ☑ | | | `pjt_overschot_comp_ctt_ind` | `char` | | ☑ | | | `pjt_overschot_comp_ind` | `char` | | ☑ | | | `pjt_partitie` | `int64` | | ☐ | | | `pjt_patroon_factuur_partijen` | `varchar2` | | ☑ | | | `pjt_patroon_opdrachtnemers` | `varchar2` | | ☑ | | | `pjt_projectvorm_ind` | `char` | | ☑ | | | `pjt_provincie` | `varchar2` | | ☐ | | | `pjt_rapportage_groep` | `varchar2` | | ☑ | | | `pjt_referentie_klant` | `varchar2` | | ☐ | | | `pjt_referentie_leverancier` | `varchar2` | | ☐ | | | `pjt_risico_percentage` | `decimal` | | ☑ | | | `pjt_samenwerking_met` | `varchar2` | | ☐ | | | `pjt_sessie_aangemaakt` | `varchar2` | | ☑ | | | `pjt_sessie_bijgewerkt` | `varchar2` | | ☑ | | | `pjt_sjabloon_omschrijving` | `varchar2` | | ☐ | | | `pjt_sjabloon_vlag` | `char` | | ☑ | | | `pjt_slagings_percentage` | `decimal` | | ☐ | | | `pjt_sorteer_volgorde` | `varchar2` | | ☑ | | | `pjt_status_ikoon_url_ult` | `varchar2` | | ☐ | | | `pjt_status_ikoon_url` | `varchar2` | | ☐ | | | `pjt_status_ind` | `char` | | ☑ | | | `pjt_status_tekst_l` | `clob` | | ☐ | | | `pjt_transactie_aangemaakt` | `int64` | | ☑ | | | `pjt_transactie_bijgewerkt` | `int64` | | ☑ | | | `pjt_urenbasis_vlag` | `char` | | ☑ | | | `pjt_volgnummer_prefix` | `varchar2` | | ☐ | | | `pjt_volledige_naam` | `varchar2` | | ☑ | | | `pjt_vrij_veld_1` | `varchar2` | | ☐ | | | `pjt_vrij_veld_2` | `varchar2` | | ☐ | | | `pjt_website_url` | `varchar2` | | ☐ | | | `pss_code` | `varchar2` | | ☑ | | | `pss_eind_status_vlag` | `char` | | ☑ | | | `pss_id` | `int64` | | ☑ | | | `pss_ikoon_url` | `varchar2` | | ☐ | | | `pss_label` | `varchar2` | | ☐ | | | `pss_niet_eind_status_uren_vlag` | `char` | | ☑ | | | `pss_omschrijving` | `varchar2` | | ☑ | | | `pss_sorteer_volgorde` | `int64` | | ☑ | | | `pzr_code` | `varchar2` | | ☑ | | | `red_code` | `varchar2` | | ☐ | | | `red_deler` | `int64` | | ☐ | | | `red_id` | `int64` | | ☐ | | | `red_omschrijving` | `varchar2` | | ☐ | | | `red_weergave_masker` | `varchar2` | | ☐ | | | `tak_bedrag_vaste_prijs` | `decimal` | | ☐ | | | `tak_code` | `varchar2` | | ☐ | | | `tak_datum_deadline` | `datetime` | | ☐ | | | `tak_groep_ikoon_url_ult` | `varchar2` | | ☐ | | | `tak_id` | `int64` | | ☐ | | | `tak_label` | `varchar2` | | ☐ | | | `tak_omschrijving` | `varchar2` | | ☐ | | | `tak_status_ikoon_url_ult` | `varchar2` | | ☐ | | | `tak_uren_resterende_inspanning` | `decimal` | | ☐ | | | `tak_uren_verwachte_inspanning` | `decimal` | | ☐ | | | `tce_apart_tonen_vlag` | `char` | | ☐ | | | `tce_code` | `varchar2` | | ☐ | | | `tce_id` | `int64` | | ☐ | | | `tce_ikoon_url` | `varchar2` | | ☐ | | | `tce_omschrijving` | `varchar2` | | ☐ | | | `tce_weging` | `int64` | | ☐ | | | `tss_code` | `varchar2` | | ☐ | | | `tss_deadline_mail_vlag` | `char` | | ☐ | | | `tss_eind_status_vlag` | `char` | | ☐ | | | `tss_goedgekeurd_vlag` | `char` | | ☐ | | | `tss_id` | `int64` | | ☐ | | | `tss_ikoon_url` | `varchar2` | | ☐ | | | `tss_label` | `varchar2` | | ☐ | | | `tss_niet_eindsts_tne_vlag` | `char` | | ☐ | | | `tss_omschrijving` | `varchar2` | | ☐ | | | `tss_sorteer_volgorde` | `int64` | | ☐ | | | `tss_voortgang_percentage` | `int16` | | ☐ | | | `tss_weging` | `int64` | | ☐ | |