# CashflowProjections - 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 `CashflowProjections` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `cig_consolideren_vlag` | `varchar2` | | ☐ | | | `cig_datum_rapportage` | `datetime` | | ☐ | | | `gbr_amr_aanmeld_code` | `varchar2` | | ☐ | | | `gbr_amr_accordeur_uren_vlag` | `char` | | ☐ | | | `gbr_amr_email_adres_workflow` | `varchar2` | | ☐ | | | `gbr_amr_email_adres` | `varchar2` | | ☐ | | | `gbr_amr_id` | `int64` | | ☐ | | | `gbr_amr_initialen` | `varchar2` | | ☐ | | | `gbr_amr_naam` | `varchar2` | | ☐ | | | `gbr_amr_taakhouder_vlag` | `char` | | ☐ | | | `gbr_amr_taakmelder_vlag` | `char` | | ☐ | | | `gbr_amr_tijdschrijver_vlag` | `char` | | ☐ | | | `gbr_amr_werk_toestel` | `varchar2` | | ☐ | | | `gbr_drr_aanmeld_code` | `varchar2` | | ☐ | | | `gbr_drr_accordeur_uren_vlag` | `char` | | ☐ | | | `gbr_drr_email_adres_workflow` | `varchar2` | | ☐ | | | `gbr_drr_email_adres` | `varchar2` | | ☐ | | | `gbr_drr_id` | `int64` | | ☐ | | | `gbr_drr_initialen` | `varchar2` | | ☐ | | | `gbr_drr_naam` | `varchar2` | | ☐ | | | `gbr_drr_taakhouder_vlag` | `char` | | ☐ | | | `gbr_drr_taakmelder_vlag` | `char` | | ☐ | | | `gbr_drr_tijdschrijver_vlag` | `char` | | ☐ | | | `gbr_drr_werk_toestel` | `varchar2` | | ☐ | | | `gbr_por_aanmeld_code` | `varchar2` | | ☐ | | | `gbr_por_accordeur_uren_vlag` | `char` | | ☐ | | | `gbr_por_email_adres_workflow` | `varchar2` | | ☐ | | | `gbr_por_email_adres` | `varchar2` | | ☐ | | | `gbr_por_id` | `int64` | | ☐ | | | `gbr_por_initialen` | `varchar2` | | ☐ | | | `gbr_por_naam` | `varchar2` | | ☐ | | | `gbr_por_pasfoto_url_ult` | `varchar2` | | ☐ | | | `gbr_por_taakhouder_vlag` | `char` | | ☐ | | | `gbr_por_taakmelder_vlag` | `char` | | ☐ | | | `gbr_por_tijdschrijver_vlag` | `char` | | ☐ | | | `gbr_por_werk_toestel` | `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` | `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` | | ☐ | | | `hpt_afgesloten_vlag` | `char` | | ☐ | | | `hpt_code` | `varchar2` | | ☐ | | | `hpt_datum_expose` | `datetime` | | ☐ | | | `hpt_gemeente` | `varchar2` | | ☐ | | | `hpt_id` | `int64` | | ☐ | | | `hpt_naam` | `varchar2` | | ☐ | | | `hpt_overschot_comp_ind` | `char` | | ☐ | | | `hpt_projectvorm_ind` | `char` | | ☐ | | | `hpt_sorteer_volgorde` | `varchar2` | | ☐ | | | `hpt_volledige_naam` | `varchar2` | | ☐ | | | `kse_aangemaakt_door` | `varchar2` | | ☑ | | | `kse_aangemaakt_in` | `varchar2` | | ☑ | | | `kse_bedrag_budget_desinv` | `decimal` | | ☐ | | | `kse_bedrag_budget_investering` | `decimal` | | ☐ | | | `kse_bedrag_budget_resultaat` | `decimal` | | ☐ | | | `kse_bedrag_c0` | `decimal` | | ☐ | | | `kse_bedrag_genomen_resultaat` | `decimal` | | ☐ | | | `kse_bedrag_npv_excl_c0` | `decimal` | | ☐ | | | `kse_bedrag_npv` | `decimal` | | ☐ | | | `kse_bedrag_verw_desinv` | `decimal` | | ☐ | | | `kse_bedrag_verw_investering` | `decimal` | | ☐ | | | `kse_bedrag_verw_resultaat` | `decimal` | | ☐ | | | `kse_bijgewerkt_door` | `varchar2` | | ☑ | | | `kse_bijgewerkt_in` | `varchar2` | | ☑ | | | `kse_datum_aangemaakt` | `datetime` | | ☑ | | | `kse_datum_bijgewerkt` | `datetime` | | ☑ | | | `kse_datum_intrf_bijgewerkt` | `datetime` | | ☐ | | | `kse_datum_intrf_geladen` | `datetime` | | ☐ | | | `kse_datum_ltst_herberekening` | `datetime` | | ☐ | | | `kse_datum_ltst_uitgesmeerd` | `datetime` | | ☐ | | | `kse_datum_start_projectie` | `datetime` | | ☑ | | | `kse_id` | `int64` | | ☑ | | | `kse_job_seq_geladen` | `int64` | | ☐ | | | `kse_kolom_soort` | `varchar2` | | ☐ | | | `kse_kolom1` | `varchar2` | | ☐ | | | `kse_kolom10` | `varchar2` | | ☐ | | | `kse_kolom2` | `varchar2` | | ☐ | | | `kse_kolom3` | `varchar2` | | ☐ | | | `kse_kolom4` | `varchar2` | | ☐ | | | `kse_kolom5` | `varchar2` | | ☐ | | | `kse_kolom6` | `varchar2` | | ☐ | | | `kse_kolom7` | `varchar2` | | ☐ | | | `kse_kolom8` | `varchar2` | | ☐ | | | `kse_kolom9` | `varchar2` | | ☐ | | | `kse_label` | `varchar2` | | ☐ | | | `kse_nk` | `varchar2` | | ☐ | | | `kse_npv_percentage_c0` | `decimal` | | ☐ | | | `kse_npv_percentage` | `decimal` | | ☑ | | | `kse_orig_system_group` | `varchar2` | | ☐ | | | `kse_orig_system_reference` | `varchar2` | | ☐ | | | `kse_partitie` | `int64` | | ☑ | | | `kse_rente_opnemen_in_npv_vlag` | `char` | | ☑ | | | `kse_saldo_desinv` | `decimal` | | ☐ | | | `kse_saldo_investering` | `decimal` | | ☐ | | | `kse_saldo_resultaat` | `decimal` | | ☐ | | | `kse_sessie_aangemaakt` | `varchar2` | | ☑ | | | `kse_sessie_bijgewerkt` | `varchar2` | | ☑ | | | `kse_toelichting_in_kdl_vlag` | `char` | | ☑ | | | `kse_toelichting_in_ksl_vlag` | `char` | | ☑ | | | `kse_toelichting` | `varchar2` | | ☐ | | | `kse_transactie_aangemaakt` | `int64` | | ☑ | | | `kse_transactie_bijgewerkt` | `int64` | | ☑ | | | `kse_versie_sw_ltst_berekening` | `varchar2` | | ☑ | | | `kse_verzoek_beiden_vlag` | `char` | | ☐ | | | `kse_verzoek_herberekenen_vlag` | `char` | | ☐ | | | `kse_verzoek_uitsmeren_vlag` | `char` | | ☐ | | | `ksm_code` | `varchar2` | | ☑ | | | `ksm_id` | `int64` | | ☑ | | | `ksm_omschrijving_i18n` | `varchar2` | | ☐ | | | `ksm_omschrijving` | `varchar2` | | ☑ | | | `ksm_plsql_script_dist` | `varchar2` | | ☑ | | | `ksm_plsql_script` | `varchar2` | | ☑ | | | `lvr_id_klant` | `int64` | | ☐ | | | `lvr_id_pe` | `int64` | | ☑ | | | `mat_gbr_aanmeld_code` | `varchar2` | | ☐ | | | `mat_gbr_naam` | `varchar2` | | ☐ | | | `mat_id` | `decimal` | | ☐ | | | `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` | `int64` | | ☐ | | | `pae_wijzigen_toegestaan_vlag` | `char` | | ☐ | | | `pgp_code` | `varchar2` | | ☐ | | | `pgp_id` | `int64` | | ☐ | | | `pgp_omschrijving` | `varchar2` | | ☐ | | | `pjt_afgesloten_vlag` | `char` | | ☑ | | | `pjt_code_con` | `varchar2` | | ☐ | | | `pjt_code` | `varchar2` | | ☑ | | | `pjt_datum_aankoop_grond` | `datetime` | | ☐ | | | `pjt_datum_bouwk_oplever` | `datetime` | | ☐ | | | `pjt_datum_expose` | `datetime` | | ☐ | | | `pjt_datum_geplande_oplvrng` | `datetime` | | ☐ | | | `pjt_datum_geplande_start` | `datetime` | | ☐ | | | `pjt_datum_laatste_review` | `datetime` | | ☐ | | | `pjt_datum_start_bouw` | `datetime` | | ☐ | | | `pjt_datum_start_verkoop` | `datetime` | | ☐ | | | `pjt_gemeente` | `varchar2` | | ☑ | | | `pjt_id` | `int64` | | ☑ | | | `pjt_ikoon_url_ult` | `varchar2` | | ☐ | | | `pjt_ikoon_url` | `varchar2` | | ☐ | | | `pjt_naam` | `varchar2` | | ☑ | | | `pjt_overschot_comp_ind` | `char` | | ☑ | | | `pjt_patroon_factuur_partijen` | `varchar2` | | ☑ | | | `pjt_patroon_opdrachtnemers` | `varchar2` | | ☑ | | | `pjt_projectvorm_ind` | `char` | | ☑ | | | `pjt_pzr_code` | `varchar2` | | ☑ | | | `pjt_referentie_klant` | `varchar2` | | ☐ | | | `pjt_sorteer_volgorde` | `varchar2` | | ☑ | | | `pjt_volgnummer_prefix` | `varchar2` | | ☐ | | | `pjt_volledige_naam` | `varchar2` | | ☑ | | | `red_code` | `varchar2` | | ☐ | | | `red_deler` | `decimal` | | ☐ | | | `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_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` | | ☐ | |