---
title: "Budgets (Sample)"
language: de
source_language: en
translation_state: pending
canonical: https://documentation.invantive.eu/de/datamodels/dummy/Dummy.Demo.Budgets
original: https://documentation.invantive.eu/en/datamodels/dummy/Dummy.Demo.Budgets
updated: 2026-11-16T20:48:50Z
license: https://documentation.invantive.eu/de/
---

# Budgets: Sample

`read only`

- Katalog: `Dummy`
- Schema: `Demo`

Es können nur Daten abgerufen werden.

## Tabellenspalten

Die Spalten der Tabelle `Budgets` sind unten aufgeführt. Jede Spalte hat einen SQL-Datentyp. Beim Einfügen und Aktualisieren muss für jede erforderliche Spalte jederzeit ein neuer Wert angegeben werden der nicht Null ist.

| Name | Datentyp | Label | Required | Marks | Documentation |
|---|---|---|:---:|---|---|
| `action_requested` | `varchar2` |  | [ ] |  |  |
| `cig_consolideren_vlag` | `varchar2` |  | [ ] |  |  |
| `cig_datum_rapportage` | `datetime` |  | [ ] |  |  |
| `cig_datum_start_rapportage` | `datetime` |  | [ ] |  |  |
| `dsk_aantal_documenten` | `int32` |  | [ ] |  |  |
| `dsk_aantal_documenten_c` | `varchar2` |  | [ ] |  |  |
| `dsk_eerste_document` | `varchar2` |  | [ ] |  |  |
| `dsk_eerste_document_param1` | `decimal` |  | [ ] |  |  |
| `dsk_eerste_document_url` | `varchar2` |  | [ ] |  |  |
| `dsk_id` | `int64` |  | [ ] |  |  |
| `dsk_laatste_document` | `varchar2` |  | [ ] |  |  |
| `dsk_laatste_document_param1` | `decimal` |  | [ ] |  |  |
| `dsk_laatste_document_url` | `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_accordeur_uren_vlag` | `char` |  | [ ] |  |  |
| `gbr_amr_email_adres` | `varchar2` |  | [ ] |  |  |
| `gbr_amr_email_adres_workflow` | `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` | `varchar2` |  | [ ] |  |  |
| `gbr_drr_email_adres_workflow` | `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` | `varchar2` |  | [ ] |  |  |
| `gbr_por_email_adres_workflow` | `varchar2` |  | [ ] |  |  |
| `gbr_por_id` | `int64` |  | [ ] |  |  |
| `gbr_por_initialen` | `varchar2` |  | [ ] |  |  |
| `gbr_por_naam` | `varchar2` |  | [ ] |  |  |
| `gbr_por_taakhouder_vlag` | `char` |  | [ ] |  |  |
| `gbr_por_taakmelder_vlag` | `char` |  | [ ] |  |  |
| `gbr_por_tijdschrijver_vlag` | `char` |  | [ ] |  |  |
| `gbr_por_werk_toestel` | `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` |  | [ ] |  |  |
| `isg_ondertitel_logo_rapporten` | `varchar2` |  | [ ] |  |  |
| `kbg_code` | `varchar2` |  | [x] |  |  |
| `kbg_dagen_betalingstermijn` | `int64` |  | [ ] |  |  |
| `kbg_id` | `int64` |  | [x] |  |  |
| `kbg_label` | `varchar2` |  | [ ] |  |  |
| `kbg_omschrijving` | `varchar2` |  | [x] |  |  |
| `kbg_uitsmeer_methode_ind` | `char` |  | [x] |  |  |
| `khg_code` | `varchar2` |  | [x] |  |  |
| `khg_id` | `int64` |  | [x] |  |  |
| `khg_kosten_opbrengst_ind` | `char` |  | [x] |  |  |
| `khg_label` | `varchar2` |  | [ ] |  |  |
| `khg_omschrijving` | `varchar2` |  | [x] |  |  |
| `kps_aangemaakt_door` | `varchar2` |  | [x] |  |  |
| `kps_aangemaakt_in` | `varchar2` |  | [x] |  |  |
| `kps_bedrag_budget` | `decimal` |  | [x] |  |  |
| `kps_bedrag_budget_na_bvg` | `decimal` |  | [x] |  |  |
| `kps_bedrag_budget_vlgnd_expose` | `decimal` |  | [ ] |  |  |
| `kps_bedrag_deelbudget_som` | `decimal` |  | [ ] |  |  |
| `kps_bedrag_vrij_dbudget_na_bvg` | `decimal` |  | [ ] |  |  |
| `kps_bedrag_vrij_deelbudget` | `decimal` |  | [ ] |  |  |
| `kps_bijgewerkt_door` | `varchar2` |  | [x] |  |  |
| `kps_bijgewerkt_in` | `varchar2` |  | [x] |  |  |
| `kps_datum_aangemaakt` | `datetime` |  | [x] |  |  |
| `kps_datum_bijgewerkt` | `datetime` |  | [x] |  |  |
| `kps_datum_intrf_bijgewerkt` | `datetime` |  | [ ] |  |  |
| `kps_datum_intrf_geladen` | `datetime` |  | [ ] |  |  |
| `kps_datum_verw_verval_einde` | `datetime` |  | [ ] |  |  |
| `kps_datum_verwacht_verval` | `datetime` |  | [ ] |  |  |
| `kps_id` | `int64` |  | [x] |  |  |
| `kps_impliciet_toegevoegd_vlag` | `char` |  | [x] |  |  |
| `kps_job_seq_geladen` | `int64` |  | [ ] |  |  |
| `kps_kolom1` | `varchar2` |  | [ ] |  |  |
| `kps_kolom10` | `varchar2` |  | [ ] |  |  |
| `kps_kolom2` | `varchar2` |  | [ ] |  |  |
| `kps_kolom3` | `varchar2` |  | [ ] |  |  |
| `kps_kolom4` | `varchar2` |  | [ ] |  |  |
| `kps_kolom5` | `varchar2` |  | [ ] |  |  |
| `kps_kolom6` | `varchar2` |  | [ ] |  |  |
| `kps_kolom7` | `varchar2` |  | [ ] |  |  |
| `kps_kolom8` | `varchar2` |  | [ ] |  |  |
| `kps_kolom9` | `varchar2` |  | [ ] |  |  |
| `kps_kolom_soort` | `varchar2` |  | [ ] |  |  |
| `kps_nk` | `varchar2` |  | [ ] |  |  |
| `kps_orig_system_group` | `varchar2` |  | [ ] |  |  |
| `kps_orig_system_reference` | `varchar2` |  | [ ] |  |  |
| `kps_overschot_comp_ind` | `char` |  | [x] |  |  |
| `kps_partitie` | `int64` |  | [x] |  |  |
| `kps_sessie_aangemaakt` | `varchar2` |  | [x] |  |  |
| `kps_sessie_bijgewerkt` | `varchar2` |  | [x] |  |  |
| `kps_toelichting` | `varchar2` |  | [ ] |  |  |
| `kps_toelichting_saldo` | `varchar2` |  | [ ] |  |  |
| `kps_toelichting_volgend_expose` | `varchar2` |  | [ ] |  |  |
| `kps_transactie_aangemaakt` | `int64` |  | [x] |  |  |
| `kps_transactie_bijgewerkt` | `int64` |  | [x] |  |  |
| `kps_uitsmeer_methode_ind` | `char` |  | [ ] |  |  |
| `kvg_code` | `varchar2` |  | [x] |  |  |
| `kvg_id` | `int64` |  | [x] |  |  |
| `kvg_label` | `varchar2` |  | [ ] |  |  |
| `kvg_omschrijving` | `varchar2` |  | [x] |  |  |
| `lsk_id` | `int64` |  | [ ] |  |  |
| `lsk_ikoon_url` | `varchar2` |  | [ ] |  |  |
| `lsk_label` | `varchar2` |  | [ ] |  |  |
| `lue_code` | `varchar2` |  | [ ] |  |  |
| `lue_id` | `int64` |  | [ ] |  |  |
| `lue_ikoon_url` | `varchar2` |  | [ ] |  |  |
| `lue_label` | `varchar2` |  | [ ] |  |  |
| `lvr_id_klant` | `int64` |  | [ ] |  |  |
| `lvr_id_pe` | `int64` |  | [x] |  |  |
| `mat_cig_omschrijving` | `varchar2` |  | [ ] |  |  |
| `mat_cig_omschrijving_lang` | `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` | `varchar2` |  | [ ] |  |  |
| `mat_request_url_hoofdmenu` | `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` |  | [x] |  |  |
| `pjt_code` | `varchar2` |  | [x] |  |  |
| `pjt_code_con` | `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` |  | [x] |  |  |
| `pjt_id` | `int64` |  | [x] |  |  |
| `pjt_ikoon_url` | `varchar2` |  | [ ] |  |  |
| `pjt_ikoon_url_ult` | `varchar2` |  | [ ] |  |  |
| `pjt_klassificatie_reeks` | `clob` |  | [ ] |  |  |
| `pjt_logo_url_ult` | `varchar2` |  | [ ] |  |  |
| `pjt_naam` | `varchar2` |  | [x] |  |  |
| `pjt_naam_con` | `varchar2` |  | [ ] |  |  |
| `pjt_overschot_comp_ind` | `char` |  | [x] |  |  |
| `pjt_patroon_factuur_partijen` | `varchar2` |  | [x] |  |  |
| `pjt_patroon_opdrachtnemers` | `varchar2` |  | [x] |  |  |
| `pjt_projectvorm_ind` | `char` |  | [x] |  |  |
| `pjt_pzr_code` | `varchar2` |  | [x] |  |  |
| `pjt_rapportage_groep` | `varchar2` |  | [x] |  |  |
| `pjt_referentie_klant` | `varchar2` |  | [ ] |  |  |
| `pjt_sorteer_volgorde` | `varchar2` |  | [x] |  |  |
| `pjt_volgnummer_prefix` | `varchar2` |  | [ ] |  |  |
| `pjt_volledige_naam` | `varchar2` |  | [x] |  |  |
| `pss_code` | `varchar2` |  | [ ] |  |  |
| `pss_id` | `int64` |  | [ ] |  |  |
| `pss_ikoon_url` | `varchar2` |  | [ ] |  |  |
| `pss_omschrijving` | `varchar2` |  | [ ] |  |  |
| `red_code` | `varchar2` |  | [ ] |  |  |
| `red_deler` | `decimal` |  | [ ] |  |  |
| `red_omschrijving` | `varchar2` |  | [ ] |  |  |
| `red_weergave_masker` | `varchar2` |  | [ ] |  |  |


## Anmerkungen zu dieser Version

Was hat sich in den Tabellen, Spalten, Attributen und Funktionen des Treibers mit jeder neuen Version geändert:

- [Dummy](/de/release-notes/drivers?driver=dummy)
