Model fields

The model consists of the following fields.

Field Name
Display Name
Type
Permissions
Nullable

deliveryitem

dviid primary auto increment
INT (11)
R+W
no
fieldset
"base_record"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "type": "hidden"
}
fk_dvi_diddelivery.did auto increment
Lieferung
INT (11)
R+W
no
fieldset
"base_record"
listCfg
{
    "viewMode": 3
}
formCfg
{
    "cssLayout": "col-6",
    "mandatory": true
}
dvi_pcode primaryDisplay auto increment
Pcode
TEXT (255)
R+W
yes
fieldset
"base"
listCfg
{
    "fullSearch": true
}
formCfg
{
    "cssLayout": "col-3"
}
dvi_name auto increment
Artikelname
TEXT
R+W
yes
fieldset
"base"
listCfg
{
    "fullSearch": true
}
formCfg
{
    "cssLayout": "col-6"
}
dvi_cnt auto increment
Anzahl
FLOAT (13,4)
R+W
no
fieldset
"base"
listCfg
{
    "sumType": "SV"
}
formCfg
{
    "cssLayout": "col-3",
    "type": "eosnumber",
    "options": {
        "decimalsCalculate": 4,
        "decimalshowMin": 0,
        "decimalshowMax": 4
    }
}
dvi_insert_time auto increment
Angelegt am
DATETIME
R+W
no
i18n_string
"insert_time"
fieldset
"sys_record"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "editMode": 2
}
dvi_update_time auto increment
Geändert am
DATETIME
R+W
yes
i18n_string
"update_time"
fieldset
"sys_record"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "editMode": 2
}
dvi_xdata auto increment
Zusatzdaten
DATA
R+W
yes
fieldset
"extra"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "cssLayout": "col-12",
    "type": "aceeditor",
    "options": {
        "mode": "json"
    }
}
dvi_insert_user auto increment
Ersteller
TEXT (127)
R+W
yes
i18n_string
"insert_user"
fieldset
"sys_record"
listCfg
{
    "formatter": {
        "type": "user"
    },
    "viewMode": 0
}
formCfg
{
    "editMode": 2
}
dvi_update_user auto increment
Letzte Änderung durch
TEXT (127)
R+W
yes
i18n_string
"update_user"
fieldset
"sys_record"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "editMode": 2
}
drvd_dv_address auto increment
Lieferadresse
TEXT
R
no
table
[ "ecs_delivery" ]
drvd_select
CONCAT(IF(CHAR_LENGTH(ecs_delivery.dv_name)>0,CONCAT(ecs_delivery.dv_name,CHAR(13)),""),
                                            IF(CHAR_LENGTH(ecs_delivery.dv_name2)>0,CONCAT(ecs_delivery.dv_name2,CHAR(13)),""),
                                            ecs_delivery.dv_street," ",ecs_delivery.dv_hnr,CHAR(13),
                                            ecs_delivery.dv_country," - ",ecs_delivery.dv_zip," ",ecs_delivery.dv_city
                            )
formCfg
{
    "editMode": 0
}
fk_dvi_item_idstorageitem.item_id auto increment
Lagerartikel-ID
INT (11)
R+W
yes
i18n_string
"ecs_plugin_ewarehouse.DELIVERYITEM.fk_dvi_item_id"
listCfg
{
    "viewMode": 0,
    "searchable": 0,
    "sortable": 0
}
formCfg
{
    "editMode": 0
}
dvi_pcode_ext auto increment
Artikel-Nr. (extern):
TEXT
R+W
yes
i18n_string
"ecs_plugin_ewarehouse.DELIVERYITEM.dvi_pcode_ext"
listCfg
{
    "viewMode": 0,
    "searchable": 0,
    "sortable": 0
}
dvi_rsvd_cnt auto increment
Reservierte Artikel
FLOAT (13,4)
R+W
no
i18n_string
"ecs_plugin_ewarehouse.DELIVERYITEM.dvi_rsvd_cnt"
listCfg
{
    "sumType": "SV"
}
formCfg
{
    "editMode": 0
}
dvi_rsvd_confirmed_cnt auto increment
Reserviert (bestätigt)
FLOAT (13,4)
R+W
no
i18n_string
"ecs_plugin_ewarehouse.DELIVERYITEM.dvi_rsvd_confirmed_cnt"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "editMode": 0
}
dvi_cost_single_purchase auto increment
Einzel-Anschaffungskosten
FLOAT (13,2)
R+W
yes
i18n_string
"ecs_plugin_ewarehouse.DELIVERYITEM.dvi_cost_single_purchase"
listCfg
{
    "viewMode": 0
}
node_id auto increment
Lagerort
INT (11)
R
no
i18n_string
"ecs_plugin_ewarehouse.STORAGEITEM.node_id"
table
[ "ewh_nstgrp_item2node", "ewh_nstgrp_nodes" ]
drvd_select
ewh_nstgrp_nodes.node_id
listCfg
{
    "viewMode": 3
}
formCfg
{
    "editMode": 0
}
node_name auto increment
Lagername
TEXT
R
no
i18n_string
"ecs_plugin_ewarehouse.STORAGE.node_name"
table
[ "ewh_nstgrp_item2node", "ewh_nstgrp_nodes" ]
drvd_select
ewh_nstgrp_nodes.i18n_node_name_DE
listCfg
{
    "viewMode": 0
}
formCfg
{
    "editMode": 0
}
node_path auto increment
Lagerpfad
TEXT
R
no
i18n_string
"ecs_plugin_ewarehouse.STORAGE.node_path"
table
[ "ewh_nstgrp_item2node", "ewh_nstgrp_nodes" ]
drvd_select
ewh_nstgrp_nodes.i18n_node_path_DE
formCfg
{
    "editMode": 0
}
drvd_dvi_cnt_not_reserved auto increment
Nicht reserviert
FLOAT (13,4)
R
no
i18n_string
"ecs_plugin_ewarehouse.DELIVERYITEM.drvd_dvi_cnt_not_reserved"
table
"ecs_deliveryitem"
drvd_select
IF(ecs_deliveryitem.dvi_rsvd_cnt = 0 AND ecs_deliveryitem.fk_dvi_item_id > 0,0,ecs_deliveryitem.dvi_cnt - ecs_deliveryitem.dvi_rsvd_cnt)
listCfg
{
    "sumType": "SV"
}
formCfg
{
    "editMode": 0
}
drvd_dvi_cnt_not_reserved_confirmed auto increment
Nicht reserviert (bestätigt)
FLOAT (13,4)
R
no
i18n_string
"ecs_plugin_ewarehouse.DELIVERYITEM.drvd_dvi_cnt_not_reserved_confirmed"
table
"ecs_deliveryitem"
drvd_select
IF(ecs_deliveryitem.dvi_rsvd_confirmed_cnt = 0 AND ecs_deliveryitem.fk_dvi_item_id > 0,0,ecs_deliveryitem.dvi_cnt - ecs_deliveryitem.dvi_rsvd_confirmed_cnt)
listCfg
{
    "viewMode": 0
}
formCfg
{
    "editMode": 0
}
drvd_si_available auto increment
Verfügbarkeit
INT
R
no
i18n_string
"ecs_plugin_ewarehouse.DELIVERYITEM.drvd_si_available"
table
[ "ewh_nstgrp_item2node", "ewh_nstgrp_nodes" ]
drvd_select
IF(ewh_nstgrp_nodes.s_available = 1 AND ewh_nstgrp_item2node.si_available = 1, 1, 0)
listCfg
{
    "viewMode": 0
}
formCfg
{
    "editMode": 0
}
drvd_si_time_available auto increment
Verfügbarkeitsdatum
INT
R
no
i18n_string
"ecs_plugin_ewarehouse.DELIVERYITEM.drvd_si_time_available"
table
[ "ewh_nstgrp_item2node", "ewh_nstgrp_nodes" ]
drvd_select
IF(ewh_nstgrp_item2node.si_time_available IS NOT NULL,ewh_nstgrp_item2node.si_time_available,ewh_nstgrp_nodes.s_time_available)
listCfg
{
    "viewMode": 0
}
formCfg
{
    "editMode": 0
}
si_cnt_rsvd auto increment
Reservierte Artikel
FLOAT (13,4)
R+W
no
i18n_string
"ecs_plugin_ewarehouse.STORAGEITEM.si_cnt_rsvd"
table
"ewh_nstgrp_item2node"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "editMode": 0
}
si_ean auto increment
EAN/GTIN
TEXT
R+W
yes
input_translated
Die Global Trade Item Number (GTIN) ist eine vergebene Identifikationsnummer, mit der Produkte und Packstücke weltweit eindeutig identifiziert werden können. Sie ersetzt die European Article Number (EAN), die bis 2009 als Globale Artikelidentifikationsnummer diente. Es wird empfohlen im Feld (falls vorhanden) die neuere GTIN anzugeben. Alternativ kann natürlich auch die EAN genutzt werden.
i18n_string
"ecs_plugin_ewarehouse.STORAGEITEM.si_ean"
table
"ewh_nstgrp_item2node"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "editMode": 0
}
si_upc auto increment
UPC
TEXT
R+W
yes
input_translated
Der Universal Product Code (UPC) ist ein Strichcode, durch den Produkte im Einzelhandel gekennzeichnet werden.
i18n_string
"ecs_plugin_ewarehouse.STORAGEITEM.si_upc"
table
"ewh_nstgrp_item2node"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "editMode": 0
}
si_snr auto increment
Seriennummer
TEXT
R+W
yes
i18n_string
"ecs_plugin_ewarehouse.STORAGEITEM.si_snr"
table
"ewh_nstgrp_item2node"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "editMode": 0
}
btch_number auto increment
Chargen-Nr.
TEXT
R+W
yes
i18n_string
"ecs_plugin_ewarehouse.STRGIBATCH.btch_number"
table
[ "ewh_strgi_batch" ]
listCfg
{
    "viewMode": 0
}
formCfg
{
    "editMode": 0
}
si_length auto increment
Länge (cm)
FLOAT (13,4)
R+W
yes
input_translated
Die Breite in Zentimeter (cm).
i18n_string
"ecs_plugin_ewarehouse.STORAGEITEM.si_length"
table
"ewh_nstgrp_item2node"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "editMode": 0
}
si_width auto increment
Tiefe (cm)
FLOAT (13,4)
R+W
yes
input_translated
Die Tiefe in Zentimeter (cm).
i18n_string
"ecs_plugin_ewarehouse.STORAGEITEM.si_width"
table
"ewh_nstgrp_item2node"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "editMode": 0
}
si_height auto increment
Höhe (cm)
FLOAT (13,4)
R+W
yes
input_translated
Die Höhe in Zentimeter (cm).
i18n_string
"ecs_plugin_ewarehouse.STORAGEITEM.si_height"
table
"ewh_nstgrp_item2node"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "editMode": 0
}
si_weight auto increment
Gewicht (kg)
FLOAT (13,4)
R+W
yes
input_translated
Das Gewicht in Kilogramm (Kg).
i18n_string
"ecs_plugin_ewarehouse.STORAGEITEM.si_weight"
table
"ewh_nstgrp_item2node"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "editMode": 0
}
drvd_si_dimension auto increment
Maße (cm)
TEXT
R
yes
i18n_string
"ecs_plugin_ewarehouse.STORAGEITEM.drvd_si_dimension"
table
"ewh_nstgrp_item2node"
drvd_select
CONCAT(si_length,' x ',si_width,' x ',si_height)
listCfg
{
    "viewMode": 0
}
formCfg
{
    "editMode": 0
}
drvd_si_volume auto increment
Volumen
TEXT
R
yes
i18n_string
"ecs_plugin_ewarehouse.STORAGEITEM.drvd_si_volume"
table
"ewh_nstgrp_item2node"
drvd_select
IF(si_length IS NOT NULL && si_width IS NOT NULL && si_height IS NOT NULL, si_length * si_width * si_height, NULL)
listCfg
{
    "viewMode": 0
}
formCfg
{
    "editMode": 0
}

product

Following fields can also be selected for reading (JOIN)

pcode auto increment
Pcode
R
no
drvd_select
dvi_pcode
listCfg
{
    "viewMode": 3
}
formCfg
{
    "editMode": 0
}
xc__active auto increment
Aktiv
INT (1)
R
no
i18n_string
"cdb_record.xc__active"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"cdb_meta"
listCfg
{
    "formatter": {
        "type": "active-flag"
    },
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "checkbox",
    "value": true,
    "editMode": 0
}
xc__searchable auto increment
Suchbar
INT (1)
R
no
i18n_string
"cdb_record.xc__searchable"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"base"
listCfg
{
    "formatter": {
        "type": "active-flag"
    },
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "checkbox",
    "value": true,
    "editMode": 0
}
xc__version auto increment
Version
INT (11)
R
no
i18n_string
"cdb_record.xc__version"
table
[ "excdb_data_ecs_product_de" ]
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
xc__current auto increment
Aktuell
INT (1)
R
no
i18n_string
"cdb_record.xc__current"
table
[ "excdb_data_ecs_product_de" ]
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
xc__insert_user auto increment
Ersteller
TEXT (127)
R
yes
i18n_string
"insert_user"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"sys_record"
listCfg
{
    "formatter": {
        "type": "user"
    },
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
xc__insert_time auto increment
Angelegt am
DATETIME
R
no
i18n_string
"insert_time"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"sys_record"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
xc__valid auto increment
Valide
INT (1)
R
no
i18n_string
"cdb_record.xc__valid"
table
[ "excdb_data_ecs_product_de" ]
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
xc__update_time auto increment
Geändert am
DATETIME
R
yes
i18n_string
"update_time"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"sys_record"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
xc__install_time auto increment
Installiert am
DATETIME
R
no
i18n_string
"plugin_install_time"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"sys_plugin"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
xc__publish_start auto increment
Veröffentlichung (Start)
DATETIME
R
yes
i18n_string
"cdb_record.xc__publish_start"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"cdb_advanced"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "cssLayout": "col-6",
    "editMode": 0
}
xc__publish_end auto increment
Veröffentlichung (Ende)
DATETIME
R
yes
i18n_string
"cdb_record.xc__publish_end"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"cdb_advanced"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "cssLayout": "col-6",
    "editMode": 0
}
xc__update_user auto increment
Letzte Änderung durch
TEXT (127)
R
yes
i18n_string
"update_user"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"sys_record"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
xc__ecms_data auto increment
eCMS-Daten
TEXT
R
yes
i18n_string
"ecs.PRODUCT.xc__ecms_data"
table
[ "excdb_data_ecs_product_de" ]
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
xc__id auto increment
ID
INT (11)
R
no
i18n_string
"cdb_record.xc__id"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"cdb_base"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "HIDDEN",
    "editMode": 0
}
drvd_xc_display auto increment
Titel
TEXT
R
no
i18n_string
"cdb_record.xc__title"
table
[ "excdb_data_ecs_product_de" ]
drvd_select
COALESCE(excdb_data_ecs_product_de.name,excdb_data_ecs_product_de.pcode)
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
drvd_is_master auto increment
Ist Masterprodukt
INT (1)
R
no
i18n_string
"ecs.PRODUCT.drvd_is_master"
table
[ "excdb_data_ecs_product_de" ]
drvd_select
IF(excdb_data_ecs_product_de.pcode = excdb_data_ecs_product_de.master_pcode,1,0)
fieldset
"cdb_base"
listCfg
{
    "formatter": {
        "type": "active-flag"
    },
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
name auto increment
Name
TEXT
R
yes
i18n_string
"ecs.PRODUCT.name"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"cdb_base"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "mandatory": true,
    "editMode": 0
}
master_pcode auto increment
Varianten-Master PCode
TEXT
R
yes
input_translated
Bei Einzelprodukten (ohne Varianten) ist dies gleich dem PCode. Bei Variantenprodukten wird hier der PCode des Hauptprodukts der Variantengruppe eingetragen.
i18n_string
"ecs.PRODUCT.master_pcode"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"cdb_base"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "text",
    "options": {
        "XXXobserver": {
            "fields": [
                {
                    "field": "pcode",
                    "trigger": "onChange",
                    "exec": [
                        {
                            "cmd": "copy"
                        }
                    ]
                }
            ]
        }
    },
    "mandatory": true,
    "editMode": 0
}
prdv_color auto increment
Varianten-Farbe
TEXT
R
yes
i18n_string
"ecs.PRODUCT.prdv_color"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"cdb_base"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "eosdropdown",
    "options": {
        "addTag": true,
        "optValueField": "prdv_color",
        "optNameField": "prdv_color",
        "dataStreamCall": {
            "method": "datahub_generate_reportList",
            "params": {
                "ds_label": "product",
                "field_groupby": [
                    {
                        "field": "prdv_color"
                    }
                ]
            }
        }
    },
    "mandatory": false,
    "editMode": 0
}
prdv_size auto increment
Varianten-Größe
TEXT
R
yes
i18n_string
"ecs.PRODUCT.prdv_size"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"cdb_base"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "eosdropdown",
    "options": {
        "addTag": true,
        "optValueField": "prdv_size",
        "optNameField": "prdv_size",
        "dataStreamCall": {
            "method": "datahub_generate_reportList",
            "params": {
                "ds_label": "product",
                "field_groupby": [
                    {
                        "field": "prdv_size"
                    }
                ]
            }
        }
    },
    "mandatory": false,
    "editMode": 0
}
prdv_other auto increment
Varianten-Ausführung
TEXT
R
yes
i18n_string
"ecs.PRODUCT.prdv_other"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"cdb_base"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "eosdropdown",
    "options": {
        "addTag": true,
        "optValueField": "prdv_other",
        "optNameField": "prdv_other",
        "dataStreamCall": {
            "method": "datahub_generate_reportList",
            "params": {
                "ds_label": "product",
                "field_groupby": [
                    {
                        "field": "prdv_other"
                    }
                ]
            }
        }
    },
    "mandatory": false,
    "editMode": 0
}
prd_comment auto increment
Kommentar
TEXT
R
yes
i18n_string
"ecs.PRODUCT.prd_comment"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"comment"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "textarea",
    "mandatory": false,
    "editMode": 0
}
files_doc auto increment
Produkt-Dateien
DATA
R
yes
i18n_string
"ecs.PRODUCT.files_doc"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"cdb_media"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "eosmedia",
    "options": {
        "uploadDirDefault": "\/products"
    },
    "mandatory": false,
    "editMode": 0
}
pack_amount auto increment
Verpackungs­menge
FLOAT
R
yes
i18n_string
"ecs.PRODUCT.pack_amount"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"packaging"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "eosnumber",
    "mandatory": false,
    "editMode": 0
}
pack_unit auto increment
Verpackungs­einheit
TEXT
R
yes
i18n_string
"ecs.PRODUCT.pack_unit"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"packaging"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "text",
    "mandatory": false,
    "editMode": 0
}
prd_ingr_amount auto increment
Verpackungs­inhalt (Menge)
FLOAT
R
yes
i18n_string
"ecs.PRODUCT.prd_ingr_amount"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"packaging"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "eosnumber",
    "mandatory": false,
    "editMode": 0
}
prd_ingr_unit auto increment
Verpackungs­inhalt (Einheit)
TEXT
R
yes
i18n_string
"ecs.PRODUCT.prd_ingr_unit"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"packaging"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "text",
    "mandatory": false,
    "editMode": 0
}
prd_weight [g] auto increment
Produktgewicht
FLOAT
R
yes
i18n_string
"ecs.PRODUCT.prd_weight"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"dimensions"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "eosnumber",
    "mandatory": false,
    "editMode": 0
}
prd_virtual auto increment
Virtuelles Produkt
TEXT
R
yes
i18n_string
"ecs.PRODUCT.prd_virtual"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"virtual"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "checkbox",
    "mandatory": false,
    "editMode": 0
}
products_replace auto increment
Nachfolge­produkte
DATA
R
yes
input_translated
Produkte durch Drag-and-Drop hinzufügen. Beispielsweise aus der Trefferliste der "Hublify Suche".
i18n_string
"ecs.PRODUCT.products_replace"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"cdb_marketing"
listCfg
{
    "formatter": {
        "type": "sub-data-chip",
        "params": {
            "chipCssClass": "chip"
        }
    },
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "eossubmodel",
    "options": {
        "model": "cdb_record",
        "xDataKey": "r2r_xdata",
        "xDataDialogConfig": {
            "layoutLabel": "submodel_product_r2r_xdata_generic_popup"
        },
        "dataStreamCall": {
            "method": "datahub_generate_reportList",
            "params": {
                "ds_label": "product"
            }
        },
        "optValueField": "xc__id",
        "optNameField": "name"
    },
    "mandatory": false,
    "editMode": 0
}
pcode_manufacturer auto increment
Hersteller-PCode
TEXT
R
yes
i18n_string
"ecs.PRODUCT.pcode_manufacturer"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"cdb_base"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "text",
    "mandatory": false,
    "editMode": 0
}
brand auto increment
Brand
TEXT
R
yes
i18n_string
"ecs.PRODUCT.brand"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"cdb_base"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "mandatory": false,
    "editMode": 0
}
products_upselling auto increment
Upselling-Produkte
DATA
R
yes
input_translated
Produkte durch Drag-and-Drop hinzufügen. Beispielsweise aus der Trefferliste der "Hublify Suche".
i18n_string
"ecs.PRODUCT.products_upselling"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"cdb_marketing"
listCfg
{
    "formatter": {
        "type": "sub-data-chip",
        "params": {
            "chipCssClass": "chip"
        }
    },
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "eossubmodel",
    "options": {
        "model": "cdb_record",
        "xDataKey": "r2r_xdata",
        "xDataDialogConfig": {
            "layoutLabel": "submodel_product_r2r_xdata_generic_popup"
        },
        "dataStreamCall": {
            "method": "datahub_generate_reportList",
            "params": {
                "ds_label": "product"
            }
        },
        "optValueField": "xc__id",
        "optNameField": "name"
    },
    "mandatory": false,
    "editMode": 0
}
orderitem_name auto increment
Auftrags­posten-Name
TEXT
R
yes
i18n_string
"ecs.PRODUCT.orderitem_name"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"proc_order"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "text",
    "mandatory": false,
    "editMode": 0
}
orderitem_text auto increment
Auftrags­posten-Text
TEXT
R
yes
i18n_string
"ecs.PRODUCT.orderitem_text"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"proc_order"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "text",
    "mandatory": false,
    "editMode": 0
}
marketing_name auto increment
Marketing-Name
TEXT
R
yes
i18n_string
"ecs.PRODUCT.marketing_name"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"cdb_marketing"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "mandatory": false,
    "editMode": 0
}
marketing_teaser auto increment
Marketing-Teaser
TEXT
R
yes
i18n_string
"ecs.PRODUCT.marketing_teaser"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"cdb_marketing"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "eoseditor",
    "options": {
        "useCfgPreset": "basic"
    },
    "mandatory": false,
    "editMode": 0
}
marketing_image auto increment
Marketing-Bild
DATA
R
yes
i18n_string
"ecs.PRODUCT.marketing_image"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"cdb_marketing"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "eosmedia",
    "options": {
        "uploadDirDefault": "\/products"
    },
    "mandatory": false,
    "editMode": 0
}
new_product auto increment
Neues Produkt?
TEXT
R
yes
i18n_string
"ecs.PRODUCT.new_product"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"cdb_marketing"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "checkbox",
    "mandatory": false,
    "editMode": 0
}
special_offer_product auto increment
Special-Offer Produkt?
TEXT
R
yes
i18n_string
"ecs.PRODUCT.special_offer_product"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"cdb_marketing"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "checkbox",
    "mandatory": false,
    "editMode": 0
}
plugin auto increment
Plugin
TEXT
R
yes
i18n_string
"ecs.PRODUCT.plugin"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"cdb_advanced"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "mandatory": false,
    "editMode": 0
}
meta_title auto increment
Produkt-Meta-Titel
TEXT
R
yes
i18n_string
"ecs.PRODUCT.meta_title"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"cdb_meta"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "text",
    "mandatory": false,
    "editMode": 0
}
meta_keywords auto increment
Produkt-Meta-Keywords
TEXT
R
yes
i18n_string
"ecs.PRODUCT.meta_keywords"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"cdb_meta"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "text",
    "mandatory": false,
    "editMode": 0
}
meta_description auto increment
Produkt-Meta-Beschreibung
TEXT
R
yes
i18n_string
"ecs.PRODUCT.meta_description"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"cdb_meta"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "textarea",
    "mandatory": false,
    "editMode": 0
}
meta_robots_noindex auto increment
Produkt-Meta-Robots-NoIndex
TEXT
R
yes
i18n_string
"ecs.PRODUCT.meta_robots_noindex"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"cdb_meta"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "checkbox",
    "mandatory": false,
    "editMode": 0
}
meta_robots_nofollow auto increment
Produkt-Meta-Robots-NoFollow
TEXT
R
yes
i18n_string
"ecs.PRODUCT.meta_robots_nofollow"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"cdb_meta"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "checkbox",
    "mandatory": false,
    "editMode": 0
}
marketing_image_background auto increment
Marketing-Hintergrundbild
DATA
R
yes
i18n_string
"ecs.PRODUCT.marketing_image_background"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"cdb_marketing"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "eosmedia",
    "options": {
        "uploadDirDefault": "\/products"
    },
    "mandatory": false,
    "editMode": 0
}
marketing_overlay_html auto increment
Marketing-Overlay-HTML
TEXT
R
yes
i18n_string
"ecs.PRODUCT.marketing_overlay_html"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"cdb_marketing"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "mandatory": false,
    "editMode": 0
}
description_seo auto increment
SEO-Beschreibung
TEXT
R
yes
i18n_string
"ecs.PRODUCT.description_seo"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"cdb_meta"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "eoseditor",
    "mandatory": false,
    "editMode": 0
}
prd_width [mm] auto increment
Produktgröße - Breite
FLOAT
R
yes
i18n_string
"ecs.PRODUCT.prd_width"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"dimensions"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "eosnumber",
    "mandatory": false,
    "editMode": 0
}
prd_height [mm] auto increment
Produktgröße - Höhe
FLOAT
R
yes
i18n_string
"ecs.PRODUCT.prd_height"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"dimensions"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "eosnumber",
    "mandatory": false,
    "editMode": 0
}
prd_depth [mm] auto increment
Produktgröße - Tiefe
FLOAT
R
yes
i18n_string
"ecs.PRODUCT.prd_depth"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"dimensions"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "eosnumber",
    "mandatory": false,
    "editMode": 0
}
prd_rating_avg auto increment
FLOAT
R
yes
i18n_string
"ecs.PRODUCT.prd_rating_avg"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"cdb_base"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "hidden",
    "mandatory": false,
    "editMode": 0
}
prd_rating_cnt auto increment
TEXT
R
yes
i18n_string
"ecs.PRODUCT.prd_rating_cnt"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"cdb_base"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "hidden",
    "mandatory": false,
    "editMode": 0
}
convertable_pack_unit auto increment
DATA
R
yes
i18n_string
"ecs.PRODUCT.convertable_pack_unit"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"packaging"
listCfg
{
    "formatter": {
        "type": "sub-data-chip",
        "params": {
            "chipCssClass": "chip"
        }
    },
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "eossubmodel",
    "options": {
        "model": "cdb_record",
        "xDataKey": "r2r_xdata",
        "xDataDialogConfig": {
            "layoutLabel": "submodel_xdata_json_popup"
        },
        "dataStreamCall": {
            "method": "datahub_generate_reportList",
            "params": {
                "ds_label": "product"
            }
        },
        "optValueField": "xc__id",
        "optNameField": "name"
    },
    "mandatory": false,
    "editMode": 0
}
prd_accounting_cost_center auto increment
Buchhaltung Kostenstelle
TEXT
R
yes
i18n_string
"ecs.PRODUCT.prd_accounting_cost_center"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"proc_accounting"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "eosdropdown",
    "options": {
        "serverSideSearch": true,
        "addTag": true,
        "optValueField": "prd_accounting_cost_center",
        "optNameField": "prd_accounting_cost_center",
        "dataStreamCall": {
            "method": "datahub_generate_reportList",
            "params": {
                "ds_label": "product",
                "field_groupby": [
                    {
                        "field": "prd_accounting_cost_center"
                    }
                ]
            }
        }
    },
    "mandatory": false,
    "editMode": 0
}
prd_accounting_revenue_account auto increment
Buchhaltung Erlöskonto
TEXT
R
yes
i18n_string
"ecs.PRODUCT.prd_accounting_revenue_account"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"proc_accounting"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "eosdropdown",
    "options": {
        "serverSideSearch": true,
        "addTag": true,
        "optValueField": "prd_accounting_revenue_account",
        "optNameField": "prd_accounting_revenue_account",
        "dataStreamCall": {
            "method": "datahub_generate_reportList",
            "params": {
                "ds_label": "product",
                "field_groupby": [
                    {
                        "field": "prd_accounting_revenue_account"
                    }
                ]
            }
        }
    },
    "mandatory": false,
    "editMode": 0
}
base_colorcolor.xc__label auto increment
Grundfarbe
TEXT
R
yes
i18n_string
"ecs.PRODUCT.base_color"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"cdb_base"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "mandatory": false,
    "editMode": 0
}
html_canonical auto increment
TEXT
R
yes
i18n_string
"ecs.PRODUCT.html_canonical"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"cdb_meta"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "checkbox",
    "mandatory": false,
    "editMode": 0
}
pack_size_width [mm] auto increment
Verpackungs­größe - Breite
TEXT
R
yes
i18n_string
"ecs.PRODUCT.pack_size_width"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"packaging"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "mandatory": false,
    "editMode": 0
}
pack_size_height [mm] auto increment
Verpackungs­größe - Höhe
TEXT
R
yes
i18n_string
"ecs.PRODUCT.pack_size_height"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"packaging"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "mandatory": false,
    "editMode": 0
}
pack_size_depth [mm] auto increment
Verpackungs­größe - Tiefe
TEXT
R
yes
i18n_string
"ecs.PRODUCT.pack_size_depth"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"packaging"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "mandatory": false,
    "editMode": 0
}
pack_weight [g] auto increment
Verpackungs­gewicht
FLOAT
R
yes
i18n_string
"ecs.PRODUCT.pack_weight"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"packaging"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "eosnumber",
    "mandatory": false,
    "editMode": 0
}
features auto increment
DATA
R
yes
i18n_string
"ecs.PRODUCT.features"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"cdb_marketing"
listCfg
{
    "formatter": {
        "type": "sub-data-chip",
        "params": {
            "chipCssClass": "chip"
        }
    },
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "eossubmodel",
    "options": {
        "model": "cdb_record",
        "xDataKey": "r2r_xdata",
        "xDataDialogConfig": {
            "layoutLabel": "submodel_xdata_json_popup"
        },
        "dataStreamCall": {
            "method": "datahub_generate_reportList",
            "params": {
                "ds_label": "feature"
            }
        },
        "optValueField": "xc__id",
        "optNameField": "name",
        "optExtraField": "type"
    },
    "mandatory": false,
    "editMode": 0
}
gtin auto increment
GTIN/EAN
TEXT
R
yes
i18n_string
"ecs.PRODUCT.gtin"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"cdb_base"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "text",
    "mandatory": false,
    "editMode": 0
}
ppn auto increment
PPN
TEXT
R
yes
i18n_string
"ecs.PRODUCT.ppn"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"cdb_base"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "text",
    "mandatory": false,
    "editMode": 0
}
origin_country auto increment
Ursprungsland
TEXT
R
yes
i18n_string
"ecs.PRODUCT.origin_country"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"extra"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "mandatory": false,
    "editMode": 0
}
customs_tariff_number auto increment
HS-Tariff-Code
TEXT
R
yes
i18n_string
"ecs.PRODUCT.customs_tariff_number"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"extra"
listCfg
{
    "view_mode": 0,
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "mandatory": false,
    "editMode": 0
}
customs_value_amount auto increment
TEXT
R
yes
i18n_string
"ecs.PRODUCT.customs_value_amount"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"extra"
listCfg
{
    "view_mode": 0,
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "unit": "EUR",
    "type": "eosnumber",
    "options": {
        "decimalsCalculate": 2,
        "decimalshowMin": 2,
        "decimalshowMax": 2
    },
    "mandatory": false,
    "editMode": 0
}
customs_description auto increment
Zoll-Beschreibung
TEXT
R
yes
i18n_string
"ecs.PRODUCT.customs_description"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"extra"
listCfg
{
    "view_mode": 0,
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "mandatory": false,
    "editMode": 0
}
files_download auto increment
Download-Dateien
DATA
R
yes
i18n_string
"ecs.PRODUCT.files_download"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"cdb_media"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "eosmedia",
    "options": {
        "uploadDirDefault": "\/products",
        "xDataDialogConfig": {
            "layoutLabel": "mamasset_2_prd_filesdownload_popup"
        },
        "xDataKey": "a2r_xdata"
    },
    "mandatory": false,
    "editMode": 0
}
products_contain auto increment
Produkte im Bundle
DATA
R
yes
i18n_string
"ecs.PRODUCT.products_contain"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"bundle"
listCfg
{
    "formatter": {
        "type": "sub-data-chip",
        "params": {
            "chipCssClass": "chip"
        }
    },
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "eossubmodel",
    "options": {
        "model": "cdb_record",
        "xDataKey": "r2r_xdata",
        "xDataDialogConfig": {
            "layoutLabel": "submodel_products_contain_popup"
        },
        "dataStreamCall": {
            "method": "datahub_generate_reportList",
            "params": {
                "ds_label": "product"
            }
        },
        "optValueField": "xc__id",
        "optNameField": "name"
    },
    "mandatory": false,
    "editMode": 0
}
prd_keywords auto increment
Keywords
TEXT
R
yes
i18n_string
"ecs.PRODUCT.prd_keywords"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"cdb_advanced"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "mandatory": false,
    "editMode": 0
}
files_img auto increment
Bilder
DATA
R
yes
input_translated
Bilder mit Drag-and-Drop hinzufügen. Entweder aus Hublify Media-Manager oder von eigener Festplatte.
i18n_string
"ecs.PRODUCT.files_img"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"cdb_base_2"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "eosmedia",
    "options": {
        "uploadDirDefault": "\/products"
    },
    "mandatory": false,
    "editMode": 0
}
prd_bundle_price_discount_perc [%] auto increment
Bundle-Preis %-Discount
FLOAT
R
yes
i18n_string
"ecs.PRODUCT.prd_bundle_price_discount_perc"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"bundle"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "mandatory": false,
    "editMode": 0
}
desc_short auto increment
Kurz­beschreibung
TEXT
R
yes
i18n_string
"ecs.PRODUCT.desc_short"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"cdb_base_2"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "eoseditor",
    "options": {
        "useCfgPreset": "basic"
    },
    "mandatory": false,
    "editMode": 0
}
prd_snr_xdata_subtype auto increment
Zusatzdaten-Typ
TEXT
R
yes
i18n_string
"ecs.PRODUCT.prd_snr_xdata_subtype"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"cdb_base_2"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "eosdropdown",
    "options": {
        "serverSideSearch": false,
        "dataStreamCall": {
            "method": "prd_subtypes_getOptions"
        }
    },
    "mandatory": false,
    "editMode": 0
}
prd_bundle_resolve_mode auto increment
Bundle-Modus
TEXT
R
yes
i18n_string
"ecs.PRODUCT.prd_bundle_resolve_mode"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"bundle"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "eosdropdown",
    "options": {
        "optI18nValuePrefix": "ecs.prd_bundle_resolve_mode",
        "optI18nName": true,
        "data": {
            "options": [
                {
                    "value": null
                },
                {
                    "value": "resolve_never"
                },
                {
                    "value": "resolve_order"
                },
                {
                    "value": "resolve_add_childitems"
                }
            ]
        }
    },
    "mandatory": false,
    "editMode": 0
}
desc_tech auto increment
Technische Beschreibung
TEXT
R
yes
i18n_string
"ecs.PRODUCT.desc_tech"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"cdb_base_2"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "mandatory": false,
    "editMode": 0
}
manufacturermanufacturer.xc__label auto increment
Hersteller
TEXT
R
yes
i18n_string
"ecs.PRODUCT.manufacturer"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"cdb_base"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "mandatory": false,
    "editMode": 0
}
xc__label auto increment
TEXT
R
yes
i18n_string
"ecs.PRODUCT.xc__label"
table
[ "excdb_data_ecs_product_de" ]
drvd_select
excdb_data_ecs_product_de.pcode
fieldset
"cdb_base"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "HIDDEN",
    "editMode": 0
}
xc__title auto increment
TEXT
R
yes
i18n_string
"ecs.PRODUCT.xc__title"
table
[ "excdb_data_ecs_product_de" ]
drvd_select
excdb_data_ecs_product_de.name
fieldset
"cdb_base"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "HIDDEN",
    "editMode": 0
}
xc__image auto increment
DATA
R
yes
i18n_string
"ecs.PRODUCT.xc__image"
table
[ "excdb_data_ecs_product_de" ]
drvd_select
excdb_data_ecs_product_de.files_img
fieldset
"cdb_base_2"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "HIDDEN",
    "editMode": 0
}
drvd_variant_specification auto increment
Ausprägung
TEXT
R
no
i18n_string
"ecs.PRODUCT.drvd_variant_specification"
table
[ "excdb_data_ecs_product_de" ]
drvd_select
CONCAT_WS(',',excdb_data_ecs_product_de.prdv_color, excdb_data_ecs_product_de.prdv_size, excdb_data_ecs_product_de.prdv_other)
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}

delivery

Following fields can also be selected for reading (JOIN)

did auto increment
INT (11)
R
no
i18n_string
"ecs.DELIVERY.did"
table
[ "ecs_delivery" ]
fieldset
"base_record"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "hidden",
    "editMode": 0
}
dv_seller_name auto increment
Verkäufername
TEXT
R
no
i18n_string
"ecs.DELIVERY.dv_seller_name"
table
[ "ecs_delivery" ]
fieldset
"seller_addr"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
dv_seller_name2 auto increment
Adressenzusatz
TEXT
R
no
i18n_string
"ecs.DELIVERY.dv_seller_name2"
table
[ "ecs_delivery" ]
fieldset
"seller_addr"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
dv_seller_street auto increment
Straße
TEXT
R
no
i18n_string
"ecs.DELIVERY.dv_seller_street"
table
[ "ecs_delivery" ]
fieldset
"seller_addr"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "cssLayout": "col-9",
    "editMode": 0
}
dv_seller_hnr auto increment
Hausnr.
TEXT
R
no
i18n_string
"ecs.DELIVERY.dv_seller_hnr"
table
[ "ecs_delivery" ]
fieldset
"seller_addr"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "cssLayout": "col-3",
    "editMode": 0
}
dv_seller_zip auto increment
PLZ
TEXT
R
no
i18n_string
"ecs.DELIVERY.dv_seller_zip"
table
[ "ecs_delivery" ]
fieldset
"seller_addr"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "cssLayout": "col-4",
    "editMode": 0
}
dv_seller_city auto increment
Ort
TEXT
R
no
i18n_string
"ecs.DELIVERY.dv_seller_city"
table
[ "ecs_delivery" ]
fieldset
"seller_addr"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "cssLayout": "col-8",
    "editMode": 0
}
dv_seller_state_code auto increment
Bundesland (Code) (Verkäufer)
TEXT (15)
R
yes
i18n_string
"ecs.DELIVERY.dv_seller_state_code"
table
[ "ecs_delivery" ]
fieldset
"seller_addr"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
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%}"
                                        }
                                    }
                                }
                            }
                        }
                    ]
                }
            ]
        }
    },
    "editMode": 0
}
dv_seller_countrycountry.cy_iso auto increment
Land
TEXT (2)
R
no
i18n_string
"ecs.DELIVERY.dv_seller_country"
table
[ "ecs_delivery" ]
fieldset
"seller_addr"
listCfg
{
    "viewMode": 0,
    "width": 64,
    "formatter": {
        "type": "country-flag"
    },
    "fullSearch": false
}
formCfg
{
    "cssLayout": "col-6",
    "editMode": 0
}
dv_code auto increment
Lieferungs-Nr.
TEXT (63)
R
no
i18n_string
"ecs.DELIVERY.dv_code"
table
[ "ecs_delivery" ]
fieldset
"base_record"
listCfg
{
    "fullSearch": false,
    "formatter": {
        "type": "model-primary",
        "params": {
            "model": "delivery",
            "primaryKey": "did",
            "statusColorField": "delivery_state_color",
            "subTitleTemplate": "{%dv_name%} {%dv_name2%}"
        }
    },
    "viewMode": 1,
    "depends_on": "fk_dvi_did"
}
formCfg
{
    "cssLayout": "col-12 col-md-6 col-xl-3",
    "editMode": 0
}
dv_extcode auto increment
Sendungsnr.
TEXT (63)
R
no
i18n_string
"ecs.DELIVERY.dv_extcode"
table
[ "ecs_delivery" ]
fieldset
"base"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "cssLayout": "col-6",
    "editMode": 0
}
fk_dv_persidperson.persid auto increment
Kunde
INT (11)
R
yes
i18n_string
"ecs.DELIVERY.fk_dv_persid"
table
[ "ecs_delivery" ]
fieldset
"base_record"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "cssLayout": "col-12 col-md-6 col-xl-3",
    "editMode": 0
}
fk_dv_oidorder.oid auto increment
Auftrags-Nr.
INT (11)
R
yes
i18n_string
"ecs.DELIVERY.fk_dv_oid"
table
[ "ecs_delivery" ]
fieldset
"base_record"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "cssLayout": "col-12 col-md-6 col-xl-3",
    "editMode": 0
}
fk_dv_st_idshippingtype.st_id auto increment
Versandart
INT (11)
R
no
i18n_string
"ecs.DELIVERY.fk_dv_st_id"
table
[ "ecs_delivery" ]
fieldset
"base_record"
listCfg
{
    "viewMode": 3,
    "fullSearch": false
}
formCfg
{
    "cssLayout": "col-12 col-md-6 col-xl-3",
    "editMode": 0
}
dv_time_insert auto increment
Angelegt am
DATETIME
R
no
i18n_string
"insert_time"
table
[ "ecs_delivery" ]
fieldset
"sys_record"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
dv_time_update auto increment
Geändert am
DATETIME
R
yes
i18n_string
"update_time"
table
[ "ecs_delivery" ]
fieldset
"sys_record"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
dv_user_insert auto increment
Ersteller
TEXT (127)
R
yes
i18n_string
"insert_user"
table
[ "ecs_delivery" ]
fieldset
"sys_record"
listCfg
{
    "formatter": {
        "type": "user"
    },
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
dv_user_update auto increment
Letzte Änderung durch
TEXT (127)
R
yes
i18n_string
"update_user"
table
[ "ecs_delivery" ]
fieldset
"sys_record"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
dv_time_sent auto increment
Versendet am
DATETIME
R
yes
i18n_string
"ecs.DELIVERY.dv_time_sent"
table
[ "ecs_delivery" ]
fieldset
"extra"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "datepicker",
    "editMode": 0
}
dv_comment auto increment
Kommentar
TEXT
R
no
i18n_string
"ecs.DELIVERY.dv_comment"
table
[ "ecs_delivery" ]
fieldset
"extra"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "textarea",
    "editMode": 0
}
dv_comment_internal auto increment
Interner Kommentar
TEXT
R
yes
i18n_string
"ecs.DELIVERY.dv_comment_internal"
table
[ "ecs_delivery" ]
fieldset
"extra"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "textarea",
    "editMode": 0
}
dv_name auto increment
Name
TEXT
R
no
i18n_string
"ecs.DELIVERY.dv_name"
table
[ "ecs_delivery" ]
fieldset
"dlv_addr"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
dv_company auto increment
Firma
TEXT
R
no
i18n_string
"ecs.DELIVERY.dv_company"
table
[ "ecs_delivery" ]
fieldset
"dlv_addr"
listCfg
{
    "fullSearch": false,
    "viewMode": 0
}
formCfg
{
    "cssLayout": "col-6",
    "editMode": 0
}
dv_name2 auto increment
Adressenzusatz
TEXT
R
no
i18n_string
"ecs.DELIVERY.dv_name2"
table
[ "ecs_delivery" ]
fieldset
"dlv_addr"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "cssLayout": "col-6",
    "editMode": 0
}
dv_street auto increment
Straße
TEXT
R
no
i18n_string
"ecs.DELIVERY.dv_street"
table
[ "ecs_delivery" ]
fieldset
"dlv_addr"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "cssLayout": "col-9",
    "editMode": 0
}
dv_hnr auto increment
Hausnr.
TEXT
R
no
i18n_string
"ecs.DELIVERY.dv_hnr"
table
[ "ecs_delivery" ]
fieldset
"dlv_addr"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "cssLayout": "col-3",
    "editMode": 0
}
dv_zip auto increment
PLZ
TEXT
R
no
i18n_string
"ecs.DELIVERY.dv_zip"
table
[ "ecs_delivery" ]
fieldset
"dlv_addr"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "cssLayout": "col-4",
    "editMode": 0
}
dv_city auto increment
Ort
TEXT
R
no
i18n_string
"ecs.DELIVERY.dv_city"
table
[ "ecs_delivery" ]
fieldset
"dlv_addr"
listCfg
{
    "fullSearch": false,
    "viewMode": 0
}
formCfg
{
    "cssLayout": "col-8",
    "editMode": 0
}
dv_state_code auto increment
Bundesland (Code)
TEXT (15)
R
yes
i18n_string
"ecs.DELIVERY.dv_state_code"
table
[ "ecs_delivery" ]
fieldset
"dlv_addr"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
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%}"
                                        }
                                    }
                                }
                            }
                        }
                    ]
                }
            ]
        }
    },
    "editMode": 0
}
dv_countrycountry.cy_iso auto increment
Land
TEXT (2)
R
no
i18n_string
"ecs.DELIVERY.dv_country"
table
[ "ecs_delivery" ]
fieldset
"dlv_addr"
listCfg
{
    "viewMode": 0,
    "width": 64,
    "formatter": {
        "type": "country-flag"
    },
    "fullSearch": false
}
formCfg
{
    "cssLayout": "col-6",
    "editMode": 0
}
dv_phone auto increment
Telefon
TEXT
R
no
i18n_string
"ecs.DELIVERY.dv_phone"
table
[ "ecs_delivery" ]
fieldset
"dlv_addr"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
drvd_dv_seller_street_hnr auto increment
Straße+Nr (Verkäufer)
TEXT
R
no
i18n_string
"ecs.DELIVERY.drvd_dv_seller_street_hnr"
table
[ "ecs_delivery" ]
drvd_select
CONCAT_WS("",ecs_delivery.dv_seller_street," ",ecs_delivery.dv_seller_hnr)
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
drvd_dv_street_hnr auto increment
Straße+Nr (L)
TEXT
R
no
i18n_string
"ecs.DELIVERY.drvd_dv_street_hnr"
table
[ "ecs_delivery" ]
drvd_select
CONCAT_WS("",ecs_delivery.dv_street," ",ecs_delivery.dv_hnr)
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
delivery_state_color auto increment
TEXT (15)
R
no
i18n_string
"ecs.DELIVERY.delivery_state_color"
table
[ "eos_states" ]
drvd_select
eos_states.st_color
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
item_id auto increment
INT
R
no
i18n_string
"ecs.DELIVERY.item_id"
table
[ "ecs_delivery" ]
drvd_select
ecs_delivery.did
listCfg
{
    "viewMode": 3,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
i18n_st_name auto increment
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"
        }
    },
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
i18n_st_name_public auto increment
Ö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"
        }
    },
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
st_x_dv_sent auto increment
INT (4)
R
no
i18n_string
"ecs.DELIVERY.st_x_dv_sent"
table
[ "eos_states" ]
drvd_select
eos_states.st_x_dv_sent
listCfg
{
    "viewMode": 3,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
st_code auto increment
Status
TEXT
R
no
i18n_string
"ecs.DELIVERY.st_code"
table
[ "eos_states" ]
drvd_select
eos_states.st_code
listCfg
{
    "viewMode": 3,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
st_position auto increment
INT
R
no
i18n_string
"ecs.DELIVERY.st_position"
table
[ "eos_states" ]
drvd_select
eos_states.st_position
listCfg
{
    "viewMode": 3,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
is_current auto increment
INT (1)
R
no
i18n_string
"ecs.DELIVERY.is_current"
table
[ "eos_statelog" ]
drvd_select
eos_statelog.is_current
listCfg
{
    "viewMode": 3,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
transtime auto increment
DATETIME
R
no
i18n_string
"ecs.DELIVERY.transtime"
table
[ "eos_statelog" ]
drvd_select
eos_statelog.transtime
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
fk_dv_psidpackstation.psid auto increment
Packstation
INT (11)
R
no
i18n_string
"ecs_plugin_ewarehouse.DELIVERY.ps_name"
table
"ecs_delivery"
drvd_select
ecs_delivery.fk_dv_psid
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
fk_dv_dgrp_iddeliverygroup.dgrp_id auto increment
Versandliste
INT (11)
R
yes
i18n_string
"ecs_plugin_ewarehouse.DELIVERY.fk_dv_dgrp_id"
table
"ecs_delivery"
drvd_select
ecs_delivery.fk_dv_dgrp_id
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
dv_cost_total_ship auto increment
Versandkosten
FLOAT (13,2)
R
yes
i18n_string
"ecs_plugin_ewarehouse.DELIVERY.dv_cost_total_ship"
table
[ "ecs_delivery" ]
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
dv_cost_total_purchase auto increment
Artikel-Einkaufskosten
FLOAT (13,2)
R
yes
i18n_string
"ecs_plugin_ewarehouse.DELIVERY.dv_cost_total_purchase"
table
[ "ecs_delivery" ]
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
dv_time_rsvd auto increment
Reserviert am
DATETIME
R
yes
i18n_string
"ecs_plugin_ewarehouse.DELIVERY.dv_time_rsvd"
table
[ "ecs_delivery" ]
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
dv_time_transfer auto increment
Transferiert am
DATETIME
R
yes
i18n_string
"ecs_plugin_ewarehouse.DELIVERY.dv_time_transfer"
table
[ "ecs_delivery" ]
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
dv_time_planned_send auto increment
Geplante Sendezeit
DATETIME
R
yes
i18n_string
"ecs_plugin_ewarehouse.DELIVERY.dv_time_planned_send"
table
[ "ecs_delivery" ]
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
fk_dv_shp_c_idshipping_carrier.shp_c_id auto increment
Logistiker
INT (11)
R
no
i18n_string
"ecs.DELIVERY.fk_dv_shp_c_id"
table
[ "ecs_delivery" ]
fieldset
"base"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "cssLayout": "col-6",
    "editMode": 0
}
dv_carrier_time_pickedup auto increment
Abgeholt am (laut Logistiker)
DATETIME
R
yes
i18n_string
"ecs.DELIVERY.dv_carrier_time_pickedup"
table
[ "ecs_delivery" ]
fieldset
"base"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "cssLayout": "col-3",
    "editMode": 0
}
dv_carrier_time_delivered auto increment
Geliefert am (laut Logistiker)
DATETIME
R
yes
i18n_string
"ecs.DELIVERY.dv_carrier_time_delivered"
table
[ "ecs_delivery" ]
fieldset
"base"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "cssLayout": "col-3",
    "editMode": 0
}
dv_carrier_status auto increment
Logistiker-Sendungsstatus
TEXT
R
yes
i18n_string
"ecs.DELIVERY.dv_carrier_status"
table
[ "ecs_delivery" ]
fieldset
"base"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "cssLayout": "col-6",
    "editMode": 0
}
dv_carrier_id auto increment
Logistiker externe ID
TEXT (63)
R
yes
i18n_string
"ecs.DELIVERY.dv_carrier_id"
table
[ "ecs_delivery" ]
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
dv_shipping_details auto increment
Detail-Daten
DATA
R
yes
i18n_string
"ecs.DELIVERY.dv_shipping_details"
table
[ "ecs_delivery" ]
fieldset
"extra"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "cssLayout": "col-12",
    "type": "aceeditor",
    "options": {
        "mode": "json"
    },
    "editMode": 0
}
drvd_shipping_label_url auto increment
Versandlabel
TEXT
R
no
i18n_string
"ecs.DELIVERY.drvd_shipping_label_url"
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"
        }
    },
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
drvd_customs_declaration_url auto increment
Zollerklärung
TEXT
R
no
i18n_string
"ecs.DELIVERY.drvd_customs_declaration_url"
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"
        }
    },
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
drvd_dv_state_name auto increment
Bundesland (Name)
TEXT
R
no
i18n_string
"ecs.DELIVERY.drvd_dv_state_name"
table
[ "dv_terr_state" ]
drvd_select
dv_terr_state.terr_name
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
drvd_dv_state_path auto increment
Bundesland (Pfad)
TEXT
R
no
i18n_string
"ecs.DELIVERY.drvd_dv_state_path"
table
[ "dv_terr_state" ]
drvd_select
dv_terr_state.i18n_node_path_DE
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
drvd_dv_seller_state_name auto increment
Bundesland (Name) (Verkäufer)
TEXT
R
no
i18n_string
"ecs.DELIVERY.drvd_dv_seller_state_name"
table
[ "dv_seller_terr_state" ]
drvd_select
dv_seller_terr_state.terr_name
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
drvd_dv_seller_state_path auto increment
Bundesland (Pfad) (Verkäufer)
TEXT
R
no
i18n_string
"ecs.DELIVERY.drvd_dv_seller_state_path"
table
[ "dv_seller_terr_state" ]
drvd_select
dv_seller_terr_state.i18n_node_path_DE
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}

order

Following fields can also be selected for reading (JOIN)

oid auto increment
OID
INT (11)
R
no
i18n_string
"ecs.ORDER.oid"
table
[ "eos_order" ]
drvd_select
eos_order.oid
fieldset
"base_record"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "hidden",
    "editMode": 0
}
fk_o_shopidshopconfig.eshopid auto increment
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" ]
drvd_select
eos_order.fk_o_shopid
fieldset
"marketing"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
orderid auto increment
Auftrags-Nr.
TEXT (63)
R
no
i18n_string
"ecs.ORDER.orderid"
table
[ "eos_order" ]
drvd_select
eos_order.orderid
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": 0,
    "depends_on": "fk_dv_oid"
}
formCfg
{
    "cssLayout": "col-12 col-md-6 col-xl-3",
    "editMode": 0
}
fk_o_persidperson.persid auto increment
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" ]
drvd_select
eos_order.fk_o_persid
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 auto increment
Bestell­datum
DATETIME
R
yes
i18n_string
"ecs.ORDER.o_time_ordered"
table
[ "eos_order" ]
drvd_select
eos_order.o_time_ordered
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] auto increment
∑ Gesamt, Netto
FLOAT (13,2)
R
no
i18n_string
"ecs.ORDER.total_netto"
table
[ "eos_order" ]
drvd_select
eos_order.total_netto
listCfg
{
    "formatter": {
        "type": "currency"
    },
    "viewMode": 0,
    "sumType": "SV",
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
total_brutto [EUR] auto increment
∑ Gesamt, Brutto
FLOAT (13,2)
R
no
i18n_string
"ecs.ORDER.total_brutto"
table
[ "eos_order" ]
drvd_select
eos_order.total_brutto
listCfg
{
    "formatter": {
        "type": "currency"
    },
    "sumType": "SV",
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
o_orderid_external auto increment
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" ]
drvd_select
eos_order.o_orderid_external
fieldset
"base"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "cssLayout": "col-12 col-md-6 col-xl-3",
    "editMode": 0
}
fk_o_posidorderpos.posid auto increment
POS Channel (ID)
INT (11)
R
yes
i18n_string
"ecs.ORDER.fk_o_posid"
table
[ "eos_order" ]
drvd_select
eos_order.fk_o_posid
fieldset
"base"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "cssLayout": "col-12 col-md-6 col-xl-3",
    "editMode": 0
}
fk_o_stidorderstate.stid auto increment
Status
INT (11)
R
no
i18n_string
"ecs.ORDER.fk_o_stid"
table
[ "eos_order" ]
drvd_select
eos_order.fk_o_stid
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 auto increment
Versandart
INT (11)
R
no
i18n_string
"ecs.ORDER.fk_o_st_id"
table
[ "eos_order" ]
drvd_select
eos_order.fk_o_st_id
fieldset
"base"
listCfg
{
    "viewMode": 3,
    "fullSearch": false
}
formCfg
{
    "cssLayout": "col-12 col-md-6 col-xl-3",
    "editMode": 0
}
o_pers_reftext auto increment
Kunden-Referenztext
TEXT
R
yes
input_translated
Geben Sie einen Referenztext des Kunden ein.
i18n_string
"ecs.ORDER.o_pers_reftext"
table
[ "eos_order" ]
drvd_select
eos_order.o_pers_reftext
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
o_pers_seq_nr auto increment
Auftrags-Sequenz-Nr.
INT (11)
R
no
i18n_string
"ecs.ORDER.o_pers_seq_nr"
table
[ "eos_order" ]
drvd_select
eos_order.o_pers_seq_nr
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
quantity auto increment
Bestellmenge
FLOAT (13,4)
R
no
i18n_string
"ecs.ORDER.quantity"
table
[ "eos_order" ]
drvd_select
eos_order.quantity
listCfg
{
    "viewMode": 0,
    "sumType": "SV",
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
drvd_total_vat [EUR] auto increment
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 auto increment
Währung
TEXT (3)
R
no
i18n_string
"ecs.ORDER.currency"
table
[ "eos_order" ]
drvd_select
eos_order.currency
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
otitle auto increment
Auftragstitel
TEXT
R
yes
input_translated
Geben Sie dem Auftrag einen Titel.
i18n_string
"ecs.ORDER.otitle"
table
[ "eos_order" ]
drvd_select
eos_order.otitle
fieldset
"doc_header"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "cssLayout": "col-12",
    "editMode": 0
}
otext auto increment
Auftragsbeschreibung
TEXT
R
yes
i18n_string
"ecs.ORDER.otext"
table
[ "eos_order" ]
drvd_select
eos_order.otext
fieldset
"extra"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "textarea",
    "editMode": 0
}
o_type auto increment
Auftragstyp
TEXT (15)
R
yes
enum
[ "order", "offer" ]
i18n_string
"ecs.ORDER.o_type"
table
[ "eos_order" ]
drvd_select
eos_order.o_type
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 auto increment
Gültig bis
DATETIME
R
yes
i18n_string
"ecs.ORDER.o_valid_until"
table
[ "eos_order" ]
drvd_select
eos_order.o_valid_until
listCfg
{
    "viewMode": 0,
    "formatter": {
        "type": "date"
    },
    "fullSearch": false
}
formCfg
{
    "type": "datetimepicker",
    "editMode": 0
}
o_txt_header auto increment
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" ]
drvd_select
eos_order.o_txt_header
fieldset
"doc_header"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "fieldSetCol": "12",
    "type": "eoseditor",
    "editMode": 0
}
invoice_addr_preset auto increment
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 auto increment
Anrede (R)
TEXT
R
yes
enum
[ "female", "male", "company", "divers" ]
i18n_string
"ecs.ORDER.invoice_gender"
table
[ "eos_order" ]
drvd_select
eos_order.invoice_gender
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 auto increment
Titel (R)
TEXT
R
no
i18n_string
"ecs.ORDER.invoice_title"
table
[ "eos_order" ]
drvd_select
eos_order.invoice_title
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 auto increment
Vorname (R)
TEXT
R
no
i18n_string
"ecs.ORDER.invoice_firstname"
table
[ "eos_order" ]
drvd_select
eos_order.invoice_firstname
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 auto increment
Nachname (R)
TEXT
R
no
i18n_string
"ecs.ORDER.invoice_lastname"
table
[ "eos_order" ]
drvd_select
eos_order.invoice_lastname
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 auto increment
Firma (R)
TEXT
R
no
i18n_string
"ecs.ORDER.invoice_company"
table
[ "eos_order" ]
drvd_select
eos_order.invoice_company
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 auto increment
Adressenzusatz
TEXT
R
no
i18n_string
"ecs.ORDER.invoice_addrextra"
table
[ "eos_order" ]
drvd_select
eos_order.invoice_addrextra
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 auto increment
Straße (R)
TEXT
R
no
i18n_string
"ecs.ORDER.invoice_street"
table
[ "eos_order" ]
drvd_select
eos_order.invoice_street
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 auto increment
Hausnummer (R)
TEXT
R
no
i18n_string
"ecs.ORDER.invoice_housenr"
table
[ "eos_order" ]
drvd_select
eos_order.invoice_housenr
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 auto increment
PLZ (R)
TEXT
R
no
i18n_string
"ecs.ORDER.invoice_zip"
table
[ "eos_order" ]
drvd_select
eos_order.invoice_zip
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 auto increment
Ort (R)
TEXT
R
no
i18n_string
"ecs.ORDER.invoice_town"
table
[ "eos_order" ]
drvd_select
eos_order.invoice_town
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 auto increment
Bundesland (Code) (R)
TEXT (15)
R
yes
i18n_string
"ecs.ORDER.invoice_state_code"
table
[ "eos_order" ]
drvd_select
eos_order.invoice_state_code
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 auto increment
Land (R)
TEXT (2)
R
no
i18n_string
"ecs.ORDER.invoice_country"
table
[ "eos_order" ]
drvd_select
eos_order.invoice_country
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 auto increment
Rechnungsart
TEXT
R
yes
enum
[ "noncommercial", "commercial" ]
i18n_string
"ecs.ORDER.invoice_type"
table
[ "eos_order" ]
drvd_select
eos_order.invoice_type
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 auto increment
E-Mail (R)
TEXT
R
no
i18n_string
"ecs.ORDER.invoice_email"
table
[ "eos_order" ]
drvd_select
eos_order.invoice_email
fieldset
"inv_extra"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "cssLayout": "col-4",
    "editMode": 0
}
invoice_taxidentnumber auto increment
USt.ID-Nr.
TEXT
R
no
i18n_string
"ecs.ORDER.invoice_taxidentnumber"
table
[ "eos_order" ]
drvd_select
eos_order.invoice_taxidentnumber
fieldset
"inv_extra"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "cssLayout": "col-4",
    "editMode": 0
}
invoice_taxident_status auto increment
USt.ID-Nr. Status
TEXT
R
yes
enum
[ "invalid", "valid_conditional", "valid_confirmed" ]
i18n_string
"ecs.ORDER.invoice_taxident_status"
table
[ "eos_order" ]
drvd_select
eos_order.invoice_taxident_status
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 auto increment
Ausfuhrbescheinigung
TEXT
R
yes
enum
[ "none", "certificate_promised", "certificate_received" ]
i18n_string
"ecs.ORDER.invoice_third_country_export"
table
[ "eos_order" ]
drvd_select
eos_order.invoice_third_country_export
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 auto increment
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" ]
drvd_select
eos_order.invoice_lang_iso
fieldset
"inv_extra"
listCfg
{
    "viewMode": 0,
    "formatter": {
        "type": "country-flag"
    },
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
drvd_invoice_street_housenr auto increment
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 auto increment
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 auto increment
Anrede (L)
TEXT
R
yes
enum
[ "female", "male", "company", "divers" ]
i18n_string
"ecs.ORDER.deliver_gender"
table
[ "eos_order" ]
drvd_select
eos_order.deliver_gender
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 auto increment
Titel (L)
TEXT
R
no
i18n_string
"ecs.ORDER.deliver_title"
table
[ "eos_order" ]
drvd_select
eos_order.deliver_title
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 auto increment
Vorname (L)
TEXT
R
no
i18n_string
"ecs.ORDER.deliver_firstname"
table
[ "eos_order" ]
drvd_select
eos_order.deliver_firstname
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 auto increment
Nachname (L)
TEXT
R
no
i18n_string
"ecs.ORDER.deliver_lastname"
table
[ "eos_order" ]
drvd_select
eos_order.deliver_lastname
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 auto increment
Firma (L)
TEXT
R
no
i18n_string
"ecs.ORDER.deliver_company"
table
[ "eos_order" ]
drvd_select
eos_order.deliver_company
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 auto increment
Adressenzusatz
TEXT
R
no
i18n_string
"ecs.ORDER.deliver_addrextra"
table
[ "eos_order" ]
drvd_select
eos_order.deliver_addrextra
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 auto increment
Straße (L)
TEXT
R
no
i18n_string
"ecs.ORDER.deliver_street"
table
[ "eos_order" ]
drvd_select
eos_order.deliver_street
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 auto increment
Hausnummer (L)
TEXT
R
no
i18n_string
"ecs.ORDER.deliver_housenr"
table
[ "eos_order" ]
drvd_select
eos_order.deliver_housenr
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 auto increment
PLZ (L)
TEXT
R
no
i18n_string
"ecs.ORDER.deliver_zip"
table
[ "eos_order" ]
drvd_select
eos_order.deliver_zip
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 auto increment
Ort (L)
TEXT
R
no
i18n_string
"ecs.ORDER.deliver_town"
table
[ "eos_order" ]
drvd_select
eos_order.deliver_town
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 auto increment
Bundesland (Code) (L)
TEXT (15)
R
yes
i18n_string
"ecs.ORDER.deliver_state_code"
table
[ "eos_order" ]
drvd_select
eos_order.deliver_state_code
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 auto increment
Land (L)
TEXT (2)
R
no
i18n_string
"ecs.ORDER.deliver_country"
table
[ "eos_order" ]
drvd_select
eos_order.deliver_country
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 auto increment
Kunden-Wunschtermin
TEXT
R
no
i18n_string
"ecs.ORDER.deliver_date_req"
table
[ "eos_order" ]
drvd_select
eos_order.deliver_date_req
fieldset
"dlv_extra"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
deliver_phone auto increment
Telefon
TEXT
R
no
i18n_string
"ecs.ORDER.deliver_phone"
table
[ "eos_order" ]
drvd_select
eos_order.deliver_phone
fieldset
"dlv_extra"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
deliver_email auto increment
E-Mail (L)
TEXT
R
no
i18n_string
"ecs.ORDER.deliver_email"
table
[ "eos_order" ]
drvd_select
eos_order.deliver_email
fieldset
"dlv_extra"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
deliver_comment auto increment
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" ]
drvd_select
eos_order.deliver_comment
fieldset
"dlv_extra"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
drvd_deliver_street_housenr auto increment
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 auto increment
Lieferhinweise
DATA
R
yes
i18n_string
"ecs.ORDER.deliver_notes_xdata"
table
[ "eos_order" ]
drvd_select
eos_order.deliver_notes_xdata
fieldset
"dlv_extra"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "cssLayout": "col-12",
    "type": "aceeditor",
    "options": {
        "mode": "json"
    },
    "editMode": 0
}
ip_address auto increment
IP-Adresse
TEXT
R
yes
i18n_string
"ecs.ORDER.ip_address"
table
[ "eos_order" ]
drvd_select
eos_order.ip_address
fieldset
"sys_record"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
o_referrer auto increment
Referrer
TEXT
R
yes
i18n_string
"ecs.ORDER.o_referrer"
table
[ "eos_order" ]
drvd_select
eos_order.o_referrer
fieldset
"sys_record"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
o_useragent auto increment
User-Agent
TEXT
R
yes
i18n_string
"ecs.ORDER.o_useragent"
table
[ "eos_order" ]
drvd_select
eos_order.o_useragent
fieldset
"sys_record"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
o_comment auto increment
Kundenkommentar
TEXT
R
yes
input_translated
Geben Sie hier einen Kommentar zum Auftrag ein.
i18n_string
"ecs.ORDER.o_comment"
table
[ "eos_order" ]
drvd_select
eos_order.o_comment
fieldset
"extra"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "textarea",
    "editMode": 0
}
o_comment_internal auto increment
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" ]
drvd_select
eos_order.o_comment_internal
fieldset
"extra"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "textarea",
    "editMode": 0
}
o_lock_time auto increment
Bearbeitungs-Sperre (Zeitpunkt)
DATETIME
R
yes
i18n_string
"ecs.ORDER.o_lock_time"
table
[ "eos_order" ]
drvd_select
eos_order.o_lock_time
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
o_lock_user auto increment
Bearbeitungs-Sperre (Benutzer)
TEXT (31)
R
yes
i18n_string
"ecs.ORDER.o_lock_user"
table
[ "eos_order" ]
drvd_select
eos_order.o_lock_user
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
o_insert_time auto increment
Angelegt am
DATETIME
R
no
i18n_string
"insert_time"
table
[ "eos_order" ]
drvd_select
eos_order.o_insert_time
fieldset
"sys_record"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
o_update_time auto increment
Geändert am
DATETIME
R
yes
i18n_string
"update_time"
table
[ "eos_order" ]
drvd_select
eos_order.o_update_time
fieldset
"sys_record"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
o_insert_user auto increment
Ersteller
TEXT (127)
R
yes
i18n_string
"insert_user"
table
[ "eos_order" ]
drvd_select
eos_order.o_insert_user
fieldset
"sys_record"
listCfg
{
    "formatter": {
        "type": "user"
    },
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
o_update_user auto increment
Letzte Änderung durch
TEXT (127)
R
yes
i18n_string
"update_user"
table
[ "eos_order" ]
drvd_select
eos_order.o_update_user
fieldset
"sys_record"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
fk_o_campidcampaign.campid auto increment
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" ]
drvd_select
eos_order.fk_o_campid
fieldset
"marketing"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "cssLayout": "col-6",
    "editMode": 0
}
drvd_o_shoplabel auto increment
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 auto increment
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 auto increment
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 auto increment
Zahlungsziel-Daten
DATA
R
yes
i18n_string
"ecs.ORDER.o_pay_profile_xdata"
table
[ "eos_order" ]
drvd_select
eos_order.o_pay_profile_xdata
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "cssLayout": "col-12",
    "type": "aceeditor",
    "options": {
        "mode": "json"
    },
    "editMode": 0
}
fk_o_companyaccount_subaccount_persidcompanysubaccount.persid auto increment
Unteraccount
INT (11)
R
yes
i18n_string
"ecs.plugin_companyaccount.fk_o_companyaccount_subaccount_persid"
table
[ "eos_order" ]
drvd_select
eos_order.fk_o_companyaccount_subaccount_persid
fieldset
"extra"
listCfg
{
    "viewMode": 3,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
fk_o_mrch_idmerchant.mrch_id auto increment
Verkaufender Anbieter
INT (11)
R
yes
i18n_string
"ecs.ORDER.fk_o_mrch_id"
table
[ "eos_order" ]
drvd_select
eos_order.fk_o_mrch_id
fieldset
"extra"
listCfg
{
    "viewMode": 3,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
fk_o_parent_oidorder.oid auto increment
Hauptauftrag
INT (11)
R
yes
i18n_string
"ecs.ORDER.fk_o_parent_oid"
table
[ "eos_order" ]
drvd_select
eos_order.fk_o_parent_oid
fieldset
"extra"
listCfg
{
    "viewMode": 3,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
o_merchant_xdata auto increment
Anbieter (Zusatzdaten)
DATA
R
yes
i18n_string
"ecs.ORDER.o_merchant_xdata"
table
[ "eos_order" ]
drvd_select
eos_order.o_merchant_xdata
fieldset
"extra"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "cssLayout": "col-12",
    "type": "aceeditor",
    "options": {
        "mode": "json"
    },
    "editMode": 0
}
o_periodic_time_first auto increment
Abo-Startdatum
DATETIME
R
yes
i18n_string
"ecs.ORDER.o_periodic_time_first"
table
[ "eos_order" ]
drvd_select
eos_order.o_periodic_time_first
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 auto increment
Abo-Enddatum
DATETIME
R
yes
i18n_string
"ecs.ORDER.o_periodic_time_last"
table
[ "eos_order" ]
drvd_select
eos_order.o_periodic_time_last
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 auto increment
Nächste Abo-Ausführung
DATETIME
R
yes
i18n_string
"ecs.ORDER.o_periodic_time_next"
table
[ "eos_order" ]
drvd_select
eos_order.o_periodic_time_next
fieldset
"time_settings"
listCfg
{
    "viewMode": 3,
    "fullSearch": false
}
formCfg
{
    "editMode": 0,
    "cssLayout": "col-12 col-md-6 col-xl-6"
}
o_periodic_timeorder_offset auto increment
Abweichendes Auftragsdatum
TEXT (31)
R
no
i18n_string
"ecs.ORDER.o_periodic_timeorder_offset"
table
[ "eos_order" ]
drvd_select
eos_order.o_periodic_timeorder_offset
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 auto increment
Strikt
INT (1)
R
no
i18n_string
"ecs.ORDER.o_periodic_time_strict"
table
[ "eos_order" ]
drvd_select
eos_order.o_periodic_time_strict
fieldset
"time_settings"
listCfg
{
    "viewMode": 3,
    "formatter": {
        "type": "active-flag"
    },
    "fullSearch": false
}
formCfg
{
    "type": "checkbox",
    "value": 1,
    "editMode": 0
}
o_periodic_exec_period auto increment
Abo-Intervall
TEXT (31)
R
no
i18n_string
"ecs.ORDER.o_periodic_exec_period"
table
[ "eos_order" ]
drvd_select
eos_order.o_periodic_exec_period
fieldset
"time_settings"
listCfg
{
    "viewMode": 3,
    "formatter": {
        "type": "cron"
    },
    "fullSearch": false
}
formCfg
{
    "type": "hfycron",
    "editMode": 0
}
o_periodic_exec_inprogress auto increment
Wird gerade ausgeführt
INT (1)
R
no
i18n_string
"ecs.ORDER.o_periodic_exec_inprogress"
table
[ "eos_order" ]
drvd_select
eos_order.o_periodic_exec_inprogress
listCfg
{
    "viewMode": 3,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
o_periodic_xdata auto increment
DATA
R
yes
i18n_string
"ecs.ORDER.o_periodic_xdata"
table
[ "eos_order" ]
drvd_select
eos_order.o_periodic_xdata
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 auto increment
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 auto increment
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 auto increment
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 auto increment
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 auto increment
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 auto increment
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
}

person

Following fields can also be selected for reading (JOIN)

persid auto increment
PersID
INT (11)
R
no
i18n_string
"ecs.PERSON.persid"
table
[ "eos_person" ]
drvd_select
eos_person.persid
fieldset
"base_record"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "hidden",
    "editMode": 0
}
personid auto increment
Kunden-Nr.
TEXT (32)
R
no
i18n_string
"ecs.PERSON.personid"
table
[ "eos_person" ]
drvd_select
eos_person.personid
fieldset
"base_record"
listCfg
{
    "width": 160,
    "formatter": {
        "type": "model-primary",
        "params": {
            "model": "person",
            "primaryKey": "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"
        }
    },
    "viewMode": 0,
    "fullSearch": false,
    "depends_on": "fk_dv_persid"
}
formCfg
{
    "cssLayout": "col-6",
    "editMode": 0
}
fk_p_grpidpersongroup.grpid auto increment
Kundengruppe
INT (11)
R
no
i18n_string
"ecs.PERSON.fk_p_grpid"
table
[ "eos_person" ]
drvd_select
eos_person.fk_p_grpid
fieldset
"base_record"
listCfg
{
    "viewMode": 3,
    "fullSearch": false
}
formCfg
{
    "cssLayout": "col-6",
    "editMode": 0
}
fk_p_shopidshopconfig.eshopid auto increment
Shop
INT (11)
R
yes
i18n_string
"ecs.PERSON.fk_p_shopid"
table
[ "eos_person" ]
drvd_select
eos_person.fk_p_shopid
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
gender auto increment
Anrede
TEXT
R
yes
enum
[ "female", "male", "company", "divers" ]
i18n_string
"ecs.PERSON.gender"
valueColorField
"gender_color"
table
[ "eos_person" ]
drvd_select
eos_person.gender
fieldset
"base"
listCfg
{
    "width": 96,
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "cssLayout": "col-3",
    "type": "eosdropdown",
    "options": {
        "optI18nValuePrefix": "ecs.gender",
        "optI18nName": true,
        "data": {
            "options": [
                {
                    "value": null
                },
                {
                    "value": "female"
                },
                {
                    "value": "male"
                },
                {
                    "value": "company"
                },
                {
                    "value": "divers"
                }
            ]
        }
    },
    "editMode": 0
}
gender_color auto increment
TEXT (15)
R
yes
i18n_string
"ecs.PERSON.gender_color"
table
[ "eos_person" ]
drvd_select
CASE eos_person.gender WHEN "female" THEN "#BF117F" WHEN "male" THEN "#1f96cb" WHEN "divers" THEN "#7D47B9" WHEN "company" THEN "#41cbd9" WHEN "unknown" THEN "#AAAAAA" ELSE NULL END
listCfg
{
    "viewMode": 3,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
title auto increment
Titel
TEXT
R
no
input_translated
Geben Sie hier einen Titel des Kunden an (z.B. Dr.).
i18n_string
"ecs.PERSON.title"
table
[ "eos_person" ]
drvd_select
eos_person.title
fieldset
"base"
listCfg
{
    "width": 96,
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "cssLayout": "col-3",
    "type": "eosdropdown",
    "options": {
        "addTag": true,
        "optValueField": "title",
        "optNameField": "title",
        "dataStreamCall": {
            "method": "datahub_generate_reportList",
            "params": {
                "ds_label": "person",
                "field_groupby": [
                    {
                        "field": "title"
                    }
                ]
            }
        }
    },
    "editMode": 0
}
salutation auto increment
Anrede formal
TEXT
R
no
i18n_string
"ecs.PERSON.salutation"
table
[ "eos_person" ]
drvd_select
eos_person.salutation
fieldset
"base"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "cssLayout": "col-6",
    "type": "eosdropdown",
    "options": {
        "addTag": true,
        "optValueField": "salutation",
        "optNameField": "salutation",
        "dataStreamCall": {
            "method": "datahub_generate_reportList",
            "params": {
                "ds_label": "person",
                "field_groupby": [
                    {
                        "field": "salutation"
                    }
                ]
            }
        }
    },
    "editMode": 0
}
firstname auto increment
Vorname
TEXT
R
no
input_translated
Vorname der Registrierungsadresse.
i18n_string
"ecs.PERSON.firstname"
table
[ "eos_person" ]
drvd_select
eos_person.firstname
fieldset
"base"
listCfg
{
    "width": 128,
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "cssLayout": "col-6",
    "editMode": 0
}
lastname auto increment
Nachname
TEXT
R
no
i18n_string
"ecs.PERSON.lastname"
table
[ "eos_person" ]
drvd_select
eos_person.lastname
fieldset
"base"
listCfg
{
    "width": 128,
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "cssLayout": "col-6",
    "editMode": 0
}
bday auto increment
Geburtsdatum
DATE
R
yes
input_translated
Tragen Sie hier das Geburtsdatum des Kunden ein.

Vorzugsweise im Format: tt.mm.JJJJ.
i18n_string
"ecs.PERSON.bday"
table
[ "eos_person" ]
drvd_select
eos_person.bday
fieldset
"base"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "datepicker",
    "options": {
        "showWeekdays": false,
        "showWeekNumbers": false,
        "minDate": {
            "day": 1,
            "month": 1,
            "year": "1900"
        }
    },
    "editMode": 0
}
drvd_age [y] auto increment
Alter
INT
R
yes
i18n_string
"ecs.PERSON.drvd_age"
table
[ "eos_person" ]
drvd_select
DATE_FORMAT(NOW(), '%Y') - DATE_FORMAT(eos_person.bday, '%Y') - (DATE_FORMAT(NOW(), '00-%m-%d') < DATE_FORMAT(eos_person.bday, '00-%m-%d'))
fieldset
"analytics"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
drvd_bday_days_until_next [d] auto increment
Nächster Geburtstag (in Tagen)
INT
R
yes
i18n_string
"ecs.PERSON.drvd_bday_days_until_next"
table
[ "eos_person" ]
drvd_select
IF(DAYOFYEAR(eos_person.bday)>DAYOFYEAR(CURDATE()) , DATEDIFF(CONCAT(YEAR(CURDATE()),'-',MONTH(eos_person.bday),'-',DAY(eos_person.bday) ) , CURDATE() ), DATEDIFF(CONCAT(YEAR(CURDATE())+1,'-',MONTH(eos_person.bday),'-',DAY(eos_person.bday) ) , CURDATE()))
fieldset
"analytics"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
drvd_bday_next auto increment
Nächster Geburtstag
DATE
R
yes
i18n_string
"ecs.PERSON.drvd_bday_next"
table
[ "eos_person" ]
drvd_select
IF(DAYOFYEAR(eos_person.bday)>DAYOFYEAR(CURDATE()) , CONCAT(YEAR(CURDATE()),'-',LPAD(MONTH(eos_person.bday),2,'0'),'-',LPAD(DAY(eos_person.bday),2,'0') ), CONCAT(YEAR(CURDATE())+1,'-',LPAD(MONTH(eos_person.bday),2,'0'),'-',LPAD(DAY(eos_person.bday),2,'0')))
fieldset
"analytics"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
company auto increment
Firma
TEXT
R
no
i18n_string
"ecs.PERSON.company"
table
[ "eos_person" ]
drvd_select
eos_person.company
fieldset
"addr"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "cssLayout": "col-4",
    "editMode": 0
}
p_department auto increment
Abteilung
TEXT
R
no
i18n_string
"ecs.PERSON.p_department"
table
[ "eos_person" ]
drvd_select
eos_person.p_department
fieldset
"addr"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "cssLayout": "col-4",
    "type": "eosdropdown",
    "options": {
        "addTag": true,
        "optValueField": "p_department",
        "optNameField": "p_department",
        "dataStreamCall": {
            "method": "data_getList",
            "params": {
                "dataset": "person",
                "fieldGroupBy": [
                    {
                        "field": "p_department"
                    }
                ],
                "filter": {
                    "p_department": {
                        "search": "!$EMPTY"
                    }
                }
            }
        }
    },
    "editMode": 0
}
p_job_position auto increment
Position
TEXT
R
no
i18n_string
"ecs.PERSON.p_job_position"
table
[ "eos_person" ]
drvd_select
eos_person.p_job_position
fieldset
"addr"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "cssLayout": "col-4",
    "type": "eosdropdown",
    "options": {
        "addTag": true,
        "optValueField": "p_job_position",
        "optNameField": "p_job_position",
        "dataStreamCall": {
            "method": "data_getList",
            "params": {
                "dataset": "person",
                "fieldGroupBy": [
                    {
                        "field": "p_job_position"
                    }
                ],
                "filter": {
                    "p_job_position": {
                        "search": "!$EMPTY"
                    }
                }
            }
        }
    },
    "editMode": 0
}
address2 auto increment
Adressenzusatz
TEXT
R
no
i18n_string
"ecs.PERSON.address2"
table
[ "eos_person" ]
drvd_select
eos_person.address2
fieldset
"addr"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "cssLayout": "col-12",
    "editMode": 0
}
street auto increment
Straße
TEXT
R
no
i18n_string
"ecs.PERSON.street"
table
[ "eos_person" ]
drvd_select
eos_person.street
fieldset
"addr"
listCfg
{
    "width": 96,
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "cssLayout": "col-9",
    "editMode": 0
}
housenr auto increment
Hausnummer
TEXT
R
no
i18n_string
"ecs.PERSON.housenr"
table
[ "eos_person" ]
drvd_select
eos_person.housenr
fieldset
"addr"
listCfg
{
    "width": 64,
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "cssLayout": "col-3",
    "editMode": 0
}
zip auto increment
PLZ
TEXT
R
no
i18n_string
"ecs.PERSON.zip"
table
[ "eos_person" ]
drvd_select
eos_person.zip
fieldset
"addr"
listCfg
{
    "width": 64,
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "cssLayout": "col-4",
    "editMode": 0
}
town auto increment
Ort
TEXT
R
no
i18n_string
"ecs.PERSON.town"
table
[ "eos_person" ]
drvd_select
eos_person.town
fieldset
"addr"
listCfg
{
    "width": 96,
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "cssLayout": "col-8",
    "editMode": 0
}
state_code auto increment
Bundesland (Code)
TEXT (15)
R
yes
i18n_string
"ecs.PERSON.state_code"
table
[ "eos_person" ]
drvd_select
eos_person.state_code
fieldset
"addr"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "cssLayout": "col-6",
    "type": "eosdropdown",
    "options": {
        "serverSideSearch": false,
        "optValueField": "terr_code",
        "optNameField": "terr_name",
        "optExtraField": "terr_code",
        "observer": {
            "fields": [
                {
                    "field": "country",
                    "trigger": "onInit",
                    "exec": [
                        {
                            "cmd": "loadOptions",
                            "params": {
                                "dataStreamCall": {
                                    "method": "state_getlist",
                                    "params": {
                                        "filter": {
                                            "state_country": "{%FIELD.value%}"
                                        }
                                    }
                                }
                            }
                        }
                    ]
                },
                {
                    "field": "country",
                    "trigger": "onChange",
                    "exec": [
                        {
                            "cmd": "loadOptions",
                            "params": {
                                "dataStreamCall": {
                                    "method": "state_getlist",
                                    "params": {
                                        "filter": {
                                            "state_country": "{%FIELD.value%}"
                                        }
                                    }
                                }
                            }
                        }
                    ]
                }
            ]
        }
    },
    "editMode": 0
}
countrycountry.cy_iso auto increment
Land
TEXT (2)
R
no
i18n_string
"ecs.PERSON.country"
table
[ "eos_person" ]
drvd_select
eos_person.country
fieldset
"addr"
listCfg
{
    "viewMode": 0,
    "width": 64,
    "formatter": {
        "type": "country-flag"
    },
    "fullSearch": false
}
formCfg
{
    "cssLayout": "col-6",
    "editMode": 0
}
drvd_person_name auto increment
Kundenname (kombiniert)
TEXT
R
no
i18n_string
"ecs.PERSON.drvd_person_name"
table
[ "eos_person" ]
drvd_select
CONCAT_WS("",eos_person.company,IF((eos_person.company IS NOT NULL AND eos_person.company != "") AND ((eos_person.firstname IS NOT NULL AND eos_person.firstname != "") OR (eos_person.lastname IS NOT NULL AND eos_person.lastname != "")),", ",""),eos_person.firstname,IF(eos_person.firstname IS NOT NULL," ",""),eos_person.lastname)
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
drvd_p_address auto increment
Adresse
TEXT
R
yes
i18n_string
"ecs.PERSON.drvd_p_address"
table
[ "eos_person" ]
drvd_select
CONCAT(
		                IF(CHAR_LENGTH(eos_person.company)>0,CONCAT(eos_person.company,CHAR(13)),""),
		                TRIM(CONCAT(eos_person.title," ",eos_person.firstname," ",eos_person.lastname)),CHAR(13),
		                IF(CHAR_LENGTH(eos_person.address2)>0,CONCAT(eos_person.address2,CHAR(13)),""),
		                eos_person.street," ",eos_person.housenr,CHAR(13),
		                eos_person.country," - ",eos_person.zip," ",eos_person.town)
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
email auto increment
E-Mail
TEXT (127)
R
no
i18n_string
"ecs.PERSON.email"
table
[ "eos_person" ]
drvd_select
eos_person.email
fieldset
"communication"
listCfg
{
    "width": 256,
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "hfyemail",
    "cssLayout": "col-6",
    "editMode": 0
}
telephone auto increment
Telefon
TEXT
R
no
i18n_string
"ecs.PERSON.telephone"
table
[ "eos_person" ]
drvd_select
eos_person.telephone
fieldset
"communication"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "hfyphone",
    "cssLayout": "col-6",
    "editMode": 0
}
telephone_mobile auto increment
Tel. mobil
TEXT
R
no
i18n_string
"ecs.PERSON.telephone_mobile"
table
[ "eos_person" ]
drvd_select
eos_person.telephone_mobile
fieldset
"communication"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "hfyphone",
    "cssLayout": "col-6",
    "editMode": 0
}
telefax auto increment
Fax
TEXT
R
no
i18n_string
"ecs.PERSON.telefax"
table
[ "eos_person" ]
drvd_select
eos_person.telefax
fieldset
"communication"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "hfyphone",
    "cssLayout": "col-6",
    "editMode": 0
}
p_invoice_type auto increment
Rechnungsart
TEXT
R
yes
i18n_string
"ecs.PERSON.p_invoice_type"
table
[ "eos_person" ]
drvd_select
eos_person.p_invoice_type
fieldset
"commercial"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "eosdropdown",
    "options": {
        "optI18nValuePrefix": "ecs.invoice_type",
        "optI18nName": true,
        "data": {
            "options": [
                {
                    "value": "noncommercial"
                },
                {
                    "value": "commercial"
                }
            ]
        }
    },
    "editMode": 0
}
p_invoice_email auto increment
E-Mail (Rechnung)
TEXT
R
no
i18n_string
"ecs.PERSON.p_invoice_email"
table
[ "eos_person" ]
drvd_select
eos_person.p_invoice_email
fieldset
"commercial"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "hfyemail",
    "editMode": 0
}
taxident auto increment
Umsatzsteuer-ID
TEXT
R
no
i18n_string
"ecs.PERSON.taxident"
table
[ "eos_person" ]
drvd_select
eos_person.taxident
fieldset
"commercial"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
taxident_status auto increment
Umsatzsteuer-ID-Status
TEXT
R
yes
input_translated
Status der Umsatzsteuer-ID des Kundenkontos. Nur Kundenkonten mit bestätigter Umsatzsteuer-ID werden für Netto-Aufträge bei Lieferung in andere EU Länder berücksichtigt.
enum
[ "invalid", "valid_conditional", "valid_confirmed" ]
i18n_string
"ecs.PERSON.taxident_status"
table
[ "eos_person" ]
drvd_select
eos_person.taxident_status
fieldset
"commercial"
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
}
score auto increment
Bonitätswert
INT (7)
R
no
i18n_string
"ecs.PERSON.score"
table
[ "eos_person" ]
drvd_select
eos_person.score
fieldset
"credit_rating"
listCfg
{
    "viewMode": 0,
    "sumType": "AVG",
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
score_time_set auto increment
Letzter Rating-Check
DATETIME
R
yes
i18n_string
"ecs.PERSON.score_time_set"
table
[ "eos_person" ]
drvd_select
eos_person.score_time_set
fieldset
"credit_rating"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
score_time_invalid auto increment
Abgelaufen am
DATETIME
R
yes
i18n_string
"ecs.PERSON.score_time_invalid"
table
[ "eos_person" ]
drvd_select
eos_person.score_time_invalid
fieldset
"credit_rating"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
svc_code auto increment
Rating ServiceCode
TEXT
R
yes
i18n_string
"ecs.PERSON.svc_code"
table
[ "eos_person" ]
drvd_select
eos_person.svc_code
fieldset
"credit_rating"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
svc_txt auto increment
Rating ServiceText
TEXT
R
yes
i18n_string
"ecs.PERSON.svc_txt"
table
[ "eos_person" ]
drvd_select
eos_person.svc_txt
fieldset
"credit_rating"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
p_login_username auto increment
Benutzername
TEXT (63)
R
yes
i18n_string
"ecs.PERSON.p_login_username"
table
[ "eos_person" ]
drvd_select
eos_person.p_login_username
fieldset
"login"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
p_login_pwd_encrypted auto increment
Passwort (verschlüsselt)
TEXT
R
yes
i18n_string
"ecs.PERSON.p_login_pwd_encrypted"
table
[ "eos_person" ]
drvd_select
eos_person.p_login_pwd_encrypted
fieldset
"login"
listCfg
{
    "viewMode": 3,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
p_login_pwd_key auto increment
Direct-Login-Token
TEXT
R
yes
i18n_string
"ecs.PERSON.p_login_pwd_key"
table
[ "eos_person" ]
drvd_select
eos_person.p_login_pwd_key
fieldset
"login"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
p_login_time_last auto increment
Letzter Login
DATETIME
R
yes
i18n_string
"ecs.PERSON.p_login_time_last"
table
[ "eos_person" ]
drvd_select
eos_person.p_login_time_last
fieldset
"login"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
p_login_pwd_must_renew_after auto increment
Passwort-Änderung auffordern ab
DATETIME
R
yes
i18n_string
"ecs.PERSON.p_login_pwd_must_renew_after"
table
[ "eos_person" ]
drvd_select
eos_person.p_login_pwd_must_renew_after
fieldset
"login"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "datetimepicker",
    "editMode": 0
}
p_login_pwd_key_timeout auto increment
Direct-Login-Token Timeout
DATETIME
R
yes
i18n_string
"ecs.PERSON.p_login_pwd_key_timeout"
table
[ "eos_person" ]
drvd_select
eos_person.p_login_pwd_key_timeout
fieldset
"login"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
p_login_pwd_last_renewed auto increment
Passwort zuletzt geändert
DATETIME
R
yes
i18n_string
"ecs.PERSON.p_login_pwd_last_renewed"
table
[ "eos_person" ]
drvd_select
eos_person.p_login_pwd_last_renewed
fieldset
"login"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
p_login_active auto increment
Aktiv
INT (1)
R
no
i18n_string
"ecs.PERSON.p_login_active"
table
[ "eos_person" ]
drvd_select
eos_person.p_login_active
fieldset
"login"
listCfg
{
    "formatter": {
        "type": "active-flag"
    },
    "width": 64,
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "checkbox",
    "editMode": 0
}
p_email_verify_token auto increment
TEXT (32)
R
yes
i18n_string
"ecs.PERSON.p_email_verify_token"
table
[ "eos_person" ]
drvd_select
eos_person.p_email_verify_token
fieldset
"login"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
p_email_verify_token_timeout auto increment
DATETIME
R
yes
i18n_string
"ecs.PERSON.p_email_verify_token_timeout"
table
[ "eos_person" ]
drvd_select
eos_person.p_email_verify_token_timeout
fieldset
"login"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
p_email_verified_time auto increment
DATETIME
R
yes
i18n_string
"ecs.PERSON.p_email_verified_time"
table
[ "eos_person" ]
drvd_select
eos_person.p_email_verified_time
fieldset
"login"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
p_login_mode auto increment
Login-Modus
TEXT (15)
R
yes
enum
[ "simple", "2fa_email" ]
i18n_string
"ecs.PERSON.p_login_mode"
table
[ "eos_person" ]
drvd_select
eos_person.p_login_mode
fieldset
"login"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "cssLayout": "col-3",
    "type": "eosdropdown",
    "options": {
        "optI18nValuePrefix": "ecs.p_login_mode",
        "optI18nName": true,
        "optI18nSubTitle": true,
        "data": {
            "options": [
                {
                    "value": "simple"
                },
                {
                    "value": "2fa_email"
                }
            ]
        }
    },
    "editMode": 0
}
p_login_2fa_code auto increment
2FA - Login Code
TEXT
R
yes
i18n_string
"ecs.PERSON.p_login_2fa_code"
table
[ "eos_person" ]
drvd_select
eos_person.p_login_2fa_code
fieldset
"login"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
p_login_2fa_timeout auto increment
2FA - Login Code Timeout
DATETIME
R
yes
i18n_string
"ecs.PERSON.p_login_2fa_timeout"
table
[ "eos_person" ]
drvd_select
eos_person.p_login_2fa_timeout
fieldset
"login"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
p_login_err_count auto increment
Anzahl Fehllogins
INT (4)
R
no
i18n_string
"ecs.PERSON.p_login_err_count"
table
[ "eos_person" ]
drvd_select
eos_person.p_login_err_count
fieldset
"login"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
p_login_time_min auto increment
Login Sperrzeit
DATETIME
R
yes
i18n_string
"ecs.PERSON.p_login_time_min"
table
[ "eos_person" ]
drvd_select
eos_person.p_login_time_min
fieldset
"login"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
p_register_state auto increment
Registrierungsstatus
TEXT (15)
R
yes
i18n_string
"ecs.PERSON.p_register_state"
table
[ "eos_person" ]
drvd_select
eos_person.p_register_state
fieldset
"login"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
p_register_code auto increment
Registrierungscode
TEXT (32)
R
yes
i18n_string
"ecs.PERSON.p_register_code"
table
[ "eos_person" ]
drvd_select
eos_person.p_register_code
fieldset
"login"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
p_register_code_timeout auto increment
Registrierungscode Timeout
DATETIME
R
yes
i18n_string
"ecs.PERSON.p_register_code_timeout"
table
[ "eos_person" ]
drvd_select
eos_person.p_register_code_timeout
fieldset
"login"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
p_onetime_pwd auto increment
Einmal-Passwort
TEXT
R
yes
i18n_string
"ecs.PERSON.p_onetime_pwd"
table
[ "eos_person" ]
drvd_select
eos_person.p_onetime_pwd
fieldset
"login"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
p_onetime_pwd_timeout auto increment
Einmal-Passwort Timeout
DATETIME
R
yes
i18n_string
"ecs.PERSON.p_onetime_pwd_timeout"
table
[ "eos_person" ]
drvd_select
eos_person.p_onetime_pwd_timeout
fieldset
"login"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
p_login_state auto increment
Login Status
TEXT (15)
R
no
enum
[ "possible", "disabled", "suspended", "retry" ]
i18n_string
"ecs.PERSON.p_login_state"
table
[ "eos_person" ]
drvd_select
IF(eos_person.p_login_active!=1, "disabled", IF(eos_person.p_login_err_count>0 ,IF(eos_person.p_login_time_min>NOW() ,"suspended","retry"),"possible"))
listCfg
{
    "viewMode": 0,
    "formatter": {
        "type": "status",
        "params": {
            "statusColorField": "p_login_state_color"
        }
    },
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
p_login_state_color auto increment
TEXT (15)
R
yes
i18n_string
"ecs.PERSON.p_login_state_color"
table
[ "eos_person" ]
drvd_select
IF(eos_person.p_login_active!=1, "#CCCCCC", IF(eos_person.p_login_err_count>0 ,IF(eos_person.p_login_time_min>NOW() ,"#CE0002","#EEAB00"),"#85B200"))
listCfg
{
    "viewMode": 0,
    "formatter": {
        "type": "color-code"
    },
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
p_oo_set_labelorderoptionset.oo_set_label auto increment
Bestelloptionen-Profil
TEXT (63)
R
no
i18n_string
"ecs.PERSON.p_oo_set_label"
table
[ "eos_person" ]
drvd_select
eos_person.p_oo_set_label
fieldset
"order_options"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
fk_p_pay_profile_idpayment_profile.pay_profile_id auto increment
Zahlungsziel-Profil
INT (11)
R
yes
i18n_string
"ecs.PERSON.fk_p_pay_profile_id"
table
[ "eos_person" ]
drvd_select
eos_person.fk_p_pay_profile_id
fieldset
"order_options"
listCfg
{
    "viewMode": 3,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
fk_p_prcgrp_idprice_group.prcgrp_id auto increment
Preisgruppe
INT (11)
R
yes
input_translated
Eine hier eingetragene Preisgruppe hat Vorrang vor den Preisgruppen-Einstellungen der Kundengruppe und auch den direkt im Produkt gesetzten Staffelpreisen.
i18n_string
"ecs.PERSON.fk_p_prcgrp_id"
table
[ "eos_person" ]
drvd_select
eos_person.fk_p_prcgrp_id
fieldset
"order_options"
listCfg
{
    "viewMode": 3,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
p_price_factor auto increment
Preis-Faktor
FLOAT (10,4)
R
yes
input_translated
Der angegebene Faktor wird bei allen für den Kunden angezeigten Standard-Preisen als Multiplikator verwendet. Ein eventuell für die zugehörige Kundengruppe angegebener Preis-Faktor wird durch einen speziell für den Kunden gesetzten Preisfaktor (!= 1) ersetzt.
i18n_string
"ecs.PERSON.p_price_factor"
table
[ "eos_person" ]
drvd_select
eos_person.p_price_factor
fieldset
"order_options"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
p_person_prices auto increment
Persönliche Preise
INT (1)
R
no
i18n_string
"ecs.PERSON.p_person_prices"
table
[ "eos_person" ]
drvd_select
eos_person.p_person_prices
fieldset
"order_options"
listCfg
{
    "formatter": {
        "type": "active-flag"
    },
    "width": 64,
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "checkbox",
    "editMode": 0
}
fk_p_campidcampaign.campid auto increment
Kampagne
INT (11)
R
yes
i18n_string
"ecs.PERSON.fk_p_campid"
table
[ "eos_person" ]
drvd_select
eos_person.fk_p_campid
fieldset
"marketing"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
p_allow_email_marketing auto increment
Zustimmung zu Marketing-Mails
INT (1)
R
no
i18n_string
"ecs.PERSON.p_allow_email_marketing"
table
[ "eos_person" ]
drvd_select
eos_person.p_allow_email_marketing
fieldset
"marketing"
listCfg
{
    "formatter": {
        "type": "active-flag"
    },
    "width": 64,
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "checkbox",
    "editMode": 0
}
drvd_emailmarketing_unsubscribetoken auto increment
Token für Direktabmeldung Marketingmails
TEXT
R
no
i18n_string
"ecs.PERSON.drvd_emailmarketing_unsubscribetoken"
table
[ "eos_person" ]
drvd_select
md5(CONCAT(eos_person.persid,'disallow',eos_person.personid,'emailmarketing',eos_person.time_insert))
fieldset
"marketing"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
p_ip_address auto increment
IP-Adresse
TEXT (15)
R
no
i18n_string
"ecs.PERSON.p_ip_address"
table
[ "eos_person" ]
drvd_select
eos_person.p_ip_address
fieldset
"registration"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
p_referrer auto increment
Referrer
TEXT
R
yes
i18n_string
"ecs.PERSON.p_referrer"
table
[ "eos_person" ]
drvd_select
eos_person.p_referrer
fieldset
"registration"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
p_useragent auto increment
User Agent
TEXT
R
yes
i18n_string
"ecs.PERSON.p_useragent"
table
[ "eos_person" ]
drvd_select
eos_person.p_useragent
fieldset
"registration"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
p_personid_external auto increment
Externe Kunden-Nr.
TEXT (127)
R
yes
input_translated
Eine externe Kunden-Nr. aus einem anderen System.
i18n_string
"ecs.PERSON.p_personid_external"
table
[ "eos_person" ]
drvd_select
eos_person.p_personid_external
fieldset
"external"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
p_comment_internal auto increment
Interner Kommentar
TEXT
R
yes
i18n_string
"ecs.PERSON.p_comment_internal"
table
[ "eos_person" ]
drvd_select
eos_person.p_comment_internal
fieldset
"extra"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
p_locale auto increment
Locale Kunde
DATA
R
yes
i18n_string
"ecs.PERSON.p_locale"
table
[ "eos_person" ]
drvd_select
eos_person.p_locale
fieldset
"extra"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
p_volfile auto increment
DATA
R
yes
i18n_string
"ecs.PERSON.p_volfile"
table
[ "eos_person" ]
drvd_select
NULL
fieldset
"documents"
listCfg
{
    "viewMode": 3,
    "fullSearch": false
}
formCfg
{
    "type": "hfyvolumefile",
    "options": {
        "vol_label": "person_documents",
        "vol_primKeyVar": "persid",
        "vol_primKey": null
    },
    "editMode": 0
}
time_insert auto increment
Angelegt am
DATETIME
R
no
i18n_string
"insert_time"
table
[ "eos_person" ]
drvd_select
eos_person.time_insert
fieldset
"sys_record"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
user_insert auto increment
Ersteller
TEXT (127)
R
yes
i18n_string
"insert_user"
table
[ "eos_person" ]
drvd_select
eos_person.user_insert
fieldset
"sys_record"
listCfg
{
    "formatter": {
        "type": "user"
    },
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
time_update auto increment
Geändert am
DATETIME
R
yes
i18n_string
"update_time"
table
[ "eos_person" ]
drvd_select
eos_person.time_update
fieldset
"sys_record"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
user_update auto increment
Letzte Änderung durch
TEXT (127)
R
yes
i18n_string
"update_user"
table
[ "eos_person" ]
drvd_select
eos_person.user_update
fieldset
"sys_record"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
drvd_timeonly_timeinsert auto increment
Angelegt (Uhrzeit)
TEXT
R
no
i18n_string
"ecs.PERSON.drvd_timeonly_timeinsert"
table
[ "eos_person" ]
drvd_select
DATE_FORMAT(eos_person.time_insert, '%H:%i')
fieldset
"analytics"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
p_anonymize_time auto increment
Anoymisiert am
DATETIME
R
yes
i18n_string
"ecs.PERSON.p_anonymize_time"
table
[ "eos_person" ]
drvd_select
eos_person.p_anonymize_time
fieldset
"sys_record"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
fk_p_companyaccount_parent_persidcompanyaccount.persid auto increment
Firmenaccount
INT
R
yes
input_translated
Verknüpfen Sie das Kundenkonto mit einem Firmenaccount. Das Kundenkonto wird damit zu einem Unteraccount des Firmenaccounts.
i18n_string
"ecs.plugin_companyaccount.fk_p_companyaccount_parent_persid"
table
[ "eos_person" ]
drvd_select
eos_person.fk_p_companyaccount_parent_persid
fieldset
"extra"
listCfg
{
    "viewMode": 3,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
p_companyaccount_budget_cart_max [EUR] auto increment
Budget Warenkorb
FLOAT (10,2)
R
yes
input_translated
Legen Sie hier den maximalen Netto-Warenkorb-Wert fest, der durch den Benutzer bestellt werden darf.
i18n_string
"ecs.plugin_companyaccount.p_companyaccount_budget_cart_max"
table
[ "eos_person" ]
drvd_select
eos_person.p_companyaccount_budget_cart_max
fieldset
"extra"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "eosnumber",
    "options": {
        "decimalsCalculate": 2,
        "decimalshowMin": 2,
        "decimalshowMax": 2
    },
    "editMode": 0
}
p_companyaccount_cost_center_customer auto increment
Kunden Kostenstelle
TEXT
R
yes
input_translated
Standard Kostenstelle des Kunden.
i18n_string
"ecs.plugin_companyaccount.p_companyaccount_cost_center_customer"
table
[ "eos_person" ]
drvd_select
eos_person.p_companyaccount_cost_center_customer
fieldset
"extra"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
p_companyaccount_type auto increment
TEXT
R
yes
i18n_string
"ecs.plugin_companyaccount.p_companyaccount_type"
table
[ "eos_person" ]
drvd_select
eos_person.p_companyaccount_type
fieldset
"extra"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "eosdropdown",
    "options": {
        "optI18nValuePrefix": "ecs.plugin_companyaccount.p_companyaccount_type",
        "optI18nName": true,
        "data": {
            "options": [
                {
                    "value": "company"
                },
                {
                    "value": "subaccount"
                }
            ]
        }
    },
    "editMode": 0
}
p_companyaccount_xdata auto increment
DATA
R
yes
i18n_string
"ecs.plugin_companyaccount.p_companyaccount_xdata"
table
[ "eos_person" ]
drvd_select
eos_person.p_companyaccount_xdata
fieldset
"extra"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "cssLayout": "col-12",
    "type": "aceeditor",
    "options": {
        "mode": "json"
    },
    "editMode": 0
}
p_accounting_debtor_account auto increment
Buchhaltung Debitorenkonto
TEXT
R
yes
input_translated
Tragen Sie hier das Debitorenkonto für diesen Kunden ein, welches im Buchungsstapel-Export verwendet werden soll.
i18n_string
"ecs.ecs_plugin_interface_accounting.p_accounting_debtor_account"
table
[ "eos_person" ]
drvd_select
eos_person.p_accounting_debtor_account
fieldset
"accounting"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
fk_pers_inv_reminder_profile auto increment
Mahnprofil
TEXT (127)
R
yes
i18n_string
"ecs.PERSON.fk_pers_inv_reminder_profile"
table
[ "eos_person" ]
drvd_select
eos_person.fk_pers_inv_reminder_profile
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
p_merchant_xdata auto increment
Anbieter (Zusatzdaten)
DATA
R
yes
input_translated
Geben Sie hier spezifische Informationen an, die für Anbieter relevant sein können (z.B. Kundennummer zu einem Anbieter).
i18n_string
"ecs.PERSON.p_merchant_xdata"
table
[ "eos_person" ]
drvd_select
eos_person.p_merchant_xdata
fieldset
"extra"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "cssLayout": "col-12",
    "type": "aceeditor",
    "options": {
        "mode": "json"
    },
    "editMode": 0
}
p_shopuserright_profiles auto increment
Benutzer-Rollen
TEXT
R
yes
input_translated
Wählen Sie hier die Benutzer-Rollen für den Kunden aus.
i18n_string
"ecs.plugin_shopuserright.p_shopuserright_profiles"
table
[ "eos_person" ]
drvd_select
eos_person.p_shopuserright_profiles
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
p_shopuserright_rights auto increment
Benutzer-Rechte
TEXT
R
yes
input_translated
Tragen Sie hier einzelne Benutzer-Rechte für den Kunden ein.
i18n_string
"ecs.plugin_shopuserright.p_shopuserright_rights"
table
[ "eos_person" ]
drvd_select
eos_person.p_shopuserright_rights
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
p_login_pwd_plain auto increment
Neues Passwort
TEXT (64)
R
yes
input_translated
Nur ausfüllen, wenn ein neues Passwort vergeben werden soll.
i18n_string
"ecs.PERSON.p_login_pwd_plain"
table
[ "eos_person" ]
drvd_select
NULL
fieldset
"login"
listCfg
{
    "viewMode": 3,
    "fullSearch": false
}
formCfg
{
    "editMode": 0,
    "type": "hfypassword",
    "options": {
        "reqs_dataStreamCall": {
            "method": "person_getPasswordRequirements"
        }
    }
}
drvd_order_timelast auto increment
Letzte Bestellung
DATETIME
R
no
i18n_string
"ecs.PERSON.drvd_order_timelast"
table
[ "eos_person" ]
drvd_select
eos_person.drvd_order_timelast
fieldset
"analytics"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
drvd_order_timefirst auto increment
Erste Bestellung
DATETIME
R
no
i18n_string
"ecs.PERSON.drvd_order_timefirst"
table
[ "eos_person" ]
drvd_select
eos_person.drvd_order_timefirst
fieldset
"analytics"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
drvd_order_frequency [d] auto increment
Bestell­frequenz
FLOAT (9,2)
R
no
i18n_string
"ecs.PERSON.drvd_order_frequency"
table
[ "eos_person" ]
drvd_select
eos_person.drvd_order_frequency
fieldset
"analytics"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
drvd_order_count auto increment
# Aufträge
INT (11)
R
no
i18n_string
"ecs.PERSON.drvd_order_count"
table
[ "eos_person" ]
drvd_select
eos_person.drvd_order_count
fieldset
"analytics"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
p_profile_photo auto increment
Bild
TEXT
R
yes
i18n_string
"ecs.PERSON.p_profile_photo"
table
[ "eos_person" ]
drvd_select
eos_person.p_profile_photo
fieldset
"profile"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}

persongroup

Following fields can also be selected for reading (JOIN)

grpid auto increment
INT (11)
R
no
i18n_string
"ecs.PERSONGRP.grpid"
table
[ "eos_person_group" ]
drvd_select
eos_person_group.grpid
fieldset
"base_record"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "hidden",
    "editMode": 0
}
grp_name auto increment
Kundengruppe
TEXT (127)
R
no
input_translated
Geben Sie einen aussagekräftigen Namen für die Kundengruppe ein.
i18n_string
"ecs.PERSONGRP.grp_name"
table
[ "eos_person_group" ]
drvd_select
eos_person_group.grp_name
fieldset
"base"
listCfg
{
    "viewMode": 0,
    "fullSearch": false,
    "depends_on": "fk_p_grpid"
}
formCfg
{
    "mandatory": 1,
    "editMode": 0
}
description auto increment
Beschreibung
TEXT
R
no
input_translated
Geben Sie eine Beschreibung der Kundengruppe ein (z.B. für WEN wurde sie angelegt)
i18n_string
"ecs.PERSONGRP.description"
table
[ "eos_person_group" ]
drvd_select
eos_person_group.description
fieldset
"base"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "textarea",
    "editMode": 0
}
grp_default auto increment
Default
INT (1)
R
no
input_translated
Aktivieren Sie die Checkbox, wenn diese Kundengruppe die Standardgruppe für alle Neuregistrierten Kunden sein soll. Diese werden dann automatisch zugeordnet.
i18n_string
"ecs.PERSONGRP.grp_default"
table
[ "eos_person_group" ]
drvd_select
eos_person_group.grp_default
fieldset
"register"
listCfg
{
    "formatter": {
        "type": "active-flag"
    },
    "width": 64,
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "checkbox",
    "editMode": 0
}
grp_p_login_active auto increment
Kundenlogin Default Aktiv
INT (1)
R
no
i18n_string
"ecs.PERSONGRP.grp_p_login_active"
table
[ "eos_person_group" ]
drvd_select
eos_person_group.grp_p_login_active
fieldset
"defaults_person"
listCfg
{
    "formatter": {
        "type": "active-flag"
    },
    "width": 64,
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "checkbox",
    "editMode": 0
}
grp_locale auto increment
Locale Kundengruppe
DATA
R
yes
i18n_string
"ecs.PERSONGRP.grp_locale"
table
[ "eos_person_group" ]
drvd_select
eos_person_group.grp_locale
fieldset
"defaults_person"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
grp_state auto increment
Bestellstatus
TEXT (63)
R
no
input_translated
Tragen Sie hier den Eingangsstatus für Bestellung von Kunden aus dieser Kundengruppe ein.
i18n_string
"ecs.PERSONGRP.grp_state"
table
[ "eos_person_group" ]
drvd_select
eos_person_group.grp_state
fieldset
"defaults_order"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
grp_pos auto increment
POS Channel
TEXT (63)
R
no
input_translated
Geben Sie hier den POS Channel an, für den diese Kundengruppe gelten soll. Lassen Sie dieses Feld leer, so steht die Kundengruppe in allen POS Channels zur Verfügung.
i18n_string
"ecs.PERSONGRP.grp_pos"
table
[ "eos_person_group" ]
drvd_select
eos_person_group.grp_pos
fieldset
"defaults_order"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
prc_display_mode auto increment
Preisanzeige
TEXT (15)
R
no
input_translated
Wählen Sie aus, ob die Preise im Shopfrontend für Kunden dieser Gruppe in brutto (also mit einberechneter Umsatzsteuer) oder netto (also ohne einberechnete Umsatzsteuer) angezeigt werden sollen.
i18n_string
"ecs.PERSONGRP.prc_display_mode"
table
[ "eos_person_group" ]
drvd_select
eos_person_group.prc_display_mode
fieldset
"prices"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "cssLayout": "col-12",
    "type": "eosdropdown",
    "options": {
        "optI18nValuePrefix": "ecs.prc_display_mode",
        "optI18nName": true,
        "optI18nSubTitle": true,
        "data": {
            "options": [
                {
                    "value": "brutto"
                },
                {
                    "value": "netto"
                }
            ]
        }
    },
    "editMode": 0
}
grp_price_factor auto increment
Preis-Faktor
FLOAT (10,4)
R
yes
input_translated
Der angegebene Faktor wird bei allen Standard-Shoppreisen als Multiplikator verwendet, wenn Mitglieder dieser Kundengruppe eingeloggt sind. Falls zusätzliche ein Preisfaktor für den Kunden gesetzt wurde oder ein spezifischer Standard-Preis für die Kundengruppe gesetzt ist, wird der Kundengruppen-Preisfaktor ignoriert.
i18n_string
"ecs.PERSONGRP.grp_price_factor"
table
[ "eos_person_group" ]
drvd_select
eos_person_group.grp_price_factor
fieldset
"prices"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "cssLayout": "col-12",
    "type": "eosnumber",
    "editMode": 0
}
fk_grp_prcgrp_idprice_group.prcgrp_id auto increment
Standard-Preisgruppe
INT (11)
R
yes
input_translated
Falls die gewählte Preisgruppen-Spalte bei einem Produkt nicht gefüllt ist, wird die hier eingetragene Preisgruppe verwendet
i18n_string
"ecs.PERSONGRP.fk_grp_prcgrp_id"
table
[ "eos_person_group" ]
drvd_select
eos_person_group.fk_grp_prcgrp_id
fieldset
"prices"
listCfg
{
    "viewMode": 3,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
grp_persongrp_prices auto increment
Gruppenspezifische Preise
INT (1)
R
no
i18n_string
"ecs.PERSONGRP.grp_persongrp_prices"
table
[ "eos_person_group" ]
drvd_select
eos_person_group.grp_persongrp_prices
fieldset
"orderoptions"
listCfg
{
    "formatter": {
        "type": "active-flag"
    },
    "width": 64,
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "checkbox",
    "editMode": 0
}
grp_price_col auto increment
Preisspalte
TEXT (31)
R
yes
input_translated
Geben Sie den Namen einer speziellen Preisspalte an, die für diese Kundengruppe gelten soll. Es werden passend dazu auch Spalten für Discountpreis und Discount-Start/Enddatum erzeugt. Wird dieses Feld nicht definiert, so werden die Standardpreisspalten verwendet.
i18n_string
"ecs.PERSONGRP.grp_price_col"
table
[ "eos_person_group" ]
drvd_select
eos_person_group.grp_price_col
fieldset
"price_col_cfg"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
grp_discount_col auto increment
Preisspalte (Discount)
TEXT (63)
R
yes
i18n_string
"ecs.PERSONGRP.grp_discount_col"
table
[ "eos_person_group" ]
drvd_select
IF(eos_person_group.grp_price_col IS NOT NULL, REPLACE(eos_person_group.grp_price_col,'price_','discount_'),null)
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
grp_discount_start_col auto increment
Preisspalte (Discount Start)
TEXT (63)
R
yes
i18n_string
"ecs.PERSONGRP.grp_discount_start_col"
table
[ "eos_person_group" ]
drvd_select
IF(eos_person_group.grp_price_col IS NOT NULL, REPLACE(eos_person_group.grp_price_col,'price_','discount_start_'),null)
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
grp_discount_end_col auto increment
Preisspalte (Discount Ende)
TEXT (63)
R
yes
i18n_string
"ecs.PERSONGRP.grp_discount_end_col"
table
[ "eos_person_group" ]
drvd_select
IF(eos_person_group.grp_price_col IS NOT NULL, REPLACE(eos_person_group.grp_price_col,'price_','discount_end_'),null)
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
grp_price_dsc_scale_col auto increment
Preisspalte (Staffelpreise)
TEXT (63)
R
no
i18n_string
"ecs.PERSONGRP.grp_price_dsc_scale_col"
table
[ "eos_person_group" ]
drvd_select
eos_person_group.grp_price_dsc_scale_col
fieldset
"price_col_cfg"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
grp_price_prcgrp_col auto increment
Preisgruppen-Spalte
TEXT (63)
R
no
input_translated
Legen Sie fest, welche Spalte in den Preisdaten die Preisgruppe für diese Kundengruppe enthält.
i18n_string
"ecs.PERSONGRP.grp_price_prcgrp_col"
table
[ "eos_person_group" ]
drvd_select
eos_person_group.grp_price_prcgrp_col
fieldset
"price_col_cfg"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
grp_price_state_col auto increment
Spalte für Shop-Status
TEXT (63)
R
no
i18n_string
"ecs.PERSONGRP.grp_price_state_col"
table
[ "eos_person_group" ]
drvd_select
eos_person_group.grp_price_state_col
fieldset
"price_col_cfg"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
grp_price_hide_price_dsp_col auto increment
Spalte für Preis ausblenden
TEXT (63)
R
no
i18n_string
"ecs.PERSONGRP.grp_price_hide_price_dsp_col"
table
[ "eos_person_group" ]
drvd_select
eos_person_group.grp_price_hide_price_dsp_col
fieldset
"price_col_cfg"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
grp_oo_set_labelorderoptionset.oo_set_label auto increment
Bestelloptionen-Profil
TEXT (63)
R
no
input_translated
Geben Sie das Label des Bestelloptionen-Profils an, dass Sie verwenden möchten. Lassen Sie dieses Feld leer, wenn Sie das Standard-Profil nutzen wollen.
i18n_string
"ecs.PERSONGRP.grp_oo_set_label"
table
[ "eos_person_group" ]
drvd_select
eos_person_group.grp_oo_set_label
fieldset
"orderoptions"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
fk_grp_pay_profile_idpayment_profile.pay_profile_id auto increment
Zahlungsziel-Profil
INT (11)
R
yes
i18n_string
"ecs.PERSONGRP.fk_grp_pay_profile_id"
table
[ "eos_person_group" ]
drvd_select
eos_person_group.fk_grp_pay_profile_id
fieldset
"orderoptions"
listCfg
{
    "viewMode": 3,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
data auto increment
Daten
DATA
R
yes
input_translated
Geben Sie hier zusätzliche Daten als Array an.

array(
'var1' => 'wert1',
'var2' => 'wert2',
)
i18n_string
"ecs.PERSONGRP.data"
table
[ "eos_person_group" ]
drvd_select
eos_person_group.data
fieldset
"extra"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "cssLayout": "col-12",
    "type": "aceeditor",
    "options": {
        "mode": "json"
    },
    "editMode": 0
}
grp_shopuserright_profiles auto increment
Gruppen-Rollen
TEXT
R
yes
input_translated
Wählen Sie hier die Benutzer-Rollen für die Kundengruppen aus.
i18n_string
"ecs.plugin_shopuserright.grp_shopuserright_profiles"
table
[ "eos_person_group" ]
drvd_select
eos_person_group.grp_shopuserright_profiles
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
grp_shopuserright_rights auto increment
Gruppen-Rechte
TEXT
R
yes
input_translated
Tragen Sie hier einzelne Benutzer-Rechte für die Kundengruppe ein.
i18n_string
"ecs.plugin_shopuserright.grp_shopuserright_rights"
table
[ "eos_person_group" ]
drvd_select
eos_person_group.grp_shopuserright_rights
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}