Model fields

The model consists of the following fields.

Field Name
Display Name
Type
Permissions
Nullable

delivery

did primary auto increment
INT (11)
R+W
no
fieldset
"base_record"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "type": "hidden"
}
dv_seller_name
Verkäufername
TEXT
R+W
no
fieldset
"seller_addr"
listCfg
{
    "viewMode": 0
}
dv_seller_name2
Adressenzusatz
TEXT
R+W
no
fieldset
"seller_addr"
listCfg
{
    "viewMode": 0
}
dv_seller_street
Straße
TEXT
R+W
no
fieldset
"seller_addr"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "cssLayout": "col-9"
}
dv_seller_hnr
Hausnr.
TEXT
R+W
no
fieldset
"seller_addr"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "cssLayout": "col-3"
}
dv_seller_zip
PLZ
TEXT
R+W
no
fieldset
"seller_addr"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "cssLayout": "col-4"
}
dv_seller_city
Ort
TEXT
R+W
no
fieldset
"seller_addr"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "cssLayout": "col-8"
}
dv_seller_state_code
Bundesland (Code) (Verkäufer)
TEXT (15)
R+W
yes
fieldset
"seller_addr"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "cssLayout": "col-6",
    "type": "eosdropdown",
    "options": {
        "serverSideSearch": false,
        "optValueField": "terr_code",
        "optNameField": "terr_name",
        "optExtraField": "terr_code",
        "observer": {
            "fields": [
                {
                    "field": "dv_seller_country",
                    "trigger": "onInit",
                    "exec": [
                        {
                            "cmd": "loadOptions",
                            "params": {
                                "dataStreamCall": {
                                    "method": "state_getlist",
                                    "params": {
                                        "filter": {
                                            "state_country": "{%FIELD.value%}"
                                        }
                                    }
                                }
                            }
                        }
                    ]
                },
                {
                    "field": "dv_seller_country",
                    "trigger": "onChange",
                    "exec": [
                        {
                            "cmd": "loadOptions",
                            "params": {
                                "dataStreamCall": {
                                    "method": "state_getlist",
                                    "params": {
                                        "filter": {
                                            "state_country": "{%FIELD.value%}"
                                        }
                                    }
                                }
                            }
                        }
                    ]
                }
            ]
        }
    }
}
dv_seller_countrycountry.cy_iso
Land
TEXT (2)
R+W
no
fieldset
"seller_addr"
listCfg
{
    "viewMode": 0,
    "width": 64,
    "formatter": {
        "type": "country-flag"
    }
}
formCfg
{
    "cssLayout": "col-6"
}
dv_code primaryDisplay
Lieferungs-Nr.
TEXT (63)
R+W
no
fieldset
"base_record"
listCfg
{
    "fullSearch": true,
    "formatter": {
        "type": "model-primary",
        "params": {
            "model": "delivery",
            "primaryKey": "did",
            "statusColorField": "delivery_state_color",
            "subTitleTemplate": "{%dv_name%} {%dv_name2%}"
        }
    }
}
formCfg
{
    "cssLayout": "col-12 col-md-6 col-xl-3"
}
dv_extcode
Sendungsnr.
TEXT (63)
R+W
no
fieldset
"base"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "cssLayout": "col-6"
}
fk_dv_persidperson.persid
Kunde
INT (11)
R+W
yes
fieldset
"base_record"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "cssLayout": "col-12 col-md-6 col-xl-3"
}
fk_dv_oidorder.oid
Auftrags-Nr.
INT (11)
R+W
yes
fieldset
"base_record"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "cssLayout": "col-12 col-md-6 col-xl-3"
}
fk_dv_st_idshippingtype.st_id
Versandart
INT (11)
R+W
no
fieldset
"base_record"
listCfg
{
    "viewMode": 3
}
formCfg
{
    "cssLayout": "col-12 col-md-6 col-xl-3"
}
dv_time_insert
Angelegt am
DATETIME
R+W
no
i18n_string
"insert_time"
fieldset
"sys_record"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "editMode": 2
}
dv_time_update
Geändert am
DATETIME
R+W
yes
i18n_string
"update_time"
fieldset
"sys_record"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "editMode": 2
}
dv_user_insert
Ersteller
TEXT (127)
R+W
yes
i18n_string
"insert_user"
fieldset
"sys_record"
listCfg
{
    "formatter": {
        "type": "user"
    },
    "viewMode": 0
}
formCfg
{
    "editMode": 2
}
dv_user_update
Letzte Änderung durch
TEXT (127)
R+W
yes
i18n_string
"update_user"
fieldset
"sys_record"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "editMode": 2
}
dv_time_sent
Versendet am
DATETIME
R+W
yes
fieldset
"extra"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "type": "datepicker"
}
dv_comment
Kommentar
TEXT
R+W
no
fieldset
"extra"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "type": "textarea"
}
dv_comment_internal
Interner Kommentar
TEXT
R+W
yes
fieldset
"extra"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "type": "textarea"
}
dv_name
Name
TEXT
R+W
no
fieldset
"dlv_addr"
dv_company
Firma
TEXT
R+W
no
fieldset
"dlv_addr"
listCfg
{
    "fullSearch": true,
    "viewMode": 0
}
formCfg
{
    "cssLayout": "col-6"
}
dv_name2
Adressenzusatz
TEXT
R+W
no
fieldset
"dlv_addr"
listCfg
{
    "viewMode": 0,
    "fullSearch": true
}
formCfg
{
    "cssLayout": "col-6"
}
dv_street
Straße
TEXT
R+W
no
fieldset
"dlv_addr"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "cssLayout": "col-9"
}
dv_hnr
Hausnr.
TEXT
R+W
no
fieldset
"dlv_addr"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "cssLayout": "col-3"
}
dv_zip
PLZ
TEXT
R+W
no
fieldset
"dlv_addr"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "cssLayout": "col-4"
}
dv_city
Ort
TEXT
R+W
no
fieldset
"dlv_addr"
listCfg
{
    "fullSearch": true,
    "viewMode": 0
}
formCfg
{
    "cssLayout": "col-8"
}
dv_state_code
Bundesland (Code)
TEXT (15)
R+W
yes
fieldset
"dlv_addr"
formCfg
{
    "cssLayout": "col-6",
    "type": "eosdropdown",
    "options": {
        "serverSideSearch": false,
        "optValueField": "terr_code",
        "optNameField": "terr_name",
        "optExtraField": "terr_code",
        "observer": {
            "fields": [
                {
                    "field": "dv_country",
                    "trigger": "onInit",
                    "exec": [
                        {
                            "cmd": "loadOptions",
                            "params": {
                                "dataStreamCall": {
                                    "method": "state_getlist",
                                    "params": {
                                        "filter": {
                                            "state_country": "{%FIELD.value%}"
                                        }
                                    }
                                }
                            }
                        }
                    ]
                },
                {
                    "field": "dv_country",
                    "trigger": "onChange",
                    "exec": [
                        {
                            "cmd": "loadOptions",
                            "params": {
                                "dataStreamCall": {
                                    "method": "state_getlist",
                                    "params": {
                                        "filter": {
                                            "state_country": "{%FIELD.value%}"
                                        }
                                    }
                                }
                            }
                        }
                    ]
                }
            ]
        }
    }
}
dv_countrycountry.cy_iso
Land
TEXT (2)
R+W
no
fieldset
"dlv_addr"
listCfg
{
    "viewMode": 0,
    "width": 64,
    "formatter": {
        "type": "country-flag"
    }
}
formCfg
{
    "cssLayout": "col-6"
}
dv_phone
Telefon
TEXT
R+W
no
fieldset
"dlv_addr"
listCfg
{
    "viewMode": 0
}
drvd_dv_seller_street_hnr
Straße+Nr (Verkäufer)
TEXT
R
no
drvd_select
CONCAT_WS("",ecs_delivery.dv_seller_street," ",ecs_delivery.dv_seller_hnr)
listCfg
{
    "viewMode": 0
}
formCfg
{
    "editMode": 0
}
drvd_dv_street_hnr
Straße+Nr (L)
TEXT
R
no
drvd_select
CONCAT_WS("",ecs_delivery.dv_street," ",ecs_delivery.dv_hnr)
listCfg
{
    "viewMode": 0
}
formCfg
{
    "editMode": 0
}
drvd_dv_cnt_dvi
Anzahl Lagerartikel
FLOAT (13,4)
R
no
table
[ "ecs_deliveryitem" ]
drvd_select
SUM(ecs_deliveryitem.dvi_cnt)/IF(COUNT(ecs_deliveryitem.dviid),(COUNT(ecs_delivery.did) /COUNT(DISTINCT ecs_deliveryitem.dviid)),1) 
listCfg
{
    "sumType": "SV"
}
formCfg
{
    "editMode": 0
}
delivery_state_color
TEXT (15)
R
no
table
[ "eos_states" ]
drvd_select
eos_states.st_color
listCfg
{
    "viewMode": 0
}
formCfg
{
    "editMode": 0
}
item_id
INT
R
no
drvd_select
ecs_delivery.did
listCfg
{
    "viewMode": 3
}
formCfg
{
    "editMode": 0
}
i18n_st_name
Statusname
TEXT
R
no
i18n_string
"st_name"
table
[ "eos_states" ]
drvd_select
eos_states.i18n_st_name_DE
listCfg
{
    "viewMode": 0,
    "formatter": {
        "type": "status",
        "params": {
            "statusColorField": "delivery_state_color"
        }
    }
}
formCfg
{
    "editMode": 0
}
i18n_st_name_public
Öffentlicher Statusname
TEXT
R
no
i18n_string
"st_name_public"
table
[ "eos_states" ]
drvd_select
eos_states.i18n_st_name_public_DE
listCfg
{
    "viewMode": 0,
    "formatter": {
        "type": "status",
        "params": {
            "statusColorField": "delivery_state_color"
        }
    }
}
formCfg
{
    "editMode": 0
}
st_x_dv_sent
INT (4)
R
no
table
[ "eos_states" ]
drvd_select
eos_states.st_x_dv_sent
listCfg
{
    "viewMode": 3
}
formCfg
{
    "editMode": 0
}
st_code
Status
TEXT
R
no
table
[ "eos_states" ]
drvd_select
eos_states.st_code
listCfg
{
    "viewMode": 3
}
formCfg
{
    "editMode": 0
}
st_position
INT
R
no
table
[ "eos_states" ]
drvd_select
eos_states.st_position
listCfg
{
    "viewMode": 3
}
formCfg
{
    "editMode": 0
}
is_current
INT (1)
R+W
no
table
[ "eos_statelog" ]
listCfg
{
    "viewMode": 3
}
formCfg
{
    "editMode": 0
}
transtime
DATETIME
R+W
no
table
[ "eos_statelog" ]
listCfg
{
    "viewMode": 0
}
formCfg
{
    "editMode": 0
}
node_id
INT (11)
R+W
yes
table
[ "ewh_nstgrp_item2node" ]
listCfg
{
    "viewMode": 3
}
formCfg
{
    "editMode": 0
}
drvd_dv_dvi_si_weight
Gewicht (kg)
FLOAT (13,4)
R
no
table
[ "ewh_nstgrp_item2node" ]
drvd_select
IF(COUNT(ewh_nstgrp_item2node.si_weight) < COUNT(*),NULL,(SUM(ecs_deliveryitem.dvi_cnt * ewh_nstgrp_item2node.si_weight)))/IF(COUNT(ecs_deliveryitem.dviid),(COUNT(ecs_delivery.did) /COUNT(DISTINCT ecs_deliveryitem.dviid)),1) 
listCfg
{
    "viewMode": 0,
    "sumType": "SV"
}
formCfg
{
    "editMode": 0
}
drvd_dv_dvi_si_available_confirm_date
DATETIME
R
yes
table
[ "ewh_nstgrp_item2node" ]
drvd_select
MAX(IF(ewh_nstgrp_item2node.si_preconfirm_incoming != 1, ewh_nstgrp_item2node.si_time_available,null))
listCfg
{
    "viewMode": 0
}
formCfg
{
    "editMode": 0
}
fk_dv_psidpackstation.psid
Packstation
INT (11)
R+W
no
i18n_string
"ecs_plugin_ewarehouse.DELIVERY.ps_name"
table
"ecs_delivery"
fk_dv_dgrp_iddeliverygroup.dgrp_id
Versandliste
INT (11)
R+W
yes
i18n_string
"ecs_plugin_ewarehouse.DELIVERY.fk_dv_dgrp_id"
table
"ecs_delivery"
dv_cost_total_ship
Versandkosten
FLOAT (13,2)
R+W
yes
i18n_string
"ecs_plugin_ewarehouse.DELIVERY.dv_cost_total_ship"
dv_cost_total_purchase
Artikel-Einkaufskosten
FLOAT (13,2)
R+W
yes
i18n_string
"ecs_plugin_ewarehouse.DELIVERY.dv_cost_total_purchase"
dv_time_rsvd
Reserviert am
DATETIME
R+W
yes
i18n_string
"ecs_plugin_ewarehouse.DELIVERY.dv_time_rsvd"
dv_time_transfer
Transferiert am
DATETIME
R+W
yes
i18n_string
"ecs_plugin_ewarehouse.DELIVERY.dv_time_transfer"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "editMode": 0
}
dv_time_planned_send
Geplante Sendezeit
DATETIME
R+W
yes
i18n_string
"ecs_plugin_ewarehouse.DELIVERY.dv_time_planned_send"
drvd_dv_cnt_dvi_reserved
Reserviert
FLOAT (13,4)
R
no
i18n_string
"ecs_plugin_ewarehouse.DELIVERY.drvd_dv_cnt_dvi_reserved"
table
"ecs_deliveryitem"
drvd_select
SUM(ecs_deliveryitem.dvi_rsvd_cnt)/IF(COUNT(ecs_deliveryitem.dviid),(COUNT(ecs_delivery.did) /COUNT(DISTINCT ecs_deliveryitem.dviid)),1) 
listCfg
{
    "viewMode": 0,
    "sumType": "SV"
}
formCfg
{
    "editMode": 0
}
drvd_dv_cnt_dvi_not_reserved
Nicht reserviert
FLOAT (13,4)
R
no
i18n_string
"ecs_plugin_ewarehouse.DELIVERY.drvd_dv_cnt_dvi_not_reserved"
table
[ "ecs_delivery", "ecs_deliveryitem" ]
drvd_select
IF(ecs_delivery.dv_time_sent IS NOT NULL,0,(SUM(ecs_deliveryitem.dvi_cnt) - SUM(ecs_deliveryitem.dvi_rsvd_cnt))/IF(COUNT(ecs_deliveryitem.dviid),(COUNT(ecs_delivery.did) /COUNT(DISTINCT ecs_deliveryitem.dviid)),1) )
listCfg
{
    "viewMode": 0,
    "sumType": "SV"
}
formCfg
{
    "editMode": 0
}
drvd_dv_cnt_dvi_reserved_confirmed
Reserviert (bestätigt)
FLOAT (13,4)
R
no
i18n_string
"ecs_plugin_ewarehouse.DELIVERY.drvd_dv_cnt_dvi_reserved_confirmed"
table
"ecs_deliveryitem"
drvd_select
SUM(ecs_deliveryitem.dvi_rsvd_confirmed_cnt)/IF(COUNT(ecs_deliveryitem.dviid),(COUNT(ecs_delivery.did) /COUNT(DISTINCT ecs_deliveryitem.dviid)),1) 
listCfg
{
    "viewMode": 0,
    "sumType": "SV"
}
formCfg
{
    "editMode": 0
}
drvd_dv_cnt_dvi_not_reserved_confirmed
Nicht reserviert (bestätigt)
FLOAT (13,4)
R
no
i18n_string
"ecs_plugin_ewarehouse.DELIVERY.drvd_dv_cnt_dvi_not_reserved_confirmed"
table
[ "ecs_delivery", "ecs_deliveryitem" ]
drvd_select
IF(ecs_delivery.dv_time_sent IS NOT NULL,0,(SUM(ecs_deliveryitem.dvi_cnt) - SUM(ecs_deliveryitem.dvi_rsvd_confirmed_cnt))/IF(COUNT(ecs_deliveryitem.dviid),(COUNT(ecs_delivery.did) /COUNT(DISTINCT ecs_deliveryitem.dviid)),1) )
listCfg
{
    "viewMode": 0,
    "sumType": "SV"
}
formCfg
{
    "editMode": 0
}
drvd_dvi_items_info
Lieferartikel
TEXT
R
no
i18n_string
"ecs_plugin_ewarehouse.DELIVERY.drvd_dvi_items_info"
table
"ecs_deliveryitem"
drvd_select
GROUP_CONCAT(DISTINCT CONCAT(IF(ecs_deliveryitem.fk_dvi_item_id IS NOT NULL,ecs_deliveryitem.fk_dvi_item_id,""),"|",ecs_deliveryitem.dvi_pcode,"|",ecs_deliveryitem.dvi_cnt,"|",ecs_deliveryitem.dvi_rsvd_cnt,"|",ecs_deliveryitem.dvi_rsvd_confirmed_cnt) SEPARATOR "#")
listCfg
{
    "viewMode": 0,
    "sortable": 0
}
formCfg
{
    "editMode": 0
}
dgrp_id
INT (11)
R+W
no
i18n_string
"ecs_plugin_ewarehouse.DELIVERYGROUP.dgrp_id"
table
"ewh_delivery_group"
listCfg
{
    "viewMode": 3
}
formCfg
{
    "editMode": 0
}
dgrp_code
Versandliste
TEXT (27)
R+W
yes
i18n_string
"ecs_plugin_ewarehouse.DELIVERYGROUP.dgrp_code"
table
"ewh_delivery_group"
listCfg
{
    "viewMode": 0,
    "fullSearch": true
}
formCfg
{
    "editMode": 0
}
dgrp_time_sent
Lieferdatum
DATETIME
R+W
yes
i18n_string
"ecs_plugin_ewarehouse.DELIVERYGROUP.dgrp_time_sent"
table
"ewh_delivery_group"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "editMode": 0
}
st_x_dv_reqtopick
INT (4)
R
no
table
[ "eos_statelog", "eos_states", "eos_statesets" ]
drvd_select
eos_states.st_x_dv_reqtopick
listCfg
{
    "viewMode": 3
}
formCfg
{
    "editMode": 0
}
st_x_dv_inpicking
INT (4)
R
no
table
[ "eos_statelog", "eos_states", "eos_statesets" ]
drvd_select
eos_states.st_x_dv_inpicking
listCfg
{
    "viewMode": 3
}
formCfg
{
    "editMode": 0
}
st_x_dv_delivered
INT (4)
R
no
table
[ "eos_statelog", "eos_states", "eos_statesets" ]
drvd_select
eos_states.st_x_dv_delivered
listCfg
{
    "viewMode": 3
}
formCfg
{
    "editMode": 0
}
st_x_dv_unrsvd
INT (4)
R
no
table
[ "eos_statelog", "eos_states", "eos_statesets" ]
drvd_select
eos_states.st_x_dv_unrsvd
listCfg
{
    "viewMode": 3
}
formCfg
{
    "editMode": 0
}
st_x_dv_rsvd
INT (4)
R
no
table
[ "eos_statelog", "eos_states", "eos_statesets" ]
drvd_select
eos_states.st_x_dv_rsvd
listCfg
{
    "viewMode": 3
}
formCfg
{
    "editMode": 0
}
st_x_dv_sendable
INT (4)
R
no
table
[ "eos_statelog", "eos_states", "eos_statesets" ]
drvd_select
eos_states.st_x_dv_sendable
listCfg
{
    "viewMode": 3
}
formCfg
{
    "editMode": 0
}
fk_dv_shp_c_idshipping_carrier.shp_c_id
Logistiker
INT (11)
R+W
no
fieldset
"base"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "cssLayout": "col-6"
}
dv_carrier_time_pickedup
Abgeholt am (laut Logistiker)
DATETIME
R+W
yes
fieldset
"base"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "cssLayout": "col-3",
    "editMode": 2
}
dv_carrier_time_delivered
Geliefert am (laut Logistiker)
DATETIME
R+W
yes
fieldset
"base"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "cssLayout": "col-3",
    "editMode": 2
}
dv_carrier_status
Logistiker-Sendungsstatus
TEXT
R+W
yes
fieldset
"base"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "cssLayout": "col-6",
    "editMode": 2
}
dv_carrier_id
Logistiker externe ID
TEXT (63)
R+W
yes
listCfg
{
    "viewMode": 0
}
formCfg
{
    "editMode": 0
}
dv_shipping_details
Detail-Daten
DATA
R+W
yes
fieldset
"extra"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "cssLayout": "col-12",
    "type": "aceeditor",
    "options": {
        "mode": "json"
    }
}
drvd_dv_trace_url
Sendung verfolgen
TEXT
R
no
table
[ "ecs_delivery", "ecs_shp_carrier" ]
drvd_select
IF((ecs_delivery.dv_extcode is not null AND ecs_shp_carrier.shp_c_track_url is not null),
                REPLACE(ecs_shp_carrier.shp_c_track_url, '{dv_extcode}', ecs_delivery.dv_extcode),null)
listCfg
{
    "formatter": {
        "type": "url",
        "params": {
            "text": "Sendung verfolgen",
            "iconLabel": "hublify\/link-external"
        }
    }
}
formCfg
{
    "editMode": 0
}
drvd_shipping_label_url
Versandlabel
TEXT
R
no
table
[ "ecs_delivery" ]
drvd_select
JSON_UNQUOTE(json_extract(ecs_delivery.dv_shipping_details,'$.label_url'))
listCfg
{
    "viewMode": 0,
    "formatter": {
        "type": "url",
        "params": {
            "text": "Versandlabel",
            "iconLabel": "hublify\/link-external"
        }
    }
}
formCfg
{
    "editMode": 0
}
drvd_customs_declaration_url
Zollerklärung
TEXT
R
no
table
[ "ecs_delivery" ]
drvd_select
JSON_UNQUOTE(json_extract(ecs_delivery.dv_shipping_details,'$.customs_declaration.carrier_declaration_document_url'))
listCfg
{
    "viewMode": 0,
    "formatter": {
        "type": "url",
        "params": {
            "text": "Zollerkl\u00e4rung",
            "iconLabel": "hublify\/link-external"
        }
    }
}
formCfg
{
    "editMode": 0
}
drvd_dv_state_name
Bundesland (Name)
TEXT
R
no
table
[ "dv_terr_state" ]
drvd_select
dv_terr_state.terr_name
listCfg
{
    "viewMode": 0
}
formCfg
{
    "editMode": 0
}
drvd_dv_state_path
Bundesland (Pfad)
TEXT
R
no
table
[ "dv_terr_state" ]
drvd_select
dv_terr_state.i18n_node_path_DE
listCfg
{
    "viewMode": 0
}
formCfg
{
    "editMode": 0
}
drvd_dv_seller_state_name
Bundesland (Name) (Verkäufer)
TEXT
R
no
table
[ "dv_seller_terr_state" ]
drvd_select
dv_seller_terr_state.terr_name
listCfg
{
    "viewMode": 0
}
formCfg
{
    "editMode": 0
}
drvd_dv_seller_state_path
Bundesland (Pfad) (Verkäufer)
TEXT
R
no
table
[ "dv_seller_terr_state" ]
drvd_select
dv_seller_terr_state.i18n_node_path_DE
listCfg
{
    "viewMode": 0
}
formCfg
{
    "editMode": 0
}
drvd_dv_dvi_weight
Gewicht (kg)
FLOAT
R
no
table
[ "ecs_deliveryitem", "excdb_data_ecs_product_de" ]
drvd_select
IF(COUNT(excdb_data_ecs_product_de.prd_weight) < COUNT(*),NULL,(SUM(ecs_deliveryitem.dvi_cnt * excdb_data_ecs_product_de.prd_weight)/1000))/IF(COUNT(ecs_deliveryitem.dviid),(COUNT(ecs_delivery.did) /COUNT(DISTINCT ecs_deliveryitem.dviid)),1) 
listCfg
{
    "viewMode": 0
}
formCfg
{
    "editMode": 0
}
drvd_dv_itemlist
TEXT
R
no
table
[ "ecs_deliveryitem" ]
drvd_select
GROUP_CONCAT(distinct CONCAT_WS("|", ecs_deliveryitem.dvi_pcode,ecs_deliveryitem.dvi_name,ecs_deliveryitem.dvi_cnt) ORDER BY ecs_deliveryitem.dvi_pcode ASC SEPARATOR "###")
listCfg
{
    "viewMode": 0
}
formCfg
{
    "editMode": 0
}
drvd_inv_info
Rechnungen zum Auftrag
DATA
R
yes
table
"ecs_invoice"
drvd_select
CONCAT("{\"model\": \"invoice\",\"primaryKey\": \"inv_id\",\"displayKey\": \"inv_code\",\"data\": [",
                    GROUP_CONCAT(DISTINCT IF(ecs_invoice.inv_id IS NULL, null, JSON_OBJECT(
                    'inv_id',ecs_invoice.inv_id,
                    'inv_code',ecs_invoice.inv_code,
                    'inv_time_invoice', ecs_invoice.inv_time_invoice,
                    'inv_amount',ecs_invoice.inv_amount,
                    'inv_status_color',CASE ecs_invoice.inv_status WHEN "open" THEN "#CE0002" WHEN "done" THEN "#85B200" ELSE NULL END
                    )) ORDER BY ecs_invoice.inv_id ASC SEPARATOR ","),"]}")
listCfg
{
    "viewMode": 0,
    "formatter": {
        "type": "sub-data-chip",
        "params": {
            "chipOptions": {
                "subTitleTemplate": "{% inv_amount|money(2) %} \u20ac ({% inv_time_invoice|date() %})",
                "statusColorField": "inv_status_color"
            }
        }
    }
}
formCfg
{
    "editMode": 0
}
drvd_inv_codes
Rg.Nummern zum Auftrag
TEXT
R
no
table
"ecs_invoice"
drvd_select
GROUP_CONCAT(DISTINCT ecs_invoice.inv_code)
listCfg
{
    "viewMode": 0
}
formCfg
{
    "editMode": 0
}
inv_code
TEXT
R+W
no
table
"ecs_invoice"
listCfg
{
    "viewMode": 3
}
formCfg
{
    "editMode": 0
}
drvd_inv_amount_total
Gesamt­rechnungs­betrag zum Auftrag
FLOAT
R
no
table
[ "ecs_invoice" ]
drvd_select
SUM(ecs_invoice.inv_amount)/IF (count(ecs_invoice.inv_id), (count(ecs_delivery.did)/count(distinct ecs_invoice.inv_id)),1)
listCfg
{
    "viewMode": 3
}
formCfg
{
    "editMode": 0
}
drvd_inv_amount_not_paid
Ausstehender Rechnungsbetrag für den Auftrag
FLOAT
R
no
table
[ "ecs_invoice" ]
drvd_select
SUM(IF(ecs_invoice.inv_status='open', ecs_invoice.inv_amount-ecs_invoice.inv_amount_paid,0.00))/IF (count(ecs_invoice.inv_id), (count(ecs_delivery.did)/count(distinct ecs_invoice.inv_id)),1)
listCfg
{
    "viewMode": 0
}
formCfg
{
    "editMode": 0
}
drvd_dv_info_others
Weitere Lieferungen zum Auftrag
TEXT
R
no
table
[ "ecs_delivery_others" ]
drvd_select
GROUP_CONCAT(DISTINCT CONCAT(ecs_delivery_others.dv_code,'|',ecs_delivery_others.did) SEPARATOR '###')
listCfg
{
    "viewMode": 0
}
formCfg
{
    "editMode": 0
}
drvd_dv_codes_others
Weitere Lfg.Nummern zum Auftrag
TEXT
R
no
table
[ "ecs_delivery_others" ]
drvd_select
GROUP_CONCAT(DISTINCT ecs_delivery_others.dv_code)
listCfg
{
    "viewMode": 0
}
formCfg
{
    "editMode": 0
}

order

Following fields can also be selected for reading (JOIN)

oid
OID
INT (11)
R
no
i18n_string
"ecs.ORDER.oid"
table
[ "eos_order" ]
fieldset
"base_record"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "hidden",
    "editMode": 0
}
fk_o_shopidshopconfig.eshopid
Shop
INT (11)
R
yes
input_translated
Wählen Sie den Shop aus, zu dem dieser Auftrag gehört.
i18n_string
"ecs.ORDER.fk_o_shopid"
table
[ "eos_order" ]
fieldset
"marketing"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
orderid
Auftrags-Nr.
TEXT (63)
R
no
i18n_string
"ecs.ORDER.orderid"
table
[ "eos_order" ]
fieldset
"base_record"
listCfg
{
    "fullSearch": false,
    "formatter": {
        "type": "model-primary",
        "params": {
            "model": "order",
            "primaryKey": "oid",
            "statusColorField": "order_state_color",
            "subTitleTemplate": "{%invoice_firstname%} {%invoice_lastname%}"
        }
    },
    "viewMode": 1,
    "depends_on": "fk_dv_oid"
}
formCfg
{
    "cssLayout": "col-12 col-md-6 col-xl-3",
    "editMode": 0
}
fk_o_persidperson.persid
Kunde
INT (11)
R
yes
input_translated
Geben Sie die Kunden-ID eines Kunden ein.
i18n_string
"ecs.ORDER.fk_o_persid"
table
[ "eos_order" ]
fieldset
"base_record"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "cssLayout": "col-12 col-md-6 col-xl-3",
    "mandatory": true,
    "editMode": 0
}
o_time_ordered
Bestell­datum
DATETIME
R
yes
i18n_string
"ecs.ORDER.o_time_ordered"
table
[ "eos_order" ]
fieldset
"base_record"
listCfg
{
    "formatter": {
        "type": "date"
    },
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "cssLayout": "col-12 col-md-6 col-xl-3",
    "editMode": 0
}
total_netto [EUR]
∑ Gesamt, Netto
FLOAT (13,2)
R
no
i18n_string
"ecs.ORDER.total_netto"
table
[ "eos_order" ]
listCfg
{
    "formatter": {
        "type": "currency"
    },
    "viewMode": 0,
    "sumType": "SV",
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
total_brutto [EUR]
∑ Gesamt, Brutto
FLOAT (13,2)
R
no
i18n_string
"ecs.ORDER.total_brutto"
table
[ "eos_order" ]
listCfg
{
    "formatter": {
        "type": "currency"
    },
    "sumType": "SV",
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
o_orderid_external
Externe Auftrags-Nr.
TEXT (255)
R
yes
input_translated
Geben Sie hier ggf. eine externe erhaltene Auftragsnummer ein. Diese bekommen Sie z.B. wenn der Auftrag über einen externen Marktplatz (z.B. Amazon Marketplace) erstellt wurde.
i18n_string
"ecs.ORDER.o_orderid_external"
table
[ "eos_order" ]
fieldset
"base"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "cssLayout": "col-12 col-md-6 col-xl-3",
    "editMode": 0
}
fk_o_posidorderpos.posid
POS Channel (ID)
INT (11)
R
yes
i18n_string
"ecs.ORDER.fk_o_posid"
table
[ "eos_order" ]
fieldset
"base"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "cssLayout": "col-12 col-md-6 col-xl-3",
    "editMode": 0
}
fk_o_stidorderstate.stid
Status
INT (11)
R
no
i18n_string
"ecs.ORDER.fk_o_stid"
table
[ "eos_order" ]
fieldset
"base"
listCfg
{
    "viewMode": 3,
    "fullSearch": false
}
formCfg
{
    "cssLayout": "col-12 col-md-6 col-xl-3",
    "editMode": 0
}
fk_o_st_idshippingtype.st_id
Versandart
INT (11)
R
no
i18n_string
"ecs.ORDER.fk_o_st_id"
table
[ "eos_order" ]
fieldset
"base"
listCfg
{
    "viewMode": 3,
    "fullSearch": false
}
formCfg
{
    "cssLayout": "col-12 col-md-6 col-xl-3",
    "editMode": 0
}
o_pers_reftext
Kunden-Referenztext
TEXT
R
yes
input_translated
Geben Sie einen Referenztext des Kunden ein.
i18n_string
"ecs.ORDER.o_pers_reftext"
table
[ "eos_order" ]
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
o_pers_seq_nr
Auftrags-Sequenz-Nr.
INT (11)
R
no
i18n_string
"ecs.ORDER.o_pers_seq_nr"
table
[ "eos_order" ]
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
quantity
Bestellmenge
FLOAT (13,4)
R
no
i18n_string
"ecs.ORDER.quantity"
table
[ "eos_order" ]
listCfg
{
    "viewMode": 0,
    "sumType": "SV",
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
drvd_total_vat [EUR]
MwSt. (Gesamt)
FLOAT (13,2)
R
no
i18n_string
"ecs.ORDER.drvd_total_vat"
table
[ "eos_order" ]
drvd_select
ROUND(eos_order.total_brutto - eos_order.total_netto, 2)
listCfg
{
    "formatter": {
        "type": "currency"
    },
    "viewMode": 0,
    "sumType": "SV",
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
currency
Währung
TEXT (3)
R
no
i18n_string
"ecs.ORDER.currency"
table
[ "eos_order" ]
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
otitle
Auftragstitel
TEXT
R
yes
input_translated
Geben Sie dem Auftrag einen Titel.
i18n_string
"ecs.ORDER.otitle"
table
[ "eos_order" ]
fieldset
"doc_header"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "cssLayout": "col-12",
    "editMode": 0
}
otext
Auftragsbeschreibung
TEXT
R
yes
i18n_string
"ecs.ORDER.otext"
table
[ "eos_order" ]
fieldset
"extra"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "textarea",
    "editMode": 0
}
o_type
Auftragstyp
TEXT (15)
R
yes
enum
[ "order", "offer" ]
i18n_string
"ecs.ORDER.o_type"
table
[ "eos_order" ]
fieldset
"base_record"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
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"
                }
            ]
        }
    },
    "editMode": 0
}
o_valid_until
Gültig bis
DATETIME
R
yes
i18n_string
"ecs.ORDER.o_valid_until"
table
[ "eos_order" ]
listCfg
{
    "viewMode": 0,
    "formatter": {
        "type": "date"
    },
    "fullSearch": false
}
formCfg
{
    "type": "datetimepicker",
    "editMode": 0
}
o_txt_header
Kopf-Text
TEXT
R
yes
input_translated
Kopf-Text für die Verwendung in PDFs
i18n_string
"ecs.ORDER.o_txt_header"
table
[ "eos_order" ]
fieldset
"doc_header"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "fieldSetCol": "12",
    "type": "eoseditor",
    "editMode": 0
}
invoice_addr_preset
Adressbuch (R)
TEXT
R
yes
i18n_string
"ecs.ORDER.invoice_addr_preset"
table
[ "eos_order" ]
drvd_select
NULL
fieldset
"inv_addr"
listCfg
{
    "viewMode": 3,
    "fullSearch": false
}
formCfg
{
    "cssLayout": "col-12",
    "type": "eosdropdown",
    "options": {
        "serverSideSearch": false,
        "valueType": "object",
        "optNameTemplate": "{%adr_lastname%}, {%adr_firstname%} ({%adr_company%})",
        "optSubTitleTemplate": "{%adr_extra1%} {%adr_street%} {%adr_housenr%}, {%adr_zip%} {%adr_town%} - {%adr_country%}",
        "optExtraTemplate": "{%adr_ref_type%}",
        "optDataLoad": [
            "adr_gender"
        ],
        "observer": {
            "fields": [
                {
                    "field": "fk_o_persid",
                    "trigger": "onInit",
                    "exec": [
                        {
                            "cmd": "loadOptions",
                            "params": {
                                "dataStreamCall": {
                                    "method": "paddress_getlist",
                                    "params": {
                                        "filter": {
                                            "adr_ref_id": "{%FIELD.value%}"
                                        }
                                    }
                                }
                            }
                        }
                    ]
                },
                {
                    "field": "fk_o_persid",
                    "trigger": "onChange",
                    "exec": [
                        {
                            "cmd": "loadOptions",
                            "params": {
                                "dataStreamCall": {
                                    "method": "paddress_getlist",
                                    "params": {
                                        "filter": {
                                            "adr_ref_id": "{%FIELD.value%}"
                                        }
                                    }
                                }
                            }
                        }
                    ]
                }
            ]
        }
    },
    "editMode": 0
}
invoice_gender
Anrede (R)
TEXT
R
yes
enum
[ "female", "male", "company", "divers" ]
i18n_string
"ecs.ORDER.invoice_gender"
table
[ "eos_order" ]
fieldset
"inv_addr"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
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"
                }
            ]
        },
        "observer": {
            "fields": [
                {
                    "field": "invoice_addr_preset",
                    "trigger": "onChange",
                    "exec": [
                        {
                            "cmd": "template",
                            "params": {
                                "tpl": "{% FIELD.value.data.adr_gender %}"
                            }
                        }
                    ]
                }
            ]
        }
    },
    "editMode": 0
}
invoice_title
Titel (R)
TEXT
R
no
i18n_string
"ecs.ORDER.invoice_title"
table
[ "eos_order" ]
fieldset
"inv_addr"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "cssLayout": "col-6 col-xl-2",
    "type": "text",
    "options": {
        "observer": {
            "fields": [
                {
                    "field": "invoice_addr_preset",
                    "trigger": "onChange",
                    "exec": [
                        {
                            "cmd": "template",
                            "params": {
                                "tpl": "{% FIELD.value.data.adr_title %}"
                            }
                        }
                    ]
                }
            ]
        }
    },
    "editMode": 0
}
invoice_firstname
Vorname (R)
TEXT
R
no
i18n_string
"ecs.ORDER.invoice_firstname"
table
[ "eos_order" ]
fieldset
"inv_addr"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "cssLayout": "col-6 col-xl-4",
    "type": "text",
    "options": {
        "observer": {
            "fields": [
                {
                    "field": "invoice_addr_preset",
                    "trigger": "onChange",
                    "exec": [
                        {
                            "cmd": "template",
                            "params": {
                                "tpl": "{% FIELD.value.data.adr_firstname%}"
                            }
                        }
                    ]
                }
            ]
        }
    },
    "editMode": 0
}
invoice_lastname
Nachname (R)
TEXT
R
no
i18n_string
"ecs.ORDER.invoice_lastname"
table
[ "eos_order" ]
fieldset
"inv_addr"
listCfg
{
    "fullSearch": false,
    "viewMode": 0
}
formCfg
{
    "cssLayout": "col-6 col-xl-4",
    "type": "text",
    "options": {
        "observer": {
            "fields": [
                {
                    "field": "invoice_addr_preset",
                    "trigger": "onChange",
                    "exec": [
                        {
                            "cmd": "template",
                            "params": {
                                "tpl": "{% FIELD.value.data.adr_lastname %}"
                            }
                        }
                    ]
                }
            ]
        }
    },
    "editMode": 0
}
invoice_company
Firma (R)
TEXT
R
no
i18n_string
"ecs.ORDER.invoice_company"
table
[ "eos_order" ]
fieldset
"inv_addr"
listCfg
{
    "fullSearch": false,
    "viewMode": 0
}
formCfg
{
    "cssLayout": "col-6",
    "type": "text",
    "options": {
        "observer": {
            "fields": [
                {
                    "field": "invoice_addr_preset",
                    "trigger": "onChange",
                    "exec": [
                        {
                            "cmd": "template",
                            "params": {
                                "tpl": "{% FIELD.value.data.adr_company %}"
                            }
                        }
                    ]
                }
            ]
        }
    },
    "editMode": 0
}
invoice_addrextra
Adressenzusatz
TEXT
R
no
i18n_string
"ecs.ORDER.invoice_addrextra"
table
[ "eos_order" ]
fieldset
"inv_addr"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "cssLayout": "col-6",
    "type": "text",
    "options": {
        "observer": {
            "fields": [
                {
                    "field": "invoice_addr_preset",
                    "trigger": "onChange",
                    "exec": [
                        {
                            "cmd": "template",
                            "params": {
                                "tpl": "{% FIELD.value.data.adr_extra1 %}"
                            }
                        }
                    ]
                }
            ]
        }
    },
    "editMode": 0
}
invoice_street
Straße (R)
TEXT
R
no
i18n_string
"ecs.ORDER.invoice_street"
table
[ "eos_order" ]
fieldset
"inv_addr"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "cssLayout": "col-9",
    "type": "text",
    "options": {
        "observer": {
            "fields": [
                {
                    "field": "invoice_addr_preset",
                    "trigger": "onChange",
                    "exec": [
                        {
                            "cmd": "template",
                            "params": {
                                "tpl": "{% FIELD.value.data.adr_street %}"
                            }
                        }
                    ]
                }
            ]
        }
    },
    "editMode": 0
}
invoice_housenr
Hausnummer (R)
TEXT
R
no
i18n_string
"ecs.ORDER.invoice_housenr"
table
[ "eos_order" ]
fieldset
"inv_addr"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "cssLayout": "col-3",
    "type": "text",
    "options": {
        "observer": {
            "fields": [
                {
                    "field": "invoice_addr_preset",
                    "trigger": "onChange",
                    "exec": [
                        {
                            "cmd": "template",
                            "params": {
                                "tpl": "{% FIELD.value.data.adr_housenr %}"
                            }
                        }
                    ]
                }
            ]
        }
    },
    "editMode": 0
}
invoice_zip
PLZ (R)
TEXT
R
no
i18n_string
"ecs.ORDER.invoice_zip"
table
[ "eos_order" ]
fieldset
"inv_addr"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "cssLayout": "col-4",
    "type": "text",
    "options": {
        "observer": {
            "fields": [
                {
                    "field": "invoice_addr_preset",
                    "trigger": "onChange",
                    "exec": [
                        {
                            "cmd": "template",
                            "params": {
                                "tpl": "{% FIELD.value.data.adr_zip %}"
                            }
                        }
                    ]
                }
            ]
        }
    },
    "editMode": 0
}
invoice_town
Ort (R)
TEXT
R
no
i18n_string
"ecs.ORDER.invoice_town"
table
[ "eos_order" ]
fieldset
"inv_addr"
listCfg
{
    "fullSearch": false,
    "viewMode": 0
}
formCfg
{
    "cssLayout": "col-8",
    "type": "text",
    "options": {
        "observer": {
            "fields": [
                {
                    "field": "invoice_addr_preset",
                    "trigger": "onChange",
                    "exec": [
                        {
                            "cmd": "template",
                            "params": {
                                "tpl": "{% FIELD.value.data.adr_town %}"
                            }
                        }
                    ]
                }
            ]
        }
    },
    "editMode": 0
}
invoice_state_code
Bundesland (Code) (R)
TEXT (15)
R
yes
i18n_string
"ecs.ORDER.invoice_state_code"
table
[ "eos_order" ]
fieldset
"inv_addr"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "cssLayout": "col-6",
    "type": "eosdropdown",
    "options": {
        "dataStreamCall": {
            "method": "state_getlist"
        },
        "serverSideSearch": false,
        "optValueField": "terr_code",
        "optNameField": "terr_name",
        "optExtraField": "terr_code",
        "observer": {
            "fields": [
                {
                    "field": "invoice_addr_preset",
                    "trigger": "onChange",
                    "exec": [
                        {
                            "cmd": "template",
                            "params": {
                                "tpl": "{%FIELD.value.data.adr_state_code%}"
                            }
                        }
                    ]
                },
                {
                    "field": "invoice_country",
                    "trigger": "onInit",
                    "exec": [
                        {
                            "cmd": "loadOptions",
                            "params": {
                                "dataStreamCall": {
                                    "method": "state_getlist",
                                    "params": {
                                        "filter": {
                                            "state_country": "{%FIELD.value%}"
                                        }
                                    }
                                }
                            }
                        }
                    ]
                },
                {
                    "field": "invoice_country",
                    "trigger": "onChange",
                    "exec": [
                        {
                            "cmd": "loadOptions",
                            "params": {
                                "dataStreamCall": {
                                    "method": "state_getlist",
                                    "params": {
                                        "filter": {
                                            "state_country": "{%FIELD.value%}"
                                        }
                                    }
                                }
                            }
                        }
                    ]
                }
            ]
        }
    },
    "editMode": 0
}
invoice_countrycountry.cy_iso
Land (R)
TEXT (2)
R
no
i18n_string
"ecs.ORDER.invoice_country"
table
[ "eos_order" ]
fieldset
"inv_addr"
listCfg
{
    "viewMode": 0,
    "formatter": {
        "type": "country-flag"
    },
    "fullSearch": false
}
formCfg
{
    "cssLayout": "col-6",
    "options": {
        "observer": {
            "fields": [
                {
                    "field": "invoice_addr_preset",
                    "trigger": "onChange",
                    "exec": [
                        {
                            "cmd": "template",
                            "params": {
                                "tpl": "{% FIELD.value.data.adr_country %}"
                            }
                        }
                    ]
                }
            ]
        }
    },
    "editMode": 0
}
invoice_type
Rechnungsart
TEXT
R
yes
enum
[ "noncommercial", "commercial" ]
i18n_string
"ecs.ORDER.invoice_type"
table
[ "eos_order" ]
fieldset
"inv_extra"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "cssLayout": "col-4",
    "type": "eosdropdown",
    "options": {
        "optI18nValuePrefix": "ecs.invoice_type",
        "optI18nName": true,
        "data": {
            "options": [
                {
                    "value": "noncommercial"
                },
                {
                    "value": "commercial"
                }
            ]
        }
    },
    "editMode": 0
}
invoice_email
E-Mail (R)
TEXT
R
no
i18n_string
"ecs.ORDER.invoice_email"
table
[ "eos_order" ]
fieldset
"inv_extra"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "cssLayout": "col-4",
    "editMode": 0
}
invoice_taxidentnumber
USt.ID-Nr.
TEXT
R
no
i18n_string
"ecs.ORDER.invoice_taxidentnumber"
table
[ "eos_order" ]
fieldset
"inv_extra"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "cssLayout": "col-4",
    "editMode": 0
}
invoice_taxident_status
USt.ID-Nr. Status
TEXT
R
yes
enum
[ "invalid", "valid_conditional", "valid_confirmed" ]
i18n_string
"ecs.ORDER.invoice_taxident_status"
table
[ "eos_order" ]
fieldset
"inv_extra"
listCfg
{
    "viewMode": 0,
    "formatter": {
        "type": "status"
    },
    "fullSearch": false
}
formCfg
{
    "type": "eosdropdown",
    "options": {
        "optI18nValuePrefix": "ecs.taxident_status",
        "optI18nName": true,
        "data": {
            "options": [
                {
                    "value": null
                },
                {
                    "value": "invalid"
                },
                {
                    "value": "valid_conditional"
                },
                {
                    "value": "valid_confirmed"
                }
            ]
        }
    },
    "editMode": 0
}
invoice_third_country_export
Ausfuhrbescheinigung
TEXT
R
yes
enum
[ "none", "certificate_promised", "certificate_received" ]
i18n_string
"ecs.ORDER.invoice_third_country_export"
table
[ "eos_order" ]
fieldset
"inv_extra"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "eosdropdown",
    "options": {
        "optI18nValuePrefix": "ecs.invoice_third_country_export",
        "optI18nName": true,
        "data": {
            "options": [
                {
                    "value": "none"
                },
                {
                    "value": "certificate_promised"
                },
                {
                    "value": "certificate_received"
                }
            ]
        }
    },
    "editMode": 0
}
invoice_lang_iso
Rechnungssprache
TEXT (2)
R
no
input_translated
Geben Sie den Sprache der Rechnung als ISO-Code (z.B. DE, EN) an.
i18n_string
"ecs.ORDER.invoice_lang_iso"
table
[ "eos_order" ]
fieldset
"inv_extra"
listCfg
{
    "viewMode": 0,
    "formatter": {
        "type": "country-flag"
    },
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
drvd_invoice_street_housenr
Straße+Nr (R)
TEXT
R
no
i18n_string
"ecs.ORDER.drvd_invoice_street_housenr"
table
[ "eos_order" ]
drvd_select
CONCAT_WS("",eos_order.invoice_street," ",eos_order.invoice_housenr)
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
deliver_addr_preset
Adressbuch (L)
DATA
R
yes
i18n_string
"ecs.ORDER.deliver_addr_preset"
table
[ "eos_order" ]
drvd_select
NULL
fieldset
"dlv_addr"
listCfg
{
    "viewMode": 3,
    "fullSearch": false
}
formCfg
{
    "cssLayout": "col-12",
    "type": "eosdropdown",
    "options": {
        "serverSideSearch": false,
        "valueType": "object",
        "optNameTemplate": "{%adr_lastname%}, {%adr_firstname%} ({%adr_company%})",
        "optSubTitleTemplate": "{%adr_extra1%} {%adr_street%} {%adr_housenr%}, {%adr_zip%} {%adr_town%} - {%adr_country%}",
        "optExtraTemplate": "{%adr_ref_type%}",
        "optDataLoad": [
            "adr_gender"
        ],
        "observer": {
            "fields": [
                {
                    "field": "fk_o_persid",
                    "trigger": "onInit",
                    "exec": [
                        {
                            "cmd": "loadOptions",
                            "params": {
                                "dataStreamCall": {
                                    "method": "paddress_getlist",
                                    "params": {
                                        "filter": {
                                            "adr_ref_id": "{%FIELD.value%}"
                                        }
                                    }
                                }
                            }
                        }
                    ]
                },
                {
                    "field": "fk_o_persid",
                    "trigger": "onChange",
                    "exec": [
                        {
                            "cmd": "loadOptions",
                            "params": {
                                "dataStreamCall": {
                                    "method": "paddress_getlist",
                                    "params": {
                                        "filter": {
                                            "adr_ref_id": "{%FIELD.value%}"
                                        }
                                    }
                                }
                            }
                        }
                    ]
                }
            ]
        }
    },
    "editMode": 0
}
deliver_gender
Anrede (L)
TEXT
R
yes
enum
[ "female", "male", "company", "divers" ]
i18n_string
"ecs.ORDER.deliver_gender"
table
[ "eos_order" ]
fieldset
"dlv_addr"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
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"
                }
            ]
        },
        "observer": {
            "fields": [
                {
                    "field": "deliver_addr_preset",
                    "trigger": "onChange",
                    "exec": [
                        {
                            "cmd": "template",
                            "params": {
                                "tpl": "{% FIELD.value.data.adr_gender %}"
                            }
                        }
                    ]
                }
            ]
        }
    },
    "editMode": 0
}
deliver_title
Titel (L)
TEXT
R
no
i18n_string
"ecs.ORDER.deliver_title"
table
[ "eos_order" ]
fieldset
"dlv_addr"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "cssLayout": "col-6 col-xl-2",
    "options": {
        "observer": {
            "fields": [
                {
                    "field": "deliver_addr_preset",
                    "trigger": "onChange",
                    "exec": [
                        {
                            "cmd": "template",
                            "params": {
                                "tpl": "{%FIELD.value.data.adr_title%}"
                            }
                        }
                    ]
                }
            ]
        }
    },
    "editMode": 0
}
deliver_firstname
Vorname (L)
TEXT
R
no
i18n_string
"ecs.ORDER.deliver_firstname"
table
[ "eos_order" ]
fieldset
"dlv_addr"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "cssLayout": "col-6 col-xl-4",
    "options": {
        "observer": {
            "fields": [
                {
                    "field": "deliver_addr_preset",
                    "trigger": "onChange",
                    "exec": [
                        {
                            "cmd": "template",
                            "params": {
                                "tpl": "{%FIELD.value.data.adr_firstname%}"
                            }
                        }
                    ]
                }
            ]
        }
    },
    "editMode": 0
}
deliver_lastname
Nachname (L)
TEXT
R
no
i18n_string
"ecs.ORDER.deliver_lastname"
table
[ "eos_order" ]
fieldset
"dlv_addr"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "cssLayout": "col-6 col-xl-4",
    "options": {
        "observer": {
            "fields": [
                {
                    "field": "deliver_addr_preset",
                    "trigger": "onChange",
                    "exec": [
                        {
                            "cmd": "template",
                            "params": {
                                "tpl": "{%FIELD.value.data.adr_lastname%}"
                            }
                        }
                    ]
                }
            ]
        }
    },
    "editMode": 0
}
deliver_company
Firma (L)
TEXT
R
no
i18n_string
"ecs.ORDER.deliver_company"
table
[ "eos_order" ]
fieldset
"dlv_addr"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "cssLayout": "col-6",
    "options": {
        "observer": {
            "fields": [
                {
                    "field": "deliver_addr_preset",
                    "trigger": "onChange",
                    "exec": [
                        {
                            "cmd": "template",
                            "params": {
                                "tpl": "{%FIELD.value.data.adr_company%}"
                            }
                        }
                    ]
                }
            ]
        }
    },
    "editMode": 0
}
deliver_addrextra
Adressenzusatz
TEXT
R
no
i18n_string
"ecs.ORDER.deliver_addrextra"
table
[ "eos_order" ]
fieldset
"dlv_addr"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "cssLayout": "col-6",
    "options": {
        "observer": {
            "fields": [
                {
                    "field": "deliver_addr_preset",
                    "trigger": "onChange",
                    "exec": [
                        {
                            "cmd": "template",
                            "params": {
                                "tpl": "{%FIELD.value.data.adr_extra1%}"
                            }
                        }
                    ]
                }
            ]
        }
    },
    "editMode": 0
}
deliver_street
Straße (L)
TEXT
R
no
i18n_string
"ecs.ORDER.deliver_street"
table
[ "eos_order" ]
fieldset
"dlv_addr"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "cssLayout": "col-9",
    "options": {
        "observer": {
            "fields": [
                {
                    "field": "deliver_addr_preset",
                    "trigger": "onChange",
                    "exec": [
                        {
                            "cmd": "template",
                            "params": {
                                "tpl": "{%FIELD.value.data.adr_street%}"
                            }
                        }
                    ]
                }
            ]
        }
    },
    "editMode": 0
}
deliver_housenr
Hausnummer (L)
TEXT
R
no
i18n_string
"ecs.ORDER.deliver_housenr"
table
[ "eos_order" ]
fieldset
"dlv_addr"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "cssLayout": "col-3",
    "options": {
        "observer": {
            "fields": [
                {
                    "field": "deliver_addr_preset",
                    "trigger": "onChange",
                    "exec": [
                        {
                            "cmd": "template",
                            "params": {
                                "tpl": "{%FIELD.value.data.adr_housenr%}"
                            }
                        }
                    ]
                }
            ]
        }
    },
    "editMode": 0
}
deliver_zip
PLZ (L)
TEXT
R
no
i18n_string
"ecs.ORDER.deliver_zip"
table
[ "eos_order" ]
fieldset
"dlv_addr"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "cssLayout": "col-4",
    "options": {
        "observer": {
            "fields": [
                {
                    "field": "deliver_addr_preset",
                    "trigger": "onChange",
                    "exec": [
                        {
                            "cmd": "template",
                            "params": {
                                "tpl": "{%FIELD.value.data.adr_zip%}"
                            }
                        }
                    ]
                }
            ]
        }
    },
    "editMode": 0
}
deliver_town
Ort (L)
TEXT
R
no
i18n_string
"ecs.ORDER.deliver_town"
table
[ "eos_order" ]
fieldset
"dlv_addr"
listCfg
{
    "full_search": true,
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "cssLayout": "col-8",
    "options": {
        "observer": {
            "fields": [
                {
                    "field": "deliver_addr_preset",
                    "trigger": "onChange",
                    "exec": [
                        {
                            "cmd": "template",
                            "params": {
                                "tpl": "{%FIELD.value.data.adr_town%}"
                            }
                        }
                    ]
                }
            ]
        }
    },
    "editMode": 0
}
deliver_state_code
Bundesland (Code) (L)
TEXT (15)
R
yes
i18n_string
"ecs.ORDER.deliver_state_code"
table
[ "eos_order" ]
fieldset
"dlv_addr"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "cssLayout": "col-6",
    "type": "eosdropdown",
    "options": {
        "dataStreamCall": {
            "method": "state_getlist"
        },
        "serverSideSearch": false,
        "optValueField": "terr_code",
        "optNameField": "terr_name",
        "optExtraField": "terr_code",
        "observer": {
            "fields": [
                {
                    "field": "deliver_addr_preset",
                    "trigger": "onChange",
                    "exec": [
                        {
                            "cmd": "template",
                            "params": {
                                "tpl": "{%FIELD.value.data.adr_state_code%}"
                            }
                        }
                    ]
                },
                {
                    "field": "deliver_country",
                    "trigger": "onInit",
                    "exec": [
                        {
                            "cmd": "loadOptions",
                            "params": {
                                "dataStreamCall": {
                                    "method": "state_getlist",
                                    "params": {
                                        "filter": {
                                            "state_country": "{%FIELD.value%}"
                                        }
                                    }
                                }
                            }
                        }
                    ]
                },
                {
                    "field": "deliver_country",
                    "trigger": "onChange",
                    "exec": [
                        {
                            "cmd": "loadOptions",
                            "params": {
                                "dataStreamCall": {
                                    "method": "state_getlist",
                                    "params": {
                                        "filter": {
                                            "state_country": "{%FIELD.value%}"
                                        }
                                    }
                                }
                            }
                        }
                    ]
                }
            ]
        }
    },
    "editMode": 0
}
deliver_countrycountry.cy_iso
Land (L)
TEXT (2)
R
no
i18n_string
"ecs.ORDER.deliver_country"
table
[ "eos_order" ]
fieldset
"dlv_addr"
listCfg
{
    "viewMode": 0,
    "formatter": {
        "type": "country-flag"
    },
    "fullSearch": false
}
formCfg
{
    "cssLayout": "col-6",
    "options": {
        "observer": {
            "fields": [
                {
                    "field": "deliver_addr_preset",
                    "trigger": "onChange",
                    "exec": [
                        {
                            "cmd": "template",
                            "params": {
                                "tpl": "{%FIELD.value.data.adr_country%}"
                            }
                        }
                    ]
                }
            ]
        }
    },
    "editMode": 0
}
deliver_date_req
Kunden-Wunschtermin
TEXT
R
no
i18n_string
"ecs.ORDER.deliver_date_req"
table
[ "eos_order" ]
fieldset
"dlv_extra"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
deliver_phone
Telefon
TEXT
R
no
i18n_string
"ecs.ORDER.deliver_phone"
table
[ "eos_order" ]
fieldset
"dlv_extra"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
deliver_email
E-Mail (L)
TEXT
R
no
i18n_string
"ecs.ORDER.deliver_email"
table
[ "eos_order" ]
fieldset
"dlv_extra"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
deliver_comment
Liefer-Hinweise
TEXT
R
no
input_translated
Geben Sie hier einen Lieferhinweis für den Lieferanten ein.
i18n_string
"ecs.ORDER.deliver_comment"
table
[ "eos_order" ]
fieldset
"dlv_extra"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
drvd_deliver_street_housenr
Straße+Nr (L)
TEXT
R
no
i18n_string
"ecs.ORDER.drvd_deliver_street_housenr"
table
[ "eos_order" ]
drvd_select
CONCAT_WS("",eos_order.deliver_street," ",eos_order.deliver_housenr)
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
deliver_notes_xdata
Lieferhinweise
DATA
R
yes
i18n_string
"ecs.ORDER.deliver_notes_xdata"
table
[ "eos_order" ]
fieldset
"dlv_extra"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "cssLayout": "col-12",
    "type": "aceeditor",
    "options": {
        "mode": "json"
    },
    "editMode": 0
}
ip_address
IP-Adresse
TEXT
R
yes
i18n_string
"ecs.ORDER.ip_address"
table
[ "eos_order" ]
fieldset
"sys_record"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
o_referrer
Referrer
TEXT
R
yes
i18n_string
"ecs.ORDER.o_referrer"
table
[ "eos_order" ]
fieldset
"sys_record"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
o_useragent
User-Agent
TEXT
R
yes
i18n_string
"ecs.ORDER.o_useragent"
table
[ "eos_order" ]
fieldset
"sys_record"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
o_comment
Kundenkommentar
TEXT
R
yes
input_translated
Geben Sie hier einen Kommentar zum Auftrag ein.
i18n_string
"ecs.ORDER.o_comment"
table
[ "eos_order" ]
fieldset
"extra"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "textarea",
    "editMode": 0
}
o_comment_internal
Interner Bestellhinweis
TEXT
R
yes
input_translated
Vergeben Sie hier einen internen Kommentar, z.B. für andere Auftragsbearbeiter.
i18n_string
"ecs.ORDER.o_comment_internal"
table
[ "eos_order" ]
fieldset
"extra"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "textarea",
    "editMode": 0
}
o_lock_time
Bearbeitungs-Sperre (Zeitpunkt)
DATETIME
R
yes
i18n_string
"ecs.ORDER.o_lock_time"
table
[ "eos_order" ]
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
o_lock_user
Bearbeitungs-Sperre (Benutzer)
TEXT (31)
R
yes
i18n_string
"ecs.ORDER.o_lock_user"
table
[ "eos_order" ]
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
o_insert_time
Angelegt am
DATETIME
R
no
i18n_string
"insert_time"
table
[ "eos_order" ]
fieldset
"sys_record"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
o_update_time
Geändert am
DATETIME
R
yes
i18n_string
"update_time"
table
[ "eos_order" ]
fieldset
"sys_record"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
o_insert_user
Ersteller
TEXT (127)
R
yes
i18n_string
"insert_user"
table
[ "eos_order" ]
fieldset
"sys_record"
listCfg
{
    "formatter": {
        "type": "user"
    },
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
o_update_user
Letzte Änderung durch
TEXT (127)
R
yes
i18n_string
"update_user"
table
[ "eos_order" ]
fieldset
"sys_record"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
fk_o_campidcampaign.campid
Kampagne
INT (11)
R
no
input_translated
Wählen Sie eine Kampagne aus, zu der dieser Auftrag zugeordnet werden soll.
i18n_string
"ecs.ORDER.fk_o_campid"
table
[ "eos_order" ]
fieldset
"marketing"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "cssLayout": "col-6",
    "editMode": 0
}
drvd_o_shoplabel
Shop
TEXT
R
no
i18n_string
"ecs.ORDER.drvd_o_shoplabel"
table
[ "eos_order" ]
drvd_select
eos_order.fk_o_shopid
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
drvd_invoice_address
Auftrag-Rg.Adresse
TEXT
R
no
i18n_string
"ecs.ORDER.drvd_invoice_address"
table
[ "eos_order" ]
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,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
drvd_deliver_address
Auftrag-Lfg.Adresse
TEXT
R
no
i18n_string
"ecs.ORDER.drvd_deliver_address"
table
[ "eos_order" ]
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,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
o_pay_profile_xdata
Zahlungsziel-Daten
DATA
R
yes
i18n_string
"ecs.ORDER.o_pay_profile_xdata"
table
[ "eos_order" ]
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "cssLayout": "col-12",
    "type": "aceeditor",
    "options": {
        "mode": "json"
    },
    "editMode": 0
}
drvd_o_omsg_cnt
INT (11)
R
yes
i18n_string
"ecs.ORDER.drvd_o_omsg_cnt"
table
[ "ecs_order_message" ]
drvd_select
COUNT(ecs_order_message.omsg_id)
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
drvd_o_omsg_time_last
DATETIME (11)
R
yes
i18n_string
"ecs.ORDER.drvd_o_omsg_time_last"
table
[ "ecs_order_message" ]
drvd_select
MAX(ecs_order_message.omsg_insert_time)
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
fk_o_companyaccount_subaccount_persidcompanysubaccount.persid
Unteraccount
INT (11)
R
yes
i18n_string
"ecs.plugin_companyaccount.fk_o_companyaccount_subaccount_persid"
table
[ "eos_order" ]
fieldset
"extra"
listCfg
{
    "viewMode": 3,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
fk_o_mrch_idmerchant.mrch_id
Verkaufender Anbieter
INT (11)
R
yes
i18n_string
"ecs.ORDER.fk_o_mrch_id"
table
[ "eos_order" ]
fieldset
"extra"
listCfg
{
    "viewMode": 3,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
fk_o_parent_oidorder.oid
Hauptauftrag
INT (11)
R
yes
i18n_string
"ecs.ORDER.fk_o_parent_oid"
table
[ "eos_order" ]
fieldset
"extra"
listCfg
{
    "viewMode": 3,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
drvd_parent_orderid
Haupt­auftrag
TEXT
R
yes
i18n_string
"ecs.ORDER.drvd_parent_orderid"
table
[ "parent_order" ]
drvd_select
parent_order.orderid
listCfg
{
    "viewMode": 0,
    "fullSearch": false,
    "formatter": {
        "type": "model-primary",
        "params": {
            "model": "order",
            "primaryKey": "fk_o_parent_oid"
        }
    }
}
formCfg
{
    "editMode": 0
}
o_merchant_xdata
Anbieter (Zusatzdaten)
DATA
R
yes
i18n_string
"ecs.ORDER.o_merchant_xdata"
table
[ "eos_order" ]
fieldset
"extra"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "cssLayout": "col-12",
    "type": "aceeditor",
    "options": {
        "mode": "json"
    },
    "editMode": 0
}
o_periodic_time_first
Abo-Startdatum
DATETIME
R
yes
i18n_string
"ecs.ORDER.o_periodic_time_first"
table
[ "eos_order" ]
fieldset
"time_settings"
listCfg
{
    "viewMode": 3,
    "fullSearch": false
}
formCfg
{
    "type": "datetimepicker",
    "cssLayout": "col-12 col-md-6 col-xl-6",
    "editMode": 0
}
o_periodic_time_last
Abo-Enddatum
DATETIME
R
yes
i18n_string
"ecs.ORDER.o_periodic_time_last"
table
[ "eos_order" ]
fieldset
"time_settings"
listCfg
{
    "viewMode": 3,
    "fullSearch": false
}
formCfg
{
    "type": "datetimepicker",
    "cssLayout": "col-12 col-md-6 col-xl-6",
    "editMode": 0
}
o_periodic_time_next
Nächste Abo-Ausführung
DATETIME
R
yes
i18n_string
"ecs.ORDER.o_periodic_time_next"
table
[ "eos_order" ]
fieldset
"time_settings"
listCfg
{
    "viewMode": 3,
    "fullSearch": false
}
formCfg
{
    "editMode": 0,
    "cssLayout": "col-12 col-md-6 col-xl-6"
}
o_periodic_timeorder_offset
Abweichendes Auftragsdatum
TEXT (31)
R
no
i18n_string
"ecs.ORDER.o_periodic_timeorder_offset"
table
[ "eos_order" ]
fieldset
"time_settings"
listCfg
{
    "viewMode": 3,
    "formatter": {
        "type": "cron"
    },
    "fullSearch": false
}
formCfg
{
    "cssLayout": "col-12 col-md-6 col-xl-6",
    "editMode": 0
}
o_periodic_time_strict
Strikt
INT (1)
R
no
i18n_string
"ecs.ORDER.o_periodic_time_strict"
table
[ "eos_order" ]
fieldset
"time_settings"
listCfg
{
    "viewMode": 3,
    "formatter": {
        "type": "active-flag"
    },
    "fullSearch": false
}
formCfg
{
    "type": "checkbox",
    "value": 1,
    "editMode": 0
}
o_periodic_exec_period
Abo-Intervall
TEXT (31)
R
no
i18n_string
"ecs.ORDER.o_periodic_exec_period"
table
[ "eos_order" ]
fieldset
"time_settings"
listCfg
{
    "viewMode": 3,
    "formatter": {
        "type": "cron"
    },
    "fullSearch": false
}
formCfg
{
    "type": "hfycron",
    "editMode": 0
}
o_periodic_exec_inprogress
Wird gerade ausgeführt
INT (1)
R
no
i18n_string
"ecs.ORDER.o_periodic_exec_inprogress"
table
[ "eos_order" ]
listCfg
{
    "viewMode": 3,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
o_periodic_xdata
DATA
R
yes
i18n_string
"ecs.ORDER.o_periodic_xdata"
table
[ "eos_order" ]
fieldset
"time_settings_xdata"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
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"
                                            }
                                        ]
                                    }
                                ]
                            }
                        ]
                    }
                }
            }
        }
    },
    "editMode": 0
}
drvd_weekday_timeordered
Wochen­tag
TEXT
R
no
i18n_string
"ecs.ORDER.drvd_weekday_timeordered"
table
[ "eos_order" ]
drvd_select
DATE_FORMAT(eos_order.o_time_ordered, '%a')
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
drvd_hour_timeordered
Stunde
TEXT
R
no
i18n_string
"ecs.ORDER.drvd_hour_timeordered"
table
[ "eos_order" ]
drvd_select
DATE_FORMAT(eos_order.o_time_ordered, '%H')
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
drvd_month_timeordered
Bestell­monat
TEXT
R
no
i18n_string
"ecs.ORDER.drvd_month_timeordered"
table
[ "eos_order" ]
drvd_select
DATE_FORMAT(eos_order.o_time_ordered, '%m')
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
drvd_dayofmonth_timeordered
Bestelltag im Monat
TEXT
R
no
i18n_string
"ecs.ORDER.drvd_dayofmonth_timeordered"
table
[ "eos_order" ]
drvd_select
DATE_FORMAT(eos_order.o_time_ordered, '%d')
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
drvd_timeonly_timeordered
Bestellzeit
TEXT
R
no
i18n_string
"ecs.ORDER.drvd_timeonly_timeordered"
table
[ "eos_order" ]
drvd_select
DATE_FORMAT(eos_order.o_time_ordered, '%H:%i')
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
drvd_cluster_seq
Erst-/Wiederkauf
TEXT
R
no
i18n_string
"ecs.ORDER.drvd_cluster_seq"
table
[ "eos_order" ]
drvd_select
IF(eos_order.o_pers_seq_nr > 1,"Wiederkauf","Erstkauf")
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
shipping_type_label
Versandart
TEXT (63)
R
no
i18n_string
"ecs.ORDER.shipping_type_label"
table
[ "eos_shipping_types" ]
drvd_select
eos_shipping_types.st_label
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
shipping_type_grp_name
Versandart-Gruppe
TEXT (63)
R
no
i18n_string
"ecs.ORDER.shipping_type_grp_name"
table
[ "eos_shipping_types" ]
drvd_select
eos_shipping_types.st_grp_name
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
shipping_type_deliver_category
Lieferkategorie
TEXT (31)
R
no
i18n_string
"ecs.ORDER.shipping_type_deliver_category"
table
[ "eos_shipping_types" ]
drvd_select
eos_shipping_types.st_deliver_category
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
drvd_inv_cy_name
Rechnungsland
TEXT
R
no
i18n_string
"ecs.ORDER.drvd_inv_cy_name"
table
[ "inv_country" ]
drvd_select
inv_country.cy_name
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
drvd_inv_cy_nameshort
Rechnungsland Kurzname
TEXT
R
no
i18n_string
"ecs.ORDER.drvd_inv_cy_nameshort"
table
[ "inv_country" ]
drvd_select
inv_country.cy_nameshort
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
drvd_del_cy_name
Lieferland
TEXT
R
no
i18n_string
"ecs.ORDER.drvd_del_cy_name"
table
[ "del_country" ]
drvd_select
del_country.cy_name
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
drvd_del_cy_nameshort
Lieferland Kurzname
TEXT
R
no
i18n_string
"ecs.ORDER.drvd_del_cy_nameshort"
table
[ "del_country" ]
drvd_select
del_country.cy_nameshort
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
drvd_invoice_state_name
Bundesland (R)
TEXT
R
no
i18n_string
"ecs.ORDER.drvd_invoice_state_name"
table
[ "invoice_terr_state" ]
drvd_select
invoice_terr_state.terr_name
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
drvd_invoice_state_path
Bundesland (Pfad) (R)
TEXT
R
no
i18n_string
"ecs.ORDER.drvd_invoice_state_path"
table
[ "invoice_terr_state" ]
drvd_select
invoice_terr_state.i18n_node_path_DE
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
drvd_deliver_state_name
Bundesland (L)
TEXT
R
no
i18n_string
"ecs.ORDER.drvd_deliver_state_name"
table
[ "deliver_terr_state" ]
drvd_select
deliver_terr_state.terr_name
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
drvd_deliver_state_path
Bundesland (Pfad) (L)
TEXT
R
no
i18n_string
"ecs.ORDER.drvd_deliver_state_path"
table
[ "deliver_terr_state" ]
drvd_select
deliver_terr_state.i18n_node_path_DE
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}

campaign

Following fields can also be selected for reading (JOIN)

campaign_name
Kampagne
TEXT (127)
R
no
i18n_string
"ecs.ORDER.campaign_name"
table
[ "eos_campaign" ]
drvd_select
eos_campaign.camp_name
listCfg
{
    "full_search": true,
    "viewMode": 3,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
campid auto increment
INT (11)
R
no
i18n_string
"ecs.CAMPAIGN.campid"
table
[ "eos_campaign" ]
drvd_select
eos_campaign.campid
fieldset
"base"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "hidden",
    "editMode": 0
}
fk_camp_shopidshopconfig.eshopid
Shop
INT (11)
R
yes
i18n_string
"ecs.CAMPAIGN.fk_camp_shopid"
table
[ "eos_campaign" ]
drvd_select
eos_campaign.fk_camp_shopid
fieldset
"base"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
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" ]
drvd_select
eos_campaign.camp_name
fieldset
"base"
listCfg
{
    "formatter": {
        "type": "model-primary",
        "params": {
            "model": "campaign",
            "primaryKey": "campid",
            "iconLabel": "ecs\/campaign.model",
            "iconColorField": "camp_color"
        }
    },
    "viewMode": 0,
    "depends_on": "fk_o_campid",
    "fullSearch": false
}
formCfg
{
    "mandatory": true,
    "editMode": 0
}
camp_short_desc
Kurzbeschreibung
TEXT (127)
R
yes
i18n_string
"ecs.CAMPAIGN.camp_short_desc"
table
[ "eos_campaign" ]
drvd_select
eos_campaign.camp_short_desc
fieldset
"base"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
camp_objective
Zielsetzung
TEXT (65536)
R
yes
i18n_string
"ecs.CAMPAIGN.camp_objective"
table
[ "eos_campaign" ]
drvd_select
eos_campaign.camp_objective
fieldset
"goals"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
camp_desc
Beschreibung
TEXT
R
yes
i18n_string
"ecs.CAMPAIGN.camp_desc"
table
[ "eos_campaign" ]
drvd_select
eos_campaign.camp_desc
fieldset
"extra"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
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" ]
drvd_select
eos_campaign.camp_active
fieldset
"base"
listCfg
{
    "formatter": {
        "type": "active-flag"
    },
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "checkbox",
    "editMode": 0
}
camp_color
Farbcode
TEXT (31)
R
yes
i18n_string
"ecs.CAMPAIGN.camp_color"
table
[ "eos_campaign" ]
drvd_select
eos_campaign.camp_color
fieldset
"analytics"
listCfg
{
    "viewMode": 3,
    "formatter": {
        "type": "color-code"
    },
    "fullSearch": false
}
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" ]
drvd_select
eos_campaign.camp_time_start
fieldset
"planning"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
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" ]
drvd_select
eos_campaign.camp_time_end
fieldset
"planning"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
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" ]
drvd_select
eos_campaign.camp_urlvarvalue
fieldset
"analytics"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
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" ]
drvd_select
eos_campaign.camp_source
fieldset
"analytics"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
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" ]
drvd_select
eos_campaign.camp_medium
fieldset
"analytics"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
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" ]
drvd_select
eos_campaign.camp_term
fieldset
"analytics"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
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" ]
drvd_select
eos_campaign.camp_content
fieldset
"analytics"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
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" ]
drvd_select
eos_campaign.camp_campaign
fieldset
"analytics"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
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" ]
drvd_select
eos_campaign.camp_track_interval
fieldset
"tracking"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
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" ]
drvd_select
eos_campaign.camp_trackvars
fieldset
"tracking"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
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" ]
drvd_select
eos_campaign.camp_tracing_javascript
fieldset
"tracking"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
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" ]
drvd_select
eos_campaign.camp_tracing_code
fieldset
"tracking"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}