# 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` | `varchar2` | | ☐ | | | `bce_btw_percentage` | `double` | | ☐ | | | `bce_code` | `varchar2` | | ☐ | | | `bce_id` | `int64` | | ☐ | | | `bce_omschrijving` | `varchar2` | | ☐ | | | `cdi_o_code` | `varchar2` | | ☐ | | | `cdi_o_id` | `int64` | | ☐ | | | `cdi_o_koppel_ind` | `char` | | ☐ | | | `cdi_o_omschrijving` | `varchar2` | | ☐ | | | `dsk_aantal_documenten` | `int32` | | ☐ | | | `dsk_id` | `int64` | | ☐ | | | `dsk_label_nn` | `varchar2` | | ☐ | | | `dsk_meerdere_aanwezig` | `varchar2` | | ☐ | | | `dsk_ref_sleutel` | `int64` | | ☐ | | | `dsk_ref_tabel` | `varchar2` | | ☐ | | | `dsk_som_bestand_omvang_c` | `varchar2` | | ☐ | | | `gce_code` | `varchar2` | | ☐ | | | `gce_id` | `int64` | | ☐ | | | `gce_omschrijving` | `varchar2` | | ☐ | | | `kbg_code` | `varchar2` | | ☐ | | | `kbg_dagen_betalingstermijn` | `int64` | | ☐ | | | `kbg_id` | `int64` | | ☐ | | | `kbg_omschrijving` | `varchar2` | | ☐ | | | `kbg_uitsmeer_methode_ind` | `char` | | ☐ | | | `khg_code` | `varchar2` | | ☐ | | | `khg_id` | `int64` | | ☐ | | | `khg_kosten_opbrengst_ind` | `char` | | ☐ | | | `khg_omschrijving` | `varchar2` | | ☐ | | | `kpt_code` | `varchar2` | | ☐ | | | `kpt_id` | `int64` | | ☐ | | | `kpt_omschrijving` | `varchar2` | | ☐ | | | `kvg_code` | `varchar2` | | ☐ | | | `kvg_id` | `int64` | | ☐ | | | `kvg_omschrijving` | `varchar2` | | ☐ | | | `lvr_dlr_adres_regel_1` | `varchar2` | | ☐ | | | `lvr_dlr_adres_regel_2` | `varchar2` | | ☐ | | | `lvr_dlr_btw_nummer` | `varchar2` | | ☐ | | | `lvr_dlr_code` | `varchar2` | | ☐ | | | `lvr_dlr_fax_tel` | `varchar2` | | ☐ | | | `lvr_dlr_id` | `int64` | | ☐ | | | `lvr_dlr_ikoon_url_ult` | `varchar2` | | ☐ | | | `lvr_dlr_ikoon_url` | `varchar2` | | ☐ | | | `lvr_dlr_klant_vlag` | `char` | | ☐ | | | `lvr_dlr_kvk_nummer` | `varchar2` | | ☐ | | | `lvr_dlr_land` | `varchar2` | | ☐ | | | `lvr_dlr_logo_url` | `varchar2` | | ☐ | | | `lvr_dlr_naam_kort` | `varchar2` | | ☐ | | | `lvr_dlr_naam` | `varchar2` | | ☐ | | | `lvr_dlr_plaats` | `varchar2` | | ☐ | | | `lvr_dlr_postcode` | `varchar2` | | ☐ | | | `lvr_dlr_project_entiteit_vlag` | `char` | | ☐ | | | `lvr_dlr_statutaire_naam` | `varchar2` | | ☐ | | | `lvr_dlr_website_url` | `varchar2` | | ☐ | | | `lvr_dlr_werk_tel` | `varchar2` | | ☐ | | | `lvr_egr_adres_regel_1` | `varchar2` | | ☐ | | | `lvr_egr_adres_regel_2` | `varchar2` | | ☐ | | | `lvr_egr_btw_nummer` | `varchar2` | | ☐ | | | `lvr_egr_code` | `varchar2` | | ☐ | | | `lvr_egr_fax_tel` | `varchar2` | | ☐ | | | `lvr_egr_id` | `int64` | | ☐ | | | `lvr_egr_ikoon_url_ult` | `varchar2` | | ☐ | | | `lvr_egr_ikoon_url` | `varchar2` | | ☐ | | | `lvr_egr_klant_vlag` | `char` | | ☐ | | | `lvr_egr_kvk_nummer` | `varchar2` | | ☐ | | | `lvr_egr_land` | `varchar2` | | ☐ | | | `lvr_egr_logo_url` | `varchar2` | | ☐ | | | `lvr_egr_naam_kort` | `varchar2` | | ☐ | | | `lvr_egr_naam` | `varchar2` | | ☐ | | | `lvr_egr_plaats` | `varchar2` | | ☐ | | | `lvr_egr_postcode` | `varchar2` | | ☐ | | | `lvr_egr_project_entiteit_vlag` | `char` | | ☐ | | | `lvr_egr_statutaire_naam` | `varchar2` | | ☐ | | | `lvr_egr_website_url` | `varchar2` | | ☐ | | | `lvr_egr_werk_tel` | `varchar2` | | ☐ | | | `lvr_fbt_adres_regel_1` | `varchar2` | | ☐ | | | `lvr_fbt_adres_regel_2` | `varchar2` | | ☐ | | | `lvr_fbt_btw_nummer` | `varchar2` | | ☐ | | | `lvr_fbt_code` | `varchar2` | | ☐ | | | `lvr_fbt_fax_tel` | `varchar2` | | ☐ | | | `lvr_fbt_id` | `int64` | | ☐ | | | `lvr_fbt_ikoon_url_ult` | `varchar2` | | ☐ | | | `lvr_fbt_ikoon_url` | `varchar2` | | ☐ | | | `lvr_fbt_klant_vlag` | `char` | | ☐ | | | `lvr_fbt_kvk_nummer` | `varchar2` | | ☐ | | | `lvr_fbt_land` | `varchar2` | | ☐ | | | `lvr_fbt_logo_url` | `varchar2` | | ☐ | | | `lvr_fbt_naam_kort` | `varchar2` | | ☐ | | | `lvr_fbt_naam` | `varchar2` | | ☐ | | | `lvr_fbt_plaats` | `varchar2` | | ☐ | | | `lvr_fbt_postcode` | `varchar2` | | ☐ | | | `lvr_fbt_project_entiteit_vlag` | `char` | | ☐ | | | `lvr_fbt_statutaire_naam` | `varchar2` | | ☐ | | | `lvr_fbt_website_url` | `varchar2` | | ☐ | | | `lvr_fbt_werk_tel` | `varchar2` | | ☐ | | | `lvr_gbr_adres_regel_1` | `varchar2` | | ☐ | | | `lvr_gbr_adres_regel_2` | `varchar2` | | ☐ | | | `lvr_gbr_btw_nummer` | `varchar2` | | ☐ | | | `lvr_gbr_code` | `varchar2` | | ☐ | | | `lvr_gbr_fax_tel` | `varchar2` | | ☐ | | | `lvr_gbr_id` | `int64` | | ☐ | | | `lvr_gbr_ikoon_url_ult` | `varchar2` | | ☐ | | | `lvr_gbr_ikoon_url` | `varchar2` | | ☐ | | | `lvr_gbr_klant_vlag` | `char` | | ☐ | | | `lvr_gbr_kvk_nummer` | `varchar2` | | ☐ | | | `lvr_gbr_land` | `varchar2` | | ☐ | | | `lvr_gbr_logo_url` | `varchar2` | | ☐ | | | `lvr_gbr_naam_kort` | `varchar2` | | ☐ | | | `lvr_gbr_naam` | `varchar2` | | ☐ | | | `lvr_gbr_plaats` | `varchar2` | | ☐ | | | `lvr_gbr_postcode` | `varchar2` | | ☐ | | | `lvr_gbr_project_entiteit_vlag` | `char` | | ☐ | | | `lvr_gbr_statutaire_naam` | `varchar2` | | ☐ | | | `lvr_gbr_website_url` | `varchar2` | | ☐ | | | `lvr_gbr_werk_tel` | `varchar2` | | ☐ | | | `lvr_lvr_adres_regel_1` | `varchar2` | | ☐ | | | `lvr_lvr_adres_regel_2` | `varchar2` | | ☐ | | | `lvr_lvr_btw_nummer` | `varchar2` | | ☐ | | | `lvr_lvr_code` | `varchar2` | | ☐ | | | `lvr_lvr_fax_tel` | `varchar2` | | ☐ | | | `lvr_lvr_id` | `int64` | | ☐ | | | `lvr_lvr_ikoon_url_ult` | `varchar2` | | ☐ | | | `lvr_lvr_ikoon_url` | `varchar2` | | ☐ | | | `lvr_lvr_klant_vlag` | `char` | | ☐ | | | `lvr_lvr_kvk_nummer` | `varchar2` | | ☐ | | | `lvr_lvr_land` | `varchar2` | | ☐ | | | `lvr_lvr_logo_url` | `varchar2` | | ☐ | | | `lvr_lvr_naam_kort` | `varchar2` | | ☐ | | | `lvr_lvr_naam` | `varchar2` | | ☐ | | | `lvr_lvr_plaats` | `varchar2` | | ☐ | | | `lvr_lvr_postcode` | `varchar2` | | ☐ | | | `lvr_lvr_project_entiteit_vlag` | `char` | | ☐ | | | `lvr_lvr_statutaire_naam` | `varchar2` | | ☐ | | | `lvr_lvr_website_url` | `varchar2` | | ☐ | | | `lvr_lvr_werk_tel` | `varchar2` | | ☐ | | | `tsa_code` | `varchar2` | | ☐ | | | `tsa_id` | `int64` | | ☐ | | | `tsa_omschrijving` | `varchar2` | | ☐ | | | `unt_aangemaakt_door` | `varchar2` | | ☑ | | | `unt_aangemaakt_in` | `varchar2` | | ☑ | | | `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` | `varchar2` | | ☑ | | | `unt_bijgewerkt_in` | `varchar2` | | ☑ | | | `unt_contact_url` | `varchar2` | | ☐ | | | `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` | `char` | | ☑ | | | `unt_dichtheid` | `decimal` | | ☐ | | | `unt_facebook_adres` | `varchar2` | | ☐ | | | `unt_gebruikt_vlag` | `char` | | ☑ | | | `unt_googleplus_adres` | `varchar2` | | ☐ | | | `unt_hoofd_vlag` | `char` | | ☐ | | | `unt_id` | `int64` | | ☑ | | | `unt_ikoon_url_ult` | `varchar2` | | ☐ | | | `unt_ikoon_url` | `varchar2` | | ☐ | | | `unt_job_seq_geladen` | `int64` | | ☐ | | | `unt_klassificatie_reeks` | `clob` | | ☐ | | | `unt_kolom_soort` | `varchar2` | | ☐ | | | `unt_kolom_xml` | `xmltype` | | ☐ | | | `unt_kolom1` | `varchar2` | | ☐ | | | `unt_kolom10` | `varchar2` | | ☐ | | | `unt_kolom2` | `varchar2` | | ☐ | | | `unt_kolom3` | `varchar2` | | ☐ | | | `unt_kolom4` | `varchar2` | | ☐ | | | `unt_kolom5` | `varchar2` | | ☐ | | | `unt_kolom6` | `varchar2` | | ☐ | | | `unt_kolom7` | `varchar2` | | ☐ | | | `unt_kolom8` | `varchar2` | | ☐ | | | `unt_kolom9` | `varchar2` | | ☐ | | | `unt_kopieerbaar_vlag` | `char` | | ☑ | | | `unt_label` | `varchar2` | | ☐ | | | `unt_leverancier_code` | `varchar2` | | ☐ | | | `unt_leverancier_sn` | `varchar2` | | ☐ | | | `unt_locatie` | `varchar2` | | ☐ | | | `unt_nk` | `varchar2` | | ☐ | | | `unt_notities_vertrouwelijk_l` | `clob` | | ☐ | | | `unt_omschrijving` | `varchar2` | | ☑ | | | `unt_orig_system_group` | `varchar2` | | ☐ | | | `unt_orig_system_reference` | `varchar2` | | ☐ | | | `unt_partitie` | `int64` | | ☑ | | | `unt_referentie_leverancier` | `varchar2` | | ☐ | | | `unt_seo_naam` | `varchar2` | | ☐ | | | `unt_seo_omschrijving_2000` | `varchar2` | | ☐ | | | `unt_seo_omschrijving_250` | `varchar2` | | ☐ | | | `unt_seo_omschrijving_45` | `varchar2` | | ☐ | | | `unt_seo_omschrijving_450` | `varchar2` | | ☐ | | | `unt_seo_omschrijving_80` | `varchar2` | | ☐ | | | `unt_seo_omschrijving` | `varchar2` | | ☐ | | | `unt_seo_pagina_pad` | `varchar2` | | ☐ | | | `unt_seo_pagina_titel` | `varchar2` | | ☐ | | | `unt_seo_usp` | `varchar2` | | ☐ | | | `unt_serienummer` | `varchar2` | | ☑ | | | `unt_sessie_aangemaakt` | `varchar2` | | ☑ | | | `unt_sessie_bijgewerkt` | `varchar2` | | ☑ | | | `unt_sorteer_volgorde` | `int64` | | ☐ | | | `unt_speciale_opmerking_vlag` | `char` | | ☑ | | | `unt_speciale_opmerking` | `varchar2` | | ☐ | | | `unt_toelichting_l` | `clob` | | ☐ | | | `unt_transactie_aangemaakt` | `int64` | | ☑ | | | `unt_transactie_bijgewerkt` | `int64` | | ☑ | | | `unt_verkoop_code` | `varchar2` | | ☐ | | | `unt_verkoop_merk` | `varchar2` | | ☐ | | | `unt_verkoopbaar_vlag` | `char` | | ☑ | | | `unt_versie` | `varchar2` | | ☐ | | | `unt_verwerkbaar_vlag` | `char` | | ☑ | | | `unt_volledige_code` | `int64` | | ☑ | | | `unt_voorraad_vlag` | `char` | | ☑ | | | `unt_vpl_verkoopprijs_vlag` | `char` | | ☑ | | | `unt_website_url` | `varchar2` | | ☐ | | | `unt0_deelbaar_vlag` | `char` | | ☑ | | | `unt0_id` | `int64` | | ☑ | | | `unt0_ikoon_url` | `varchar2` | | ☐ | | | `unt0_kopieerbaar_vlag` | `char` | | ☑ | | | `unt0_omschrijving` | `varchar2` | | ☑ | | | `unt0_serienummer` | `varchar2` | | ☑ | | | `unt0_verkoopbaar_vlag` | `char` | | ☑ | | | `unt0_voorraad_vlag` | `char` | | ☑ | | | `unt0_vpl_verkoopprijs_vlag` | `char` | | ☑ | | | `usp_code` | `varchar2` | | ☑ | | | `usp_id` | `int64` | | ☑ | | | `usp_omschrijving` | `varchar2` | | ☑ | | | `ust_code` | `varchar2` | | ☑ | | | `ust_id` | `int64` | | ☑ | | | `ust_ikoon_url` | `varchar2` | | ☐ | | | `ust_omschrijving` | `varchar2` | | ☑ | | | `ust_vpl_verkoopprijs_vlag` | `char` | | ☑ | |