# Invoices - 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 `Invoices` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `action_requested` | `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` | | ☐ | | | `ftr_aangemaakt_door` | `varchar2` | | ☑ | | | `ftr_aangemaakt_in` | `varchar2` | | ☑ | | | `ftr_bijgewerkt_door` | `varchar2` | | ☑ | | | `ftr_bijgewerkt_in` | `varchar2` | | ☑ | | | `ftr_code` | `varchar2` | | ☑ | | | `ftr_dagen_betalingstermijn` | `int64` | | ☐ | | | `ftr_datum_aangemaakt` | `datetime` | | ☑ | | | `ftr_datum_bijgewerkt` | `datetime` | | ☑ | | | `ftr_datum_geboekt` | `datetime` | | ☐ | | | `ftr_datum_gefactureerd` | `datetime` | | ☑ | | | `ftr_datum_intrf_bijgewerkt` | `datetime` | | ☐ | | | `ftr_datum_intrf_geladen` | `datetime` | | ☐ | | | `ftr_datum_verw_verval_einde` | `datetime` | | ☐ | | | `ftr_datum_verwacht_verval` | `datetime` | | ☐ | | | `ftr_id` | `int64` | | ☑ | | | `ftr_job_seq_geladen` | `int64` | | ☐ | | | `ftr_kolom_soort` | `varchar2` | | ☐ | | | `ftr_kolom1` | `varchar2` | | ☐ | | | `ftr_kolom10` | `varchar2` | | ☐ | | | `ftr_kolom2` | `varchar2` | | ☐ | | | `ftr_kolom3` | `varchar2` | | ☐ | | | `ftr_kolom4` | `varchar2` | | ☐ | | | `ftr_kolom5` | `varchar2` | | ☐ | | | `ftr_kolom6` | `varchar2` | | ☐ | | | `ftr_kolom7` | `varchar2` | | ☐ | | | `ftr_kolom8` | `varchar2` | | ☐ | | | `ftr_kolom9` | `varchar2` | | ☐ | | | `ftr_label` | `varchar2` | | ☐ | | | `ftr_nk` | `varchar2` | | ☑ | | | `ftr_omschrijving` | `varchar2` | | ☐ | | | `ftr_orig_system_group` | `varchar2` | | ☐ | | | `ftr_orig_system_reference` | `varchar2` | | ☐ | | | `ftr_partitie` | `int64` | | ☑ | | | `ftr_referentie_leverancier` | `varchar2` | | ☐ | | | `ftr_sessie_aangemaakt` | `varchar2` | | ☑ | | | `ftr_sessie_bijgewerkt` | `varchar2` | | ☑ | | | `ftr_sync_met_erp_vlag` | `char` | | ☑ | | | `ftr_transactie_aangemaakt` | `int64` | | ☑ | | | `ftr_transactie_bijgewerkt` | `int64` | | ☑ | | | `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_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` | | ☐ | | | `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` | `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_opdrachtnemer_actief_vlag` | `char` | | ☑ | | | `lvr_opdrachtnemer_vlag` | `char` | | ☑ | | | `lvr_pjt_ent_actief_vlag` | `char` | | ☑ | | | `lvr_plaats` | `varchar2` | | ☐ | | | `lvr_postcode` | `varchar2` | | ☐ | | | `lvr_project_entiteit_vlag` | `char` | | ☑ | | | `lvr_statutaire_naam` | `varchar2` | | ☐ | | | `lvr_website_url` | `varchar2` | | ☐ | | | `lvr_werk_tel` | `varchar2` | | ☐ | | | `tak_bedrag_vaste_prijs` | `double` | | ☐ | | | `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` | `double` | | ☐ | | | `tak_uren_verwachte_inspanning` | `double` | | ☐ | | | `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` | | ☐ | |