delivery - "Lieferung" 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 "delivery".
Other retrievable fields of delivery are:
'did' - (INT, 11) ,
'dv_seller_name' - (TEXT) Verkäufername,
'dv_seller_name2' - (TEXT) Adressenzusatz,
'dv_seller_street' - (TEXT) Straße,
'dv_seller_hnr' - (TEXT) Hausnr.,
'dv_seller_zip' - (TEXT) PLZ,
'dv_seller_city' - (TEXT) Ort,
'dv_seller_state_code' - (TEXT, 15) Bundesland (Code) (Verkäufer),
'dv_seller_country' - (TEXT, 2) Land,
'dv_code' - (TEXT, 63) Lieferungs-Nr.,
'dv_extcode' - (TEXT, 63) Sendungsnr.,
'fk_dv_persid' - (INT, 11) Kunde,
'fk_dv_oid' - (INT, 11) Auftrags-Nr.,
'fk_dv_st_id' - (INT, 11) Versandart,
'dv_time_insert' - (DATETIME) Angelegt am,
'dv_time_update' - (DATETIME) Geändert am,
'dv_user_insert' - (TEXT, 127) Ersteller,
'dv_user_update' - (TEXT, 127) Letzte Änderung durch,
'dv_time_sent' - (DATETIME) Versendet am,
'dv_comment' - (TEXT) Kommentar,
'dv_comment_internal' - (TEXT) Interner Kommentar,
'dv_name' - (TEXT) Name,
'dv_company' - (TEXT) Firma,
'dv_name2' - (TEXT) Adressenzusatz,
'dv_street' - (TEXT) Straße,
'dv_hnr' - (TEXT) Hausnr.,
'dv_zip' - (TEXT) PLZ,
'dv_city' - (TEXT) Ort,
'dv_state_code' - (TEXT, 15) Bundesland (Code),
'dv_country' - (TEXT, 2) Land,
'dv_phone' - (TEXT) Telefon,
'drvd_dv_seller_street_hnr' - (TEXT) Straße+Nr (Verkäufer),
'drvd_dv_street_hnr' - (TEXT) Straße+Nr (L),
'drvd_dv_cnt_dvi' - (FLOAT, 13,4) Anzahl Lagerartikel,
'delivery_state_color' - (TEXT, 15) ,
'item_id' - (INT) ,
'i18n_st_name' - (TEXT) Statusname,
'i18n_st_name_public' - (TEXT) Öffentlicher Statusname,
'st_x_dv_sent' - (INT, 4) ,
'st_code' - (TEXT) Status,
'st_position' - (INT) ,
'is_current' - (INT, 1) ,
'transtime' - (DATETIME) ,
'st_id' - (INT, 11) ,
'st_grp_name' - (TEXT, 63) Versandart (L),
'st_label' - (TEXT, 63) Versandart-Label (L),
'st_desc' - (TEXT) Versandart-Beschreibung (L),
'st_deliver_category' - (TEXT, 31) Versand-Kategorie (L),
'st_settings' - (DATA) Versandart-Einstellungen (L),
'oid' - (INT, 11) OID,
'fk_o_shopid' - (INT, 11) Shop,
'orderid' - (TEXT, 63) Auftrags-Nr.,
'fk_o_persid' - (INT, 11) Kunde,
'o_time_ordered' - (DATETIME) Bestelldatum,
'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),
'currency' - (TEXT, 3) Währung,
'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,
'pos_addrline' - (TEXT) Adresszeile (POS),
'drvd_invoice_address' - (TEXT) Auftrag-Rg.Adresse,
'drvd_deliver_address' - (TEXT) Auftrag-Lfg.Adresse,
'o_pay_profile_xdata' - (DATA) Zahlungsziel-Daten,
'drvd_o_omsg_cnt' - (INT, 11) ,
'drvd_o_omsg_time_last' - (DATETIME, 11) ,
'fk_o_companyaccount_subaccount_persid' - (INT, 11) Unteraccount,
'companyaccount_subaccount_personid' - (TEXT) Unteraccount Kunden-Nr.,
'companyaccount_subaccount_email' - (TEXT) Unteraccount E-Mail ,
'companyaccount_subaccount_firstname' - (TEXT) Unteraccount Vorname,
'companyaccount_subaccount_lastname' - (TEXT) Unteraccount Nachname,
'fk_o_mrch_id' - (INT, 11) Verkaufender Anbieter,
'fk_o_parent_oid' - (INT, 11) Hauptauftrag,
'drvd_parent_orderid' - (TEXT) Hauptauftrag,
'o_merchant_xdata' - (DATA) Anbieter (Zusatzdaten),
'mrch_id' - (INT, 11) ,
'fk_mrch_persid' - (INT, 11) Kundenkonto des Anbieters,
'mrch_code' - (TEXT, 31) Anbieter-Nr.,
'mrch_code_external' - (TEXT) Externe Anbieternr.,
'mrch_name' - (TEXT) Anbietername,
'mrch_description' - (TEXT) Beschreibung,
'mrch_active' - (INT, 1) Aktiv,
'mrch_company' - (TEXT) Firma,
'mrch_address2' - (TEXT) Adresszusatz,
'mrch_street' - (TEXT) Straße,
'mrch_housenr' - (TEXT) Hausnr.,
'mrch_zip' - (TEXT) PLZ,
'mrch_town' - (TEXT) Ort,
'mrch_country' - (TEXT) Land,
'mrch_homepage' - (TEXT) Homepage,
'mrch_support_email' - (TEXT) Support E-Mail,
'mrch_support_phone' - (TEXT) Support Telefon,
'mrch_support_fax' - (TEXT) Support Fax,
'mrch_contacts' - (DATA) Kontakte,
'mrch_conditions' - (DATA) ,
'mrch_xdata' - (DATA) Zusatzdaten,
'mrch_xsettings' - (DATA) Einstellungen,
'mrch_insert_user' - (TEXT, 127) Ersteller,
'mrch_update_user' - (TEXT, 127) Letzte Änderung durch,
'mrch_insert_time' - (DATETIME) Angelegt am,
'mrch_update_time' - (DATETIME) Geändert am,
'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) Wochentag,
'drvd_hour_timeordered' - (TEXT) Stunde,
'drvd_month_timeordered' - (TEXT) Bestellmonat,
'drvd_dayofmonth_timeordered' - (TEXT) Bestelltag im Monat,
'drvd_timeonly_timeordered' - (TEXT) Bestellzeit,
'drvd_cluster_seq' - (TEXT) Erst-/Wiederkauf,
'campaign_name' - (TEXT, 127) Kampagne,
'shipping_type_label' - (TEXT, 63) Versandart,
'shipping_type_grp_name' - (TEXT, 63) Versandart-Gruppe,
'shipping_type_deliver_category' - (TEXT, 31) Lieferkategorie,
'posid' - (INT, 11) ,
'pos_name' - (TEXT, 127) POS Channel,
'pos_shortdesc' - (TEXT) Kurzbeschreibung,
'available' - (INT, 1) Verfügbar,
'default_pos' - (INT, 1) Default,
'pos_xsettings' - (DATA) Einstellungen,
'pos_insert_user' - (TEXT, 127) Ersteller,
'pos_update_user' - (TEXT, 127) Letzte Änderung durch,
'pos_insert_time' - (DATETIME) Angelegt am,
'pos_update_time' - (DATETIME) Geändert am,
'api_channel_token' - (TEXT) API-Channel-Token,
'campid' - (INT, 11) ,
'fk_camp_shopid' - (INT, 11) Shop,
'camp_name' - (TEXT, 127) Kampagnen-Name,
'camp_short_desc' - (TEXT, 127) Kurzbeschreibung,
'camp_objective' - (TEXT, 65536) Zielsetzung,
'camp_desc' - (TEXT) Beschreibung,
'camp_active' - (INT, 2) Aktiv,
'camp_color' - (TEXT, 31) Farbcode,
'camp_time_start' - (DATETIME) Startzeit,
'camp_time_end' - (DATETIME) Endzeit,
'camp_urlvarvalue' - (TEXT, 31) URL Variablenwert,
'camp_source' - (TEXT, 31) Quelle,
'camp_medium' - (TEXT, 31) Medium,
'camp_term' - (TEXT, 31) Begriff,
'camp_content' - (TEXT, 31) Inhalt,
'camp_campaign' - (TEXT, 31) Zusatz-Name,
'camp_track_interval' - (INT, 11) Erkennungszeitraum,
'camp_trackvars' - (TEXT) Tracking-Variablen,
'camp_tracing_javascript' - (TEXT) Verfolgungs-Javascript,
'camp_tracing_code' - (TEXT) Verfolgungs-Code,
'camp_external_id' - (TEXT, 63) Externer Kampagnen-Id,
'camp_external_src' - (TEXT, 127) Externer Kampagnen-Quelle,
'camp_person_grpid' - (INT, 11) Kundengruppe,
'camp_prc_col' - (TEXT, 63) Preisspalte,
'camp_prc_mode' - (TEXT, 7) Preismodus,
'camp_expected_order_revenue' - (FLOAT, 13,4) Erwarteter Umsatz (Order),
'camp_expected_order_cnt' - (INT, 11) Erwartete Anzahl (Order),
'camp_expected_lead_cnt' - (INT, 11) Erwartete Anzahl (Leads),
'camp_expected_impression_cnt' - (INT, 11) Erwartete Impressions,
'camp_expected_costs' - (FLOAT, 13,4) Erwartete Kosten,
'camp_costs_actual' - (FLOAT, 13,4) Kosten - aktuell,
'camp_costs_initial' - (FLOAT, 13,4) Kosten, einmalig,
'camp_costs_po_abs' - (FLOAT, 13,4) Kosten pro Order, absolut (CPO-a),
'camp_costs_po_perc' - (FLOAT, 8,4) Kosten pro Order, prozentual (CPO-p),
'camp_costs_pi_abs' - (FLOAT, 13,4) Kosten pro Impression, absolut (CPI),
'camp_commission_initial' - (FLOAT, 13,4) Provision, einmalig,
'camp_commission_po_abs' - (FLOAT, 13,4) Provision per Order, absolut,
'camp_commission_po_perc' - (FLOAT, 8,4) Provision per Order, prozentual,
'camp_commission_pi_abs' - (FLOAT, 13,4) Provision pro Impression,
'camp_progress_data' - (DATA) Verlaufsdaten,
'camp_insert_user' - (TEXT, 127) Ersteller,
'camp_update_user' - (TEXT, 127) Letzte Änderung durch,
'camp_time_insert' - (DATETIME) Angelegt am,
'camp_time_update' - (DATETIME) Geändert am,
'drvd_camp_difftime_end_day' - (INT, 11) Zeit bis Ende,
'drvd_inv_cy_name' - (TEXT) Rechnungsland,
'drvd_inv_cy_nameshort' - (TEXT) Rechnungsland Kurzname,
'drvd_del_cy_name' - (TEXT) Lieferland,
'drvd_del_cy_nameshort' - (TEXT) Lieferland Kurzname,
'drvd_invoice_state_name' - (TEXT) Bundesland (R),
'drvd_invoice_state_path' - (TEXT) Bundesland (Pfad) (R),
'drvd_deliver_state_name' - (TEXT) Bundesland (L),
'drvd_deliver_state_path' - (TEXT) Bundesland (Pfad) (L),
'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,
'p_login_pwd_plain' - (TEXT, 64) Neues Passwort,
'drvd_order_timelast' - (DATETIME) Letzte Bestellung,
'drvd_order_timefirst' - (DATETIME) Erste Bestellung,
'drvd_order_frequency' - (FLOAT, 9,2) Bestellfrequenz,
'drvd_order_count' - (INT, 11) # Aufträge,
'p_profile_photo' - (TEXT) Bild,
'node_id' - (INT, 11) ,
'drvd_dv_dvi_si_weight' - (FLOAT, 13,4) Gewicht (kg),
'drvd_dv_dvi_si_available_confirm_date' - (DATETIME) ,
'fk_dv_psid' - (INT, 11) Packstation,
'fk_dv_dgrp_id' - (INT, 11) Versandliste,
'dv_cost_total_ship' - (FLOAT, 13,2) Versandkosten,
'dv_cost_total_purchase' - (FLOAT, 13,2) Artikel-Einkaufskosten,
'dv_time_rsvd' - (DATETIME) Reserviert am,
'dv_time_transfer' - (DATETIME) Transferiert am,
'dv_time_planned_send' - (DATETIME) Geplante Sendezeit,
'drvd_dv_cnt_dvi_reserved' - (FLOAT, 13,4) Reserviert,
'drvd_dv_cnt_dvi_not_reserved' - (FLOAT, 13,4) Nicht reserviert,
'drvd_dv_cnt_dvi_reserved_confirmed' - (FLOAT, 13,4) Reserviert (bestätigt),
'drvd_dv_cnt_dvi_not_reserved_confirmed' - (FLOAT, 13,4) Nicht reserviert (bestätigt),
'drvd_dvi_items_info' - (TEXT) Lieferartikel,
'dgrp_id' - (INT, 11) ,
'dgrp_code' - (TEXT, 27) Versandliste,
'dgrp_time_sent' - (DATETIME) Lieferdatum,
'st_x_dv_reqtopick' - (INT, 4) ,
'st_x_dv_inpicking' - (INT, 4) ,
'st_x_dv_delivered' - (INT, 4) ,
'st_x_dv_unrsvd' - (INT, 4) ,
'st_x_dv_rsvd' - (INT, 4) ,
'st_x_dv_sendable' - (INT, 4) ,
'psid' - (INT, 11) ,
'ps_name' - (TEXT) Name der Packstation,
'ps_owner_name' - (TEXT) Ansprechpartner,
'ps_owner_address2' - (TEXT) Adressenzusatz,
'ps_owner_street' - (TEXT) Straße,
'ps_owner_housenr' - (TEXT) Hausnummer,
'ps_owner_zip' - (TEXT) PLZ,
'ps_owner_city' - (TEXT) Ort,
'ps_owner_country' - (TEXT, 2) Land,
'ps_owner_email' - (TEXT) E-Mail,
'ps_owner_phone' - (TEXT) Telefon,
'ps_owner_fax' - (TEXT) Fax,
'ps_svc_exectime_1' - (TEXT) Service Montag,
'ps_svc_exectime_2' - (TEXT) Service Dienstag,
'ps_svc_exectime_3' - (TEXT) Service Mittwoch,
'ps_svc_exectime_4' - (TEXT) Service Donnerstag,
'ps_svc_exectime_5' - (TEXT) Service Freitag,
'ps_svc_exectime_6' - (TEXT) Service Samstag,
'ps_svc_exectime_7' - (TEXT) Service Sonntag,
'ps_svc_exec_active' - (INT, 1) Service AutoExec,
'ps_desc' - (TEXT) Beschreibung,
'ps_svc_interface_class' - (TEXT, 31) Service Interface,
'ps_svc_interface_config' - (DATA) Interface Konfiguration,
'ps_config' - (DATA) Konfiguration,
'ps_insert_time' - (DATETIME) Angelegt am,
'ps_insert_user' - (TEXT, 127) Ersteller,
'ps_update_time' - (DATETIME) Geändert am,
'ps_update_user' - (TEXT, 127) Letzte Änderung durch,
'fk_dv_shp_c_id' - (INT, 11) Logistiker,
'dv_carrier_time_pickedup' - (DATETIME) Abgeholt am (laut Logistiker),
'dv_carrier_time_delivered' - (DATETIME) Geliefert am (laut Logistiker),
'dv_carrier_status' - (TEXT) Logistiker-Sendungsstatus,
'dv_carrier_id' - (TEXT, 63) Logistiker externe ID,
'dv_shipping_details' - (DATA) Detail-Daten,
'drvd_dv_trace_url' - (TEXT) Sendung verfolgen,
'drvd_shipping_label_url' - (TEXT) Versandlabel,
'drvd_customs_declaration_url' - (TEXT) Zollerklärung,
'shp_c_id' - (INT, 11) ID,
'shp_c_label' - (TEXT, 31) Logistiker-Label,
'shp_c_name' - (TEXT) Logistiker-Name,
'shp_c_desc' - (TEXT) Logistiker-Beschreibung,
'shp_c_active' - (INT, 1) Logistiker aktiviert,
'shp_c_track_url' - (TEXT) Sendungsverfolgungs-URL,
'shp_c_interface_class' - (TEXT, 31) Logistiker-Interface,
'shp_c_interface_config' - (DATA) Logistiker-Interface-Einstellungen,
'shp_c_config' - (DATA) Einstellungen,
'shp_c_insert_time' - (DATETIME) Angelegt am,
'shp_c_insert_user' - (TEXT, 127) Ersteller,
'shp_c_update_time' - (DATETIME) Geändert am,
'shp_c_update_user' - (TEXT, 127) Letzte Änderung durch,
'cy_name' - (TEXT, 63) Lieferland,
'cy_nameshort' - (TEXT, 15) Lieferland Kurzname,
'drvd_dv_state_name' - (TEXT) Bundesland (Name),
'drvd_dv_state_path' - (TEXT) Bundesland (Pfad),
'drvd_dv_seller_state_name' - (TEXT) Bundesland (Name) (Verkäufer),
'drvd_dv_seller_state_path' - (TEXT) Bundesland (Pfad) (Verkäufer),
'drvd_dv_dvi_weight' - (FLOAT) Gewicht (kg),
'drvd_dv_itemlist' - (TEXT) ,
'drvd_inv_info' - (DATA) Rechnungen zum Auftrag,
'drvd_inv_codes' - (TEXT) Rg.Nummern zum Auftrag,
'inv_code' - (TEXT) ,
'drvd_inv_amount_total' - (FLOAT) Gesamtrechnungsbetrag zum Auftrag,
'drvd_inv_amount_not_paid' - (FLOAT) Ausstehender Rechnungsbetrag für den Auftrag,
'drvd_dv_info_others' - (TEXT) Weitere Lieferungen zum Auftrag,
'drvd_dv_codes_others' - (TEXT) Weitere Lfg.Nummern zum Auftrag,
#}
{% set dataList = hublify.dataset('delivery')
.fields([
'did',
'dv_code',
])
.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 "delivery".
Other retrievable fields of delivery are:
'did' - (INT, 11) ,
'dv_seller_name' - (TEXT) Verkäufername,
'dv_seller_name2' - (TEXT) Adressenzusatz,
'dv_seller_street' - (TEXT) Straße,
'dv_seller_hnr' - (TEXT) Hausnr.,
'dv_seller_zip' - (TEXT) PLZ,
'dv_seller_city' - (TEXT) Ort,
'dv_seller_state_code' - (TEXT, 15) Bundesland (Code) (Verkäufer),
'dv_seller_country' - (TEXT, 2) Land,
'dv_code' - (TEXT, 63) Lieferungs-Nr.,
'dv_extcode' - (TEXT, 63) Sendungsnr.,
'fk_dv_persid' - (INT, 11) Kunde,
'fk_dv_oid' - (INT, 11) Auftrags-Nr.,
'fk_dv_st_id' - (INT, 11) Versandart,
'dv_time_insert' - (DATETIME) Angelegt am,
'dv_time_update' - (DATETIME) Geändert am,
'dv_user_insert' - (TEXT, 127) Ersteller,
'dv_user_update' - (TEXT, 127) Letzte Änderung durch,
'dv_time_sent' - (DATETIME) Versendet am,
'dv_comment' - (TEXT) Kommentar,
'dv_comment_internal' - (TEXT) Interner Kommentar,
'dv_name' - (TEXT) Name,
'dv_company' - (TEXT) Firma,
'dv_name2' - (TEXT) Adressenzusatz,
'dv_street' - (TEXT) Straße,
'dv_hnr' - (TEXT) Hausnr.,
'dv_zip' - (TEXT) PLZ,
'dv_city' - (TEXT) Ort,
'dv_state_code' - (TEXT, 15) Bundesland (Code),
'dv_country' - (TEXT, 2) Land,
'dv_phone' - (TEXT) Telefon,
'drvd_dv_seller_street_hnr' - (TEXT) Straße+Nr (Verkäufer),
'drvd_dv_street_hnr' - (TEXT) Straße+Nr (L),
'drvd_dv_cnt_dvi' - (FLOAT, 13,4) Anzahl Lagerartikel,
'delivery_state_color' - (TEXT, 15) ,
'item_id' - (INT) ,
'i18n_st_name' - (TEXT) Statusname,
'i18n_st_name_public' - (TEXT) Öffentlicher Statusname,
'st_x_dv_sent' - (INT, 4) ,
'st_code' - (TEXT) Status,
'st_position' - (INT) ,
'is_current' - (INT, 1) ,
'transtime' - (DATETIME) ,
'st_id' - (INT, 11) ,
'st_grp_name' - (TEXT, 63) Versandart (L),
'st_label' - (TEXT, 63) Versandart-Label (L),
'st_desc' - (TEXT) Versandart-Beschreibung (L),
'st_deliver_category' - (TEXT, 31) Versand-Kategorie (L),
'st_settings' - (DATA) Versandart-Einstellungen (L),
'oid' - (INT, 11) OID,
'fk_o_shopid' - (INT, 11) Shop,
'orderid' - (TEXT, 63) Auftrags-Nr.,
'fk_o_persid' - (INT, 11) Kunde,
'o_time_ordered' - (DATETIME) Bestelldatum,
'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),
'currency' - (TEXT, 3) Währung,
'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,
'pos_addrline' - (TEXT) Adresszeile (POS),
'drvd_invoice_address' - (TEXT) Auftrag-Rg.Adresse,
'drvd_deliver_address' - (TEXT) Auftrag-Lfg.Adresse,
'o_pay_profile_xdata' - (DATA) Zahlungsziel-Daten,
'drvd_o_omsg_cnt' - (INT, 11) ,
'drvd_o_omsg_time_last' - (DATETIME, 11) ,
'fk_o_companyaccount_subaccount_persid' - (INT, 11) Unteraccount,
'companyaccount_subaccount_personid' - (TEXT) Unteraccount Kunden-Nr.,
'companyaccount_subaccount_email' - (TEXT) Unteraccount E-Mail ,
'companyaccount_subaccount_firstname' - (TEXT) Unteraccount Vorname,
'companyaccount_subaccount_lastname' - (TEXT) Unteraccount Nachname,
'fk_o_mrch_id' - (INT, 11) Verkaufender Anbieter,
'fk_o_parent_oid' - (INT, 11) Hauptauftrag,
'drvd_parent_orderid' - (TEXT) Hauptauftrag,
'o_merchant_xdata' - (DATA) Anbieter (Zusatzdaten),
'mrch_id' - (INT, 11) ,
'fk_mrch_persid' - (INT, 11) Kundenkonto des Anbieters,
'mrch_code' - (TEXT, 31) Anbieter-Nr.,
'mrch_code_external' - (TEXT) Externe Anbieternr.,
'mrch_name' - (TEXT) Anbietername,
'mrch_description' - (TEXT) Beschreibung,
'mrch_active' - (INT, 1) Aktiv,
'mrch_company' - (TEXT) Firma,
'mrch_address2' - (TEXT) Adresszusatz,
'mrch_street' - (TEXT) Straße,
'mrch_housenr' - (TEXT) Hausnr.,
'mrch_zip' - (TEXT) PLZ,
'mrch_town' - (TEXT) Ort,
'mrch_country' - (TEXT) Land,
'mrch_homepage' - (TEXT) Homepage,
'mrch_support_email' - (TEXT) Support E-Mail,
'mrch_support_phone' - (TEXT) Support Telefon,
'mrch_support_fax' - (TEXT) Support Fax,
'mrch_contacts' - (DATA) Kontakte,
'mrch_conditions' - (DATA) ,
'mrch_xdata' - (DATA) Zusatzdaten,
'mrch_xsettings' - (DATA) Einstellungen,
'mrch_insert_user' - (TEXT, 127) Ersteller,
'mrch_update_user' - (TEXT, 127) Letzte Änderung durch,
'mrch_insert_time' - (DATETIME) Angelegt am,
'mrch_update_time' - (DATETIME) Geändert am,
'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) Wochentag,
'drvd_hour_timeordered' - (TEXT) Stunde,
'drvd_month_timeordered' - (TEXT) Bestellmonat,
'drvd_dayofmonth_timeordered' - (TEXT) Bestelltag im Monat,
'drvd_timeonly_timeordered' - (TEXT) Bestellzeit,
'drvd_cluster_seq' - (TEXT) Erst-/Wiederkauf,
'campaign_name' - (TEXT, 127) Kampagne,
'shipping_type_label' - (TEXT, 63) Versandart,
'shipping_type_grp_name' - (TEXT, 63) Versandart-Gruppe,
'shipping_type_deliver_category' - (TEXT, 31) Lieferkategorie,
'posid' - (INT, 11) ,
'pos_name' - (TEXT, 127) POS Channel,
'pos_shortdesc' - (TEXT) Kurzbeschreibung,
'available' - (INT, 1) Verfügbar,
'default_pos' - (INT, 1) Default,
'pos_xsettings' - (DATA) Einstellungen,
'pos_insert_user' - (TEXT, 127) Ersteller,
'pos_update_user' - (TEXT, 127) Letzte Änderung durch,
'pos_insert_time' - (DATETIME) Angelegt am,
'pos_update_time' - (DATETIME) Geändert am,
'api_channel_token' - (TEXT) API-Channel-Token,
'campid' - (INT, 11) ,
'fk_camp_shopid' - (INT, 11) Shop,
'camp_name' - (TEXT, 127) Kampagnen-Name,
'camp_short_desc' - (TEXT, 127) Kurzbeschreibung,
'camp_objective' - (TEXT, 65536) Zielsetzung,
'camp_desc' - (TEXT) Beschreibung,
'camp_active' - (INT, 2) Aktiv,
'camp_color' - (TEXT, 31) Farbcode,
'camp_time_start' - (DATETIME) Startzeit,
'camp_time_end' - (DATETIME) Endzeit,
'camp_urlvarvalue' - (TEXT, 31) URL Variablenwert,
'camp_source' - (TEXT, 31) Quelle,
'camp_medium' - (TEXT, 31) Medium,
'camp_term' - (TEXT, 31) Begriff,
'camp_content' - (TEXT, 31) Inhalt,
'camp_campaign' - (TEXT, 31) Zusatz-Name,
'camp_track_interval' - (INT, 11) Erkennungszeitraum,
'camp_trackvars' - (TEXT) Tracking-Variablen,
'camp_tracing_javascript' - (TEXT) Verfolgungs-Javascript,
'camp_tracing_code' - (TEXT) Verfolgungs-Code,
'camp_external_id' - (TEXT, 63) Externer Kampagnen-Id,
'camp_external_src' - (TEXT, 127) Externer Kampagnen-Quelle,
'camp_person_grpid' - (INT, 11) Kundengruppe,
'camp_prc_col' - (TEXT, 63) Preisspalte,
'camp_prc_mode' - (TEXT, 7) Preismodus,
'camp_expected_order_revenue' - (FLOAT, 13,4) Erwarteter Umsatz (Order),
'camp_expected_order_cnt' - (INT, 11) Erwartete Anzahl (Order),
'camp_expected_lead_cnt' - (INT, 11) Erwartete Anzahl (Leads),
'camp_expected_impression_cnt' - (INT, 11) Erwartete Impressions,
'camp_expected_costs' - (FLOAT, 13,4) Erwartete Kosten,
'camp_costs_actual' - (FLOAT, 13,4) Kosten - aktuell,
'camp_costs_initial' - (FLOAT, 13,4) Kosten, einmalig,
'camp_costs_po_abs' - (FLOAT, 13,4) Kosten pro Order, absolut (CPO-a),
'camp_costs_po_perc' - (FLOAT, 8,4) Kosten pro Order, prozentual (CPO-p),
'camp_costs_pi_abs' - (FLOAT, 13,4) Kosten pro Impression, absolut (CPI),
'camp_commission_initial' - (FLOAT, 13,4) Provision, einmalig,
'camp_commission_po_abs' - (FLOAT, 13,4) Provision per Order, absolut,
'camp_commission_po_perc' - (FLOAT, 8,4) Provision per Order, prozentual,
'camp_commission_pi_abs' - (FLOAT, 13,4) Provision pro Impression,
'camp_progress_data' - (DATA) Verlaufsdaten,
'camp_insert_user' - (TEXT, 127) Ersteller,
'camp_update_user' - (TEXT, 127) Letzte Änderung durch,
'camp_time_insert' - (DATETIME) Angelegt am,
'camp_time_update' - (DATETIME) Geändert am,
'drvd_camp_difftime_end_day' - (INT, 11) Zeit bis Ende,
'drvd_inv_cy_name' - (TEXT) Rechnungsland,
'drvd_inv_cy_nameshort' - (TEXT) Rechnungsland Kurzname,
'drvd_del_cy_name' - (TEXT) Lieferland,
'drvd_del_cy_nameshort' - (TEXT) Lieferland Kurzname,
'drvd_invoice_state_name' - (TEXT) Bundesland (R),
'drvd_invoice_state_path' - (TEXT) Bundesland (Pfad) (R),
'drvd_deliver_state_name' - (TEXT) Bundesland (L),
'drvd_deliver_state_path' - (TEXT) Bundesland (Pfad) (L),
'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,
'p_login_pwd_plain' - (TEXT, 64) Neues Passwort,
'drvd_order_timelast' - (DATETIME) Letzte Bestellung,
'drvd_order_timefirst' - (DATETIME) Erste Bestellung,
'drvd_order_frequency' - (FLOAT, 9,2) Bestellfrequenz,
'drvd_order_count' - (INT, 11) # Aufträge,
'p_profile_photo' - (TEXT) Bild,
'node_id' - (INT, 11) ,
'drvd_dv_dvi_si_weight' - (FLOAT, 13,4) Gewicht (kg),
'drvd_dv_dvi_si_available_confirm_date' - (DATETIME) ,
'fk_dv_psid' - (INT, 11) Packstation,
'fk_dv_dgrp_id' - (INT, 11) Versandliste,
'dv_cost_total_ship' - (FLOAT, 13,2) Versandkosten,
'dv_cost_total_purchase' - (FLOAT, 13,2) Artikel-Einkaufskosten,
'dv_time_rsvd' - (DATETIME) Reserviert am,
'dv_time_transfer' - (DATETIME) Transferiert am,
'dv_time_planned_send' - (DATETIME) Geplante Sendezeit,
'drvd_dv_cnt_dvi_reserved' - (FLOAT, 13,4) Reserviert,
'drvd_dv_cnt_dvi_not_reserved' - (FLOAT, 13,4) Nicht reserviert,
'drvd_dv_cnt_dvi_reserved_confirmed' - (FLOAT, 13,4) Reserviert (bestätigt),
'drvd_dv_cnt_dvi_not_reserved_confirmed' - (FLOAT, 13,4) Nicht reserviert (bestätigt),
'drvd_dvi_items_info' - (TEXT) Lieferartikel,
'dgrp_id' - (INT, 11) ,
'dgrp_code' - (TEXT, 27) Versandliste,
'dgrp_time_sent' - (DATETIME) Lieferdatum,
'st_x_dv_reqtopick' - (INT, 4) ,
'st_x_dv_inpicking' - (INT, 4) ,
'st_x_dv_delivered' - (INT, 4) ,
'st_x_dv_unrsvd' - (INT, 4) ,
'st_x_dv_rsvd' - (INT, 4) ,
'st_x_dv_sendable' - (INT, 4) ,
'psid' - (INT, 11) ,
'ps_name' - (TEXT) Name der Packstation,
'ps_owner_name' - (TEXT) Ansprechpartner,
'ps_owner_address2' - (TEXT) Adressenzusatz,
'ps_owner_street' - (TEXT) Straße,
'ps_owner_housenr' - (TEXT) Hausnummer,
'ps_owner_zip' - (TEXT) PLZ,
'ps_owner_city' - (TEXT) Ort,
'ps_owner_country' - (TEXT, 2) Land,
'ps_owner_email' - (TEXT) E-Mail,
'ps_owner_phone' - (TEXT) Telefon,
'ps_owner_fax' - (TEXT) Fax,
'ps_svc_exectime_1' - (TEXT) Service Montag,
'ps_svc_exectime_2' - (TEXT) Service Dienstag,
'ps_svc_exectime_3' - (TEXT) Service Mittwoch,
'ps_svc_exectime_4' - (TEXT) Service Donnerstag,
'ps_svc_exectime_5' - (TEXT) Service Freitag,
'ps_svc_exectime_6' - (TEXT) Service Samstag,
'ps_svc_exectime_7' - (TEXT) Service Sonntag,
'ps_svc_exec_active' - (INT, 1) Service AutoExec,
'ps_desc' - (TEXT) Beschreibung,
'ps_svc_interface_class' - (TEXT, 31) Service Interface,
'ps_svc_interface_config' - (DATA) Interface Konfiguration,
'ps_config' - (DATA) Konfiguration,
'ps_insert_time' - (DATETIME) Angelegt am,
'ps_insert_user' - (TEXT, 127) Ersteller,
'ps_update_time' - (DATETIME) Geändert am,
'ps_update_user' - (TEXT, 127) Letzte Änderung durch,
'fk_dv_shp_c_id' - (INT, 11) Logistiker,
'dv_carrier_time_pickedup' - (DATETIME) Abgeholt am (laut Logistiker),
'dv_carrier_time_delivered' - (DATETIME) Geliefert am (laut Logistiker),
'dv_carrier_status' - (TEXT) Logistiker-Sendungsstatus,
'dv_carrier_id' - (TEXT, 63) Logistiker externe ID,
'dv_shipping_details' - (DATA) Detail-Daten,
'drvd_dv_trace_url' - (TEXT) Sendung verfolgen,
'drvd_shipping_label_url' - (TEXT) Versandlabel,
'drvd_customs_declaration_url' - (TEXT) Zollerklärung,
'shp_c_id' - (INT, 11) ID,
'shp_c_label' - (TEXT, 31) Logistiker-Label,
'shp_c_name' - (TEXT) Logistiker-Name,
'shp_c_desc' - (TEXT) Logistiker-Beschreibung,
'shp_c_active' - (INT, 1) Logistiker aktiviert,
'shp_c_track_url' - (TEXT) Sendungsverfolgungs-URL,
'shp_c_interface_class' - (TEXT, 31) Logistiker-Interface,
'shp_c_interface_config' - (DATA) Logistiker-Interface-Einstellungen,
'shp_c_config' - (DATA) Einstellungen,
'shp_c_insert_time' - (DATETIME) Angelegt am,
'shp_c_insert_user' - (TEXT, 127) Ersteller,
'shp_c_update_time' - (DATETIME) Geändert am,
'shp_c_update_user' - (TEXT, 127) Letzte Änderung durch,
'cy_name' - (TEXT, 63) Lieferland,
'cy_nameshort' - (TEXT, 15) Lieferland Kurzname,
'drvd_dv_state_name' - (TEXT) Bundesland (Name),
'drvd_dv_state_path' - (TEXT) Bundesland (Pfad),
'drvd_dv_seller_state_name' - (TEXT) Bundesland (Name) (Verkäufer),
'drvd_dv_seller_state_path' - (TEXT) Bundesland (Pfad) (Verkäufer),
'drvd_dv_dvi_weight' - (FLOAT) Gewicht (kg),
'drvd_dv_itemlist' - (TEXT) ,
'drvd_inv_info' - (DATA) Rechnungen zum Auftrag,
'drvd_inv_codes' - (TEXT) Rg.Nummern zum Auftrag,
'inv_code' - (TEXT) ,
'drvd_inv_amount_total' - (FLOAT) Gesamtrechnungsbetrag zum Auftrag,
'drvd_inv_amount_not_paid' - (FLOAT) Ausstehender Rechnungsbetrag für den Auftrag,
'drvd_dv_info_others' - (TEXT) Weitere Lieferungen zum Auftrag,
'drvd_dv_codes_others' - (TEXT) Weitere Lfg.Nummern zum Auftrag,
#}
{% set dataList = hublify.dataset('delivery')
.fields([
'did',
'dv_code',
])
.filter('did','<something>')
.one()
%}
api(). ... - create
For how-to insert a record...
api(). ... - update
For how-to update a record...
WHAT ELSE, you'd like ??
...