Model fields

The model consists of the following fields.

Field Name
Display Name
Type
Permissions
Nullable

person

persid primary auto increment
PersID
INT (11)
R+W
no
fieldset
"base_record"
formCfg
{
    "type": "hidden"
}
personid primaryDisplay
Kunden-Nr.
TEXT (32)
R+W
no
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"
        }
    }
}
formCfg
{
    "cssLayout": "col-6"
}
fk_p_grpid → persongroup.grpid
Kundengruppe
INT (11)
R+W
no
fieldset
"base_record"
listCfg
{
    "viewMode": 3
}
formCfg
{
    "cssLayout": "col-6"
}
fk_p_shopid → shopconfig.eshopid
Shop
INT (11)
R+W
yes
listCfg
{
    "viewMode": 0
}
gender
Anrede
TEXT
R+W
yes
enum
[ "female", "male", "company", "divers" ]
valueColorField
"gender_color"
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"
                }
            ]
        }
    }
}
gender_color
TEXT (15)
R
yes
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+W
no
input_translated
Geben Sie hier einen Titel des Kunden an (z.B. Dr.).
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"
                    }
                ]
            }
        }
    }
}
salutation
Anrede formal
TEXT
R+W
no
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"
                    }
                ]
            }
        }
    }
}
firstname
Vorname
TEXT
R+W
no
input_translated
Vorname der Registrierungsadresse.
fieldset
"base"
listCfg
{
    "width": 128
}
formCfg
{
    "cssLayout": "col-6"
}
lastname
Nachname
TEXT
R+W
no
fieldset
"base"
listCfg
{
    "width": 128
}
formCfg
{
    "cssLayout": "col-6"
}
bday
Geburtsdatum
DATE
R+W
yes
input_translated
Tragen Sie hier das Geburtsdatum des Kunden ein.

Vorzugsweise im Format: tt.mm.JJJJ.
fieldset
"base"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "type": "datepicker",
    "options": {
        "showWeekdays": false,
        "showWeekNumbers": false,
        "minDate": {
            "day": 1,
            "month": 1,
            "year": "1900"
        }
    }
}
drvd_age [y]
Alter
INT
R
yes
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
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
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+W
no
fieldset
"addr"
formCfg
{
    "cssLayout": "col-4"
}
p_department
Abteilung
TEXT
R+W
no
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"
                    }
                }
            }
        }
    }
}
p_job_position
Position
TEXT
R+W
no
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"
                    }
                }
            }
        }
    }
}
address2
Adressenzusatz
TEXT
R+W
no
fieldset
"addr"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "cssLayout": "col-12"
}
street
Straße
TEXT
R+W
no
fieldset
"addr"
listCfg
{
    "width": 96,
    "viewMode": 0
}
formCfg
{
    "cssLayout": "col-9"
}
housenr
Hausnummer
TEXT
R+W
no
fieldset
"addr"
listCfg
{
    "width": 64,
    "viewMode": 0
}
formCfg
{
    "cssLayout": "col-3"
}
zip
PLZ
TEXT
R+W
no
fieldset
"addr"
listCfg
{
    "width": 64
}
formCfg
{
    "cssLayout": "col-4"
}
town
Ort
TEXT
R+W
no
fieldset
"addr"
listCfg
{
    "width": 96
}
formCfg
{
    "cssLayout": "col-8"
}
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": "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%}"
                                        }
                                    }
                                }
                            }
                        }
                    ]
                }
            ]
        }
    }
}
country → country.cy_iso
Land
TEXT (2)
R+W
no
fieldset
"addr"
listCfg
{
    "viewMode": 0,
    "width": 64,
    "formatter": {
        "type": "country-flag"
    }
}
formCfg
{
    "cssLayout": "col-6"
}
drvd_person_name
Kundenname (kombiniert)
TEXT
R
no
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
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+W
no
fieldset
"communication"
listCfg
{
    "width": 256
}
formCfg
{
    "type": "hfyemail",
    "cssLayout": "col-6"
}
telephone
Telefon
TEXT
R+W
no
fieldset
"communication"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "type": "hfyphone",
    "cssLayout": "col-6"
}
telephone_mobile
Tel. mobil
TEXT
R+W
no
fieldset
"communication"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "type": "hfyphone",
    "cssLayout": "col-6"
}
telefax
Fax
TEXT
R+W
no
fieldset
"communication"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "type": "hfyphone",
    "cssLayout": "col-6"
}
p_invoice_type
Rechnungsart
TEXT
R+W
yes
fieldset
"commercial"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "type": "eosdropdown",
    "options": {
        "optI18nValuePrefix": "ecs.invoice_type",
        "optI18nName": true,
        "data": {
            "options": [
                {
                    "value": "noncommercial"
                },
                {
                    "value": "commercial"
                }
            ]
        }
    }
}
p_invoice_email
E-Mail (Rechnung)
TEXT
R+W
no
fieldset
"commercial"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "type": "hfyemail"
}
taxident
Umsatzsteuer-ID
TEXT
R+W
no
fieldset
"commercial"
listCfg
{
    "viewMode": 0
}
taxident_status
Umsatzsteuer-ID-Status
TEXT
R+W
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" ]
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"
                }
            ]
        }
    }
}
score
Bonitätswert
INT (7)
R+W
no
fieldset
"credit_rating"
listCfg
{
    "viewMode": 0,
    "sumType": "AVG"
}
score_time_set
Letzter Rating-Check
DATETIME
R+W
yes
fieldset
"credit_rating"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "editMode": 2
}
score_time_invalid
Abgelaufen am
DATETIME
R+W
yes
fieldset
"credit_rating"
listCfg
{
    "viewMode": 0
}
svc_code
Rating ServiceCode
TEXT
R+W
yes
fieldset
"credit_rating"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "editMode": 2
}
svc_txt
Rating ServiceText
TEXT
R+W
yes
fieldset
"credit_rating"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "editMode": 2
}
p_login_username
Benutzername
TEXT (63)
R+W
yes
fieldset
"login"
listCfg
{
    "viewMode": 0
}
p_login_pwd_encrypted
Passwort (verschlüsselt)
TEXT
R+W
yes
fieldset
"login"
listCfg
{
    "viewMode": 3
}
formCfg
{
    "editMode": 0
}
p_login_pwd_key
Direct-Login-Token
TEXT
R+W
yes
fieldset
"login"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "editMode": 2
}
p_login_time_last
Letzter Login
DATETIME
R+W
yes
fieldset
"login"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "editMode": 2
}
p_login_pwd_must_renew_after
Passwort-Änderung auffordern ab
DATETIME
R+W
yes
fieldset
"login"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "type": "datetimepicker"
}
p_login_pwd_key_timeout
Direct-Login-Token Timeout
DATETIME
R+W
yes
fieldset
"login"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "editMode": 2
}
p_login_pwd_last_renewed
Passwort zuletzt geändert
DATETIME
R+W
yes
fieldset
"login"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "editMode": 2
}
p_login_active
Aktiv
INT (1)
R+W
no
fieldset
"login"
listCfg
{
    "formatter": {
        "type": "active-flag"
    },
    "width": 64
}
formCfg
{
    "type": "checkbox"
}
p_email_verify_token
TEXT (32)
R+W
yes
fieldset
"login"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "editMode": 2
}
p_email_verify_token_timeout
DATETIME
R+W
yes
fieldset
"login"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "editMode": 2
}
p_email_verified_time
DATETIME
R+W
yes
fieldset
"login"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "editMode": 2
}
p_login_mode
Login-Modus
TEXT (15)
R+W
yes
enum
[ "simple", "2fa_email" ]
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"
                }
            ]
        }
    }
}
p_login_2fa_code
2FA - Login Code
TEXT
R+W
yes
fieldset
"login"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "editMode": 2
}
p_login_2fa_timeout
2FA - Login Code Timeout
DATETIME
R+W
yes
fieldset
"login"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "editMode": 2
}
p_login_err_count
Anzahl Fehllogins
INT (4)
R+W
no
fieldset
"login"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "editMode": 2
}
p_login_time_min
Login Sperrzeit
DATETIME
R+W
yes
fieldset
"login"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "editMode": 2
}
p_register_state
Registrierungsstatus
TEXT (15)
R+W
yes
fieldset
"login"
listCfg
{
    "viewMode": 0
}
p_register_code
Registrierungscode
TEXT (32)
R+W
yes
fieldset
"login"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "editMode": 2
}
p_register_code_timeout
Registrierungscode Timeout
DATETIME
R+W
yes
fieldset
"login"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "editMode": 2
}
p_onetime_pwd
Einmal-Passwort
TEXT
R+W
yes
fieldset
"login"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "editMode": 2
}
p_onetime_pwd_timeout
Einmal-Passwort Timeout
DATETIME
R+W
yes
fieldset
"login"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "editMode": 2
}
p_login_state
Login Status
TEXT (15)
R
no
enum
[ "possible", "disabled", "suspended", "retry" ]
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
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+W
no
fieldset
"order_options"
fk_p_pay_profile_id → payment_profile.pay_profile_id
Zahlungsziel-Profil
INT (11)
R+W
yes
fieldset
"order_options"
listCfg
{
    "viewMode": 3
}
fk_p_prcgrp_id → price_group.prcgrp_id
Preisgruppe
INT (11)
R+W
yes
input_translated
Eine hier eingetragene Preisgruppe hat Vorrang vor den Preisgruppen-Einstellungen der Kundengruppe und auch den direkt im Produkt gesetzten Staffelpreisen.
fieldset
"order_options"
listCfg
{
    "viewMode": 3
}
p_price_factor
Preis-Faktor
FLOAT (10,4)
R+W
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.
fieldset
"order_options"
listCfg
{
    "viewMode": 0
}
p_person_prices
Persönliche Preise
INT (1)
R+W
no
fieldset
"order_options"
listCfg
{
    "formatter": {
        "type": "active-flag"
    },
    "width": 64
}
formCfg
{
    "type": "checkbox"
}
fk_p_campid → campaign.campid
Kampagne
INT (11)
R+W
yes
fieldset
"marketing"
p_allow_email_marketing
Zustimmung zu Marketing-Mails
INT (1)
R+W
no
fieldset
"marketing"
listCfg
{
    "formatter": {
        "type": "active-flag"
    },
    "width": 64
}
formCfg
{
    "type": "checkbox"
}
drvd_emailmarketing_unsubscribetoken
Token für Direktabmeldung Marketingmails
TEXT
R
no
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+W
no
fieldset
"registration"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "editMode": 2
}
p_referrer
Referrer
TEXT
R+W
yes
fieldset
"registration"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "editMode": 2
}
p_useragent
User Agent
TEXT
R+W
yes
fieldset
"registration"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "editMode": 2
}
p_personid_external
Externe Kunden-Nr.
TEXT (127)
R+W
yes
input_translated
Eine externe Kunden-Nr. aus einem anderen System.
fieldset
"external"
listCfg
{
    "viewMode": 0,
    "fullSearch": true
}
p_comment_internal
Interner Kommentar
TEXT
R+W
yes
fieldset
"extra"
listCfg
{
    "viewMode": 0
}
p_locale
Locale Kunde
DATA
R+W
yes
fieldset
"extra"
listCfg
{
    "viewMode": 0
}
p_volfile
DATA
R
yes
drvd_select
NULL
fieldset
"documents"
listCfg
{
    "viewMode": 3
}
formCfg
{
    "type": "hfyvolumefile",
    "options": {
        "vol_label": "person_documents",
        "vol_primKeyVar": "persid",
        "vol_primKey": null
    }
}
time_insert
Angelegt am
DATETIME
R+W
no
i18n_string
"insert_time"
fieldset
"sys_record"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "editMode": 2
}
user_insert
Ersteller
TEXT (127)
R+W
yes
i18n_string
"insert_user"
fieldset
"sys_record"
listCfg
{
    "formatter": {
        "type": "user"
    },
    "viewMode": 0
}
formCfg
{
    "editMode": 2
}
time_update
Geändert am
DATETIME
R+W
yes
i18n_string
"update_time"
fieldset
"sys_record"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "editMode": 2
}
user_update
Letzte Änderung durch
TEXT (127)
R+W
yes
i18n_string
"update_user"
fieldset
"sys_record"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "editMode": 2
}
drvd_timeonly_timeinsert
Angelegt (Uhrzeit)
TEXT
R
no
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+W
yes
fieldset
"sys_record"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "editMode": 2
}
fk_p_companyaccount_parent_persid → companyaccount.persid
Firmenaccount
INT
R+W
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"
fieldset
"extra"
listCfg
{
    "viewMode": 3
}
p_companyaccount_budget_cart_max [EUR]
Budget Warenkorb
FLOAT (10,2)
R+W
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"
fieldset
"extra"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "type": "eosnumber",
    "options": {
        "decimalsCalculate": 2,
        "decimalshowMin": 2,
        "decimalshowMax": 2
    }
}
p_companyaccount_cost_center_customer
Kunden Kostenstelle
TEXT
R+W
yes
input_translated
Standard Kostenstelle des Kunden.
i18n_string
"ecs.plugin_companyaccount.p_companyaccount_cost_center_customer"
fieldset
"extra"
listCfg
{
    "viewMode": 0
}
p_companyaccount_type
TEXT
R+W
yes
i18n_string
"ecs.plugin_companyaccount.p_companyaccount_type"
fieldset
"extra"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "type": "eosdropdown",
    "options": {
        "optI18nValuePrefix": "ecs.plugin_companyaccount.p_companyaccount_type",
        "optI18nName": true,
        "data": {
            "options": [
                {
                    "value": "company"
                },
                {
                    "value": "subaccount"
                }
            ]
        }
    }
}
p_companyaccount_xdata
DATA
R+W
yes
i18n_string
"ecs.plugin_companyaccount.p_companyaccount_xdata"
fieldset
"extra"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "cssLayout": "col-12",
    "type": "aceeditor",
    "options": {
        "mode": "json"
    }
}
p_accounting_debtor_account
Buchhaltung Debitorenkonto
TEXT
R+W
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"
fieldset
"accounting"
fk_pers_inv_reminder_profile
Mahnprofil
TEXT (127)
R+W
yes
drvd_pers_inv_reminder_profile_name
angewendetes Mahnprofil
TEXT (127)
R
yes
table
"ecs_invoice_reminder_profile"
drvd_select
ecs_invoice_reminder_profile.profile_name
formCfg
{
    "editMode": 0
}
p_merchant_xdata
Anbieter (Zusatzdaten)
DATA
R+W
yes
input_translated
Geben Sie hier spezifische Informationen an, die für Anbieter relevant sein können (z.B. Kundennummer zu einem Anbieter).
fieldset
"extra"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "cssLayout": "col-12",
    "type": "aceeditor",
    "options": {
        "mode": "json"
    }
}
p_shopuserright_profiles
Benutzer-Rollen
TEXT
R+W
yes
input_translated
Wählen Sie hier die Benutzer-Rollen für den Kunden aus.
i18n_string
"ecs.plugin_shopuserright.p_shopuserright_profiles"
p_shopuserright_rights
Benutzer-Rechte
TEXT
R+W
yes
input_translated
Tragen Sie hier einzelne Benutzer-Rechte für den Kunden ein.
i18n_string
"ecs.plugin_shopuserright.p_shopuserright_rights"
p_login_pwd_plain
Neues Passwort
TEXT (64)
R
yes
input_translated
Nur ausfüllen, wenn ein neues Passwort vergeben werden soll.
drvd_select
NULL
fieldset
"login"
listCfg
{
    "viewMode": 3
}
formCfg
{
    "editMode": 1,
    "type": "hfypassword",
    "options": {
        "reqs_dataStreamCall": {
            "method": "person_getPasswordRequirements"
        }
    }
}
campid
INT (11)
R+W
no
table
[ "eos_campaign" ]
fieldset
"marketing"
listCfg
{
    "viewMode": 3
}
formCfg
{
    "editMode": 0
}
drvd_order_timelast
Letzte Bestellung
DATETIME
R+W
no
fieldset
"analytics"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "editMode": 0
}
drvd_order_timefirst
Erste Bestellung
DATETIME
R+W
no
fieldset
"analytics"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "editMode": 0
}
drvd_order_frequency [d]
Bestell­frequenz
FLOAT (9,2)
R+W
no
fieldset
"analytics"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "editMode": 0
}
drvd_order_count
# Aufträge
INT (11)
R+W
no
fieldset
"analytics"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "editMode": 0
}
p_profile_photo
Bild
TEXT
R+W
yes
fieldset
"profile"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "editMode": 0
}
cy_locale
Locale Land
TEXT
R+W
no
i18n_string
"ecs.COUNTRY.cy_locale"
table
[ "person_country" ]
listCfg
{
    "viewMode": 0
}
formCfg
{
    "editMode": 0
}
drvd_person_state_name
Bundesland (Name)
TEXT
R
no
table
[ "person_terr_state" ]
drvd_select
person_terr_state.terr_name
listCfg
{
    "viewMode": 0
}
formCfg
{
    "editMode": 0
}
drvd_person_state_path
Bundesland (Pfad)
TEXT
R
no
table
[ "person_terr_state" ]
drvd_select
person_terr_state.i18n_node_path_DE
listCfg
{
    "viewMode": 0
}
formCfg
{
    "editMode": 0
}
person_invoice_default__drvd_adr_state_name
Bundesland
TEXT
R
no
i18n_string
"ecs.ADDRESS.drvd_adr_state_name"
table
[ "person_invoice_default__adress_terr_state" ]
drvd_select
person_invoice_default__adress_terr_state.terr_name
listCfg
{
    "viewMode": 0
}
formCfg
{
    "editMode": 0
}
person_invoice_default__drvd_adr_state_path
Bundesland (Pfad)
TEXT
R
no
i18n_string
"ecs.ADDRESS.drvd_adr_state_path"
table
[ "person_invoice_default__adress_terr_state" ]
drvd_select
person_invoice_default__adress_terr_state.i18n_node_path_DE
listCfg
{
    "viewMode": 0
}
formCfg
{
    "editMode": 0
}
person_delivery_default__drvd_adr_state_name
Bundesland
TEXT
R
no
i18n_string
"ecs.ADDRESS.drvd_adr_state_name"
table
[ "person_delivery_default__adress_terr_state" ]
drvd_select
person_delivery_default__adress_terr_state.terr_name
listCfg
{
    "viewMode": 0
}
formCfg
{
    "editMode": 0
}
person_delivery_default__drvd_adr_state_path
Bundesland (Pfad)
TEXT
R
no
i18n_string
"ecs.ADDRESS.drvd_adr_state_path"
table
[ "person_delivery_default__adress_terr_state" ]
drvd_select
person_delivery_default__adress_terr_state.i18n_node_path_DE
listCfg
{
    "viewMode": 0
}
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" ]
fieldset
"base_record"
listCfg
{
    "viewMode": 0,
    "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" ]
fieldset
"base"
listCfg
{
    "viewMode": 1,
    "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" ]
fieldset
"base"
listCfg
{
    "viewMode": 0,
    "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" ]
fieldset
"register"
listCfg
{
    "formatter": {
        "type": "active-flag"
    },
    "width": 64,
    "viewMode": 0,
    "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" ]
fieldset
"defaults_person"
listCfg
{
    "formatter": {
        "type": "active-flag"
    },
    "width": 64,
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "checkbox",
    "editMode": 0
}
grp_locale
Locale Kundengruppe
DATA
R
yes
i18n_string
"ecs.PERSONGRP.grp_locale"
table
[ "eos_person_group" ]
fieldset
"defaults_person"
listCfg
{
    "viewMode": 0,
    "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" ]
fieldset
"defaults_order"
listCfg
{
    "viewMode": 0,
    "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" ]
fieldset
"defaults_order"
listCfg
{
    "viewMode": 0,
    "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" ]
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
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" ]
fieldset
"prices"
listCfg
{
    "viewMode": 0,
    "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" ]
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" ]
fieldset
"orderoptions"
listCfg
{
    "formatter": {
        "type": "active-flag"
    },
    "width": 64,
    "viewMode": 0,
    "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" ]
fieldset
"price_col_cfg"
listCfg
{
    "viewMode": 0,
    "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": 0,
    "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": 0,
    "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": 0,
    "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" ]
fieldset
"price_col_cfg"
listCfg
{
    "viewMode": 0,
    "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" ]
fieldset
"price_col_cfg"
listCfg
{
    "viewMode": 0,
    "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" ]
fieldset
"price_col_cfg"
listCfg
{
    "viewMode": 0,
    "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" ]
fieldset
"price_col_cfg"
listCfg
{
    "viewMode": 0,
    "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" ]
fieldset
"orderoptions"
listCfg
{
    "viewMode": 0,
    "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" ]
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" ]
fieldset
"extra"
listCfg
{
    "viewMode": 0,
    "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" ]
listCfg
{
    "viewMode": 0,
    "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" ]
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}

campaign

Following fields can also be selected for reading (JOIN)

camp_name
Kampagne
TEXT (127)
R
no
table
[ "eos_campaign" ]
fieldset
"marketing"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "editMode": 1
}

paddress

Following fields can also be selected for reading (JOIN)

person_invoice_default__adr_id primary auto increment
Adr.Id
INT (11)
R
no
i18n_string
"ecs.ADDRESS.adr_id"
table
[ "person_invoice_default" ]
drvd_select
person_invoice_default.adr_id
fieldset
"person_invoice_default"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "type": "hidden",
    "editMode": 1
}
person_invoice_default__adr_ref_type
Typ
TEXT (31)
R
yes
i18n_string
"ecs.ADDRESS.adr_ref_type"
table
[ "person_invoice_default" ]
drvd_select
person_invoice_default.adr_ref_type
fieldset
"person_invoice_default"
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"
                }
            ]
        }
    },
    "editMode": 1
}
person_invoice_default__adr_gender
Anrede
TEXT
R
yes
enum
[ "female", "male", "company", "divers" ]
i18n_string
"ecs.ADDRESS.adr_gender"
valueColorField
"adr_gender_color"
table
[ "person_invoice_default" ]
drvd_select
person_invoice_default.adr_gender
fieldset
"person_invoice_default"
listCfg
{
    "width": 96,
    "viewMode": 0
}
formCfg
{
    "cssLayout": "col-6",
    "type": "eosdropdown",
    "options": {
        "optI18nValuePrefix": "ecs.gender",
        "optI18nName": true,
        "data": {
            "options": [
                {
                    "value": "female"
                },
                {
                    "value": "male"
                },
                {
                    "value": "company"
                },
                {
                    "value": "divers"
                }
            ]
        }
    },
    "editMode": 1
}
person_invoice_default__adr_title
Titel
TEXT
R
yes
i18n_string
"ecs.ADDRESS.adr_title"
table
[ "person_invoice_default" ]
drvd_select
person_invoice_default.adr_title
fieldset
"person_invoice_default"
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"
                    }
                ]
            }
        }
    },
    "editMode": 1
}
person_invoice_default__adr_firstname
Vorname
TEXT
R
yes
i18n_string
"ecs.ADDRESS.adr_firstname"
table
[ "person_invoice_default" ]
drvd_select
person_invoice_default.adr_firstname
fieldset
"person_invoice_default"
listCfg
{
    "width": 128,
    "viewMode": 0
}
formCfg
{
    "cssLayout": "col-6",
    "editMode": 1
}
person_invoice_default__adr_lastname
Nachname
TEXT
R
yes
i18n_string
"ecs.ADDRESS.adr_lastname"
table
[ "person_invoice_default" ]
drvd_select
person_invoice_default.adr_lastname
fieldset
"person_invoice_default"
listCfg
{
    "width": 128,
    "viewMode": 0
}
formCfg
{
    "cssLayout": "col-6",
    "editMode": 1
}
person_invoice_default__adr_company
Firma
TEXT
R
yes
i18n_string
"ecs.ADDRESS.adr_company"
table
[ "person_invoice_default" ]
drvd_select
person_invoice_default.adr_company
fieldset
"person_invoice_default"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "cssLayout": "col-12",
    "editMode": 1
}
person_invoice_default__adr_extra1
Adressenzusatz
TEXT
R
yes
i18n_string
"ecs.ADDRESS.adr_extra1"
table
[ "person_invoice_default" ]
drvd_select
person_invoice_default.adr_extra1
fieldset
"person_invoice_default"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "cssLayout": "col-12",
    "editMode": 1
}
person_invoice_default__adr_street
Straße
TEXT
R
yes
i18n_string
"ecs.ADDRESS.adr_street"
table
[ "person_invoice_default" ]
drvd_select
person_invoice_default.adr_street
fieldset
"person_invoice_default"
listCfg
{
    "width": 96,
    "viewMode": 0
}
formCfg
{
    "cssLayout": "col-9",
    "editMode": 1
}
person_invoice_default__adr_housenr
Hausnr.
TEXT
R
yes
i18n_string
"ecs.ADDRESS.adr_housenr"
table
[ "person_invoice_default" ]
drvd_select
person_invoice_default.adr_housenr
fieldset
"person_invoice_default"
listCfg
{
    "width": 64,
    "viewMode": 0
}
formCfg
{
    "cssLayout": "col-3",
    "editMode": 1
}
person_invoice_default__adr_zip
PLZ
TEXT
R
yes
i18n_string
"ecs.ADDRESS.adr_zip"
table
[ "person_invoice_default" ]
drvd_select
person_invoice_default.adr_zip
fieldset
"person_invoice_default"
listCfg
{
    "width": 64,
    "viewMode": 0
}
formCfg
{
    "cssLayout": "col-4",
    "editMode": 1
}
person_invoice_default__adr_town
Ort
TEXT
R
yes
i18n_string
"ecs.ADDRESS.adr_town"
table
[ "person_invoice_default" ]
drvd_select
person_invoice_default.adr_town
fieldset
"person_invoice_default"
listCfg
{
    "width": 96,
    "viewMode": 0
}
formCfg
{
    "cssLayout": "col-8",
    "editMode": 1
}
person_invoice_default__adr_state_code
Bundesland (Code)
TEXT (15)
R
yes
i18n_string
"ecs.ADDRESS.adr_state_code"
table
[ "person_invoice_default" ]
drvd_select
person_invoice_default.adr_state_code
fieldset
"person_invoice_default"
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%}"
                                        }
                                    }
                                }
                            }
                        }
                    ]
                }
            ]
        }
    },
    "editMode": 1
}
person_invoice_default__adr_time_insert
Erstellt am
DATETIME
R
no
i18n_string
"ecs.ADDRESS.adr_time_insert"
table
[ "person_invoice_default" ]
drvd_select
person_invoice_default.adr_time_insert
fieldset
"person_invoice_default"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "editMode": 2
}
person_invoice_default__adr_time_update
Letzte Änderung
DATETIME
R
yes
i18n_string
"ecs.ADDRESS.adr_time_update"
table
[ "person_invoice_default" ]
drvd_select
person_invoice_default.adr_time_update
fieldset
"person_invoice_default"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "editMode": 2
}
person_delivery_default__adr_id primary auto increment
Adr.Id
INT (11)
R
no
i18n_string
"ecs.ADDRESS.adr_id"
table
[ "person_delivery_default" ]
drvd_select
person_delivery_default.adr_id
fieldset
"person_delivery_default"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "type": "hidden",
    "editMode": 1
}
person_delivery_default__adr_ref_type
Typ
TEXT (31)
R
yes
i18n_string
"ecs.ADDRESS.adr_ref_type"
table
[ "person_delivery_default" ]
drvd_select
person_delivery_default.adr_ref_type
fieldset
"person_delivery_default"
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"
                }
            ]
        }
    },
    "editMode": 1
}
person_delivery_default__adr_gender
Anrede
TEXT
R
yes
enum
[ "female", "male", "company", "divers" ]
i18n_string
"ecs.ADDRESS.adr_gender"
valueColorField
"adr_gender_color"
table
[ "person_delivery_default" ]
drvd_select
person_delivery_default.adr_gender
fieldset
"person_delivery_default"
listCfg
{
    "width": 96,
    "viewMode": 0
}
formCfg
{
    "cssLayout": "col-6",
    "type": "eosdropdown",
    "options": {
        "optI18nValuePrefix": "ecs.gender",
        "optI18nName": true,
        "data": {
            "options": [
                {
                    "value": "female"
                },
                {
                    "value": "male"
                },
                {
                    "value": "company"
                },
                {
                    "value": "divers"
                }
            ]
        }
    },
    "editMode": 1
}
person_delivery_default__adr_title
Titel
TEXT
R
yes
i18n_string
"ecs.ADDRESS.adr_title"
table
[ "person_delivery_default" ]
drvd_select
person_delivery_default.adr_title
fieldset
"person_delivery_default"
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"
                    }
                ]
            }
        }
    },
    "editMode": 1
}
person_delivery_default__adr_firstname
Vorname
TEXT
R
yes
i18n_string
"ecs.ADDRESS.adr_firstname"
table
[ "person_delivery_default" ]
drvd_select
person_delivery_default.adr_firstname
fieldset
"person_delivery_default"
listCfg
{
    "width": 128,
    "viewMode": 0
}
formCfg
{
    "cssLayout": "col-6",
    "editMode": 1
}
person_delivery_default__adr_lastname
Nachname
TEXT
R
yes
i18n_string
"ecs.ADDRESS.adr_lastname"
table
[ "person_delivery_default" ]
drvd_select
person_delivery_default.adr_lastname
fieldset
"person_delivery_default"
listCfg
{
    "width": 128,
    "viewMode": 0
}
formCfg
{
    "cssLayout": "col-6",
    "editMode": 1
}
person_delivery_default__adr_company
Firma
TEXT
R
yes
i18n_string
"ecs.ADDRESS.adr_company"
table
[ "person_delivery_default" ]
drvd_select
person_delivery_default.adr_company
fieldset
"person_delivery_default"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "cssLayout": "col-12",
    "editMode": 1
}
person_delivery_default__adr_extra1
Adressenzusatz
TEXT
R
yes
i18n_string
"ecs.ADDRESS.adr_extra1"
table
[ "person_delivery_default" ]
drvd_select
person_delivery_default.adr_extra1
fieldset
"person_delivery_default"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "cssLayout": "col-12",
    "editMode": 1
}
person_delivery_default__adr_street
Straße
TEXT
R
yes
i18n_string
"ecs.ADDRESS.adr_street"
table
[ "person_delivery_default" ]
drvd_select
person_delivery_default.adr_street
fieldset
"person_delivery_default"
listCfg
{
    "width": 96,
    "viewMode": 0
}
formCfg
{
    "cssLayout": "col-9",
    "editMode": 1
}
person_delivery_default__adr_housenr
Hausnr.
TEXT
R
yes
i18n_string
"ecs.ADDRESS.adr_housenr"
table
[ "person_delivery_default" ]
drvd_select
person_delivery_default.adr_housenr
fieldset
"person_delivery_default"
listCfg
{
    "width": 64,
    "viewMode": 0
}
formCfg
{
    "cssLayout": "col-3",
    "editMode": 1
}
person_delivery_default__adr_zip
PLZ
TEXT
R
yes
i18n_string
"ecs.ADDRESS.adr_zip"
table
[ "person_delivery_default" ]
drvd_select
person_delivery_default.adr_zip
fieldset
"person_delivery_default"
listCfg
{
    "width": 64,
    "viewMode": 0
}
formCfg
{
    "cssLayout": "col-4",
    "editMode": 1
}
person_delivery_default__adr_town
Ort
TEXT
R
yes
i18n_string
"ecs.ADDRESS.adr_town"
table
[ "person_delivery_default" ]
drvd_select
person_delivery_default.adr_town
fieldset
"person_delivery_default"
listCfg
{
    "width": 96,
    "viewMode": 0
}
formCfg
{
    "cssLayout": "col-8",
    "editMode": 1
}
person_delivery_default__adr_state_code
Bundesland (Code)
TEXT (15)
R
yes
i18n_string
"ecs.ADDRESS.adr_state_code"
table
[ "person_delivery_default" ]
drvd_select
person_delivery_default.adr_state_code
fieldset
"person_delivery_default"
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%}"
                                        }
                                    }
                                }
                            }
                        }
                    ]
                }
            ]
        }
    },
    "editMode": 1
}
person_delivery_default__adr_time_insert
Erstellt am
DATETIME
R
no
i18n_string
"ecs.ADDRESS.adr_time_insert"
table
[ "person_delivery_default" ]
drvd_select
person_delivery_default.adr_time_insert
fieldset
"person_delivery_default"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "editMode": 2
}
person_delivery_default__adr_time_update
Letzte Änderung
DATETIME
R
yes
i18n_string
"ecs.ADDRESS.adr_time_update"
table
[ "person_delivery_default" ]
drvd_select
person_delivery_default.adr_time_update
fieldset
"person_delivery_default"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "editMode": 2
}