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"
}
fieldset
"base_record"
listCfg
{
"viewMode": 3
}
formCfg
{
"cssLayout": "col-6"
}
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
Verpackungsmenge
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
Verpackungseinheit
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
Verpackungsinhalt (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
Verpackungsinhalt (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
Nachfolgeprodukte
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
}
orderitem_name
Auftragsposten-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
Auftragsposten-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_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
}
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]
Verpackungsgröß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]
Verpackungsgröß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]
Verpackungsgröß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]
Verpackungsgewicht
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
Kurzbeschreibung
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
}
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
}
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
Rechnungsdatum
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]
Rechnungsbetrag
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
}
input_translated
Diesem Auftrag wird die Rechnung zugeordnet.
Einem Auftrag können mehrere Rechnungen zugeordnet sein.
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_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
}
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
}
i18n_string
"ecs.INVOICE.inv_tax_country"
table
[
"ecs_invoice"
]
fieldset
"tax"
listCfg
{
"viewMode": 0,
"fullSearch": false
}
formCfg
{
"editMode": 0
}
i18n_string
"ecs.INVOICE.inv_currency"
table
[
"ecs_invoice"
]
fieldset
"tax"
listCfg
{
"viewMode": 0,
"fullSearch": false
}
formCfg
{
"editMode": 0
}
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
}
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.
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
}
i18n_string
"ecs.PERSON.fk_p_grpid"
table
[
"eos_person"
]
fieldset
"base_record"
listCfg
{
"viewMode": 3,
"fullSearch": false
}
formCfg
{
"cssLayout": "col-6",
"editMode": 0
}
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.
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
}
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