invoice - "Rechnung" Model fields
The model consists of the following fields.
Field Name
Display Name
Type
Permissions
Nullable
invoice
inv_id
primary
auto increment
INT (11)
R+W
no
formCfg{
"type": "hidden"
}inv_code
primaryDisplay
Rechnungs-Nr.
TEXT (31)
R+W
yes
fieldset"base"listCfg{
"formatter": {
"type": "model-primary",
"params": {
"model": "invoice",
"primaryKey": "inv_id",
"statusColorField": "inv_status_color",
"subTitleTemplate": "{%inv_firstname%} {%inv_lastname%}"
}
}
}formCfg{
"cssLayout": "col-12 col-md-6 col-xl-3"
}fieldset"base"listCfg{
"viewMode": 0
}formCfg{
"cssLayout": "col-12 col-md-6 col-xl-3"
}inv_time_invoice
Rechnungsdatum
DATETIME
R+W
yes
fieldset"base"listCfg{
"formatter": {
"type": "date"
}
}formCfg{
"type": "datetimepicker",
"cssLayout": "col-12 col-md-6 col-xl-3"
}inv_amount
[EUR]
Rechnungsbetrag
FLOAT (13,2)
R+W
no
fieldset"payment"listCfg{
"formatter": {
"type": "currency"
},
"sumType": "SV"
}formCfg{
"editMode": 2
}inv_status
Rechnungsstatus
TEXT (7)
R+W
no
enum[
"open",
"done"
]valueColorField"inv_status_color"fieldset"base"listCfg{
"formatter": {
"type": "status",
"params": {
"statusColorField": "inv_status_color"
}
}
}formCfg{
"cssLayout": "col-12 col-md-6 col-xl-3",
"type": "eosdropdown",
"options": {
"data": {
"options": [
{
"value": "open",
"name": "open",
"color": "#CE0002",
"iconLabel": "hublify\/circle",
"iconColor": "#CE0002"
},
{
"value": "done",
"name": "done",
"color": "#85B200",
"iconLabel": "hublify\/circle",
"iconColor": "#85B200"
}
]
},
"optValueColorField": "inv_status_color",
"optIconLabel": "hublify\/circle",
"optIconColorField": "inv_status_color"
}
}inv_status_color
TEXT (15)
R
yes
drvd_selectCASE ecs_invoice.inv_status WHEN "open" THEN "#CE0002" WHEN "done" THEN "#85B200" ELSE NULL ENDlistCfg{
"viewMode": 3
}input_translatedDiesem Auftrag wird die Rechnung zugeordnet.
Einem Auftrag können mehrere Rechnungen zugeordnet sein.
Einem Auftrag können mehrere Rechnungen zugeordnet sein.
fieldset"inv_extra"listCfg{
"viewMode": 0
}formCfg{
"cssLayout": "col-6"
}inv_user_insert
Ersteller
TEXT (127)
R+W
yes
i18n_string"insert_user"fieldset"sys_record"listCfg{
"formatter": {
"type": "user"
},
"viewMode": 0
}formCfg{
"editMode": 2
}inv_time_insert
Angelegt am
DATETIME
R+W
no
i18n_string"insert_time"fieldset"sys_record"listCfg{
"viewMode": 0
}formCfg{
"editMode": 2
}inv_user_update
Letzte Änderung durch
TEXT (127)
R+W
yes
i18n_string"update_user"fieldset"sys_record"listCfg{
"viewMode": 0
}formCfg{
"editMode": 2
}inv_time_update
Geändert am
DATETIME
R+W
yes
i18n_string"update_time"fieldset"sys_record"listCfg{
"viewMode": 0
}formCfg{
"editMode": 2
}drvd_invoice_or_credit
TEXT
R
no
enum[
"invoice",
"creditmemo"
]drvd_selectIF(ecs_invoice.inv_amount < 0,"creditmemo","invoice")listCfg{
"viewMode": 0
}formCfg{
"editMode": 0
}inv_amount_paid
[EUR]
Bezahlter Rechnungsbetrag
FLOAT (13,2)
R+W
no
fieldset"payment"listCfg{
"formatter": {
"type": "currency"
},
"viewMode": 0,
"sumType": "SV"
}inv_time_paid
Letzte Rechnungszahlung
DATETIME
R+W
yes
fieldset"payment"listCfg{
"viewMode": 0,
"formatter": {
"type": "date"
}
}inv_discount_percent
% Skonto (Altversion)
FLOAT (6,2)
R+W
yes
fieldset"payment"listCfg{
"formatter": {
"type": "decimal",
"params": {
"unit": " %",
"format": "1.0-1"
}
},
"viewMode": 0
}inv_discount_time_until
Skonto bis (Altversion)
DATETIME
R+W
yes
fieldset"payment"listCfg{
"viewMode": 0
}inv_txt_title
Rechnungstitel
TEXT
R+W
yes
fieldset"doc_header"listCfg{
"viewMode": 0,
"fullSearch": true
}formCfg{
"cssLayout": "col-12"
}inv_txt_header
Kopfbereich
TEXT
R+W
yes
fieldset"doc_header"listCfg{
"viewMode": 0,
"fullSearch": true
}formCfg{
"cssLayout": "col-12",
"type": "eoseditor"
}inv_comment_internal
Interner Kommentar
TEXT
R+W
yes
fieldset"extra"listCfg{
"viewMode": 0
}inv_gender
Anrede
TEXT
R+W
yes
enum[
"female",
"male",
"company",
"divers"
]fieldset"inv_address"listCfg{
"viewMode": 0
}formCfg{
"cssLayout": "col-6 col-xl-2",
"type": "eosdropdown",
"options": {
"data": {
"options": [
{
"value": null,
"name": "unknown"
},
{
"value": "female",
"name": "Frau"
},
{
"value": "male",
"name": "Herr"
},
{
"value": "company",
"name": "Firma"
},
{
"value": "divers",
"name": "Divers"
}
]
}
}
}inv_title
Titel
TEXT
R+W
yes
fieldset"inv_address"listCfg{
"viewMode": 0,
"fullSearch": true
}formCfg{
"cssLayout": "col-6 col-xl-2"
}inv_firstname
Vorname
TEXT
R+W
yes
fieldset"inv_address"listCfg{
"viewMode": 0,
"fullSearch": true
}formCfg{
"cssLayout": "col-6 col-xl-4"
}inv_lastname
Rg.Nachname
TEXT
R+W
yes
fieldset"inv_address"listCfg{
"viewMode": 0,
"fullSearch": true
}formCfg{
"cssLayout": "col-6 col-xl-4"
}inv_company
Rg.Firma
TEXT
R+W
yes
fieldset"inv_address"listCfg{
"viewMode": 0,
"fullSearch": true
}formCfg{
"cssLayout": "col-6"
}inv_addrextra
Adressenzusatz
TEXT
R+W
yes
fieldset"inv_address"listCfg{
"viewMode": 0
}formCfg{
"cssLayout": "col-6"
}inv_street
Straße
TEXT
R+W
yes
fieldset"inv_address"listCfg{
"viewMode": 0
}formCfg{
"cssLayout": "col-9"
}inv_housenr
Hausnummer
TEXT
R+W
yes
fieldset"inv_address"listCfg{
"viewMode": 0
}formCfg{
"cssLayout": "col-3"
}drvd_inv_street_housenr
Straße+Nr
TEXT
R
no
drvd_selectCONCAT_WS("",ecs_invoice.inv_street," ",ecs_invoice.inv_housenr)listCfg{
"viewMode": 0
}inv_zip
PLZ
TEXT
R+W
yes
fieldset"inv_address"listCfg{
"viewMode": 0
}formCfg{
"cssLayout": "col-4"
}inv_town
Ort
TEXT
R+W
yes
fieldset"inv_address"listCfg{
"viewMode": 0
}formCfg{
"cssLayout": "col-8"
}inv_state_code
Bundesland (Code)
TEXT (15)
R+W
yes
fieldset"inv_address"listCfg{
"viewMode": 0
}formCfg{
"cssLayout": "col-6",
"type": "eosdropdown",
"options": {
"optValueField": "terr_code",
"optNameField": "terr_name",
"optExtraField": "terr_code",
"observer": {
"fields": [
{
"field": "inv_country",
"trigger": "onInit",
"exec": [
{
"cmd": "loadOptions",
"params": {
"dataStreamCall": {
"method": "state_getlist",
"params": {
"filter": {
"state_country": "{%FIELD.value%}"
}
}
}
}
}
]
},
{
"field": "inv_country",
"trigger": "onChange",
"exec": [
{
"cmd": "loadOptions",
"params": {
"dataStreamCall": {
"method": "state_getlist",
"params": {
"filter": {
"state_country": "{%FIELD.value%}"
}
}
}
}
}
]
}
]
}
}
}fieldset"inv_address"listCfg{
"viewMode": 0,
"width": 64,
"formatter": {
"type": "country-flag"
}
}formCfg{
"cssLayout": "col-6"
}inv_time_account_export
Buchhaltung-Export
DATETIME
R+W
yes
fieldset"tax"listCfg{
"viewMode": 0
}formCfg{
"editMode": 0
}inv_editable
änderbar
INT (11)
R+W
no
listCfg{
"viewMode": 0
}formCfg{
"editMode": 0
}inv_type
Rechnungsart
TEXT
R+W
yes
enum[
"noncommercial",
"commercial"
]fieldset"inv_extra"listCfg{
"viewMode": 0
}formCfg{
"cssLayout": "col-6",
"type": "eosdropdown",
"options": {
"data": {
"options": [
{
"value": "noncommercial",
"name": "Privat (B2C)"
},
{
"value": "commercial",
"name": "Gewerblich (B2B)"
}
]
}
}
}inv_reason
Grund
TEXT (15)
R+W
yes
enum[
"cancellation",
"return",
"complaint",
"multiple_orders",
"obligingness"
]fieldset"inv_extra"listCfg{
"viewMode": 0
}formCfg{
"type": "eosdropdown",
"options": {
"optI18nValuePrefix": "invoice.inv_reason",
"optI18nName": true,
"optI18nSubTitle": true,
"data": {
"options": [
{
"value": "cancellation"
},
{
"value": "return"
},
{
"value": "complaint"
},
{
"value": "multiple_orders"
},
{
"value": "obligingness"
}
]
}
}
}inv_comment
Kommentar
TEXT
R+W
yes
listCfg{
"viewMode": 0
}formCfg{
"editMode": 0
}inv_email
Rechnungs E-Mail
TEXT
R+W
yes
fieldset"inv_extra"listCfg{
"viewMode": 0
}formCfg{
"cssLayout": "col-6"
}inv_taxidentnumber
Umsatzsteuer-ID
TEXT
R+W
yes
fieldset"tax"listCfg{
"viewMode": 0
}formCfg{
"cssLayout": "col-6"
}inv_taxident_status
Umsatzsteuer-ID Status
TEXT
R+W
yes
enum[
"invalid",
"valid_conditional",
"valid_confirmed"
]fieldset"tax"listCfg{
"viewMode": 0
}formCfg{
"cssLayout": "col-6",
"type": "eosdropdown",
"options": {
"data": {
"options": [
{
"value": null,
"name": "nicht \u00fcberpr\u00fcft"
},
{
"value": "invalid",
"name": "ung\u00fcltig"
},
{
"value": "valid_conditional",
"name": "bedingt g\u00fcltig"
},
{
"value": "valid_confirmed",
"name": "g\u00fcltig"
}
]
}
}
}inv_third_country_export
Ausfuhrbescheinigung
TEXT
R+W
yes
enum[
"none",
"certificate_promised",
"certificate_received"
]fieldset"tax"listCfg{
"viewMode": 0
}formCfg{
"type": "eosdropdown",
"options": {
"data": {
"options": [
{
"value": "",
"name": ""
},
{
"value": "none",
"name": "keine vorhanden"
},
{
"value": "certificate_promised",
"name": "angek\u00fcndigt"
},
{
"value": "certificate_received",
"name": "erhalten"
}
]
}
}
}inv_deliver_country
Lieferland
TEXT
R+W
yes
fieldset"tax"listCfg{
"viewMode": 0
}formCfg{
"type": "eosdropdown",
"options": {
"dataStreamCall": {
"method": "country_getlist",
"params": {
"sql": {
"order": "cy_default DESC,cy_name ASC"
}
}
},
"optValueField": "cy_iso",
"optNameField": "cy_name"
}
}fieldset"tax"listCfg{
"viewMode": 0
}fieldset"tax"listCfg{
"viewMode": 0
}formCfg{
"editMode": 0
}input_translatedWählen Sie die Zahlungsart aus, über die diese Rechnung beglichen werden soll.
fieldset"payment"listCfg{
"viewMode": 0
}input_translatedWählen Sie hier das Konto des Kunden aus, von dem der Rechnungsbetrag eingezogen werden soll.
Bitte beachten Sie:
Die Auswahl ist nur sinnvoll, wenn es sich bei der Zahlungsart z.B. um eine Lastschrift handelt, die direkt von Ihnen selbst veranlasst wird. In den meisten anderen Fällen (Drittanbieter-Bezahlung, Vorkasse) können Sie dieses Feld leer lassen.
Bitte beachten Sie:
Die Auswahl ist nur sinnvoll, wenn es sich bei der Zahlungsart z.B. um eine Lastschrift handelt, die direkt von Ihnen selbst veranlasst wird. In den meisten anderen Fällen (Drittanbieter-Bezahlung, Vorkasse) können Sie dieses Feld leer lassen.
fieldset"payment"listCfg{
"viewMode": 0
}inv_pay_profile_xdata
Zahlungsziel-Daten
DATA
R+W
yes
fieldset"payment"listCfg{
"viewMode": 0
}drvd_amount_not_paid
[EUR]
Ausstehender Rechnungsbetrag
FLOAT (13,2)
R
no
drvd_selectIF(ecs_invoice.inv_status='open', ecs_invoice.inv_amount-ecs_invoice.inv_amount_paid,0.00)listCfg{
"formatter": {
"type": "currency"
},
"sumType": "SV"
}drvd_amount_open_days
[d]
Offen seit ... Tagen
INT
R
no
drvd_selectIF(ecs_invoice.inv_status='open',DATEDIFF(CURDATE(),ecs_invoice.inv_time_invoice),NULL)drvd_days_until_paid
[d]
Bezahlt nach ... Tagen
INT
R
no
drvd_selectIF(ecs_invoice.inv_status='done',DATEDIFF(ecs_invoice.inv_time_paid,ecs_invoice.inv_time_invoice),NULL)drvd_inv_name
Name (kombiniert)
TEXT
R
no
drvd_selectCONCAT_WS("",ecs_invoice.inv_company,IF(ecs_invoice.inv_company IS NOT NULL AND (ecs_invoice.inv_firstname IS NOT NULL OR ecs_invoice.inv_lastname IS NOT NULL),", ",""),ecs_invoice.inv_firstname,IF(ecs_invoice.inv_firstname IS NOT NULL," ",""),ecs_invoice.inv_lastname)inv_reminder_level
INT (11)
R+W
yes
inv_reminder_data
Mahndaten
TEXT
R
yes
inv_reminder_profile_label
Mahnprofil
TEXT (127)
R+W
yes
inv_reminder_time_last_sent
Letzte Mahnung gesendet
DATETIME
R
yes
inv_reminder_time_last_change
Letzte Mahnstufe-Änderung
DATETIME
R
yes
drvd_reminder_profile_name
angewendetes Mahnprofil
TEXT (127)
R
yes
table[
"ecs_invoice_reminder_profile"
]drvd_selectecs_invoice_reminder_profile.profile_namedrvd_reminder_profile_label
angewendetes Mahnprofil-Label
TEXT (127)
R
yes
table[
"ecs_invoice_reminder_profile"
]drvd_selectecs_invoice_reminder_profile.profile_labelprofile_steps
Mahnstufen
TEXT
R
yes
table[
"ecs_invoice_reminder_profile"
]drvd_selectecs_invoice_reminder_profile.profile_stepsinv_reminder_prop_level
Mahnstufe (vorgeschlagen)
INT (11)
R+W
yes
inv_reminder_prop_xdata
Mahnstufen-Daten (vorgeschlagen)
TEXT
R
yes
inv_reminder_prop_time
Mahnstufen-Vorschlag (Berechnung)
DATETIME
R
yes
inv_reminder_suspend_time
Mahnstopp Zeitpunkt
DATETIME
R
yes
inv_extcollect_time
Inkasso-Übergabe
DATETIME
R
yes
inv_extcollect_code
Inkasso Code
TEXT (127)
R
yes
inv_extcollect_xdata
Inkasso-Daten
TEXT
R
yes
cy_name
Name
TEXT (63)
R+W
no
input_translatedVollständiger Landesname
i18n_string"ecs.COUNTRY.cy_name"table[
"ecs_country"
]listCfg{
"viewMode": 0
}formCfg{
"editMode": 0
}cy_nameshort
Kurzname
TEXT (15)
R+W
no
input_translatedKurzname für Adressangaben
i18n_string"ecs.COUNTRY.cy_nameshort"table[
"ecs_country"
]listCfg{
"viewMode": 0
}formCfg{
"editMode": 0
}drvd_inv_state_name
Bundesland
TEXT
R
no
table[
"inv_terr_state"
]drvd_selectinv_terr_state.terr_namelistCfg{
"viewMode": 0
}formCfg{
"editMode": 0
}drvd_inv_state_path
Bundesland (Pfad)
TEXT
R
no
table[
"inv_terr_state"
]drvd_selectinv_terr_state.i18n_node_path_DElistCfg{
"viewMode": 0
}formCfg{
"editMode": 0
}drvd_inv_info_others
Weitere Rechnungen zum Auftrag
DATA
R
yes
table"ecs_invoice_others"drvd_selectCONCAT("{\"model\": \"invoice\",\"primaryKey\": \"inv_id\",\"displayKey\": \"inv_code\",\"data\": [",
GROUP_CONCAT(DISTINCT IF(ecs_invoice_others.inv_id IS NULL, null, JSON_OBJECT(
'inv_id',ecs_invoice_others.inv_id,
'inv_code',ecs_invoice_others.inv_code,
'inv_time_invoice', ecs_invoice_others.inv_time_invoice,
'inv_amount',ecs_invoice_others.inv_amount,
'inv_status_color',CASE ecs_invoice_others.inv_status WHEN "open" THEN "#CE0002" WHEN "done" THEN "#85B200" ELSE NULL END
)) ORDER BY ecs_invoice_others.inv_id ASC SEPARATOR ","),"]}")listCfg{
"viewMode": 0,
"formatter": {
"type": "sub-data-chip",
"params": {
"chipOptions": {
"subTitleTemplate": "{% inv_amount|money(2) %} \u20ac ({% inv_time_invoice|date() %})",
"statusColorField": "inv_status_color"
}
}
}
}formCfg{
"editMode": 0
}drvd_inv_codes_others
Weitere Rg.Nummern zum Auftrag
TEXT
R
no
table[
"ecs_invoice_others"
]drvd_selectGROUP_CONCAT(DISTINCT ecs_invoice_others.inv_code)listCfg{
"viewMode": 0
}formCfg{
"editMode": 0
}drvd_dv_info
Lieferungen zum Auftrag
DATA
R
yes
table[
"ecs_delivery"
]drvd_selectCONCAT(" {\"model\": \"delivery\",\"primaryKey\": \"did\",\"displayKey\": \"dv_code\",\"data\": [",
GROUP_CONCAT(DISTINCT IF(ecs_delivery.did IS NULL, null, JSON_OBJECT(
'did',ecs_delivery.did,
'dv_code', ecs_delivery.dv_code
)) ORDER BY ecs_delivery.did ASC SEPARATOR ",") ,"]}")listCfg{
"viewMode": 0,
"formatter": {
"type": "sub-data-chip"
}
}formCfg{
"editMode": 0
}drvd_dv_codes
Lfg.Nummern zum Auftrag
TEXT
R
no
table[
"ecs_delivery"
]drvd_selectGROUP_CONCAT(DISTINCT ecs_delivery.dv_code)listCfg{
"viewMode": 0
}formCfg{
"editMode": 0
}drvd_inv_amount_total
[EUR]
Gesamtrechnungsbetrag zum Auftrag
FLOAT (13,2)
R
no
table[
"ecs_invoice",
"ecs_invoice_others"
]drvd_selectIF(ecs_invoice_others.inv_amount IS NOT NULL,ecs_invoice.inv_amount + SUM(ecs_invoice_others.inv_amount)/IF (count(ecs_invoice_others.inv_id), (count(ecs_invoice.inv_id)/count(distinct ecs_invoice_others.inv_id)),1),ecs_invoice.inv_amount)listCfg{
"formatter": {
"type": "currency"
},
"viewMode": 0,
"sumType": "SV"
}formCfg{
"editMode": 0
}drvd_inv_amount_others
[EUR]
∑ Weitere Rechnungsbeträge zum Auftrag
FLOAT (13,2)
R
no
table[
"ecs_invoice_others"
]drvd_selectSUM(ecs_invoice_others.inv_amount)/IF (count(ecs_invoice_others.inv_id), (count(ecs_invoice.inv_id)/count(distinct ecs_invoice_others.inv_id)),1)listCfg{
"formatter": {
"type": "currency"
},
"viewMode": 0,
"sumType": "SV"
}formCfg{
"editMode": 0
}drvd_inv_amount_not_paid_others
[EUR]
∑ Ausstehende weitere Rechnungsbeträge zum Auftrag
FLOAT (13,2)
R
no
table[
"ecs_invoice_others"
]drvd_selectSUM(IF(ecs_invoice_others.inv_status='open', ecs_invoice_others.inv_amount-ecs_invoice_others.inv_amount_paid,0.00))/IF (count(ecs_invoice_others.inv_id), (count(ecs_invoice.inv_id)/count(distinct ecs_invoice_others.inv_id)),1)listCfg{
"formatter": {
"type": "currency"
},
"viewMode": 0,
"sumType": "SV"
}formCfg{
"editMode": 0
}drvd_inv_amount_not_paid_total
[EUR]
Ausstehender Gesamtrechnungsbetrag für den Auftrag
FLOAT (13,2)
R
no
table[
"ecs_invoice",
"ecs_invoice_others"
]drvd_selectIF(ecs_invoice_others.inv_amount IS NOT NULL,(IF(ecs_invoice.inv_status='open', ecs_invoice.inv_amount-ecs_invoice.inv_amount_paid,0.00) + SUM(IF(ecs_invoice_others.inv_status='open', ecs_invoice_others.inv_amount-ecs_invoice_others.inv_amount_paid,0.00))/IF (count(ecs_invoice_others.inv_id), (count(ecs_invoice.inv_id)/count(distinct ecs_invoice_others.inv_id)),1)),IF(ecs_invoice.inv_status='open', ecs_invoice.inv_amount-ecs_invoice.inv_amount_paid,0.00))listCfg{
"formatter": {
"type": "currency"
},
"viewMode": 0,
"sumType": "SV"
}formCfg{
"editMode": 0
}drvd_inv_amount_total_netto
[EUR]
Rechnungsbetrag (netto)
FLOAT (13,2)
R
no
table[
"ecs_invoice_item"
]drvd_selectSUM(ROUND(IF(ecs_invoice_item.invi_price_single_netto IS NOT NULL, ecs_invoice_item.invi_price_single_netto, (ecs_invoice_item.invi_price_single_brutto / ( (100+ecs_invoice_item.invi_vat_pct) / 100 ) )) * ecs_invoice_item.invi_quantity, 2))/IF (count(ecs_invoice_item.invi_id), (count(ecs_invoice_item.invi_id)/count(distinct ecs_invoice_item.invi_id)),1)listCfg{
"formatter": {
"type": "currency"
},
"viewMode": 0,
"sumType": "SV"
}formCfg{
"editMode": 0
}drvd_inv_amount_total_vat
[EUR]
MwSt. gesamt
FLOAT (13,2)
R
no
table[
"ecs_invoice",
"ecs_invoice_item"
]drvd_selectecs_invoice.inv_amount - SUM(ROUND(IF(ecs_invoice_item.invi_price_single_netto IS NOT NULL, ecs_invoice_item.invi_price_single_netto, (ecs_invoice_item.invi_price_single_brutto / ( (100+ecs_invoice_item.invi_vat_pct) / 100 ) )) * ecs_invoice_item.invi_quantity,2))/IF (count(ecs_invoice_item.invi_id), (count(ecs_invoice_item.invi_id)/count(distinct ecs_invoice_item.invi_id)),1)listCfg{
"formatter": {
"type": "currency"
},
"viewMode": 0,
"sumType": "SV"
}formCfg{
"editMode": 0
}drvd_inv_itemlist
Rg.Posten
DATA
R
yes
table[
"ecs_invoice_item"
]drvd_selectCONCAT(" {\"model\": \"invoiceitem\",\"primaryKey\": \"invi_id\",\"displayKey\": \"invi_name\",\"data\": [",
GROUP_CONCAT(DISTINCT IF(ecs_invoice_item.invi_id IS NULL, null, JSON_OBJECT(
'invi_id',ecs_invoice_item.invi_id,
'invi_pcode', ecs_invoice_item.invi_pcode,
'invi_name',ecs_invoice_item.invi_name,
'invi_quantity',ecs_invoice_item.invi_quantity
)) ORDER BY ecs_invoice_item.invi_id ASC SEPARATOR ",") ,"]}")listCfg{
"viewMode": 0,
"formatter": {
"type": "sub-data-chip",
"params": {
"chipOptions": {
"subTitleTemplate": "{% invi_quantity|number(0) %}x {% invi_pcode %}"
}
}
}
}formCfg{
"editMode": 0
}drvd_min_invi_vesting_period_from
DATE
R
no
table[
"ecs_invoice_item"
]drvd_selectMIN(ecs_invoice_item.invi_vesting_period_from)listCfg{
"viewMode": 0
}formCfg{
"editMode": 0
}drvd_max_invi_vesting_period_to
DATE
R
no
table[
"ecs_invoice_item"
]drvd_selectMAX(ecs_invoice_item.invi_vesting_period_to)listCfg{
"viewMode": 0
}formCfg{
"editMode": 0
}inv_email_time_send
Letzter Rechnungsversand
DATETIME
R+W
no
listCfg{
"viewMode": 0
}formCfg{
"editMode": 2
}drvd_sum_trans_amount_complete
[EUR]
ZVg. abgeschlossen
FLOAT (13,2)
R
no
table[
"ecs_payment_transaction"
]drvd_select(SUM(IF((ecs_payment_transaction.tr_time_completed IS NOT NULL), ecs_payment_transaction.transamount, 0) )/IF(COUNT(ecs_payment_transaction.transid),(COUNT(ecs_invoice.inv_id) /COUNT(DISTINCT ecs_payment_transaction.transid)),1) )listCfg{
"formatter": {
"type": "currency"
},
"viewMode": 0,
"sumType": "SV"
}formCfg{
"editMode": 0
}drvd_sum_trans_amount_inproc
[EUR]
ZVg. in Ausführung
FLOAT (13,2)
R
no
table[
"ecs_payment_transaction"
]drvd_select(SUM(IF((ecs_payment_transaction.tr_time_completed IS NULL AND ecs_payment_transaction.tr_time_exec IS NOT NULL), ecs_payment_transaction.transamount, 0) )/IF(COUNT(ecs_payment_transaction.transid),(COUNT(ecs_invoice.inv_id) /COUNT(DISTINCT ecs_payment_transaction.transid)),1) )listCfg{
"formatter": {
"type": "currency"
},
"viewMode": 0,
"sumType": "SV"
}formCfg{
"editMode": 0
}drvd_sum_trans_amount_waitreturn
[EUR]
ZVg. WaitReturn
FLOAT (13,2)
R
no
table[
"ecs_payment_transaction"
]drvd_select(SUM(IF((ecs_payment_transaction.tr_time_exec IS NULL), ecs_payment_transaction.transamount, 0) )/IF(COUNT(ecs_payment_transaction.transid),(COUNT(ecs_invoice.inv_id) /COUNT(DISTINCT ecs_payment_transaction.transid)),1) )listCfg{
"formatter": {
"type": "currency"
},
"viewMode": 0,
"sumType": "SV"
}formCfg{
"editMode": 0
}drvd_last_transaction
letzte Zahlung
DATETIME
R
no
table[
"ecs_payment_transaction"
]drvd_selectMAX(IFNULL( ecs_payment_transaction.tr_time_completed, NULL) )listCfg{
"viewMode": 0
}formCfg{
"editMode": 0
}drvd_sum_trans_amount_open
[EUR]
ZVg. offen
FLOAT (13,2)
R
no
table[
"ecs_invoice",
"ecs_payment_transaction"
]drvd_selectROUND( ABS(ecs_invoice.inv_amount - (SUM( IF( (ecs_payment_transaction.tr_time_completed IS NOT NULL), ecs_payment_transaction.transamount, 0) )/IF(COUNT(ecs_payment_transaction.transid),(COUNT(ecs_invoice.inv_id) /COUNT(DISTINCT ecs_payment_transaction.transid)),1) )),2)listCfg{
"formatter": {
"type": "currency"
},
"viewMode": 0,
"sumType": "SV"
}formCfg{
"editMode": 0
}drvd_sum_trans_amount_diff_brutto
[EUR]
ZVg.-Rg.Differenz
FLOAT (13,2)
R
no
table[
"ecs_invoice",
"ecs_payment_transaction"
]drvd_selectROUND( ABS(ecs_invoice.inv_amount - (SUM(IFNULL(ecs_payment_transaction.transamount,0))/IF(COUNT(ecs_payment_transaction.transid),(COUNT(ecs_invoice.inv_id) /COUNT(DISTINCT ecs_payment_transaction.transid)),1) )),2)listCfg{
"formatter": {
"type": "currency"
},
"viewMode": 0,
"sumType": "SV"
}formCfg{
"editMode": 0
}drvd_transactions_pys_desc
Zahlungsarten
TEXT
R
no
table[
"ecs_payment_service"
]drvd_selectGROUP_CONCAT(DISTINCT(ecs_payment_service.pys_desc) SEPARATOR ';')listCfg{
"viewMode": 0
}formCfg{
"editMode": 0
}drvd_transactions_info
Zahlungsvorgänge
DATA
R
yes
table[
"ecs_payment_transaction",
"ecs_payment_service"
]drvd_selectCONCAT(" {\"model\": \"transaction\",\"primaryKey\": \"transid\",\"displayKey\": \"pys_desc\",\"data\": [",
GROUP_CONCAT(DISTINCT IF(ecs_payment_transaction.transid IS NULL, null, JSON_OBJECT(
'transid',ecs_payment_transaction.transid,
'drvd_trans_summary', CONCAT(ecs_payment_service.pys_desc,": ",FORMAT(ecs_payment_transaction.transamount,2)," €"),
'transamount',ecs_payment_transaction.transamount,
'pys_desc',ecs_payment_service.pys_desc,
'transstate', ecs_payment_transaction.transstate,
'drvd_transcolor',IF(ecs_payment_transaction.transstate = "cancel","grey",
IF(ecs_payment_transaction.tr_time_completed IS NOT NULL,"green",
IF(ecs_payment_transaction.tr_time_exec IS NOT NULL,"orange","red")))
)) ORDER BY ecs_payment_transaction.transid ASC SEPARATOR ",") ,"]}")listCfg{
"viewMode": 1,
"formatter": {
"type": "sub-data-chip",
"params": {
"chipOptions": {
"subTitleTemplate": "{% transamount|money(2) %} \u20ac ({% transstate %})",
"statusColorField": "drvd_transcolor"
}
}
}
}formCfg{
"editMode": 0
}order
Following fields can also be selected for reading (JOIN)
oid
INT (11)
R
yes
table[
"eos_order"
]listCfg{
"viewMode": 3
}formCfg{
"editMode": 0
}orderid
Auftrags-Nr.
TEXT (63)
R
no
i18n_string"ecs.ORDER.orderid"table[
"eos_order"
]listCfg{
"full_search": true,
"formatter": {
"type": "model-primary",
"params": {
"model": "order",
"primaryKey": "oid",
"statusColorField": "order_state_color",
"subTitleTemplate": "{%invoice_firstname %} {%invoice_lastname%}"
}
}
}formCfg{
"editMode": 0
}input_translatedWählen Sie den Shop aus, zu dem dieser Auftrag gehört.
i18n_string"ecs.ORDER.fk_o_shopid"table[
"eos_order"
]fieldset"marketing"listCfg{
"viewMode": 0
}formCfg{
"editMode": 0
}input_translatedGeben Sie die Kunden-ID eines Kunden ein.
i18n_string"ecs.ORDER.fk_o_persid"table[
"eos_order"
]fieldset"base_record"listCfg{
"viewMode": 0
}formCfg{
"cssLayout": "col-12 col-md-6 col-xl-3",
"mandatory": true,
"editMode": 0
}o_time_ordered
Bestelldatum
DATETIME
R
yes
i18n_string"ecs.ORDER.o_time_ordered"table[
"eos_order"
]fieldset"base_record"listCfg{
"formatter": {
"type": "date"
},
"viewMode": 0
}formCfg{
"cssLayout": "col-12 col-md-6 col-xl-3",
"editMode": 0
}total_netto
[EUR]
∑ Gesamt, Netto
FLOAT (13,2)
R
no
i18n_string"ecs.ORDER.total_netto"table[
"eos_order"
]listCfg{
"formatter": {
"type": "currency"
},
"viewMode": 0,
"sumType": "SV"
}formCfg{
"editMode": 0
}total_brutto
[EUR]
∑ Gesamt, Brutto
FLOAT (13,2)
R
no
i18n_string"ecs.ORDER.total_brutto"table[
"eos_order"
]listCfg{
"formatter": {
"type": "currency"
},
"sumType": "SV",
"viewMode": 0
}formCfg{
"editMode": 0
}o_orderid_external
Externe Auftrags-Nr.
TEXT (255)
R
yes
input_translatedGeben Sie hier ggf. eine externe erhaltene Auftragsnummer ein. Diese bekommen Sie z.B. wenn der Auftrag über einen externen Marktplatz (z.B. Amazon Marketplace) erstellt wurde.
i18n_string"ecs.ORDER.o_orderid_external"table[
"eos_order"
]fieldset"base"listCfg{
"viewMode": 0
}formCfg{
"cssLayout": "col-12 col-md-6 col-xl-3",
"editMode": 0
}i18n_string"ecs.ORDER.fk_o_posid"table[
"eos_order"
]fieldset"base"listCfg{
"viewMode": 0
}formCfg{
"cssLayout": "col-12 col-md-6 col-xl-3",
"editMode": 0
}i18n_string"ecs.ORDER.fk_o_stid"table[
"eos_order"
]fieldset"base"listCfg{
"viewMode": 3
}formCfg{
"cssLayout": "col-12 col-md-6 col-xl-3",
"editMode": 0
}i18n_string"ecs.ORDER.fk_o_st_id"table[
"eos_order"
]fieldset"base"listCfg{
"viewMode": 3
}formCfg{
"cssLayout": "col-12 col-md-6 col-xl-3",
"editMode": 0
}o_pers_reftext
Kunden-Referenztext
TEXT
R
yes
input_translatedGeben Sie einen Referenztext des Kunden ein.
i18n_string"ecs.ORDER.o_pers_reftext"table[
"eos_order"
]listCfg{
"viewMode": 0
}formCfg{
"editMode": 0
}o_pers_seq_nr
Auftrags-Sequenz-Nr.
INT (11)
R
no
i18n_string"ecs.ORDER.o_pers_seq_nr"table[
"eos_order"
]listCfg{
"viewMode": 0
}formCfg{
"editMode": 0
}quantity
Bestellmenge
FLOAT (13,4)
R
no
i18n_string"ecs.ORDER.quantity"table[
"eos_order"
]listCfg{
"viewMode": 0,
"sumType": "SV"
}formCfg{
"editMode": 0
}drvd_total_vat
[EUR]
MwSt. (Gesamt)
FLOAT (13,2)
R
no
i18n_string"ecs.ORDER.drvd_total_vat"table[
"eos_order"
]drvd_selectROUND(eos_order.total_brutto - eos_order.total_netto, 2)listCfg{
"formatter": {
"type": "currency"
},
"viewMode": 0,
"sumType": "SV"
}formCfg{
"editMode": 0
}currency
Währung
TEXT (3)
R
no
i18n_string"ecs.ORDER.currency"table[
"eos_order"
]listCfg{
"viewMode": 0
}formCfg{
"editMode": 0
}otitle
Auftragstitel
TEXT
R
yes
input_translatedGeben Sie dem Auftrag einen Titel.
i18n_string"ecs.ORDER.otitle"table[
"eos_order"
]fieldset"doc_header"listCfg{
"viewMode": 0
}formCfg{
"cssLayout": "col-12",
"editMode": 0
}otext
Auftragsbeschreibung
TEXT
R
yes
i18n_string"ecs.ORDER.otext"table[
"eos_order"
]fieldset"extra"listCfg{
"viewMode": 0
}formCfg{
"type": "textarea",
"editMode": 0
}o_type
Auftragstyp
TEXT (15)
R
yes
enum[
"order",
"offer"
]i18n_string"ecs.ORDER.o_type"table[
"eos_order"
]fieldset"base_record"listCfg{
"viewMode": 0
}formCfg{
"cssLayout": "col-12 col-md-6 col-xl-3",
"type": "eosdropdown",
"value": "order",
"options": {
"optI18nValuePrefix": "ecs.o_type",
"optI18nName": true,
"data": {
"options": [
{
"value": "order"
},
{
"value": "offer"
},
{
"value": "tpl"
}
]
}
},
"editMode": 0
}o_valid_until
Gültig bis
DATETIME
R
yes
i18n_string"ecs.ORDER.o_valid_until"table[
"eos_order"
]listCfg{
"viewMode": 0,
"formatter": {
"type": "date"
}
}formCfg{
"type": "datetimepicker",
"editMode": 0
}o_txt_header
Kopf-Text
TEXT
R
yes
input_translatedKopf-Text für die Verwendung in PDFs
i18n_string"ecs.ORDER.o_txt_header"table[
"eos_order"
]fieldset"doc_header"listCfg{
"viewMode": 0,
"fullSearch": true
}formCfg{
"fieldSetCol": "12",
"type": "eoseditor",
"editMode": 0
}invoice_addr_preset
Adressbuch (R)
TEXT
R
yes
i18n_string"ecs.ORDER.invoice_addr_preset"table[
"eos_order"
]drvd_selectNULLfieldset"inv_addr"listCfg{
"viewMode": 3
}formCfg{
"cssLayout": "col-12",
"type": "eosdropdown",
"options": {
"serverSideSearch": false,
"valueType": "object",
"optNameTemplate": "{%adr_lastname%}, {%adr_firstname%} ({%adr_company%})",
"optSubTitleTemplate": "{%adr_extra1%} {%adr_street%} {%adr_housenr%}, {%adr_zip%} {%adr_town%} - {%adr_country%}",
"optExtraTemplate": "{%adr_ref_type%}",
"optDataLoad": [
"adr_gender"
],
"observer": {
"fields": [
{
"field": "fk_o_persid",
"trigger": "onInit",
"exec": [
{
"cmd": "loadOptions",
"params": {
"dataStreamCall": {
"method": "paddress_getlist",
"params": {
"filter": {
"adr_ref_id": "{%FIELD.value%}"
}
}
}
}
}
]
},
{
"field": "fk_o_persid",
"trigger": "onChange",
"exec": [
{
"cmd": "loadOptions",
"params": {
"dataStreamCall": {
"method": "paddress_getlist",
"params": {
"filter": {
"adr_ref_id": "{%FIELD.value%}"
}
}
}
}
}
]
}
]
}
},
"editMode": 0
}invoice_gender
Anrede (R)
TEXT
R
yes
enum[
"female",
"male",
"company",
"divers"
]i18n_string"ecs.ORDER.invoice_gender"table[
"eos_order"
]fieldset"inv_addr"listCfg{
"viewMode": 0
}formCfg{
"cssLayout": "col-6 col-xl-2",
"type": "eosdropdown",
"options": {
"optI18nValuePrefix": "ecs.gender",
"optI18nName": true,
"data": {
"options": [
{
"value": null
},
{
"value": "female"
},
{
"value": "male"
},
{
"value": "company"
},
{
"value": "divers"
}
]
},
"observer": {
"fields": [
{
"field": "invoice_addr_preset",
"trigger": "onChange",
"exec": [
{
"cmd": "template",
"params": {
"tpl": "{% FIELD.value.data.adr_gender %}"
}
}
]
}
]
}
},
"editMode": 0
}invoice_title
Titel (R)
TEXT
R
no
i18n_string"ecs.ORDER.invoice_title"table[
"eos_order"
]fieldset"inv_addr"listCfg{
"viewMode": 0
}formCfg{
"cssLayout": "col-6 col-xl-2",
"type": "text",
"options": {
"observer": {
"fields": [
{
"field": "invoice_addr_preset",
"trigger": "onChange",
"exec": [
{
"cmd": "template",
"params": {
"tpl": "{% FIELD.value.data.adr_title %}"
}
}
]
}
]
}
},
"editMode": 0
}invoice_firstname
Vorname (R)
TEXT
R
no
i18n_string"ecs.ORDER.invoice_firstname"table[
"eos_order"
]fieldset"inv_addr"listCfg{
"viewMode": 0,
"fullSearch": true
}formCfg{
"cssLayout": "col-6 col-xl-4",
"type": "text",
"options": {
"observer": {
"fields": [
{
"field": "invoice_addr_preset",
"trigger": "onChange",
"exec": [
{
"cmd": "template",
"params": {
"tpl": "{% FIELD.value.data.adr_firstname%}"
}
}
]
}
]
}
},
"editMode": 0
}invoice_lastname
Nachname (R)
TEXT
R
no
i18n_string"ecs.ORDER.invoice_lastname"table[
"eos_order"
]fieldset"inv_addr"listCfg{
"fullSearch": true,
"viewMode": 0
}formCfg{
"cssLayout": "col-6 col-xl-4",
"type": "text",
"options": {
"observer": {
"fields": [
{
"field": "invoice_addr_preset",
"trigger": "onChange",
"exec": [
{
"cmd": "template",
"params": {
"tpl": "{% FIELD.value.data.adr_lastname %}"
}
}
]
}
]
}
},
"editMode": 0
}invoice_company
Firma (R)
TEXT
R
no
i18n_string"ecs.ORDER.invoice_company"table[
"eos_order"
]fieldset"inv_addr"listCfg{
"fullSearch": true,
"viewMode": 0
}formCfg{
"cssLayout": "col-6",
"type": "text",
"options": {
"observer": {
"fields": [
{
"field": "invoice_addr_preset",
"trigger": "onChange",
"exec": [
{
"cmd": "template",
"params": {
"tpl": "{% FIELD.value.data.adr_company %}"
}
}
]
}
]
}
},
"editMode": 0
}invoice_addrextra
Adressenzusatz
TEXT
R
no
i18n_string"ecs.ORDER.invoice_addrextra"table[
"eos_order"
]fieldset"inv_addr"listCfg{
"viewMode": 0
}formCfg{
"cssLayout": "col-6",
"type": "text",
"options": {
"observer": {
"fields": [
{
"field": "invoice_addr_preset",
"trigger": "onChange",
"exec": [
{
"cmd": "template",
"params": {
"tpl": "{% FIELD.value.data.adr_extra1 %}"
}
}
]
}
]
}
},
"editMode": 0
}invoice_street
Straße (R)
TEXT
R
no
i18n_string"ecs.ORDER.invoice_street"table[
"eos_order"
]fieldset"inv_addr"listCfg{
"viewMode": 0
}formCfg{
"cssLayout": "col-9",
"type": "text",
"options": {
"observer": {
"fields": [
{
"field": "invoice_addr_preset",
"trigger": "onChange",
"exec": [
{
"cmd": "template",
"params": {
"tpl": "{% FIELD.value.data.adr_street %}"
}
}
]
}
]
}
},
"editMode": 0
}invoice_housenr
Hausnummer (R)
TEXT
R
no
i18n_string"ecs.ORDER.invoice_housenr"table[
"eos_order"
]fieldset"inv_addr"listCfg{
"viewMode": 0
}formCfg{
"cssLayout": "col-3",
"type": "text",
"options": {
"observer": {
"fields": [
{
"field": "invoice_addr_preset",
"trigger": "onChange",
"exec": [
{
"cmd": "template",
"params": {
"tpl": "{% FIELD.value.data.adr_housenr %}"
}
}
]
}
]
}
},
"editMode": 0
}invoice_zip
PLZ (R)
TEXT
R
no
i18n_string"ecs.ORDER.invoice_zip"table[
"eos_order"
]fieldset"inv_addr"listCfg{
"viewMode": 0
}formCfg{
"cssLayout": "col-4",
"type": "text",
"options": {
"observer": {
"fields": [
{
"field": "invoice_addr_preset",
"trigger": "onChange",
"exec": [
{
"cmd": "template",
"params": {
"tpl": "{% FIELD.value.data.adr_zip %}"
}
}
]
}
]
}
},
"editMode": 0
}invoice_town
Ort (R)
TEXT
R
no
i18n_string"ecs.ORDER.invoice_town"table[
"eos_order"
]fieldset"inv_addr"listCfg{
"fullSearch": true,
"viewMode": 0
}formCfg{
"cssLayout": "col-8",
"type": "text",
"options": {
"observer": {
"fields": [
{
"field": "invoice_addr_preset",
"trigger": "onChange",
"exec": [
{
"cmd": "template",
"params": {
"tpl": "{% FIELD.value.data.adr_town %}"
}
}
]
}
]
}
},
"editMode": 0
}invoice_state_code
Bundesland (Code) (R)
TEXT (15)
R
yes
i18n_string"ecs.ORDER.invoice_state_code"table[
"eos_order"
]fieldset"inv_addr"listCfg{
"viewMode": 0
}formCfg{
"cssLayout": "col-6",
"type": "eosdropdown",
"options": {
"dataStreamCall": {
"method": "state_getlist"
},
"serverSideSearch": false,
"optValueField": "terr_code",
"optNameField": "terr_name",
"optExtraField": "terr_code",
"observer": {
"fields": [
{
"field": "invoice_addr_preset",
"trigger": "onChange",
"exec": [
{
"cmd": "template",
"params": {
"tpl": "{%FIELD.value.data.adr_state_code%}"
}
}
]
},
{
"field": "invoice_country",
"trigger": "onInit",
"exec": [
{
"cmd": "loadOptions",
"params": {
"dataStreamCall": {
"method": "state_getlist",
"params": {
"filter": {
"state_country": "{%FIELD.value%}"
}
}
}
}
}
]
},
{
"field": "invoice_country",
"trigger": "onChange",
"exec": [
{
"cmd": "loadOptions",
"params": {
"dataStreamCall": {
"method": "state_getlist",
"params": {
"filter": {
"state_country": "{%FIELD.value%}"
}
}
}
}
}
]
}
]
}
},
"editMode": 0
}i18n_string"ecs.ORDER.invoice_country"table[
"eos_order"
]fieldset"inv_addr"listCfg{
"viewMode": 0,
"formatter": {
"type": "country-flag"
}
}formCfg{
"cssLayout": "col-6",
"options": {
"observer": {
"fields": [
{
"field": "invoice_addr_preset",
"trigger": "onChange",
"exec": [
{
"cmd": "template",
"params": {
"tpl": "{% FIELD.value.data.adr_country %}"
}
}
]
}
]
}
},
"editMode": 0
}invoice_type
Rechnungsart
TEXT
R
yes
enum[
"noncommercial",
"commercial"
]i18n_string"ecs.ORDER.invoice_type"table[
"eos_order"
]fieldset"inv_extra"listCfg{
"viewMode": 0
}formCfg{
"cssLayout": "col-4",
"type": "eosdropdown",
"options": {
"optI18nValuePrefix": "ecs.invoice_type",
"optI18nName": true,
"data": {
"options": [
{
"value": "noncommercial"
},
{
"value": "commercial"
}
]
}
},
"editMode": 0
}invoice_email
E-Mail (R)
TEXT
R
no
i18n_string"ecs.ORDER.invoice_email"table[
"eos_order"
]fieldset"inv_extra"listCfg{
"viewMode": 0
}formCfg{
"cssLayout": "col-4",
"editMode": 0
}invoice_taxidentnumber
USt.ID-Nr.
TEXT
R
no
i18n_string"ecs.ORDER.invoice_taxidentnumber"table[
"eos_order"
]fieldset"inv_extra"listCfg{
"viewMode": 0
}formCfg{
"cssLayout": "col-4",
"editMode": 0
}invoice_taxident_status
USt.ID-Nr. Status
TEXT
R
yes
enum[
"invalid",
"valid_conditional",
"valid_confirmed"
]i18n_string"ecs.ORDER.invoice_taxident_status"table[
"eos_order"
]fieldset"inv_extra"listCfg{
"viewMode": 0,
"formatter": {
"type": "status"
}
}formCfg{
"type": "eosdropdown",
"options": {
"optI18nValuePrefix": "ecs.taxident_status",
"optI18nName": true,
"data": {
"options": [
{
"value": null
},
{
"value": "invalid"
},
{
"value": "valid_conditional"
},
{
"value": "valid_confirmed"
}
]
}
},
"editMode": 0
}invoice_third_country_export
Ausfuhrbescheinigung
TEXT
R
yes
enum[
"none",
"certificate_promised",
"certificate_received"
]i18n_string"ecs.ORDER.invoice_third_country_export"table[
"eos_order"
]fieldset"inv_extra"listCfg{
"viewMode": 0
}formCfg{
"type": "eosdropdown",
"options": {
"optI18nValuePrefix": "ecs.invoice_third_country_export",
"optI18nName": true,
"data": {
"options": [
{
"value": "none"
},
{
"value": "certificate_promised"
},
{
"value": "certificate_received"
}
]
}
},
"editMode": 0
}invoice_lang_iso
Rechnungssprache
TEXT (2)
R
no
input_translatedGeben Sie den Sprache der Rechnung als ISO-Code (z.B. DE, EN) an.
i18n_string"ecs.ORDER.invoice_lang_iso"table[
"eos_order"
]fieldset"inv_extra"listCfg{
"viewMode": 0,
"formatter": {
"type": "country-flag"
}
}formCfg{
"editMode": 0
}drvd_invoice_street_housenr
Straße+Nr (R)
TEXT
R
no
i18n_string"ecs.ORDER.drvd_invoice_street_housenr"table[
"eos_order"
]drvd_selectCONCAT_WS("",eos_order.invoice_street," ",eos_order.invoice_housenr)listCfg{
"viewMode": 0
}formCfg{
"editMode": 0
}deliver_addr_preset
Adressbuch (L)
DATA
R
yes
i18n_string"ecs.ORDER.deliver_addr_preset"table[
"eos_order"
]drvd_selectNULLfieldset"dlv_addr"listCfg{
"viewMode": 3
}formCfg{
"cssLayout": "col-12",
"type": "eosdropdown",
"options": {
"serverSideSearch": false,
"valueType": "object",
"optNameTemplate": "{%adr_lastname%}, {%adr_firstname%} ({%adr_company%})",
"optSubTitleTemplate": "{%adr_extra1%} {%adr_street%} {%adr_housenr%}, {%adr_zip%} {%adr_town%} - {%adr_country%}",
"optExtraTemplate": "{%adr_ref_type%}",
"optDataLoad": [
"adr_gender"
],
"observer": {
"fields": [
{
"field": "fk_o_persid",
"trigger": "onInit",
"exec": [
{
"cmd": "loadOptions",
"params": {
"dataStreamCall": {
"method": "paddress_getlist",
"params": {
"filter": {
"adr_ref_id": "{%FIELD.value%}"
}
}
}
}
}
]
},
{
"field": "fk_o_persid",
"trigger": "onChange",
"exec": [
{
"cmd": "loadOptions",
"params": {
"dataStreamCall": {
"method": "paddress_getlist",
"params": {
"filter": {
"adr_ref_id": "{%FIELD.value%}"
}
}
}
}
}
]
}
]
}
},
"editMode": 0
}deliver_gender
Anrede (L)
TEXT
R
yes
enum[
"female",
"male",
"company",
"divers"
]i18n_string"ecs.ORDER.deliver_gender"table[
"eos_order"
]fieldset"dlv_addr"listCfg{
"viewMode": 0
}formCfg{
"cssLayout": "col-6 col-xl-2",
"type": "eosdropdown",
"options": {
"optI18nValuePrefix": "ecs.gender",
"optI18nName": true,
"data": {
"options": [
{
"value": null
},
{
"value": "female"
},
{
"value": "male"
},
{
"value": "company"
},
{
"value": "divers"
}
]
},
"observer": {
"fields": [
{
"field": "deliver_addr_preset",
"trigger": "onChange",
"exec": [
{
"cmd": "template",
"params": {
"tpl": "{% FIELD.value.data.adr_gender %}"
}
}
]
}
]
}
},
"editMode": 0
}deliver_title
Titel (L)
TEXT
R
no
i18n_string"ecs.ORDER.deliver_title"table[
"eos_order"
]fieldset"dlv_addr"listCfg{
"viewMode": 0
}formCfg{
"cssLayout": "col-6 col-xl-2",
"options": {
"observer": {
"fields": [
{
"field": "deliver_addr_preset",
"trigger": "onChange",
"exec": [
{
"cmd": "template",
"params": {
"tpl": "{%FIELD.value.data.adr_title%}"
}
}
]
}
]
}
},
"editMode": 0
}deliver_firstname
Vorname (L)
TEXT
R
no
i18n_string"ecs.ORDER.deliver_firstname"table[
"eos_order"
]fieldset"dlv_addr"listCfg{
"viewMode": 0
}formCfg{
"cssLayout": "col-6 col-xl-4",
"options": {
"observer": {
"fields": [
{
"field": "deliver_addr_preset",
"trigger": "onChange",
"exec": [
{
"cmd": "template",
"params": {
"tpl": "{%FIELD.value.data.adr_firstname%}"
}
}
]
}
]
}
},
"editMode": 0
}deliver_lastname
Nachname (L)
TEXT
R
no
i18n_string"ecs.ORDER.deliver_lastname"table[
"eos_order"
]fieldset"dlv_addr"listCfg{
"viewMode": 0,
"fullSearch": true
}formCfg{
"cssLayout": "col-6 col-xl-4",
"options": {
"observer": {
"fields": [
{
"field": "deliver_addr_preset",
"trigger": "onChange",
"exec": [
{
"cmd": "template",
"params": {
"tpl": "{%FIELD.value.data.adr_lastname%}"
}
}
]
}
]
}
},
"editMode": 0
}deliver_company
Firma (L)
TEXT
R
no
i18n_string"ecs.ORDER.deliver_company"table[
"eos_order"
]fieldset"dlv_addr"listCfg{
"viewMode": 0
}formCfg{
"cssLayout": "col-6",
"options": {
"observer": {
"fields": [
{
"field": "deliver_addr_preset",
"trigger": "onChange",
"exec": [
{
"cmd": "template",
"params": {
"tpl": "{%FIELD.value.data.adr_company%}"
}
}
]
}
]
}
},
"editMode": 0
}deliver_addrextra
Adressenzusatz
TEXT
R
no
i18n_string"ecs.ORDER.deliver_addrextra"table[
"eos_order"
]fieldset"dlv_addr"listCfg{
"viewMode": 0
}formCfg{
"cssLayout": "col-6",
"options": {
"observer": {
"fields": [
{
"field": "deliver_addr_preset",
"trigger": "onChange",
"exec": [
{
"cmd": "template",
"params": {
"tpl": "{%FIELD.value.data.adr_extra1%}"
}
}
]
}
]
}
},
"editMode": 0
}deliver_street
Straße (L)
TEXT
R
no
i18n_string"ecs.ORDER.deliver_street"table[
"eos_order"
]fieldset"dlv_addr"listCfg{
"viewMode": 0
}formCfg{
"cssLayout": "col-9",
"options": {
"observer": {
"fields": [
{
"field": "deliver_addr_preset",
"trigger": "onChange",
"exec": [
{
"cmd": "template",
"params": {
"tpl": "{%FIELD.value.data.adr_street%}"
}
}
]
}
]
}
},
"editMode": 0
}deliver_housenr
Hausnummer (L)
TEXT
R
no
i18n_string"ecs.ORDER.deliver_housenr"table[
"eos_order"
]fieldset"dlv_addr"listCfg{
"viewMode": 0
}formCfg{
"cssLayout": "col-3",
"options": {
"observer": {
"fields": [
{
"field": "deliver_addr_preset",
"trigger": "onChange",
"exec": [
{
"cmd": "template",
"params": {
"tpl": "{%FIELD.value.data.adr_housenr%}"
}
}
]
}
]
}
},
"editMode": 0
}deliver_zip
PLZ (L)
TEXT
R
no
i18n_string"ecs.ORDER.deliver_zip"table[
"eos_order"
]fieldset"dlv_addr"listCfg{
"viewMode": 0
}formCfg{
"cssLayout": "col-4",
"options": {
"observer": {
"fields": [
{
"field": "deliver_addr_preset",
"trigger": "onChange",
"exec": [
{
"cmd": "template",
"params": {
"tpl": "{%FIELD.value.data.adr_zip%}"
}
}
]
}
]
}
},
"editMode": 0
}deliver_town
Ort (L)
TEXT
R
no
i18n_string"ecs.ORDER.deliver_town"table[
"eos_order"
]fieldset"dlv_addr"listCfg{
"full_search": true,
"viewMode": 0
}formCfg{
"cssLayout": "col-8",
"options": {
"observer": {
"fields": [
{
"field": "deliver_addr_preset",
"trigger": "onChange",
"exec": [
{
"cmd": "template",
"params": {
"tpl": "{%FIELD.value.data.adr_town%}"
}
}
]
}
]
}
},
"editMode": 0
}deliver_state_code
Bundesland (Code) (L)
TEXT (15)
R
yes
i18n_string"ecs.ORDER.deliver_state_code"table[
"eos_order"
]fieldset"dlv_addr"listCfg{
"viewMode": 0
}formCfg{
"cssLayout": "col-6",
"type": "eosdropdown",
"options": {
"dataStreamCall": {
"method": "state_getlist"
},
"serverSideSearch": false,
"optValueField": "terr_code",
"optNameField": "terr_name",
"optExtraField": "terr_code",
"observer": {
"fields": [
{
"field": "deliver_addr_preset",
"trigger": "onChange",
"exec": [
{
"cmd": "template",
"params": {
"tpl": "{%FIELD.value.data.adr_state_code%}"
}
}
]
},
{
"field": "deliver_country",
"trigger": "onInit",
"exec": [
{
"cmd": "loadOptions",
"params": {
"dataStreamCall": {
"method": "state_getlist",
"params": {
"filter": {
"state_country": "{%FIELD.value%}"
}
}
}
}
}
]
},
{
"field": "deliver_country",
"trigger": "onChange",
"exec": [
{
"cmd": "loadOptions",
"params": {
"dataStreamCall": {
"method": "state_getlist",
"params": {
"filter": {
"state_country": "{%FIELD.value%}"
}
}
}
}
}
]
}
]
}
},
"editMode": 0
}i18n_string"ecs.ORDER.deliver_country"table[
"eos_order"
]fieldset"dlv_addr"listCfg{
"viewMode": 0,
"formatter": {
"type": "country-flag"
}
}formCfg{
"cssLayout": "col-6",
"options": {
"observer": {
"fields": [
{
"field": "deliver_addr_preset",
"trigger": "onChange",
"exec": [
{
"cmd": "template",
"params": {
"tpl": "{%FIELD.value.data.adr_country%}"
}
}
]
}
]
}
},
"editMode": 0
}deliver_date_req
Kunden-Wunschtermin
TEXT
R
no
i18n_string"ecs.ORDER.deliver_date_req"table[
"eos_order"
]fieldset"dlv_extra"listCfg{
"viewMode": 0
}formCfg{
"editMode": 0
}deliver_phone
Telefon
TEXT
R
no
i18n_string"ecs.ORDER.deliver_phone"table[
"eos_order"
]fieldset"dlv_extra"listCfg{
"viewMode": 0
}formCfg{
"editMode": 0
}deliver_email
E-Mail (L)
TEXT
R
no
i18n_string"ecs.ORDER.deliver_email"table[
"eos_order"
]fieldset"dlv_extra"listCfg{
"viewMode": 0
}formCfg{
"editMode": 0
}deliver_comment
Liefer-Hinweise
TEXT
R
no
input_translatedGeben Sie hier einen Lieferhinweis für den Lieferanten ein.
i18n_string"ecs.ORDER.deliver_comment"table[
"eos_order"
]fieldset"dlv_extra"listCfg{
"viewMode": 0
}formCfg{
"editMode": 0
}drvd_deliver_street_housenr
Straße+Nr (L)
TEXT
R
no
i18n_string"ecs.ORDER.drvd_deliver_street_housenr"table[
"eos_order"
]drvd_selectCONCAT_WS("",eos_order.deliver_street," ",eos_order.deliver_housenr)listCfg{
"viewMode": 0
}formCfg{
"editMode": 0
}deliver_notes_xdata
Lieferhinweise
DATA
R
yes
i18n_string"ecs.ORDER.deliver_notes_xdata"table[
"eos_order"
]fieldset"dlv_extra"listCfg{
"viewMode": 0
}formCfg{
"cssLayout": "col-12",
"type": "aceeditor",
"options": {
"mode": "json"
},
"editMode": 0
}ip_address
IP-Adresse
TEXT
R
yes
i18n_string"ecs.ORDER.ip_address"table[
"eos_order"
]fieldset"sys_record"listCfg{
"viewMode": 0
}formCfg{
"editMode": 0
}o_referrer
Referrer
TEXT
R
yes
i18n_string"ecs.ORDER.o_referrer"table[
"eos_order"
]fieldset"sys_record"listCfg{
"viewMode": 0
}formCfg{
"editMode": 0
}o_useragent
User-Agent
TEXT
R
yes
i18n_string"ecs.ORDER.o_useragent"table[
"eos_order"
]fieldset"sys_record"listCfg{
"viewMode": 0
}formCfg{
"editMode": 0
}o_comment
Kundenkommentar
TEXT
R
yes
input_translatedGeben Sie hier einen Kommentar zum Auftrag ein.
i18n_string"ecs.ORDER.o_comment"table[
"eos_order"
]fieldset"extra"listCfg{
"viewMode": 0
}formCfg{
"type": "textarea",
"editMode": 0
}o_comment_internal
Interner Bestellhinweis
TEXT
R
yes
input_translatedVergeben Sie hier einen internen Kommentar, z.B. für andere Auftragsbearbeiter.
i18n_string"ecs.ORDER.o_comment_internal"table[
"eos_order"
]fieldset"extra"listCfg{
"viewMode": 0
}formCfg{
"type": "textarea",
"editMode": 0
}o_lock_time
Bearbeitungs-Sperre (Zeitpunkt)
DATETIME
R
yes
i18n_string"ecs.ORDER.o_lock_time"table[
"eos_order"
]listCfg{
"viewMode": 0
}formCfg{
"editMode": 0
}o_lock_user
Bearbeitungs-Sperre (Benutzer)
TEXT (31)
R
yes
i18n_string"ecs.ORDER.o_lock_user"table[
"eos_order"
]listCfg{
"viewMode": 0
}formCfg{
"editMode": 0
}o_insert_time
Angelegt am
DATETIME
R
no
i18n_string"insert_time"table[
"eos_order"
]fieldset"sys_record"listCfg{
"viewMode": 0
}formCfg{
"editMode": 0
}o_update_time
Geändert am
DATETIME
R
yes
i18n_string"update_time"table[
"eos_order"
]fieldset"sys_record"listCfg{
"viewMode": 0
}formCfg{
"editMode": 0
}o_insert_user
Ersteller
TEXT (127)
R
yes
i18n_string"insert_user"table[
"eos_order"
]fieldset"sys_record"listCfg{
"formatter": {
"type": "user"
},
"viewMode": 0
}formCfg{
"editMode": 0
}o_update_user
Letzte Änderung durch
TEXT (127)
R
yes
i18n_string"update_user"table[
"eos_order"
]fieldset"sys_record"listCfg{
"viewMode": 0
}formCfg{
"editMode": 0
}input_translatedWählen Sie eine Kampagne aus, zu der dieser Auftrag zugeordnet werden soll.
i18n_string"ecs.ORDER.fk_o_campid"table[
"eos_order"
]fieldset"marketing"listCfg{
"viewMode": 0
}formCfg{
"cssLayout": "col-6",
"editMode": 0
}drvd_o_shoplabel
Shop
TEXT
R
no
i18n_string"ecs.ORDER.drvd_o_shoplabel"table[
"eos_order"
]drvd_selecteos_order.fk_o_shopidlistCfg{
"viewMode": 0
}formCfg{
"editMode": 0
}drvd_invoice_address
Auftrag-Rg.Adresse
TEXT
R
no
i18n_string"ecs.ORDER.drvd_invoice_address"table[
"eos_order"
]drvd_selectCONCAT(
IF(CHAR_LENGTH(eos_order.invoice_company)>0,CONCAT(eos_order.invoice_company,CHAR(13)),""),
TRIM(CONCAT(eos_order.invoice_title," ",eos_order.invoice_firstname," ",eos_order.invoice_lastname)),CHAR(13),
IF(CHAR_LENGTH(eos_order.invoice_addrextra)>0,CONCAT(eos_order.invoice_addrextra,CHAR(13)),""),
eos_order.invoice_street," ",eos_order.invoice_housenr,CHAR(13),
eos_order.invoice_country," - ",eos_order.invoice_zip," ",eos_order.invoice_town) listCfg{
"viewMode": 0
}formCfg{
"editMode": 0
}drvd_deliver_address
Auftrag-Lfg.Adresse
TEXT
R
no
i18n_string"ecs.ORDER.drvd_deliver_address"table[
"eos_order"
]drvd_selectCONCAT(
IF(CHAR_LENGTH(eos_order.deliver_company)>0,CONCAT(eos_order.deliver_company,CHAR(13)),""),
TRIM(CONCAT(eos_order.deliver_title," ",eos_order.deliver_firstname," ",eos_order.deliver_lastname)),CHAR(13),
IF(CHAR_LENGTH(eos_order.deliver_addrextra)>0,CONCAT(eos_order.deliver_addrextra,CHAR(13)),""),
eos_order.deliver_street," ",eos_order.deliver_housenr,CHAR(13),
eos_order.deliver_country," - ",eos_order.deliver_zip," ",eos_order.deliver_town) listCfg{
"viewMode": 0
}formCfg{
"editMode": 0
}o_pay_profile_xdata
Zahlungsziel-Daten
DATA
R
yes
i18n_string"ecs.ORDER.o_pay_profile_xdata"table[
"eos_order"
]listCfg{
"viewMode": 0
}formCfg{
"cssLayout": "col-12",
"type": "aceeditor",
"options": {
"mode": "json"
},
"editMode": 0
}i18n_string"ecs.plugin_companyaccount.fk_o_companyaccount_subaccount_persid"table[
"eos_order"
]fieldset"extra"listCfg{
"viewMode": 3
}formCfg{
"editMode": 0
}i18n_string"ecs.ORDER.fk_o_mrch_id"table[
"eos_order"
]fieldset"extra"listCfg{
"viewMode": 3
}formCfg{
"editMode": 0
}i18n_string"ecs.ORDER.fk_o_parent_oid"table[
"eos_order"
]fieldset"extra"listCfg{
"viewMode": 3
}formCfg{
"editMode": 0
}o_merchant_xdata
Anbieter (Zusatzdaten)
DATA
R
yes
i18n_string"ecs.ORDER.o_merchant_xdata"table[
"eos_order"
]fieldset"extra"listCfg{
"viewMode": 0
}formCfg{
"cssLayout": "col-12",
"type": "aceeditor",
"options": {
"mode": "json"
},
"editMode": 0
}o_periodic_time_first
Abo-Startdatum
DATETIME
R
yes
i18n_string"ecs.ORDER.o_periodic_time_first"table[
"eos_order"
]fieldset"time_settings"listCfg{
"viewMode": 3
}formCfg{
"type": "datetimepicker",
"cssLayout": "col-12 col-md-6 col-xl-6",
"editMode": 0
}o_periodic_time_last
Abo-Enddatum
DATETIME
R
yes
i18n_string"ecs.ORDER.o_periodic_time_last"table[
"eos_order"
]fieldset"time_settings"listCfg{
"viewMode": 3
}formCfg{
"type": "datetimepicker",
"cssLayout": "col-12 col-md-6 col-xl-6",
"editMode": 0
}o_periodic_time_next
Nächste Abo-Ausführung
DATETIME
R
yes
i18n_string"ecs.ORDER.o_periodic_time_next"table[
"eos_order"
]fieldset"time_settings"listCfg{
"viewMode": 3
}formCfg{
"editMode": 0,
"cssLayout": "col-12 col-md-6 col-xl-6"
}o_periodic_timeorder_offset
Abweichendes Auftragsdatum
TEXT (31)
R
no
i18n_string"ecs.ORDER.o_periodic_timeorder_offset"table[
"eos_order"
]fieldset"time_settings"listCfg{
"viewMode": 3,
"formatter": {
"type": "cron"
}
}formCfg{
"cssLayout": "col-12 col-md-6 col-xl-6",
"editMode": 0
}o_periodic_time_strict
Strikt
INT (1)
R
no
i18n_string"ecs.ORDER.o_periodic_time_strict"table[
"eos_order"
]fieldset"time_settings"listCfg{
"viewMode": 3,
"formatter": {
"type": "active-flag"
}
}formCfg{
"type": "checkbox",
"value": 1,
"editMode": 0
}o_periodic_exec_period
Abo-Intervall
TEXT (31)
R
no
i18n_string"ecs.ORDER.o_periodic_exec_period"table[
"eos_order"
]fieldset"time_settings"listCfg{
"viewMode": 3,
"formatter": {
"type": "cron"
}
}formCfg{
"type": "hfycron",
"editMode": 0
}o_periodic_exec_inprogress
Wird gerade ausgeführt
INT (1)
R
no
i18n_string"ecs.ORDER.o_periodic_exec_inprogress"table[
"eos_order"
]listCfg{
"viewMode": 3
}formCfg{
"editMode": 0
}o_periodic_xdata
DATA
R
yes
i18n_string"ecs.ORDER.o_periodic_xdata"table[
"eos_order"
]fieldset"time_settings_xdata"listCfg{
"viewMode": 0
}formCfg{
"type": "eossubform",
"hideLabel": true,
"options": {
"fieldDefinition": {
"time_paused": {
"type": "eossubformarray",
"options": {
"model": "time_paused",
"sortable": true,
"enableAdd": true,
"enableRemove": true,
"itemsMinCount": 0,
"itemsMaxCount": -1,
"fieldDefinition": {
"pause_start": {
"type": "datetimepicker",
"hideLabel": true
},
"pause_end": {
"type": "datetimepicker",
"hideLabel": true
}
},
"layoutSettings": {
"hideTabs": true,
"tabs": [
{
"label": "base",
"cssLayoutGroupDefault": "col-12",
"groups": [
{
"label": "time_paused",
"hideHeader": true,
"fdLabelLayoutDefault": "vt",
"fields": [
{
"field": "pause_start",
"cssLayout": "col-6"
},
{
"field": "pause_end",
"cssLayout": "col-6"
}
]
}
]
}
]
}
}
}
}
},
"editMode": 0
}drvd_weekday_timeordered
Wochentag
TEXT
R
no
i18n_string"ecs.ORDER.drvd_weekday_timeordered"table[
"eos_order"
]drvd_selectDATE_FORMAT(eos_order.o_time_ordered, '%a')listCfg{
"viewMode": 0
}formCfg{
"editMode": 0
}drvd_hour_timeordered
Stunde
TEXT
R
no
i18n_string"ecs.ORDER.drvd_hour_timeordered"table[
"eos_order"
]drvd_selectDATE_FORMAT(eos_order.o_time_ordered, '%H')listCfg{
"viewMode": 0
}formCfg{
"editMode": 0
}drvd_month_timeordered
Bestellmonat
TEXT
R
no
i18n_string"ecs.ORDER.drvd_month_timeordered"table[
"eos_order"
]drvd_selectDATE_FORMAT(eos_order.o_time_ordered, '%m')listCfg{
"viewMode": 0
}formCfg{
"editMode": 0
}drvd_dayofmonth_timeordered
Bestelltag im Monat
TEXT
R
no
i18n_string"ecs.ORDER.drvd_dayofmonth_timeordered"table[
"eos_order"
]drvd_selectDATE_FORMAT(eos_order.o_time_ordered, '%d')listCfg{
"viewMode": 0
}formCfg{
"editMode": 0
}drvd_timeonly_timeordered
Bestellzeit
TEXT
R
no
i18n_string"ecs.ORDER.drvd_timeonly_timeordered"table[
"eos_order"
]drvd_selectDATE_FORMAT(eos_order.o_time_ordered, '%H:%i')listCfg{
"viewMode": 0
}formCfg{
"editMode": 0
}drvd_cluster_seq
Erst-/Wiederkauf
TEXT
R
no
i18n_string"ecs.ORDER.drvd_cluster_seq"table[
"eos_order"
]drvd_selectIF(eos_order.o_pers_seq_nr > 1,"Wiederkauf","Erstkauf")listCfg{
"viewMode": 0
}formCfg{
"editMode": 0
}order_state_transtime
Transaktionszeit
DATETIME
R
no
i18n_string"ecs.ORDER.order_state_transtime"table[
"eos_statelog"
]drvd_selecteos_statelog.transtimelistCfg{
"viewMode": 0
}formCfg{
"editMode": 0
}order_state_code
Auftragsstatus (Code)
TEXT (63)
R
no
i18n_string"ecs.ORDER.order_state_code"table[
"eos_states"
]drvd_selecteos_states.st_codelistCfg{
"viewMode": 0
}formCfg{
"editMode": 0
}order_state_color
Status-Farbe
TEXT (15)
R
no
i18n_string"ecs.ORDER.order_state_color"table[
"eos_states"
]drvd_selecteos_states.st_colorlistCfg{
"viewMode": 0
}formCfg{
"editMode": 0
}order_state_name
Auftragsstatus (Name)
TEXT
R
no
i18n_string"ecs.ORDER.order_state_name"valueColorField"order_state_color"table[
"eos_states"
]drvd_selecteos_states.i18n_st_name_DElistCfg{
"formatter": {
"type": "status",
"params": {
"statusColorField": "order_state_color"
}
},
"width": 192,
"viewMode": 0
}formCfg{
"editMode": 0
}order_state_name_public
Auftragsstatus (öffentlicher Name)
TEXT
R
no
i18n_string"ecs.ORDER.order_state_name_public"valueColorField"order_state_color"table[
"eos_states"
]drvd_selecteos_states.i18n_st_name_public_DElistCfg{
"viewMode": 0,
"formatter": {
"type": "status",
"params": {
"statusColorField": "order_state_color"
}
}
}formCfg{
"editMode": 0
}person
Following fields can also be selected for reading (JOIN)
persid
PersID
INT (11)
R
no
i18n_string"ecs.PERSON.persid"table[
"eos_person"
]personid
Kunden-Nr.
TEXT (32)
R
no
i18n_string"ecs.PERSON.personid"table[
"eos_person"
]listCfg{
"formatter": {
"type": "model-primary",
"params": {
"model": "person",
"primaryKey": "persid",
"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",
"subTitleTemplate": "{%firstname%} {%lastname%}"
}
}
}fk_p_shopid
Kunden-Nr.
INT (11)
R
no
i18n_string"ecs.PERSON.personid"table[
"eos_person"
]i18n_string"ecs.PERSON.fk_p_grpid"table[
"eos_person"
]fieldset"base_record"listCfg{
"viewMode": 3
}formCfg{
"cssLayout": "col-6",
"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_selectCASE 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 ENDlistCfg{
"viewMode": 3
}formCfg{
"editMode": 0
}title
Titel
TEXT
R
no
input_translatedGeben 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_translatedVorname 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_translatedTragen Sie hier das Geburtsdatum des Kunden ein.
Vorzugsweise im Format: tt.mm.JJJJ.
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_selectDATE_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_selectIF(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_selectIF(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
}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_selectCONCAT_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_selectCONCAT(
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_translatedStatus 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_selectIF(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_selectIF(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
}i18n_string"ecs.PERSON.p_oo_set_label"table[
"eos_person"
]fieldset"order_options"listCfg{
"viewMode": 0
}formCfg{
"editMode": 0
}i18n_string"ecs.PERSON.fk_p_pay_profile_id"table[
"eos_person"
]fieldset"order_options"listCfg{
"viewMode": 3
}formCfg{
"editMode": 0
}input_translatedEine 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_translatedDer 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
}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_selectmd5(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_translatedEine 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_selectNULLfieldset"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_selectDATE_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
}input_translatedVerknü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_translatedLegen 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_translatedStandard 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_translatedTragen 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_translatedGeben 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_translatedWä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_translatedTragen 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
}persongroup
Following fields can also be selected for reading (JOIN)
grpid
Kundengruppen-ID
INT (11)
R
no
i18n_string"ecs.PERSON.grpid"table[
"eos_person_group"
]listCfg{
"viewMode": 3
}formCfg{
"editMode": 0
}grp_name
Kundengruppe
TEXT (127)
R
no
input_translatedGeben Sie einen aussagekräftigen Namen für die Kundengruppe ein.
i18n_string"ecs.PERSONGRP.grp_name"table[
"eos_person_group"
]drvd_selecteos_person_group.grp_namelistCfg{
"viewMode": 0
}formCfg{
"editMode": 0
}description
Beschreibung
TEXT
R
no
input_translatedGeben Sie eine Beschreibung der Kundengruppe ein (z.B. für WEN wurde sie angelegt)
i18n_string"ecs.PERSONGRP.description"table[
"eos_person_group"
]drvd_selecteos_person_group.descriptionfieldset"base"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"type": "textarea",
"editMode": 0
}grp_default
Default
INT (1)
R
no
input_translatedAktivieren 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_selecteos_person_group.grp_defaultfieldset"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"
]drvd_selecteos_person_group.grp_p_login_activefieldset"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"
]drvd_selecteos_person_group.grp_localefieldset"defaults_person"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}grp_state
Bestellstatus
TEXT (63)
R
no
input_translatedTragen Sie hier den Eingangsstatus für Bestellung von Kunden aus dieser Kundengruppe ein.
i18n_string"ecs.PERSONGRP.grp_state"table[
"eos_person_group"
]drvd_selecteos_person_group.grp_statefieldset"defaults_order"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}grp_pos
POS Channel
TEXT (63)
R
no
input_translatedGeben 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_selecteos_person_group.grp_posfieldset"defaults_order"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}prc_display_mode
Preisanzeige
TEXT (15)
R
no
input_translatedWä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_selecteos_person_group.prc_display_modefieldset"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_translatedDer 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_selecteos_person_group.grp_price_factorfieldset"prices"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"cssLayout": "col-12",
"type": "eosnumber",
"editMode": 0
}input_translatedFalls 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_selecteos_person_group.fk_grp_prcgrp_idfieldset"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_selecteos_person_group.grp_persongrp_pricesfieldset"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_translatedGeben 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_selecteos_person_group.grp_price_colfieldset"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_selectIF(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_selectIF(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_selectIF(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"
]drvd_selecteos_person_group.grp_price_dsc_scale_colfieldset"price_col_cfg"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}grp_price_prcgrp_col
Preisgruppen-Spalte
TEXT (63)
R
no
input_translatedLegen 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_selecteos_person_group.grp_price_prcgrp_colfieldset"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"
]drvd_selecteos_person_group.grp_price_state_colfieldset"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"
]drvd_selecteos_person_group.grp_price_hide_price_dsp_colfieldset"price_col_cfg"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}input_translatedGeben 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_selecteos_person_group.grp_oo_set_labelfieldset"orderoptions"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}i18n_string"ecs.PERSONGRP.fk_grp_pay_profile_id"table[
"eos_person_group"
]drvd_selecteos_person_group.fk_grp_pay_profile_idfieldset"orderoptions"listCfg{
"viewMode": 3,
"fullSearch": false
}formCfg{
"editMode": 0
}data
Daten
DATA
R
yes
input_translatedGeben Sie hier zusätzliche Daten als Array an.
array(
'var1' => 'wert1',
'var2' => 'wert2',
)
array(
'var1' => 'wert1',
'var2' => 'wert2',
)
i18n_string"ecs.PERSONGRP.data"table[
"eos_person_group"
]drvd_selecteos_person_group.datafieldset"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_translatedWählen Sie hier die Benutzer-Rollen für die Kundengruppen aus.
i18n_string"ecs.plugin_shopuserright.grp_shopuserright_profiles"table[
"eos_person_group"
]drvd_selecteos_person_group.grp_shopuserright_profileslistCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}grp_shopuserright_rights
Gruppen-Rechte
TEXT
R
yes
input_translatedTragen Sie hier einzelne Benutzer-Rechte für die Kundengruppe ein.
i18n_string"ecs.plugin_shopuserright.grp_shopuserright_rights"table[
"eos_person_group"
]drvd_selecteos_person_group.grp_shopuserright_rightslistCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}