---
title: "Invoices (Sample)"
language: en
source_language: en
translation_state: complete
canonical: https://documentation.invantive.eu/en/datamodels/dummy/Dummy.Demo.Invoices
original: https://documentation.invantive.eu/en/datamodels/dummy/Dummy.Demo.Invoices
updated: 2026-11-01T16:09:06Z
license: https://documentation.invantive.eu/en/
---

# Invoices: Sample

`read only`

- Catalog: `Dummy`
- Schema: `Demo`

Can only retrieve data.

## Table Columns

The columns of the table `Invoices` are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.

| Name | Data Type | Label | Required | Marks | Documentation |
|---|---|---|:---:|---|---|
| `action_requested` | `varchar2` |  | [ ] |  |  |
| `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` |  | [ ] |  |  |
| `ftr_aangemaakt_door` | `varchar2` |  | [x] |  |  |
| `ftr_aangemaakt_in` | `varchar2` |  | [x] |  |  |
| `ftr_bijgewerkt_door` | `varchar2` |  | [x] |  |  |
| `ftr_bijgewerkt_in` | `varchar2` |  | [x] |  |  |
| `ftr_code` | `varchar2` |  | [x] |  |  |
| `ftr_dagen_betalingstermijn` | `int64` |  | [ ] |  |  |
| `ftr_datum_aangemaakt` | `datetime` |  | [x] |  |  |
| `ftr_datum_bijgewerkt` | `datetime` |  | [x] |  |  |
| `ftr_datum_geboekt` | `datetime` |  | [ ] |  |  |
| `ftr_datum_gefactureerd` | `datetime` |  | [x] |  |  |
| `ftr_datum_intrf_bijgewerkt` | `datetime` |  | [ ] |  |  |
| `ftr_datum_intrf_geladen` | `datetime` |  | [ ] |  |  |
| `ftr_datum_verw_verval_einde` | `datetime` |  | [ ] |  |  |
| `ftr_datum_verwacht_verval` | `datetime` |  | [ ] |  |  |
| `ftr_id` | `int64` |  | [x] |  |  |
| `ftr_job_seq_geladen` | `int64` |  | [ ] |  |  |
| `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_kolom_soort` | `varchar2` |  | [ ] |  |  |
| `ftr_label` | `varchar2` |  | [ ] |  |  |
| `ftr_nk` | `varchar2` |  | [x] |  |  |
| `ftr_omschrijving` | `varchar2` |  | [ ] |  |  |
| `ftr_orig_system_group` | `varchar2` |  | [ ] |  |  |
| `ftr_orig_system_reference` | `varchar2` |  | [ ] |  |  |
| `ftr_partitie` | `int64` |  | [x] |  |  |
| `ftr_referentie_leverancier` | `varchar2` |  | [ ] |  |  |
| `ftr_sessie_aangemaakt` | `varchar2` |  | [x] |  |  |
| `ftr_sessie_bijgewerkt` | `varchar2` |  | [x] |  |  |
| `ftr_sync_met_erp_vlag` | `char` |  | [x] |  |  |
| `ftr_transactie_aangemaakt` | `int64` |  | [x] |  |  |
| `ftr_transactie_bijgewerkt` | `int64` |  | [x] |  |  |
| `gbr_cp_aanmeld_code` | `varchar2` |  | [ ] |  |  |
| `gbr_cp_achternaam` | `varchar2` |  | [ ] |  |  |
| `gbr_cp_email_adres` | `varchar2` |  | [ ] |  |  |
| `gbr_cp_email_adres_workflow` | `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` | `varchar2` |  | [ ] |  |  |
| `gbr_tak_email_adres_workflow` | `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` |  | [x] |  |  |
| `lvr_datum_intrf_geladen` | `datetime` |  | [ ] |  |  |
| `lvr_fax_tel` | `varchar2` |  | [ ] |  |  |
| `lvr_id` | `int64` |  | [x] |  |  |
| `lvr_ikoon_url` | `varchar2` |  | [ ] |  |  |
| `lvr_ikoon_url_ult` | `varchar2` |  | [ ] |  |  |
| `lvr_klant_actief_vlag` | `char` |  | [x] |  |  |
| `lvr_klant_vlag` | `char` |  | [x] |  |  |
| `lvr_kvk_nummer` | `varchar2` |  | [ ] |  |  |
| `lvr_land` | `varchar2` |  | [ ] |  |  |
| `lvr_logo_url` | `varchar2` |  | [ ] |  |  |
| `lvr_naam` | `varchar2` |  | [x] |  |  |
| `lvr_naam_kort` | `varchar2` |  | [ ] |  |  |
| `lvr_opdrachtnemer_actief_vlag` | `char` |  | [x] |  |  |
| `lvr_opdrachtnemer_vlag` | `char` |  | [x] |  |  |
| `lvr_pjt_ent_actief_vlag` | `char` |  | [x] |  |  |
| `lvr_plaats` | `varchar2` |  | [ ] |  |  |
| `lvr_postcode` | `varchar2` |  | [ ] |  |  |
| `lvr_project_entiteit_vlag` | `char` |  | [x] |  |  |
| `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` |  | [ ] |  |  |



## Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver:

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

