Please enable JavaScript to view this site.

Dummy Forums

Dummy Data Model

Navigation: Schema: Demo > Tables

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

string

 

☐

 

dsk_aantal_documenten_c

string

 

☐

 

dsk_aantal_documenten

int32

 

☐

 

dsk_eerste_document_param1

decimal

 

☐

 

dsk_eerste_document_url

string

 

☐

 

dsk_eerste_document

string

 

☐

 

dsk_id

int64

 

☐

 

dsk_laatste_document_param1

decimal

 

☐

 

dsk_laatste_document_url

string

 

☐

 

dsk_laatste_document

string

 

☐

 

dsk_label_nn

string

 

☐

 

dsk_meerdere_aanwezig

string

 

☐

 

dsk_ref_sleutel

int64

 

☐

 

dsk_ref_tabel

string

 

☐

 

dsk_som_bestand_omvang_c

string

 

☐

 

ftr_aangemaakt_door

string

 

☑

 

ftr_aangemaakt_in

string

 

☑

 

ftr_bijgewerkt_door

string

 

☑

 

ftr_bijgewerkt_in

string

 

☑

 

ftr_code

string

 

☑

 

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

string

 

☐

 

ftr_kolom1

string

 

☐

 

ftr_kolom10

string

 

☐

 

ftr_kolom2

string

 

☐

 

ftr_kolom3

string

 

☐

 

ftr_kolom4

string

 

☐

 

ftr_kolom5

string

 

☐

 

ftr_kolom6

string

 

☐

 

ftr_kolom7

string

 

☐

 

ftr_kolom8

string

 

☐

 

ftr_kolom9

string

 

☐

 

ftr_label

string

 

☐

 

ftr_nk

string

 

☑

 

ftr_omschrijving

string

 

☐

 

ftr_orig_system_group

string

 

☐

 

ftr_orig_system_reference

string

 

☐

 

ftr_partitie

int64

 

☑

 

ftr_referentie_leverancier

string

 

☐

 

ftr_sessie_aangemaakt

string

 

☑

 

ftr_sessie_bijgewerkt

string

 

☑

 

ftr_sync_met_erp_vlag

string

 

☑

 

ftr_transactie_aangemaakt

int64

 

☑

 

ftr_transactie_bijgewerkt

int64

 

☑

 

gbr_cp_aanmeld_code

string

 

☐

 

gbr_cp_achternaam

string

 

☐

 

gbr_cp_email_adres_workflow

string

 

☐

 

gbr_cp_email_adres

string

 

☐

 

gbr_cp_functie

string

 

☐

 

gbr_cp_geslacht_ind

string

 

☐

 

gbr_cp_id

int64

 

☐

 

gbr_cp_initialen

string

 

☐

 

gbr_cp_naam

string

 

☐

 

gbr_cp_pasfoto_url

string

 

☐

 

gbr_cp_personeelsnummer

string

 

☐

 

gbr_cp_taakhouder_vlag

string

 

☐

 

gbr_cp_tussenvoegsel

string

 

☐

 

gbr_cp_voorletters

string

 

☐

 

gbr_cp_voornaam

string

 

☐

 

gbr_cp_werk_afdeling

string

 

☐

 

gbr_cp_werk_tel

string

 

☐

 

gbr_tak_aanmeld_code

string

 

☐

 

gbr_tak_achternaam

string

 

☐

 

gbr_tak_email_adres_workflow

string

 

☐

 

gbr_tak_email_adres

string

 

☐

 

gbr_tak_functie

string

 

☐

 

gbr_tak_geslacht_ind

string

 

☐

 

gbr_tak_id

int64

 

☐

 

gbr_tak_initialen

string

 

☐

 

gbr_tak_naam

string

 

☐

 

gbr_tak_pasfoto_url

string

 

☐

 

gbr_tak_personeelsnummer

string

 

☐

 

gbr_tak_taakhouder_vlag

string

 

☐

 

gbr_tak_tussenvoegsel

string

 

☐

 

gbr_tak_voorletters

string

 

☐

 

gbr_tak_voornaam

string

 

☐

 

gbr_tak_werk_afdeling

string

 

☐

 

gbr_tak_werk_tel

string

 

☐

 

lvr_adres_regel_1

string

 

☐

 

lvr_adres_regel_2

string

 

☐

 

lvr_btw_nummer

string

 

☐

 

lvr_code

string

 

☑

 

lvr_datum_intrf_geladen

datetime

 

☐

 

lvr_fax_tel

string

 

☐

 

lvr_id

int64

 

☑

 

lvr_ikoon_url_ult

string

 

☐

 

lvr_ikoon_url

string

 

☐

 

lvr_klant_actief_vlag

string

 

☑

 

lvr_klant_vlag

string

 

☑

 

lvr_kvk_nummer

string

 

☐

 

lvr_land

string

 

☐

 

lvr_logo_url

string

 

☐

 

lvr_naam_kort

string

 

☐

 

lvr_naam

string

 

☑

 

lvr_opdrachtnemer_actief_vlag

string

 

☑

 

lvr_opdrachtnemer_vlag

string

 

☑

 

lvr_pjt_ent_actief_vlag

string

 

☑

 

lvr_plaats

string

 

☐

 

lvr_postcode

string

 

☐

 

lvr_project_entiteit_vlag

string

 

☑

 

lvr_statutaire_naam

string

 

☐

 

lvr_website_url

string

 

☐

 

lvr_werk_tel

string

 

☐

 

tak_bedrag_vaste_prijs

double

 

☐

 

tak_code

string

 

☐

 

tak_datum_deadline

datetime

 

☐

 

tak_groep_ikoon_url_ult

string

 

☐

 

tak_id

int64

 

☐

 

tak_label

string

 

☐

 

tak_omschrijving

string

 

☐

 

tak_uren_resterende_inspanning

double

 

☐

 

tak_uren_verwachte_inspanning

double

 

☐

 

tce_apart_tonen_vlag

string

 

☐

 

tce_code

string

 

☐

 

tce_id

int64

 

☐

 

tce_ikoon_url

string

 

☐

 

tce_omschrijving

string

 

☐

 

tce_weging

int64

 

☐

 

tss_code

string

 

☐

 

tss_deadline_mail_vlag

string

 

☐

 

tss_eind_status_vlag

string

 

☐

 

tss_goedgekeurd_vlag

string

 

☐

 

tss_id

int64

 

☐

 

tss_ikoon_url

string

 

☐

 

tss_label

string

 

☐

 

tss_niet_eindsts_tne_vlag

string

 

☐

 

tss_omschrijving

string

 

☐

 

tss_sorteer_volgorde

int64

 

☐

 

tss_voortgang_percentage

int16

 

☐

 

tss_weging

int64

 

☐

 

 

30-05-2024 13:58 Version 24.0.193-PROD+4785

X

Important Safety and Usage Information

Intended Use and Limitations: This software, developed by Invantive, is designed to support a variety of business and information technology data processing functions, such as accounting, financial reporting an sales reporting. It is important to note that this software is not designed, tested, or approved for use in environments where malfunction or failure could lead to life-threatening situations or severe physical or environmental damage. This includes, but is not limited to:

  • Nuclear facilities: The software should not be used for operations or functions related to the control, maintenance, or operation of nuclear facilities.
  • Defense and Military Applications: This software is not suitable for use in defense-related applications, including but not limited to weaponry control, military strategy planning, or any other aspects of national defense.
  • Aviation: The software is not intended for use in the operation, navigation, or communication systems of any aircraft or air traffic control environments.
  • Healthcare and Medicine Production: This software should not be utilized for medical device operation, patient data analysis for critical health decisions, pharmaceutical production, or medical research where its failure or malfunction could impact patient health.
  • Chemical and Hazardous Material Handling: This software is not intended for the management, control, or operational aspects of chemical plants or hazardous material handling facilities. Any malfunction in software used in these settings could result in dangerous chemical spills, explosions, or environmental disasters.
  • Transportation and Traffic Control Systems: The software should not be used for the control, operation, or management of transportation systems, including railway signal controls, subway systems, or traffic light management. Malfunctions in such critical systems could lead to severe accidents and endanger public safety.
  • Energy Grid and Utility Control Systems: This software is not designed for the control or operation of energy grid systems, including electrical substations, renewable energy control systems, or water utility control systems. The failure of software in these areas could lead to significant power outages, water supply disruptions, or other public utility failures, potentially endangering communities and causing extensive damage.
  • Other High-Risk Environments: Any other critical infrastructure and environments where a failure of the software could result in significant harm to individuals or the environment.

User Responsibility: Users must ensure that they understand the intended use of the software and refrain from deploying it in any setting that falls outside of its designed purpose. It is the responsibility of the user to assess the suitability of the software for their intended application, especially in any scenarios that might pose a risk to life, health, or the environment.

Disclaimer of Liability: Invantive disclaims any responsibility for damage, injury, or legal consequences resulting from the use or misuse of this software in prohibited or unintended applications.
  
Disclaimer