Hublify-CMS - Template Examples

Below you can find some auto-generated examples for direct use within your Hublify-CMS' twig templates.

dataset().all()

Hint: For best performance, retrieve only those fields you really need!

Autogenerated twig-templating source code:


          {# Get all records from dataset "invoiceitem".

             Other retrievable fields of invoiceitem are:
                       'invi_id' - (INT, 11) Rg-Id,
                       'invi_fk_inv_id' - (INT, 11) Rechnung,
                       'invi_fk_persid' - (INT, 11) Kunde,
                       'invi_pos' - (INT, 4) Pos.,
                       'invi_type' - (TEXT, 15) Typ,
                       'invi_pcode' - (TEXT, 255) Produktcode,
                       'pcode' - () Pcode,
                       'invi_name' - (TEXT) Name,
                       'invi_text' - (TEXT) Text,
                       'invi_quantity' - (FLOAT, 13,4) Anzahl,
                       'invi_vat_pct' - (FLOAT, 6,2) % MwSt.,
                       'invi_price_single_brutto' - (FLOAT, 13,2) Einzelpreis (brutto),
                       'invi_time_insert' - (DATETIME) Angelegt am,
                       'invi_time_update' - (DATETIME) Geändert am,
                       'invi_user_insert' - (TEXT, 127) Ersteller,
                       'invi_user_update' - (TEXT, 127) Letzte Änderung durch,
                       'drvd_invi_total_brutto' - (FLOAT, 13,2) Gesamt Brutto,
                       'drvd_invi_single_brutto' - (FLOAT, 13,2) Einzelpreis Brutto,
                       'invi_price_single_netto' - (FLOAT, 13,2) Einzelpreis (netto),
                       'drvd_invi_single_netto' - (FLOAT, 13,2) Einzelpreis Netto,
                       'drvd_invi_total_netto' - (FLOAT, 13,2) Gesamt Netto,
                       'invi_price_single_brutto_xcurrency' - (FLOAT, 13,2) Einzelpreis (brutto, X-Währung),
                       'invi_price_single_netto_xcurrency' - (FLOAT, 13,2) Einzelpreis (netto, X-Währung),
                       'invi_xcurrency' - (TEXT, 3) X-Währung,
                       'drvd_invi_total_brutto_xcurrency' - (FLOAT, 13,2) Gesamt Brutto (X-Währung),
                       'drvd_invi_total_netto_xcurrency' - (FLOAT, 13,2) Gesamt Netto (X-Währung),
                       'drvd_invi_price_single_brutto_xcurrency' - (FLOAT, 13,2) Einzelpreis (brutto, X-Währung),
                       'drvd_invi_price_single_netto_xcurrency' - (FLOAT, 13,2) Einzelpreis (netto, X-Währung)	,
                       'invi_vesting_period_from' - (DATE) LZR Beginn,
                       'invi_vesting_period_to' - (DATE) LZR Ende,
                       'invi_xdata' - (DATA) Zusatzdaten,
                       'invi_contributionmargin_total_netto' - (FLOAT, 8,2) Deckungsbeitrag,
                       'drvd_invi_contributionmargin_total_netto_percent' - (FLOAT, 8,2) Deckungsbeitrag [%],
                       'inv_id' - (INT, 11) ,
                       'inv_code' - (TEXT, 31) Rechnungs-Nr.,
                       'fk_inv_persid' - (INT, 11) Kunde,
                       'inv_time_invoice' - (DATETIME) Rechnungs­­datum,
                       'inv_amount' - (FLOAT, 13,2) Rechnungs­­betrag,
                       'inv_status' - (TEXT, 7) Rechnungsstatus,
                       'inv_status_color' - (TEXT, 15) ,
                       'fk_inv_oid' - (INT, 11) Auftrag,
                       'inv_user_insert' - (TEXT, 127) Ersteller,
                       'inv_time_insert' - (DATETIME) Angelegt am,
                       'inv_user_update' - (TEXT, 127) Letzte Änderung durch,
                       'inv_time_update' - (DATETIME) Geändert am,
                       'drvd_invoice_or_credit' - (TEXT) ,
                       'inv_amount_paid' - (FLOAT, 13,2) Bezahlter Rechnungsbetrag,
                       'inv_time_paid' - (DATETIME) Letzte Rechnungszahlung,
                       'inv_discount_percent' - (FLOAT, 6,2) % Skonto (Altversion),
                       'inv_discount_time_until' - (DATETIME) Skonto bis (Altversion),
                       'inv_txt_title' - (TEXT) Rechnungstitel,
                       'inv_txt_header' - (TEXT) Kopfbereich,
                       'inv_txt_footer' - (TEXT) Fußbereich,
                       'inv_comment_internal' - (TEXT) Interner Kommentar,
                       'inv_gender' - (TEXT) Anrede,
                       'inv_title' - (TEXT) Titel,
                       'inv_firstname' - (TEXT) Vorname,
                       'inv_lastname' - (TEXT) Rg.Nachname,
                       'inv_company' - (TEXT) Rg.Firma,
                       'inv_addrextra' - (TEXT) Adressenzusatz,
                       'inv_street' - (TEXT) Straße,
                       'inv_housenr' - (TEXT) Hausnummer,
                       'drvd_inv_street_housenr' - (TEXT) Straße+Nr,
                       'inv_zip' - (TEXT) PLZ,
                       'inv_town' - (TEXT) Ort,
                       'inv_state_code' - (TEXT, 15) Bundesland (Code),
                       'inv_country' - (TEXT) Land,
                       'inv_time_account_export' - (DATETIME) Buchhaltung-Export,
                       'inv_editable' - (INT, 11) änderbar,
                       'inv_type' - (TEXT) Rechnungsart,
                       'inv_reason' - (TEXT, 15) Grund,
                       'inv_comment' - (TEXT) Kommentar,
                       'inv_email' - (TEXT) Rechnungs E-Mail,
                       'inv_taxidentnumber' - (TEXT) Umsatzsteuer-ID,
                       'inv_taxident_status' - (TEXT) Umsatzsteuer-ID Status,
                       'inv_third_country_export' - (TEXT) Ausfuhrbescheinigung ,
                       'inv_deliver_country' - (TEXT) Lieferland,
                       'inv_tax_country' - (TEXT) Umsatzsteuer-Land,
                       'inv_currency' - (TEXT, 3) Währung,
                       'inv_pys_method' - (TEXT, 31) Zahlungsart,
                       'fk_inv_accid' - (INT, 11) Konto,
                       'inv_pay_profile_xdata' - (DATA) Zahlungsziel-Daten,
                       'drvd_amount_not_paid' - (FLOAT, 13,2) Ausstehender Rechnungsbetrag,
                       'drvd_amount_open_days' - (INT) Offen seit ... Tagen,
                       'drvd_days_until_paid' - (INT) Bezahlt nach ... Tagen,
                       'drvd_inv_name' - (TEXT) Name (kombiniert),
                       'inv_reminder_level' - (INT, 11) ,
                       'inv_reminder_data' - (TEXT) Mahndaten,
                       'inv_reminder_profile_label' - (TEXT, 127) Mahnprofil,
                       'inv_reminder_time_last_sent' - (DATETIME) Letzte Mahnung gesendet,
                       'inv_reminder_time_last_change' - (DATETIME) Letzte Mahnstufe-Änderung,
                       'inv_reminder_prop_level' - (INT, 11) Mahnstufe (vorgeschlagen),
                       'inv_reminder_prop_xdata' - (TEXT) Mahnstufen-Daten (vorgeschlagen),
                       'inv_reminder_prop_time' - (DATETIME) Mahnstufen-Vorschlag (Berechnung),
                       'inv_reminder_suspend_time' - (DATETIME) Mahnstopp Zeitpunkt,
                       'inv_extcollect_time' - (DATETIME) Inkasso-Übergabe,
                       'inv_extcollect_code' - (TEXT, 127) Inkasso Code,
                       'inv_extcollect_xdata' - (TEXT) Inkasso-Daten,
                       'persid' - (INT, 11) PersID,
                       'personid' - (TEXT, 32) Kunden-Nr.,
                       'fk_p_grpid' - (INT, 11) Kundengruppe,
                       'fk_p_shopid' - (INT, 11) Shop,
                       'gender' - (TEXT) Anrede,
                       'gender_color' - (TEXT, 15) ,
                       'title' - (TEXT) Titel,
                       'salutation' - (TEXT) Anrede formal,
                       'firstname' - (TEXT) Vorname,
                       'lastname' - (TEXT) Nachname,
                       'bday' - (DATE) Geburtsdatum,
                       'drvd_age' - (INT) Alter,
                       'drvd_bday_days_until_next' - (INT) Nächster Geburtstag (in Tagen),
                       'drvd_bday_next' - (DATE) Nächster Geburtstag,
                       'company' - (TEXT) Firma,
                       'p_department' - (TEXT) Abteilung,
                       'p_job_position' - (TEXT) Position,
                       'address2' - (TEXT) Adressenzusatz,
                       'street' - (TEXT) Straße,
                       'housenr' - (TEXT) Hausnummer,
                       'zip' - (TEXT) PLZ,
                       'town' - (TEXT) Ort,
                       'state_code' - (TEXT, 15) Bundesland (Code),
                       'country' - (TEXT, 2) Land,
                       'drvd_person_name' - (TEXT) Kundenname (kombiniert),
                       'drvd_p_address' - (TEXT) Adresse,
                       'email' - (TEXT, 127) E-Mail,
                       'telephone' - (TEXT) Telefon,
                       'telephone_mobile' - (TEXT) Tel. mobil,
                       'telefax' - (TEXT) Fax,
                       'p_invoice_type' - (TEXT) Rechnungsart,
                       'p_invoice_email' - (TEXT) E-Mail (Rechnung),
                       'taxident' - (TEXT) Umsatzsteuer-ID,
                       'taxident_status' - (TEXT) Umsatzsteuer-ID-Status,
                       'score' - (INT, 7) Bonitätswert,
                       'score_time_set' - (DATETIME) Letzter Rating-Check,
                       'score_time_invalid' - (DATETIME) Abgelaufen am,
                       'svc_code' - (TEXT) Rating ServiceCode,
                       'svc_txt' - (TEXT) Rating ServiceText,
                       'p_login_username' - (TEXT, 63) Benutzername,
                       'p_login_pwd_encrypted' - (TEXT) Passwort (verschlüsselt),
                       'p_login_pwd_key' - (TEXT) Direct-Login-Token,
                       'p_login_time_last' - (DATETIME) Letzter Login,
                       'p_login_pwd_must_renew_after' - (DATETIME) Passwort-Änderung auffordern ab,
                       'p_login_pwd_key_timeout' - (DATETIME) Direct-Login-Token Timeout,
                       'p_login_pwd_last_renewed' - (DATETIME) Passwort zuletzt geändert,
                       'p_login_active' - (INT, 1) Aktiv,
                       'p_email_verify_token' - (TEXT, 32) ,
                       'p_email_verify_token_timeout' - (DATETIME) ,
                       'p_email_verified_time' - (DATETIME) ,
                       'p_login_mode' - (TEXT, 15) Login-Modus,
                       'p_login_2fa_code' - (TEXT) 2FA - Login Code,
                       'p_login_2fa_timeout' - (DATETIME) 2FA - Login Code Timeout,
                       'p_login_err_count' - (INT, 4) Anzahl Fehllogins,
                       'p_login_time_min' - (DATETIME) Login Sperrzeit,
                       'p_register_state' - (TEXT, 15) Registrierungsstatus,
                       'p_register_code' - (TEXT, 32) Registrierungscode,
                       'p_register_code_timeout' - (DATETIME) Registrierungscode Timeout,
                       'p_onetime_pwd' - (TEXT) Einmal-Passwort,
                       'p_onetime_pwd_timeout' - (DATETIME) Einmal-Passwort Timeout,
                       'p_login_state' - (TEXT, 15) Login Status,
                       'p_login_state_color' - (TEXT, 15) ,
                       'p_oo_set_label' - (TEXT, 63) Bestelloptionen-Profil,
                       'fk_p_pay_profile_id' - (INT, 11) Zahlungsziel-Profil,
                       'fk_p_prcgrp_id' - (INT, 11) Preisgruppe,
                       'p_price_factor' - (FLOAT, 10,4) Preis-Faktor,
                       'p_person_prices' - (INT, 1) Persönliche Preise,
                       'fk_p_campid' - (INT, 11) Kampagne,
                       'p_allow_email_marketing' - (INT, 1) Zustimmung zu Marketing-Mails,
                       'drvd_emailmarketing_unsubscribetoken' - (TEXT) Token für Direktabmeldung Marketingmails,
                       'p_ip_address' - (TEXT, 15) IP-Adresse,
                       'p_referrer' - (TEXT) Referrer,
                       'p_useragent' - (TEXT) User Agent,
                       'p_personid_external' - (TEXT, 127) Externe Kunden-Nr.,
                       'p_comment_internal' - (TEXT) Interner Kommentar,
                       'p_locale' - (DATA) Locale Kunde,
                       'p_volfile' - (DATA) ,
                       'time_insert' - (DATETIME) Angelegt am,
                       'user_insert' - (TEXT, 127) Ersteller,
                       'time_update' - (DATETIME) Geändert am,
                       'user_update' - (TEXT, 127) Letzte Änderung durch,
                       'drvd_timeonly_timeinsert' - (TEXT) Angelegt (Uhrzeit),
                       'p_anonymize_time' - (DATETIME) Anoymisiert am,
                       'grpid' - (INT, 11) ,
                       'grp_name' - (TEXT, 127) Kundengruppe,
                       'description' - (TEXT) Beschreibung,
                       'grp_default' - (INT, 1) Default,
                       'grp_p_login_active' - (INT, 1) Kundenlogin Default Aktiv,
                       'grp_locale' - (DATA) Locale Kundengruppe,
                       'grp_state' - (TEXT, 63) Bestellstatus,
                       'grp_pos' - (TEXT, 63) POS Channel,
                       'prc_display_mode' - (TEXT, 15) Preisanzeige,
                       'grp_price_factor' - (FLOAT, 10,4) Preis-Faktor,
                       'fk_grp_prcgrp_id' - (INT, 11) Standard-Preisgruppe,
                       'grp_persongrp_prices' - (INT, 1) Gruppenspezifische Preise,
                       'grp_price_col' - (TEXT, 31) Preisspalte,
                       'grp_discount_col' - (TEXT, 63) Preisspalte (Discount),
                       'grp_discount_start_col' - (TEXT, 63) Preisspalte (Discount Start),
                       'grp_discount_end_col' - (TEXT, 63) Preisspalte (Discount Ende),
                       'grp_price_dsc_scale_col' - (TEXT, 63) Preisspalte (Staffelpreise),
                       'grp_price_prcgrp_col' - (TEXT, 63) Preisgruppen-Spalte,
                       'grp_price_state_col' - (TEXT, 63) Spalte für Shop-Status
,
                       'grp_price_hide_price_dsp_col' - (TEXT, 63) Spalte für Preis ausblenden,
                       'grp_oo_set_label' - (TEXT, 63) Bestelloptionen-Profil,
                       'fk_grp_pay_profile_id' - (INT, 11) Zahlungsziel-Profil,
                       'data' - (DATA) Daten,
                       'grp_shopuserright_profiles' - (TEXT) Gruppen-Rollen,
                       'grp_shopuserright_rights' - (TEXT) Gruppen-Rechte,
                       'fk_p_companyaccount_parent_persid' - (INT) Firmenaccount,
                       'p_companyaccount_budget_cart_max' - (FLOAT, 10,2) Budget Warenkorb,
                       'p_companyaccount_cost_center_customer' - (TEXT) Kunden Kostenstelle,
                       'p_companyaccount_type' - (TEXT) ,
                       'p_companyaccount_xdata' - (DATA) ,
                       'p_accounting_debtor_account' - (TEXT) Buchhaltung Debitorenkonto,
                       'fk_pers_inv_reminder_profile' - (TEXT, 127) Mahnprofil,
                       'p_merchant_xdata' - (DATA) Anbieter (Zusatzdaten),
                       'p_shopuserright_profiles' - (TEXT) Benutzer-Rollen,
                       'p_shopuserright_rights' - (TEXT) Benutzer-Rechte,
                       'xc__active' - (INT, 1) Aktiv,
                       'xc__searchable' - (INT, 1) Suchbar,
                       'xc__version' - (INT, 11) Version,
                       'xc__current' - (INT, 1) Aktuell,
                       'xc__insert_user' - (TEXT, 127) Ersteller,
                       'xc__insert_time' - (DATETIME) Angelegt am,
                       'xc__valid' - (INT, 1) Valide,
                       'xc__update_time' - (DATETIME) Geändert am,
                       'xc__install_time' - (DATETIME) Installiert am,
                       'xc__publish_start' - (DATETIME) Veröffentlichung (Start),
                       'xc__publish_end' - (DATETIME) Veröffentlichung (Ende),
                       'xc__update_user' - (TEXT, 127) Letzte Änderung durch,
                       'xc__ecms_data' - (TEXT) eCMS-Daten,
                       'xc__id' - (INT, 11) ID,
                       'drvd_xc_display' - (TEXT) Titel,
                       'drvd_is_master' - (INT, 1) Ist Masterprodukt,
                       'name' - (TEXT) Name,
                       'master_pcode' - (TEXT) Varianten-Master PCode,
                       'prdv_color' - (TEXT) Varianten-Farbe,
                       'prdv_size' - (TEXT) Varianten-Größe,
                       'prdv_other' - (TEXT) Varianten-Ausführung,
                       'prd_comment' - (TEXT) Kommentar,
                       'files_doc' - (DATA) Produkt-Dateien,
                       'pack_amount' - (FLOAT) Verpackungs­menge,
                       'pack_unit' - (TEXT) Verpackungs­einheit,
                       'prd_ingr_amount' - (FLOAT) Verpackungs­inhalt (Menge),
                       'prd_ingr_unit' - (TEXT) Verpackungs­inhalt (Einheit),
                       'prd_weight' - (FLOAT) Produktgewicht,
                       'prd_virtual' - (TEXT) Virtuelles Produkt,
                       'products_replace' - (DATA) Nachfolge­produkte,
                       'pcode_manufacturer' - (TEXT) Hersteller-PCode,
                       'brand' - (TEXT) Brand,
                       'products_upselling' - (DATA) Upselling-Produkte,
                       'products_related' - (DATA) Zugehörige Produkte,
                       'orderitem_name' - (TEXT) Auftrags­posten-Name,
                       'orderitem_text' - (TEXT) Auftrags­posten-Text,
                       'marketing_name' - (TEXT) Marketing-Name,
                       'marketing_teaser' - (TEXT) Marketing-Teaser,
                       'marketing_image' - (DATA) Marketing-Bild,
                       'new_product' - (TEXT) Neues Produkt?,
                       'special_offer_product' - (TEXT) Special-Offer Produkt?,
                       'plugin' - (TEXT) Plugin,
                       'meta_title' - (TEXT) Produkt-Meta-Titel,
                       'meta_keywords' - (TEXT) Produkt-Meta-Keywords,
                       'meta_description' - (TEXT) Produkt-Meta-Beschreibung,
                       'meta_robots_noindex' - (TEXT) Produkt-Meta-Robots-NoIndex,
                       'meta_robots_nofollow' - (TEXT) Produkt-Meta-Robots-NoFollow,
                       'marketing_image_background' - (DATA) Marketing-Hintergrundbild,
                       'marketing_overlay_html' - (TEXT) Marketing-Overlay-HTML,
                       'description_seo' - (TEXT) SEO-Beschreibung,
                       'prd_width' - (FLOAT) Produktgröße - Breite,
                       'prd_height' - (FLOAT) Produktgröße - Höhe,
                       'prd_depth' - (FLOAT) Produktgröße - Tiefe,
                       'prd_rating_avg' - (FLOAT) ,
                       'prd_rating_cnt' - (TEXT) ,
                       'convertable_pack_unit' - (DATA) ,
                       'prd_accounting_cost_center' - (TEXT) Buchhaltung Kostenstelle,
                       'prd_accounting_revenue_account' - (TEXT) Buchhaltung Erlöskonto,
                       'base_color' - (TEXT) Grundfarbe,
                       'html_canonical' - (TEXT) ,
                       'pack_size_width' - (TEXT) Verpackungs­größe - Breite,
                       'pack_size_height' - (TEXT) Verpackungs­größe - Höhe,
                       'pack_size_depth' - (TEXT) Verpackungs­größe - Tiefe,
                       'pack_weight' - (FLOAT) Verpackungs­gewicht,
                       'features' - (DATA) ,
                       'gtin' - (TEXT) GTIN/EAN,
                       'ppn' - (TEXT) PPN,
                       'origin_country' - (TEXT) Ursprungsland,
                       'customs_tariff_number' - (TEXT) HS-Tariff-Code,
                       'customs_value_amount' - (TEXT) ,
                       'customs_description' - (TEXT) Zoll-Beschreibung,
                       'files_download' - (DATA) Download-Dateien,
                       'products_contain' - (DATA) Produkte im Bundle,
                       'prd_keywords' - (TEXT) Keywords,
                       'files_img' - (DATA) Bilder,
                       'prd_bundle_price_discount_perc' - (FLOAT) Bundle-Preis %-Discount,
                       'desc_short' - (TEXT) Kurz­beschreibung,
                       'prd_snr_xdata_subtype' - (TEXT) Zusatzdaten-Typ,
                       'prd_bundle_resolve_mode' - (TEXT) Bundle-Modus,
                       'desc_tech' - (TEXT) Technische Beschreibung,
                       'manufacturer' - (TEXT) Hersteller,
                       'xc__label' - (TEXT) ,
                       'xc__title' - (TEXT) ,
                       'xc__image' - (DATA) ,
                       'drvd_variant_specification' - (TEXT) Ausprägung,
                       'currency' - (TEXT) ,
                       'cy_name' - (TEXT, 63) Name,
                       'cy_nameshort' - (TEXT, 15) Kurzname,
                       'drvd_inv_state_name' - (TEXT) Bundesland,
                       'drvd_inv_state_path' - (TEXT) Bundesland (Pfad),
                       'oid' - (INT, 11) ,
                       'orderid' - (TEXT, 63) Auftrags-Nr.,
                       'fk_o_shopid' - (INT, 11) Shop,
                       'fk_o_persid' - (INT, 11) Kunde,
                       'o_time_ordered' - (DATETIME) Bestell­datum,
                       'total_netto' - (FLOAT, 13,2) ∑ Gesamt, Netto,
                       'total_brutto' - (FLOAT, 13,2) ∑ Gesamt, Brutto,
                       'o_orderid_external' - (TEXT, 255) Externe Auftrags-Nr.,
                       'fk_o_posid' - (INT, 11) POS Channel (ID),
                       'fk_o_stid' - (INT, 11) Status,
                       'fk_o_st_id' - (INT, 11) Versandart,
                       'o_pers_reftext' - (TEXT) Kunden-Referenztext,
                       'o_pers_seq_nr' - (INT, 11) Auftrags-Sequenz-Nr.,
                       'quantity' - (FLOAT, 13,4) Bestellmenge,
                       'drvd_total_vat' - (FLOAT, 13,2) MwSt. (Gesamt),
                       'otitle' - (TEXT) Auftragstitel,
                       'otext' - (TEXT) Auftragsbeschreibung,
                       'o_type' - (TEXT, 15) Auftragstyp,
                       'o_valid_until' - (DATETIME) Gültig bis,
                       'o_txt_header' - (TEXT) Kopf-Text,
                       'o_txt_footer' - (TEXT) Fuß-Text,
                       'invoice_addr_preset' - (TEXT) Adressbuch (R),
                       'invoice_gender' - (TEXT) Anrede (R),
                       'invoice_title' - (TEXT) Titel (R),
                       'invoice_firstname' - (TEXT) Vorname (R),
                       'invoice_lastname' - (TEXT) Nachname (R),
                       'invoice_company' - (TEXT) Firma (R),
                       'invoice_addrextra' - (TEXT) Adressenzusatz,
                       'invoice_street' - (TEXT) Straße (R),
                       'invoice_housenr' - (TEXT) Hausnummer (R),
                       'invoice_zip' - (TEXT) PLZ (R),
                       'invoice_town' - (TEXT) Ort (R),
                       'invoice_state_code' - (TEXT, 15) Bundesland (Code) (R),
                       'invoice_country' - (TEXT, 2) Land (R),
                       'invoice_type' - (TEXT) Rechnungsart,
                       'invoice_email' - (TEXT) E-Mail (R),
                       'invoice_taxidentnumber' - (TEXT) USt.ID-Nr.,
                       'invoice_taxident_status' - (TEXT) USt.ID-Nr. Status,
                       'invoice_third_country_export' - (TEXT) Ausfuhrbescheinigung,
                       'invoice_lang_iso' - (TEXT, 2) Rechnungssprache,
                       'drvd_invoice_street_housenr' - (TEXT) Straße+Nr (R),
                       'deliver_addr_preset' - (DATA) Adressbuch (L),
                       'deliver_gender' - (TEXT) Anrede (L),
                       'deliver_title' - (TEXT) Titel (L),
                       'deliver_firstname' - (TEXT) Vorname (L),
                       'deliver_lastname' - (TEXT) Nachname (L),
                       'deliver_company' - (TEXT) Firma (L),
                       'deliver_addrextra' - (TEXT) Adressenzusatz,
                       'deliver_street' - (TEXT) Straße (L),
                       'deliver_housenr' - (TEXT) Hausnummer (L),
                       'deliver_zip' - (TEXT) PLZ (L),
                       'deliver_town' - (TEXT) Ort (L),
                       'deliver_state_code' - (TEXT, 15) Bundesland (Code) (L),
                       'deliver_country' - (TEXT, 2) Land (L),
                       'deliver_date_req' - (TEXT) Kunden-Wunschtermin,
                       'deliver_phone' - (TEXT) Telefon,
                       'deliver_email' - (TEXT) E-Mail (L),
                       'deliver_comment' - (TEXT) Liefer-Hinweise,
                       'drvd_deliver_street_housenr' - (TEXT) Straße+Nr (L),
                       'deliver_notes_xdata' - (DATA) Lieferhinweise,
                       'ip_address' - (TEXT) IP-Adresse,
                       'o_referrer' - (TEXT) Referrer,
                       'o_useragent' - (TEXT) User-Agent,
                       'o_comment' - (TEXT) Kundenkommentar,
                       'o_comment_internal' - (TEXT) Interner Bestellhinweis,
                       'o_lock_time' - (DATETIME) Bearbeitungs-Sperre (Zeitpunkt),
                       'o_lock_user' - (TEXT, 31) Bearbeitungs-Sperre (Benutzer),
                       'o_insert_time' - (DATETIME) Angelegt am,
                       'o_update_time' - (DATETIME) Geändert am,
                       'o_insert_user' - (TEXT, 127) Ersteller,
                       'o_update_user' - (TEXT, 127) Letzte Änderung durch,
                       'fk_o_campid' - (INT, 11) Kampagne,
                       'drvd_o_shoplabel' - (TEXT) Shop,
                       'drvd_invoice_address' - (TEXT) Auftrag-Rg.Adresse,
                       'drvd_deliver_address' - (TEXT) Auftrag-Lfg.Adresse,
                       'o_pay_profile_xdata' - (DATA) Zahlungsziel-Daten,
                       'fk_o_companyaccount_subaccount_persid' - (INT, 11) Unteraccount,
                       'fk_o_mrch_id' - (INT, 11) Verkaufender Anbieter,
                       'fk_o_parent_oid' - (INT, 11) Hauptauftrag,
                       'o_merchant_xdata' - (DATA) Anbieter (Zusatzdaten),
                       'o_periodic_time_first' - (DATETIME) Abo-Startdatum,
                       'o_periodic_time_last' - (DATETIME) Abo-Enddatum,
                       'o_periodic_time_next' - (DATETIME) Nächste Abo-Ausführung,
                       'o_periodic_timeorder_offset' - (TEXT, 31) Abweichendes Auftragsdatum,
                       'o_periodic_time_strict' - (INT, 1) Strikt,
                       'o_periodic_exec_period' - (TEXT, 31) Abo-Intervall,
                       'o_periodic_exec_inprogress' - (INT, 1) Wird gerade ausgeführt,
                       'o_periodic_xdata' - (DATA) ,
                       'drvd_weekday_timeordered' - (TEXT) Wochen­tag,
                       'drvd_hour_timeordered' - (TEXT) Stunde,
                       'drvd_month_timeordered' - (TEXT) Bestell­monat,
                       'drvd_dayofmonth_timeordered' - (TEXT) Bestelltag im Monat,
                       'drvd_timeonly_timeordered' - (TEXT) Bestellzeit,
                       'drvd_cluster_seq' - (TEXT) Erst-/Wiederkauf,
                       'order_state_transtime' - (DATETIME) Transaktionszeit,
                       'order_state_code' - (TEXT, 63) Auftragsstatus (Code),
                       'order_state_color' - (TEXT, 15) Status-Farbe,
                       'order_state_name' - (TEXT) Auftragsstatus (Name),
                       'order_state_name_public' - (TEXT) Auftragsstatus (öffentlicher Name),
                       'inv_email_time_send' - (DATETIME) Letzter Rechnungsversand,
                       'pos_name' - (TEXT, 127) POS Channel,
                #}
          {% set dataList = hublify.dataset('invoiceitem')
              .fields([
                  'invi_id',
                  'invi_pcode',
              ])
              .filter('','<something>')
              .limit(10)
              .all()
          %}
          

dataset().one()

Hint: For best performance, retrieve only those fields you really need!

Autogenerated twig-templating source code:


          {# Get one record from dataset "invoiceitem".

             Other retrievable fields of invoiceitem are:
                       'invi_id' - (INT, 11) Rg-Id,
                       'invi_fk_inv_id' - (INT, 11) Rechnung,
                       'invi_fk_persid' - (INT, 11) Kunde,
                       'invi_pos' - (INT, 4) Pos.,
                       'invi_type' - (TEXT, 15) Typ,
                       'invi_pcode' - (TEXT, 255) Produktcode,
                       'pcode' - () Pcode,
                       'invi_name' - (TEXT) Name,
                       'invi_text' - (TEXT) Text,
                       'invi_quantity' - (FLOAT, 13,4) Anzahl,
                       'invi_vat_pct' - (FLOAT, 6,2) % MwSt.,
                       'invi_price_single_brutto' - (FLOAT, 13,2) Einzelpreis (brutto),
                       'invi_time_insert' - (DATETIME) Angelegt am,
                       'invi_time_update' - (DATETIME) Geändert am,
                       'invi_user_insert' - (TEXT, 127) Ersteller,
                       'invi_user_update' - (TEXT, 127) Letzte Änderung durch,
                       'drvd_invi_total_brutto' - (FLOAT, 13,2) Gesamt Brutto,
                       'drvd_invi_single_brutto' - (FLOAT, 13,2) Einzelpreis Brutto,
                       'invi_price_single_netto' - (FLOAT, 13,2) Einzelpreis (netto),
                       'drvd_invi_single_netto' - (FLOAT, 13,2) Einzelpreis Netto,
                       'drvd_invi_total_netto' - (FLOAT, 13,2) Gesamt Netto,
                       'invi_price_single_brutto_xcurrency' - (FLOAT, 13,2) Einzelpreis (brutto, X-Währung),
                       'invi_price_single_netto_xcurrency' - (FLOAT, 13,2) Einzelpreis (netto, X-Währung),
                       'invi_xcurrency' - (TEXT, 3) X-Währung,
                       'drvd_invi_total_brutto_xcurrency' - (FLOAT, 13,2) Gesamt Brutto (X-Währung),
                       'drvd_invi_total_netto_xcurrency' - (FLOAT, 13,2) Gesamt Netto (X-Währung),
                       'drvd_invi_price_single_brutto_xcurrency' - (FLOAT, 13,2) Einzelpreis (brutto, X-Währung),
                       'drvd_invi_price_single_netto_xcurrency' - (FLOAT, 13,2) Einzelpreis (netto, X-Währung)	,
                       'invi_vesting_period_from' - (DATE) LZR Beginn,
                       'invi_vesting_period_to' - (DATE) LZR Ende,
                       'invi_xdata' - (DATA) Zusatzdaten,
                       'invi_contributionmargin_total_netto' - (FLOAT, 8,2) Deckungsbeitrag,
                       'drvd_invi_contributionmargin_total_netto_percent' - (FLOAT, 8,2) Deckungsbeitrag [%],
                       'inv_id' - (INT, 11) ,
                       'inv_code' - (TEXT, 31) Rechnungs-Nr.,
                       'fk_inv_persid' - (INT, 11) Kunde,
                       'inv_time_invoice' - (DATETIME) Rechnungs­­datum,
                       'inv_amount' - (FLOAT, 13,2) Rechnungs­­betrag,
                       'inv_status' - (TEXT, 7) Rechnungsstatus,
                       'inv_status_color' - (TEXT, 15) ,
                       'fk_inv_oid' - (INT, 11) Auftrag,
                       'inv_user_insert' - (TEXT, 127) Ersteller,
                       'inv_time_insert' - (DATETIME) Angelegt am,
                       'inv_user_update' - (TEXT, 127) Letzte Änderung durch,
                       'inv_time_update' - (DATETIME) Geändert am,
                       'drvd_invoice_or_credit' - (TEXT) ,
                       'inv_amount_paid' - (FLOAT, 13,2) Bezahlter Rechnungsbetrag,
                       'inv_time_paid' - (DATETIME) Letzte Rechnungszahlung,
                       'inv_discount_percent' - (FLOAT, 6,2) % Skonto (Altversion),
                       'inv_discount_time_until' - (DATETIME) Skonto bis (Altversion),
                       'inv_txt_title' - (TEXT) Rechnungstitel,
                       'inv_txt_header' - (TEXT) Kopfbereich,
                       'inv_txt_footer' - (TEXT) Fußbereich,
                       'inv_comment_internal' - (TEXT) Interner Kommentar,
                       'inv_gender' - (TEXT) Anrede,
                       'inv_title' - (TEXT) Titel,
                       'inv_firstname' - (TEXT) Vorname,
                       'inv_lastname' - (TEXT) Rg.Nachname,
                       'inv_company' - (TEXT) Rg.Firma,
                       'inv_addrextra' - (TEXT) Adressenzusatz,
                       'inv_street' - (TEXT) Straße,
                       'inv_housenr' - (TEXT) Hausnummer,
                       'drvd_inv_street_housenr' - (TEXT) Straße+Nr,
                       'inv_zip' - (TEXT) PLZ,
                       'inv_town' - (TEXT) Ort,
                       'inv_state_code' - (TEXT, 15) Bundesland (Code),
                       'inv_country' - (TEXT) Land,
                       'inv_time_account_export' - (DATETIME) Buchhaltung-Export,
                       'inv_editable' - (INT, 11) änderbar,
                       'inv_type' - (TEXT) Rechnungsart,
                       'inv_reason' - (TEXT, 15) Grund,
                       'inv_comment' - (TEXT) Kommentar,
                       'inv_email' - (TEXT) Rechnungs E-Mail,
                       'inv_taxidentnumber' - (TEXT) Umsatzsteuer-ID,
                       'inv_taxident_status' - (TEXT) Umsatzsteuer-ID Status,
                       'inv_third_country_export' - (TEXT) Ausfuhrbescheinigung ,
                       'inv_deliver_country' - (TEXT) Lieferland,
                       'inv_tax_country' - (TEXT) Umsatzsteuer-Land,
                       'inv_currency' - (TEXT, 3) Währung,
                       'inv_pys_method' - (TEXT, 31) Zahlungsart,
                       'fk_inv_accid' - (INT, 11) Konto,
                       'inv_pay_profile_xdata' - (DATA) Zahlungsziel-Daten,
                       'drvd_amount_not_paid' - (FLOAT, 13,2) Ausstehender Rechnungsbetrag,
                       'drvd_amount_open_days' - (INT) Offen seit ... Tagen,
                       'drvd_days_until_paid' - (INT) Bezahlt nach ... Tagen,
                       'drvd_inv_name' - (TEXT) Name (kombiniert),
                       'inv_reminder_level' - (INT, 11) ,
                       'inv_reminder_data' - (TEXT) Mahndaten,
                       'inv_reminder_profile_label' - (TEXT, 127) Mahnprofil,
                       'inv_reminder_time_last_sent' - (DATETIME) Letzte Mahnung gesendet,
                       'inv_reminder_time_last_change' - (DATETIME) Letzte Mahnstufe-Änderung,
                       'inv_reminder_prop_level' - (INT, 11) Mahnstufe (vorgeschlagen),
                       'inv_reminder_prop_xdata' - (TEXT) Mahnstufen-Daten (vorgeschlagen),
                       'inv_reminder_prop_time' - (DATETIME) Mahnstufen-Vorschlag (Berechnung),
                       'inv_reminder_suspend_time' - (DATETIME) Mahnstopp Zeitpunkt,
                       'inv_extcollect_time' - (DATETIME) Inkasso-Übergabe,
                       'inv_extcollect_code' - (TEXT, 127) Inkasso Code,
                       'inv_extcollect_xdata' - (TEXT) Inkasso-Daten,
                       'persid' - (INT, 11) PersID,
                       'personid' - (TEXT, 32) Kunden-Nr.,
                       'fk_p_grpid' - (INT, 11) Kundengruppe,
                       'fk_p_shopid' - (INT, 11) Shop,
                       'gender' - (TEXT) Anrede,
                       'gender_color' - (TEXT, 15) ,
                       'title' - (TEXT) Titel,
                       'salutation' - (TEXT) Anrede formal,
                       'firstname' - (TEXT) Vorname,
                       'lastname' - (TEXT) Nachname,
                       'bday' - (DATE) Geburtsdatum,
                       'drvd_age' - (INT) Alter,
                       'drvd_bday_days_until_next' - (INT) Nächster Geburtstag (in Tagen),
                       'drvd_bday_next' - (DATE) Nächster Geburtstag,
                       'company' - (TEXT) Firma,
                       'p_department' - (TEXT) Abteilung,
                       'p_job_position' - (TEXT) Position,
                       'address2' - (TEXT) Adressenzusatz,
                       'street' - (TEXT) Straße,
                       'housenr' - (TEXT) Hausnummer,
                       'zip' - (TEXT) PLZ,
                       'town' - (TEXT) Ort,
                       'state_code' - (TEXT, 15) Bundesland (Code),
                       'country' - (TEXT, 2) Land,
                       'drvd_person_name' - (TEXT) Kundenname (kombiniert),
                       'drvd_p_address' - (TEXT) Adresse,
                       'email' - (TEXT, 127) E-Mail,
                       'telephone' - (TEXT) Telefon,
                       'telephone_mobile' - (TEXT) Tel. mobil,
                       'telefax' - (TEXT) Fax,
                       'p_invoice_type' - (TEXT) Rechnungsart,
                       'p_invoice_email' - (TEXT) E-Mail (Rechnung),
                       'taxident' - (TEXT) Umsatzsteuer-ID,
                       'taxident_status' - (TEXT) Umsatzsteuer-ID-Status,
                       'score' - (INT, 7) Bonitätswert,
                       'score_time_set' - (DATETIME) Letzter Rating-Check,
                       'score_time_invalid' - (DATETIME) Abgelaufen am,
                       'svc_code' - (TEXT) Rating ServiceCode,
                       'svc_txt' - (TEXT) Rating ServiceText,
                       'p_login_username' - (TEXT, 63) Benutzername,
                       'p_login_pwd_encrypted' - (TEXT) Passwort (verschlüsselt),
                       'p_login_pwd_key' - (TEXT) Direct-Login-Token,
                       'p_login_time_last' - (DATETIME) Letzter Login,
                       'p_login_pwd_must_renew_after' - (DATETIME) Passwort-Änderung auffordern ab,
                       'p_login_pwd_key_timeout' - (DATETIME) Direct-Login-Token Timeout,
                       'p_login_pwd_last_renewed' - (DATETIME) Passwort zuletzt geändert,
                       'p_login_active' - (INT, 1) Aktiv,
                       'p_email_verify_token' - (TEXT, 32) ,
                       'p_email_verify_token_timeout' - (DATETIME) ,
                       'p_email_verified_time' - (DATETIME) ,
                       'p_login_mode' - (TEXT, 15) Login-Modus,
                       'p_login_2fa_code' - (TEXT) 2FA - Login Code,
                       'p_login_2fa_timeout' - (DATETIME) 2FA - Login Code Timeout,
                       'p_login_err_count' - (INT, 4) Anzahl Fehllogins,
                       'p_login_time_min' - (DATETIME) Login Sperrzeit,
                       'p_register_state' - (TEXT, 15) Registrierungsstatus,
                       'p_register_code' - (TEXT, 32) Registrierungscode,
                       'p_register_code_timeout' - (DATETIME) Registrierungscode Timeout,
                       'p_onetime_pwd' - (TEXT) Einmal-Passwort,
                       'p_onetime_pwd_timeout' - (DATETIME) Einmal-Passwort Timeout,
                       'p_login_state' - (TEXT, 15) Login Status,
                       'p_login_state_color' - (TEXT, 15) ,
                       'p_oo_set_label' - (TEXT, 63) Bestelloptionen-Profil,
                       'fk_p_pay_profile_id' - (INT, 11) Zahlungsziel-Profil,
                       'fk_p_prcgrp_id' - (INT, 11) Preisgruppe,
                       'p_price_factor' - (FLOAT, 10,4) Preis-Faktor,
                       'p_person_prices' - (INT, 1) Persönliche Preise,
                       'fk_p_campid' - (INT, 11) Kampagne,
                       'p_allow_email_marketing' - (INT, 1) Zustimmung zu Marketing-Mails,
                       'drvd_emailmarketing_unsubscribetoken' - (TEXT) Token für Direktabmeldung Marketingmails,
                       'p_ip_address' - (TEXT, 15) IP-Adresse,
                       'p_referrer' - (TEXT) Referrer,
                       'p_useragent' - (TEXT) User Agent,
                       'p_personid_external' - (TEXT, 127) Externe Kunden-Nr.,
                       'p_comment_internal' - (TEXT) Interner Kommentar,
                       'p_locale' - (DATA) Locale Kunde,
                       'p_volfile' - (DATA) ,
                       'time_insert' - (DATETIME) Angelegt am,
                       'user_insert' - (TEXT, 127) Ersteller,
                       'time_update' - (DATETIME) Geändert am,
                       'user_update' - (TEXT, 127) Letzte Änderung durch,
                       'drvd_timeonly_timeinsert' - (TEXT) Angelegt (Uhrzeit),
                       'p_anonymize_time' - (DATETIME) Anoymisiert am,
                       'grpid' - (INT, 11) ,
                       'grp_name' - (TEXT, 127) Kundengruppe,
                       'description' - (TEXT) Beschreibung,
                       'grp_default' - (INT, 1) Default,
                       'grp_p_login_active' - (INT, 1) Kundenlogin Default Aktiv,
                       'grp_locale' - (DATA) Locale Kundengruppe,
                       'grp_state' - (TEXT, 63) Bestellstatus,
                       'grp_pos' - (TEXT, 63) POS Channel,
                       'prc_display_mode' - (TEXT, 15) Preisanzeige,
                       'grp_price_factor' - (FLOAT, 10,4) Preis-Faktor,
                       'fk_grp_prcgrp_id' - (INT, 11) Standard-Preisgruppe,
                       'grp_persongrp_prices' - (INT, 1) Gruppenspezifische Preise,
                       'grp_price_col' - (TEXT, 31) Preisspalte,
                       'grp_discount_col' - (TEXT, 63) Preisspalte (Discount),
                       'grp_discount_start_col' - (TEXT, 63) Preisspalte (Discount Start),
                       'grp_discount_end_col' - (TEXT, 63) Preisspalte (Discount Ende),
                       'grp_price_dsc_scale_col' - (TEXT, 63) Preisspalte (Staffelpreise),
                       'grp_price_prcgrp_col' - (TEXT, 63) Preisgruppen-Spalte,
                       'grp_price_state_col' - (TEXT, 63) Spalte für Shop-Status
,
                       'grp_price_hide_price_dsp_col' - (TEXT, 63) Spalte für Preis ausblenden,
                       'grp_oo_set_label' - (TEXT, 63) Bestelloptionen-Profil,
                       'fk_grp_pay_profile_id' - (INT, 11) Zahlungsziel-Profil,
                       'data' - (DATA) Daten,
                       'grp_shopuserright_profiles' - (TEXT) Gruppen-Rollen,
                       'grp_shopuserright_rights' - (TEXT) Gruppen-Rechte,
                       'fk_p_companyaccount_parent_persid' - (INT) Firmenaccount,
                       'p_companyaccount_budget_cart_max' - (FLOAT, 10,2) Budget Warenkorb,
                       'p_companyaccount_cost_center_customer' - (TEXT) Kunden Kostenstelle,
                       'p_companyaccount_type' - (TEXT) ,
                       'p_companyaccount_xdata' - (DATA) ,
                       'p_accounting_debtor_account' - (TEXT) Buchhaltung Debitorenkonto,
                       'fk_pers_inv_reminder_profile' - (TEXT, 127) Mahnprofil,
                       'p_merchant_xdata' - (DATA) Anbieter (Zusatzdaten),
                       'p_shopuserright_profiles' - (TEXT) Benutzer-Rollen,
                       'p_shopuserright_rights' - (TEXT) Benutzer-Rechte,
                       'xc__active' - (INT, 1) Aktiv,
                       'xc__searchable' - (INT, 1) Suchbar,
                       'xc__version' - (INT, 11) Version,
                       'xc__current' - (INT, 1) Aktuell,
                       'xc__insert_user' - (TEXT, 127) Ersteller,
                       'xc__insert_time' - (DATETIME) Angelegt am,
                       'xc__valid' - (INT, 1) Valide,
                       'xc__update_time' - (DATETIME) Geändert am,
                       'xc__install_time' - (DATETIME) Installiert am,
                       'xc__publish_start' - (DATETIME) Veröffentlichung (Start),
                       'xc__publish_end' - (DATETIME) Veröffentlichung (Ende),
                       'xc__update_user' - (TEXT, 127) Letzte Änderung durch,
                       'xc__ecms_data' - (TEXT) eCMS-Daten,
                       'xc__id' - (INT, 11) ID,
                       'drvd_xc_display' - (TEXT) Titel,
                       'drvd_is_master' - (INT, 1) Ist Masterprodukt,
                       'name' - (TEXT) Name,
                       'master_pcode' - (TEXT) Varianten-Master PCode,
                       'prdv_color' - (TEXT) Varianten-Farbe,
                       'prdv_size' - (TEXT) Varianten-Größe,
                       'prdv_other' - (TEXT) Varianten-Ausführung,
                       'prd_comment' - (TEXT) Kommentar,
                       'files_doc' - (DATA) Produkt-Dateien,
                       'pack_amount' - (FLOAT) Verpackungs­menge,
                       'pack_unit' - (TEXT) Verpackungs­einheit,
                       'prd_ingr_amount' - (FLOAT) Verpackungs­inhalt (Menge),
                       'prd_ingr_unit' - (TEXT) Verpackungs­inhalt (Einheit),
                       'prd_weight' - (FLOAT) Produktgewicht,
                       'prd_virtual' - (TEXT) Virtuelles Produkt,
                       'products_replace' - (DATA) Nachfolge­produkte,
                       'pcode_manufacturer' - (TEXT) Hersteller-PCode,
                       'brand' - (TEXT) Brand,
                       'products_upselling' - (DATA) Upselling-Produkte,
                       'products_related' - (DATA) Zugehörige Produkte,
                       'orderitem_name' - (TEXT) Auftrags­posten-Name,
                       'orderitem_text' - (TEXT) Auftrags­posten-Text,
                       'marketing_name' - (TEXT) Marketing-Name,
                       'marketing_teaser' - (TEXT) Marketing-Teaser,
                       'marketing_image' - (DATA) Marketing-Bild,
                       'new_product' - (TEXT) Neues Produkt?,
                       'special_offer_product' - (TEXT) Special-Offer Produkt?,
                       'plugin' - (TEXT) Plugin,
                       'meta_title' - (TEXT) Produkt-Meta-Titel,
                       'meta_keywords' - (TEXT) Produkt-Meta-Keywords,
                       'meta_description' - (TEXT) Produkt-Meta-Beschreibung,
                       'meta_robots_noindex' - (TEXT) Produkt-Meta-Robots-NoIndex,
                       'meta_robots_nofollow' - (TEXT) Produkt-Meta-Robots-NoFollow,
                       'marketing_image_background' - (DATA) Marketing-Hintergrundbild,
                       'marketing_overlay_html' - (TEXT) Marketing-Overlay-HTML,
                       'description_seo' - (TEXT) SEO-Beschreibung,
                       'prd_width' - (FLOAT) Produktgröße - Breite,
                       'prd_height' - (FLOAT) Produktgröße - Höhe,
                       'prd_depth' - (FLOAT) Produktgröße - Tiefe,
                       'prd_rating_avg' - (FLOAT) ,
                       'prd_rating_cnt' - (TEXT) ,
                       'convertable_pack_unit' - (DATA) ,
                       'prd_accounting_cost_center' - (TEXT) Buchhaltung Kostenstelle,
                       'prd_accounting_revenue_account' - (TEXT) Buchhaltung Erlöskonto,
                       'base_color' - (TEXT) Grundfarbe,
                       'html_canonical' - (TEXT) ,
                       'pack_size_width' - (TEXT) Verpackungs­größe - Breite,
                       'pack_size_height' - (TEXT) Verpackungs­größe - Höhe,
                       'pack_size_depth' - (TEXT) Verpackungs­größe - Tiefe,
                       'pack_weight' - (FLOAT) Verpackungs­gewicht,
                       'features' - (DATA) ,
                       'gtin' - (TEXT) GTIN/EAN,
                       'ppn' - (TEXT) PPN,
                       'origin_country' - (TEXT) Ursprungsland,
                       'customs_tariff_number' - (TEXT) HS-Tariff-Code,
                       'customs_value_amount' - (TEXT) ,
                       'customs_description' - (TEXT) Zoll-Beschreibung,
                       'files_download' - (DATA) Download-Dateien,
                       'products_contain' - (DATA) Produkte im Bundle,
                       'prd_keywords' - (TEXT) Keywords,
                       'files_img' - (DATA) Bilder,
                       'prd_bundle_price_discount_perc' - (FLOAT) Bundle-Preis %-Discount,
                       'desc_short' - (TEXT) Kurz­beschreibung,
                       'prd_snr_xdata_subtype' - (TEXT) Zusatzdaten-Typ,
                       'prd_bundle_resolve_mode' - (TEXT) Bundle-Modus,
                       'desc_tech' - (TEXT) Technische Beschreibung,
                       'manufacturer' - (TEXT) Hersteller,
                       'xc__label' - (TEXT) ,
                       'xc__title' - (TEXT) ,
                       'xc__image' - (DATA) ,
                       'drvd_variant_specification' - (TEXT) Ausprägung,
                       'currency' - (TEXT) ,
                       'cy_name' - (TEXT, 63) Name,
                       'cy_nameshort' - (TEXT, 15) Kurzname,
                       'drvd_inv_state_name' - (TEXT) Bundesland,
                       'drvd_inv_state_path' - (TEXT) Bundesland (Pfad),
                       'oid' - (INT, 11) ,
                       'orderid' - (TEXT, 63) Auftrags-Nr.,
                       'fk_o_shopid' - (INT, 11) Shop,
                       'fk_o_persid' - (INT, 11) Kunde,
                       'o_time_ordered' - (DATETIME) Bestell­datum,
                       'total_netto' - (FLOAT, 13,2) ∑ Gesamt, Netto,
                       'total_brutto' - (FLOAT, 13,2) ∑ Gesamt, Brutto,
                       'o_orderid_external' - (TEXT, 255) Externe Auftrags-Nr.,
                       'fk_o_posid' - (INT, 11) POS Channel (ID),
                       'fk_o_stid' - (INT, 11) Status,
                       'fk_o_st_id' - (INT, 11) Versandart,
                       'o_pers_reftext' - (TEXT) Kunden-Referenztext,
                       'o_pers_seq_nr' - (INT, 11) Auftrags-Sequenz-Nr.,
                       'quantity' - (FLOAT, 13,4) Bestellmenge,
                       'drvd_total_vat' - (FLOAT, 13,2) MwSt. (Gesamt),
                       'otitle' - (TEXT) Auftragstitel,
                       'otext' - (TEXT) Auftragsbeschreibung,
                       'o_type' - (TEXT, 15) Auftragstyp,
                       'o_valid_until' - (DATETIME) Gültig bis,
                       'o_txt_header' - (TEXT) Kopf-Text,
                       'o_txt_footer' - (TEXT) Fuß-Text,
                       'invoice_addr_preset' - (TEXT) Adressbuch (R),
                       'invoice_gender' - (TEXT) Anrede (R),
                       'invoice_title' - (TEXT) Titel (R),
                       'invoice_firstname' - (TEXT) Vorname (R),
                       'invoice_lastname' - (TEXT) Nachname (R),
                       'invoice_company' - (TEXT) Firma (R),
                       'invoice_addrextra' - (TEXT) Adressenzusatz,
                       'invoice_street' - (TEXT) Straße (R),
                       'invoice_housenr' - (TEXT) Hausnummer (R),
                       'invoice_zip' - (TEXT) PLZ (R),
                       'invoice_town' - (TEXT) Ort (R),
                       'invoice_state_code' - (TEXT, 15) Bundesland (Code) (R),
                       'invoice_country' - (TEXT, 2) Land (R),
                       'invoice_type' - (TEXT) Rechnungsart,
                       'invoice_email' - (TEXT) E-Mail (R),
                       'invoice_taxidentnumber' - (TEXT) USt.ID-Nr.,
                       'invoice_taxident_status' - (TEXT) USt.ID-Nr. Status,
                       'invoice_third_country_export' - (TEXT) Ausfuhrbescheinigung,
                       'invoice_lang_iso' - (TEXT, 2) Rechnungssprache,
                       'drvd_invoice_street_housenr' - (TEXT) Straße+Nr (R),
                       'deliver_addr_preset' - (DATA) Adressbuch (L),
                       'deliver_gender' - (TEXT) Anrede (L),
                       'deliver_title' - (TEXT) Titel (L),
                       'deliver_firstname' - (TEXT) Vorname (L),
                       'deliver_lastname' - (TEXT) Nachname (L),
                       'deliver_company' - (TEXT) Firma (L),
                       'deliver_addrextra' - (TEXT) Adressenzusatz,
                       'deliver_street' - (TEXT) Straße (L),
                       'deliver_housenr' - (TEXT) Hausnummer (L),
                       'deliver_zip' - (TEXT) PLZ (L),
                       'deliver_town' - (TEXT) Ort (L),
                       'deliver_state_code' - (TEXT, 15) Bundesland (Code) (L),
                       'deliver_country' - (TEXT, 2) Land (L),
                       'deliver_date_req' - (TEXT) Kunden-Wunschtermin,
                       'deliver_phone' - (TEXT) Telefon,
                       'deliver_email' - (TEXT) E-Mail (L),
                       'deliver_comment' - (TEXT) Liefer-Hinweise,
                       'drvd_deliver_street_housenr' - (TEXT) Straße+Nr (L),
                       'deliver_notes_xdata' - (DATA) Lieferhinweise,
                       'ip_address' - (TEXT) IP-Adresse,
                       'o_referrer' - (TEXT) Referrer,
                       'o_useragent' - (TEXT) User-Agent,
                       'o_comment' - (TEXT) Kundenkommentar,
                       'o_comment_internal' - (TEXT) Interner Bestellhinweis,
                       'o_lock_time' - (DATETIME) Bearbeitungs-Sperre (Zeitpunkt),
                       'o_lock_user' - (TEXT, 31) Bearbeitungs-Sperre (Benutzer),
                       'o_insert_time' - (DATETIME) Angelegt am,
                       'o_update_time' - (DATETIME) Geändert am,
                       'o_insert_user' - (TEXT, 127) Ersteller,
                       'o_update_user' - (TEXT, 127) Letzte Änderung durch,
                       'fk_o_campid' - (INT, 11) Kampagne,
                       'drvd_o_shoplabel' - (TEXT) Shop,
                       'drvd_invoice_address' - (TEXT) Auftrag-Rg.Adresse,
                       'drvd_deliver_address' - (TEXT) Auftrag-Lfg.Adresse,
                       'o_pay_profile_xdata' - (DATA) Zahlungsziel-Daten,
                       'fk_o_companyaccount_subaccount_persid' - (INT, 11) Unteraccount,
                       'fk_o_mrch_id' - (INT, 11) Verkaufender Anbieter,
                       'fk_o_parent_oid' - (INT, 11) Hauptauftrag,
                       'o_merchant_xdata' - (DATA) Anbieter (Zusatzdaten),
                       'o_periodic_time_first' - (DATETIME) Abo-Startdatum,
                       'o_periodic_time_last' - (DATETIME) Abo-Enddatum,
                       'o_periodic_time_next' - (DATETIME) Nächste Abo-Ausführung,
                       'o_periodic_timeorder_offset' - (TEXT, 31) Abweichendes Auftragsdatum,
                       'o_periodic_time_strict' - (INT, 1) Strikt,
                       'o_periodic_exec_period' - (TEXT, 31) Abo-Intervall,
                       'o_periodic_exec_inprogress' - (INT, 1) Wird gerade ausgeführt,
                       'o_periodic_xdata' - (DATA) ,
                       'drvd_weekday_timeordered' - (TEXT) Wochen­tag,
                       'drvd_hour_timeordered' - (TEXT) Stunde,
                       'drvd_month_timeordered' - (TEXT) Bestell­monat,
                       'drvd_dayofmonth_timeordered' - (TEXT) Bestelltag im Monat,
                       'drvd_timeonly_timeordered' - (TEXT) Bestellzeit,
                       'drvd_cluster_seq' - (TEXT) Erst-/Wiederkauf,
                       'order_state_transtime' - (DATETIME) Transaktionszeit,
                       'order_state_code' - (TEXT, 63) Auftragsstatus (Code),
                       'order_state_color' - (TEXT, 15) Status-Farbe,
                       'order_state_name' - (TEXT) Auftragsstatus (Name),
                       'order_state_name_public' - (TEXT) Auftragsstatus (öffentlicher Name),
                       'inv_email_time_send' - (DATETIME) Letzter Rechnungsversand,
                       'pos_name' - (TEXT, 127) POS Channel,
                #}
          {% set dataList = hublify.dataset('invoiceitem')
              .fields([
                  'invi_id',
                  'invi_pcode',
              ])
              .filter('invi_id','<something>')
              .one()
          %}
      

api(). ... - create

For how-to insert a record...

api(). ... - update

For how-to update a record...

WHAT ELSE, you'd like ??

...