invoiceitem - "Rechnungsposten" 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_selectROUND((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_selectROUND((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_selectROUND((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_selectROUND((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_selectROUND((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_selectROUND((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_selectROUND((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_selectROUND((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_selectROUND((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_selectfk_o_shopidlistCfg{
"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_selectinvi_pcodelistCfg{
"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_selectCOALESCE(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_selectIF(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_translatedBei 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_translatedProdukte 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_translatedProdukte 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_translatedBilder 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_selectexcdb_data_ecs_product_de.pcodefieldset"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_selectexcdb_data_ecs_product_de.namefieldset"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_selectexcdb_data_ecs_product_de.files_imgfieldset"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_selectCONCAT_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_selectCASE ecs_invoice.inv_status WHEN "open" THEN "#CE0002" WHEN "done" THEN "#85B200" ELSE NULL ENDlistCfg{
"viewMode": 3,
"fullSearch": false
}formCfg{
"editMode": 0
}input_translatedDiesem 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_selectIF(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_selectCONCAT_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_translatedWä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_translatedWählen Sie hier das Konto des Kunden aus, von dem der Rechnungsbetrag eingezogen werden soll.
Bitte beachten Sie:
Die Auswahl ist nur sinnvoll, wenn es sich bei der Zahlungsart z.B. um eine Lastschrift handelt, die direkt von Ihnen selbst veranlasst wird. In den meisten anderen Fällen (Drittanbieter-Bezahlung, Vorkasse) können Sie dieses Feld leer lassen.
Bitte beachten Sie:
Die Auswahl ist nur sinnvoll, wenn es sich bei der Zahlungsart z.B. um eine Lastschrift handelt, die direkt von Ihnen selbst veranlasst wird. In den meisten anderen Fällen (Drittanbieter-Bezahlung, Vorkasse) können Sie dieses Feld leer lassen.
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_selectIF(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_selectIF(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_selectIF(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_selectCONCAT_WS("",ecs_invoice.inv_company,IF(ecs_invoice.inv_company IS NOT NULL AND (ecs_invoice.inv_firstname IS NOT NULL OR ecs_invoice.inv_lastname IS NOT NULL),", ",""),ecs_invoice.inv_firstname,IF(ecs_invoice.inv_firstname IS NOT NULL," ",""),ecs_invoice.inv_lastname)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_translatedVollständiger Landesname
i18n_string"ecs.COUNTRY.cy_name"table[
"ecs_country"
]drvd_selectecs_country.cy_namelistCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}cy_nameshort
Kurzname
TEXT (15)
R
no
input_translatedKurzname für Adressangaben
i18n_string"ecs.COUNTRY.cy_nameshort"table[
"ecs_country"
]drvd_selectecs_country.cy_nameshortlistCfg{
"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_selectinv_terr_state.terr_namelistCfg{
"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_selectinv_terr_state.i18n_node_path_DElistCfg{
"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_selectCASE eos_person.gender WHEN "female" THEN "#BF117F" WHEN "male" THEN "#1f96cb" WHEN "divers" THEN "#7D47B9" WHEN "company" THEN "#41cbd9" WHEN "unknown" THEN "#AAAAAA" ELSE NULL ENDlistCfg{
"viewMode": 3,
"fullSearch": false
}formCfg{
"editMode": 0
}title
Titel
TEXT
R
no
input_translatedGeben Sie hier einen Titel des Kunden an (z.B. Dr.).
i18n_string"ecs.PERSON.title"table[
"eos_person"
]fieldset"base"listCfg{
"width": 96,
"viewMode": 0,
"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_translatedVorname 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_translatedTragen Sie hier das Geburtsdatum des Kunden ein.
Vorzugsweise im Format: tt.mm.JJJJ.
Vorzugsweise im Format: tt.mm.JJJJ.
i18n_string"ecs.PERSON.bday"table[
"eos_person"
]fieldset"base"listCfg{
"viewMode": 0,
"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_selectDATE_FORMAT(NOW(), '%Y') - DATE_FORMAT(eos_person.bday, '%Y') - (DATE_FORMAT(NOW(), '00-%m-%d') < DATE_FORMAT(eos_person.bday, '00-%m-%d'))fieldset"analytics"listCfg{
"viewMode": 0,
"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_selectIF(DAYOFYEAR(eos_person.bday)>DAYOFYEAR(CURDATE()) , DATEDIFF(CONCAT(YEAR(CURDATE()),'-',MONTH(eos_person.bday),'-',DAY(eos_person.bday) ) , CURDATE() ), DATEDIFF(CONCAT(YEAR(CURDATE())+1,'-',MONTH(eos_person.bday),'-',DAY(eos_person.bday) ) , CURDATE()))fieldset"analytics"listCfg{
"viewMode": 0,
"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_selectIF(DAYOFYEAR(eos_person.bday)>DAYOFYEAR(CURDATE()) , CONCAT(YEAR(CURDATE()),'-',LPAD(MONTH(eos_person.bday),2,'0'),'-',LPAD(DAY(eos_person.bday),2,'0') ), CONCAT(YEAR(CURDATE())+1,'-',LPAD(MONTH(eos_person.bday),2,'0'),'-',LPAD(DAY(eos_person.bday),2,'0')))fieldset"analytics"listCfg{
"viewMode": 0,
"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_selectCONCAT_WS("",eos_person.company,IF((eos_person.company IS NOT NULL AND eos_person.company != "") AND ((eos_person.firstname IS NOT NULL AND eos_person.firstname != "") OR (eos_person.lastname IS NOT NULL AND eos_person.lastname != "")),", ",""),eos_person.firstname,IF(eos_person.firstname IS NOT NULL," ",""),eos_person.lastname)listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}drvd_p_address
Adresse
TEXT
R
yes
i18n_string"ecs.PERSON.drvd_p_address"table[
"eos_person"
]drvd_selectCONCAT(
IF(CHAR_LENGTH(eos_person.company)>0,CONCAT(eos_person.company,CHAR(13)),""),
TRIM(CONCAT(eos_person.title," ",eos_person.firstname," ",eos_person.lastname)),CHAR(13),
IF(CHAR_LENGTH(eos_person.address2)>0,CONCAT(eos_person.address2,CHAR(13)),""),
eos_person.street," ",eos_person.housenr,CHAR(13),
eos_person.country," - ",eos_person.zip," ",eos_person.town)listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}email
E-Mail
TEXT (127)
R
no
i18n_string"ecs.PERSON.email"table[
"eos_person"
]fieldset"communication"listCfg{
"width": 256,
"viewMode": 0,
"fullSearch": false
}formCfg{
"type": "hfyemail",
"cssLayout": "col-6",
"editMode": 0
}telephone
Telefon
TEXT
R
no
i18n_string"ecs.PERSON.telephone"table[
"eos_person"
]fieldset"communication"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"type": "hfyphone",
"cssLayout": "col-6",
"editMode": 0
}telephone_mobile
Tel. mobil
TEXT
R
no
i18n_string"ecs.PERSON.telephone_mobile"table[
"eos_person"
]fieldset"communication"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"type": "hfyphone",
"cssLayout": "col-6",
"editMode": 0
}telefax
Fax
TEXT
R
no
i18n_string"ecs.PERSON.telefax"table[
"eos_person"
]fieldset"communication"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"type": "hfyphone",
"cssLayout": "col-6",
"editMode": 0
}p_invoice_type
Rechnungsart
TEXT
R
yes
i18n_string"ecs.PERSON.p_invoice_type"table[
"eos_person"
]fieldset"commercial"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"type": "eosdropdown",
"options": {
"optI18nValuePrefix": "ecs.invoice_type",
"optI18nName": true,
"data": {
"options": [
{
"value": "noncommercial"
},
{
"value": "commercial"
}
]
}
},
"editMode": 0
}p_invoice_email
E-Mail (Rechnung)
TEXT
R
no
i18n_string"ecs.PERSON.p_invoice_email"table[
"eos_person"
]fieldset"commercial"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"type": "hfyemail",
"editMode": 0
}taxident
Umsatzsteuer-ID
TEXT
R
no
i18n_string"ecs.PERSON.taxident"table[
"eos_person"
]fieldset"commercial"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}taxident_status
Umsatzsteuer-ID-Status
TEXT
R
yes
input_translatedStatus der Umsatzsteuer-ID des Kundenkontos. Nur Kundenkonten mit bestätigter Umsatzsteuer-ID werden für Netto-Aufträge bei Lieferung in andere EU Länder berücksichtigt.
enum[
"invalid",
"valid_conditional",
"valid_confirmed"
]i18n_string"ecs.PERSON.taxident_status"table[
"eos_person"
]fieldset"commercial"listCfg{
"viewMode": 0,
"formatter": {
"type": "status"
},
"fullSearch": false
}formCfg{
"type": "eosdropdown",
"options": {
"optI18nValuePrefix": "ecs.taxident_status",
"optI18nName": true,
"data": {
"options": [
{
"value": null
},
{
"value": "invalid"
},
{
"value": "valid_conditional"
},
{
"value": "valid_confirmed"
}
]
}
},
"editMode": 0
}score
Bonitätswert
INT (7)
R
no
i18n_string"ecs.PERSON.score"table[
"eos_person"
]fieldset"credit_rating"listCfg{
"viewMode": 0,
"sumType": "AVG",
"fullSearch": false
}formCfg{
"editMode": 0
}score_time_set
Letzter Rating-Check
DATETIME
R
yes
i18n_string"ecs.PERSON.score_time_set"table[
"eos_person"
]fieldset"credit_rating"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}score_time_invalid
Abgelaufen am
DATETIME
R
yes
i18n_string"ecs.PERSON.score_time_invalid"table[
"eos_person"
]fieldset"credit_rating"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}svc_code
Rating ServiceCode
TEXT
R
yes
i18n_string"ecs.PERSON.svc_code"table[
"eos_person"
]fieldset"credit_rating"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}svc_txt
Rating ServiceText
TEXT
R
yes
i18n_string"ecs.PERSON.svc_txt"table[
"eos_person"
]fieldset"credit_rating"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}p_login_username
Benutzername
TEXT (63)
R
yes
i18n_string"ecs.PERSON.p_login_username"table[
"eos_person"
]fieldset"login"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}p_login_pwd_encrypted
Passwort (verschlüsselt)
TEXT
R
yes
i18n_string"ecs.PERSON.p_login_pwd_encrypted"table[
"eos_person"
]fieldset"login"listCfg{
"viewMode": 3,
"fullSearch": false
}formCfg{
"editMode": 0
}p_login_pwd_key
Direct-Login-Token
TEXT
R
yes
i18n_string"ecs.PERSON.p_login_pwd_key"table[
"eos_person"
]fieldset"login"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}p_login_time_last
Letzter Login
DATETIME
R
yes
i18n_string"ecs.PERSON.p_login_time_last"table[
"eos_person"
]fieldset"login"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}p_login_pwd_must_renew_after
Passwort-Änderung auffordern ab
DATETIME
R
yes
i18n_string"ecs.PERSON.p_login_pwd_must_renew_after"table[
"eos_person"
]fieldset"login"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"type": "datetimepicker",
"editMode": 0
}p_login_pwd_key_timeout
Direct-Login-Token Timeout
DATETIME
R
yes
i18n_string"ecs.PERSON.p_login_pwd_key_timeout"table[
"eos_person"
]fieldset"login"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}p_login_pwd_last_renewed
Passwort zuletzt geändert
DATETIME
R
yes
i18n_string"ecs.PERSON.p_login_pwd_last_renewed"table[
"eos_person"
]fieldset"login"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}p_login_active
Aktiv
INT (1)
R
no
i18n_string"ecs.PERSON.p_login_active"table[
"eos_person"
]fieldset"login"listCfg{
"formatter": {
"type": "active-flag"
},
"width": 64,
"viewMode": 0,
"fullSearch": false
}formCfg{
"type": "checkbox",
"editMode": 0
}p_email_verify_token
TEXT (32)
R
yes
i18n_string"ecs.PERSON.p_email_verify_token"table[
"eos_person"
]fieldset"login"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}p_email_verify_token_timeout
DATETIME
R
yes
i18n_string"ecs.PERSON.p_email_verify_token_timeout"table[
"eos_person"
]fieldset"login"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}p_email_verified_time
DATETIME
R
yes
i18n_string"ecs.PERSON.p_email_verified_time"table[
"eos_person"
]fieldset"login"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}p_login_mode
Login-Modus
TEXT (15)
R
yes
enum[
"simple",
"2fa_email"
]i18n_string"ecs.PERSON.p_login_mode"table[
"eos_person"
]fieldset"login"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"cssLayout": "col-3",
"type": "eosdropdown",
"options": {
"optI18nValuePrefix": "ecs.p_login_mode",
"optI18nName": true,
"optI18nSubTitle": true,
"data": {
"options": [
{
"value": "simple"
},
{
"value": "2fa_email"
}
]
}
},
"editMode": 0
}p_login_2fa_code
2FA - Login Code
TEXT
R
yes
i18n_string"ecs.PERSON.p_login_2fa_code"table[
"eos_person"
]fieldset"login"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}p_login_2fa_timeout
2FA - Login Code Timeout
DATETIME
R
yes
i18n_string"ecs.PERSON.p_login_2fa_timeout"table[
"eos_person"
]fieldset"login"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}p_login_err_count
Anzahl Fehllogins
INT (4)
R
no
i18n_string"ecs.PERSON.p_login_err_count"table[
"eos_person"
]fieldset"login"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}p_login_time_min
Login Sperrzeit
DATETIME
R
yes
i18n_string"ecs.PERSON.p_login_time_min"table[
"eos_person"
]fieldset"login"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}p_register_state
Registrierungsstatus
TEXT (15)
R
yes
i18n_string"ecs.PERSON.p_register_state"table[
"eos_person"
]fieldset"login"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}p_register_code
Registrierungscode
TEXT (32)
R
yes
i18n_string"ecs.PERSON.p_register_code"table[
"eos_person"
]fieldset"login"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}p_register_code_timeout
Registrierungscode Timeout
DATETIME
R
yes
i18n_string"ecs.PERSON.p_register_code_timeout"table[
"eos_person"
]fieldset"login"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}p_onetime_pwd
Einmal-Passwort
TEXT
R
yes
i18n_string"ecs.PERSON.p_onetime_pwd"table[
"eos_person"
]fieldset"login"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}p_onetime_pwd_timeout
Einmal-Passwort Timeout
DATETIME
R
yes
i18n_string"ecs.PERSON.p_onetime_pwd_timeout"table[
"eos_person"
]fieldset"login"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}p_login_state
Login Status
TEXT (15)
R
no
enum[
"possible",
"disabled",
"suspended",
"retry"
]i18n_string"ecs.PERSON.p_login_state"table[
"eos_person"
]drvd_selectIF(eos_person.p_login_active!=1, "disabled", IF(eos_person.p_login_err_count>0 ,IF(eos_person.p_login_time_min>NOW() ,"suspended","retry"),"possible"))listCfg{
"viewMode": 0,
"formatter": {
"type": "status",
"params": {
"statusColorField": "p_login_state_color"
}
},
"fullSearch": false
}formCfg{
"editMode": 0
}p_login_state_color
TEXT (15)
R
yes
i18n_string"ecs.PERSON.p_login_state_color"table[
"eos_person"
]drvd_selectIF(eos_person.p_login_active!=1, "#CCCCCC", IF(eos_person.p_login_err_count>0 ,IF(eos_person.p_login_time_min>NOW() ,"#CE0002","#EEAB00"),"#85B200"))listCfg{
"viewMode": 0,
"formatter": {
"type": "color-code"
},
"fullSearch": false
}formCfg{
"editMode": 0
}i18n_string"ecs.PERSON.p_oo_set_label"table[
"eos_person"
]fieldset"order_options"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}i18n_string"ecs.PERSON.fk_p_pay_profile_id"table[
"eos_person"
]fieldset"order_options"listCfg{
"viewMode": 3,
"fullSearch": false
}formCfg{
"editMode": 0
}input_translatedEine hier eingetragene Preisgruppe hat Vorrang vor den Preisgruppen-Einstellungen der Kundengruppe und auch den direkt im Produkt gesetzten Staffelpreisen.
i18n_string"ecs.PERSON.fk_p_prcgrp_id"table[
"eos_person"
]fieldset"order_options"listCfg{
"viewMode": 3,
"fullSearch": false
}formCfg{
"editMode": 0
}p_price_factor
Preis-Faktor
FLOAT (10,4)
R
yes
input_translatedDer angegebene Faktor wird bei allen für den Kunden angezeigten Standard-Preisen als Multiplikator verwendet.
Ein eventuell für die zugehörige Kundengruppe angegebener Preis-Faktor wird durch einen speziell für den Kunden gesetzten Preisfaktor (!= 1) ersetzt.
i18n_string"ecs.PERSON.p_price_factor"table[
"eos_person"
]fieldset"order_options"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}p_person_prices
Persönliche Preise
INT (1)
R
no
i18n_string"ecs.PERSON.p_person_prices"table[
"eos_person"
]fieldset"order_options"listCfg{
"formatter": {
"type": "active-flag"
},
"width": 64,
"viewMode": 0,
"fullSearch": false
}formCfg{
"type": "checkbox",
"editMode": 0
}i18n_string"ecs.PERSON.fk_p_campid"table[
"eos_person"
]fieldset"marketing"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}p_allow_email_marketing
Zustimmung zu Marketing-Mails
INT (1)
R
no
i18n_string"ecs.PERSON.p_allow_email_marketing"table[
"eos_person"
]fieldset"marketing"listCfg{
"formatter": {
"type": "active-flag"
},
"width": 64,
"viewMode": 0,
"fullSearch": false
}formCfg{
"type": "checkbox",
"editMode": 0
}drvd_emailmarketing_unsubscribetoken
Token für Direktabmeldung Marketingmails
TEXT
R
no
i18n_string"ecs.PERSON.drvd_emailmarketing_unsubscribetoken"table[
"eos_person"
]drvd_selectmd5(CONCAT(eos_person.persid,'disallow',eos_person.personid,'emailmarketing',eos_person.time_insert))fieldset"marketing"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}p_ip_address
IP-Adresse
TEXT (15)
R
no
i18n_string"ecs.PERSON.p_ip_address"table[
"eos_person"
]fieldset"registration"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}p_referrer
Referrer
TEXT
R
yes
i18n_string"ecs.PERSON.p_referrer"table[
"eos_person"
]fieldset"registration"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}p_useragent
User Agent
TEXT
R
yes
i18n_string"ecs.PERSON.p_useragent"table[
"eos_person"
]fieldset"registration"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}p_personid_external
Externe Kunden-Nr.
TEXT (127)
R
yes
input_translatedEine externe Kunden-Nr. aus einem anderen System.
i18n_string"ecs.PERSON.p_personid_external"table[
"eos_person"
]fieldset"external"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}p_comment_internal
Interner Kommentar
TEXT
R
yes
i18n_string"ecs.PERSON.p_comment_internal"table[
"eos_person"
]fieldset"extra"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}p_locale
Locale Kunde
DATA
R
yes
i18n_string"ecs.PERSON.p_locale"table[
"eos_person"
]fieldset"extra"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}p_volfile
DATA
R
yes
i18n_string"ecs.PERSON.p_volfile"table[
"eos_person"
]drvd_selectNULLfieldset"documents"listCfg{
"viewMode": 3,
"fullSearch": false
}formCfg{
"type": "hfyvolumefile",
"options": {
"vol_label": "person_documents",
"vol_primKeyVar": "persid",
"vol_primKey": null
},
"editMode": 0
}time_insert
Angelegt am
DATETIME
R
no
i18n_string"insert_time"table[
"eos_person"
]fieldset"sys_record"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}user_insert
Ersteller
TEXT (127)
R
yes
i18n_string"insert_user"table[
"eos_person"
]fieldset"sys_record"listCfg{
"formatter": {
"type": "user"
},
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}time_update
Geändert am
DATETIME
R
yes
i18n_string"update_time"table[
"eos_person"
]fieldset"sys_record"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}user_update
Letzte Änderung durch
TEXT (127)
R
yes
i18n_string"update_user"table[
"eos_person"
]fieldset"sys_record"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}drvd_timeonly_timeinsert
Angelegt (Uhrzeit)
TEXT
R
no
i18n_string"ecs.PERSON.drvd_timeonly_timeinsert"table[
"eos_person"
]drvd_selectDATE_FORMAT(eos_person.time_insert, '%H:%i')fieldset"analytics"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}p_anonymize_time
Anoymisiert am
DATETIME
R
yes
i18n_string"ecs.PERSON.p_anonymize_time"table[
"eos_person"
]fieldset"sys_record"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}input_translatedVerknüpfen Sie das Kundenkonto mit einem Firmenaccount. Das Kundenkonto wird damit zu einem Unteraccount des Firmenaccounts.
i18n_string"ecs.plugin_companyaccount.fk_p_companyaccount_parent_persid"table[
"eos_person"
]fieldset"extra"listCfg{
"viewMode": 3,
"fullSearch": false
}formCfg{
"editMode": 0
}p_companyaccount_budget_cart_max
[EUR]
Budget Warenkorb
FLOAT (10,2)
R
yes
input_translatedLegen Sie hier den maximalen Netto-Warenkorb-Wert fest, der durch den Benutzer bestellt werden darf.
i18n_string"ecs.plugin_companyaccount.p_companyaccount_budget_cart_max"table[
"eos_person"
]fieldset"extra"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"type": "eosnumber",
"options": {
"decimalsCalculate": 2,
"decimalshowMin": 2,
"decimalshowMax": 2
},
"editMode": 0
}p_companyaccount_cost_center_customer
Kunden Kostenstelle
TEXT
R
yes
input_translatedStandard Kostenstelle des Kunden.
i18n_string"ecs.plugin_companyaccount.p_companyaccount_cost_center_customer"table[
"eos_person"
]fieldset"extra"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}p_companyaccount_type
TEXT
R
yes
i18n_string"ecs.plugin_companyaccount.p_companyaccount_type"table[
"eos_person"
]fieldset"extra"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"type": "eosdropdown",
"options": {
"optI18nValuePrefix": "ecs.plugin_companyaccount.p_companyaccount_type",
"optI18nName": true,
"data": {
"options": [
{
"value": "company"
},
{
"value": "subaccount"
}
]
}
},
"editMode": 0
}p_companyaccount_xdata
DATA
R
yes
i18n_string"ecs.plugin_companyaccount.p_companyaccount_xdata"table[
"eos_person"
]fieldset"extra"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"cssLayout": "col-12",
"type": "aceeditor",
"options": {
"mode": "json"
},
"editMode": 0
}p_accounting_debtor_account
Buchhaltung Debitorenkonto
TEXT
R
yes
input_translatedTragen Sie hier das Debitorenkonto für diesen Kunden ein, welches im Buchungsstapel-Export verwendet werden soll.
i18n_string"ecs.ecs_plugin_interface_accounting.p_accounting_debtor_account"table[
"eos_person"
]fieldset"accounting"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}fk_pers_inv_reminder_profile
Mahnprofil
TEXT (127)
R
yes
i18n_string"ecs.PERSON.fk_pers_inv_reminder_profile"table[
"eos_person"
]listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}p_merchant_xdata
Anbieter (Zusatzdaten)
DATA
R
yes
input_translatedGeben Sie hier spezifische Informationen an, die für Anbieter relevant sein können (z.B. Kundennummer zu einem Anbieter).
i18n_string"ecs.PERSON.p_merchant_xdata"table[
"eos_person"
]fieldset"extra"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"cssLayout": "col-12",
"type": "aceeditor",
"options": {
"mode": "json"
},
"editMode": 0
}p_shopuserright_profiles
Benutzer-Rollen
TEXT
R
yes
input_translatedWählen Sie hier die Benutzer-Rollen für den Kunden aus.
i18n_string"ecs.plugin_shopuserright.p_shopuserright_profiles"table[
"eos_person"
]listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}p_shopuserright_rights
Benutzer-Rechte
TEXT
R
yes
input_translatedTragen Sie hier einzelne Benutzer-Rechte für den Kunden ein.
i18n_string"ecs.plugin_shopuserright.p_shopuserright_rights"table[
"eos_person"
]listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}persongroup
Following fields can also be selected for reading (JOIN)
grpid
auto increment
INT (11)
R
no
i18n_string"ecs.PERSONGRP.grpid"table[
"eos_person_group"
]drvd_selecteos_person_group.grpidfieldset"base_record"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"type": "hidden",
"editMode": 0
}grp_name
Kundengruppe
TEXT (127)
R
no
input_translatedGeben Sie einen aussagekräftigen Namen für die Kundengruppe ein.
i18n_string"ecs.PERSONGRP.grp_name"table[
"eos_person_group"
]drvd_selecteos_person_group.grp_namefieldset"base"listCfg{
"viewMode": 0,
"fullSearch": false,
"depends_on": "fk_p_grpid"
}formCfg{
"mandatory": 1,
"editMode": 0
}description
Beschreibung
TEXT
R
no
input_translatedGeben Sie eine Beschreibung der Kundengruppe ein (z.B. für WEN wurde sie angelegt)
i18n_string"ecs.PERSONGRP.description"table[
"eos_person_group"
]drvd_selecteos_person_group.descriptionfieldset"base"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"type": "textarea",
"editMode": 0
}grp_default
Default
INT (1)
R
no
input_translatedAktivieren Sie die Checkbox, wenn diese Kundengruppe die Standardgruppe für alle Neuregistrierten Kunden sein soll. Diese werden dann automatisch zugeordnet.
i18n_string"ecs.PERSONGRP.grp_default"table[
"eos_person_group"
]drvd_selecteos_person_group.grp_defaultfieldset"register"listCfg{
"formatter": {
"type": "active-flag"
},
"width": 64,
"viewMode": 0,
"fullSearch": false
}formCfg{
"type": "checkbox",
"editMode": 0
}grp_p_login_active
Kundenlogin Default Aktiv
INT (1)
R
no
i18n_string"ecs.PERSONGRP.grp_p_login_active"table[
"eos_person_group"
]drvd_selecteos_person_group.grp_p_login_activefieldset"defaults_person"listCfg{
"formatter": {
"type": "active-flag"
},
"width": 64,
"viewMode": 0,
"fullSearch": false
}formCfg{
"type": "checkbox",
"editMode": 0
}grp_locale
Locale Kundengruppe
DATA
R
yes
i18n_string"ecs.PERSONGRP.grp_locale"table[
"eos_person_group"
]drvd_selecteos_person_group.grp_localefieldset"defaults_person"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}grp_state
Bestellstatus
TEXT (63)
R
no
input_translatedTragen Sie hier den Eingangsstatus für Bestellung von Kunden aus dieser Kundengruppe ein.
i18n_string"ecs.PERSONGRP.grp_state"table[
"eos_person_group"
]drvd_selecteos_person_group.grp_statefieldset"defaults_order"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}grp_pos
POS Channel
TEXT (63)
R
no
input_translatedGeben Sie hier den POS Channel an, für den diese Kundengruppe gelten soll. Lassen Sie dieses Feld leer, so steht die Kundengruppe in allen POS Channels zur Verfügung.
i18n_string"ecs.PERSONGRP.grp_pos"table[
"eos_person_group"
]drvd_selecteos_person_group.grp_posfieldset"defaults_order"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}prc_display_mode
Preisanzeige
TEXT (15)
R
no
input_translatedWählen Sie aus, ob die Preise im Shopfrontend für Kunden dieser Gruppe in brutto (also mit einberechneter Umsatzsteuer) oder netto (also ohne einberechnete Umsatzsteuer) angezeigt werden sollen.
i18n_string"ecs.PERSONGRP.prc_display_mode"table[
"eos_person_group"
]drvd_selecteos_person_group.prc_display_modefieldset"prices"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"cssLayout": "col-12",
"type": "eosdropdown",
"options": {
"optI18nValuePrefix": "ecs.prc_display_mode",
"optI18nName": true,
"optI18nSubTitle": true,
"data": {
"options": [
{
"value": "brutto"
},
{
"value": "netto"
}
]
}
},
"editMode": 0
}grp_price_factor
Preis-Faktor
FLOAT (10,4)
R
yes
input_translatedDer angegebene Faktor wird bei allen Standard-Shoppreisen als Multiplikator verwendet, wenn Mitglieder dieser Kundengruppe eingeloggt sind. Falls zusätzliche ein Preisfaktor für den Kunden gesetzt wurde oder ein spezifischer Standard-Preis für die Kundengruppe gesetzt ist, wird der Kundengruppen-Preisfaktor ignoriert.
i18n_string"ecs.PERSONGRP.grp_price_factor"table[
"eos_person_group"
]drvd_selecteos_person_group.grp_price_factorfieldset"prices"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"cssLayout": "col-12",
"type": "eosnumber",
"editMode": 0
}input_translatedFalls die gewählte Preisgruppen-Spalte bei einem Produkt nicht gefüllt ist, wird die hier eingetragene Preisgruppe verwendet
i18n_string"ecs.PERSONGRP.fk_grp_prcgrp_id"table[
"eos_person_group"
]drvd_selecteos_person_group.fk_grp_prcgrp_idfieldset"prices"listCfg{
"viewMode": 3,
"fullSearch": false
}formCfg{
"editMode": 0
}grp_persongrp_prices
Gruppenspezifische Preise
INT (1)
R
no
i18n_string"ecs.PERSONGRP.grp_persongrp_prices"table[
"eos_person_group"
]drvd_selecteos_person_group.grp_persongrp_pricesfieldset"orderoptions"listCfg{
"formatter": {
"type": "active-flag"
},
"width": 64,
"viewMode": 0,
"fullSearch": false
}formCfg{
"type": "checkbox",
"editMode": 0
}grp_price_col
Preisspalte
TEXT (31)
R
yes
input_translatedGeben Sie den Namen einer speziellen Preisspalte an, die für diese Kundengruppe gelten soll. Es werden passend dazu auch Spalten für Discountpreis und Discount-Start/Enddatum erzeugt. Wird dieses Feld nicht definiert, so werden die Standardpreisspalten verwendet.
i18n_string"ecs.PERSONGRP.grp_price_col"table[
"eos_person_group"
]drvd_selecteos_person_group.grp_price_colfieldset"price_col_cfg"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}grp_discount_col
Preisspalte (Discount)
TEXT (63)
R
yes
i18n_string"ecs.PERSONGRP.grp_discount_col"table[
"eos_person_group"
]drvd_selectIF(eos_person_group.grp_price_col IS NOT NULL, REPLACE(eos_person_group.grp_price_col,'price_','discount_'),null)listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}grp_discount_start_col
Preisspalte (Discount Start)
TEXT (63)
R
yes
i18n_string"ecs.PERSONGRP.grp_discount_start_col"table[
"eos_person_group"
]drvd_selectIF(eos_person_group.grp_price_col IS NOT NULL, REPLACE(eos_person_group.grp_price_col,'price_','discount_start_'),null)listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}grp_discount_end_col
Preisspalte (Discount Ende)
TEXT (63)
R
yes
i18n_string"ecs.PERSONGRP.grp_discount_end_col"table[
"eos_person_group"
]drvd_selectIF(eos_person_group.grp_price_col IS NOT NULL, REPLACE(eos_person_group.grp_price_col,'price_','discount_end_'),null)listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}grp_price_dsc_scale_col
Preisspalte (Staffelpreise)
TEXT (63)
R
no
i18n_string"ecs.PERSONGRP.grp_price_dsc_scale_col"table[
"eos_person_group"
]drvd_selecteos_person_group.grp_price_dsc_scale_colfieldset"price_col_cfg"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}grp_price_prcgrp_col
Preisgruppen-Spalte
TEXT (63)
R
no
input_translatedLegen Sie fest, welche Spalte in den Preisdaten die Preisgruppe für diese Kundengruppe enthält.
i18n_string"ecs.PERSONGRP.grp_price_prcgrp_col"table[
"eos_person_group"
]drvd_selecteos_person_group.grp_price_prcgrp_colfieldset"price_col_cfg"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}grp_price_state_col
Spalte für Shop-Status
TEXT (63)
R
no
i18n_string"ecs.PERSONGRP.grp_price_state_col"table[
"eos_person_group"
]drvd_selecteos_person_group.grp_price_state_colfieldset"price_col_cfg"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}grp_price_hide_price_dsp_col
Spalte für Preis ausblenden
TEXT (63)
R
no
i18n_string"ecs.PERSONGRP.grp_price_hide_price_dsp_col"table[
"eos_person_group"
]drvd_selecteos_person_group.grp_price_hide_price_dsp_colfieldset"price_col_cfg"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}input_translatedGeben Sie das Label des Bestelloptionen-Profils an, dass Sie verwenden möchten. Lassen Sie dieses Feld leer, wenn Sie das Standard-Profil nutzen wollen.
i18n_string"ecs.PERSONGRP.grp_oo_set_label"table[
"eos_person_group"
]drvd_selecteos_person_group.grp_oo_set_labelfieldset"orderoptions"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}i18n_string"ecs.PERSONGRP.fk_grp_pay_profile_id"table[
"eos_person_group"
]drvd_selecteos_person_group.fk_grp_pay_profile_idfieldset"orderoptions"listCfg{
"viewMode": 3,
"fullSearch": false
}formCfg{
"editMode": 0
}data
Daten
DATA
R
yes
input_translatedGeben Sie hier zusätzliche Daten als Array an.
array(
'var1' => 'wert1',
'var2' => 'wert2',
)
array(
'var1' => 'wert1',
'var2' => 'wert2',
)
i18n_string"ecs.PERSONGRP.data"table[
"eos_person_group"
]drvd_selecteos_person_group.datafieldset"extra"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"cssLayout": "col-12",
"type": "aceeditor",
"options": {
"mode": "json"
},
"editMode": 0
}grp_shopuserright_profiles
Gruppen-Rollen
TEXT
R
yes
input_translatedWählen Sie hier die Benutzer-Rollen für die Kundengruppen aus.
i18n_string"ecs.plugin_shopuserright.grp_shopuserright_profiles"table[
"eos_person_group"
]drvd_selecteos_person_group.grp_shopuserright_profileslistCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}grp_shopuserright_rights
Gruppen-Rechte
TEXT
R
yes
input_translatedTragen Sie hier einzelne Benutzer-Rechte für die Kundengruppe ein.
i18n_string"ecs.plugin_shopuserright.grp_shopuserright_rights"table[
"eos_person_group"
]drvd_selecteos_person_group.grp_shopuserright_rightslistCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}order
Following fields can also be selected for reading (JOIN)
oid
INT (11)
R
yes
i18n_string"ecs.INVOICE.oid"table[
"eos_order"
]drvd_selecteos_order.oidlistCfg{
"viewMode": 3
}formCfg{
"editMode": 0
}orderid
Auftrags-Nr.
TEXT (63)
R
no
i18n_string"ecs.ORDER.orderid"table[
"eos_order"
]drvd_selecteos_order.orderidlistCfg{
"full_search": true,
"formatter": {
"type": "model-primary",
"params": {
"model": "order",
"primaryKey": "oid",
"statusColorField": "order_state_color",
"subTitleTemplate": "{%invoice_firstname %} {%invoice_lastname%}"
}
},
"viewMode": 0
}formCfg{
"editMode": 0
}input_translatedWählen Sie den Shop aus, zu dem dieser Auftrag gehört.
i18n_string"ecs.ORDER.fk_o_shopid"table[
"eos_order"
]drvd_selecteos_order.fk_o_shopidfieldset"marketing"listCfg{
"viewMode": 0
}formCfg{
"editMode": 0
}input_translatedGeben Sie die Kunden-ID eines Kunden ein.
i18n_string"ecs.ORDER.fk_o_persid"table[
"eos_order"
]drvd_selecteos_order.fk_o_persidfieldset"base_record"listCfg{
"viewMode": 0
}formCfg{
"cssLayout": "col-12 col-md-6 col-xl-3",
"mandatory": true,
"editMode": 0
}o_time_ordered
Bestelldatum
DATETIME
R
yes
i18n_string"ecs.ORDER.o_time_ordered"table[
"eos_order"
]drvd_selecteos_order.o_time_orderedfieldset"base_record"listCfg{
"formatter": {
"type": "date"
},
"viewMode": 0
}formCfg{
"cssLayout": "col-12 col-md-6 col-xl-3",
"editMode": 0
}total_netto
[EUR]
∑ Gesamt, Netto
FLOAT (13,2)
R
no
i18n_string"ecs.ORDER.total_netto"table[
"eos_order"
]drvd_selecteos_order.total_nettolistCfg{
"formatter": {
"type": "currency"
},
"viewMode": 0,
"sumType": "SV"
}formCfg{
"editMode": 0
}total_brutto
[EUR]
∑ Gesamt, Brutto
FLOAT (13,2)
R
no
i18n_string"ecs.ORDER.total_brutto"table[
"eos_order"
]drvd_selecteos_order.total_bruttolistCfg{
"formatter": {
"type": "currency"
},
"sumType": "SV",
"viewMode": 0
}formCfg{
"editMode": 0
}o_orderid_external
Externe Auftrags-Nr.
TEXT (255)
R
yes
input_translatedGeben Sie hier ggf. eine externe erhaltene Auftragsnummer ein. Diese bekommen Sie z.B. wenn der Auftrag über einen externen Marktplatz (z.B. Amazon Marketplace) erstellt wurde.
i18n_string"ecs.ORDER.o_orderid_external"table[
"eos_order"
]drvd_selecteos_order.o_orderid_externalfieldset"base"listCfg{
"viewMode": 0
}formCfg{
"cssLayout": "col-12 col-md-6 col-xl-3",
"editMode": 0
}i18n_string"ecs.ORDER.fk_o_posid"table[
"eos_order"
]drvd_selecteos_order.fk_o_posidfieldset"base"listCfg{
"viewMode": 0
}formCfg{
"cssLayout": "col-12 col-md-6 col-xl-3",
"editMode": 0
}i18n_string"ecs.ORDER.fk_o_stid"table[
"eos_order"
]drvd_selecteos_order.fk_o_stidfieldset"base"listCfg{
"viewMode": 3
}formCfg{
"cssLayout": "col-12 col-md-6 col-xl-3",
"editMode": 0
}i18n_string"ecs.ORDER.fk_o_st_id"table[
"eos_order"
]drvd_selecteos_order.fk_o_st_idfieldset"base"listCfg{
"viewMode": 3
}formCfg{
"cssLayout": "col-12 col-md-6 col-xl-3",
"editMode": 0
}o_pers_reftext
Kunden-Referenztext
TEXT
R
yes
input_translatedGeben Sie einen Referenztext des Kunden ein.
i18n_string"ecs.ORDER.o_pers_reftext"table[
"eos_order"
]drvd_selecteos_order.o_pers_reftextlistCfg{
"viewMode": 0
}formCfg{
"editMode": 0
}o_pers_seq_nr
Auftrags-Sequenz-Nr.
INT (11)
R
no
i18n_string"ecs.ORDER.o_pers_seq_nr"table[
"eos_order"
]drvd_selecteos_order.o_pers_seq_nrlistCfg{
"viewMode": 0
}formCfg{
"editMode": 0
}quantity
Bestellmenge
FLOAT (13,4)
R
no
i18n_string"ecs.ORDER.quantity"table[
"eos_order"
]drvd_selecteos_order.quantitylistCfg{
"viewMode": 0,
"sumType": "SV"
}formCfg{
"editMode": 0
}drvd_total_vat
[EUR]
MwSt. (Gesamt)
FLOAT (13,2)
R
no
i18n_string"ecs.ORDER.drvd_total_vat"table[
"eos_order"
]drvd_selectROUND(eos_order.total_brutto - eos_order.total_netto, 2)listCfg{
"formatter": {
"type": "currency"
},
"viewMode": 0,
"sumType": "SV"
}formCfg{
"editMode": 0
}otitle
Auftragstitel
TEXT
R
yes
input_translatedGeben Sie dem Auftrag einen Titel.
i18n_string"ecs.ORDER.otitle"table[
"eos_order"
]drvd_selecteos_order.otitlefieldset"doc_header"listCfg{
"viewMode": 0
}formCfg{
"cssLayout": "col-12",
"editMode": 0
}otext
Auftragsbeschreibung
TEXT
R
yes
i18n_string"ecs.ORDER.otext"table[
"eos_order"
]drvd_selecteos_order.otextfieldset"extra"listCfg{
"viewMode": 0
}formCfg{
"type": "textarea",
"editMode": 0
}o_type
Auftragstyp
TEXT (15)
R
yes
enum[
"order",
"offer"
]i18n_string"ecs.ORDER.o_type"table[
"eos_order"
]drvd_selecteos_order.o_typefieldset"base_record"listCfg{
"viewMode": 0
}formCfg{
"cssLayout": "col-12 col-md-6 col-xl-3",
"type": "eosdropdown",
"value": "order",
"options": {
"optI18nValuePrefix": "ecs.o_type",
"optI18nName": true,
"data": {
"options": [
{
"value": "order"
},
{
"value": "offer"
},
{
"value": "tpl"
}
]
}
},
"editMode": 0
}o_valid_until
Gültig bis
DATETIME
R
yes
i18n_string"ecs.ORDER.o_valid_until"table[
"eos_order"
]drvd_selecteos_order.o_valid_untillistCfg{
"viewMode": 0,
"formatter": {
"type": "date"
}
}formCfg{
"type": "datetimepicker",
"editMode": 0
}o_txt_header
Kopf-Text
TEXT
R
yes
input_translatedKopf-Text für die Verwendung in PDFs
i18n_string"ecs.ORDER.o_txt_header"table[
"eos_order"
]drvd_selecteos_order.o_txt_headerfieldset"doc_header"listCfg{
"viewMode": 0,
"fullSearch": true
}formCfg{
"fieldSetCol": "12",
"type": "eoseditor",
"editMode": 0
}invoice_addr_preset
Adressbuch (R)
TEXT
R
yes
i18n_string"ecs.ORDER.invoice_addr_preset"table[
"eos_order"
]drvd_selectNULLfieldset"inv_addr"listCfg{
"viewMode": 3
}formCfg{
"cssLayout": "col-12",
"type": "eosdropdown",
"options": {
"serverSideSearch": false,
"valueType": "object",
"optNameTemplate": "{%adr_lastname%}, {%adr_firstname%} ({%adr_company%})",
"optSubTitleTemplate": "{%adr_extra1%} {%adr_street%} {%adr_housenr%}, {%adr_zip%} {%adr_town%} - {%adr_country%}",
"optExtraTemplate": "{%adr_ref_type%}",
"optDataLoad": [
"adr_gender"
],
"observer": {
"fields": [
{
"field": "fk_o_persid",
"trigger": "onInit",
"exec": [
{
"cmd": "loadOptions",
"params": {
"dataStreamCall": {
"method": "paddress_getlist",
"params": {
"filter": {
"adr_ref_id": "{%FIELD.value%}"
}
}
}
}
}
]
},
{
"field": "fk_o_persid",
"trigger": "onChange",
"exec": [
{
"cmd": "loadOptions",
"params": {
"dataStreamCall": {
"method": "paddress_getlist",
"params": {
"filter": {
"adr_ref_id": "{%FIELD.value%}"
}
}
}
}
}
]
}
]
}
},
"editMode": 0
}invoice_gender
Anrede (R)
TEXT
R
yes
enum[
"female",
"male",
"company",
"divers"
]i18n_string"ecs.ORDER.invoice_gender"table[
"eos_order"
]drvd_selecteos_order.invoice_genderfieldset"inv_addr"listCfg{
"viewMode": 0
}formCfg{
"cssLayout": "col-6 col-xl-2",
"type": "eosdropdown",
"options": {
"optI18nValuePrefix": "ecs.gender",
"optI18nName": true,
"data": {
"options": [
{
"value": null
},
{
"value": "female"
},
{
"value": "male"
},
{
"value": "company"
},
{
"value": "divers"
}
]
},
"observer": {
"fields": [
{
"field": "invoice_addr_preset",
"trigger": "onChange",
"exec": [
{
"cmd": "template",
"params": {
"tpl": "{% FIELD.value.data.adr_gender %}"
}
}
]
}
]
}
},
"editMode": 0
}invoice_title
Titel (R)
TEXT
R
no
i18n_string"ecs.ORDER.invoice_title"table[
"eos_order"
]drvd_selecteos_order.invoice_titlefieldset"inv_addr"listCfg{
"viewMode": 0
}formCfg{
"cssLayout": "col-6 col-xl-2",
"type": "text",
"options": {
"observer": {
"fields": [
{
"field": "invoice_addr_preset",
"trigger": "onChange",
"exec": [
{
"cmd": "template",
"params": {
"tpl": "{% FIELD.value.data.adr_title %}"
}
}
]
}
]
}
},
"editMode": 0
}invoice_firstname
Vorname (R)
TEXT
R
no
i18n_string"ecs.ORDER.invoice_firstname"table[
"eos_order"
]drvd_selecteos_order.invoice_firstnamefieldset"inv_addr"listCfg{
"viewMode": 0,
"fullSearch": true
}formCfg{
"cssLayout": "col-6 col-xl-4",
"type": "text",
"options": {
"observer": {
"fields": [
{
"field": "invoice_addr_preset",
"trigger": "onChange",
"exec": [
{
"cmd": "template",
"params": {
"tpl": "{% FIELD.value.data.adr_firstname%}"
}
}
]
}
]
}
},
"editMode": 0
}invoice_lastname
Nachname (R)
TEXT
R
no
i18n_string"ecs.ORDER.invoice_lastname"table[
"eos_order"
]drvd_selecteos_order.invoice_lastnamefieldset"inv_addr"listCfg{
"fullSearch": true,
"viewMode": 0
}formCfg{
"cssLayout": "col-6 col-xl-4",
"type": "text",
"options": {
"observer": {
"fields": [
{
"field": "invoice_addr_preset",
"trigger": "onChange",
"exec": [
{
"cmd": "template",
"params": {
"tpl": "{% FIELD.value.data.adr_lastname %}"
}
}
]
}
]
}
},
"editMode": 0
}invoice_company
Firma (R)
TEXT
R
no
i18n_string"ecs.ORDER.invoice_company"table[
"eos_order"
]drvd_selecteos_order.invoice_companyfieldset"inv_addr"listCfg{
"fullSearch": true,
"viewMode": 0
}formCfg{
"cssLayout": "col-6",
"type": "text",
"options": {
"observer": {
"fields": [
{
"field": "invoice_addr_preset",
"trigger": "onChange",
"exec": [
{
"cmd": "template",
"params": {
"tpl": "{% FIELD.value.data.adr_company %}"
}
}
]
}
]
}
},
"editMode": 0
}invoice_addrextra
Adressenzusatz
TEXT
R
no
i18n_string"ecs.ORDER.invoice_addrextra"table[
"eos_order"
]drvd_selecteos_order.invoice_addrextrafieldset"inv_addr"listCfg{
"viewMode": 0
}formCfg{
"cssLayout": "col-6",
"type": "text",
"options": {
"observer": {
"fields": [
{
"field": "invoice_addr_preset",
"trigger": "onChange",
"exec": [
{
"cmd": "template",
"params": {
"tpl": "{% FIELD.value.data.adr_extra1 %}"
}
}
]
}
]
}
},
"editMode": 0
}invoice_street
Straße (R)
TEXT
R
no
i18n_string"ecs.ORDER.invoice_street"table[
"eos_order"
]drvd_selecteos_order.invoice_streetfieldset"inv_addr"listCfg{
"viewMode": 0
}formCfg{
"cssLayout": "col-9",
"type": "text",
"options": {
"observer": {
"fields": [
{
"field": "invoice_addr_preset",
"trigger": "onChange",
"exec": [
{
"cmd": "template",
"params": {
"tpl": "{% FIELD.value.data.adr_street %}"
}
}
]
}
]
}
},
"editMode": 0
}invoice_housenr
Hausnummer (R)
TEXT
R
no
i18n_string"ecs.ORDER.invoice_housenr"table[
"eos_order"
]drvd_selecteos_order.invoice_housenrfieldset"inv_addr"listCfg{
"viewMode": 0
}formCfg{
"cssLayout": "col-3",
"type": "text",
"options": {
"observer": {
"fields": [
{
"field": "invoice_addr_preset",
"trigger": "onChange",
"exec": [
{
"cmd": "template",
"params": {
"tpl": "{% FIELD.value.data.adr_housenr %}"
}
}
]
}
]
}
},
"editMode": 0
}invoice_zip
PLZ (R)
TEXT
R
no
i18n_string"ecs.ORDER.invoice_zip"table[
"eos_order"
]drvd_selecteos_order.invoice_zipfieldset"inv_addr"listCfg{
"viewMode": 0
}formCfg{
"cssLayout": "col-4",
"type": "text",
"options": {
"observer": {
"fields": [
{
"field": "invoice_addr_preset",
"trigger": "onChange",
"exec": [
{
"cmd": "template",
"params": {
"tpl": "{% FIELD.value.data.adr_zip %}"
}
}
]
}
]
}
},
"editMode": 0
}invoice_town
Ort (R)
TEXT
R
no
i18n_string"ecs.ORDER.invoice_town"table[
"eos_order"
]drvd_selecteos_order.invoice_townfieldset"inv_addr"listCfg{
"fullSearch": true,
"viewMode": 0
}formCfg{
"cssLayout": "col-8",
"type": "text",
"options": {
"observer": {
"fields": [
{
"field": "invoice_addr_preset",
"trigger": "onChange",
"exec": [
{
"cmd": "template",
"params": {
"tpl": "{% FIELD.value.data.adr_town %}"
}
}
]
}
]
}
},
"editMode": 0
}invoice_state_code
Bundesland (Code) (R)
TEXT (15)
R
yes
i18n_string"ecs.ORDER.invoice_state_code"table[
"eos_order"
]drvd_selecteos_order.invoice_state_codefieldset"inv_addr"listCfg{
"viewMode": 0
}formCfg{
"cssLayout": "col-6",
"type": "eosdropdown",
"options": {
"dataStreamCall": {
"method": "state_getlist"
},
"serverSideSearch": false,
"optValueField": "terr_code",
"optNameField": "terr_name",
"optExtraField": "terr_code",
"observer": {
"fields": [
{
"field": "invoice_addr_preset",
"trigger": "onChange",
"exec": [
{
"cmd": "template",
"params": {
"tpl": "{%FIELD.value.data.adr_state_code%}"
}
}
]
},
{
"field": "invoice_country",
"trigger": "onInit",
"exec": [
{
"cmd": "loadOptions",
"params": {
"dataStreamCall": {
"method": "state_getlist",
"params": {
"filter": {
"state_country": "{%FIELD.value%}"
}
}
}
}
}
]
},
{
"field": "invoice_country",
"trigger": "onChange",
"exec": [
{
"cmd": "loadOptions",
"params": {
"dataStreamCall": {
"method": "state_getlist",
"params": {
"filter": {
"state_country": "{%FIELD.value%}"
}
}
}
}
}
]
}
]
}
},
"editMode": 0
}i18n_string"ecs.ORDER.invoice_country"table[
"eos_order"
]drvd_selecteos_order.invoice_countryfieldset"inv_addr"listCfg{
"viewMode": 0,
"formatter": {
"type": "country-flag"
}
}formCfg{
"cssLayout": "col-6",
"options": {
"observer": {
"fields": [
{
"field": "invoice_addr_preset",
"trigger": "onChange",
"exec": [
{
"cmd": "template",
"params": {
"tpl": "{% FIELD.value.data.adr_country %}"
}
}
]
}
]
}
},
"editMode": 0
}invoice_type
Rechnungsart
TEXT
R
yes
enum[
"noncommercial",
"commercial"
]i18n_string"ecs.ORDER.invoice_type"table[
"eos_order"
]drvd_selecteos_order.invoice_typefieldset"inv_extra"listCfg{
"viewMode": 0
}formCfg{
"cssLayout": "col-4",
"type": "eosdropdown",
"options": {
"optI18nValuePrefix": "ecs.invoice_type",
"optI18nName": true,
"data": {
"options": [
{
"value": "noncommercial"
},
{
"value": "commercial"
}
]
}
},
"editMode": 0
}invoice_email
E-Mail (R)
TEXT
R
no
i18n_string"ecs.ORDER.invoice_email"table[
"eos_order"
]drvd_selecteos_order.invoice_emailfieldset"inv_extra"listCfg{
"viewMode": 0
}formCfg{
"cssLayout": "col-4",
"editMode": 0
}invoice_taxidentnumber
USt.ID-Nr.
TEXT
R
no
i18n_string"ecs.ORDER.invoice_taxidentnumber"table[
"eos_order"
]drvd_selecteos_order.invoice_taxidentnumberfieldset"inv_extra"listCfg{
"viewMode": 0
}formCfg{
"cssLayout": "col-4",
"editMode": 0
}invoice_taxident_status
USt.ID-Nr. Status
TEXT
R
yes
enum[
"invalid",
"valid_conditional",
"valid_confirmed"
]i18n_string"ecs.ORDER.invoice_taxident_status"table[
"eos_order"
]drvd_selecteos_order.invoice_taxident_statusfieldset"inv_extra"listCfg{
"viewMode": 0,
"formatter": {
"type": "status"
}
}formCfg{
"type": "eosdropdown",
"options": {
"optI18nValuePrefix": "ecs.taxident_status",
"optI18nName": true,
"data": {
"options": [
{
"value": null
},
{
"value": "invalid"
},
{
"value": "valid_conditional"
},
{
"value": "valid_confirmed"
}
]
}
},
"editMode": 0
}invoice_third_country_export
Ausfuhrbescheinigung
TEXT
R
yes
enum[
"none",
"certificate_promised",
"certificate_received"
]i18n_string"ecs.ORDER.invoice_third_country_export"table[
"eos_order"
]drvd_selecteos_order.invoice_third_country_exportfieldset"inv_extra"listCfg{
"viewMode": 0
}formCfg{
"type": "eosdropdown",
"options": {
"optI18nValuePrefix": "ecs.invoice_third_country_export",
"optI18nName": true,
"data": {
"options": [
{
"value": "none"
},
{
"value": "certificate_promised"
},
{
"value": "certificate_received"
}
]
}
},
"editMode": 0
}invoice_lang_iso
Rechnungssprache
TEXT (2)
R
no
input_translatedGeben Sie den Sprache der Rechnung als ISO-Code (z.B. DE, EN) an.
i18n_string"ecs.ORDER.invoice_lang_iso"table[
"eos_order"
]drvd_selecteos_order.invoice_lang_isofieldset"inv_extra"listCfg{
"viewMode": 0,
"formatter": {
"type": "country-flag"
}
}formCfg{
"editMode": 0
}drvd_invoice_street_housenr
Straße+Nr (R)
TEXT
R
no
i18n_string"ecs.ORDER.drvd_invoice_street_housenr"table[
"eos_order"
]drvd_selectCONCAT_WS("",eos_order.invoice_street," ",eos_order.invoice_housenr)listCfg{
"viewMode": 0
}formCfg{
"editMode": 0
}deliver_addr_preset
Adressbuch (L)
DATA
R
yes
i18n_string"ecs.ORDER.deliver_addr_preset"table[
"eos_order"
]drvd_selectNULLfieldset"dlv_addr"listCfg{
"viewMode": 3
}formCfg{
"cssLayout": "col-12",
"type": "eosdropdown",
"options": {
"serverSideSearch": false,
"valueType": "object",
"optNameTemplate": "{%adr_lastname%}, {%adr_firstname%} ({%adr_company%})",
"optSubTitleTemplate": "{%adr_extra1%} {%adr_street%} {%adr_housenr%}, {%adr_zip%} {%adr_town%} - {%adr_country%}",
"optExtraTemplate": "{%adr_ref_type%}",
"optDataLoad": [
"adr_gender"
],
"observer": {
"fields": [
{
"field": "fk_o_persid",
"trigger": "onInit",
"exec": [
{
"cmd": "loadOptions",
"params": {
"dataStreamCall": {
"method": "paddress_getlist",
"params": {
"filter": {
"adr_ref_id": "{%FIELD.value%}"
}
}
}
}
}
]
},
{
"field": "fk_o_persid",
"trigger": "onChange",
"exec": [
{
"cmd": "loadOptions",
"params": {
"dataStreamCall": {
"method": "paddress_getlist",
"params": {
"filter": {
"adr_ref_id": "{%FIELD.value%}"
}
}
}
}
}
]
}
]
}
},
"editMode": 0
}deliver_gender
Anrede (L)
TEXT
R
yes
enum[
"female",
"male",
"company",
"divers"
]i18n_string"ecs.ORDER.deliver_gender"table[
"eos_order"
]drvd_selecteos_order.deliver_genderfieldset"dlv_addr"listCfg{
"viewMode": 0
}formCfg{
"cssLayout": "col-6 col-xl-2",
"type": "eosdropdown",
"options": {
"optI18nValuePrefix": "ecs.gender",
"optI18nName": true,
"data": {
"options": [
{
"value": null
},
{
"value": "female"
},
{
"value": "male"
},
{
"value": "company"
},
{
"value": "divers"
}
]
},
"observer": {
"fields": [
{
"field": "deliver_addr_preset",
"trigger": "onChange",
"exec": [
{
"cmd": "template",
"params": {
"tpl": "{% FIELD.value.data.adr_gender %}"
}
}
]
}
]
}
},
"editMode": 0
}deliver_title
Titel (L)
TEXT
R
no
i18n_string"ecs.ORDER.deliver_title"table[
"eos_order"
]drvd_selecteos_order.deliver_titlefieldset"dlv_addr"listCfg{
"viewMode": 0
}formCfg{
"cssLayout": "col-6 col-xl-2",
"options": {
"observer": {
"fields": [
{
"field": "deliver_addr_preset",
"trigger": "onChange",
"exec": [
{
"cmd": "template",
"params": {
"tpl": "{%FIELD.value.data.adr_title%}"
}
}
]
}
]
}
},
"editMode": 0
}deliver_firstname
Vorname (L)
TEXT
R
no
i18n_string"ecs.ORDER.deliver_firstname"table[
"eos_order"
]drvd_selecteos_order.deliver_firstnamefieldset"dlv_addr"listCfg{
"viewMode": 0
}formCfg{
"cssLayout": "col-6 col-xl-4",
"options": {
"observer": {
"fields": [
{
"field": "deliver_addr_preset",
"trigger": "onChange",
"exec": [
{
"cmd": "template",
"params": {
"tpl": "{%FIELD.value.data.adr_firstname%}"
}
}
]
}
]
}
},
"editMode": 0
}deliver_lastname
Nachname (L)
TEXT
R
no
i18n_string"ecs.ORDER.deliver_lastname"table[
"eos_order"
]drvd_selecteos_order.deliver_lastnamefieldset"dlv_addr"listCfg{
"viewMode": 0,
"fullSearch": true
}formCfg{
"cssLayout": "col-6 col-xl-4",
"options": {
"observer": {
"fields": [
{
"field": "deliver_addr_preset",
"trigger": "onChange",
"exec": [
{
"cmd": "template",
"params": {
"tpl": "{%FIELD.value.data.adr_lastname%}"
}
}
]
}
]
}
},
"editMode": 0
}deliver_company
Firma (L)
TEXT
R
no
i18n_string"ecs.ORDER.deliver_company"table[
"eos_order"
]drvd_selecteos_order.deliver_companyfieldset"dlv_addr"listCfg{
"viewMode": 0
}formCfg{
"cssLayout": "col-6",
"options": {
"observer": {
"fields": [
{
"field": "deliver_addr_preset",
"trigger": "onChange",
"exec": [
{
"cmd": "template",
"params": {
"tpl": "{%FIELD.value.data.adr_company%}"
}
}
]
}
]
}
},
"editMode": 0
}deliver_addrextra
Adressenzusatz
TEXT
R
no
i18n_string"ecs.ORDER.deliver_addrextra"table[
"eos_order"
]drvd_selecteos_order.deliver_addrextrafieldset"dlv_addr"listCfg{
"viewMode": 0
}formCfg{
"cssLayout": "col-6",
"options": {
"observer": {
"fields": [
{
"field": "deliver_addr_preset",
"trigger": "onChange",
"exec": [
{
"cmd": "template",
"params": {
"tpl": "{%FIELD.value.data.adr_extra1%}"
}
}
]
}
]
}
},
"editMode": 0
}deliver_street
Straße (L)
TEXT
R
no
i18n_string"ecs.ORDER.deliver_street"table[
"eos_order"
]drvd_selecteos_order.deliver_streetfieldset"dlv_addr"listCfg{
"viewMode": 0
}formCfg{
"cssLayout": "col-9",
"options": {
"observer": {
"fields": [
{
"field": "deliver_addr_preset",
"trigger": "onChange",
"exec": [
{
"cmd": "template",
"params": {
"tpl": "{%FIELD.value.data.adr_street%}"
}
}
]
}
]
}
},
"editMode": 0
}deliver_housenr
Hausnummer (L)
TEXT
R
no
i18n_string"ecs.ORDER.deliver_housenr"table[
"eos_order"
]drvd_selecteos_order.deliver_housenrfieldset"dlv_addr"listCfg{
"viewMode": 0
}formCfg{
"cssLayout": "col-3",
"options": {
"observer": {
"fields": [
{
"field": "deliver_addr_preset",
"trigger": "onChange",
"exec": [
{
"cmd": "template",
"params": {
"tpl": "{%FIELD.value.data.adr_housenr%}"
}
}
]
}
]
}
},
"editMode": 0
}deliver_zip
PLZ (L)
TEXT
R
no
i18n_string"ecs.ORDER.deliver_zip"table[
"eos_order"
]drvd_selecteos_order.deliver_zipfieldset"dlv_addr"listCfg{
"viewMode": 0
}formCfg{
"cssLayout": "col-4",
"options": {
"observer": {
"fields": [
{
"field": "deliver_addr_preset",
"trigger": "onChange",
"exec": [
{
"cmd": "template",
"params": {
"tpl": "{%FIELD.value.data.adr_zip%}"
}
}
]
}
]
}
},
"editMode": 0
}deliver_town
Ort (L)
TEXT
R
no
i18n_string"ecs.ORDER.deliver_town"table[
"eos_order"
]drvd_selecteos_order.deliver_townfieldset"dlv_addr"listCfg{
"full_search": true,
"viewMode": 0
}formCfg{
"cssLayout": "col-8",
"options": {
"observer": {
"fields": [
{
"field": "deliver_addr_preset",
"trigger": "onChange",
"exec": [
{
"cmd": "template",
"params": {
"tpl": "{%FIELD.value.data.adr_town%}"
}
}
]
}
]
}
},
"editMode": 0
}deliver_state_code
Bundesland (Code) (L)
TEXT (15)
R
yes
i18n_string"ecs.ORDER.deliver_state_code"table[
"eos_order"
]drvd_selecteos_order.deliver_state_codefieldset"dlv_addr"listCfg{
"viewMode": 0
}formCfg{
"cssLayout": "col-6",
"type": "eosdropdown",
"options": {
"dataStreamCall": {
"method": "state_getlist"
},
"serverSideSearch": false,
"optValueField": "terr_code",
"optNameField": "terr_name",
"optExtraField": "terr_code",
"observer": {
"fields": [
{
"field": "deliver_addr_preset",
"trigger": "onChange",
"exec": [
{
"cmd": "template",
"params": {
"tpl": "{%FIELD.value.data.adr_state_code%}"
}
}
]
},
{
"field": "deliver_country",
"trigger": "onInit",
"exec": [
{
"cmd": "loadOptions",
"params": {
"dataStreamCall": {
"method": "state_getlist",
"params": {
"filter": {
"state_country": "{%FIELD.value%}"
}
}
}
}
}
]
},
{
"field": "deliver_country",
"trigger": "onChange",
"exec": [
{
"cmd": "loadOptions",
"params": {
"dataStreamCall": {
"method": "state_getlist",
"params": {
"filter": {
"state_country": "{%FIELD.value%}"
}
}
}
}
}
]
}
]
}
},
"editMode": 0
}i18n_string"ecs.ORDER.deliver_country"table[
"eos_order"
]drvd_selecteos_order.deliver_countryfieldset"dlv_addr"listCfg{
"viewMode": 0,
"formatter": {
"type": "country-flag"
}
}formCfg{
"cssLayout": "col-6",
"options": {
"observer": {
"fields": [
{
"field": "deliver_addr_preset",
"trigger": "onChange",
"exec": [
{
"cmd": "template",
"params": {
"tpl": "{%FIELD.value.data.adr_country%}"
}
}
]
}
]
}
},
"editMode": 0
}deliver_date_req
Kunden-Wunschtermin
TEXT
R
no
i18n_string"ecs.ORDER.deliver_date_req"table[
"eos_order"
]drvd_selecteos_order.deliver_date_reqfieldset"dlv_extra"listCfg{
"viewMode": 0
}formCfg{
"editMode": 0
}deliver_phone
Telefon
TEXT
R
no
i18n_string"ecs.ORDER.deliver_phone"table[
"eos_order"
]drvd_selecteos_order.deliver_phonefieldset"dlv_extra"listCfg{
"viewMode": 0
}formCfg{
"editMode": 0
}deliver_email
E-Mail (L)
TEXT
R
no
i18n_string"ecs.ORDER.deliver_email"table[
"eos_order"
]drvd_selecteos_order.deliver_emailfieldset"dlv_extra"listCfg{
"viewMode": 0
}formCfg{
"editMode": 0
}deliver_comment
Liefer-Hinweise
TEXT
R
no
input_translatedGeben Sie hier einen Lieferhinweis für den Lieferanten ein.
i18n_string"ecs.ORDER.deliver_comment"table[
"eos_order"
]drvd_selecteos_order.deliver_commentfieldset"dlv_extra"listCfg{
"viewMode": 0
}formCfg{
"editMode": 0
}drvd_deliver_street_housenr
Straße+Nr (L)
TEXT
R
no
i18n_string"ecs.ORDER.drvd_deliver_street_housenr"table[
"eos_order"
]drvd_selectCONCAT_WS("",eos_order.deliver_street," ",eos_order.deliver_housenr)listCfg{
"viewMode": 0
}formCfg{
"editMode": 0
}deliver_notes_xdata
Lieferhinweise
DATA
R
yes
i18n_string"ecs.ORDER.deliver_notes_xdata"table[
"eos_order"
]drvd_selecteos_order.deliver_notes_xdatafieldset"dlv_extra"listCfg{
"viewMode": 0
}formCfg{
"cssLayout": "col-12",
"type": "aceeditor",
"options": {
"mode": "json"
},
"editMode": 0
}ip_address
IP-Adresse
TEXT
R
yes
i18n_string"ecs.ORDER.ip_address"table[
"eos_order"
]drvd_selecteos_order.ip_addressfieldset"sys_record"listCfg{
"viewMode": 0
}formCfg{
"editMode": 0
}o_referrer
Referrer
TEXT
R
yes
i18n_string"ecs.ORDER.o_referrer"table[
"eos_order"
]drvd_selecteos_order.o_referrerfieldset"sys_record"listCfg{
"viewMode": 0
}formCfg{
"editMode": 0
}o_useragent
User-Agent
TEXT
R
yes
i18n_string"ecs.ORDER.o_useragent"table[
"eos_order"
]drvd_selecteos_order.o_useragentfieldset"sys_record"listCfg{
"viewMode": 0
}formCfg{
"editMode": 0
}o_comment
Kundenkommentar
TEXT
R
yes
input_translatedGeben Sie hier einen Kommentar zum Auftrag ein.
i18n_string"ecs.ORDER.o_comment"table[
"eos_order"
]drvd_selecteos_order.o_commentfieldset"extra"listCfg{
"viewMode": 0
}formCfg{
"type": "textarea",
"editMode": 0
}o_comment_internal
Interner Bestellhinweis
TEXT
R
yes
input_translatedVergeben Sie hier einen internen Kommentar, z.B. für andere Auftragsbearbeiter.
i18n_string"ecs.ORDER.o_comment_internal"table[
"eos_order"
]drvd_selecteos_order.o_comment_internalfieldset"extra"listCfg{
"viewMode": 0
}formCfg{
"type": "textarea",
"editMode": 0
}o_lock_time
Bearbeitungs-Sperre (Zeitpunkt)
DATETIME
R
yes
i18n_string"ecs.ORDER.o_lock_time"table[
"eos_order"
]drvd_selecteos_order.o_lock_timelistCfg{
"viewMode": 0
}formCfg{
"editMode": 0
}o_lock_user
Bearbeitungs-Sperre (Benutzer)
TEXT (31)
R
yes
i18n_string"ecs.ORDER.o_lock_user"table[
"eos_order"
]drvd_selecteos_order.o_lock_userlistCfg{
"viewMode": 0
}formCfg{
"editMode": 0
}o_insert_time
Angelegt am
DATETIME
R
no
i18n_string"insert_time"table[
"eos_order"
]drvd_selecteos_order.o_insert_timefieldset"sys_record"listCfg{
"viewMode": 0
}formCfg{
"editMode": 0
}o_update_time
Geändert am
DATETIME
R
yes
i18n_string"update_time"table[
"eos_order"
]drvd_selecteos_order.o_update_timefieldset"sys_record"listCfg{
"viewMode": 0
}formCfg{
"editMode": 0
}o_insert_user
Ersteller
TEXT (127)
R
yes
i18n_string"insert_user"table[
"eos_order"
]drvd_selecteos_order.o_insert_userfieldset"sys_record"listCfg{
"formatter": {
"type": "user"
},
"viewMode": 0
}formCfg{
"editMode": 0
}o_update_user
Letzte Änderung durch
TEXT (127)
R
yes
i18n_string"update_user"table[
"eos_order"
]drvd_selecteos_order.o_update_userfieldset"sys_record"listCfg{
"viewMode": 0
}formCfg{
"editMode": 0
}input_translatedWählen Sie eine Kampagne aus, zu der dieser Auftrag zugeordnet werden soll.
i18n_string"ecs.ORDER.fk_o_campid"table[
"eos_order"
]drvd_selecteos_order.fk_o_campidfieldset"marketing"listCfg{
"viewMode": 0
}formCfg{
"cssLayout": "col-6",
"editMode": 0
}drvd_invoice_address
Auftrag-Rg.Adresse
TEXT
R
no
i18n_string"ecs.ORDER.drvd_invoice_address"table[
"eos_order"
]drvd_selectCONCAT(
IF(CHAR_LENGTH(eos_order.invoice_company)>0,CONCAT(eos_order.invoice_company,CHAR(13)),""),
TRIM(CONCAT(eos_order.invoice_title," ",eos_order.invoice_firstname," ",eos_order.invoice_lastname)),CHAR(13),
IF(CHAR_LENGTH(eos_order.invoice_addrextra)>0,CONCAT(eos_order.invoice_addrextra,CHAR(13)),""),
eos_order.invoice_street," ",eos_order.invoice_housenr,CHAR(13),
eos_order.invoice_country," - ",eos_order.invoice_zip," ",eos_order.invoice_town) listCfg{
"viewMode": 0
}formCfg{
"editMode": 0
}drvd_deliver_address
Auftrag-Lfg.Adresse
TEXT
R
no
i18n_string"ecs.ORDER.drvd_deliver_address"table[
"eos_order"
]drvd_selectCONCAT(
IF(CHAR_LENGTH(eos_order.deliver_company)>0,CONCAT(eos_order.deliver_company,CHAR(13)),""),
TRIM(CONCAT(eos_order.deliver_title," ",eos_order.deliver_firstname," ",eos_order.deliver_lastname)),CHAR(13),
IF(CHAR_LENGTH(eos_order.deliver_addrextra)>0,CONCAT(eos_order.deliver_addrextra,CHAR(13)),""),
eos_order.deliver_street," ",eos_order.deliver_housenr,CHAR(13),
eos_order.deliver_country," - ",eos_order.deliver_zip," ",eos_order.deliver_town) listCfg{
"viewMode": 0
}formCfg{
"editMode": 0
}o_pay_profile_xdata
Zahlungsziel-Daten
DATA
R
yes
i18n_string"ecs.ORDER.o_pay_profile_xdata"table[
"eos_order"
]drvd_selecteos_order.o_pay_profile_xdatalistCfg{
"viewMode": 0
}formCfg{
"cssLayout": "col-12",
"type": "aceeditor",
"options": {
"mode": "json"
},
"editMode": 0
}i18n_string"ecs.plugin_companyaccount.fk_o_companyaccount_subaccount_persid"table[
"eos_order"
]drvd_selecteos_order.fk_o_companyaccount_subaccount_persidfieldset"extra"listCfg{
"viewMode": 3
}formCfg{
"editMode": 0
}i18n_string"ecs.ORDER.fk_o_mrch_id"table[
"eos_order"
]drvd_selecteos_order.fk_o_mrch_idfieldset"extra"listCfg{
"viewMode": 3
}formCfg{
"editMode": 0
}i18n_string"ecs.ORDER.fk_o_parent_oid"table[
"eos_order"
]drvd_selecteos_order.fk_o_parent_oidfieldset"extra"listCfg{
"viewMode": 3
}formCfg{
"editMode": 0
}o_merchant_xdata
Anbieter (Zusatzdaten)
DATA
R
yes
i18n_string"ecs.ORDER.o_merchant_xdata"table[
"eos_order"
]drvd_selecteos_order.o_merchant_xdatafieldset"extra"listCfg{
"viewMode": 0
}formCfg{
"cssLayout": "col-12",
"type": "aceeditor",
"options": {
"mode": "json"
},
"editMode": 0
}o_periodic_time_first
Abo-Startdatum
DATETIME
R
yes
i18n_string"ecs.ORDER.o_periodic_time_first"table[
"eos_order"
]drvd_selecteos_order.o_periodic_time_firstfieldset"time_settings"listCfg{
"viewMode": 3
}formCfg{
"type": "datetimepicker",
"cssLayout": "col-12 col-md-6 col-xl-6",
"editMode": 0
}o_periodic_time_last
Abo-Enddatum
DATETIME
R
yes
i18n_string"ecs.ORDER.o_periodic_time_last"table[
"eos_order"
]drvd_selecteos_order.o_periodic_time_lastfieldset"time_settings"listCfg{
"viewMode": 3
}formCfg{
"type": "datetimepicker",
"cssLayout": "col-12 col-md-6 col-xl-6",
"editMode": 0
}o_periodic_time_next
Nächste Abo-Ausführung
DATETIME
R
yes
i18n_string"ecs.ORDER.o_periodic_time_next"table[
"eos_order"
]drvd_selecteos_order.o_periodic_time_nextfieldset"time_settings"listCfg{
"viewMode": 3
}formCfg{
"editMode": 0,
"cssLayout": "col-12 col-md-6 col-xl-6"
}o_periodic_timeorder_offset
Abweichendes Auftragsdatum
TEXT (31)
R
no
i18n_string"ecs.ORDER.o_periodic_timeorder_offset"table[
"eos_order"
]drvd_selecteos_order.o_periodic_timeorder_offsetfieldset"time_settings"listCfg{
"viewMode": 3,
"formatter": {
"type": "cron"
}
}formCfg{
"cssLayout": "col-12 col-md-6 col-xl-6",
"editMode": 0
}o_periodic_time_strict
Strikt
INT (1)
R
no
i18n_string"ecs.ORDER.o_periodic_time_strict"table[
"eos_order"
]drvd_selecteos_order.o_periodic_time_strictfieldset"time_settings"listCfg{
"viewMode": 3,
"formatter": {
"type": "active-flag"
}
}formCfg{
"type": "checkbox",
"value": 1,
"editMode": 0
}o_periodic_exec_period
Abo-Intervall
TEXT (31)
R
no
i18n_string"ecs.ORDER.o_periodic_exec_period"table[
"eos_order"
]drvd_selecteos_order.o_periodic_exec_periodfieldset"time_settings"listCfg{
"viewMode": 3,
"formatter": {
"type": "cron"
}
}formCfg{
"type": "hfycron",
"editMode": 0
}o_periodic_exec_inprogress
Wird gerade ausgeführt
INT (1)
R
no
i18n_string"ecs.ORDER.o_periodic_exec_inprogress"table[
"eos_order"
]drvd_selecteos_order.o_periodic_exec_inprogresslistCfg{
"viewMode": 3
}formCfg{
"editMode": 0
}o_periodic_xdata
DATA
R
yes
i18n_string"ecs.ORDER.o_periodic_xdata"table[
"eos_order"
]drvd_selecteos_order.o_periodic_xdatafieldset"time_settings_xdata"listCfg{
"viewMode": 0
}formCfg{
"type": "eossubform",
"hideLabel": true,
"options": {
"fieldDefinition": {
"time_paused": {
"type": "eossubformarray",
"options": {
"model": "time_paused",
"sortable": true,
"enableAdd": true,
"enableRemove": true,
"itemsMinCount": 0,
"itemsMaxCount": -1,
"fieldDefinition": {
"pause_start": {
"type": "datetimepicker",
"hideLabel": true
},
"pause_end": {
"type": "datetimepicker",
"hideLabel": true
}
},
"layoutSettings": {
"hideTabs": true,
"tabs": [
{
"label": "base",
"cssLayoutGroupDefault": "col-12",
"groups": [
{
"label": "time_paused",
"hideHeader": true,
"fdLabelLayoutDefault": "vt",
"fields": [
{
"field": "pause_start",
"cssLayout": "col-6"
},
{
"field": "pause_end",
"cssLayout": "col-6"
}
]
}
]
}
]
}
}
}
}
},
"editMode": 0
}drvd_weekday_timeordered
Wochentag
TEXT
R
no
i18n_string"ecs.ORDER.drvd_weekday_timeordered"table[
"eos_order"
]drvd_selectDATE_FORMAT(eos_order.o_time_ordered, '%a')listCfg{
"viewMode": 0
}formCfg{
"editMode": 0
}drvd_hour_timeordered
Stunde
TEXT
R
no
i18n_string"ecs.ORDER.drvd_hour_timeordered"table[
"eos_order"
]drvd_selectDATE_FORMAT(eos_order.o_time_ordered, '%H')listCfg{
"viewMode": 0
}formCfg{
"editMode": 0
}drvd_month_timeordered
Bestellmonat
TEXT
R
no
i18n_string"ecs.ORDER.drvd_month_timeordered"table[
"eos_order"
]drvd_selectDATE_FORMAT(eos_order.o_time_ordered, '%m')listCfg{
"viewMode": 0
}formCfg{
"editMode": 0
}drvd_dayofmonth_timeordered
Bestelltag im Monat
TEXT
R
no
i18n_string"ecs.ORDER.drvd_dayofmonth_timeordered"table[
"eos_order"
]drvd_selectDATE_FORMAT(eos_order.o_time_ordered, '%d')listCfg{
"viewMode": 0
}formCfg{
"editMode": 0
}drvd_timeonly_timeordered
Bestellzeit
TEXT
R
no
i18n_string"ecs.ORDER.drvd_timeonly_timeordered"table[
"eos_order"
]drvd_selectDATE_FORMAT(eos_order.o_time_ordered, '%H:%i')listCfg{
"viewMode": 0
}formCfg{
"editMode": 0
}drvd_cluster_seq
Erst-/Wiederkauf
TEXT
R
no
i18n_string"ecs.ORDER.drvd_cluster_seq"table[
"eos_order"
]drvd_selectIF(eos_order.o_pers_seq_nr > 1,"Wiederkauf","Erstkauf")listCfg{
"viewMode": 0
}formCfg{
"editMode": 0
}order_state_transtime
Transaktionszeit
DATETIME
R
no
i18n_string"ecs.ORDER.order_state_transtime"table[
"eos_statelog"
]drvd_selecteos_statelog.transtimelistCfg{
"viewMode": 0
}formCfg{
"editMode": 0
}order_state_code
Auftragsstatus (Code)
TEXT (63)
R
no
i18n_string"ecs.ORDER.order_state_code"table[
"eos_states"
]drvd_selecteos_states.st_codelistCfg{
"viewMode": 0
}formCfg{
"editMode": 0
}order_state_color
Status-Farbe
TEXT (15)
R
no
i18n_string"ecs.ORDER.order_state_color"table[
"eos_states"
]drvd_selecteos_states.st_colorlistCfg{
"viewMode": 0
}formCfg{
"editMode": 0
}order_state_name
Auftragsstatus (Name)
TEXT
R
no
i18n_string"ecs.ORDER.order_state_name"valueColorField"order_state_color"table[
"eos_states"
]drvd_selecteos_states.i18n_st_name_DElistCfg{
"formatter": {
"type": "status",
"params": {
"statusColorField": "order_state_color"
}
},
"width": 192,
"viewMode": 0
}formCfg{
"editMode": 0
}order_state_name_public
Auftragsstatus (öffentlicher Name)
TEXT
R
no
i18n_string"ecs.ORDER.order_state_name_public"valueColorField"order_state_color"table[
"eos_states"
]drvd_selecteos_states.i18n_st_name_public_DElistCfg{
"viewMode": 0,
"formatter": {
"type": "status",
"params": {
"statusColorField": "order_state_color"
}
}
}formCfg{
"editMode": 0
}