# ConceptInvoiceLines - 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 `ConceptInvoiceLines` 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` | | ☑ | | | `btn_aantal_dagen` | `int32` | | ☑ | | | `btn_code` | `varchar2` | | ☑ | | | `btn_id` | `int64` | | ☑ | | | `btn_koppel_ind` | `char` | | ☑ | | | `btn_omschrijving` | `varchar2` | | ☑ | | | `cdi_code` | `varchar2` | | ☑ | | | `cdi_id` | `int64` | | ☑ | | | `cdi_koppel_ind` | `char` | | ☑ | | | `cdi_omschrijving` | `varchar2` | | ☑ | | | `cfl_aangemaakt_door` | `varchar2` | | ☑ | | | `cfl_aangemaakt_in` | `varchar2` | | ☑ | | | `cfl_aantal_eenheden` | `decimal` | | ☑ | | | `cfl_bedrag_btw` | `decimal` | | ☑ | | | `cfl_bedrag_eenheid` | `decimal` | | ☑ | | | `cfl_bedrag_incl_btw` | `decimal` | | ☐ | | | `cfl_bedrag_netto_incl_btw` | `decimal` | | ☐ | | | `cfl_bedrag_netto` | `decimal` | | ☐ | | | `cfl_bedrag` | `decimal` | | ☑ | | | `cfl_bijgewerkt_door` | `varchar2` | | ☑ | | | `cfl_bijgewerkt_in` | `varchar2` | | ☑ | | | `cfl_datum_aangemaakt` | `datetime` | | ☑ | | | `cfl_datum_bijgewerkt` | `datetime` | | ☑ | | | `cfl_datum_doorgestuurd` | `datetime` | | ☐ | | | `cfl_datum_einde` | `datetime` | | ☐ | | | `cfl_datum_goedgekeurd` | `datetime` | | ☐ | | | `cfl_datum_intrf_bijgewerkt` | `datetime` | | ☐ | | | `cfl_datum_intrf_geladen` | `datetime` | | ☐ | | | `cfl_datum_start` | `datetime` | | ☐ | | | `cfl_dekkingsgraad_percentage` | `decimal` | | ☑ | | | `cfl_doorgestuurd_vlag` | `char` | | ☑ | | | `cfl_goedgekeurd_vlag` | `char` | | ☑ | | | `cfl_groep_nn` | `varchar2` | | ☐ | | | `cfl_groep` | `varchar2` | | ☐ | | | `cfl_id` | `int64` | | ☑ | | | `cfl_job_seq_geladen` | `int64` | | ☐ | | | `cfl_kolom_soort` | `varchar2` | | ☐ | | | `cfl_kolom1` | `varchar2` | | ☐ | | | `cfl_kolom10` | `varchar2` | | ☐ | | | `cfl_kolom2` | `varchar2` | | ☐ | | | `cfl_kolom3` | `varchar2` | | ☐ | | | `cfl_kolom4` | `varchar2` | | ☐ | | | `cfl_kolom5` | `varchar2` | | ☐ | | | `cfl_kolom6` | `varchar2` | | ☐ | | | `cfl_kolom7` | `varchar2` | | ☐ | | | `cfl_kolom8` | `varchar2` | | ☐ | | | `cfl_kolom9` | `varchar2` | | ☐ | | | `cfl_korting_percentage` | `decimal` | | ☑ | | | `cfl_label` | `varchar2` | | ☐ | | | `cfl_nk` | `varchar2` | | ☐ | | | `cfl_omschrijving` | `varchar2` | | ☐ | | | `cfl_orig_system_group` | `varchar2` | | ☐ | | | `cfl_orig_system_reference` | `varchar2` | | ☐ | | | `cfl_partitie` | `int64` | | ☑ | | | `cfl_ref_detail_nk` | `varchar2` | | ☐ | | | `cfl_ref_detail_orig_system_ref` | `varchar2` | | ☐ | | | `cfl_ref_detail_sleutel` | `int64` | | ☑ | | | `cfl_ref_detail_tabel` | `varchar2` | | ☑ | | | `cfl_ref_nk` | `varchar2` | | ☐ | | | `cfl_ref_orig_system_reference` | `varchar2` | | ☐ | | | `cfl_ref_sleutel` | `int64` | | ☑ | | | `cfl_ref_tabel` | `varchar2` | | ☑ | | | `cfl_referentie_tegenpartij` | `varchar2` | | ☐ | | | `cfl_seq` | `int64` | | ☑ | | | `cfl_sessie_aangemaakt` | `varchar2` | | ☑ | | | `cfl_sessie_bijgewerkt` | `varchar2` | | ☑ | | | `cfl_toelichting` | `varchar2` | | ☐ | | | `cfl_transactie_aangemaakt` | `int64` | | ☑ | | | `cfl_transactie_bijgewerkt` | `int64` | | ☑ | | | `cfl_volgnummer_in_groep` | `varchar2` | | ☐ | | | `cfl_volgnummer` | `varchar2` | | ☑ | | | `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_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` | `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_drr_aanmeld_code` | `varchar2` | | ☐ | | | `gbr_drr_accordeur_uren_vlag` | `char` | | ☐ | | | `gbr_drr_email_adres_workflow` | `varchar2` | | ☐ | | | `gbr_drr_email_adres` | `varchar2` | | ☐ | | | `gbr_drr_geslacht_ind` | `char` | | ☐ | | | `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_geslacht_ind` | `char` | | ☐ | | | `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` | | ☐ | | | `gbr_uur_aanmeld_code` | `varchar2` | | ☐ | | | `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` | `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` | | ☐ | | | `gce_code` | `varchar2` | | ☐ | | | `gce_id` | `int64` | | ☐ | | | `gce_omschrijving` | `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` | | ☐ | | | `kbg_code` | `varchar2` | | ☑ | | | `kbg_dagen_betalingstermijn` | `int64` | | ☐ | | | `kbg_id` | `int64` | | ☑ | | | `kbg_label` | `varchar2` | | ☐ | | | `kbg_omschrijving` | `varchar2` | | ☑ | | | `kbg_uitsmeer_methode_ind` | `char` | | ☑ | | | `khg_code` | `varchar2` | | ☑ | | | `khg_id` | `int64` | | ☑ | | | `khg_kosten_opbrengst_ind` | `char` | | ☑ | | | `khg_omschrijving` | `varchar2` | | ☑ | | | `kps_bedrag_budget_na_bvg` | `decimal` | | ☑ | | | `kps_bedrag_budget` | `decimal` | | ☑ | | | `kps_bedrag_deelbudget_som` | `decimal` | | ☐ | | | `kps_datum_verw_verval_einde` | `datetime` | | ☐ | | | `kps_datum_verwacht_verval` | `datetime` | | ☐ | | | `kps_id` | `int64` | | ☑ | | | `kps_overschot_comp_ind` | `char` | | ☑ | | | `kps_uitsmeer_methode_ind` | `char` | | ☐ | | | `kpt_code` | `varchar2` | | ☐ | | | `kpt_id` | `int64` | | ☐ | | | `kpt_omschrijving` | `varchar2` | | ☐ | | | `kvg_code` | `varchar2` | | ☑ | | | `kvg_id` | `int64` | | ☑ | | | `kvg_omschrijving` | `varchar2` | | ☑ | | | `lcdl_code` | `varchar2` | | ☐ | | | `lcdl_id` | `int64` | | ☐ | | | `lcdl_ikoon_url` | `varchar2` | | ☐ | | | `lcdl_label` | `varchar2` | | ☐ | | | `lcl_code` | `varchar2` | | ☐ | | | `lcl_id` | `int64` | | ☐ | | | `lcl_ikoon_url` | `varchar2` | | ☐ | | | `lcl_label` | `varchar2` | | ☐ | | | `lvr_adres_regel_1` | `varchar2` | | ☐ | | | `lvr_adres_regel_2` | `varchar2` | | ☐ | | | `lvr_btw_nummer` | `varchar2` | | ☐ | | | `lvr_code` | `varchar2` | | ☑ | | | `lvr_datum_intrf_geladen` | `datetime` | | ☐ | | | `lvr_fax_tel` | `varchar2` | | ☐ | | | `lvr_id_klant` | `int64` | | ☐ | | | `lvr_id_pe` | `int64` | | ☑ | | | `lvr_id` | `int64` | | ☑ | | | `lvr_ikoon_url_ult` | `varchar2` | | ☐ | | | `lvr_ikoon_url` | `varchar2` | | ☐ | | | `lvr_klant_actief_vlag` | `char` | | ☑ | | | `lvr_klant_vlag` | `char` | | ☑ | | | `lvr_kvk_nummer` | `varchar2` | | ☐ | | | `lvr_land` | `varchar2` | | ☐ | | | `lvr_logo_url` | `varchar2` | | ☐ | | | `lvr_naam_kort` | `varchar2` | | ☐ | | | `lvr_naam` | `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_land` | `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` | | ☐ | | | `lvr_plaats` | `varchar2` | | ☐ | | | `lvr_postcode` | `varchar2` | | ☐ | | | `lvr_project_entiteit_vlag` | `char` | | ☑ | | | `lvr_statutaire_naam` | `varchar2` | | ☐ | | | `lvr_volledig_adres` | `varchar2` | | ☐ | | | `lvr_website_url` | `varchar2` | | ☐ | | | `lvr_werk_tel` | `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_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_erp` | `varchar2` | | ☐ | | | `pjt_code_kort` | `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_klassificatie_reeks` | `clob` | | ☐ | | | `pjt_logo_url_ult` | `varchar2` | | ☐ | | | `pjt_naam_con` | `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_rapportage_groep` | `varchar2` | | ☑ | | | `pjt_referentie_klant` | `varchar2` | | ☐ | | | `pjt_sorteer_volgorde` | `varchar2` | | ☑ | | | `pjt_volgnummer_prefix` | `varchar2` | | ☐ | | | `pjt_volledige_naam` | `varchar2` | | ☑ | | | `plt_code` | `varchar2` | | ☑ | | | `plt_id` | `int64` | | ☑ | | | `plt_koppel_ind` | `char` | | ☑ | | | `plt_omschrijving` | `varchar2` | | ☑ | | | `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` | | ☐ | | | `tak_bedrag_vaste_prijs` | `decimal` | | ☐ | | | `tak_code` | `varchar2` | | ☐ | | | `tak_groep_ikoon_url_ult` | `varchar2` | | ☐ | | | `tak_id` | `int64` | | ☐ | | | `tak_label` | `varchar2` | | ☐ | | | `tak_omschrijving` | `varchar2` | | ☐ | | | `takunt_deelbaar_vlag` | `char` | | ☐ | | | `takunt_id` | `int64` | | ☐ | | | `takunt_ikoon_url` | `varchar2` | | ☐ | | | `takunt_kopieerbaar_vlag` | `char` | | ☐ | | | `takunt_label` | `varchar2` | | ☐ | | | `takunt_omschrijving` | `varchar2` | | ☐ | | | `takunt_serienummer` | `varchar2` | | ☐ | | | `takunt_verkoopbaar_vlag` | `char` | | ☐ | | | `takunt_voorraad_vlag` | `char` | | ☐ | | | `takunt_vpl_verkoopprijs_vlag` | `char` | | ☐ | | | `takust_code` | `varchar2` | | ☐ | | | `takust_id` | `int64` | | ☐ | | | `takust_ikoon_url` | `varchar2` | | ☐ | | | `takust_omschrijving` | `varchar2` | | ☐ | | | `takust_vpl_verkoopprijs_vlag` | `char` | | ☐ | | | `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` | | ☐ | | | `tut_id` | `int64` | | ☐ | | | `tut_seq` | `int64` | | ☐ | | | `unt_deelbaar_vlag` | `char` | | ☑ | | | `unt_id` | `int64` | | ☑ | | | `unt_ikoon_url_ult` | `varchar2` | | ☐ | | | `unt_ikoon_url` | `varchar2` | | ☐ | | | `unt_kopieerbaar_vlag` | `char` | | ☑ | | | `unt_label` | `varchar2` | | ☐ | | | `unt_omschrijving` | `varchar2` | | ☑ | | | `unt_serienummer` | `varchar2` | | ☑ | | | `unt_verkoopbaar_vlag` | `char` | | ☑ | | | `unt_volledige_code` | `int64` | | ☑ | | | `unt_voorraad_vlag` | `char` | | ☑ | | | `unt_vpl_verkoopprijs_vlag` | `char` | | ☑ | | | `ust_code` | `varchar2` | | ☑ | | | `ust_id` | `int64` | | ☑ | | | `ust_ikoon_url` | `varchar2` | | ☐ | | | `ust_omschrijving` | `varchar2` | | ☑ | | | `ust_vpl_verkoopprijs_vlag` | `char` | | ☑ | | | `uur_commentaar` | `varchar2` | | ☐ | | | `uur_datum_start` | `datetime` | | ☐ | | | `uur_id` | `int64` | | ☐ | | | `uur_locatie` | `varchar2` | | ☐ | | | `uur_sec_inspanning` | `int32` | | ☐ | | | `uur_seq` | `int64` | | ☐ | | | `uur_uren_inspanning` | `decimal` | | ☐ | |