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"
}
fk_inv_persidperson.persid
Kunde
INT (11)
R+W
yes
fieldset
"base"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "cssLayout": "col-12 col-md-6 col-xl-3"
}
inv_time_invoice
Rechnungs­­datum
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]
Rechnungs­­betrag
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_select
CASE ecs_invoice.inv_status WHEN "open" THEN "#CE0002" WHEN "done" THEN "#85B200" ELSE NULL END
listCfg
{
    "viewMode": 3
}
fk_inv_oidorder.oid
Auftrag
INT (11)
R+W
yes
input_translated
Diesem Auftrag wird die Rechnung zugeordnet.
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", "credit_memo" ]
drvd_select
IF(ecs_invoice.inv_amount < 0,"credit_memo","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_select
CONCAT_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%}"
                                        }
                                    }
                                }
                            }
                        }
                    ]
                }
            ]
        }
    }
}
inv_countrycountry.cy_iso
Land
TEXT
R+W
yes
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"
    }
}
inv_tax_countrycountry.cy_iso
Umsatzsteuer-Land
TEXT
R+W
yes
fieldset
"tax"
listCfg
{
    "viewMode": 0
}
inv_currencycurrency.cur_iso
Währung
TEXT (3)
R+W
yes
fieldset
"tax"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "editMode": 0
}
inv_pys_methodpaymentservice.pys_method
Zahlungsart
TEXT (31)
R+W
yes
input_translated
Wählen Sie die Zahlungsart aus, über die diese Rechnung beglichen werden soll.
fieldset
"payment"
listCfg
{
    "viewMode": 0
}
fk_inv_accidaccount.accid
Konto
INT (11)
R+W
yes
input_translated
Wä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.
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_select
IF(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_select
IF(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_select
IF(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_select
CONCAT_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_select
ecs_invoice_reminder_profile.profile_name
drvd_reminder_profile_label
angewendetes Mahnprofil-Label
TEXT (127)
R
yes
table
[ "ecs_invoice_reminder_profile" ]
drvd_select
ecs_invoice_reminder_profile.profile_label
profile_steps
Mahnstufen
TEXT
R
yes
table
[ "ecs_invoice_reminder_profile" ]
drvd_select
ecs_invoice_reminder_profile.profile_steps
inv_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_translated
Vollstä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_translated
Kurzname 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_select
inv_terr_state.terr_name
listCfg
{
    "viewMode": 0
}
formCfg
{
    "editMode": 0
}
drvd_inv_state_path
Bundesland (Pfad)
TEXT
R
no
table
[ "inv_terr_state" ]
drvd_select
inv_terr_state.i18n_node_path_DE
listCfg
{
    "viewMode": 0
}
formCfg
{
    "editMode": 0
}
drvd_inv_info_others
Weitere Rechnungen zum Auftrag
DATA
R
yes
table
"ecs_invoice_others"
drvd_select
CONCAT("{\"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_select
GROUP_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_select
CONCAT(" {\"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_select
GROUP_CONCAT(DISTINCT ecs_delivery.dv_code)
listCfg
{
    "viewMode": 0
}
formCfg
{
    "editMode": 0
}
drvd_inv_amount_total [EUR]
Gesamt­rechnungs­betrag zum Auftrag
FLOAT (13,2)
R
no
table
[ "ecs_invoice", "ecs_invoice_others" ]
drvd_select
IF(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_select
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)
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_select
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)
listCfg
{
    "formatter": {
        "type": "currency"
    },
    "viewMode": 0,
    "sumType": "SV"
}
formCfg
{
    "editMode": 0
}
drvd_inv_amount_not_paid_total [EUR]
Ausstehender Gesamt­rechnungs­betrag für den Auftrag
FLOAT (13,2)
R
no
table
[ "ecs_invoice", "ecs_invoice_others" ]
drvd_select
IF(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]
Rechnungs­­betrag (netto)
FLOAT (13,2)
R
no
table
[ "ecs_invoice_item" ]
drvd_select
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_amount_total_vat [EUR]
MwSt. gesamt
FLOAT (13,2)
R
no
table
[ "ecs_invoice", "ecs_invoice_item" ]
drvd_select
ecs_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_select
CONCAT(" {\"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_select
MIN(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_select
MAX(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_select
MAX(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_select
ROUND( 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_select
ROUND( 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_select
GROUP_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_select
CONCAT(" {\"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
}
fk_o_shopidshopconfig.eshopid
Shop
INT (11)
R
yes
input_translated
Wählen Sie den Shop aus, zu dem dieser Auftrag gehört.
i18n_string
"ecs.ORDER.fk_o_shopid"
table
[ "eos_order" ]
fieldset
"marketing"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "editMode": 0
}
fk_o_persidperson.persid
Kunde
INT (11)
R
yes
input_translated
Geben Sie die Kunden-ID eines Kunden ein.
i18n_string
"ecs.ORDER.fk_o_persid"
table
[ "eos_order" ]
fieldset
"base_record"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "cssLayout": "col-12 col-md-6 col-xl-3",
    "mandatory": true,
    "editMode": 0
}
o_time_ordered
Bestell­datum
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_translated
Geben Sie hier ggf. eine externe erhaltene Auftragsnummer ein. Diese bekommen Sie z.B. wenn der Auftrag über einen externen Marktplatz (z.B. Amazon Marketplace) erstellt wurde.
i18n_string
"ecs.ORDER.o_orderid_external"
table
[ "eos_order" ]
fieldset
"base"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "cssLayout": "col-12 col-md-6 col-xl-3",
    "editMode": 0
}
fk_o_posidorderpos.posid
POS Channel (ID)
INT (11)
R
yes
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
}
fk_o_stidorderstate.stid
Status
INT (11)
R
no
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
}
fk_o_st_idshippingtype.st_id
Versandart
INT (11)
R
no
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_translated
Geben 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_select
ROUND(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_translated
Geben 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_translated
Kopf-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_select
NULL
fieldset
"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
}
invoice_countrycountry.cy_iso
Land (R)
TEXT (2)
R
no
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_translated
Geben Sie den Sprache der Rechnung als ISO-Code (z.B. DE, EN) an.
i18n_string
"ecs.ORDER.invoice_lang_iso"
table
[ "eos_order" ]
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_select
CONCAT_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_select
NULL
fieldset
"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
}
deliver_countrycountry.cy_iso
Land (L)
TEXT (2)
R
no
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_translated
Geben 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_select
CONCAT_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_translated
Geben 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_translated
Vergeben 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
}
fk_o_campidcampaign.campid
Kampagne
INT (11)
R
no
input_translated
Wählen Sie eine Kampagne aus, zu der dieser Auftrag zugeordnet werden soll.
i18n_string
"ecs.ORDER.fk_o_campid"
table
[ "eos_order" ]
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_select
eos_order.fk_o_shopid
listCfg
{
    "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_select
CONCAT(
					IF(CHAR_LENGTH(eos_order.invoice_company)>0,CONCAT(eos_order.invoice_company,CHAR(13)),""),
					TRIM(CONCAT(eos_order.invoice_title," ",eos_order.invoice_firstname," ",eos_order.invoice_lastname)),CHAR(13),
					IF(CHAR_LENGTH(eos_order.invoice_addrextra)>0,CONCAT(eos_order.invoice_addrextra,CHAR(13)),""),
					eos_order.invoice_street," ",eos_order.invoice_housenr,CHAR(13),
					eos_order.invoice_country," - ",eos_order.invoice_zip," ",eos_order.invoice_town) 
listCfg
{
    "viewMode": 0
}
formCfg
{
    "editMode": 0
}
drvd_deliver_address
Auftrag-Lfg.Adresse
TEXT
R
no
i18n_string
"ecs.ORDER.drvd_deliver_address"
table
[ "eos_order" ]
drvd_select
CONCAT(
					IF(CHAR_LENGTH(eos_order.deliver_company)>0,CONCAT(eos_order.deliver_company,CHAR(13)),""),
					TRIM(CONCAT(eos_order.deliver_title," ",eos_order.deliver_firstname," ",eos_order.deliver_lastname)),CHAR(13),
					IF(CHAR_LENGTH(eos_order.deliver_addrextra)>0,CONCAT(eos_order.deliver_addrextra,CHAR(13)),""),
					eos_order.deliver_street," ",eos_order.deliver_housenr,CHAR(13),
					eos_order.deliver_country," - ",eos_order.deliver_zip," ",eos_order.deliver_town) 
listCfg
{
    "viewMode": 0
}
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
}
fk_o_companyaccount_subaccount_persidcompanysubaccount.persid
Unteraccount
INT (11)
R
yes
i18n_string
"ecs.plugin_companyaccount.fk_o_companyaccount_subaccount_persid"
table
[ "eos_order" ]
fieldset
"extra"
listCfg
{
    "viewMode": 3
}
formCfg
{
    "editMode": 0
}
fk_o_mrch_idmerchant.mrch_id
Verkaufender Anbieter
INT (11)
R
yes
i18n_string
"ecs.ORDER.fk_o_mrch_id"
table
[ "eos_order" ]
fieldset
"extra"
listCfg
{
    "viewMode": 3
}
formCfg
{
    "editMode": 0
}
fk_o_parent_oidorder.oid
Hauptauftrag
INT (11)
R
yes
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
Wochen­tag
TEXT
R
no
i18n_string
"ecs.ORDER.drvd_weekday_timeordered"
table
[ "eos_order" ]
drvd_select
DATE_FORMAT(eos_order.o_time_ordered, '%a')
listCfg
{
    "viewMode": 0
}
formCfg
{
    "editMode": 0
}
drvd_hour_timeordered
Stunde
TEXT
R
no
i18n_string
"ecs.ORDER.drvd_hour_timeordered"
table
[ "eos_order" ]
drvd_select
DATE_FORMAT(eos_order.o_time_ordered, '%H')
listCfg
{
    "viewMode": 0
}
formCfg
{
    "editMode": 0
}
drvd_month_timeordered
Bestell­monat
TEXT
R
no
i18n_string
"ecs.ORDER.drvd_month_timeordered"
table
[ "eos_order" ]
drvd_select
DATE_FORMAT(eos_order.o_time_ordered, '%m')
listCfg
{
    "viewMode": 0
}
formCfg
{
    "editMode": 0
}
drvd_dayofmonth_timeordered
Bestelltag im Monat
TEXT
R
no
i18n_string
"ecs.ORDER.drvd_dayofmonth_timeordered"
table
[ "eos_order" ]
drvd_select
DATE_FORMAT(eos_order.o_time_ordered, '%d')
listCfg
{
    "viewMode": 0
}
formCfg
{
    "editMode": 0
}
drvd_timeonly_timeordered
Bestellzeit
TEXT
R
no
i18n_string
"ecs.ORDER.drvd_timeonly_timeordered"
table
[ "eos_order" ]
drvd_select
DATE_FORMAT(eos_order.o_time_ordered, '%H:%i')
listCfg
{
    "viewMode": 0
}
formCfg
{
    "editMode": 0
}
drvd_cluster_seq
Erst-/Wiederkauf
TEXT
R
no
i18n_string
"ecs.ORDER.drvd_cluster_seq"
table
[ "eos_order" ]
drvd_select
IF(eos_order.o_pers_seq_nr > 1,"Wiederkauf","Erstkauf")
listCfg
{
    "viewMode": 0
}
formCfg
{
    "editMode": 0
}
order_state_transtime
Transaktionszeit
DATETIME
R
no
i18n_string
"ecs.ORDER.order_state_transtime"
table
[ "eos_statelog" ]
drvd_select
eos_statelog.transtime
listCfg
{
    "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_select
eos_states.st_code
listCfg
{
    "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_select
eos_states.st_color
listCfg
{
    "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_select
eos_states.i18n_st_name_DE
listCfg
{
    "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_select
eos_states.i18n_st_name_public_DE
listCfg
{
    "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" ]
fk_p_grpidpersongroup.grpid
Kundengruppe
INT (11)
R
no
i18n_string
"ecs.PERSON.fk_p_grpid"
table
[ "eos_person" ]
fieldset
"base_record"
listCfg
{
    "viewMode": 3
}
formCfg
{
    "cssLayout": "col-6",
    "editMode": 0
}
gender
Anrede
TEXT
R
yes
enum
[ "female", "male", "company", "divers" ]
i18n_string
"ecs.PERSON.gender"
valueColorField
"gender_color"
table
[ "eos_person" ]
fieldset
"base"
listCfg
{
    "width": 96,
    "viewMode": 0
}
formCfg
{
    "cssLayout": "col-3",
    "type": "eosdropdown",
    "options": {
        "optI18nValuePrefix": "ecs.gender",
        "optI18nName": true,
        "data": {
            "options": [
                {
                    "value": null
                },
                {
                    "value": "female"
                },
                {
                    "value": "male"
                },
                {
                    "value": "company"
                },
                {
                    "value": "divers"
                }
            ]
        }
    },
    "editMode": 0
}
gender_color
TEXT (15)
R
yes
i18n_string
"ecs.PERSON.gender_color"
table
[ "eos_person" ]
drvd_select
CASE eos_person.gender WHEN "female" THEN "#BF117F" WHEN "male" THEN "#1f96cb" WHEN "divers" THEN "#7D47B9" WHEN "company" THEN "#41cbd9" WHEN "unknown" THEN "#AAAAAA" ELSE NULL END
listCfg
{
    "viewMode": 3
}
formCfg
{
    "editMode": 0
}
title
Titel
TEXT
R
no
input_translated
Geben Sie hier einen Titel des Kunden an (z.B. Dr.).
i18n_string
"ecs.PERSON.title"
table
[ "eos_person" ]
fieldset
"base"
listCfg
{
    "width": 96,
    "viewMode": 0
}
formCfg
{
    "cssLayout": "col-3",
    "type": "eosdropdown",
    "options": {
        "addTag": true,
        "optValueField": "title",
        "optNameField": "title",
        "dataStreamCall": {
            "method": "datahub_generate_reportList",
            "params": {
                "ds_label": "person",
                "field_groupby": [
                    {
                        "field": "title"
                    }
                ]
            }
        }
    },
    "editMode": 0
}
salutation
Anrede formal
TEXT
R
no
i18n_string
"ecs.PERSON.salutation"
table
[ "eos_person" ]
fieldset
"base"
listCfg
{
    "viewMode": 0,
    "fullSearch": true
}
formCfg
{
    "cssLayout": "col-6",
    "type": "eosdropdown",
    "options": {
        "addTag": true,
        "optValueField": "salutation",
        "optNameField": "salutation",
        "dataStreamCall": {
            "method": "datahub_generate_reportList",
            "params": {
                "ds_label": "person",
                "field_groupby": [
                    {
                        "field": "salutation"
                    }
                ]
            }
        }
    },
    "editMode": 0
}
firstname
Vorname
TEXT
R
no
input_translated
Vorname der Registrierungsadresse.
i18n_string
"ecs.PERSON.firstname"
table
[ "eos_person" ]
fieldset
"base"
listCfg
{
    "width": 128,
    "viewMode": 0
}
formCfg
{
    "cssLayout": "col-6",
    "editMode": 0
}
lastname
Nachname
TEXT
R
no
i18n_string
"ecs.PERSON.lastname"
table
[ "eos_person" ]
fieldset
"base"
listCfg
{
    "width": 128,
    "viewMode": 0
}
formCfg
{
    "cssLayout": "col-6",
    "editMode": 0
}
bday
Geburtsdatum
DATE
R
yes
input_translated
Tragen Sie hier das Geburtsdatum des Kunden ein.

Vorzugsweise im Format: tt.mm.JJJJ.
i18n_string
"ecs.PERSON.bday"
table
[ "eos_person" ]
fieldset
"base"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "type": "datepicker",
    "options": {
        "showWeekdays": false,
        "showWeekNumbers": false,
        "minDate": {
            "day": 1,
            "month": 1,
            "year": "1900"
        }
    },
    "editMode": 0
}
drvd_age [y]
Alter
INT
R
yes
i18n_string
"ecs.PERSON.drvd_age"
table
[ "eos_person" ]
drvd_select
DATE_FORMAT(NOW(), '%Y') - DATE_FORMAT(eos_person.bday, '%Y') - (DATE_FORMAT(NOW(), '00-%m-%d') < DATE_FORMAT(eos_person.bday, '00-%m-%d'))
fieldset
"analytics"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "editMode": 0
}
drvd_bday_days_until_next [d]
Nächster Geburtstag (in Tagen)
INT
R
yes
i18n_string
"ecs.PERSON.drvd_bday_days_until_next"
table
[ "eos_person" ]
drvd_select
IF(DAYOFYEAR(eos_person.bday)>DAYOFYEAR(CURDATE()) , DATEDIFF(CONCAT(YEAR(CURDATE()),'-',MONTH(eos_person.bday),'-',DAY(eos_person.bday) ) , CURDATE() ), DATEDIFF(CONCAT(YEAR(CURDATE())+1,'-',MONTH(eos_person.bday),'-',DAY(eos_person.bday) ) , CURDATE()))
fieldset
"analytics"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "editMode": 0
}
drvd_bday_next
Nächster Geburtstag
DATE
R
yes
i18n_string
"ecs.PERSON.drvd_bday_next"
table
[ "eos_person" ]
drvd_select
IF(DAYOFYEAR(eos_person.bday)>DAYOFYEAR(CURDATE()) , CONCAT(YEAR(CURDATE()),'-',LPAD(MONTH(eos_person.bday),2,'0'),'-',LPAD(DAY(eos_person.bday),2,'0') ), CONCAT(YEAR(CURDATE())+1,'-',LPAD(MONTH(eos_person.bday),2,'0'),'-',LPAD(DAY(eos_person.bday),2,'0')))
fieldset
"analytics"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "editMode": 0
}
company
Firma
TEXT
R
no
i18n_string
"ecs.PERSON.company"
table
[ "eos_person" ]
fieldset
"addr"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "cssLayout": "col-4",
    "editMode": 0
}
p_department
Abteilung
TEXT
R
no
i18n_string
"ecs.PERSON.p_department"
table
[ "eos_person" ]
fieldset
"addr"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "cssLayout": "col-4",
    "type": "eosdropdown",
    "options": {
        "addTag": true,
        "optValueField": "p_department",
        "optNameField": "p_department",
        "dataStreamCall": {
            "method": "data_getList",
            "params": {
                "dataset": "person",
                "fieldGroupBy": [
                    {
                        "field": "p_department"
                    }
                ],
                "filter": {
                    "p_department": {
                        "search": "!$EMPTY"
                    }
                }
            }
        }
    },
    "editMode": 0
}
p_job_position
Position
TEXT
R
no
i18n_string
"ecs.PERSON.p_job_position"
table
[ "eos_person" ]
fieldset
"addr"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "cssLayout": "col-4",
    "type": "eosdropdown",
    "options": {
        "addTag": true,
        "optValueField": "p_job_position",
        "optNameField": "p_job_position",
        "dataStreamCall": {
            "method": "data_getList",
            "params": {
                "dataset": "person",
                "fieldGroupBy": [
                    {
                        "field": "p_job_position"
                    }
                ],
                "filter": {
                    "p_job_position": {
                        "search": "!$EMPTY"
                    }
                }
            }
        }
    },
    "editMode": 0
}
address2
Adressenzusatz
TEXT
R
no
i18n_string
"ecs.PERSON.address2"
table
[ "eos_person" ]
fieldset
"addr"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "cssLayout": "col-12",
    "editMode": 0
}
street
Straße
TEXT
R
no
i18n_string
"ecs.PERSON.street"
table
[ "eos_person" ]
fieldset
"addr"
listCfg
{
    "width": 96,
    "viewMode": 0
}
formCfg
{
    "cssLayout": "col-9",
    "editMode": 0
}
housenr
Hausnummer
TEXT
R
no
i18n_string
"ecs.PERSON.housenr"
table
[ "eos_person" ]
fieldset
"addr"
listCfg
{
    "width": 64,
    "viewMode": 0
}
formCfg
{
    "cssLayout": "col-3",
    "editMode": 0
}
zip
PLZ
TEXT
R
no
i18n_string
"ecs.PERSON.zip"
table
[ "eos_person" ]
fieldset
"addr"
listCfg
{
    "width": 64,
    "viewMode": 0
}
formCfg
{
    "cssLayout": "col-4",
    "editMode": 0
}
town
Ort
TEXT
R
no
i18n_string
"ecs.PERSON.town"
table
[ "eos_person" ]
fieldset
"addr"
listCfg
{
    "width": 96,
    "viewMode": 0
}
formCfg
{
    "cssLayout": "col-8",
    "editMode": 0
}
state_code
Bundesland (Code)
TEXT (15)
R
yes
i18n_string
"ecs.PERSON.state_code"
table
[ "eos_person" ]
fieldset
"addr"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "cssLayout": "col-6",
    "type": "eosdropdown",
    "options": {
        "serverSideSearch": false,
        "optValueField": "terr_code",
        "optNameField": "terr_name",
        "optExtraField": "terr_code",
        "observer": {
            "fields": [
                {
                    "field": "country",
                    "trigger": "onInit",
                    "exec": [
                        {
                            "cmd": "loadOptions",
                            "params": {
                                "dataStreamCall": {
                                    "method": "state_getlist",
                                    "params": {
                                        "filter": {
                                            "state_country": "{%FIELD.value%}"
                                        }
                                    }
                                }
                            }
                        }
                    ]
                },
                {
                    "field": "country",
                    "trigger": "onChange",
                    "exec": [
                        {
                            "cmd": "loadOptions",
                            "params": {
                                "dataStreamCall": {
                                    "method": "state_getlist",
                                    "params": {
                                        "filter": {
                                            "state_country": "{%FIELD.value%}"
                                        }
                                    }
                                }
                            }
                        }
                    ]
                }
            ]
        }
    },
    "editMode": 0
}
countrycountry.cy_iso
Land
TEXT (2)
R
no
i18n_string
"ecs.PERSON.country"
table
[ "eos_person" ]
fieldset
"addr"
listCfg
{
    "viewMode": 0,
    "width": 64,
    "formatter": {
        "type": "country-flag"
    }
}
formCfg
{
    "cssLayout": "col-6",
    "editMode": 0
}
drvd_person_name
Kundenname (kombiniert)
TEXT
R
no
i18n_string
"ecs.PERSON.drvd_person_name"
table
[ "eos_person" ]
drvd_select
CONCAT_WS("",eos_person.company,IF((eos_person.company IS NOT NULL AND eos_person.company != "") AND ((eos_person.firstname IS NOT NULL AND eos_person.firstname != "") OR (eos_person.lastname IS NOT NULL AND eos_person.lastname != "")),", ",""),eos_person.firstname,IF(eos_person.firstname IS NOT NULL," ",""),eos_person.lastname)
listCfg
{
    "viewMode": 0
}
formCfg
{
    "editMode": 0
}
drvd_p_address
Adresse
TEXT
R
yes
i18n_string
"ecs.PERSON.drvd_p_address"
table
[ "eos_person" ]
drvd_select
CONCAT(
		                IF(CHAR_LENGTH(eos_person.company)>0,CONCAT(eos_person.company,CHAR(13)),""),
		                TRIM(CONCAT(eos_person.title," ",eos_person.firstname," ",eos_person.lastname)),CHAR(13),
		                IF(CHAR_LENGTH(eos_person.address2)>0,CONCAT(eos_person.address2,CHAR(13)),""),
		                eos_person.street," ",eos_person.housenr,CHAR(13),
		                eos_person.country," - ",eos_person.zip," ",eos_person.town)
listCfg
{
    "viewMode": 0
}
formCfg
{
    "editMode": 0
}
email
E-Mail
TEXT (127)
R
no
i18n_string
"ecs.PERSON.email"
table
[ "eos_person" ]
fieldset
"communication"
listCfg
{
    "width": 256,
    "viewMode": 0
}
formCfg
{
    "type": "hfyemail",
    "cssLayout": "col-6",
    "editMode": 0
}
telephone
Telefon
TEXT
R
no
i18n_string
"ecs.PERSON.telephone"
table
[ "eos_person" ]
fieldset
"communication"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "type": "hfyphone",
    "cssLayout": "col-6",
    "editMode": 0
}
telephone_mobile
Tel. mobil
TEXT
R
no
i18n_string
"ecs.PERSON.telephone_mobile"
table
[ "eos_person" ]
fieldset
"communication"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "type": "hfyphone",
    "cssLayout": "col-6",
    "editMode": 0
}
telefax
Fax
TEXT
R
no
i18n_string
"ecs.PERSON.telefax"
table
[ "eos_person" ]
fieldset
"communication"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "type": "hfyphone",
    "cssLayout": "col-6",
    "editMode": 0
}
p_invoice_type
Rechnungsart
TEXT
R
yes
i18n_string
"ecs.PERSON.p_invoice_type"
table
[ "eos_person" ]
fieldset
"commercial"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "type": "eosdropdown",
    "options": {
        "optI18nValuePrefix": "ecs.invoice_type",
        "optI18nName": true,
        "data": {
            "options": [
                {
                    "value": "noncommercial"
                },
                {
                    "value": "commercial"
                }
            ]
        }
    },
    "editMode": 0
}
p_invoice_email
E-Mail (Rechnung)
TEXT
R
no
i18n_string
"ecs.PERSON.p_invoice_email"
table
[ "eos_person" ]
fieldset
"commercial"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "type": "hfyemail",
    "editMode": 0
}
taxident
Umsatzsteuer-ID
TEXT
R
no
i18n_string
"ecs.PERSON.taxident"
table
[ "eos_person" ]
fieldset
"commercial"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "editMode": 0
}
taxident_status
Umsatzsteuer-ID-Status
TEXT
R
yes
input_translated
Status der Umsatzsteuer-ID des Kundenkontos. Nur Kundenkonten mit bestätigter Umsatzsteuer-ID werden für Netto-Aufträge bei Lieferung in andere EU Länder berücksichtigt.
enum
[ "invalid", "valid_conditional", "valid_confirmed" ]
i18n_string
"ecs.PERSON.taxident_status"
table
[ "eos_person" ]
fieldset
"commercial"
listCfg
{
    "viewMode": 0,
    "formatter": {
        "type": "status"
    }
}
formCfg
{
    "type": "eosdropdown",
    "options": {
        "optI18nValuePrefix": "ecs.taxident_status",
        "optI18nName": true,
        "data": {
            "options": [
                {
                    "value": null
                },
                {
                    "value": "invalid"
                },
                {
                    "value": "valid_conditional"
                },
                {
                    "value": "valid_confirmed"
                }
            ]
        }
    },
    "editMode": 0
}
score
Bonitätswert
INT (7)
R
no
i18n_string
"ecs.PERSON.score"
table
[ "eos_person" ]
fieldset
"credit_rating"
listCfg
{
    "viewMode": 0,
    "sumType": "AVG"
}
formCfg
{
    "editMode": 0
}
score_time_set
Letzter Rating-Check
DATETIME
R
yes
i18n_string
"ecs.PERSON.score_time_set"
table
[ "eos_perso