Units |
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 Units are shown below. Each column has an SQL data type.
Name |
Data Type |
Label |
Required |
Documentation |
---|---|---|---|---|
action_requested |
string |
|
☐ |
|
bce_btw_percentage |
double |
|
☐ |
|
bce_code |
string |
|
☐ |
|
bce_id |
int64 |
|
☐ |
|
bce_omschrijving |
string |
|
☐ |
|
cdi_o_code |
string |
|
☐ |
|
cdi_o_id |
int64 |
|
☐ |
|
cdi_o_koppel_ind |
string |
|
☐ |
|
cdi_o_omschrijving |
string |
|
☐ |
|
dsk_aantal_documenten |
int32 |
|
☐ |
|
dsk_id |
int64 |
|
☐ |
|
dsk_label_nn |
string |
|
☐ |
|
dsk_meerdere_aanwezig |
string |
|
☐ |
|
dsk_ref_sleutel |
int64 |
|
☐ |
|
dsk_ref_tabel |
string |
|
☐ |
|
dsk_som_bestand_omvang_c |
string |
|
☐ |
|
gce_code |
string |
|
☐ |
|
gce_id |
int64 |
|
☐ |
|
gce_omschrijving |
string |
|
☐ |
|
kbg_code |
string |
|
☐ |
|
kbg_dagen_betalingstermijn |
int64 |
|
☐ |
|
kbg_id |
int64 |
|
☐ |
|
kbg_omschrijving |
string |
|
☐ |
|
kbg_uitsmeer_methode_ind |
string |
|
☐ |
|
khg_code |
string |
|
☐ |
|
khg_id |
int64 |
|
☐ |
|
khg_kosten_opbrengst_ind |
string |
|
☐ |
|
khg_omschrijving |
string |
|
☐ |
|
kpt_code |
string |
|
☐ |
|
kpt_id |
int64 |
|
☐ |
|
kpt_omschrijving |
string |
|
☐ |
|
kvg_code |
string |
|
☐ |
|
kvg_id |
int64 |
|
☐ |
|
kvg_omschrijving |
string |
|
☐ |
|
lvr_dlr_adres_regel_1 |
string |
|
☐ |
|
lvr_dlr_adres_regel_2 |
string |
|
☐ |
|
lvr_dlr_btw_nummer |
string |
|
☐ |
|
lvr_dlr_code |
string |
|
☐ |
|
lvr_dlr_fax_tel |
string |
|
☐ |
|
lvr_dlr_id |
int64 |
|
☐ |
|
lvr_dlr_ikoon_url_ult |
string |
|
☐ |
|
lvr_dlr_ikoon_url |
string |
|
☐ |
|
lvr_dlr_klant_vlag |
string |
|
☐ |
|
lvr_dlr_kvk_nummer |
string |
|
☐ |
|
lvr_dlr_land |
string |
|
☐ |
|
lvr_dlr_logo_url |
string |
|
☐ |
|
lvr_dlr_naam_kort |
string |
|
☐ |
|
lvr_dlr_naam |
string |
|
☐ |
|
lvr_dlr_plaats |
string |
|
☐ |
|
lvr_dlr_postcode |
string |
|
☐ |
|
lvr_dlr_project_entiteit_vlag |
string |
|
☐ |
|
lvr_dlr_statutaire_naam |
string |
|
☐ |
|
lvr_dlr_website_url |
string |
|
☐ |
|
lvr_dlr_werk_tel |
string |
|
☐ |
|
lvr_egr_adres_regel_1 |
string |
|
☐ |
|
lvr_egr_adres_regel_2 |
string |
|
☐ |
|
lvr_egr_btw_nummer |
string |
|
☐ |
|
lvr_egr_code |
string |
|
☐ |
|
lvr_egr_fax_tel |
string |
|
☐ |
|
lvr_egr_id |
int64 |
|
☐ |
|
lvr_egr_ikoon_url_ult |
string |
|
☐ |
|
lvr_egr_ikoon_url |
string |
|
☐ |
|
lvr_egr_klant_vlag |
string |
|
☐ |
|
lvr_egr_kvk_nummer |
string |
|
☐ |
|
lvr_egr_land |
string |
|
☐ |
|
lvr_egr_logo_url |
string |
|
☐ |
|
lvr_egr_naam_kort |
string |
|
☐ |
|
lvr_egr_naam |
string |
|
☐ |
|
lvr_egr_plaats |
string |
|
☐ |
|
lvr_egr_postcode |
string |
|
☐ |
|
lvr_egr_project_entiteit_vlag |
string |
|
☐ |
|
lvr_egr_statutaire_naam |
string |
|
☐ |
|
lvr_egr_website_url |
string |
|
☐ |
|
lvr_egr_werk_tel |
string |
|
☐ |
|
lvr_fbt_adres_regel_1 |
string |
|
☐ |
|
lvr_fbt_adres_regel_2 |
string |
|
☐ |
|
lvr_fbt_btw_nummer |
string |
|
☐ |
|
lvr_fbt_code |
string |
|
☐ |
|
lvr_fbt_fax_tel |
string |
|
☐ |
|
lvr_fbt_id |
int64 |
|
☐ |
|
lvr_fbt_ikoon_url_ult |
string |
|
☐ |
|
lvr_fbt_ikoon_url |
string |
|
☐ |
|
lvr_fbt_klant_vlag |
string |
|
☐ |
|
lvr_fbt_kvk_nummer |
string |
|
☐ |
|
lvr_fbt_land |
string |
|
☐ |
|
lvr_fbt_logo_url |
string |
|
☐ |
|
lvr_fbt_naam_kort |
string |
|
☐ |
|
lvr_fbt_naam |
string |
|
☐ |
|
lvr_fbt_plaats |
string |
|
☐ |
|
lvr_fbt_postcode |
string |
|
☐ |
|
lvr_fbt_project_entiteit_vlag |
string |
|
☐ |
|
lvr_fbt_statutaire_naam |
string |
|
☐ |
|
lvr_fbt_website_url |
string |
|
☐ |
|
lvr_fbt_werk_tel |
string |
|
☐ |
|
lvr_gbr_adres_regel_1 |
string |
|
☐ |
|
lvr_gbr_adres_regel_2 |
string |
|
☐ |
|
lvr_gbr_btw_nummer |
string |
|
☐ |
|
lvr_gbr_code |
string |
|
☐ |
|
lvr_gbr_fax_tel |
string |
|
☐ |
|
lvr_gbr_id |
int64 |
|
☐ |
|
lvr_gbr_ikoon_url_ult |
string |
|
☐ |
|
lvr_gbr_ikoon_url |
string |
|
☐ |
|
lvr_gbr_klant_vlag |
string |
|
☐ |
|
lvr_gbr_kvk_nummer |
string |
|
☐ |
|
lvr_gbr_land |
string |
|
☐ |
|
lvr_gbr_logo_url |
string |
|
☐ |
|
lvr_gbr_naam_kort |
string |
|
☐ |
|
lvr_gbr_naam |
string |
|
☐ |
|
lvr_gbr_plaats |
string |
|
☐ |
|
lvr_gbr_postcode |
string |
|
☐ |
|
lvr_gbr_project_entiteit_vlag |
string |
|
☐ |
|
lvr_gbr_statutaire_naam |
string |
|
☐ |
|
lvr_gbr_website_url |
string |
|
☐ |
|
lvr_gbr_werk_tel |
string |
|
☐ |
|
lvr_lvr_adres_regel_1 |
string |
|
☐ |
|
lvr_lvr_adres_regel_2 |
string |
|
☐ |
|
lvr_lvr_btw_nummer |
string |
|
☐ |
|
lvr_lvr_code |
string |
|
☐ |
|
lvr_lvr_fax_tel |
string |
|
☐ |
|
lvr_lvr_id |
int64 |
|
☐ |
|
lvr_lvr_ikoon_url_ult |
string |
|
☐ |
|
lvr_lvr_ikoon_url |
string |
|
☐ |
|
lvr_lvr_klant_vlag |
string |
|
☐ |
|
lvr_lvr_kvk_nummer |
string |
|
☐ |
|
lvr_lvr_land |
string |
|
☐ |
|
lvr_lvr_logo_url |
string |
|
☐ |
|
lvr_lvr_naam_kort |
string |
|
☐ |
|
lvr_lvr_naam |
string |
|
☐ |
|
lvr_lvr_plaats |
string |
|
☐ |
|
lvr_lvr_postcode |
string |
|
☐ |
|
lvr_lvr_project_entiteit_vlag |
string |
|
☐ |
|
lvr_lvr_statutaire_naam |
string |
|
☐ |
|
lvr_lvr_website_url |
string |
|
☐ |
|
lvr_lvr_werk_tel |
string |
|
☐ |
|
tsa_code |
string |
|
☐ |
|
tsa_id |
int64 |
|
☐ |
|
tsa_omschrijving |
string |
|
☐ |
|
unt_aangemaakt_door |
string |
|
☑ |
|
unt_aangemaakt_in |
string |
|
☑ |
|
unt_aantal_kg_gewicht |
decimal |
|
☐ |
|
unt_aantal_m1_breedte |
decimal |
|
☐ |
|
unt_aantal_m1_hoogte |
decimal |
|
☐ |
|
unt_aantal_m1_lengte |
decimal |
|
☐ |
|
unt_aantal_m2_grond |
int32 |
|
☐ |
|
unt_aantal_m2_ruimte |
int32 |
|
☐ |
|
unt_aantal_m3_ruimte |
int32 |
|
☐ |
|
unt_aantal_units |
int32 |
|
☐ |
|
unt_bedrag_inkoopprijs |
double |
|
☐ |
|
unt_bijgewerkt_door |
string |
|
☑ |
|
unt_bijgewerkt_in |
string |
|
☑ |
|
unt_contact_url |
string |
|
☐ |
|
unt_datum_aangemaakt |
datetime |
|
☑ |
|
unt_datum_bijgewerkt |
datetime |
|
☑ |
|
unt_datum_buiten_gebruik |
datetime |
|
☐ |
|
unt_datum_einde_garantie |
datetime |
|
☐ |
|
unt_datum_einde_gebruiksrecht |
datetime |
|
☐ |
|
unt_datum_einde_productie |
datetime |
|
☐ |
|
unt_datum_einde_vlg_mut_pde |
datetime |
|
☐ |
|
unt_datum_ingebruikstelling |
datetime |
|
☐ |
|
unt_datum_intrf_bijgewerkt |
datetime |
|
☐ |
|
unt_datum_intrf_geladen |
datetime |
|
☐ |
|
unt_datum_ontvangen |
datetime |
|
☐ |
|
unt_datum_start_garantie |
datetime |
|
☐ |
|
unt_datum_start_gebruiksrecht |
datetime |
|
☐ |
|
unt_datum_start_productie |
datetime |
|
☐ |
|
unt_datum_start_transport |
datetime |
|
☐ |
|
unt_datum_start_vlg_mut_pde |
datetime |
|
☐ |
|
unt_datum_verwerving |
datetime |
|
☐ |
|
unt_deelbaar_vlag |
string |
|
☑ |
|
unt_dichtheid |
decimal |
|
☐ |
|
unt_facebook_adres |
string |
|
☐ |
|
unt_gebruikt_vlag |
string |
|
☑ |
|
unt_googleplus_adres |
string |
|
☐ |
|
unt_hoofd_vlag |
string |
|
☐ |
|
unt_id |
int64 |
|
☑ |
|
unt_ikoon_url_ult |
string |
|
☐ |
|
unt_ikoon_url |
string |
|
☐ |
|
unt_job_seq_geladen |
int64 |
|
☐ |
|
unt_klassificatie_reeks |
string |
|
☐ |
|
unt_kolom_soort |
string |
|
☐ |
|
unt_kolom_xml |
string |
|
☐ |
|
unt_kolom1 |
string |
|
☐ |
|
unt_kolom10 |
string |
|
☐ |
|
unt_kolom2 |
string |
|
☐ |
|
unt_kolom3 |
string |
|
☐ |
|
unt_kolom4 |
string |
|
☐ |
|
unt_kolom5 |
string |
|
☐ |
|
unt_kolom6 |
string |
|
☐ |
|
unt_kolom7 |
string |
|
☐ |
|
unt_kolom8 |
string |
|
☐ |
|
unt_kolom9 |
string |
|
☐ |
|
unt_kopieerbaar_vlag |
string |
|
☑ |
|
unt_label |
string |
|
☐ |
|
unt_leverancier_code |
string |
|
☐ |
|
unt_leverancier_sn |
string |
|
☐ |
|
unt_locatie |
string |
|
☐ |
|
unt_nk |
string |
|
☐ |
|
unt_notities_vertrouwelijk_l |
string |
|
☐ |
|
unt_omschrijving |
string |
|
☑ |
|
unt_orig_system_group |
string |
|
☐ |
|
unt_orig_system_reference |
string |
|
☐ |
|
unt_partitie |
int64 |
|
☑ |
|
unt_referentie_leverancier |
string |
|
☐ |
|
unt_seo_naam |
string |
|
☐ |
|
unt_seo_omschrijving_2000 |
string |
|
☐ |
|
unt_seo_omschrijving_250 |
string |
|
☐ |
|
unt_seo_omschrijving_45 |
string |
|
☐ |
|
unt_seo_omschrijving_450 |
string |
|
☐ |
|
unt_seo_omschrijving_80 |
string |
|
☐ |
|
unt_seo_omschrijving |
string |
|
☐ |
|
unt_seo_pagina_pad |
string |
|
☐ |
|
unt_seo_pagina_titel |
string |
|
☐ |
|
unt_seo_usp |
string |
|
☐ |
|
unt_serienummer |
string |
|
☑ |
|
unt_sessie_aangemaakt |
string |
|
☑ |
|
unt_sessie_bijgewerkt |
string |
|
☑ |
|
unt_sorteer_volgorde |
int64 |
|
☐ |
|
unt_speciale_opmerking_vlag |
string |
|
☑ |
|
unt_speciale_opmerking |
string |
|
☐ |
|
unt_toelichting_l |
string |
|
☐ |
|
unt_transactie_aangemaakt |
int64 |
|
☑ |
|
unt_transactie_bijgewerkt |
int64 |
|
☑ |
|
unt_verkoop_code |
string |
|
☐ |
|
unt_verkoop_merk |
string |
|
☐ |
|
unt_verkoopbaar_vlag |
string |
|
☑ |
|
unt_versie |
string |
|
☐ |
|
unt_verwerkbaar_vlag |
string |
|
☑ |
|
unt_volledige_code |
int64 |
|
☑ |
|
unt_voorraad_vlag |
string |
|
☑ |
|
unt_vpl_verkoopprijs_vlag |
string |
|
☑ |
|
unt_website_url |
string |
|
☐ |
|
unt0_deelbaar_vlag |
string |
|
☑ |
|
unt0_id |
int64 |
|
☑ |
|
unt0_ikoon_url |
string |
|
☐ |
|
unt0_kopieerbaar_vlag |
string |
|
☑ |
|
unt0_omschrijving |
string |
|
☑ |
|
unt0_serienummer |
string |
|
☑ |
|
unt0_verkoopbaar_vlag |
string |
|
☑ |
|
unt0_voorraad_vlag |
string |
|
☑ |
|
unt0_vpl_verkoopprijs_vlag |
string |
|
☑ |
|
usp_code |
string |
|
☑ |
|
usp_id |
int64 |
|
☑ |
|
usp_omschrijving |
string |
|
☑ |
|
ust_code |
string |
|
☑ |
|
ust_id |
int64 |
|
☑ |
|
ust_ikoon_url |
string |
|
☐ |
|
ust_omschrijving |
string |
|
☑ |
|
ust_vpl_verkoopprijs_vlag |
string |
|
☑ |
|
30-05-2024 13:58 Version 24.0.193-PROD+4785