Model fields

The model consists of the following fields.

Field Name
Display Name
Type
Permissions
Nullable

invoiceitem

invi_id primary auto increment
Rg-Id
INT (11)
R+W
no
fieldset
"base_record"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "type": "hidden"
}
invi_fk_inv_id → invoice.inv_id
Rechnung
INT (11)
R+W
no
fieldset
"base_record"
listCfg
{
    "viewMode": 3
}
formCfg
{
    "cssLayout": "col-6"
}
invi_fk_persid → person.persid
Kunde
INT (11)
R+W
no
fieldset
"base_record"
listCfg
{
    "viewMode": 3
}
formCfg
{
    "cssLayout": "col-6",
    "mandatory": true
}
invi_pos
Pos.
INT (4)
R+W
yes
fieldset
"base"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "cssLayout": "col-1"
}
invi_type
Typ
TEXT (15)
R+W
no
enum
[ "product", "shipping", "payment", "coupon", "couponprepaid", "document" ]
fieldset
"base"
formCfg
{
    "cssLayout": "col-2"
}
invi_pcode primaryDisplay
Produktcode
TEXT (255)
R+W
yes
fieldset
"base"
listCfg
{
    "fullSearch": true
}
formCfg
{
    "cssLayout": "col-3"
}
invi_name
Name
TEXT
R+W
yes
fieldset
"base"
listCfg
{
    "fullSearch": true
}
formCfg
{
    "cssLayout": "col-6"
}
invi_text
Text
TEXT
R+W
yes
fieldset
"base"
formCfg
{
    "type": "eoseditor",
    "options": {
        "useCfgPreset": "inlineBasic"
    }
}
invi_quantity
Anzahl
FLOAT (13,4)
R+W
no
fieldset
"base"
listCfg
{
    "sumType": "SV"
}
formCfg
{
    "cssLayout": "col-3",
    "type": "eosnumber",
    "options": {
        "decimalsCalculate": 4,
        "decimalshowMin": 0,
        "decimalshowMax": 4
    }
}
invi_vat_pct [%]
% MwSt.
FLOAT (6,2)
R+W
no
fieldset
"base"
listCfg
{
    "formatter": {
        "type": "decimal",
        "params": {
            "unit": " %",
            "format": "1.0-1"
        }
    }
}
formCfg
{
    "cssLayout": "col-3",
    "type": "eosnumber",
    "options": {
        "decimalsCalculate": 2,
        "decimalshowMin": 0,
        "decimalshowMax": 2
    }
}
invi_price_single_brutto [EUR]
Einzelpreis (brutto)
FLOAT (13,2)
R+W
yes
fieldset
"base"
listCfg
{
    "formatter": {
        "type": "currency"
    },
    "viewMode": 0
}
formCfg
{
    "cssLayout": "col-3",
    "type": "eosnumber",
    "options": {
        "decimalsCalculate": 2,
        "decimalshowMin": 2,
        "decimalshowMax": 2
    }
}
invi_time_insert
Angelegt am
DATETIME
R+W
no
i18n_string
"insert_time"
fieldset
"sys_record"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "editMode": 2
}
invi_time_update
Geändert am
DATETIME
R+W
yes
i18n_string
"update_time"
fieldset
"sys_record"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "editMode": 2
}
invi_user_insert
Ersteller
TEXT (127)
R+W
yes
i18n_string
"insert_user"
fieldset
"sys_record"
listCfg
{
    "formatter": {
        "type": "user"
    },
    "viewMode": 0
}
formCfg
{
    "editMode": 2
}
invi_user_update
Letzte Änderung durch
TEXT (127)
R+W
yes
i18n_string
"update_user"
fieldset
"sys_record"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "editMode": 2
}
drvd_invi_total_brutto [EUR]
Gesamt Brutto
FLOAT (13,2)
R
no
drvd_select
ROUND((IF(invi_price_single_brutto IS NOT NULL, invi_price_single_brutto, 
                            (invi_price_single_netto * ( (100+invi_vat_pct) / 100 ) )) * invi_quantity) ,2)
fieldset
"base"
listCfg
{
    "formatter": {
        "type": "currency"
    },
    "sumType": "SV"
}
formCfg
{
    "cssLayout": "col-3",
    "editMode": 2,
    "type": "eosnumber",
    "options": {
        "decimalsCalculate": 2,
        "decimalshowMin": 2,
        "decimalshowMax": 2
    }
}
drvd_invi_single_brutto [EUR]
Einzelpreis Brutto
FLOAT (13,2)
R
no
drvd_select
ROUND((IF(invi_price_single_brutto IS NOT NULL, invi_price_single_brutto, 
                        (invi_price_single_netto * ( (100+invi_vat_pct) / 100 ) ))) ,2)
fieldset
"base"
listCfg
{
    "formatter": {
        "type": "currency"
    },
    "viewMode": 0
}
formCfg
{
    "editMode": 0
}
invi_price_single_netto [EUR]
Einzelpreis (netto)
FLOAT (13,2)
R+W
yes
fieldset
"base"
listCfg
{
    "formatter": {
        "type": "currency"
    },
    "viewMode": 0
}
formCfg
{
    "cssLayout": "col-3",
    "editMode": 0
}
drvd_invi_single_netto [EUR]
Einzelpreis Netto
FLOAT (13,2)
R
no
drvd_select
ROUND((IF(invi_price_single_netto IS NOT NULL, invi_price_single_netto, 
                        (invi_price_single_brutto / ( (100+invi_vat_pct) / 100 ) )) ) ,2)
fieldset
"base"
listCfg
{
    "formatter": {
        "type": "currency"
    },
    "viewMode": 0
}
formCfg
{
    "cssLayout": "col-3",
    "editMode": 2,
    "type": "eosnumber",
    "options": {
        "decimalsCalculate": 2,
        "decimalshowMin": 2,
        "decimalshowMax": 2
    }
}
drvd_invi_total_netto [EUR]
Gesamt Netto
FLOAT (13,2)
R
no
drvd_select
ROUND((IF(invi_price_single_netto IS NOT NULL, invi_price_single_netto, (invi_price_single_brutto / ( (100+invi_vat_pct) / 100 ) )) * invi_quantity) ,2)
fieldset
"base"
listCfg
{
    "formatter": {
        "type": "currency"
    },
    "viewMode": 0,
    "sumType": "SV"
}
formCfg
{
    "cssLayout": "col-3",
    "editMode": 2,
    "type": "eosnumber",
    "options": {
        "decimalsCalculate": 2,
        "decimalshowMin": 2,
        "decimalshowMax": 2
    }
}
invi_price_single_brutto_xcurrency
Einzelpreis (brutto, X-Währung)
FLOAT (13,2)
R+W
yes
fieldset
"xcurrency"
listCfg
{
    "viewMode": 0
}
invi_price_single_netto_xcurrency
Einzelpreis (netto, X-Währung)
FLOAT (13,2)
R+W
yes
fieldset
"xcurrency"
listCfg
{
    "viewMode": 0
}
invi_xcurrency
X-Währung
TEXT (3)
R+W
no
fieldset
"xcurrency"
listCfg
{
    "viewMode": 0
}
drvd_invi_total_brutto_xcurrency
Gesamt Brutto (X-Währung)
FLOAT (13,2)
R
no
drvd_select
ROUND((IF(invi_price_single_brutto_xcurrency IS NOT NULL, invi_price_single_brutto_xcurrency, (invi_price_single_netto_xcurrency * ( (100+invi_vat_pct) / 100 ) )) * invi_quantity), 2)
fieldset
"xcurrency"
listCfg
{
    "viewMode": 0
}
drvd_invi_total_netto_xcurrency
Gesamt Netto (X-Währung)
FLOAT (13,2)
R
no
drvd_select
ROUND((IF(invi_price_single_netto_xcurrency IS NOT NULL, invi_price_single_netto_xcurrency, (invi_price_single_brutto_xcurrency / ( (100+invi_vat_pct) / 100 ) )) * invi_quantity), 2)
fieldset
"xcurrency"
listCfg
{
    "viewMode": 0
}
drvd_invi_price_single_brutto_xcurrency
Einzelpreis (brutto, X-Währung)
FLOAT (13,2)
R
no
drvd_select
ROUND((IF(invi_price_single_brutto_xcurrency IS NOT NULL, invi_price_single_brutto_xcurrency, (invi_price_single_netto_xcurrency * ( (100+invi_vat_pct) / 100 ) ))), 2)
fieldset
"xcurrency"
listCfg
{
    "viewMode": 0
}
drvd_invi_price_single_netto_xcurrency
Einzelpreis (netto, X-Währung)
FLOAT (13,2)
R
no
drvd_select
ROUND((IF(invi_price_single_netto_xcurrency IS NOT NULL, invi_price_single_netto_xcurrency, (invi_price_single_brutto_xcurrency / ( (100+invi_vat_pct) / 100 ) ))), 2)
fieldset
"xcurrency"
listCfg
{
    "viewMode": 0
}
invi_vesting_period_from
LZR Beginn
DATE
R+W
yes
fieldset
"vesting_period"
listCfg
{
    "viewMode": 0,
    "formatter": {
        "type": "date"
    }
}
formCfg
{
    "cssLayout": "col-6"
}
invi_vesting_period_to
LZR Ende
DATE
R+W
yes
fieldset
"vesting_period"
listCfg
{
    "viewMode": 0,
    "formatter": {
        "type": "date"
    }
}
formCfg
{
    "cssLayout": "col-6",
    "type": "date"
}
invi_xdata
Zusatzdaten
DATA
R+W
yes
fieldset
"extra"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "cssLayout": "col-12",
    "type": "aceeditor",
    "options": {
        "mode": "json"
    }
}
invi_contributionmargin_total_netto
Deckungsbeitrag
FLOAT (8,2)
R
yes
i18n_string
"ecs_plugin_profit_tracker.INVOICEITEM.invi_contributionmargin_total_netto"
drvd_invi_contributionmargin_total_netto_percent [%]
Deckungsbeitrag [%]
FLOAT (8,2)
R
yes
i18n_string
"ecs_plugin_profit_tracker.INVOICEITEM.invi_contributionmargin_total_netto_percent"
drvd_select
ROUND((invi_contributionmargin_total_netto*100)/(IF(invi_price_single_netto IS NOT NULL, invi_price_single_netto, (invi_price_single_brutto / ( (100+invi_vat_pct) / 100 ) )) * invi_quantity),2)
drvd_o_shoplabel
Shop
TEXT
R
no
i18n_string
"ecs.ORDER.drvd_o_shoplabel"
table
[ "eos_order" ]
drvd_select
fk_o_shopid
listCfg
{
    "viewMode": 0
}
pos_name
POS Channel
TEXT (127)
R+W
no
i18n_string
"ecs.ORDER.pos_name"
table
[ "eos_order_pos" ]
listCfg
{
    "viewMode": 0
}

product

Following fields can also be selected for reading (JOIN)

pcode
Pcode
R
no
drvd_select
invi_pcode
listCfg
{
    "viewMode": 3
}
xc__active
Aktiv
INT (1)
R
no
i18n_string
"cdb_record.xc__active"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"cdb_meta"
listCfg
{
    "formatter": {
        "type": "active-flag"
    },
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "checkbox",
    "value": true,
    "editMode": 0
}
xc__searchable
Suchbar
INT (1)
R
no
i18n_string
"cdb_record.xc__searchable"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"base"
listCfg
{
    "formatter": {
        "type": "active-flag"
    },
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "checkbox",
    "value": true,
    "editMode": 0
}
xc__version
Version
INT (11)
R
no
i18n_string
"cdb_record.xc__version"
table
[ "excdb_data_ecs_product_de" ]
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
xc__current
Aktuell
INT (1)
R
no
i18n_string
"cdb_record.xc__current"
table
[ "excdb_data_ecs_product_de" ]
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
xc__insert_user
Ersteller
TEXT (127)
R
yes
i18n_string
"insert_user"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"sys_record"
listCfg
{
    "formatter": {
        "type": "user"
    },
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
xc__insert_time
Angelegt am
DATETIME
R
no
i18n_string
"insert_time"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"sys_record"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
xc__valid
Valide
INT (1)
R
no
i18n_string
"cdb_record.xc__valid"
table
[ "excdb_data_ecs_product_de" ]
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
xc__update_time
Geändert am
DATETIME
R
yes
i18n_string
"update_time"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"sys_record"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
xc__install_time
Installiert am
DATETIME
R
no
i18n_string
"plugin_install_time"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"sys_plugin"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
xc__publish_start
Veröffentlichung (Start)
DATETIME
R
yes
i18n_string
"cdb_record.xc__publish_start"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"cdb_advanced"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "cssLayout": "col-6",
    "editMode": 0
}
xc__publish_end
Veröffentlichung (Ende)
DATETIME
R
yes
i18n_string
"cdb_record.xc__publish_end"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"cdb_advanced"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "cssLayout": "col-6",
    "editMode": 0
}
xc__update_user
Letzte Änderung durch
TEXT (127)
R
yes
i18n_string
"update_user"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"sys_record"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
xc__ecms_data
eCMS-Daten
TEXT
R
yes
i18n_string
"ecs.PRODUCT.xc__ecms_data"
table
[ "excdb_data_ecs_product_de" ]
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
xc__id
ID
INT (11)
R
no
i18n_string
"cdb_record.xc__id"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"cdb_base"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "HIDDEN",
    "editMode": 0
}
drvd_xc_display
Titel
TEXT
R
no
i18n_string
"cdb_record.xc__title"
table
[ "excdb_data_ecs_product_de" ]
drvd_select
COALESCE(excdb_data_ecs_product_de.name,excdb_data_ecs_product_de.pcode)
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
drvd_is_master
Ist Masterprodukt
INT (1)
R
no
i18n_string
"ecs.PRODUCT.drvd_is_master"
table
[ "excdb_data_ecs_product_de" ]
drvd_select
IF(excdb_data_ecs_product_de.pcode = excdb_data_ecs_product_de.master_pcode,1,0)
fieldset
"cdb_base"
listCfg
{
    "formatter": {
        "type": "active-flag"
    },
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
name
Name
TEXT
R
yes
i18n_string
"ecs.PRODUCT.name"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"cdb_base"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "mandatory": true,
    "editMode": 0
}
master_pcode
Varianten-Master PCode
TEXT
R
yes
input_translated
Bei Einzelprodukten (ohne Varianten) ist dies gleich dem PCode. Bei Variantenprodukten wird hier der PCode des Hauptprodukts der Variantengruppe eingetragen.
i18n_string
"ecs.PRODUCT.master_pcode"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"cdb_base"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "text",
    "options": {
        "XXXobserver": {
            "fields": [
                {
                    "field": "pcode",
                    "trigger": "onChange",
                    "exec": [
                        {
                            "cmd": "copy"
                        }
                    ]
                }
            ]
        }
    },
    "mandatory": true,
    "editMode": 0
}
prdv_color
Varianten-Farbe
TEXT
R
yes
i18n_string
"ecs.PRODUCT.prdv_color"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"cdb_base"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "eosdropdown",
    "options": {
        "addTag": true,
        "optValueField": "prdv_color",
        "optNameField": "prdv_color",
        "dataStreamCall": {
            "method": "datahub_generate_reportList",
            "params": {
                "ds_label": "product",
                "field_groupby": [
                    {
                        "field": "prdv_color"
                    }
                ]
            }
        }
    },
    "mandatory": false,
    "editMode": 0
}
prdv_size
Varianten-Größe
TEXT
R
yes
i18n_string
"ecs.PRODUCT.prdv_size"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"cdb_base"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "eosdropdown",
    "options": {
        "addTag": true,
        "optValueField": "prdv_size",
        "optNameField": "prdv_size",
        "dataStreamCall": {
            "method": "datahub_generate_reportList",
            "params": {
                "ds_label": "product",
                "field_groupby": [
                    {
                        "field": "prdv_size"
                    }
                ]
            }
        }
    },
    "mandatory": false,
    "editMode": 0
}
prdv_other
Varianten-Ausführung
TEXT
R
yes
i18n_string
"ecs.PRODUCT.prdv_other"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"cdb_base"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "eosdropdown",
    "options": {
        "addTag": true,
        "optValueField": "prdv_other",
        "optNameField": "prdv_other",
        "dataStreamCall": {
            "method": "datahub_generate_reportList",
            "params": {
                "ds_label": "product",
                "field_groupby": [
                    {
                        "field": "prdv_other"
                    }
                ]
            }
        }
    },
    "mandatory": false,
    "editMode": 0
}
prd_comment
Kommentar
TEXT
R
yes
i18n_string
"ecs.PRODUCT.prd_comment"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"comment"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "textarea",
    "mandatory": false,
    "editMode": 0
}
files_doc
Produkt-Dateien
DATA
R
yes
i18n_string
"ecs.PRODUCT.files_doc"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"cdb_media"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "eosmedia",
    "options": {
        "uploadDirDefault": "\/products"
    },
    "mandatory": false,
    "editMode": 0
}
pack_amount
Verpackungs­menge
FLOAT
R
yes
i18n_string
"ecs.PRODUCT.pack_amount"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"packaging"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "eosnumber",
    "mandatory": false,
    "editMode": 0
}
pack_unit
Verpackungs­einheit
TEXT
R
yes
i18n_string
"ecs.PRODUCT.pack_unit"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"packaging"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "text",
    "mandatory": false,
    "editMode": 0
}
prd_ingr_amount
Verpackungs­inhalt (Menge)
FLOAT
R
yes
i18n_string
"ecs.PRODUCT.prd_ingr_amount"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"packaging"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "eosnumber",
    "mandatory": false,
    "editMode": 0
}
prd_ingr_unit
Verpackungs­inhalt (Einheit)
TEXT
R
yes
i18n_string
"ecs.PRODUCT.prd_ingr_unit"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"packaging"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "text",
    "mandatory": false,
    "editMode": 0
}
prd_weight [g]
Produktgewicht
FLOAT
R
yes
i18n_string
"ecs.PRODUCT.prd_weight"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"dimensions"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "eosnumber",
    "mandatory": false,
    "editMode": 0
}
prd_virtual
Virtuelles Produkt
TEXT
R
yes
i18n_string
"ecs.PRODUCT.prd_virtual"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"virtual"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "checkbox",
    "mandatory": false,
    "editMode": 0
}
products_replace
Nachfolge­produkte
DATA
R
yes
input_translated
Produkte durch Drag-and-Drop hinzufügen. Beispielsweise aus der Trefferliste der "Hublify Suche".
i18n_string
"ecs.PRODUCT.products_replace"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"cdb_marketing"
listCfg
{
    "formatter": {
        "type": "sub-data-chip",
        "params": {
            "chipCssClass": "chip"
        }
    },
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "eossubmodel",
    "options": {
        "model": "cdb_record",
        "xDataKey": "r2r_xdata",
        "xDataDialogConfig": {
            "layoutLabel": "submodel_product_r2r_xdata_generic_popup"
        },
        "dataStreamCall": {
            "method": "datahub_generate_reportList",
            "params": {
                "ds_label": "product"
            }
        },
        "optValueField": "xc__id",
        "optNameField": "name"
    },
    "mandatory": false,
    "editMode": 0
}
pcode_manufacturer
Hersteller-PCode
TEXT
R
yes
i18n_string
"ecs.PRODUCT.pcode_manufacturer"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"cdb_base"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "text",
    "mandatory": false,
    "editMode": 0
}
brand
Brand
TEXT
R
yes
i18n_string
"ecs.PRODUCT.brand"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"cdb_base"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "mandatory": false,
    "editMode": 0
}
products_upselling
Upselling-Produkte
DATA
R
yes
input_translated
Produkte durch Drag-and-Drop hinzufügen. Beispielsweise aus der Trefferliste der "Hublify Suche".
i18n_string
"ecs.PRODUCT.products_upselling"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"cdb_marketing"
listCfg
{
    "formatter": {
        "type": "sub-data-chip",
        "params": {
            "chipCssClass": "chip"
        }
    },
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "eossubmodel",
    "options": {
        "model": "cdb_record",
        "xDataKey": "r2r_xdata",
        "xDataDialogConfig": {
            "layoutLabel": "submodel_product_r2r_xdata_generic_popup"
        },
        "dataStreamCall": {
            "method": "datahub_generate_reportList",
            "params": {
                "ds_label": "product"
            }
        },
        "optValueField": "xc__id",
        "optNameField": "name"
    },
    "mandatory": false,
    "editMode": 0
}
products_related
Zugehörige Produkte
DATA
R
yes
orderitem_name
Auftrags­posten-Name
TEXT
R
yes
i18n_string
"ecs.PRODUCT.orderitem_name"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"proc_order"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "text",
    "mandatory": false,
    "editMode": 0
}
orderitem_text
Auftrags­posten-Text
TEXT
R
yes
i18n_string
"ecs.PRODUCT.orderitem_text"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"proc_order"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "text",
    "mandatory": false,
    "editMode": 0
}
marketing_name
Marketing-Name
TEXT
R
yes
i18n_string
"ecs.PRODUCT.marketing_name"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"cdb_marketing"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "mandatory": false,
    "editMode": 0
}
marketing_teaser
Marketing-Teaser
TEXT
R
yes
i18n_string
"ecs.PRODUCT.marketing_teaser"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"cdb_marketing"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "eoseditor",
    "options": {
        "useCfgPreset": "basic"
    },
    "mandatory": false,
    "editMode": 0
}
marketing_image
Marketing-Bild
DATA
R
yes
i18n_string
"ecs.PRODUCT.marketing_image"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"cdb_marketing"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "eosmedia",
    "options": {
        "uploadDirDefault": "\/products"
    },
    "mandatory": false,
    "editMode": 0
}
new_product
Neues Produkt?
TEXT
R
yes
i18n_string
"ecs.PRODUCT.new_product"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"cdb_marketing"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "checkbox",
    "mandatory": false,
    "editMode": 0
}
special_offer_product
Special-Offer Produkt?
TEXT
R
yes
i18n_string
"ecs.PRODUCT.special_offer_product"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"cdb_marketing"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "checkbox",
    "mandatory": false,
    "editMode": 0
}
plugin
Plugin
TEXT
R
yes
i18n_string
"ecs.PRODUCT.plugin"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"cdb_advanced"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "mandatory": false,
    "editMode": 0
}
meta_title
Produkt-Meta-Titel
TEXT
R
yes
i18n_string
"ecs.PRODUCT.meta_title"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"cdb_meta"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "text",
    "mandatory": false,
    "editMode": 0
}
meta_keywords
Produkt-Meta-Keywords
TEXT
R
yes
i18n_string
"ecs.PRODUCT.meta_keywords"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"cdb_meta"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "text",
    "mandatory": false,
    "editMode": 0
}
meta_description
Produkt-Meta-Beschreibung
TEXT
R
yes
i18n_string
"ecs.PRODUCT.meta_description"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"cdb_meta"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "textarea",
    "mandatory": false,
    "editMode": 0
}
meta_robots_noindex
Produkt-Meta-Robots-NoIndex
TEXT
R
yes
i18n_string
"ecs.PRODUCT.meta_robots_noindex"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"cdb_meta"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "checkbox",
    "mandatory": false,
    "editMode": 0
}
meta_robots_nofollow
Produkt-Meta-Robots-NoFollow
TEXT
R
yes
i18n_string
"ecs.PRODUCT.meta_robots_nofollow"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"cdb_meta"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "checkbox",
    "mandatory": false,
    "editMode": 0
}
marketing_image_background
Marketing-Hintergrundbild
DATA
R
yes
i18n_string
"ecs.PRODUCT.marketing_image_background"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"cdb_marketing"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "eosmedia",
    "options": {
        "uploadDirDefault": "\/products"
    },
    "mandatory": false,
    "editMode": 0
}
marketing_overlay_html
Marketing-Overlay-HTML
TEXT
R
yes
i18n_string
"ecs.PRODUCT.marketing_overlay_html"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"cdb_marketing"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "mandatory": false,
    "editMode": 0
}
description_seo
SEO-Beschreibung
TEXT
R
yes
i18n_string
"ecs.PRODUCT.description_seo"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"cdb_meta"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "eoseditor",
    "mandatory": false,
    "editMode": 0
}
prd_width [mm]
Produktgröße - Breite
FLOAT
R
yes
i18n_string
"ecs.PRODUCT.prd_width"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"dimensions"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "eosnumber",
    "mandatory": false,
    "editMode": 0
}
prd_height [mm]
Produktgröße - Höhe
FLOAT
R
yes
i18n_string
"ecs.PRODUCT.prd_height"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"dimensions"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "eosnumber",
    "mandatory": false,
    "editMode": 0
}
prd_depth [mm]
Produktgröße - Tiefe
FLOAT
R
yes
i18n_string
"ecs.PRODUCT.prd_depth"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"dimensions"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "eosnumber",
    "mandatory": false,
    "editMode": 0
}
prd_rating_avg
FLOAT
R
yes
i18n_string
"ecs.PRODUCT.prd_rating_avg"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"cdb_base"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "hidden",
    "mandatory": false,
    "editMode": 0
}
prd_rating_cnt
TEXT
R
yes
i18n_string
"ecs.PRODUCT.prd_rating_cnt"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"cdb_base"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "hidden",
    "mandatory": false,
    "editMode": 0
}
convertable_pack_unit
DATA
R
yes
i18n_string
"ecs.PRODUCT.convertable_pack_unit"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"packaging"
listCfg
{
    "formatter": {
        "type": "sub-data-chip",
        "params": {
            "chipCssClass": "chip"
        }
    },
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "eossubmodel",
    "options": {
        "model": "cdb_record",
        "xDataKey": "r2r_xdata",
        "xDataDialogConfig": {
            "layoutLabel": "submodel_xdata_json_popup"
        },
        "dataStreamCall": {
            "method": "datahub_generate_reportList",
            "params": {
                "ds_label": "product"
            }
        },
        "optValueField": "xc__id",
        "optNameField": "name"
    },
    "mandatory": false,
    "editMode": 0
}
prd_accounting_cost_center
Buchhaltung Kostenstelle
TEXT
R
yes
i18n_string
"ecs.PRODUCT.prd_accounting_cost_center"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"proc_accounting"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "eosdropdown",
    "options": {
        "serverSideSearch": true,
        "addTag": true,
        "optValueField": "prd_accounting_cost_center",
        "optNameField": "prd_accounting_cost_center",
        "dataStreamCall": {
            "method": "datahub_generate_reportList",
            "params": {
                "ds_label": "product",
                "field_groupby": [
                    {
                        "field": "prd_accounting_cost_center"
                    }
                ]
            }
        }
    },
    "mandatory": false,
    "editMode": 0
}
prd_accounting_revenue_account
Buchhaltung Erlöskonto
TEXT
R
yes
i18n_string
"ecs.PRODUCT.prd_accounting_revenue_account"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"proc_accounting"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "eosdropdown",
    "options": {
        "serverSideSearch": true,
        "addTag": true,
        "optValueField": "prd_accounting_revenue_account",
        "optNameField": "prd_accounting_revenue_account",
        "dataStreamCall": {
            "method": "datahub_generate_reportList",
            "params": {
                "ds_label": "product",
                "field_groupby": [
                    {
                        "field": "prd_accounting_revenue_account"
                    }
                ]
            }
        }
    },
    "mandatory": false,
    "editMode": 0
}
base_color → color.xc__label
Grundfarbe
TEXT
R
yes
i18n_string
"ecs.PRODUCT.base_color"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"cdb_base"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "mandatory": false,
    "editMode": 0
}
html_canonical
TEXT
R
yes
i18n_string
"ecs.PRODUCT.html_canonical"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"cdb_meta"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "checkbox",
    "mandatory": false,
    "editMode": 0
}
pack_size_width [mm]
Verpackungs­größe - Breite
TEXT
R
yes
i18n_string
"ecs.PRODUCT.pack_size_width"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"packaging"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "mandatory": false,
    "editMode": 0
}
pack_size_height [mm]
Verpackungs­größe - Höhe
TEXT
R
yes
i18n_string
"ecs.PRODUCT.pack_size_height"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"packaging"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "mandatory": false,
    "editMode": 0
}
pack_size_depth [mm]
Verpackungs­größe - Tiefe
TEXT
R
yes
i18n_string
"ecs.PRODUCT.pack_size_depth"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"packaging"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "mandatory": false,
    "editMode": 0
}
pack_weight [g]
Verpackungs­gewicht
FLOAT
R
yes
i18n_string
"ecs.PRODUCT.pack_weight"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"packaging"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "eosnumber",
    "mandatory": false,
    "editMode": 0
}
features
DATA
R
yes
i18n_string
"ecs.PRODUCT.features"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"cdb_marketing"
listCfg
{
    "formatter": {
        "type": "sub-data-chip",
        "params": {
            "chipCssClass": "chip"
        }
    },
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "eossubmodel",
    "options": {
        "model": "cdb_record",
        "xDataKey": "r2r_xdata",
        "xDataDialogConfig": {
            "layoutLabel": "submodel_xdata_json_popup"
        },
        "dataStreamCall": {
            "method": "datahub_generate_reportList",
            "params": {
                "ds_label": "feature"
            }
        },
        "optValueField": "xc__id",
        "optNameField": "name",
        "optExtraField": "type"
    },
    "mandatory": false,
    "editMode": 0
}
gtin
GTIN/EAN
TEXT
R
yes
i18n_string
"ecs.PRODUCT.gtin"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"cdb_base"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "text",
    "mandatory": false,
    "editMode": 0
}
ppn
PPN
TEXT
R
yes
i18n_string
"ecs.PRODUCT.ppn"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"cdb_base"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "text",
    "mandatory": false,
    "editMode": 0
}
origin_country
Ursprungsland
TEXT
R
yes
i18n_string
"ecs.PRODUCT.origin_country"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"extra"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "mandatory": false,
    "editMode": 0
}
customs_tariff_number
HS-Tariff-Code
TEXT
R
yes
i18n_string
"ecs.PRODUCT.customs_tariff_number"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"extra"
listCfg
{
    "view_mode": 0,
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "mandatory": false,
    "editMode": 0
}
customs_value_amount
TEXT
R
yes
i18n_string
"ecs.PRODUCT.customs_value_amount"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"extra"
listCfg
{
    "view_mode": 0,
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "unit": "EUR",
    "type": "eosnumber",
    "options": {
        "decimalsCalculate": 2,
        "decimalshowMin": 2,
        "decimalshowMax": 2
    },
    "mandatory": false,
    "editMode": 0
}
customs_description
Zoll-Beschreibung
TEXT
R
yes
i18n_string
"ecs.PRODUCT.customs_description"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"extra"
listCfg
{
    "view_mode": 0,
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "mandatory": false,
    "editMode": 0
}
files_download
Download-Dateien
DATA
R
yes
i18n_string
"ecs.PRODUCT.files_download"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"cdb_media"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "eosmedia",
    "options": {
        "uploadDirDefault": "\/products",
        "xDataDialogConfig": {
            "layoutLabel": "mamasset_2_prd_filesdownload_popup"
        },
        "xDataKey": "a2r_xdata"
    },
    "mandatory": false,
    "editMode": 0
}
products_contain
Produkte im Bundle
DATA
R
yes
i18n_string
"ecs.PRODUCT.products_contain"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"bundle"
listCfg
{
    "formatter": {
        "type": "sub-data-chip",
        "params": {
            "chipCssClass": "chip"
        }
    },
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "eossubmodel",
    "options": {
        "model": "cdb_record",
        "xDataKey": "r2r_xdata",
        "xDataDialogConfig": {
            "layoutLabel": "submodel_products_contain_popup"
        },
        "dataStreamCall": {
            "method": "datahub_generate_reportList",
            "params": {
                "ds_label": "product"
            }
        },
        "optValueField": "xc__id",
        "optNameField": "name"
    },
    "mandatory": false,
    "editMode": 0
}
prd_keywords
Keywords
TEXT
R
yes
i18n_string
"ecs.PRODUCT.prd_keywords"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"cdb_advanced"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "mandatory": false,
    "editMode": 0
}
files_img
Bilder
DATA
R
yes
input_translated
Bilder mit Drag-and-Drop hinzufügen. Entweder aus Hublify Media-Manager oder von eigener Festplatte.
i18n_string
"ecs.PRODUCT.files_img"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"cdb_base_2"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "eosmedia",
    "options": {
        "uploadDirDefault": "\/products"
    },
    "mandatory": false,
    "editMode": 0
}
prd_bundle_price_discount_perc [%]
Bundle-Preis %-Discount
FLOAT
R
yes
i18n_string
"ecs.PRODUCT.prd_bundle_price_discount_perc"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"bundle"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "mandatory": false,
    "editMode": 0
}
desc_short
Kurz­beschreibung
TEXT
R
yes
i18n_string
"ecs.PRODUCT.desc_short"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"cdb_base_2"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "eoseditor",
    "options": {
        "useCfgPreset": "basic"
    },
    "mandatory": false,
    "editMode": 0
}
prd_snr_xdata_subtype
Zusatzdaten-Typ
TEXT
R
yes
i18n_string
"ecs.PRODUCT.prd_snr_xdata_subtype"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"cdb_base_2"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "eosdropdown",
    "options": {
        "serverSideSearch": false,
        "dataStreamCall": {
            "method": "prd_subtypes_getOptions"
        }
    },
    "mandatory": false,
    "editMode": 0
}
prd_bundle_resolve_mode
Bundle-Modus
TEXT
R
yes
i18n_string
"ecs.PRODUCT.prd_bundle_resolve_mode"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"bundle"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "eosdropdown",
    "options": {
        "optI18nValuePrefix": "ecs.prd_bundle_resolve_mode",
        "optI18nName": true,
        "data": {
            "options": [
                {
                    "value": null
                },
                {
                    "value": "resolve_never"
                },
                {
                    "value": "resolve_order"
                },
                {
                    "value": "resolve_add_childitems"
                }
            ]
        }
    },
    "mandatory": false,
    "editMode": 0
}
desc_tech
Technische Beschreibung
TEXT
R
yes
i18n_string
"ecs.PRODUCT.desc_tech"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"cdb_base_2"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "mandatory": false,
    "editMode": 0
}
manufacturer → manufacturer.xc__label
Hersteller
TEXT
R
yes
i18n_string
"ecs.PRODUCT.manufacturer"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"cdb_base"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "mandatory": false,
    "editMode": 0
}
xc__label
TEXT
R
yes
i18n_string
"ecs.PRODUCT.xc__label"
table
[ "excdb_data_ecs_product_de" ]
drvd_select
excdb_data_ecs_product_de.pcode
fieldset
"cdb_base"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "HIDDEN",
    "editMode": 0
}
xc__title
TEXT
R
yes
i18n_string
"ecs.PRODUCT.xc__title"
table
[ "excdb_data_ecs_product_de" ]
drvd_select
excdb_data_ecs_product_de.name
fieldset
"cdb_base"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "HIDDEN",
    "editMode": 0
}
xc__image
DATA
R
yes
i18n_string
"ecs.PRODUCT.xc__image"
table
[ "excdb_data_ecs_product_de" ]
drvd_select
excdb_data_ecs_product_de.files_img
fieldset
"cdb_base_2"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "HIDDEN",
    "editMode": 0
}
drvd_variant_specification
Ausprägung
TEXT
R
no
i18n_string
"ecs.PRODUCT.drvd_variant_specification"
table
[ "excdb_data_ecs_product_de" ]
drvd_select
CONCAT_WS(',',excdb_data_ecs_product_de.prdv_color, excdb_data_ecs_product_de.prdv_size, excdb_data_ecs_product_de.prdv_other)
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
currency
TEXT
R
no
i18n_string
"ecs.PRODUCT.currency"
table
[ "excdb_data_ecs_product_de" ]
drvd_select
"EUR"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}

invoice

Following fields can also be selected for reading (JOIN)

inv_id auto increment
INT (11)
R
no
i18n_string
"ecs.INVOICE.inv_id"
table
[ "ecs_invoice" ]
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "hidden",
    "editMode": 0
}
inv_code
Rechnungs-Nr.
TEXT (31)
R
yes
i18n_string
"ecs.INVOICE.inv_code"
table
[ "ecs_invoice" ]
fieldset
"base"
listCfg
{
    "formatter": {
        "type": "model-primary",
        "params": {
            "model": "invoice",
            "primaryKey": "inv_id",
            "statusColorField": "inv_status_color",
            "subTitleTemplate": "{%inv_firstname%} {%inv_lastname%}"
        }
    },
    "viewMode": 1,
    "fullSearch": false,
    "depends_on": "invi_fk_inv_id"
}
formCfg
{
    "cssLayout": "col-12 col-md-6 col-xl-3",
    "editMode": 0
}
fk_inv_persid → person.persid
Kunde
INT (11)
R
yes
i18n_string
"ecs.INVOICE.fk_inv_persid"
table
[ "ecs_invoice" ]
fieldset
"base"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "cssLayout": "col-12 col-md-6 col-xl-3",
    "editMode": 0
}
inv_time_invoice
Rechnungs­­datum
DATETIME
R
yes
i18n_string
"ecs.INVOICE.inv_time_invoice"
table
[ "ecs_invoice" ]
fieldset
"base"
listCfg
{
    "formatter": {
        "type": "date"
    },
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "datetimepicker",
    "cssLayout": "col-12 col-md-6 col-xl-3",
    "editMode": 0
}
inv_amount [EUR]
Rechnungs­­betrag
FLOAT (13,2)
R
no
i18n_string
"ecs.INVOICE.inv_amount"
table
[ "ecs_invoice" ]
fieldset
"payment"
listCfg
{
    "formatter": {
        "type": "currency"
    },
    "sumType": "SV",
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
inv_status
Rechnungsstatus
TEXT (7)
R
no
enum
[ "open", "done" ]
i18n_string
"ecs.INVOICE.inv_status"
valueColorField
"inv_status_color"
table
[ "ecs_invoice" ]
fieldset
"base"
listCfg
{
    "formatter": {
        "type": "status",
        "params": {
            "statusColorField": "inv_status_color"
        }
    },
    "viewMode": 0,
    "fullSearch": false
}
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"
    },
    "editMode": 0
}
inv_status_color
TEXT (15)
R
yes
i18n_string
"ecs.INVOICE.inv_status_color"
table
[ "ecs_invoice" ]
drvd_select
CASE ecs_invoice.inv_status WHEN "open" THEN "#CE0002" WHEN "done" THEN "#85B200" ELSE NULL END
listCfg
{
    "viewMode": 3,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
fk_inv_oid → order.oid
Auftrag
INT (11)
R
yes
input_translated
Diesem Auftrag wird die Rechnung zugeordnet.
Einem Auftrag können mehrere Rechnungen zugeordnet sein.
i18n_string
"ecs.INVOICE.fk_inv_oid"
table
[ "ecs_invoice" ]
fieldset
"inv_extra"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "cssLayout": "col-6",
    "editMode": 0
}
inv_user_insert
Ersteller
TEXT (127)
R
yes
i18n_string
"insert_user"
table
[ "ecs_invoice" ]
fieldset
"sys_record"
listCfg
{
    "formatter": {
        "type": "user"
    },
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
inv_time_insert
Angelegt am
DATETIME
R
no
i18n_string
"insert_time"
table
[ "ecs_invoice" ]
fieldset
"sys_record"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
inv_user_update
Letzte Änderung durch
TEXT (127)
R
yes
i18n_string
"update_user"
table
[ "ecs_invoice" ]
fieldset
"sys_record"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
inv_time_update
Geändert am
DATETIME
R
yes
i18n_string
"update_time"
table
[ "ecs_invoice" ]
fieldset
"sys_record"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
drvd_invoice_or_credit
TEXT
R
no
enum
[ "invoice", "credit_memo" ]
i18n_string
"ecs.INVOICE.drvd_invoice_or_credit"
table
[ "ecs_invoice" ]
drvd_select
IF(ecs_invoice.inv_amount < 0,"credit_memo","invoice")
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
inv_amount_paid [EUR]
Bezahlter Rechnungsbetrag
FLOAT (13,2)
R
no
i18n_string
"ecs.INVOICE.inv_amount_paid"
table
[ "ecs_invoice" ]
fieldset
"payment"
listCfg
{
    "formatter": {
        "type": "currency"
    },
    "viewMode": 0,
    "sumType": "SV",
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
inv_time_paid
Letzte Rechnungszahlung
DATETIME
R
yes
i18n_string
"ecs.INVOICE.inv_time_paid"
table
[ "ecs_invoice" ]
fieldset
"payment"
listCfg
{
    "viewMode": 0,
    "formatter": {
        "type": "date"
    },
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
inv_discount_percent
% Skonto (Altversion)
FLOAT (6,2)
R
yes
i18n_string
"ecs.INVOICE.inv_discount_percent"
table
[ "ecs_invoice" ]
fieldset
"payment"
listCfg
{
    "formatter": {
        "type": "decimal",
        "params": {
            "unit": " %",
            "format": "1.0-1"
        }
    },
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
inv_discount_time_until
Skonto bis (Altversion)
DATETIME
R
yes
i18n_string
"ecs.INVOICE.inv_discount_time_until"
table
[ "ecs_invoice" ]
fieldset
"payment"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
inv_txt_title
Rechnungstitel
TEXT
R
yes
i18n_string
"ecs.INVOICE.inv_txt_title"
table
[ "ecs_invoice" ]
fieldset
"doc_header"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "cssLayout": "col-12",
    "editMode": 0
}
inv_txt_header
Kopfbereich
TEXT
R
yes
i18n_string
"ecs.INVOICE.inv_txt_header"
table
[ "ecs_invoice" ]
fieldset
"doc_header"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "cssLayout": "col-12",
    "type": "eoseditor",
    "editMode": 0
}
inv_txt_footer
Fußbereich
TEXT
R
yes
inv_comment_internal
Interner Kommentar
TEXT
R
yes
i18n_string
"ecs.INVOICE.inv_comment_internal"
table
[ "ecs_invoice" ]
fieldset
"extra"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
inv_gender
Anrede
TEXT
R
yes
enum
[ "female", "male", "company", "divers" ]
i18n_string
"ecs.INVOICE.inv_gender"
table
[ "ecs_invoice" ]
fieldset
"inv_address"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
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"
                }
            ]
        }
    },
    "editMode": 0
}
inv_title
Titel
TEXT
R
yes
i18n_string
"ecs.INVOICE.inv_title"
table
[ "ecs_invoice" ]
fieldset
"inv_address"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "cssLayout": "col-6 col-xl-2",
    "editMode": 0
}
inv_firstname
Vorname
TEXT
R
yes
i18n_string
"ecs.INVOICE.inv_firstname"
table
[ "ecs_invoice" ]
fieldset
"inv_address"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "cssLayout": "col-6 col-xl-4",
    "editMode": 0
}
inv_lastname
Rg.Nachname
TEXT
R
yes
i18n_string
"ecs.INVOICE.inv_lastname"
table
[ "ecs_invoice" ]
fieldset
"inv_address"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "cssLayout": "col-6 col-xl-4",
    "editMode": 0
}
inv_company
Rg.Firma
TEXT
R
yes
i18n_string
"ecs.INVOICE.inv_company"
table
[ "ecs_invoice" ]
fieldset
"inv_address"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "cssLayout": "col-6",
    "editMode": 0
}
inv_addrextra
Adressenzusatz
TEXT
R
yes
i18n_string
"ecs.INVOICE.inv_addrextra"
table
[ "ecs_invoice" ]
fieldset
"inv_address"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "cssLayout": "col-6",
    "editMode": 0
}
inv_street
Straße
TEXT
R
yes
i18n_string
"ecs.INVOICE.inv_street"
table
[ "ecs_invoice" ]
fieldset
"inv_address"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "cssLayout": "col-9",
    "editMode": 0
}
inv_housenr
Hausnummer
TEXT
R
yes
i18n_string
"ecs.INVOICE.inv_housenr"
table
[ "ecs_invoice" ]
fieldset
"inv_address"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "cssLayout": "col-3",
    "editMode": 0
}
drvd_inv_street_housenr
Straße+Nr
TEXT
R
no
i18n_string
"ecs.INVOICE.drvd_inv_street_housenr"
table
[ "ecs_invoice" ]
drvd_select
CONCAT_WS("",ecs_invoice.inv_street," ",ecs_invoice.inv_housenr)
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
inv_zip
PLZ
TEXT
R
yes
i18n_string
"ecs.INVOICE.inv_zip"
table
[ "ecs_invoice" ]
fieldset
"inv_address"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "cssLayout": "col-4",
    "editMode": 0
}
inv_town
Ort
TEXT
R
yes
i18n_string
"ecs.INVOICE.inv_town"
table
[ "ecs_invoice" ]
fieldset
"inv_address"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "cssLayout": "col-8",
    "editMode": 0
}
inv_state_code
Bundesland (Code)
TEXT (15)
R
yes
i18n_string
"ecs.INVOICE.inv_state_code"
table
[ "ecs_invoice" ]
fieldset
"inv_address"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
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%}"
                                        }
                                    }
                                }
                            }
                        }
                    ]
                }
            ]
        }
    },
    "editMode": 0
}
inv_country → country.cy_iso
Land
TEXT
R
yes
i18n_string
"ecs.INVOICE.inv_country"
table
[ "ecs_invoice" ]
fieldset
"inv_address"
listCfg
{
    "viewMode": 0,
    "width": 64,
    "formatter": {
        "type": "country-flag"
    },
    "fullSearch": false
}
formCfg
{
    "cssLayout": "col-6",
    "editMode": 0
}
inv_time_account_export
Buchhaltung-Export
DATETIME
R
yes
i18n_string
"ecs.INVOICE.inv_time_account_export"
table
[ "ecs_invoice" ]
fieldset
"tax"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
inv_editable
änderbar
INT (11)
R
no
i18n_string
"ecs.INVOICE.inv_editable"
table
[ "ecs_invoice" ]
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
inv_type
Rechnungsart
TEXT
R
yes
enum
[ "noncommercial", "commercial" ]
i18n_string
"ecs.INVOICE.inv_type"
table
[ "ecs_invoice" ]
fieldset
"inv_extra"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "cssLayout": "col-6",
    "type": "eosdropdown",
    "options": {
        "data": {
            "options": [
                {
                    "value": "noncommercial",
                    "name": "Privat (B2C)"
                },
                {
                    "value": "commercial",
                    "name": "Gewerblich (B2B)"
                }
            ]
        }
    },
    "editMode": 0
}
inv_reason
Grund
TEXT (15)
R
yes
enum
[ "cancellation", "return", "complaint", "multiple_orders", "obligingness" ]
i18n_string
"ecs.INVOICE.inv_reason"
table
[ "ecs_invoice" ]
fieldset
"inv_extra"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
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"
                }
            ]
        }
    },
    "editMode": 0
}
inv_comment
Kommentar
TEXT
R
yes
i18n_string
"ecs.INVOICE.inv_comment"
table
[ "ecs_invoice" ]
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
inv_email
Rechnungs E-Mail
TEXT
R
yes
i18n_string
"ecs.INVOICE.inv_email"
table
[ "ecs_invoice" ]
fieldset
"inv_extra"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "cssLayout": "col-6",
    "editMode": 0
}
inv_taxidentnumber
Umsatzsteuer-ID
TEXT
R
yes
i18n_string
"ecs.INVOICE.inv_taxidentnumber"
table
[ "ecs_invoice" ]
fieldset
"tax"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "cssLayout": "col-6",
    "editMode": 0
}
inv_taxident_status
Umsatzsteuer-ID Status
TEXT
R
yes
enum
[ "invalid", "valid_conditional", "valid_confirmed" ]
i18n_string
"ecs.INVOICE.inv_taxident_status"
table
[ "ecs_invoice" ]
fieldset
"tax"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
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"
                }
            ]
        }
    },
    "editMode": 0
}
inv_third_country_export
Ausfuhrbescheinigung
TEXT
R
yes
enum
[ "none", "certificate_promised", "certificate_received" ]
i18n_string
"ecs.INVOICE.inv_third_country_export"
table
[ "ecs_invoice" ]
fieldset
"tax"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "eosdropdown",
    "options": {
        "data": {
            "options": [
                {
                    "value": "",
                    "name": ""
                },
                {
                    "value": "none",
                    "name": "keine vorhanden"
                },
                {
                    "value": "certificate_promised",
                    "name": "angek\u00fcndigt"
                },
                {
                    "value": "certificate_received",
                    "name": "erhalten"
                }
            ]
        }
    },
    "editMode": 0
}
inv_deliver_country
Lieferland
TEXT
R
yes
i18n_string
"ecs.INVOICE.inv_deliver_country"
table
[ "ecs_invoice" ]
fieldset
"tax"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "eosdropdown",
    "options": {
        "dataStreamCall": {
            "method": "country_getlist",
            "params": {
                "sql": {
                    "order": "cy_default DESC,cy_name ASC"
                }
            }
        },
        "optValueField": "cy_iso",
        "optNameField": "cy_name"
    },
    "editMode": 0
}
inv_tax_country → country.cy_iso
Umsatzsteuer-Land
TEXT
R
yes
i18n_string
"ecs.INVOICE.inv_tax_country"
table
[ "ecs_invoice" ]
fieldset
"tax"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
inv_currency → currency.cur_iso
Währung
TEXT (3)
R
yes
i18n_string
"ecs.INVOICE.inv_currency"
table
[ "ecs_invoice" ]
fieldset
"tax"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
inv_pys_method → paymentservice.pys_method
Zahlungsart
TEXT (31)
R
yes
input_translated
Wählen Sie die Zahlungsart aus, über die diese Rechnung beglichen werden soll.
i18n_string
"ecs.INVOICE.inv_pys_method"
table
[ "ecs_invoice" ]
fieldset
"payment"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
fk_inv_accid → account.accid
Konto
INT (11)
R
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.
i18n_string
"ecs.INVOICE.fk_inv_accid"
table
[ "ecs_invoice" ]
fieldset
"payment"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
inv_pay_profile_xdata
Zahlungsziel-Daten
DATA
R
yes
i18n_string
"ecs.INVOICE.inv_pay_profile_xdata"
table
[ "ecs_invoice" ]
fieldset
"payment"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
drvd_amount_not_paid [EUR]
Ausstehender Rechnungsbetrag
FLOAT (13,2)
R
no
i18n_string
"ecs.INVOICE.drvd_amount_not_paid"
table
[ "ecs_invoice" ]
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",
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
drvd_amount_open_days [d]
Offen seit ... Tagen
INT
R
no
i18n_string
"ecs.INVOICE.drvd_amount_open_days"
table
[ "ecs_invoice" ]
drvd_select
IF(ecs_invoice.inv_status='open',DATEDIFF(CURDATE(),ecs_invoice.inv_time_invoice),NULL)
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
drvd_days_until_paid [d]
Bezahlt nach ... Tagen
INT
R
no
i18n_string
"ecs.INVOICE.drvd_days_until_paid"
table
[ "ecs_invoice" ]
drvd_select
IF(ecs_invoice.inv_status='done',DATEDIFF(ecs_invoice.inv_time_paid,ecs_invoice.inv_time_invoice),NULL)
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
drvd_inv_name
Name (kombiniert)
TEXT
R
no
i18n_string
"ecs.INVOICE.drvd_inv_name"
table
[ "ecs_invoice" ]
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)
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
inv_reminder_level
INT (11)
R
yes
i18n_string
"ecs.INVOICE.inv_reminder_level"
table
[ "ecs_invoice" ]
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
inv_reminder_data
Mahndaten
TEXT
R
yes
i18n_string
"ecs.INVOICE.inv_reminder_data"
table
[ "ecs_invoice" ]
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
inv_reminder_profile_label
Mahnprofil
TEXT (127)
R
yes
i18n_string
"ecs.INVOICE.inv_reminder_profile_label"
table
[ "ecs_invoice" ]
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
inv_reminder_time_last_sent
Letzte Mahnung gesendet
DATETIME
R
yes
i18n_string
"ecs.INVOICE.inv_reminder_time_last_sent"
table
[ "ecs_invoice" ]
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
inv_reminder_time_last_change
Letzte Mahnstufe-Änderung
DATETIME
R
yes
i18n_string
"ecs.INVOICE.inv_reminder_time_last_change"
table
[ "ecs_invoice" ]
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
inv_reminder_prop_level
Mahnstufe (vorgeschlagen)
INT (11)
R
yes
i18n_string
"ecs.INVOICE.inv_reminder_prop_level"
table
[ "ecs_invoice" ]
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
inv_reminder_prop_xdata
Mahnstufen-Daten (vorgeschlagen)
TEXT
R
yes
i18n_string
"ecs.INVOICE.inv_reminder_prop_xdata"
table
[ "ecs_invoice" ]
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
inv_reminder_prop_time
Mahnstufen-Vorschlag (Berechnung)
DATETIME
R
yes
i18n_string
"ecs.INVOICE.inv_reminder_prop_time"
table
[ "ecs_invoice" ]
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
inv_reminder_suspend_time
Mahnstopp Zeitpunkt
DATETIME
R
yes
i18n_string
"ecs.INVOICE.inv_reminder_suspend_time"
table
[ "ecs_invoice" ]
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
inv_extcollect_time
Inkasso-Übergabe
DATETIME
R
yes
i18n_string
"ecs.INVOICE.inv_extcollect_time"
table
[ "ecs_invoice" ]
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
inv_extcollect_code
Inkasso Code
TEXT (127)
R
yes
i18n_string
"ecs.INVOICE.inv_extcollect_code"
table
[ "ecs_invoice" ]
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
inv_extcollect_xdata
Inkasso-Daten
TEXT
R
yes
i18n_string
"ecs.INVOICE.inv_extcollect_xdata"
table
[ "ecs_invoice" ]
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
cy_name
Name
TEXT (63)
R
no
input_translated
Vollständiger Landesname
i18n_string
"ecs.COUNTRY.cy_name"
table
[ "ecs_country" ]
drvd_select
ecs_country.cy_name
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
cy_nameshort
Kurzname
TEXT (15)
R
no
input_translated
Kurzname für Adressangaben
i18n_string
"ecs.COUNTRY.cy_nameshort"
table
[ "ecs_country" ]
drvd_select
ecs_country.cy_nameshort
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
drvd_inv_state_name
Bundesland
TEXT
R
no
i18n_string
"ecs.INVOICE.drvd_inv_state_name"
table
[ "inv_terr_state" ]
drvd_select
inv_terr_state.terr_name
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
drvd_inv_state_path
Bundesland (Pfad)
TEXT
R
no
i18n_string
"ecs.INVOICE.drvd_inv_state_path"
table
[ "inv_terr_state" ]
drvd_select
inv_terr_state.i18n_node_path_DE
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
inv_email_time_send
Letzter Rechnungsversand
DATETIME
R
no
i18n_string
"ecs.INVOICE.inv_email_time_send"
table
[ "ecs_invoice" ]
listCfg
{
    "viewMode": 0
}
formCfg
{
    "editMode": 2
}

person

Following fields can also be selected for reading (JOIN)

persid auto increment
PersID
INT (11)
R
no
i18n_string
"ecs.PERSON.persid"
table
[ "eos_person" ]
fieldset
"base_record"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "hidden",
    "editMode": 0
}
personid
Kunden-Nr.
TEXT (32)
R
no
i18n_string
"ecs.PERSON.personid"
table
[ "eos_person" ]
fieldset
"base_record"
listCfg
{
    "width": 160,
    "formatter": {
        "type": "model-primary",
        "params": {
            "model": "person",
            "primaryKey": "persid",
            "iconLabel": "hublify\/sign-questionmark",
            "iconMapField": "gender",
            "iconMap": [
                {
                    "value": "female",
                    "iconLabel": "ecs\/gender_female"
                },
                {
                    "value": "male",
                    "iconLabel": "ecs\/gender_male"
                },
                {
                    "value": "company",
                    "iconLabel": "ecs\/gender_company"
                },
                {
                    "value": "divers",
                    "iconLabel": "ecs\/gender_divers"
                }
            ],
            "iconColorField": "gender_color"
        }
    },
    "viewMode": 1,
    "fullSearch": false,
    "depends_on": "invi_fk_persid"
}
formCfg
{
    "cssLayout": "col-6",
    "editMode": 0
}
fk_p_grpid → persongroup.grpid
Kundengruppe
INT (11)
R
no
i18n_string
"ecs.PERSON.fk_p_grpid"
table
[ "eos_person" ]
fieldset
"base_record"
listCfg
{
    "viewMode": 3,
    "fullSearch": false
}
formCfg
{
    "cssLayout": "col-6",
    "editMode": 0
}
fk_p_shopid → shopconfig.eshopid
Shop
INT (11)
R
yes
i18n_string
"ecs.PERSON.fk_p_shopid"
table
[ "eos_person" ]
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
gender
Anrede
TEXT
R
yes
enum
[ "female", "male", "company", "divers" ]
i18n_string
"ecs.PERSON.gender"
valueColorField
"gender_color"
table
[ "eos_person" ]
fieldset
"base"
listCfg
{
    "width": 96,
    "viewMode": 0,
    "fullSearch": false
}
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,
    "fullSearch": false
}
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,
    "fullSearch": false
}
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": false
}
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,
    "fullSearch": false
}
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,
    "fullSearch": false
}
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,
    "fullSearch": false
}
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,
    "fullSearch": false
}
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,
    "fullSearch": false
}
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,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
company
Firma
TEXT
R
no
i18n_string
"ecs.PERSON.company"
table
[ "eos_person" ]
fieldset
"addr"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
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,
    "fullSearch": false
}
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,
    "fullSearch": false
}
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,
    "fullSearch": false
}
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,
    "fullSearch": false
}
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,
    "fullSearch": false
}
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,
    "fullSearch": false
}
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,
    "fullSearch": false
}
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,
    "fullSearch": false
}
formCfg
{
    "cssLayout": "col-6",
    "type": "eosdropdown",
    "options": {
        "serverSideSearch": false,
        "optValueField": "terr_code",
        "optNameField": "terr_name",
        "optExtraField": "terr_code",
        "observer": {
            "fields": [
                {
                    "field": "country",
                    "trigger": "onInit",
                    "exec": [
                        {
                            "cmd": "loadOptions",
                            "params": {
                                "dataStreamCall": {
                                    "method": "state_getlist",
                                    "params": {
                                        "filter": {
                                            "state_country": "{%FIELD.value%}"
                                        }
                                    }
                                }
                            }
                        }
                    ]
                },
                {
                    "field": "country",
                    "trigger": "onChange",
                    "exec": [
                        {
                            "cmd": "loadOptions",
                            "params": {
                                "dataStreamCall": {
                                    "method": "state_getlist",
                                    "params": {
                                        "filter": {
                                            "state_country": "{%FIELD.value%}"
                                        }
                                    }
                                }
                            }
                        }
                    ]
                }
            ]
        }
    },
    "editMode": 0
}
country → country.cy_iso
Land
TEXT (2)
R
no
i18n_string
"ecs.PERSON.country"
table
[ "eos_person" ]
fieldset
"addr"
listCfg
{
    "viewMode": 0,
    "width": 64,
    "formatter": {
        "type": "country-flag"
    },
    "fullSearch": false
}
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,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
drvd_p_address
Adresse
TEXT
R
yes