orderitem - "Auftragsposten" 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 "orderitem".
Other retrievable fields of orderitem are:
'oiid' - (INT, 11) Auftragitem-ID,
'fk_oi_oid' - (INT, 11) Auftrag,
'oi_position' - (INT, 5) Position,
'fk_oi_father_oiid' - (INT, 11) übergeordneter Posten,
'oi_type' - (TEXT, 15) Typ,
'oi_pcode' - (TEXT, 255) Produktcode,
'pcode' - () Produktcode,
'oi_name' - (TEXT) Name,
'oi_text' - (TEXT) Text,
'oi_code' - (TEXT, 63) Code,
'oi_quantity' - (FLOAT, 13,4) Bestellmenge,
'oi_vat_pct' - (FLOAT, 6,2) % MwSt.,
'oi_price_interval' - (TEXT, 1) ,
'oi_price_single_brutto' - (FLOAT, 13,4) Stückpreis Brutto,
'drvd_oi_total_brutto' - (FLOAT, 13,2) Gesamt Brutto,
'drvd_oi_price_single_brutto' - (FLOAT, 13,4) Einzelpreis Brutto,
'oi_price_single_netto' - (FLOAT, 13,4) Einzelpreis Netto,
'drvd_oi_price_single_netto' - (FLOAT, 13,4) Einzelpreis Netto,
'drvd_oi_total_netto' - (FLOAT, 13,2) Gesamt Netto,
'oi_price_single_brutto_standard' - (FLOAT, 13,4) Standard Einzelpreis Brutto (Data),
'oi_price_single_wholesale' - (FLOAT, 13,4) Einzel-EK Netto,
'oi_price_single_netto_standard' - (FLOAT, 13,4) ,
'drvd_oi_price_single_netto_standard' - (FLOAT, 13,4) Standard Einzelpreis Netto,
'drvd_oi_total_netto_not_discounted' - (FLOAT, 13,4) Gesamt Netto (regulär),
'drvd_oi_price_single_brutto_standard' - (FLOAT, 13,4) Standard Einzelpreis Brutto,
'drvd_oi_total_brutto_not_discounted' - (FLOAT, 13,4) Gesamt Brutto (regulär),
'drvd_oi_discount_diff_netto' - (FLOAT, 13,4) Einzelrabatt Netto,
'drvd_oi_total_netto_discounted' - (FLOAT, 13,2) Gesamt Netto (discounted),
'drvd_oi_discount_diff_brutto' - (FLOAT, 13,4) Einzelrabatt Brutto,
'drvd_oi_total_brutto_discounted' - (FLOAT, 13,2) Gesamt Brutto (discounted),
'drvd_oi_is_discounted' - (INT, 1) Flag Discounted,
'drvd_oi_discounted_perc' - (FLOAT, 6,2) Discount (prozentual),
'drvd_oi_margin_gross' - (FLOAT, 11,2) Handelsspanne,
'drvd_oi_profit_perc' - (FLOAT, 11,2) Gewinn Marge,
'drvd_oi_profit_single' - (FLOAT, 13,4) Einzel Gewinn,
'drvd_oi_profit_total' - (FLOAT, 13,4) Gesamt Gewinn,
'oi_qty_invoiced' - (FLOAT, 13,4) In Rechnung gestellt,
'oi_qty_refunded' - (FLOAT, 13,4) Erstattet,
'oi_qty_shipped' - (FLOAT, 13,4) Versendet,
'oi_qty_returned' - (FLOAT, 13,4) Zurückgeschickt,
'drvd_oi_qty_not_invoiced' - (FLOAT, 13,4) ,
'drvd_oi_qty_not_shipped' - (FLOAT, 13,4) ,
'oi_block' - (INT, 3) Block,
'oi_xdata' - (DATA) Weitere Daten,
'oi_price_single_brutto_xcurrency' - (FLOAT, 13,4) Stückpreis Brutto (X-Währung),
'oi_price_single_netto_xcurrency' - (FLOAT, 13,4) Stückpreis Netto (X-Währung),
'oi_xcurrency' - (TEXT, 3) X-Währung,
'drvd_oi_total_brutto_xcurrency' - (FLOAT, 13,2) Gesamt Brutto (X-Währung),
'drvd_oi_total_netto_xcurrency' - (FLOAT, 13,2) Gesamt Netto (X-Währung),
'drvd_oi_price_single_brutto_xcurrency' - (FLOAT, 13,4) Einzelpreis Brutto (X-Währung),
'drvd_oi_price_single_netto_xcurrency' - (FLOAT, 13,4) Einzelpreis Netto (X-Währung),
'oi_time_insert' - (DATETIME) Angelegt am,
'oi_time_update' - (DATETIME) Geändert am,
'oi_user_insert' - (TEXT, 127) Ersteller,
'oi_user_update' - (TEXT, 127) Letzte Änderung durch,
'oi_omsg_status' - (, 31) Status aus Kundendialog,
'drvd_oi_omsg_cnt' - (INT, 11) # Nachrichten,
'drvd_oi_omsg_time_last' - (DATETIME, 11) Letzte Nachricht vom,
'fk_oi_mrch_id' - (INT, 11) Anbieter,
'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,
'order_state_transtime' - (DATETIME) Transaktionszeit,
'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_anonymize_time' - (DATETIME) ,
'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_mode' - (TEXT, 7) Abo-Modus,
'o_periodic_exec_inprogress' - (INT, 1) Wird gerade ausgeführt,
'o_periodic_xdata' - (DATA) ,
'o_release_user' - (TEXT) Freigabe - Hublify User,
'o_release_time' - (DATETIME) Freigabe - Zeitpunkt,
'o_finalinspection_user' - (TEXT) Endkontrolle - Hublify User,
'o_finalinspection_time' - (DATETIME) Endkontrolle - Zeitpunkt,
'fk_o_crm_opp_id' - (INT, 11) CRM Opportunity,
'drvd_days_since_ordered' - (INT) ,
'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,
'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),
#}
{% set dataList = hublify.dataset('orderitem')
.fields([
'oiid',
'oi_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 "orderitem".
Other retrievable fields of orderitem are:
'oiid' - (INT, 11) Auftragitem-ID,
'fk_oi_oid' - (INT, 11) Auftrag,
'oi_position' - (INT, 5) Position,
'fk_oi_father_oiid' - (INT, 11) übergeordneter Posten,
'oi_type' - (TEXT, 15) Typ,
'oi_pcode' - (TEXT, 255) Produktcode,
'pcode' - () Produktcode,
'oi_name' - (TEXT) Name,
'oi_text' - (TEXT) Text,
'oi_code' - (TEXT, 63) Code,
'oi_quantity' - (FLOAT, 13,4) Bestellmenge,
'oi_vat_pct' - (FLOAT, 6,2) % MwSt.,
'oi_price_interval' - (TEXT, 1) ,
'oi_price_single_brutto' - (FLOAT, 13,4) Stückpreis Brutto,
'drvd_oi_total_brutto' - (FLOAT, 13,2) Gesamt Brutto,
'drvd_oi_price_single_brutto' - (FLOAT, 13,4) Einzelpreis Brutto,
'oi_price_single_netto' - (FLOAT, 13,4) Einzelpreis Netto,
'drvd_oi_price_single_netto' - (FLOAT, 13,4) Einzelpreis Netto,
'drvd_oi_total_netto' - (FLOAT, 13,2) Gesamt Netto,
'oi_price_single_brutto_standard' - (FLOAT, 13,4) Standard Einzelpreis Brutto (Data),
'oi_price_single_wholesale' - (FLOAT, 13,4) Einzel-EK Netto,
'oi_price_single_netto_standard' - (FLOAT, 13,4) ,
'drvd_oi_price_single_netto_standard' - (FLOAT, 13,4) Standard Einzelpreis Netto,
'drvd_oi_total_netto_not_discounted' - (FLOAT, 13,4) Gesamt Netto (regulär),
'drvd_oi_price_single_brutto_standard' - (FLOAT, 13,4) Standard Einzelpreis Brutto,
'drvd_oi_total_brutto_not_discounted' - (FLOAT, 13,4) Gesamt Brutto (regulär),
'drvd_oi_discount_diff_netto' - (FLOAT, 13,4) Einzelrabatt Netto,
'drvd_oi_total_netto_discounted' - (FLOAT, 13,2) Gesamt Netto (discounted),
'drvd_oi_discount_diff_brutto' - (FLOAT, 13,4) Einzelrabatt Brutto,
'drvd_oi_total_brutto_discounted' - (FLOAT, 13,2) Gesamt Brutto (discounted),
'drvd_oi_is_discounted' - (INT, 1) Flag Discounted,
'drvd_oi_discounted_perc' - (FLOAT, 6,2) Discount (prozentual),
'drvd_oi_margin_gross' - (FLOAT, 11,2) Handelsspanne,
'drvd_oi_profit_perc' - (FLOAT, 11,2) Gewinn Marge,
'drvd_oi_profit_single' - (FLOAT, 13,4) Einzel Gewinn,
'drvd_oi_profit_total' - (FLOAT, 13,4) Gesamt Gewinn,
'oi_qty_invoiced' - (FLOAT, 13,4) In Rechnung gestellt,
'oi_qty_refunded' - (FLOAT, 13,4) Erstattet,
'oi_qty_shipped' - (FLOAT, 13,4) Versendet,
'oi_qty_returned' - (FLOAT, 13,4) Zurückgeschickt,
'drvd_oi_qty_not_invoiced' - (FLOAT, 13,4) ,
'drvd_oi_qty_not_shipped' - (FLOAT, 13,4) ,
'oi_block' - (INT, 3) Block,
'oi_xdata' - (DATA) Weitere Daten,
'oi_price_single_brutto_xcurrency' - (FLOAT, 13,4) Stückpreis Brutto (X-Währung),
'oi_price_single_netto_xcurrency' - (FLOAT, 13,4) Stückpreis Netto (X-Währung),
'oi_xcurrency' - (TEXT, 3) X-Währung,
'drvd_oi_total_brutto_xcurrency' - (FLOAT, 13,2) Gesamt Brutto (X-Währung),
'drvd_oi_total_netto_xcurrency' - (FLOAT, 13,2) Gesamt Netto (X-Währung),
'drvd_oi_price_single_brutto_xcurrency' - (FLOAT, 13,4) Einzelpreis Brutto (X-Währung),
'drvd_oi_price_single_netto_xcurrency' - (FLOAT, 13,4) Einzelpreis Netto (X-Währung),
'oi_time_insert' - (DATETIME) Angelegt am,
'oi_time_update' - (DATETIME) Geändert am,
'oi_user_insert' - (TEXT, 127) Ersteller,
'oi_user_update' - (TEXT, 127) Letzte Änderung durch,
'oi_omsg_status' - (, 31) Status aus Kundendialog,
'drvd_oi_omsg_cnt' - (INT, 11) # Nachrichten,
'drvd_oi_omsg_time_last' - (DATETIME, 11) Letzte Nachricht vom,
'fk_oi_mrch_id' - (INT, 11) Anbieter,
'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,
'order_state_transtime' - (DATETIME) Transaktionszeit,
'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_anonymize_time' - (DATETIME) ,
'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_mode' - (TEXT, 7) Abo-Modus,
'o_periodic_exec_inprogress' - (INT, 1) Wird gerade ausgeführt,
'o_periodic_xdata' - (DATA) ,
'o_release_user' - (TEXT) Freigabe - Hublify User,
'o_release_time' - (DATETIME) Freigabe - Zeitpunkt,
'o_finalinspection_user' - (TEXT) Endkontrolle - Hublify User,
'o_finalinspection_time' - (DATETIME) Endkontrolle - Zeitpunkt,
'fk_o_crm_opp_id' - (INT, 11) CRM Opportunity,
'drvd_days_since_ordered' - (INT) ,
'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,
'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),
#}
{% set dataList = hublify.dataset('orderitem')
.fields([
'oiid',
'oi_pcode',
])
.filter('oiid','<something>')
.one()
%}
api(). ... - create
For how-to insert a record...
api(). ... - update
For how-to update a record...
WHAT ELSE, you'd like ??
...