Model fields

The model consists of the following fields.

Field Name
Display Name
Type
Permissions
Nullable

price_person

prcpers_id primary auto increment
INT (11)
R+W
no
fieldset
"base_record"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "type": "hidden"
}
fk_prcpers_pcode → product.pcode primaryDisplay
Produktcode
TEXT (127)
R+W
no
fieldset
"base_record"
formCfg
{
    "mandatory": true,
    "cssLayout": "col-6"
}
fk_prcpers_persid → person.persid
Kunde
INT (11)
R+W
yes
fieldset
"base_record"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "mandatory": true,
    "cssLayout": "col-6"
}
fk_prcpers_shopid → shopconfig.eshopid
Shop
INT (11)
R+W
yes
fieldset
"sys_record"
listCfg
{
    "viewMode": 0
}
prcpers_price [EUR]
Brutto-Preis
FLOAT (13,2)
R+W
yes
fieldset
"price_base"
listCfg
{
    "formatter": {
        "type": "currency"
    }
}
formCfg
{
    "type": "hfyprice",
    "options": {
        "valueVatType": "brutto",
        "vatField": "vat",
        "sessionStatePresetId": "PIM__primaryPriceMode",
        "sessionStateId": "PIM__prd__price",
        "decimalsCalculate": 2,
        "decimalshowMin": 0,
        "decimalshowMax": 2,
        "observer": {
            "fields": [
                {
                    "field": "vat",
                    "trigger": "onChange",
                    "exec": [
                        {
                            "cmd": "setVat"
                        }
                    ]
                }
            ]
        }
    }
}
prcpers_discount [EUR]
Discountpreis
FLOAT (13,2)
R+W
yes
fieldset
"price_base"
listCfg
{
    "formatter": {
        "type": "currency"
    }
}
formCfg
{
    "type": "hfyprice",
    "options": {
        "valueVatType": "brutto",
        "vatField": "vat",
        "sessionStatePresetId": "PIM__primaryPriceMode",
        "sessionStateId": "PIM__prd__price",
        "decimalsCalculate": 2,
        "decimalshowMin": 0,
        "decimalshowMax": 2,
        "observer": {
            "fields": [
                {
                    "field": "vat",
                    "trigger": "onChange",
                    "exec": [
                        {
                            "cmd": "setVat"
                        }
                    ]
                }
            ]
        }
    }
}
prcpers_discount_start
Discount gültig ab
DATETIME
R+W
yes
fieldset
"price_base"
listCfg
{
    "viewMode": 0
}
prcpers_discount_end
Discount gültig bis
DATETIME
R+W
yes
fieldset
"price_base"
listCfg
{
    "viewMode": 0
}
fk_prcpers_prcgrp_id → price_group.prcgrp_id
Preisgruppe
INT (11)
R+W
yes
fieldset
"price_base"
listCfg
{
    "viewMode": 0
}
prcpers_dsc_scale
Preisstaffel
DATA
R+W
yes
fieldset
"price_base"
listCfg
{
    "viewMode": 0,
    "formatter": {
        "type": "sub-scale-price"
    }
}
formCfg
{
    "type": "eossubformarray",
    "options": {
        "model": "priceScale",
        "sortable": true,
        "enableAdd": true,
        "enableRemove": true,
        "itemsMinCount": 0,
        "itemsMaxCount": -1,
        "fieldDefinition": {
            "qty_range_min": {
                "type": "eosnumber",
                "hideLabel": true,
                "options": {
                    "prepend": "\u2265"
                }
            },
            "value": {
                "type": "eosnumber",
                "options": {
                    "decimalsCalculate": 2,
                    "decimalshowMin": 0,
                    "decimalshowMax": 2
                },
                "hideLabel": true
            },
            "type": {
                "type": "eosdropdown",
                "hideLabel": true,
                "options": {
                    "optI18nValuePrefix": "ecs.pricescale",
                    "optI18nName": true,
                    "optI18nSubTitle": true,
                    "data": {
                        "options": [
                            {
                                "value": "price_brutto"
                            },
                            {
                                "value": "price_netto"
                            },
                            {
                                "value": "discount_brutto_abs"
                            },
                            {
                                "value": "discount_netto_abs"
                            },
                            {
                                "value": "discount_perc"
                            },
                            {
                                "value": "poa"
                            }
                        ]
                    }
                }
            }
        },
        "layoutSettings": {
            "hideTabs": true,
            "tabs": [
                {
                    "label": "base",
                    "cssLayoutGroupDefault": "col-12",
                    "groups": [
                        {
                            "label": "price_scale",
                            "hideHeader": true,
                            "fdLabelLayoutDefault": "vt",
                            "fields": [
                                {
                                    "field": "qty_range_min",
                                    "cssLayout": "col-3"
                                },
                                {
                                    "field": "type",
                                    "cssLayout": "col-6"
                                },
                                {
                                    "field": "value",
                                    "cssLayout": "col-3"
                                }
                            ]
                        }
                    ]
                }
            ]
        }
    }
}
prcpers_state
Kundenpreis Status
INT (3)
R+W
no
valueColorField
"state_color"
fieldset
"price_base"
listCfg
{
    "formatter": {
        "type": "status",
        "params": {
            "statusColorField": "prcpers_state_color"
        }
    }
}
formCfg
{
    "type": "eosdropdown",
    "options": {
        "data": {
            "options": [
                {
                    "value": "0",
                    "name": "0 - unbekannt",
                    "color": "#A3CBEB",
                    "iconLabel": "hublify\/circle",
                    "iconColor": "#A3CBEB"
                },
                {
                    "value": "1",
                    "name": "1 - offline",
                    "color": "#CE0002",
                    "iconLabel": "hublify\/circle",
                    "iconColor": "#CE0002"
                },
                {
                    "value": "2",
                    "name": "2 - online",
                    "color": "#85B200",
                    "iconLabel": "hublify\/circle",
                    "iconColor": "#85B200"
                }
            ]
        },
        "optValueColorField": "state_color",
        "optIconLabel": "hublify\/circle",
        "optIconColorField": "state_color"
    }
}
prcpers_state_color
TEXT (15)
R
yes
drvd_select
CASE ecs_prd_price_person.prcpers_state WHEN 1 THEN "#CE0002" WHEN 2 THEN "#85B200" ELSE "#CCCCCC" END
listCfg
{
    "viewMode": 3
}
formCfg
{
    "editMode": 0
}
prcpers_xdata
DATA
R+W
yes
listCfg
{
    "viewMode": 0
}
formCfg
{
    "cssLayout": "col-12",
    "type": "aceeditor",
    "options": {
        "mode": "json"
    }
}
prcpers_insert_time
Angelegt am
DATETIME
R+W
no
i18n_string
"insert_time"
fieldset
"sys_record"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "editMode": 2
}
prcpers_insert_user
Ersteller
TEXT (127)
R+W
yes
i18n_string
"insert_user"
fieldset
"sys_record"
listCfg
{
    "formatter": {
        "type": "user"
    },
    "viewMode": 0
}
formCfg
{
    "editMode": 2
}
prcpers_update_time
Geändert am
DATETIME
R+W
yes
i18n_string
"update_time"
fieldset
"sys_record"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "editMode": 2
}
prcpers_update_user
Letzte Änderung durch
TEXT (127)
R+W
yes
i18n_string
"update_user"
fieldset
"sys_record"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "editMode": 2
}
vat [%]
FLOAT (6,2)
R+W
no
table
[ "prc" ]
fieldset
"price_base"
listCfg
{
    "formatter": {
        "type": "decimal",
        "params": {
            "unit": " %",
            "format": "1.0-1"
        }
    },
    "viewMode": 0
}
formCfg
{
    "type": "hidden"
}

person

Following fields can also be selected for reading (JOIN)

personid
Kunden-Nr.
TEXT
R
no
i18n_string
"ecs.PERSON.personid"
table
[ "eos_person" ]
drvd_select
eos_person.personid
formCfg
{
    "editMode": 1
}
persid auto increment
PersID
INT (11)
R
no
i18n_string
"ecs.PERSON.persid"
table
[ "eos_person" ]
fieldset
"base_record"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "type": "hidden",
    "editMode": 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": 0
}
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": 0
}
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": 0
}
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": 0,
    "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": 0
}
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": 0
}
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": 0
}
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": 0
}
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": 0
}
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": 0
}
formCfg
{
    "editMode": 0
}
company
Firma
TEXT
R
no
i18n_string
"ecs.PERSON.company"
table
[ "eos_person" ]
fieldset
"addr"
listCfg
{
    "viewMode": 0
}
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": 0
}
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": 0
}
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": 0
}
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": 0
}
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": 0
}
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": 0
}
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": 0
}
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": 0
}
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": 0,
    "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": 0
}
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": 0
}
formCfg
{
    "editMode": 0
}
email
E-Mail
TEXT (127)
R
no
i18n_string
"ecs.PERSON.email"
table
[ "eos_person" ]
fieldset
"communication"
listCfg
{
    "width": 256,
    "viewMode": 0
}
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": 0
}
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": 0
}
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": 0
}
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": 0
}
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": 0
}
formCfg
{
    "type": "hfyemail",
    "editMode": 0
}
taxident
Umsatzsteuer-ID
TEXT
R
no
i18n_string
"ecs.PERSON.taxident"
table
[ "eos_person" ]
fieldset
"commercial"
listCfg
{
    "viewMode": 0
}
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": 0,
    "formatter": {
        "type": "status"
    }
}
formCfg
{
    "type": "eosdropdown",
    "options": {
        "optI18nValuePrefix": "ecs.taxident_status",
        "optI18nName": true,
        "data": {
            "options": [
                {
                    "value": null
                },
                {
                    "value": "invalid"
                },
                {
                    "value": "valid_conditional"
                },
                {
                    "value": "valid_confirmed"
                }
            ]
        }
    },
    "editMode": 0
}
score
Bonitätswert
INT (7)
R
no
i18n_string
"ecs.PERSON.score"
table
[ "eos_person" ]
fieldset
"credit_rating"
listCfg
{
    "viewMode": 0,
    "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": 0
}
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": 0
}
formCfg
{
    "editMode": 0
}
svc_code
Rating ServiceCode
TEXT
R
yes
i18n_string
"ecs.PERSON.svc_code"
table
[ "eos_person" ]
fieldset
"credit_rating"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "editMode": 0
}
svc_txt
Rating ServiceText
TEXT
R
yes
i18n_string
"ecs.PERSON.svc_txt"
table
[ "eos_person" ]
fieldset
"credit_rating"
listCfg
{
    "viewMode": 0
}
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": 0
}
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": 0
}
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": 0
}
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": 0
}
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": 0
}
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": 0
}
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": 0
}
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": 0
}
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": 0
}
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": 0
}
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": 0
}
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": 0
}
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": 0
}
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": 0
}
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": 0
}
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": 0
}
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": 0
}
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": 0
}
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": 0
}
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": 0
}
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": 0,
    "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": 0,
    "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": 0
}
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": 0
}
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": 0
}
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": 0
}
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": 0
}
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": 0
}
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": 0
}
formCfg
{
    "editMode": 0
}
p_referrer
Referrer
TEXT
R
yes
i18n_string
"ecs.PERSON.p_referrer"
table
[ "eos_person" ]
fieldset
"registration"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "editMode": 0
}
p_useragent
User Agent
TEXT
R
yes
i18n_string
"ecs.PERSON.p_useragent"
table
[ "eos_person" ]
fieldset
"registration"
listCfg
{
    "viewMode": 0
}
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": 0,
    "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": 0
}
formCfg
{
    "editMode": 0
}
p_locale
Locale Kunde
DATA
R
yes
i18n_string
"ecs.PERSON.p_locale"
table
[ "eos_person" ]
fieldset
"extra"
listCfg
{
    "viewMode": 0
}
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": 0
}
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": 0
}
formCfg
{
    "editMode": 0
}
time_update
Geändert am
DATETIME
R
yes
i18n_string
"update_time"
table
[ "eos_person" ]
fieldset
"sys_record"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "editMode": 0
}
user_update
Letzte Änderung durch
TEXT (127)
R
yes
i18n_string
"update_user"
table
[ "eos_person" ]
fieldset
"sys_record"
listCfg
{
    "viewMode": 0
}
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": 0
}
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": 0
}
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": 0
}
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": 0
}
formCfg
{
    "editMode": 0
}
p_companyaccount_type
TEXT
R
yes
i18n_string
"ecs.plugin_companyaccount.p_companyaccount_type"
table
[ "eos_person" ]
fieldset
"extra"
listCfg
{
    "viewMode": 0
}
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": 0
}
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": 0
}
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": 0
}
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": 0
}
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": 0
}
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": 0
}
formCfg
{
    "editMode": 0
}