# BudgetMovements - 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 `BudgetMovements` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `action_requested` | `varchar2` | | ☐ | | | `bvg_aangemaakt_door` | `varchar2` | | ☑ | | | `bvg_aangemaakt_in` | `varchar2` | | ☑ | | | `bvg_bedrag_budget_mutatie` | `decimal` | | ☑ | | | `bvg_bijgewerkt_door` | `varchar2` | | ☑ | | | `bvg_bijgewerkt_in` | `varchar2` | | ☑ | | | `bvg_datum_aangemaakt` | `datetime` | | ☑ | | | `bvg_datum_bijgewerkt` | `datetime` | | ☑ | | | `bvg_datum_intrf_bijgewerkt` | `datetime` | | ☐ | | | `bvg_datum_intrf_geladen` | `datetime` | | ☐ | | | `bvg_id` | `int64` | | ☑ | | | `bvg_job_seq_geladen` | `int64` | | ☐ | | | `bvg_kolom_soort` | `varchar2` | | ☐ | | | `bvg_kolom1` | `varchar2` | | ☐ | | | `bvg_kolom10` | `varchar2` | | ☐ | | | `bvg_kolom2` | `varchar2` | | ☐ | | | `bvg_kolom3` | `varchar2` | | ☐ | | | `bvg_kolom4` | `varchar2` | | ☐ | | | `bvg_kolom5` | `varchar2` | | ☐ | | | `bvg_kolom6` | `varchar2` | | ☐ | | | `bvg_kolom7` | `varchar2` | | ☐ | | | `bvg_kolom8` | `varchar2` | | ☐ | | | `bvg_kolom9` | `varchar2` | | ☐ | | | `bvg_nk` | `varchar2` | | ☐ | | | `bvg_orig_system_group` | `varchar2` | | ☐ | | | `bvg_orig_system_reference` | `varchar2` | | ☐ | | | `bvg_partitie` | `int64` | | ☑ | | | `bvg_seq` | `int64` | | ☑ | | | `bvg_sessie_aangemaakt` | `varchar2` | | ☑ | | | `bvg_sessie_bijgewerkt` | `varchar2` | | ☑ | | | `bvg_toelichting_l` | `clob` | | ☐ | | | `bvg_transactie_aangemaakt` | `int64` | | ☑ | | | `bvg_transactie_bijgewerkt` | `int64` | | ☑ | | | `cig_consolideren_vlag` | `varchar2` | | ☐ | | | `cig_datum_rapportage` | `datetime` | | ☐ | | | `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_v_aanmeld_code` | `varchar2` | | ☐ | | | `gbr_amr_v_accordeur_uren_vlag` | `char` | | ☐ | | | `gbr_amr_v_email_adres_workflow` | `varchar2` | | ☐ | | | `gbr_amr_v_email_adres` | `varchar2` | | ☐ | | | `gbr_amr_v_id` | `int64` | | ☐ | | | `gbr_amr_v_initialen` | `varchar2` | | ☐ | | | `gbr_amr_v_naam` | `varchar2` | | ☐ | | | `gbr_amr_v_taakhouder_vlag` | `char` | | ☐ | | | `gbr_amr_v_taakmelder_vlag` | `char` | | ☐ | | | `gbr_amr_v_tijdschrijver_vlag` | `char` | | ☐ | | | `gbr_amr_v_werk_toestel` | `varchar2` | | ☐ | | | `gbr_drr_v_aanmeld_code` | `varchar2` | | ☐ | | | `gbr_drr_v_accordeur_uren_vlag` | `char` | | ☐ | | | `gbr_drr_v_email_adres_workflow` | `varchar2` | | ☐ | | | `gbr_drr_v_email_adres` | `varchar2` | | ☐ | | | `gbr_drr_v_id` | `int64` | | ☐ | | | `gbr_drr_v_initialen` | `varchar2` | | ☐ | | | `gbr_drr_v_naam` | `varchar2` | | ☐ | | | `gbr_drr_v_taakhouder_vlag` | `char` | | ☐ | | | `gbr_drr_v_taakmelder_vlag` | `char` | | ☐ | | | `gbr_drr_v_tijdschrijver_vlag` | `char` | | ☐ | | | `gbr_drr_v_werk_toestel` | `varchar2` | | ☐ | | | `gbr_por_v_aanmeld_code` | `varchar2` | | ☐ | | | `gbr_por_v_accordeur_uren_vlag` | `char` | | ☐ | | | `gbr_por_v_email_adres_workflow` | `varchar2` | | ☐ | | | `gbr_por_v_email_adres` | `varchar2` | | ☐ | | | `gbr_por_v_id` | `int64` | | ☐ | | | `gbr_por_v_initialen` | `varchar2` | | ☐ | | | `gbr_por_v_naam` | `varchar2` | | ☐ | | | `gbr_por_v_taakhouder_vlag` | `char` | | ☐ | | | `gbr_por_v_taakmelder_vlag` | `char` | | ☐ | | | `gbr_por_v_tijdschrijver_vlag` | `char` | | ☐ | | | `gbr_por_v_werk_toestel` | `varchar2` | | ☐ | | | `hpt_n_afgesloten_vlag` | `char` | | ☐ | | | `hpt_n_code_kort` | `varchar2` | | ☐ | | | `hpt_n_code` | `varchar2` | | ☐ | | | `hpt_n_datum_expose` | `datetime` | | ☐ | | | `hpt_n_gemeente` | `varchar2` | | ☐ | | | `hpt_n_id` | `int64` | | ☐ | | | `hpt_n_ikoon_url` | `varchar2` | | ☐ | | | `hpt_n_naam` | `varchar2` | | ☐ | | | `hpt_n_overschot_comp_ind` | `char` | | ☐ | | | `hpt_n_projectvorm_ind` | `char` | | ☐ | | | `hpt_n_sorteer_volgorde` | `varchar2` | | ☐ | | | `hpt_n_volledige_naam` | `varchar2` | | ☐ | | | `hpt_v_afgesloten_vlag` | `char` | | ☐ | | | `hpt_v_code` | `varchar2` | | ☐ | | | `hpt_v_datum_expose` | `datetime` | | ☐ | | | `hpt_v_gemeente` | `varchar2` | | ☐ | | | `hpt_v_id` | `int64` | | ☐ | | | `hpt_v_naam` | `varchar2` | | ☐ | | | `hpt_v_overschot_comp_ind` | `char` | | ☐ | | | `hpt_v_projectvorm_ind` | `char` | | ☐ | | | `hpt_v_sorteer_volgorde` | `varchar2` | | ☐ | | | `hpt_v_volledige_naam` | `varchar2` | | ☐ | | | `kbg_n_code` | `varchar2` | | ☑ | | | `kbg_n_dagen_betalingstermijn` | `int64` | | ☐ | | | `kbg_n_id` | `int64` | | ☑ | | | `kbg_n_label` | `varchar2` | | ☐ | | | `kbg_n_omschrijving` | `varchar2` | | ☑ | | | `kbg_n_uitsmeer_methode_ind` | `char` | | ☑ | | | `kbg_v_code` | `varchar2` | | ☑ | | | `kbg_v_dagen_betalingstermijn` | `int64` | | ☐ | | | `kbg_v_id` | `int64` | | ☑ | | | `kbg_v_label` | `varchar2` | | ☐ | | | `kbg_v_omschrijving` | `varchar2` | | ☑ | | | `kbg_v_uitsmeer_methode_ind` | `char` | | ☑ | | | `khg_n_code` | `varchar2` | | ☑ | | | `khg_n_id` | `int64` | | ☑ | | | `khg_n_kosten_opbrengst_ind` | `char` | | ☑ | | | `khg_n_omschrijving` | `varchar2` | | ☑ | | | `khg_v_code` | `varchar2` | | ☑ | | | `khg_v_id` | `int64` | | ☑ | | | `khg_v_kosten_opbrengst_ind` | `char` | | ☑ | | | `khg_v_omschrijving` | `varchar2` | | ☑ | | | `kps_n_bedrag_budget` | `decimal` | | ☑ | | | `kps_n_bedrag_deelbudget_som` | `decimal` | | ☐ | | | `kps_n_id` | `int64` | | ☑ | | | `kps_v_bedrag_budget` | `decimal` | | ☑ | | | `kps_v_bedrag_deelbudget_som` | `decimal` | | ☐ | | | `kps_v_id` | `int64` | | ☑ | | | `kvg_n_code` | `varchar2` | | ☑ | | | `kvg_n_id` | `int64` | | ☑ | | | `kvg_n_omschrijving` | `varchar2` | | ☑ | | | `kvg_v_code` | `varchar2` | | ☑ | | | `kvg_v_id` | `int64` | | ☑ | | | `kvg_v_omschrijving` | `varchar2` | | ☑ | | | `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_v_id` | `int64` | | ☐ | | | `pae_v_wijzigen_toegestaan_vlag` | `char` | | ☐ | | | `pgp_v_code` | `varchar2` | | ☐ | | | `pgp_v_id` | `int64` | | ☐ | | | `pgp_v_omschrijving` | `varchar2` | | ☐ | | | `pjt_n_afgesloten_vlag` | `char` | | ☑ | | | `pjt_n_code_con` | `varchar2` | | ☐ | | | `pjt_n_code_kort` | `varchar2` | | ☐ | | | `pjt_n_code` | `varchar2` | | ☑ | | | `pjt_n_datum_expose` | `datetime` | | ☐ | | | `pjt_n_gemeente` | `varchar2` | | ☑ | | | `pjt_n_id` | `int64` | | ☑ | | | `pjt_n_ikoon_url` | `varchar2` | | ☐ | | | `pjt_n_label` | `varchar2` | | ☐ | | | `pjt_n_naam` | `varchar2` | | ☑ | | | `pjt_n_overschot_comp_ind` | `char` | | ☑ | | | `pjt_n_projectvorm_ind` | `char` | | ☑ | | | `pjt_n_sorteer_volgorde` | `varchar2` | | ☑ | | | `pjt_n_volgnummer_prefix` | `varchar2` | | ☐ | | | `pjt_n_volledige_naam` | `varchar2` | | ☑ | | | `pjt_v_afgesloten_vlag` | `char` | | ☑ | | | `pjt_v_code_con` | `varchar2` | | ☐ | | | `pjt_v_code` | `varchar2` | | ☑ | | | `pjt_v_datum_aankoop_grond` | `datetime` | | ☐ | | | `pjt_v_datum_bouwk_oplever` | `datetime` | | ☐ | | | `pjt_v_datum_expose` | `datetime` | | ☐ | | | `pjt_v_datum_geplande_oplvrng` | `datetime` | | ☐ | | | `pjt_v_datum_geplande_start` | `datetime` | | ☐ | | | `pjt_v_datum_laatste_review` | `datetime` | | ☐ | | | `pjt_v_datum_start_bouw` | `datetime` | | ☐ | | | `pjt_v_datum_start_verkoop` | `datetime` | | ☐ | | | `pjt_v_gemeente` | `varchar2` | | ☑ | | | `pjt_v_id` | `int64` | | ☑ | | | `pjt_v_ikoon_url_ult` | `varchar2` | | ☐ | | | `pjt_v_ikoon_url` | `varchar2` | | ☐ | | | `pjt_v_naam` | `varchar2` | | ☑ | | | `pjt_v_overschot_comp_ind` | `char` | | ☑ | | | `pjt_v_patroon_factuur_partijen` | `varchar2` | | ☑ | | | `pjt_v_patroon_opdrachtnemers` | `varchar2` | | ☑ | | | `pjt_v_projectvorm_ind` | `char` | | ☑ | | | `pjt_v_pzr_code` | `varchar2` | | ☑ | | | `pjt_v_referentie_klant` | `varchar2` | | ☐ | | | `pjt_v_sorteer_volgorde` | `varchar2` | | ☑ | | | `pjt_v_volgnummer_prefix` | `varchar2` | | ☐ | | | `pjt_v_volledige_naam` | `varchar2` | | ☑ | | | `pss_n_id` | `int64` | | ☑ | | | `pss_v_id` | `int64` | | ☐ | | | `red_code` | `varchar2` | | ☐ | | | `red_deler` | `decimal` | | ☐ | | | `red_omschrijving` | `varchar2` | | ☐ | | | `red_weergave_masker` | `varchar2` | | ☐ | |