Model fields

The model consists of the following fields.

Field Name
Display Name
Type
Permissions
Nullable

order

oid primary auto increment
OID
INT (11)
R+W
no
fieldset
"base_record"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "type": "hidden"
}
fk_o_shopid → shopconfig.eshopid
Shop
INT (11)
R+W
yes
fieldset
"marketing"
listCfg
{
    "viewMode": 0
}
orderid primaryDisplay
Auftrags-Nr.
TEXT (63)
R+W
no
fieldset
"base_record"
listCfg
{
    "full_search": true,
    "formatter": {
        "type": "model-primary",
        "params": {
            "model": "order",
            "primaryKey": "oid",
            "statusColorField": "order_state_color",
            "subTitleTemplate": "{%invoice_firstname%} {%invoice_lastname%}"
        }
    }
}
formCfg
{
    "cssLayout": "col-12 col-md-6 col-xl-3"
}
fk_o_persid → person.persid
Kunde
INT (11)
R+W
yes
fieldset
"base_record"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "cssLayout": "col-12 col-md-6 col-xl-3",
    "mandatory": true
}
o_time_ordered
Bestell­datum
DATETIME
R+W
yes
fieldset
"base_record"
listCfg
{
    "formatter": {
        "type": "date"
    }
}
formCfg
{
    "cssLayout": "col-12 col-md-6 col-xl-3"
}
total_netto [EUR]
∑ Gesamt, Netto
FLOAT (13,2)
R+W
no
listCfg
{
    "formatter": {
        "type": "currency"
    },
    "viewMode": 0,
    "sumType": "SV"
}
total_brutto [EUR]
∑ Gesamt, Brutto
FLOAT (13,2)
R+W
no
listCfg
{
    "formatter": {
        "type": "currency"
    },
    "sumType": "SV"
}
o_orderid_external
Externe Auftrags-Nr.
TEXT (255)
R+W
yes
fieldset
"base"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "cssLayout": "col-12 col-md-6 col-xl-3"
}
fk_o_posid → orderpos.posid
POS Channel (ID)
INT (11)
R+W
yes
fieldset
"base"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "cssLayout": "col-12 col-md-6 col-xl-3"
}
fk_o_stid → orderstate.stid
Status
INT (11)
R+W
no
fieldset
"base"
listCfg
{
    "viewMode": 3
}
formCfg
{
    "cssLayout": "col-12 col-md-6 col-xl-3"
}
fk_o_st_id → shippingtype.st_id
Versandart
INT (11)
R+W
no
fieldset
"base"
listCfg
{
    "viewMode": 3
}
formCfg
{
    "cssLayout": "col-12 col-md-6 col-xl-3"
}
o_pers_reftext
Kunden-Referenztext
TEXT
R+W
yes
listCfg
{
    "viewMode": 0
}
o_pers_seq_nr
Auftrags-Sequenz-Nr.
INT (11)
R+W
no
listCfg
{
    "viewMode": 0
}
quantity
Bestellmenge
FLOAT (13,1)
R+W
no
listCfg
{
    "viewMode": 0,
    "sumType": "SV"
}
drvd_total_vat [EUR]
MwSt. (Gesamt)
FLOAT (13,2)
R
no
drvd_select
ROUND(eos_order.total_brutto - eos_order.total_netto, 2)
listCfg
{
    "formatter": {
        "type": "currency"
    },
    "viewMode": 0,
    "sumType": "SV"
}
currency
Währung
TEXT (3)
R+W
no
listCfg
{
    "viewMode": 0
}
otitle
Auftragstitel
TEXT
R+W
yes
fieldset
"doc_header"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "cssLayout": "col-12"
}
otext
Auftragsbeschreibung
TEXT
R+W
yes
fieldset
"extra"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "type": "textarea"
}
o_type
Auftragstyp
TEXT (15)
R+W
yes
fieldset
"base_record"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "cssLayout": "col-12 col-md-6 col-xl-3",
    "type": "eosdropdown",
    "value": "order",
    "options": {
        "optI18nValuePrefix": "ecs.o_type",
        "optI18nName": true,
        "data": {
            "options": [
                {
                    "value": "order"
                },
                {
                    "value": "offer"
                },
                {
                    "value": "tpl"
                }
            ]
        }
    }
}
o_valid_until
Gültig bis
DATETIME
R+W
yes
listCfg
{
    "viewMode": 0,
    "formatter": {
        "type": "date"
    }
}
o_txt_header
Kopf-Text
TEXT
R+W
yes
input_translated
Kopf-Text für die Verwendung in PDFs
fieldset
"doc_header"
listCfg
{
    "viewMode": 0,
    "fullSearch": true
}
formCfg
{
    "fieldSetCol": "12",
    "type": "eoseditor"
}
o_txt_footer
Fuß-Text
TEXT
R+W
yes
invoice_gender
Anrede (R)
TEXT
R+W
yes
fieldset
"inv_addr"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "cssLayout": "col-6 col-xl-2",
    "type": "eosdropdown",
    "options": {
        "optI18nValuePrefix": "ecs.gender",
        "optI18nName": true,
        "data": {
            "options": [
                {
                    "value": null
                },
                {
                    "value": "female"
                },
                {
                    "value": "male"
                },
                {
                    "value": "company"
                },
                {
                    "value": "divers"
                }
            ]
        }
    }
}
invoice_title
Titel (R)
TEXT
R+W
no
fieldset
"inv_addr"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "cssLayout": "col-6 col-xl-2"
}
invoice_firstname
Vorname (R)
TEXT
R+W
no
fieldset
"inv_addr"
listCfg
{
    "viewMode": 0,
    "fullSearch": true
}
formCfg
{
    "cssLayout": "col-6 col-xl-4"
}
invoice_lastname
Nachname (R)
TEXT
R+W
no
fieldset
"inv_addr"
listCfg
{
    "fullSearch": true,
    "viewMode": 0
}
formCfg
{
    "cssLayout": "col-6 col-xl-4"
}
invoice_company
Firma (R)
TEXT
R+W
no
fieldset
"inv_addr"
listCfg
{
    "fullSearch": true,
    "viewMode": 0
}
formCfg
{
    "cssLayout": "col-6"
}
invoice_addrextra
Adressenzusatz
TEXT
R+W
no
fieldset
"inv_addr"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "cssLayout": "col-6"
}
invoice_street
Straße (R)
TEXT
R+W
no
fieldset
"inv_addr"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "cssLayout": "col-9"
}
invoice_housenr
Hausnummer (R)
TEXT
R+W
no
fieldset
"inv_addr"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "cssLayout": "col-3"
}
invoice_zip
PLZ (R)
TEXT
R+W
no
fieldset
"inv_addr"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "cssLayout": "col-3"
}
invoice_town
Ort (R)
TEXT
R+W
no
fieldset
"inv_addr"
listCfg
{
    "fullSearch": true,
    "viewMode": 0
}
formCfg
{
    "cssLayout": "col-6"
}
invoice_country → country.cy_iso
Land (R)
TEXT (2)
R+W
no
fieldset
"inv_addr"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "cssLayout": "col-3"
}
invoice_type
Rechnungsart
TEXT
R+W
yes
fieldset
"inv_extra"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "cssLayout": "col-4",
    "type": "eosdropdown",
    "options": {
        "optI18nValuePrefix": "ecs.invoice_type",
        "optI18nName": true,
        "data": {
            "options": [
                {
                    "value": "noncommercial"
                },
                {
                    "value": "commercial"
                }
            ]
        }
    }
}
invoice_email
E-Mail (R)
TEXT
R+W
no
fieldset
"inv_extra"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "cssLayout": "col-4"
}
invoice_taxidentnumber
USt.ID-Nr.
TEXT
R+W
no
fieldset
"inv_extra"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "cssLayout": "col-4"
}
invoice_taxident_status
USt.ID-Nr. Status
TEXT
R+W
yes
fieldset
"inv_extra"
listCfg
{
    "viewMode": 0,
    "formatter": {
        "type": "status"
    }
}
formCfg
{
    "type": "eosdropdown",
    "options": {
        "optI18nValuePrefix": "ecs.taxident_status",
        "optI18nName": true,
        "data": {
            "options": [
                {
                    "value": null
                },
                {
                    "value": "invalid"
                },
                {
                    "value": "valid_conditional"
                },
                {
                    "value": "valid_confirmed"
                }
            ]
        }
    }
}
invoice_third_country_export
Ausfuhrbescheinigung
TEXT
R+W
yes
fieldset
"inv_extra"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "type": "eosdropdown",
    "options": {
        "optI18nValuePrefix": "ecs.invoice_third_country_export",
        "optI18nName": true,
        "data": {
            "options": [
                {
                    "value": "none"
                },
                {
                    "value": "certificate_promised"
                },
                {
                    "value": "certificate_received"
                }
            ]
        }
    }
}
invoice_lang_iso
Rechnungssprache
TEXT (2)
R+W
no
fieldset
"inv_extra"
listCfg
{
    "viewMode": 0
}
drvd_invoice_street_housenr
Straße+Nr (R)
TEXT
R
no
drvd_select
CONCAT_WS("",eos_order.invoice_street," ",eos_order.invoice_housenr)
listCfg
{
    "viewMode": 0
}
deliver_gender
Anrede (L)
TEXT
R+W
yes
fieldset
"dlv_addr"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "cssLayout": "col-6 col-xl-2",
    "type": "eosdropdown",
    "options": {
        "optI18nValuePrefix": "ecs.gender",
        "optI18nName": true,
        "data": {
            "options": [
                {
                    "value": null
                },
                {
                    "value": "female"
                },
                {
                    "value": "male"
                },
                {
                    "value": "company"
                },
                {
                    "value": "divers"
                }
            ]
        }
    }
}
deliver_title
Titel (L)
TEXT
R+W
no
fieldset
"dlv_addr"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "cssLayout": "col-6 col-xl-2"
}
deliver_firstname
Vorname (L)
TEXT
R+W
no
fieldset
"dlv_addr"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "cssLayout": "col-6 col-xl-4"
}
deliver_lastname
Nachname (L)
TEXT
R+W
no
fieldset
"dlv_addr"
listCfg
{
    "viewMode": 0,
    "fullSearch": true
}
formCfg
{
    "cssLayout": "col-6 col-xl-4"
}
deliver_company
Firma (L)
TEXT
R+W
no
fieldset
"dlv_addr"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "cssLayout": "col-6"
}
deliver_addrextra
Adressenzusatz
TEXT
R+W
no
fieldset
"dlv_addr"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "cssLayout": "col-6"
}
deliver_street
Straße (L)
TEXT
R+W
no
fieldset
"dlv_addr"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "cssLayout": "col-9"
}
deliver_housenr
Hausnummer (L)
TEXT
R+W
no
fieldset
"dlv_addr"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "cssLayout": "col-3"
}
deliver_zip
PLZ (L)
TEXT
R+W
no
fieldset
"dlv_addr"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "cssLayout": "col-3"
}
deliver_town
Ort (L)
TEXT
R+W
no
fieldset
"dlv_addr"
listCfg
{
    "full_search": true,
    "viewMode": 0
}
formCfg
{
    "cssLayout": "col-6"
}
deliver_country → country.cy_iso
Land (L)
TEXT (2)
R+W
no
fieldset
"dlv_addr"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "cssLayout": "col-3"
}
deliver_date_req
Kunden-Wunschtermin
TEXT
R+W
no
fieldset
"dlv_extra"
listCfg
{
    "viewMode": 0
}
deliver_phone
Telefon
TEXT
R+W
no
fieldset
"dlv_extra"
listCfg
{
    "viewMode": 0
}
deliver_email
E-Mail (L)
TEXT
R+W
no
fieldset
"dlv_extra"
listCfg
{
    "viewMode": 0
}
deliver_comment
Liefer-Hinweise
TEXT
R+W
no
fieldset
"dlv_extra"
listCfg
{
    "viewMode": 0
}
drvd_deliver_street_housenr
Straße+Nr (L)
TEXT
R
no
drvd_select
CONCAT_WS("",eos_order.deliver_street," ",eos_order.deliver_housenr)
listCfg
{
    "viewMode": 0
}
deliver_notes_xdata
Lieferhinweise
DATA
R+W
yes
fieldset
"dlv_extra"
listCfg
{
    "viewMode": 0
}
ip_address
IP-Adresse
TEXT
R+W
yes
fieldset
"sys_record"
listCfg
{
    "viewMode": 0
}
o_referrer
Referrer
TEXT
R+W
yes
fieldset
"sys_record"
listCfg
{
    "viewMode": 0
}
o_useragent
User-Agent
TEXT
R+W
yes
fieldset
"sys_record"
listCfg
{
    "viewMode": 0
}
o_comment
Kundenkommentar
TEXT
R+W
yes
fieldset
"extra"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "type": "textarea"
}
o_comment_internal
Interner Bestellhinweis
TEXT
R+W
yes
fieldset
"extra"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "type": "textarea"
}
o_lock_time
Bearbeitungs-Sperre (Zeitpunkt)
DATETIME
R+W
yes
listCfg
{
    "viewMode": 0
}
o_lock_user
Bearbeitungs-Sperre (Benutzer)
TEXT (31)
R+W
yes
listCfg
{
    "viewMode": 0
}
o_insert_time
Angelegt am
DATETIME
R+W
no
i18n_string
"insert_time"
fieldset
"sys_record"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "editMode": 2
}
o_update_time
Geändert am
DATETIME
R+W
yes
i18n_string
"update_time"
fieldset
"sys_record"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "editMode": 2
}
o_insert_user
Ersteller
TEXT (127)
R+W
yes
i18n_string
"insert_user"
fieldset
"sys_record"
listCfg
{
    "formatter": {
        "type": "user"
    },
    "viewMode": 0
}
formCfg
{
    "editMode": 2
}
o_update_user
Letzte Änderung durch
TEXT (127)
R+W
yes
i18n_string
"update_user"
fieldset
"sys_record"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "editMode": 2
}
fk_o_campid → campaign.campid
Kampagne
INT (11)
R+W
no
fieldset
"marketing"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "cssLayout": "col-6"
}
drvd_o_shoplabel
Shop
TEXT
R
no
drvd_select
eos_order.fk_o_shopid
listCfg
{
    "viewMode": 0
}
drvd_invoice_address
Auftrag-Rg.Adresse
TEXT
R
no
drvd_select
CONCAT(
					IF(CHAR_LENGTH(eos_order.invoice_company)>0,CONCAT(eos_order.invoice_company,CHAR(13)),""),
					TRIM(CONCAT(eos_order.invoice_title," ",eos_order.invoice_firstname," ",eos_order.invoice_lastname)),CHAR(13),
					IF(CHAR_LENGTH(eos_order.invoice_addrextra)>0,CONCAT(eos_order.invoice_addrextra,CHAR(13)),""),
					eos_order.invoice_street," ",eos_order.invoice_housenr,CHAR(13),
					eos_order.invoice_country," - ",eos_order.invoice_zip," ",eos_order.invoice_town)
listCfg
{
    "viewMode": 0
}
drvd_deliver_address
Auftrag-Lfg.Adresse
TEXT
R
no
drvd_select
CONCAT(
					IF(CHAR_LENGTH(eos_order.deliver_company)>0,CONCAT(eos_order.deliver_company,CHAR(13)),""),
					TRIM(CONCAT(eos_order.deliver_title," ",eos_order.deliver_firstname," ",eos_order.deliver_lastname)),CHAR(13),
					IF(CHAR_LENGTH(eos_order.deliver_addrextra)>0,CONCAT(eos_order.deliver_addrextra,CHAR(13)),""),
					eos_order.deliver_street," ",eos_order.deliver_housenr,CHAR(13),
					eos_order.deliver_country," - ",eos_order.deliver_zip," ",eos_order.deliver_town)
listCfg
{
    "viewMode": 0
}
o_pay_profile_xdata
Zahlungsziel-Daten
DATA
R+W
yes
listCfg
{
    "viewMode": 0
}
fk_o_companyaccount_subaccount_persid → companysubaccount.persid
Unteraccount
INT (11)
R+W
yes
i18n_string
"ecs.plugin_companyaccount.fk_o_companyaccount_subaccount_persid"
fieldset
"extra"
listCfg
{
    "viewMode": 3
}
fk_o_mrch_id → merchant.mrch_id
Verkaufender Anbieter
INT (11)
R+W
yes
fieldset
"extra"
listCfg
{
    "viewMode": 3
}
fk_o_parent_oid → order.oid
Hauptauftrag
INT (11)
R+W
yes
fieldset
"extra"
listCfg
{
    "viewMode": 3
}
drvd_parent_orderid
Haupt­auftrag
TEXT
R
yes
table
[ "parent_order" ]
drvd_select
parent_order.orderid
listCfg
{
    "viewMode": 0,
    "fullSearch": true,
    "formatter": {
        "type": "model-primary",
        "params": {
            "model": "order",
            "primaryKey": "fk_o_parent_oid"
        }
    }
}
formCfg
{
    "editMode": 0
}
o_merchant_xdata
Anbieter (Zusatzdaten)
DATA
R+W
yes
fieldset
"extra"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "cssLayout": "col-12",
    "type": "aceeditor",
    "options": {
        "mode": "json"
    }
}
o_periodic_time_first
Abo-Startdatum
DATETIME
R+W
yes
fieldset
"time_settings"
listCfg
{
    "viewMode": 3
}
formCfg
{
    "type": "datetimepicker",
    "cssLayout": "col-12 col-md-6 col-xl-6"
}
o_periodic_time_last
Abo-Enddatum
DATETIME
R+W
yes
fieldset
"time_settings"
listCfg
{
    "viewMode": 3
}
formCfg
{
    "type": "datetimepicker",
    "cssLayout": "col-12 col-md-6 col-xl-6"
}
o_periodic_time_next
Nächste Abo-Ausführung
DATETIME
R+W
yes
fieldset
"time_settings"
listCfg
{
    "viewMode": 3
}
formCfg
{
    "editMode": 2,
    "cssLayout": "col-12 col-md-6 col-xl-6"
}
o_periodic_timeorder_offset
Abweichendes Auftragsdatum
TEXT (31)
R+W
no
fieldset
"time_settings"
listCfg
{
    "viewMode": 3,
    "formatter": {
        "type": "cron"
    }
}
formCfg
{
    "cssLayout": "col-12 col-md-6 col-xl-6"
}
o_periodic_time_strict
Strikt
INT (1)
R+W
no
fieldset
"time_settings"
listCfg
{
    "viewMode": 3,
    "formatter": {
        "type": "active-flag"
    }
}
formCfg
{
    "type": "checkbox",
    "value": 1
}
o_periodic_exec_period
Abo-Intervall
TEXT (31)
R+W
no
fieldset
"time_settings"
listCfg
{
    "viewMode": 3,
    "formatter": {
        "type": "cron"
    }
}
formCfg
{
    "type": "hfycron"
}
o_periodic_exec_inprogress
Wird gerade ausgeführt
INT (1)
R+W
no
listCfg
{
    "viewMode": 3
}
formCfg
{
    "editMode": 0
}
o_periodic_xdata
DATA
R+W
yes
fieldset
"time_settings_xdata"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "type": "eossubform",
    "hideLabel": true,
    "options": {
        "fieldDefinition": {
            "time_paused": {
                "type": "eossubformarray",
                "options": {
                    "model": "time_paused",
                    "sortable": true,
                    "enableAdd": true,
                    "enableRemove": true,
                    "itemsMinCount": 0,
                    "itemsMaxCount": -1,
                    "fieldDefinition": {
                        "pause_start": {
                            "type": "datetimepicker",
                            "hideLabel": true
                        },
                        "pause_end": {
                            "type": "datetimepicker",
                            "hideLabel": true
                        }
                    },
                    "layoutSettings": {
                        "hideTabs": true,
                        "tabs": [
                            {
                                "label": "base",
                                "cssLayoutGroupDefault": "col-12",
                                "groups": [
                                    {
                                        "label": "time_paused",
                                        "hideHeader": true,
                                        "fdLabelLayoutDefault": "vt",
                                        "fields": [
                                            {
                                                "field": "pause_start",
                                                "cssLayout": "col-6"
                                            },
                                            {
                                                "field": "pause_end",
                                                "cssLayout": "col-6"
                                            }
                                        ]
                                    }
                                ]
                            }
                        ]
                    }
                }
            }
        }
    }
}
drvd_weekday_timeordered
Wochen­tag
TEXT
R
no
drvd_select
DATE_FORMAT(eos_order.o_time_ordered, '%a')
drvd_hour_timeordered
Stunde
TEXT
R
no
drvd_select
DATE_FORMAT(eos_order.o_time_ordered, '%H')
drvd_month_timeordered
Bestell­monat
TEXT
R
no
drvd_select
DATE_FORMAT(eos_order.o_time_ordered, '%m')
drvd_dayofmonth_timeordered
Bestelltag im Monat
TEXT
R
no
drvd_select
DATE_FORMAT(eos_order.o_time_ordered, '%d')
drvd_timeonly_timeordered
Bestellzeit
TEXT
R
no
drvd_select
DATE_FORMAT(eos_order.o_time_ordered, '%H:%i')
drvd_cluster_seq
Erst-/Wiederkauf
TEXT
R
no
drvd_select
IF(eos_order.o_pers_seq_nr > 1,"Wiederkauf","Erstkauf")
shipping_type_label
Versandart
TEXT (63)
R
no
table
[ "eos_shipping_types" ]
drvd_select
eos_shipping_types.st_label
shipping_type_grp_name
Versandart-Gruppe
TEXT (63)
R
no
table
[ "eos_shipping_types" ]
drvd_select
eos_shipping_types.st_grp_name
shipping_type_deliver_category
Lieferkategorie
TEXT (31)
R
no
table
[ "eos_shipping_types" ]
drvd_select
eos_shipping_types.st_deliver_category
order_state_transtime
Transaktionszeit
DATETIME
R
no
table
[ "eos_statelog" ]
drvd_select
eos_statelog.transtime
order_state_code
Auftragsstatus (Code)
TEXT (63)
R
no
table
[ "eos_states" ]
drvd_select
eos_states.st_code
order_state_color
Status-Farbe
TEXT (15)
R
no
table
[ "eos_states" ]
drvd_select
eos_states.st_color
order_state_name
Auftragsstatus (Name)
TEXT
R
no
valueColorField
"order_state_color"
table
[ "eos_states" ]
drvd_select
eos_states.i18n_st_name_DE
listCfg
{
    "formatter": {
        "type": "status",
        "params": {
            "statusColorField": "order_state_color"
        }
    },
    "width": 192
}
order_state_name_public
Auftragsstatus (öffentlicher Name)
TEXT
R
no
valueColorField
"order_state_color"
table
[ "eos_states" ]
drvd_select
eos_states.i18n_st_name_public_DE
listCfg
{
    "formatter": {
        "type": "status",
        "params": {
            "statusColorField": "order_state_color"
        }
    }
}

person

Following fields can also be selected for reading (JOIN)

personid
Kunden-Nr.
TEXT (32)
R
no
table
[ "eos_person" ]
listCfg
{
    "full_search": true,
    "formatter": {
        "type": "model-primary",
        "params": {
            "model": "person",
            "primaryKey": "fk_o_persid",
            "iconLabel": "hublify\/sign-questionmark",
            "iconMapField": "gender",
            "iconMap": [
                {
                    "value": "female",
                    "iconLabel": "ecs\/gender_female"
                },
                {
                    "value": "male",
                    "iconLabel": "ecs\/gender_male"
                },
                {
                    "value": "company",
                    "iconLabel": "ecs\/gender_company"
                },
                {
                    "value": "divers",
                    "iconLabel": "ecs\/gender_divers"
                }
            ],
            "iconColorField": "gender_color",
            "subTitleTemplate": "{%firstname%} {%lastname%}"
        }
    }
}
formCfg
{
    "editMode": 0
}
persid
INT (11)
R
no
table
[ "eos_person" ]
drvd_select
eos_person.persid
listCfg
{
    "viewMode": 3
}

campaign

Following fields can also be selected for reading (JOIN)

campaign_name
Kampagne
TEXT (127)
R
no
table
[ "eos_campaign" ]
drvd_select
eos_campaign.camp_name
listCfg
{
    "full_search": true,
    "viewMode": 3
}
campid auto increment
INT (11)
R
no
i18n_string
"ecs.CAMPAIGN.campid"
table
[ "eos_campaign" ]
fieldset
"base"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "type": "hidden",
    "editMode": 0
}
fk_camp_shopid → shopconfig.eshopid
Shop
INT (11)
R
yes
i18n_string
"ecs.CAMPAIGN.fk_camp_shopid"
table
[ "eos_campaign" ]
fieldset
"base"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "editMode": 0
}
camp_name
Kampagnen-Name
TEXT (127)
R
no
input_translated
Interner Name dieser Kampagne.
i18n_string
"ecs.CAMPAIGN.camp_name"
table
[ "eos_campaign" ]
fieldset
"base"
listCfg
{
    "formatter": {
        "type": "model-primary",
        "params": {
            "model": "campaign",
            "primaryKey": "campid",
            "iconLabel": "ecs\/campaign.model",
            "iconColorField": "camp_color"
        }
    },
    "viewMode": 1,
    "depends_on": "fk_o_campid"
}
formCfg
{
    "mandatory": true,
    "editMode": 0
}
camp_short_desc
Kurzbeschreibung
TEXT (127)
R
yes
i18n_string
"ecs.CAMPAIGN.camp_short_desc"
table
[ "eos_campaign" ]
fieldset
"base"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "editMode": 0
}
camp_objective
Zielsetzung
TEXT (65536)
R
yes
i18n_string
"ecs.CAMPAIGN.camp_objective"
table
[ "eos_campaign" ]
fieldset
"goals"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "editMode": 0
}
camp_desc
Beschreibung
TEXT
R
yes
i18n_string
"ecs.CAMPAIGN.camp_desc"
table
[ "eos_campaign" ]
fieldset
"extra"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "editMode": 0
}
camp_active
Aktiv
INT (2)
R
no
input_translated
Nur hierüber aktivierte Kampagnen werden getrackt.
i18n_string
"ecs.CAMPAIGN.camp_active"
table
[ "eos_campaign" ]
fieldset
"base"
listCfg
{
    "formatter": {
        "type": "active-flag"
    },
    "viewMode": 0
}
formCfg
{
    "type": "checkbox",
    "editMode": 0
}
camp_color
Farbcode
TEXT (31)
R
yes
i18n_string
"ecs.CAMPAIGN.camp_color"
table
[ "eos_campaign" ]
fieldset
"analytics"
listCfg
{
    "viewMode": 3,
    "formatter": {
        "type": "color-code"
    }
}
formCfg
{
    "editMode": 0
}
camp_time_start
Startzeit
DATETIME
R
yes
input_translated
Wählen Sie über die optionale Startzeit (TT-MM-YYYY hh:mm), ab wann diese Kampagne beim Tracking berücksichtigt wird.
i18n_string
"ecs.CAMPAIGN.camp_time_start"
table
[ "eos_campaign" ]
fieldset
"planning"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "editMode": 0
}
camp_time_end
Endzeit
DATETIME
R
yes
input_translated
Wählen Sie die optionale Endzeit (TT-MM-YYYY hh:mm), bis wann diese Kampagne beim Tracking berücksichtigt wird.
i18n_string
"ecs.CAMPAIGN.camp_time_end"
table
[ "eos_campaign" ]
fieldset
"planning"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "editMode": 0
}
camp_urlvarvalue
URL Variablenwert
TEXT (31)
R
yes
input_translated
Dies ist der Variablenwert, der dem URL-GET-Parameter "xr" zugewiesen werden muss, damit ein Besucher dieser Kampagne zugeordnet wird.
Beispiel:
Variablenwert = "MyCampaign123"
Dann könnte exemplarisch eine Shop-URL mit Tracking, wie folgt aussehen:
www.Ihr-Shop.de/eineSeite.html?xr=MyCampaign123
i18n_string
"ecs.CAMPAIGN.camp_urlvarvalue"
table
[ "eos_campaign" ]
fieldset
"analytics"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "editMode": 0
}
camp_source
Quelle
TEXT (31)
R
yes
input_translated
Die Quelle des Traffics zur Vereinfachung, wenn mehrere Kampagnen verwendet werden. Hier könnte beispielsweise retention-newsletter, google, bing, etc. eingetragen werden.
i18n_string
"ecs.CAMPAIGN.camp_source"
table
[ "eos_campaign" ]
fieldset
"analytics"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "editMode": 0
}
camp_medium
Medium
TEXT (31)
R
yes
input_translated
Tragen Sie hier die Art des Traffics ein, die über die Quelle geliefert wird. Damit kann die Bewertung von Kampagnenergebnissen besser bewertet werden, da unterschiedliche Arten zumeist auch unterschiedliche Eigenschaften (z.B. andere Absprungraten,etc.) besitzen. Hier kann also beispielsweise email, pay-per-view, CPC, etc. stehen.
i18n_string
"ecs.CAMPAIGN.camp_medium"
table
[ "eos_campaign" ]
fieldset
"analytics"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "editMode": 0
}
camp_term
Begriff
TEXT (31)
R
yes
input_translated
Wenn die Kampagne eine Werbemaßnahme betrifft, können Sie hier Keywords definieren, die getrackt werden sollen. Mehrere Keywords können mit einem + getrennt werden, also beispielsweise mode+damen+shirts
i18n_string
"ecs.CAMPAIGN.camp_term"
table
[ "eos_campaign" ]
fieldset
"analytics"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "editMode": 0
}
camp_content
Inhalt
TEXT (31)
R
yes
input_translated
Wenn Sie unterschiedliche Werbemittel verwenden, die aber auf dieselbe URL verweisen, kann hierüber erfasst werden, welches Werbemittel geklickt wurde. Hier kann also beispielsweise banner-skyscraper, textlink, etc. eingetragen werden.
i18n_string
"ecs.CAMPAIGN.camp_content"
table
[ "eos_campaign" ]
fieldset
"analytics"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "editMode": 0
}
camp_campaign
Zusatz-Name
TEXT (31)
R
yes
input_translated
Definieren Sie hierüber einen möglichst eindeutigen Kampagnennamen oder Namen der Produktwerbeaktion (über alle verwendeten Kampagnen) mit der das Werbemittel verbunden ist. Machen Sie es sich an dieser Stelle nicht zu kompliziert, um den Überblick zu bewahren. Beispielsweise könnte hier winterschlussverkauf eingetragen werden.
i18n_string
"ecs.CAMPAIGN.camp_campaign"
table
[ "eos_campaign" ]
fieldset
"analytics"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "editMode": 0
}
camp_track_interval
Erkennungszeitraum
INT (11)
R
no
input_translated
Anzahl der TAGE, innerhalb derer ein Besucher, der ursprünglich über diese Kampagne gekommen ist, auch bei Folgebesuchen dieser Kampagne automatisch wieder zugeordnet wird.
Ein typischer Wert ist: "30" Tage.
i18n_string
"ecs.CAMPAIGN.camp_track_interval"
table
[ "eos_campaign" ]
fieldset
"tracking"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "editMode": 0
}
camp_trackvars
Tracking-Variablen
TEXT
R
yes
input_translated
Zu einer Kampagne lassen sich zusätzliche Variablen definieren, deren Werte vom Referrer im Link per URL-GET-Variablen übergeben werden. Auf die Variablen kann später im dynamischen Erstellen des Tracing-Codes auf der Bestellabschlussseite zugegriffen werden.

Mehrere Variablen müssen mit Semikolon ; getrennt werden.

Beispiel: var1;var2;var3
i18n_string
"ecs.CAMPAIGN.camp_trackvars"
table
[ "eos_campaign" ]
fieldset
"tracking"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "editMode": 0
}
camp_tracing_javascript
Verfolgungs-Javascript
TEXT
R
yes
input_translated
Tragen Sie hier Javascript-Code ein, der für die Kampagnenverfolgung auf der Bestellabschlussseite eingebunden wird. Innerhalb des Codes kann via Platzhaltern {} dynamisch auf alle Daten des neuen Auftrages zugegriffen werden. Mehrere Ebenen innerhalb des Platzhalters können via Slash / getrennt werden.

Platzhalterbeispiel: {person/personid} oder {orderid}
i18n_string
"ecs.CAMPAIGN.camp_tracing_javascript"
table
[ "eos_campaign" ]
fieldset
"tracking"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "editMode": 0
}
camp_tracing_code
Verfolgungs-Code
TEXT
R
yes
input_translated
Tragen Sie hier HTML-Code ein, der für die Kampagnenverfolgung auf der Bestellabschlussseite eingebunden wird. Innerhalb des Codes kann via Platzhaltern {} dynamisch auf alle Daten des neuen Auftrages zugegriffen werden. Mehrere Ebenen innerhalb des Platzhalters können dabei via Slash / getrennt werden.

Platzhalterbeispiel: {person/personid} oder {orderid}
i18n_string
"ecs.CAMPAIGN.camp_tracing_code"
table
[ "eos_campaign" ]
fieldset
"tracking"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "editMode": 0
}
camp_external_id
Externer Kampagnen-Id
TEXT (63)
R
yes
i18n_string
"ecs.CAMPAIGN.camp_external_id"
table
[ "eos_campaign" ]
fieldset
"external"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "editMode": 0
}
camp_external_src
Externer Kampagnen-Quelle
TEXT (127)
R
yes
i18n_string
"ecs.CAMPAIGN.camp_external_src"
table
[ "eos_campaign" ]
fieldset
"external"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "editMode": 0
}
camp_person_grpid → persongroup.grpid
Kundengruppe
INT (11)
R
no
input_translated
Kommt ein Besucher über diese Kampagne, so wird er automatisch dieser Kundengruppe zugeordnet.
i18n_string
"ecs.CAMPAIGN.camp_person_grpid"
table
[ "eos_campaign" ]
fieldset
"dynpricing"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "editMode": 0
}
camp_prc_col
Preisspalte
TEXT (63)
R
yes
input_translated
Kommt ein Besucher über diese Kampagne, so werden ihm Produkt-Preise aus dieser Preisspalte angzeigt.
Wird dies Feld leer gelassen, so wird die Standard-Produktpreisspalte genommen.
i18n_string
"ecs.CAMPAIGN.camp_prc_col"
table
[ "eos_campaign" ]
fieldset
"dynpricing"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "editMode": 0
}
camp_prc_mode
Preismodus
TEXT (7)
R
yes
input_translated
Kommt ein Besucher über diese Kampagne, so kann hierüber konfiguriert werden, ob er NETTO- oder BRUTTO-Preise (default) angezeigt bekommen soll.
i18n_string
"ecs.CAMPAIGN.camp_prc_mode"
table
[ "eos_campaign" ]
fieldset
"dynpricing"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "editMode": 0
}
camp_expected_order_revenue [EUR]
Erwarteter Umsatz (Order)
FLOAT (13,4)
R
yes
i18n_string
"ecs.CAMPAIGN.camp_expected_order_revenue"
table
[ "eos_campaign" ]
fieldset
"goals"
listCfg
{
    "formatter": {
        "type": "currency"
    },
    "viewMode": 0,
    "sumType": "SV"
}
formCfg
{
    "editMode": 0
}
camp_expected_order_cnt [#]
Erwartete Anzahl (Order)
INT (11)
R
yes
i18n_string
"ecs.CAMPAIGN.camp_expected_order_cnt"
table
[ "eos_campaign" ]
fieldset
"goals"
listCfg
{
    "viewMode": 0,
    "sumType": "SV"
}
formCfg
{
    "editMode": 0
}
camp_expected_lead_cnt [#]
Erwartete Anzahl (Leads)
INT (11)
R
yes
i18n_string
"ecs.CAMPAIGN.camp_expected_lead_cnt"
table
[ "eos_campaign" ]
fieldset
"goals"
listCfg
{
    "viewMode": 0,
    "sumType": "SV"
}
formCfg
{
    "editMode": 0
}
camp_expected_impression_cnt [#]
Erwartete Impressions
INT (11)
R
yes
i18n_string
"ecs.CAMPAIGN.camp_expected_impression_cnt"
table
[ "eos_campaign" ]
fieldset
"goals"
listCfg
{
    "viewMode": 0,
    "sumType": "SV"
}
formCfg
{
    "editMode": 0
}
camp_expected_costs [EUR]
Erwartete Kosten
FLOAT (13,4)
R
yes
i18n_string
"ecs.CAMPAIGN.camp_expected_costs"
table
[ "eos_campaign" ]
fieldset
"costs"
listCfg
{
    "formatter": {
        "type": "currency"
    },
    "viewMode": 0,
    "sumType": "SV"
}
formCfg
{
    "editMode": 0
}
camp_costs_actual [EUR]
Kosten - aktuell
FLOAT (13,4)
R
yes
i18n_string
"ecs.CAMPAIGN.camp_costs_actual"
table
[ "eos_campaign" ]
fieldset
"costs"
listCfg
{
    "formatter": {
        "type": "currency"
    },
    "viewMode": 0,
    "sumType": "SV"
}
formCfg
{
    "editMode": 0
}
camp_costs_initial [EUR]
Kosten, einmalig
FLOAT (13,4)
R
yes
i18n_string
"ecs.CAMPAIGN.camp_costs_initial"
table
[ "eos_campaign" ]
fieldset
"costs"
listCfg
{
    "formatter": {
        "type": "currency"
    },
    "viewMode": 0,
    "sumType": "SV"
}
formCfg
{
    "editMode": 0
}
camp_costs_po_abs [EUR]
Kosten pro Order, absolut (CPO-a)
FLOAT (13,4)
R
yes
i18n_string
"ecs.CAMPAIGN.camp_costs_po_abs"
table
[ "eos_campaign" ]
fieldset
"costs"
listCfg
{
    "formatter": {
        "type": "currency"
    },
    "viewMode": 0,
    "sumType": "SV"
}
formCfg
{
    "editMode": 0
}
camp_costs_po_perc [%]
Kosten pro Order, prozentual (CPO-p)
FLOAT (8,4)
R
yes
i18n_string
"ecs.CAMPAIGN.camp_costs_po_perc"
table
[ "eos_campaign" ]
fieldset
"costs"
listCfg
{
    "viewMode": 0,
    "sumType": "SV"
}
formCfg
{
    "editMode": 0
}
camp_costs_pi_abs [EUR]
Kosten pro Impression, absolut (CPI)
FLOAT (13,4)
R
yes
i18n_string
"ecs.CAMPAIGN.camp_costs_pi_abs"
table
[ "eos_campaign" ]
fieldset
"costs"
listCfg
{
    "formatter": {
        "type": "currency"
    },
    "viewMode": 0,
    "sumType": "SV"
}
formCfg
{
    "editMode": 0
}
camp_commission_initial [EUR]
Provision, einmalig
FLOAT (13,4)
R
yes
i18n_string
"ecs.CAMPAIGN.camp_commission_initial"
table
[ "eos_campaign" ]
fieldset
"commissions"
listCfg
{
    "formatter": {
        "type": "currency"
    },
    "viewMode": 0,
    "sumType": "SV"
}
formCfg
{
    "editMode": 0
}
camp_commission_po_abs [EUR]
Provision per Order, absolut
FLOAT (13,4)
R
yes
i18n_string
"ecs.CAMPAIGN.camp_commission_po_abs"
table
[ "eos_campaign" ]
fieldset
"commissions"
listCfg
{
    "formatter": {
        "type": "currency"
    },
    "viewMode": 0,
    "sumType": "SV"
}
formCfg
{
    "editMode": 0
}
camp_commission_po_perc [%]
Provision per Order, prozentual
FLOAT (8,4)
R
yes
i18n_string
"ecs.CAMPAIGN.camp_commission_po_perc"
table
[ "eos_campaign" ]
fieldset
"commissions"
listCfg
{
    "viewMode": 0,
    "sumType": "SV"
}
formCfg
{
    "editMode": 0
}
camp_commission_pi_abs
Provision pro Impression
FLOAT (13,4)
R
yes
i18n_string
"ecs.CAMPAIGN.camp_commission_pi_abs"
table
[ "eos_campaign" ]
fieldset
"commissions"
listCfg
{
    "viewMode": 0,
    "sumType": "SV"
}
formCfg
{
    "editMode": 0
}
camp_progress_data
Verlaufsdaten
DATA
R
yes
i18n_string
"ecs.CAMPAIGN.camp_progress_data"
table
[ "eos_campaign" ]
listCfg
{
    "viewMode": 0
}
formCfg
{
    "cssLayout": "col-12",
    "type": "aceeditor",
    "options": {
        "mode": "json"
    },
    "editMode": 0
}
camp_insert_user
Ersteller
TEXT (127)
R
yes
i18n_string
"insert_user"
table
[ "eos_campaign" ]
fieldset
"sys_record"
listCfg
{
    "formatter": {
        "type": "user"
    },
    "viewMode": 0
}
formCfg
{
    "editMode": 0
}
camp_update_user
Letzte Änderung durch
TEXT (127)
R
yes
i18n_string
"update_user"
table
[ "eos_campaign" ]
fieldset
"sys_record"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "editMode": 0
}
camp_time_insert
Angelegt am
DATETIME
R
no
i18n_string
"insert_time"
table
[ "eos_campaign" ]
fieldset
"sys_record"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "editMode": 0
}
camp_time_update
Geändert am
DATETIME
R
yes
i18n_string
"update_time"
table
[ "eos_campaign" ]
fieldset
"sys_record"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "editMode": 0
}
drvd_camp_difftime_end_day [d]
Zeit bis Ende
INT (11)
R
yes
i18n_string
"ecs.CAMPAIGN.drvd_camp_difftime_end_day"
table
[ "eos_campaign" ]
drvd_select
TIMESTAMPDIFF(DAY, eos_campaign.camp_time_end, NOW())
listCfg
{
    "viewMode": 0
}
formCfg
{
    "editMode": 0
}
datasetaddedfield
TEXT
R
yes
i18n_string
"ecs.CAMPAIGN.datasetaddedfield"
table
[ "eos_campaign" ]
fieldset
"dynamicFields"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "editMode": 0
}