Model fields

The model consists of the following fields.

Field Name
Display Name
Type
Permissions
Nullable

paddress

adr_id primary auto increment
Adr.Id
INT (11)
R+W
no
fieldset
"base_record"
formCfg
{
    "type": "hidden"
}
adr_ref_id → person.persid
Kundennummer
INT (11)
R+W
yes
fieldset
"base_record"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "cssLayout": "col-6"
}
drvd_adr_key primaryDisplay
Adresse
TEXT
R
no
drvd_select
COALESCE(eos_addressbook.adr_street,eos_addressbook.adr_company,eos_addressbook.adr_lastname,eos_addressbook.adr_ref_type)
listCfg
{
    "width": 160,
    "formatter": {
        "type": "model-primary",
        "params": {
            "model": "paddress",
            "primaryKey": "adr_id",
            "subTitleTemplate": "{%adr_country%} - {%adr_zip%} {%adr_town%}"
        }
    }
}
formCfg
{
    "editMode": 0
}
adr_ref_type
Typ
TEXT (31)
R+W
yes
fieldset
"base_record"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "cssLayout": "col-6",
    "type": "eosdropdown",
    "options": {
        "optI18nValuePrefix": "ecs.adresstype",
        "optI18nName": true,
        "data": {
            "options": [
                {
                    "value": "person_invoice_default"
                },
                {
                    "value": "person_invoice"
                },
                {
                    "value": "person_delivery_default"
                },
                {
                    "value": "person_delivery"
                },
                {
                    "value": "person_other"
                }
            ]
        }
    }
}
adr_gender
Anrede
TEXT
R+W
yes
enum
[ "female", "male", "company", "divers" ]
valueColorField
"adr_gender_color"
fieldset
"base"
listCfg
{
    "width": 96
}
formCfg
{
    "cssLayout": "col-6",
    "type": "eosdropdown",
    "options": {
        "optI18nValuePrefix": "ecs.gender",
        "optI18nName": true,
        "data": {
            "options": [
                {
                    "value": "female"
                },
                {
                    "value": "male"
                },
                {
                    "value": "company"
                },
                {
                    "value": "divers"
                }
            ]
        }
    }
}
adr_gender_color
TEXT (15)
R
yes
drvd_select
CASE eos_addressbook.adr_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
}
adr_title
Titel
TEXT
R+W
yes
fieldset
"base"
listCfg
{
    "width": 96,
    "viewMode": 0,
    "fullSearch": true
}
formCfg
{
    "cssLayout": "col-6",
    "type": "eosdropdown",
    "options": {
        "addTag": true,
        "optValueField": "title",
        "optNameField": "title",
        "dataStreamCall": {
            "method": "datahub_generate_reportList",
            "params": {
                "ds_label": "person",
                "field_groupby": [
                    {
                        "field": "title"
                    }
                ]
            }
        }
    }
}
adr_firstname
Vorname
TEXT
R+W
yes
fieldset
"base"
listCfg
{
    "width": 128
}
formCfg
{
    "cssLayout": "col-6"
}
adr_lastname
Nachname
TEXT
R+W
yes
fieldset
"base"
listCfg
{
    "width": 128
}
formCfg
{
    "cssLayout": "col-6"
}
adr_company
Firma
TEXT
R+W
yes
fieldset
"addr"
formCfg
{
    "cssLayout": "col-12"
}
adr_extra1
Adressenzusatz
TEXT
R+W
yes
fieldset
"addr"
formCfg
{
    "cssLayout": "col-12"
}
adr_street
Straße
TEXT
R+W
yes
fieldset
"addr"
listCfg
{
    "width": 96
}
formCfg
{
    "cssLayout": "col-9"
}
adr_housenr
Hausnr.
TEXT
R+W
yes
fieldset
"addr"
listCfg
{
    "width": 64
}
formCfg
{
    "cssLayout": "col-3"
}
adr_zip
PLZ
TEXT
R+W
yes
fieldset
"addr"
listCfg
{
    "width": 64
}
formCfg
{
    "cssLayout": "col-4"
}
adr_town
Ort
TEXT
R+W
yes
fieldset
"addr"
listCfg
{
    "width": 96
}
formCfg
{
    "cssLayout": "col-8"
}
adr_state_code
Bundesland (Code)
TEXT (15)
R+W
yes
fieldset
"addr"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "cssLayout": "col-6",
    "type": "eosdropdown",
    "options": {
        "serverSideSearch": false,
        "optValueField": "terr_code",
        "optNameField": "terr_name",
        "optExtraField": "terr_code",
        "observer": {
            "fields": [
                {
                    "field": "adr_country",
                    "trigger": "onInit",
                    "exec": [
                        {
                            "cmd": "loadOptions",
                            "params": {
                                "dataStreamCall": {
                                    "method": "state_getlist",
                                    "params": {
                                        "filter": {
                                            "state_country": "{%FIELD.value%}"
                                        }
                                    }
                                }
                            }
                        }
                    ]
                },
                {
                    "field": "adr_country",
                    "trigger": "onChange",
                    "exec": [
                        {
                            "cmd": "loadOptions",
                            "params": {
                                "dataStreamCall": {
                                    "method": "state_getlist",
                                    "params": {
                                        "filter": {
                                            "state_country": "{%FIELD.value%}"
                                        }
                                    }
                                }
                            }
                        }
                    ]
                }
            ]
        }
    }
}
adr_country → country.cy_iso
Land
TEXT (3)
R+W
yes
fieldset
"addr"
listCfg
{
    "full_search": true,
    "formatter": {
        "type": "country-flag"
    }
}
formCfg
{
    "cssLayout": "col-6"
}
drvd_adr_address
Adresse
TEXT
R
no
drvd_select
CONCAT(
    						IF (eos_addressbook.adr_company IS NOT NULL, CONCAT(eos_addressbook.adr_company,CHAR(13)),""),
							IF (eos_addressbook.adr_lastname IS NOT NULL, CONCAT_WS(" ",eos_addressbook.adr_title,eos_addressbook.adr_firstname,eos_addressbook.adr_lastname,CHAR(13)),""),
							IF (eos_addressbook.adr_extra1 IS NOT NULL, CONCAT(eos_addressbook.adr_extra1,CHAR(13)),""),
							IF (eos_addressbook.adr_street IS NOT NULL, CONCAT_WS(" ",eos_addressbook.adr_street,eos_addressbook.adr_housenr,CHAR(13)),""),
							IF (eos_addressbook.adr_street IS NOT NULL, CONCAT(eos_addressbook.adr_country," - "),""),
    						IF (eos_addressbook.adr_zip IS NOT NULL,eos_addressbook.adr_zip,"")," ",
    						IF (eos_addressbook.adr_town IS NOT NULL,eos_addressbook.adr_town,""))
listCfg
{
    "viewMode": 0
}
adr_time_insert
Angelegt am
DATETIME
R+W
no
i18n_string
"insert_time"
fieldset
"sys_record"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "editMode": 2
}
adr_time_update
Geändert am
DATETIME
R+W
yes
i18n_string
"update_time"
fieldset
"sys_record"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "editMode": 2
}
drvd_adr_state_name
Bundesland
TEXT
R
no
table
[ "adress_terr_state" ]
drvd_select
adress_terr_state.terr_name
listCfg
{
    "viewMode": 0
}
formCfg
{
    "editMode": 0
}
drvd_adr_state_path
Bundesland (Pfad)
TEXT
R
no
table
[ "adress_terr_state" ]
drvd_select
adress_terr_state.i18n_node_path_DE
listCfg
{
    "viewMode": 0
}
formCfg
{
    "editMode": 0
}

person

Following fields can also be selected for reading (JOIN)

personid
Kunden-Nr.
TEXT (32)
R
no
table
[ "eos_person" ]
persid
Kunde
INT (11)
R
no
table
[ "eos_person" ]
listCfg
{
    "viewMode": 0
}
fk_p_grpid → persongroup.grpid
Kundengruppe
INT (11)
R
no
i18n_string
"ecs.PERSON.fk_p_grpid"
table
[ "eos_person" ]
fieldset
"base_record"
listCfg
{
    "viewMode": 3
}
formCfg
{
    "cssLayout": "col-6",
    "editMode": 0
}
fk_p_shopid → shopconfig.eshopid
Shop
INT (11)
R
yes
i18n_string
"ecs.PERSON.fk_p_shopid"
table
[ "eos_person" ]
listCfg
{
    "viewMode": 3
}
formCfg
{
    "editMode": 0
}
gender
Anrede
TEXT
R
yes
enum
[ "female", "male", "company", "divers" ]
i18n_string
"ecs.PERSON.gender"
valueColorField
"gender_color"
table
[ "eos_person" ]
fieldset
"base"
listCfg
{
    "width": 96,
    "viewMode": 3
}
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
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
}
formCfg
{
    "editMode": 0
}
title
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" ]
fieldset
"base"
listCfg
{
    "width": 96,
    "viewMode": 3
}
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
Anrede formal
TEXT
R
no
i18n_string
"ecs.PERSON.salutation"
table
[ "eos_person" ]
fieldset
"base"
listCfg
{
    "viewMode": 3,
    "fullSearch": true
}
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
Vorname
TEXT
R
no
input_translated
Vorname der Registrierungsadresse.
i18n_string
"ecs.PERSON.firstname"
table
[ "eos_person" ]
fieldset
"base"
listCfg
{
    "width": 128,
    "viewMode": 3
}
formCfg
{
    "cssLayout": "col-6",
    "editMode": 0
}
lastname
Nachname
TEXT
R
no
i18n_string
"ecs.PERSON.lastname"
table
[ "eos_person" ]
fieldset
"base"
listCfg
{
    "width": 128,
    "viewMode": 3
}
formCfg
{
    "cssLayout": "col-6",
    "editMode": 0
}
bday
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" ]
fieldset
"base"
listCfg
{
    "viewMode": 3
}
formCfg
{
    "type": "datepicker",
    "options": {
        "showWeekdays": false,
        "showWeekNumbers": false,
        "minDate": {
            "day": 1,
            "month": 1,
            "year": "1900"
        }
    },
    "editMode": 0
}
drvd_age [y]
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": 3
}
formCfg
{
    "editMode": 0
}
drvd_bday_days_until_next [d]
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": 3
}
formCfg
{
    "editMode": 0
}
drvd_bday_next
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": 3
}
formCfg
{
    "editMode": 0
}
company
Firma
TEXT
R
no
i18n_string
"ecs.PERSON.company"
table
[ "eos_person" ]
fieldset
"addr"
listCfg
{
    "viewMode": 3
}
formCfg
{
    "cssLayout": "col-4",
    "editMode": 0
}
p_department
Abteilung
TEXT
R
no
i18n_string
"ecs.PERSON.p_department"
table
[ "eos_person" ]
fieldset
"addr"
listCfg
{
    "viewMode": 3
}
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
Position
TEXT
R
no
i18n_string
"ecs.PERSON.p_job_position"
table
[ "eos_person" ]
fieldset
"addr"
listCfg
{
    "viewMode": 3
}
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
Adressenzusatz
TEXT
R
no
i18n_string
"ecs.PERSON.address2"
table
[ "eos_person" ]
fieldset
"addr"
listCfg
{
    "viewMode": 3
}
formCfg
{
    "cssLayout": "col-12",
    "editMode": 0
}
street
Straße
TEXT
R
no
i18n_string
"ecs.PERSON.street"
table
[ "eos_person" ]
fieldset
"addr"
listCfg
{
    "width": 96,
    "viewMode": 3
}
formCfg
{
    "cssLayout": "col-9",
    "editMode": 0
}
housenr
Hausnummer
TEXT
R
no
i18n_string
"ecs.PERSON.housenr"
table
[ "eos_person" ]
fieldset
"addr"
listCfg
{
    "width": 64,
    "viewMode": 3
}
formCfg
{
    "cssLayout": "col-3",
    "editMode": 0
}
zip
PLZ
TEXT
R
no
i18n_string
"ecs.PERSON.zip"
table
[ "eos_person" ]
fieldset
"addr"
listCfg
{
    "width": 64,
    "viewMode": 3
}
formCfg
{
    "cssLayout": "col-4",
    "editMode": 0
}
town
Ort
TEXT
R
no
i18n_string
"ecs.PERSON.town"
table
[ "eos_person" ]
fieldset
"addr"
listCfg
{
    "width": 96,
    "viewMode": 3
}
formCfg
{
    "cssLayout": "col-8",
    "editMode": 0
}
state_code
Bundesland (Code)
TEXT (15)
R
yes
i18n_string
"ecs.PERSON.state_code"
table
[ "eos_person" ]
fieldset
"addr"
listCfg
{
    "viewMode": 3
}
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
}
country → country.cy_iso
Land
TEXT (2)
R
no
i18n_string
"ecs.PERSON.country"
table
[ "eos_person" ]
fieldset
"addr"
listCfg
{
    "viewMode": 3,
    "width": 64,
    "formatter": {
        "type": "country-flag"
    }
}
formCfg
{
    "cssLayout": "col-6",
    "editMode": 0
}
drvd_person_name
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": 3
}
formCfg
{
    "editMode": 0
}
drvd_p_address
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": 3
}
formCfg
{
    "editMode": 0
}
email
E-Mail
TEXT (127)
R
no
i18n_string
"ecs.PERSON.email"
table
[ "eos_person" ]
fieldset
"communication"
listCfg
{
    "width": 256,
    "viewMode": 3
}
formCfg
{
    "type": "hfyemail",
    "cssLayout": "col-6",
    "editMode": 0
}
telephone
Telefon
TEXT
R
no
i18n_string
"ecs.PERSON.telephone"
table
[ "eos_person" ]
fieldset
"communication"
listCfg
{
    "viewMode": 3
}
formCfg
{
    "type": "hfyphone",
    "cssLayout": "col-6",
    "editMode": 0
}
telephone_mobile
Tel. mobil
TEXT
R
no
i18n_string
"ecs.PERSON.telephone_mobile"
table
[ "eos_person" ]
fieldset
"communication"
listCfg
{
    "viewMode": 3
}
formCfg
{
    "type": "hfyphone",
    "cssLayout": "col-6",
    "editMode": 0
}
telefax
Fax
TEXT
R
no
i18n_string
"ecs.PERSON.telefax"
table
[ "eos_person" ]
fieldset
"communication"
listCfg
{
    "viewMode": 3
}
formCfg
{
    "type": "hfyphone",
    "cssLayout": "col-6",
    "editMode": 0
}
p_invoice_type
Rechnungsart
TEXT
R
yes
i18n_string
"ecs.PERSON.p_invoice_type"
table
[ "eos_person" ]
fieldset
"commercial"
listCfg
{
    "viewMode": 3
}
formCfg
{
    "type": "eosdropdown",
    "options": {
        "optI18nValuePrefix": "ecs.invoice_type",
        "optI18nName": true,
        "data": {
            "options": [
                {
                    "value": "noncommercial"
                },
                {
                    "value": "commercial"
                }
            ]
        }
    },
    "editMode": 0
}
p_invoice_email
E-Mail (Rechnung)
TEXT
R
no
i18n_string
"ecs.PERSON.p_invoice_email"
table
[ "eos_person" ]
fieldset
"commercial"
listCfg
{
    "viewMode": 3
}
formCfg
{
    "type": "hfyemail",
    "editMode": 0
}
taxident
Umsatzsteuer-ID
TEXT
R
no
i18n_string
"ecs.PERSON.taxident"
table
[ "eos_person" ]
fieldset
"commercial"
listCfg
{
    "viewMode": 3
}
formCfg
{
    "editMode": 0
}
taxident_status
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" ]
fieldset
"commercial"
listCfg
{
    "viewMode": 3,
    "formatter": {
        "type": "status"
    }
}
formCfg
{
    "type": "eosdropdown",
    "options": {
        "optI18nValuePrefix": "ecs.taxident_status",
        "optI18nName": true,
        "data": {
            "options": [
                {
                    "value": null
                },
                {
                    "value": "invalid"
                },
                {
                    "value": "valid_conditional"
                },
                {
                    "value": "valid_confirmed"
                }
            ]
        }
    },
    "editMode": 0
}
score
Bonitätswert
INT (7)
R
no
i18n_string
"ecs.PERSON.score"
table
[ "eos_person" ]
fieldset
"credit_rating"
listCfg
{
    "viewMode": 3,
    "sumType": "AVG"
}
formCfg
{
    "editMode": 0
}
score_time_set
Letzter Rating-Check
DATETIME
R
yes
i18n_string
"ecs.PERSON.score_time_set"
table
[ "eos_person" ]
fieldset
"credit_rating"
listCfg
{
    "viewMode": 3
}
formCfg
{
    "editMode": 0
}
score_time_invalid
Abgelaufen am
DATETIME
R
yes
i18n_string
"ecs.PERSON.score_time_invalid"
table
[ "eos_person" ]
fieldset
"credit_rating"
listCfg
{
    "viewMode": 3
}
formCfg
{
    "editMode": 0
}
svc_code
Rating ServiceCode
TEXT
R
yes
i18n_string
"ecs.PERSON.svc_code"
table
[ "eos_person" ]
fieldset
"credit_rating"
listCfg
{
    "viewMode": 3
}
formCfg
{
    "editMode": 0
}
svc_txt
Rating ServiceText
TEXT
R
yes
i18n_string
"ecs.PERSON.svc_txt"
table
[ "eos_person" ]
fieldset
"credit_rating"
listCfg
{
    "viewMode": 3
}
formCfg
{
    "editMode": 0
}
p_login_username
Benutzername
TEXT (63)
R
yes
i18n_string
"ecs.PERSON.p_login_username"
table
[ "eos_person" ]
fieldset
"login"
listCfg
{
    "viewMode": 3
}
formCfg
{
    "editMode": 0
}
p_login_pwd_encrypted
Passwort (verschlüsselt)
TEXT
R
yes
i18n_string
"ecs.PERSON.p_login_pwd_encrypted"
table
[ "eos_person" ]
fieldset
"login"
listCfg
{
    "viewMode": 3
}
formCfg
{
    "editMode": 0
}
p_login_pwd_key
Direct-Login-Token
TEXT
R
yes
i18n_string
"ecs.PERSON.p_login_pwd_key"
table
[ "eos_person" ]
fieldset
"login"
listCfg
{
    "viewMode": 3
}
formCfg
{
    "editMode": 0
}
p_login_time_last
Letzter Login
DATETIME
R
yes
i18n_string
"ecs.PERSON.p_login_time_last"
table
[ "eos_person" ]
fieldset
"login"
listCfg
{
    "viewMode": 3
}
formCfg
{
    "editMode": 0
}
p_login_pwd_must_renew_after
Passwort-Änderung auffordern ab
DATETIME
R
yes
i18n_string
"ecs.PERSON.p_login_pwd_must_renew_after"
table
[ "eos_person" ]
fieldset
"login"
listCfg
{
    "viewMode": 3
}
formCfg
{
    "type": "datetimepicker",
    "editMode": 0
}
p_login_pwd_key_timeout
Direct-Login-Token Timeout
DATETIME
R
yes
i18n_string
"ecs.PERSON.p_login_pwd_key_timeout"
table
[ "eos_person" ]
fieldset
"login"
listCfg
{
    "viewMode": 3
}
formCfg
{
    "editMode": 0
}
p_login_pwd_last_renewed
Passwort zuletzt geändert
DATETIME
R
yes
i18n_string
"ecs.PERSON.p_login_pwd_last_renewed"
table
[ "eos_person" ]
fieldset
"login"
listCfg
{
    "viewMode": 3
}
formCfg
{
    "editMode": 0
}
p_login_active
Aktiv
INT (1)
R
no
i18n_string
"ecs.PERSON.p_login_active"
table
[ "eos_person" ]
fieldset
"login"
listCfg
{
    "formatter": {
        "type": "active-flag"
    },
    "width": 64,
    "viewMode": 3
}
formCfg
{
    "type": "checkbox",
    "editMode": 0
}
p_email_verify_token
TEXT (32)
R
yes
i18n_string
"ecs.PERSON.p_email_verify_token"
table
[ "eos_person" ]
fieldset
"login"
listCfg
{
    "viewMode": 3
}
formCfg
{
    "editMode": 0
}
p_email_verify_token_timeout
DATETIME
R
yes
i18n_string
"ecs.PERSON.p_email_verify_token_timeout"
table
[ "eos_person" ]
fieldset
"login"
listCfg
{
    "viewMode": 3
}
formCfg
{
    "editMode": 0
}
p_email_verified_time
DATETIME
R
yes
i18n_string
"ecs.PERSON.p_email_verified_time"
table
[ "eos_person" ]
fieldset
"login"
listCfg
{
    "viewMode": 3
}
formCfg
{
    "editMode": 0
}
p_login_mode
Login-Modus
TEXT (15)
R
yes
enum
[ "simple", "2fa_email" ]
i18n_string
"ecs.PERSON.p_login_mode"
table
[ "eos_person" ]
fieldset
"login"
listCfg
{
    "viewMode": 3
}
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
2FA - Login Code
TEXT
R
yes
i18n_string
"ecs.PERSON.p_login_2fa_code"
table
[ "eos_person" ]
fieldset
"login"
listCfg
{
    "viewMode": 3
}
formCfg
{
    "editMode": 0
}
p_login_2fa_timeout
2FA - Login Code Timeout
DATETIME
R
yes
i18n_string
"ecs.PERSON.p_login_2fa_timeout"
table
[ "eos_person" ]
fieldset
"login"
listCfg
{
    "viewMode": 3
}
formCfg
{
    "editMode": 0
}
p_login_err_count
Anzahl Fehllogins
INT (4)
R
no
i18n_string
"ecs.PERSON.p_login_err_count"
table
[ "eos_person" ]
fieldset
"login"
listCfg
{
    "viewMode": 3
}
formCfg
{
    "editMode": 0
}
p_login_time_min
Login Sperrzeit
DATETIME
R
yes
i18n_string
"ecs.PERSON.p_login_time_min"
table
[ "eos_person" ]
fieldset
"login"
listCfg
{
    "viewMode": 3
}
formCfg
{
    "editMode": 0
}
p_register_state
Registrierungsstatus
TEXT (15)
R
yes
i18n_string
"ecs.PERSON.p_register_state"
table
[ "eos_person" ]
fieldset
"login"
listCfg
{
    "viewMode": 3
}
formCfg
{
    "editMode": 0
}
p_register_code
Registrierungscode
TEXT (32)
R
yes
i18n_string
"ecs.PERSON.p_register_code"
table
[ "eos_person" ]
fieldset
"login"
listCfg
{
    "viewMode": 3
}
formCfg
{
    "editMode": 0
}
p_register_code_timeout
Registrierungscode Timeout
DATETIME
R
yes
i18n_string
"ecs.PERSON.p_register_code_timeout"
table
[ "eos_person" ]
fieldset
"login"
listCfg
{
    "viewMode": 3
}
formCfg
{
    "editMode": 0
}
p_onetime_pwd
Einmal-Passwort
TEXT
R
yes
i18n_string
"ecs.PERSON.p_onetime_pwd"
table
[ "eos_person" ]
fieldset
"login"
listCfg
{
    "viewMode": 3
}
formCfg
{
    "editMode": 0
}
p_onetime_pwd_timeout
Einmal-Passwort Timeout
DATETIME
R
yes
i18n_string
"ecs.PERSON.p_onetime_pwd_timeout"
table
[ "eos_person" ]
fieldset
"login"
listCfg
{
    "viewMode": 3
}
formCfg
{
    "editMode": 0
}
p_login_state
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": 3,
    "formatter": {
        "type": "status",
        "params": {
            "statusColorField": "p_login_state_color"
        }
    }
}
formCfg
{
    "editMode": 0
}
p_login_state_color
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": 3,
    "formatter": {
        "type": "color-code"
    }
}
formCfg
{
    "editMode": 0
}
p_oo_set_label → orderoptionset.oo_set_label
Bestelloptionen-Profil
TEXT (63)
R
no
i18n_string
"ecs.PERSON.p_oo_set_label"
table
[ "eos_person" ]
fieldset
"order_options"
listCfg
{
    "viewMode": 3
}
formCfg
{
    "editMode": 0
}
fk_p_pay_profile_id → payment_profile.pay_profile_id
Zahlungsziel-Profil
INT (11)
R
yes
i18n_string
"ecs.PERSON.fk_p_pay_profile_id"
table
[ "eos_person" ]
fieldset
"order_options"
listCfg
{
    "viewMode": 3
}
formCfg
{
    "editMode": 0
}
fk_p_prcgrp_id → price_group.prcgrp_id
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" ]
fieldset
"order_options"
listCfg
{
    "viewMode": 3
}
formCfg
{
    "editMode": 0
}
p_price_factor
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" ]
fieldset
"order_options"
listCfg
{
    "viewMode": 3
}
formCfg
{
    "editMode": 0
}
p_person_prices
Persönliche Preise
INT (1)
R
no
i18n_string
"ecs.PERSON.p_person_prices"
table
[ "eos_person" ]
fieldset
"order_options"
listCfg
{
    "formatter": {
        "type": "active-flag"
    },
    "width": 64,
    "viewMode": 3
}
formCfg
{
    "type": "checkbox",
    "editMode": 0
}
fk_p_campid → campaign.campid
Kampagne
INT (11)
R
yes
i18n_string
"ecs.PERSON.fk_p_campid"
table
[ "eos_person" ]
fieldset
"marketing"
listCfg
{
    "viewMode": 3
}
formCfg
{
    "editMode": 0
}
p_allow_email_marketing
Zustimmung zu Marketing-Mails
INT (1)
R
no
i18n_string
"ecs.PERSON.p_allow_email_marketing"
table
[ "eos_person" ]
fieldset
"marketing"
listCfg
{
    "formatter": {
        "type": "active-flag"
    },
    "width": 64,
    "viewMode": 3
}
formCfg
{
    "type": "checkbox",
    "editMode": 0
}
drvd_emailmarketing_unsubscribetoken
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": 3
}
formCfg
{
    "editMode": 0
}
p_ip_address
IP-Adresse
TEXT (15)
R
no
i18n_string
"ecs.PERSON.p_ip_address"
table
[ "eos_person" ]
fieldset
"registration"
listCfg
{
    "viewMode": 3
}
formCfg
{
    "editMode": 0
}
p_referrer
Referrer
TEXT
R
yes
i18n_string
"ecs.PERSON.p_referrer"
table
[ "eos_person" ]
fieldset
"registration"
listCfg
{
    "viewMode": 3
}
formCfg
{
    "editMode": 0
}
p_useragent
User Agent
TEXT
R
yes
i18n_string
"ecs.PERSON.p_useragent"
table
[ "eos_person" ]
fieldset
"registration"
listCfg
{
    "viewMode": 3
}
formCfg
{
    "editMode": 0
}
p_personid_external
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" ]
fieldset
"external"
listCfg
{
    "viewMode": 3,
    "fullSearch": true
}
formCfg
{
    "editMode": 0
}
p_comment_internal
Interner Kommentar
TEXT
R
yes
i18n_string
"ecs.PERSON.p_comment_internal"
table
[ "eos_person" ]
fieldset
"extra"
listCfg
{
    "viewMode": 3
}
formCfg
{
    "editMode": 0
}
p_locale
Locale Kunde
DATA
R
yes
i18n_string
"ecs.PERSON.p_locale"
table
[ "eos_person" ]
fieldset
"extra"
listCfg
{
    "viewMode": 3
}
formCfg
{
    "editMode": 0
}
p_volfile
DATA
R
yes
i18n_string
"ecs.PERSON.p_volfile"
table
[ "eos_person" ]
drvd_select
NULL
fieldset
"documents"
listCfg
{
    "viewMode": 3
}
formCfg
{
    "type": "hfyvolumefile",
    "options": {
        "vol_label": "person_documents",
        "vol_primKeyVar": "persid",
        "vol_primKey": null
    },
    "editMode": 0
}
time_insert
Angelegt am
DATETIME
R
no
i18n_string
"insert_time"
table
[ "eos_person" ]
fieldset
"sys_record"
listCfg
{
    "viewMode": 3
}
formCfg
{
    "editMode": 0
}
user_insert
Ersteller
TEXT (127)
R
yes
i18n_string
"insert_user"
table
[ "eos_person" ]
fieldset
"sys_record"
listCfg
{
    "formatter": {
        "type": "user"
    },
    "viewMode": 3
}
formCfg
{
    "editMode": 0
}
time_update
Geändert am
DATETIME
R
yes
i18n_string
"update_time"
table
[ "eos_person" ]
fieldset
"sys_record"
listCfg
{
    "viewMode": 3
}
formCfg
{
    "editMode": 0
}
user_update
Letzte Änderung durch
TEXT (127)
R
yes
i18n_string
"update_user"
table
[ "eos_person" ]
fieldset
"sys_record"
listCfg
{
    "viewMode": 3
}
formCfg
{
    "editMode": 0
}
drvd_timeonly_timeinsert
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": 3
}
formCfg
{
    "editMode": 0
}
p_anonymize_time
Anoymisiert am
DATETIME
R
yes
i18n_string
"ecs.PERSON.p_anonymize_time"
table
[ "eos_person" ]
fieldset
"sys_record"
listCfg
{
    "viewMode": 3
}
formCfg
{
    "editMode": 0
}
fk_p_companyaccount_parent_persid → companyaccount.persid
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" ]
fieldset
"extra"
listCfg
{
    "viewMode": 3
}
formCfg
{
    "editMode": 0
}
p_companyaccount_budget_cart_max [EUR]
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" ]
fieldset
"extra"
listCfg
{
    "viewMode": 3
}
formCfg
{
    "type": "eosnumber",
    "options": {
        "decimalsCalculate": 2,
        "decimalshowMin": 2,
        "decimalshowMax": 2
    },
    "editMode": 0
}
p_companyaccount_cost_center_customer
Kunden Kostenstelle
TEXT
R
yes
input_translated
Standard Kostenstelle des Kunden.
i18n_string
"ecs.plugin_companyaccount.p_companyaccount_cost_center_customer"
table
[ "eos_person" ]
fieldset
"extra"
listCfg
{
    "viewMode": 3
}
formCfg
{
    "editMode": 0
}
p_companyaccount_type
TEXT
R
yes
i18n_string
"ecs.plugin_companyaccount.p_companyaccount_type"
table
[ "eos_person" ]
fieldset
"extra"
listCfg
{
    "viewMode": 3
}
formCfg
{
    "type": "eosdropdown",
    "options": {
        "optI18nValuePrefix": "ecs.plugin_companyaccount.p_companyaccount_type",
        "optI18nName": true,
        "data": {
            "options": [
                {
                    "value": "company"
                },
                {
                    "value": "subaccount"
                }
            ]
        }
    },
    "editMode": 0
}
p_companyaccount_xdata
DATA
R
yes
i18n_string
"ecs.plugin_companyaccount.p_companyaccount_xdata"
table
[ "eos_person" ]
fieldset
"extra"
listCfg
{
    "viewMode": 3
}
formCfg
{
    "cssLayout": "col-12",
    "type": "aceeditor",
    "options": {
        "mode": "json"
    },
    "editMode": 0
}
p_accounting_debtor_account
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" ]
fieldset
"accounting"
listCfg
{
    "viewMode": 3
}
formCfg
{
    "editMode": 0
}
fk_pers_inv_reminder_profile
Mahnprofil
TEXT (127)
R
yes
i18n_string
"ecs.PERSON.fk_pers_inv_reminder_profile"
table
[ "eos_person" ]
listCfg
{
    "viewMode": 3
}
formCfg
{
    "editMode": 0
}
drvd_pers_inv_reminder_profile_name
angewendetes Mahnprofil
TEXT (127)
R
yes
i18n_string
"ecs.PERSON.drvd_pers_inv_reminder_profile_name"
table
"ecs_invoice_reminder_profile"
drvd_select
ecs_invoice_reminder_profile.profile_name
listCfg
{
    "viewMode": 3
}
formCfg
{
    "editMode": 0
}
p_merchant_xdata
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" ]
fieldset
"extra"
listCfg
{
    "viewMode": 3
}
formCfg
{
    "cssLayout": "col-12",
    "type": "aceeditor",
    "options": {
        "mode": "json"
    },
    "editMode": 0
}
p_shopuserright_profiles
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" ]
listCfg
{
    "viewMode": 3
}
formCfg
{
    "editMode": 0
}
p_shopuserright_rights
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" ]
listCfg
{
    "viewMode": 3
}
formCfg
{
    "editMode": 0
}
p_login_pwd_plain
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
}
formCfg
{
    "editMode": 0,
    "type": "hfypassword",
    "options": {
        "reqs_dataStreamCall": {
            "method": "person_getPasswordRequirements"
        }
    }
}
campid
INT (11)
R
no
i18n_string
"ecs.PERSON.campid"
table
[ "eos_campaign" ]
drvd_select
eos_campaign.campid
fieldset
"marketing"
listCfg
{
    "viewMode": 3
}
formCfg
{
    "editMode": 0
}
drvd_order_timelast
Letzte Bestellung
DATETIME
R
no
i18n_string
"ecs.PERSON.drvd_order_timelast"
table
[ "eos_person" ]
fieldset
"analytics"
listCfg
{
    "viewMode": 3
}
formCfg
{
    "editMode": 0
}
drvd_order_timefirst
Erste Bestellung
DATETIME
R
no
i18n_string
"ecs.PERSON.drvd_order_timefirst"
table
[ "eos_person" ]
fieldset
"analytics"
listCfg
{
    "viewMode": 3
}
formCfg
{
    "editMode": 0
}
drvd_order_frequency [d]
Bestell­frequenz
FLOAT (9,2)
R
no
i18n_string
"ecs.PERSON.drvd_order_frequency"
table
[ "eos_person" ]
fieldset
"analytics"
listCfg
{
    "viewMode": 3
}
formCfg
{
    "editMode": 0
}
drvd_order_count
# Aufträge
INT (11)
R
no
i18n_string
"ecs.PERSON.drvd_order_count"
table
[ "eos_person" ]
fieldset
"analytics"
listCfg
{
    "viewMode": 3
}
formCfg
{
    "editMode": 0
}
p_profile_photo
Bild
TEXT
R
yes
i18n_string
"ecs.PERSON.p_profile_photo"
table
[ "eos_person" ]
fieldset
"profile"
listCfg
{
    "viewMode": 3
}
formCfg
{
    "editMode": 0
}
cy_locale
Locale Land
TEXT
R
no
i18n_string
"ecs.COUNTRY.cy_locale"
table
[ "person_country" ]
drvd_select
person_country.cy_locale
listCfg
{
    "viewMode": 3
}
formCfg
{
    "editMode": 0
}
drvd_person_state_name
Bundesland (Name)
TEXT
R
no
i18n_string
"ecs.PERSON.drvd_person_state_name"
table
[ "person_terr_state" ]
drvd_select
person_terr_state.terr_name
listCfg
{
    "viewMode": 3
}
formCfg
{
    "editMode": 0
}
drvd_person_state_path
Bundesland (Pfad)
TEXT
R
no
i18n_string
"ecs.PERSON.drvd_person_state_path"
table
[ "person_terr_state" ]
drvd_select
person_terr_state.i18n_node_path_DE
listCfg
{
    "viewMode": 3
}
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": 3,
    "fullSearch": false
}
formCfg
{
    "type": "hidden",
    "editMode": 0
}
grp_name
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": 3,
    "fullSearch": false,
    "depends_on": "fk_p_grpid"
}
formCfg
{
    "mandatory": 1,
    "editMode": 0
}
description
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": 3,
    "fullSearch": false
}
formCfg
{
    "type": "textarea",
    "editMode": 0
}
grp_default
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": 3,
    "fullSearch": false
}
formCfg
{
    "type": "checkbox",
    "editMode": 0
}
grp_p_login_active
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": 3,
    "fullSearch": false
}
formCfg
{
    "type": "checkbox",
    "editMode": 0
}
grp_locale
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": 3,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
grp_state
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": 3,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
grp_pos
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": 3,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
prc_display_mode
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": 3,
    "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
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": 3,
    "fullSearch": false
}
formCfg
{
    "cssLayout": "col-12",
    "type": "eosnumber",
    "editMode": 0
}
fk_grp_prcgrp_id → price_group.prcgrp_id
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
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": 3,
    "fullSearch": false
}
formCfg
{
    "type": "checkbox",
    "editMode": 0
}
grp_price_col
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": 3,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
grp_discount_col
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": 3,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
grp_discount_start_col
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": 3,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
grp_discount_end_col
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": 3,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
grp_price_dsc_scale_col
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": 3,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
grp_price_prcgrp_col
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": 3,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
grp_price_state_col
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": 3,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
grp_price_hide_price_dsp_col
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": 3,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
grp_oo_set_label → orderoptionset.oo_set_label
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": 3,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
fk_grp_pay_profile_id → payment_profile.pay_profile_id
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
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": 3,
    "fullSearch": false
}
formCfg
{
    "cssLayout": "col-12",
    "type": "aceeditor",
    "options": {
        "mode": "json"
    },
    "editMode": 0
}
grp_shopuserright_profiles
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": 3,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
grp_shopuserright_rights
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": 3,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}

campaign

Following fields can also be selected for reading (JOIN)

camp_name
Kampagne
TEXT (127)
R
no
i18n_string
"ecs.PERSON.camp_name"
table
[ "eos_campaign" ]
drvd_select
eos_campaign.camp_name
fieldset
"marketing"
listCfg
{
    "viewMode": 3
}
formCfg
{
    "editMode": 0
}