Model fields
The model consists of the following fields.
Field Name
Display Name
Type
Permissions
Nullable
deliveryitem
dviid
primary
auto increment
INT (11)
R+W
no
fieldset
"base_record"
listCfg
{
"viewMode": 0
}
formCfg
{
"type": "hidden"
}
fieldset
"base_record"
listCfg
{
"viewMode": 3
}
formCfg
{
"cssLayout": "col-6",
"mandatory": true
}
dvi_pcode
primaryDisplay
auto increment
Pcode
TEXT (255)
R+W
yes
fieldset
"base"
listCfg
{
"fullSearch": true
}
formCfg
{
"cssLayout": "col-3"
}
dvi_name
auto increment
Artikelname
TEXT
R+W
yes
fieldset
"base"
listCfg
{
"fullSearch": true
}
formCfg
{
"cssLayout": "col-6"
}
dvi_cnt
auto increment
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
}
}
dvi_insert_time
auto increment
Angelegt am
DATETIME
R+W
no
i18n_string
"insert_time"
fieldset
"sys_record"
listCfg
{
"viewMode": 0
}
formCfg
{
"editMode": 2
}
dvi_update_time
auto increment
Geändert am
DATETIME
R+W
yes
i18n_string
"update_time"
fieldset
"sys_record"
listCfg
{
"viewMode": 0
}
formCfg
{
"editMode": 2
}
dvi_xdata
auto increment
Zusatzdaten
DATA
R+W
yes
fieldset
"extra"
listCfg
{
"viewMode": 0
}
formCfg
{
"cssLayout": "col-12",
"type": "aceeditor",
"options": {
"mode": "json"
}
}
dvi_insert_user
auto increment
Ersteller
TEXT (127)
R+W
yes
i18n_string
"insert_user"
fieldset
"sys_record"
listCfg
{
"formatter": {
"type": "user"
},
"viewMode": 0
}
formCfg
{
"editMode": 2
}
dvi_update_user
auto increment
Letzte Änderung durch
TEXT (127)
R+W
yes
i18n_string
"update_user"
fieldset
"sys_record"
listCfg
{
"viewMode": 0
}
formCfg
{
"editMode": 2
}
drvd_dv_address
auto increment
Lieferadresse
TEXT
R
no
table
[
"ecs_delivery"
]
drvd_select
CONCAT(IF(CHAR_LENGTH(ecs_delivery.dv_name)>0,CONCAT(ecs_delivery.dv_name,CHAR(13)),""),
IF(CHAR_LENGTH(ecs_delivery.dv_name2)>0,CONCAT(ecs_delivery.dv_name2,CHAR(13)),""),
ecs_delivery.dv_street," ",ecs_delivery.dv_hnr,CHAR(13),
ecs_delivery.dv_country," - ",ecs_delivery.dv_zip," ",ecs_delivery.dv_city
)
formCfg
{
"editMode": 0
}
i18n_string
"ecs_plugin_ewarehouse.DELIVERYITEM.fk_dvi_item_id"
listCfg
{
"viewMode": 0,
"searchable": 0,
"sortable": 0
}
formCfg
{
"editMode": 0
}
dvi_pcode_ext
auto increment
Artikel-Nr. (extern):
TEXT
R+W
yes
i18n_string
"ecs_plugin_ewarehouse.DELIVERYITEM.dvi_pcode_ext"
listCfg
{
"viewMode": 0,
"searchable": 0,
"sortable": 0
}
dvi_rsvd_cnt
auto increment
Reservierte Artikel
FLOAT (13,4)
R+W
no
i18n_string
"ecs_plugin_ewarehouse.DELIVERYITEM.dvi_rsvd_cnt"
listCfg
{
"sumType": "SV"
}
formCfg
{
"editMode": 0
}
dvi_rsvd_confirmed_cnt
auto increment
Reserviert (bestätigt)
FLOAT (13,4)
R+W
no
i18n_string
"ecs_plugin_ewarehouse.DELIVERYITEM.dvi_rsvd_confirmed_cnt"
listCfg
{
"viewMode": 0
}
formCfg
{
"editMode": 0
}
dvi_cost_single_purchase
auto increment
Einzel-Anschaffungskosten
FLOAT (13,2)
R+W
yes
i18n_string
"ecs_plugin_ewarehouse.DELIVERYITEM.dvi_cost_single_purchase"
listCfg
{
"viewMode": 0
}
node_id
auto increment
Lagerort
INT (11)
R
no
i18n_string
"ecs_plugin_ewarehouse.STORAGEITEM.node_id"
table
[
"ewh_nstgrp_item2node",
"ewh_nstgrp_nodes"
]
drvd_select
ewh_nstgrp_nodes.node_id
listCfg
{
"viewMode": 3
}
formCfg
{
"editMode": 0
}
node_name
auto increment
Lagername
TEXT
R
no
i18n_string
"ecs_plugin_ewarehouse.STORAGE.node_name"
table
[
"ewh_nstgrp_item2node",
"ewh_nstgrp_nodes"
]
drvd_select
ewh_nstgrp_nodes.i18n_node_name_DE
listCfg
{
"viewMode": 0
}
formCfg
{
"editMode": 0
}
node_path
auto increment
Lagerpfad
TEXT
R
no
i18n_string
"ecs_plugin_ewarehouse.STORAGE.node_path"
table
[
"ewh_nstgrp_item2node",
"ewh_nstgrp_nodes"
]
drvd_select
ewh_nstgrp_nodes.i18n_node_path_DE
formCfg
{
"editMode": 0
}
drvd_dvi_cnt_not_reserved
auto increment
Nicht reserviert
FLOAT (13,4)
R
no
i18n_string
"ecs_plugin_ewarehouse.DELIVERYITEM.drvd_dvi_cnt_not_reserved"
table
"ecs_deliveryitem"
drvd_select
IF(ecs_deliveryitem.dvi_rsvd_cnt = 0 AND ecs_deliveryitem.fk_dvi_item_id > 0,0,ecs_deliveryitem.dvi_cnt - ecs_deliveryitem.dvi_rsvd_cnt)
listCfg
{
"sumType": "SV"
}
formCfg
{
"editMode": 0
}
drvd_dvi_cnt_not_reserved_confirmed
auto increment
Nicht reserviert (bestätigt)
FLOAT (13,4)
R
no
i18n_string
"ecs_plugin_ewarehouse.DELIVERYITEM.drvd_dvi_cnt_not_reserved_confirmed"
table
"ecs_deliveryitem"
drvd_select
IF(ecs_deliveryitem.dvi_rsvd_confirmed_cnt = 0 AND ecs_deliveryitem.fk_dvi_item_id > 0,0,ecs_deliveryitem.dvi_cnt - ecs_deliveryitem.dvi_rsvd_confirmed_cnt)
listCfg
{
"viewMode": 0
}
formCfg
{
"editMode": 0
}
drvd_si_available
auto increment
Verfügbarkeit
INT
R
no
i18n_string
"ecs_plugin_ewarehouse.DELIVERYITEM.drvd_si_available"
table
[
"ewh_nstgrp_item2node",
"ewh_nstgrp_nodes"
]
drvd_select
IF(ewh_nstgrp_nodes.s_available = 1 AND ewh_nstgrp_item2node.si_available = 1, 1, 0)
listCfg
{
"viewMode": 0
}
formCfg
{
"editMode": 0
}
drvd_si_time_available
auto increment
Verfügbarkeitsdatum
INT
R
no
i18n_string
"ecs_plugin_ewarehouse.DELIVERYITEM.drvd_si_time_available"
table
[
"ewh_nstgrp_item2node",
"ewh_nstgrp_nodes"
]
drvd_select
IF(ewh_nstgrp_item2node.si_time_available IS NOT NULL,ewh_nstgrp_item2node.si_time_available,ewh_nstgrp_nodes.s_time_available)
listCfg
{
"viewMode": 0
}
formCfg
{
"editMode": 0
}
si_cnt_rsvd
auto increment
Reservierte Artikel
FLOAT (13,4)
R+W
no
i18n_string
"ecs_plugin_ewarehouse.STORAGEITEM.si_cnt_rsvd"
table
"ewh_nstgrp_item2node"
listCfg
{
"viewMode": 0
}
formCfg
{
"editMode": 0
}
si_ean
auto increment
EAN/GTIN
TEXT
R+W
yes
input_translated
Die Global Trade Item Number (GTIN) ist eine vergebene Identifikationsnummer, mit der Produkte und Packstücke weltweit eindeutig identifiziert werden können. Sie ersetzt die European Article Number (EAN), die bis 2009 als Globale Artikelidentifikationsnummer diente. Es wird empfohlen im Feld (falls vorhanden) die neuere GTIN anzugeben. Alternativ kann natürlich auch die EAN genutzt werden.
i18n_string
"ecs_plugin_ewarehouse.STORAGEITEM.si_ean"
table
"ewh_nstgrp_item2node"
listCfg
{
"viewMode": 0
}
formCfg
{
"editMode": 0
}
si_upc
auto increment
UPC
TEXT
R+W
yes
input_translated
Der Universal Product Code (UPC) ist ein Strichcode, durch den Produkte im Einzelhandel gekennzeichnet werden.
i18n_string
"ecs_plugin_ewarehouse.STORAGEITEM.si_upc"
table
"ewh_nstgrp_item2node"
listCfg
{
"viewMode": 0
}
formCfg
{
"editMode": 0
}
si_snr
auto increment
Seriennummer
TEXT
R+W
yes
i18n_string
"ecs_plugin_ewarehouse.STORAGEITEM.si_snr"
table
"ewh_nstgrp_item2node"
listCfg
{
"viewMode": 0
}
formCfg
{
"editMode": 0
}
btch_number
auto increment
Chargen-Nr.
TEXT
R+W
yes
i18n_string
"ecs_plugin_ewarehouse.STRGIBATCH.btch_number"
table
[
"ewh_strgi_batch"
]
listCfg
{
"viewMode": 0
}
formCfg
{
"editMode": 0
}
si_length
auto increment
Länge (cm)
FLOAT (13,4)
R+W
yes
input_translated
Die Breite in Zentimeter (cm).
i18n_string
"ecs_plugin_ewarehouse.STORAGEITEM.si_length"
table
"ewh_nstgrp_item2node"
listCfg
{
"viewMode": 0
}
formCfg
{
"editMode": 0
}
si_width
auto increment
Tiefe (cm)
FLOAT (13,4)
R+W
yes
input_translated
Die Tiefe in Zentimeter (cm).
i18n_string
"ecs_plugin_ewarehouse.STORAGEITEM.si_width"
table
"ewh_nstgrp_item2node"
listCfg
{
"viewMode": 0
}
formCfg
{
"editMode": 0
}
si_height
auto increment
Höhe (cm)
FLOAT (13,4)
R+W
yes
input_translated
Die Höhe in Zentimeter (cm).
i18n_string
"ecs_plugin_ewarehouse.STORAGEITEM.si_height"
table
"ewh_nstgrp_item2node"
listCfg
{
"viewMode": 0
}
formCfg
{
"editMode": 0
}
si_weight
auto increment
Gewicht (kg)
FLOAT (13,4)
R+W
yes
input_translated
Das Gewicht in Kilogramm (Kg).
i18n_string
"ecs_plugin_ewarehouse.STORAGEITEM.si_weight"
table
"ewh_nstgrp_item2node"
listCfg
{
"viewMode": 0
}
formCfg
{
"editMode": 0
}
drvd_si_dimension
auto increment
Maße (cm)
TEXT
R
yes
i18n_string
"ecs_plugin_ewarehouse.STORAGEITEM.drvd_si_dimension"
table
"ewh_nstgrp_item2node"
drvd_select
CONCAT(si_length,' x ',si_width,' x ',si_height)
listCfg
{
"viewMode": 0
}
formCfg
{
"editMode": 0
}
drvd_si_volume
auto increment
Volumen
TEXT
R
yes
i18n_string
"ecs_plugin_ewarehouse.STORAGEITEM.drvd_si_volume"
table
"ewh_nstgrp_item2node"
drvd_select
IF(si_length IS NOT NULL && si_width IS NOT NULL && si_height IS NOT NULL, si_length * si_width * si_height, NULL)
listCfg
{
"viewMode": 0
}
formCfg
{
"editMode": 0
}
product
Following fields can also be selected for reading (JOIN)
pcode
auto increment
Pcode
R
no
drvd_select
dvi_pcode
listCfg
{
"viewMode": 3
}
formCfg
{
"editMode": 0
}
xc__active
auto increment
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
auto increment
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
auto increment
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
auto increment
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
auto increment
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
auto increment
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
auto increment
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
auto increment
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
auto increment
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
auto increment
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
auto increment
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
auto increment
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
auto increment
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
auto increment
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
auto increment
Titel
TEXT
R
no
i18n_string
"cdb_record.xc__title"
table
[
"excdb_data_ecs_product_de"
]
drvd_select
COALESCE(excdb_data_ecs_product_de.name,excdb_data_ecs_product_de.pcode)
listCfg
{
"viewMode": 0,
"fullSearch": false
}
formCfg
{
"editMode": 0
}
drvd_is_master
auto increment
Ist Masterprodukt
INT (1)
R
no
i18n_string
"ecs.PRODUCT.drvd_is_master"
table
[
"excdb_data_ecs_product_de"
]
drvd_select
IF(excdb_data_ecs_product_de.pcode = excdb_data_ecs_product_de.master_pcode,1,0)
fieldset
"cdb_base"
listCfg
{
"formatter": {
"type": "active-flag"
},
"viewMode": 0,
"fullSearch": false
}
formCfg
{
"editMode": 0
}
name
auto increment
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
auto increment
Varianten-Master PCode
TEXT
R
yes
input_translated
Bei Einzelprodukten (ohne Varianten) ist dies gleich dem PCode. Bei Variantenprodukten wird hier der PCode des Hauptprodukts der Variantengruppe eingetragen.
i18n_string
"ecs.PRODUCT.master_pcode"
table
[
"excdb_data_ecs_product_de"
]
fieldset
"cdb_base"
listCfg
{
"viewMode": 0,
"fullSearch": false
}
formCfg
{
"type": "text",
"options": {
"XXXobserver": {
"fields": [
{
"field": "pcode",
"trigger": "onChange",
"exec": [
{
"cmd": "copy"
}
]
}
]
}
},
"mandatory": true,
"editMode": 0
}
prdv_color
auto increment
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
auto increment
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
auto increment
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
auto increment
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
auto increment
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
auto increment
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
auto increment
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
auto increment
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
auto increment
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]
auto increment
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
auto increment
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
auto increment
Nachfolgeprodukte
DATA
R
yes
input_translated
Produkte durch Drag-and-Drop hinzufügen. Beispielsweise aus der Trefferliste der "Hublify Suche".
i18n_string
"ecs.PRODUCT.products_replace"
table
[
"excdb_data_ecs_product_de"
]
fieldset
"cdb_marketing"
listCfg
{
"formatter": {
"type": "sub-data-chip",
"params": {
"chipCssClass": "chip"
}
},
"viewMode": 0,
"fullSearch": false
}
formCfg
{
"type": "eossubmodel",
"options": {
"model": "cdb_record",
"xDataKey": "r2r_xdata",
"xDataDialogConfig": {
"layoutLabel": "submodel_product_r2r_xdata_generic_popup"
},
"dataStreamCall": {
"method": "datahub_generate_reportList",
"params": {
"ds_label": "product"
}
},
"optValueField": "xc__id",
"optNameField": "name"
},
"mandatory": false,
"editMode": 0
}
pcode_manufacturer
auto increment
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
auto increment
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
auto increment
Upselling-Produkte
DATA
R
yes
input_translated
Produkte durch Drag-and-Drop hinzufügen. Beispielsweise aus der Trefferliste der "Hublify Suche".
i18n_string
"ecs.PRODUCT.products_upselling"
table
[
"excdb_data_ecs_product_de"
]
fieldset
"cdb_marketing"
listCfg
{
"formatter": {
"type": "sub-data-chip",
"params": {
"chipCssClass": "chip"
}
},
"viewMode": 0,
"fullSearch": false
}
formCfg
{
"type": "eossubmodel",
"options": {
"model": "cdb_record",
"xDataKey": "r2r_xdata",
"xDataDialogConfig": {
"layoutLabel": "submodel_product_r2r_xdata_generic_popup"
},
"dataStreamCall": {
"method": "datahub_generate_reportList",
"params": {
"ds_label": "product"
}
},
"optValueField": "xc__id",
"optNameField": "name"
},
"mandatory": false,
"editMode": 0
}
orderitem_name
auto increment
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
auto increment
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
auto increment
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
auto increment
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
auto increment
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
auto increment
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
auto increment
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
auto increment
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
auto increment
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
auto increment
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
auto increment
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
auto increment
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
auto increment
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
auto increment
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
auto increment
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]
auto increment
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]
auto increment
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]
auto increment
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
auto increment
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
auto increment
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
auto increment
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
auto increment
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
auto increment
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
auto increment
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]
auto increment
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]
auto increment
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]
auto increment
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]
auto increment
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
auto increment
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
auto increment
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
auto increment
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
auto increment
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
auto increment
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
auto increment
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
auto increment
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
auto increment
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
auto increment
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
auto increment
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
auto increment
Bilder
DATA
R
yes
input_translated
Bilder mit Drag-and-Drop hinzufügen. Entweder aus Hublify Media-Manager oder von eigener Festplatte.
i18n_string
"ecs.PRODUCT.files_img"
table
[
"excdb_data_ecs_product_de"
]
fieldset
"cdb_base_2"
listCfg
{
"viewMode": 0,
"fullSearch": false
}
formCfg
{
"type": "eosmedia",
"options": {
"uploadDirDefault": "\/products"
},
"mandatory": false,
"editMode": 0
}
prd_bundle_price_discount_perc
[%]
auto increment
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
auto increment
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
auto increment
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
auto increment
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
auto increment
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
auto increment
TEXT
R
yes
i18n_string
"ecs.PRODUCT.xc__label"
table
[
"excdb_data_ecs_product_de"
]
drvd_select
excdb_data_ecs_product_de.pcode
fieldset
"cdb_base"
listCfg
{
"viewMode": 0,
"fullSearch": false
}
formCfg
{
"type": "HIDDEN",
"editMode": 0
}
xc__title
auto increment
TEXT
R
yes
i18n_string
"ecs.PRODUCT.xc__title"
table
[
"excdb_data_ecs_product_de"
]
drvd_select
excdb_data_ecs_product_de.name
fieldset
"cdb_base"
listCfg
{
"viewMode": 0,
"fullSearch": false
}
formCfg
{
"type": "HIDDEN",
"editMode": 0
}
xc__image
auto increment
DATA
R
yes
i18n_string
"ecs.PRODUCT.xc__image"
table
[
"excdb_data_ecs_product_de"
]
drvd_select
excdb_data_ecs_product_de.files_img
fieldset
"cdb_base_2"
listCfg
{
"viewMode": 0,
"fullSearch": false
}
formCfg
{
"type": "HIDDEN",
"editMode": 0
}
drvd_variant_specification
auto increment
Ausprägung
TEXT
R
no
i18n_string
"ecs.PRODUCT.drvd_variant_specification"
table
[
"excdb_data_ecs_product_de"
]
drvd_select
CONCAT_WS(',',excdb_data_ecs_product_de.prdv_color, excdb_data_ecs_product_de.prdv_size, excdb_data_ecs_product_de.prdv_other)
listCfg
{
"viewMode": 0,
"fullSearch": false
}
formCfg
{
"editMode": 0
}
delivery
Following fields can also be selected for reading (JOIN)
did
auto increment
INT (11)
R
no
i18n_string
"ecs.DELIVERY.did"
table
[
"ecs_delivery"
]
fieldset
"base_record"
listCfg
{
"viewMode": 0,
"fullSearch": false
}
formCfg
{
"type": "hidden",
"editMode": 0
}
dv_seller_name
auto increment
Verkäufername
TEXT
R
no
i18n_string
"ecs.DELIVERY.dv_seller_name"
table
[
"ecs_delivery"
]
fieldset
"seller_addr"
listCfg
{
"viewMode": 0,
"fullSearch": false
}
formCfg
{
"editMode": 0
}
dv_seller_name2
auto increment
Adressenzusatz
TEXT
R
no
i18n_string
"ecs.DELIVERY.dv_seller_name2"
table
[
"ecs_delivery"
]
fieldset
"seller_addr"
listCfg
{
"viewMode": 0,
"fullSearch": false
}
formCfg
{
"editMode": 0
}
dv_seller_street
auto increment
Straße
TEXT
R
no
i18n_string
"ecs.DELIVERY.dv_seller_street"
table
[
"ecs_delivery"
]
fieldset
"seller_addr"
listCfg
{
"viewMode": 0,
"fullSearch": false
}
formCfg
{
"cssLayout": "col-9",
"editMode": 0
}
dv_seller_hnr
auto increment
Hausnr.
TEXT
R
no
i18n_string
"ecs.DELIVERY.dv_seller_hnr"
table
[
"ecs_delivery"
]
fieldset
"seller_addr"
listCfg
{
"viewMode": 0,
"fullSearch": false
}
formCfg
{
"cssLayout": "col-3",
"editMode": 0
}
dv_seller_zip
auto increment
PLZ
TEXT
R
no
i18n_string
"ecs.DELIVERY.dv_seller_zip"
table
[
"ecs_delivery"
]
fieldset
"seller_addr"
listCfg
{
"viewMode": 0,
"fullSearch": false
}
formCfg
{
"cssLayout": "col-4",
"editMode": 0
}
dv_seller_city
auto increment
Ort
TEXT
R
no
i18n_string
"ecs.DELIVERY.dv_seller_city"
table
[
"ecs_delivery"
]
fieldset
"seller_addr"
listCfg
{
"viewMode": 0,
"fullSearch": false
}
formCfg
{
"cssLayout": "col-8",
"editMode": 0
}
dv_seller_state_code
auto increment
Bundesland (Code) (Verkäufer)
TEXT (15)
R
yes
i18n_string
"ecs.DELIVERY.dv_seller_state_code"
table
[
"ecs_delivery"
]
fieldset
"seller_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": "dv_seller_country",
"trigger": "onInit",
"exec": [
{
"cmd": "loadOptions",
"params": {
"dataStreamCall": {
"method": "state_getlist",
"params": {
"filter": {
"state_country": "{%FIELD.value%}"
}
}
}
}
}
]
},
{
"field": "dv_seller_country",
"trigger": "onChange",
"exec": [
{
"cmd": "loadOptions",
"params": {
"dataStreamCall": {
"method": "state_getlist",
"params": {
"filter": {
"state_country": "{%FIELD.value%}"
}
}
}
}
}
]
}
]
}
},
"editMode": 0
}
i18n_string
"ecs.DELIVERY.dv_seller_country"
table
[
"ecs_delivery"
]
fieldset
"seller_addr"
listCfg
{
"viewMode": 0,
"width": 64,
"formatter": {
"type": "country-flag"
},
"fullSearch": false
}
formCfg
{
"cssLayout": "col-6",
"editMode": 0
}
dv_code
auto increment
Lieferungs-Nr.
TEXT (63)
R
no
i18n_string
"ecs.DELIVERY.dv_code"
table
[
"ecs_delivery"
]
fieldset
"base_record"
listCfg
{
"fullSearch": false,
"formatter": {
"type": "model-primary",
"params": {
"model": "delivery",
"primaryKey": "did",
"statusColorField": "delivery_state_color",
"subTitleTemplate": "{%dv_name%} {%dv_name2%}"
}
},
"viewMode": 1,
"depends_on": "fk_dvi_did"
}
formCfg
{
"cssLayout": "col-12 col-md-6 col-xl-3",
"editMode": 0
}
dv_extcode
auto increment
Sendungsnr.
TEXT (63)
R
no
i18n_string
"ecs.DELIVERY.dv_extcode"
table
[
"ecs_delivery"
]
fieldset
"base"
listCfg
{
"viewMode": 0,
"fullSearch": false
}
formCfg
{
"cssLayout": "col-6",
"editMode": 0
}
i18n_string
"ecs.DELIVERY.fk_dv_persid"
table
[
"ecs_delivery"
]
fieldset
"base_record"
listCfg
{
"viewMode": 0,
"fullSearch": false
}
formCfg
{
"cssLayout": "col-12 col-md-6 col-xl-3",
"editMode": 0
}
i18n_string
"ecs.DELIVERY.fk_dv_oid"
table
[
"ecs_delivery"
]
fieldset
"base_record"
listCfg
{
"viewMode": 0,
"fullSearch": false
}
formCfg
{
"cssLayout": "col-12 col-md-6 col-xl-3",
"editMode": 0
}
i18n_string
"ecs.DELIVERY.fk_dv_st_id"
table
[
"ecs_delivery"
]
fieldset
"base_record"
listCfg
{
"viewMode": 3,
"fullSearch": false
}
formCfg
{
"cssLayout": "col-12 col-md-6 col-xl-3",
"editMode": 0
}
dv_time_insert
auto increment
Angelegt am
DATETIME
R
no
i18n_string
"insert_time"
table
[
"ecs_delivery"
]
fieldset
"sys_record"
listCfg
{
"viewMode": 0,
"fullSearch": false
}
formCfg
{
"editMode": 0
}
dv_time_update
auto increment
Geändert am
DATETIME
R
yes
i18n_string
"update_time"
table
[
"ecs_delivery"
]
fieldset
"sys_record"
listCfg
{
"viewMode": 0,
"fullSearch": false
}
formCfg
{
"editMode": 0
}
dv_user_insert
auto increment
Ersteller
TEXT (127)
R
yes
i18n_string
"insert_user"
table
[
"ecs_delivery"
]
fieldset
"sys_record"
listCfg
{
"formatter": {
"type": "user"
},
"viewMode": 0,
"fullSearch": false
}
formCfg
{
"editMode": 0
}
dv_user_update
auto increment
Letzte Änderung durch
TEXT (127)
R
yes
i18n_string
"update_user"
table
[
"ecs_delivery"
]
fieldset
"sys_record"
listCfg
{
"viewMode": 0,
"fullSearch": false
}
formCfg
{
"editMode": 0
}
dv_time_sent
auto increment
Versendet am
DATETIME
R
yes
i18n_string
"ecs.DELIVERY.dv_time_sent"
table
[
"ecs_delivery"
]
fieldset
"extra"
listCfg
{
"viewMode": 0,
"fullSearch": false
}
formCfg
{
"type": "datepicker",
"editMode": 0
}
dv_comment
auto increment
Kommentar
TEXT
R
no
i18n_string
"ecs.DELIVERY.dv_comment"
table
[
"ecs_delivery"
]
fieldset
"extra"
listCfg
{
"viewMode": 0,
"fullSearch": false
}
formCfg
{
"type": "textarea",
"editMode": 0
}
dv_comment_internal
auto increment
Interner Kommentar
TEXT
R
yes
i18n_string
"ecs.DELIVERY.dv_comment_internal"
table
[
"ecs_delivery"
]
fieldset
"extra"
listCfg
{
"viewMode": 0,
"fullSearch": false
}
formCfg
{
"type": "textarea",
"editMode": 0
}
dv_name
auto increment
Name
TEXT
R
no
i18n_string
"ecs.DELIVERY.dv_name"
table
[
"ecs_delivery"
]
fieldset
"dlv_addr"
listCfg
{
"viewMode": 0,
"fullSearch": false
}
formCfg
{
"editMode": 0
}
dv_company
auto increment
Firma
TEXT
R
no
i18n_string
"ecs.DELIVERY.dv_company"
table
[
"ecs_delivery"
]
fieldset
"dlv_addr"
listCfg
{
"fullSearch": false,
"viewMode": 0
}
formCfg
{
"cssLayout": "col-6",
"editMode": 0
}
dv_name2
auto increment
Adressenzusatz
TEXT
R
no
i18n_string
"ecs.DELIVERY.dv_name2"
table
[
"ecs_delivery"
]
fieldset
"dlv_addr"
listCfg
{
"viewMode": 0,
"fullSearch": false
}
formCfg
{
"cssLayout": "col-6",
"editMode": 0
}
dv_street
auto increment
Straße
TEXT
R
no
i18n_string
"ecs.DELIVERY.dv_street"
table
[
"ecs_delivery"
]
fieldset
"dlv_addr"
listCfg
{
"viewMode": 0,
"fullSearch": false
}
formCfg
{
"cssLayout": "col-9",
"editMode": 0
}
dv_hnr
auto increment
Hausnr.
TEXT
R
no
i18n_string
"ecs.DELIVERY.dv_hnr"
table
[
"ecs_delivery"
]
fieldset
"dlv_addr"
listCfg
{
"viewMode": 0,
"fullSearch": false
}
formCfg
{
"cssLayout": "col-3",
"editMode": 0
}
dv_zip
auto increment
PLZ
TEXT
R
no
i18n_string
"ecs.DELIVERY.dv_zip"
table
[
"ecs_delivery"
]
fieldset
"dlv_addr"
listCfg
{
"viewMode": 0,
"fullSearch": false
}
formCfg
{
"cssLayout": "col-4",
"editMode": 0
}
dv_city
auto increment
Ort
TEXT
R
no
i18n_string
"ecs.DELIVERY.dv_city"
table
[
"ecs_delivery"
]
fieldset
"dlv_addr"
listCfg
{
"fullSearch": false,
"viewMode": 0
}
formCfg
{
"cssLayout": "col-8",
"editMode": 0
}
dv_state_code
auto increment
Bundesland (Code)
TEXT (15)
R
yes
i18n_string
"ecs.DELIVERY.dv_state_code"
table
[
"ecs_delivery"
]
fieldset
"dlv_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": "dv_country",
"trigger": "onInit",
"exec": [
{
"cmd": "loadOptions",
"params": {
"dataStreamCall": {
"method": "state_getlist",
"params": {
"filter": {
"state_country": "{%FIELD.value%}"
}
}
}
}
}
]
},
{
"field": "dv_country",
"trigger": "onChange",
"exec": [
{
"cmd": "loadOptions",
"params": {
"dataStreamCall": {
"method": "state_getlist",
"params": {
"filter": {
"state_country": "{%FIELD.value%}"
}
}
}
}
}
]
}
]
}
},
"editMode": 0
}
i18n_string
"ecs.DELIVERY.dv_country"
table
[
"ecs_delivery"
]
fieldset
"dlv_addr"
listCfg
{
"viewMode": 0,
"width": 64,
"formatter": {
"type": "country-flag"
},
"fullSearch": false
}
formCfg
{
"cssLayout": "col-6",
"editMode": 0
}
dv_phone
auto increment
Telefon
TEXT
R
no
i18n_string
"ecs.DELIVERY.dv_phone"
table
[
"ecs_delivery"
]
fieldset
"dlv_addr"
listCfg
{
"viewMode": 0,
"fullSearch": false
}
formCfg
{
"editMode": 0
}
drvd_dv_seller_street_hnr
auto increment
Straße+Nr (Verkäufer)
TEXT
R
no
i18n_string
"ecs.DELIVERY.drvd_dv_seller_street_hnr"
table
[
"ecs_delivery"
]
drvd_select
CONCAT_WS("",ecs_delivery.dv_seller_street," ",ecs_delivery.dv_seller_hnr)
listCfg
{
"viewMode": 0,
"fullSearch": false
}
formCfg
{
"editMode": 0
}
drvd_dv_street_hnr
auto increment
Straße+Nr (L)
TEXT
R
no
i18n_string
"ecs.DELIVERY.drvd_dv_street_hnr"
table
[
"ecs_delivery"
]
drvd_select
CONCAT_WS("",ecs_delivery.dv_street," ",ecs_delivery.dv_hnr)
listCfg
{
"viewMode": 0,
"fullSearch": false
}
formCfg
{
"editMode": 0
}
delivery_state_color
auto increment
TEXT (15)
R
no
i18n_string
"ecs.DELIVERY.delivery_state_color"
table
[
"eos_states"
]
drvd_select
eos_states.st_color
listCfg
{
"viewMode": 0,
"fullSearch": false
}
formCfg
{
"editMode": 0
}
item_id
auto increment
INT
R
no
i18n_string
"ecs.DELIVERY.item_id"
table
[
"ecs_delivery"
]
drvd_select
ecs_delivery.did
listCfg
{
"viewMode": 3,
"fullSearch": false
}
formCfg
{
"editMode": 0
}
i18n_st_name
auto increment
Statusname
TEXT
R
no
i18n_string
"st_name"
table
[
"eos_states"
]
drvd_select
eos_states.i18n_st_name_DE
listCfg
{
"viewMode": 0,
"formatter": {
"type": "status",
"params": {
"statusColorField": "delivery_state_color"
}
},
"fullSearch": false
}
formCfg
{
"editMode": 0
}
i18n_st_name_public
auto increment
Öffentlicher Statusname
TEXT
R
no
i18n_string
"st_name_public"
table
[
"eos_states"
]
drvd_select
eos_states.i18n_st_name_public_DE
listCfg
{
"viewMode": 0,
"formatter": {
"type": "status",
"params": {
"statusColorField": "delivery_state_color"
}
},
"fullSearch": false
}
formCfg
{
"editMode": 0
}
st_x_dv_sent
auto increment
INT (4)
R
no
i18n_string
"ecs.DELIVERY.st_x_dv_sent"
table
[
"eos_states"
]
drvd_select
eos_states.st_x_dv_sent
listCfg
{
"viewMode": 3,
"fullSearch": false
}
formCfg
{
"editMode": 0
}
st_code
auto increment
Status
TEXT
R
no
i18n_string
"ecs.DELIVERY.st_code"
table
[
"eos_states"
]
drvd_select
eos_states.st_code
listCfg
{
"viewMode": 3,
"fullSearch": false
}
formCfg
{
"editMode": 0
}
st_position
auto increment
INT
R
no
i18n_string
"ecs.DELIVERY.st_position"
table
[
"eos_states"
]
drvd_select
eos_states.st_position
listCfg
{
"viewMode": 3,
"fullSearch": false
}
formCfg
{
"editMode": 0
}
is_current
auto increment
INT (1)
R
no
i18n_string
"ecs.DELIVERY.is_current"
table
[
"eos_statelog"
]
drvd_select
eos_statelog.is_current
listCfg
{
"viewMode": 3,
"fullSearch": false
}
formCfg
{
"editMode": 0
}
transtime
auto increment
DATETIME
R
no
i18n_string
"ecs.DELIVERY.transtime"
table
[
"eos_statelog"
]
drvd_select
eos_statelog.transtime
listCfg
{
"viewMode": 0,
"fullSearch": false
}
formCfg
{
"editMode": 0
}
i18n_string
"ecs_plugin_ewarehouse.DELIVERY.ps_name"
table
"ecs_delivery"
drvd_select
ecs_delivery.fk_dv_psid
listCfg
{
"viewMode": 0,
"fullSearch": false
}
formCfg
{
"editMode": 0
}
i18n_string
"ecs_plugin_ewarehouse.DELIVERY.fk_dv_dgrp_id"
table
"ecs_delivery"
drvd_select
ecs_delivery.fk_dv_dgrp_id
listCfg
{
"viewMode": 0,
"fullSearch": false
}
formCfg
{
"editMode": 0
}
dv_cost_total_ship
auto increment
Versandkosten
FLOAT (13,2)
R
yes
i18n_string
"ecs_plugin_ewarehouse.DELIVERY.dv_cost_total_ship"
table
[
"ecs_delivery"
]
listCfg
{
"viewMode": 0,
"fullSearch": false
}
formCfg
{
"editMode": 0
}
dv_cost_total_purchase
auto increment
Artikel-Einkaufskosten
FLOAT (13,2)
R
yes
i18n_string
"ecs_plugin_ewarehouse.DELIVERY.dv_cost_total_purchase"
table
[
"ecs_delivery"
]
listCfg
{
"viewMode": 0,
"fullSearch": false
}
formCfg
{
"editMode": 0
}
dv_time_rsvd
auto increment
Reserviert am
DATETIME
R
yes
i18n_string
"ecs_plugin_ewarehouse.DELIVERY.dv_time_rsvd"
table
[
"ecs_delivery"
]
listCfg
{
"viewMode": 0,
"fullSearch": false
}
formCfg
{
"editMode": 0
}
dv_time_transfer
auto increment
Transferiert am
DATETIME
R
yes
i18n_string
"ecs_plugin_ewarehouse.DELIVERY.dv_time_transfer"
table
[
"ecs_delivery"
]
listCfg
{
"viewMode": 0,
"fullSearch": false
}
formCfg
{
"editMode": 0
}
dv_time_planned_send
auto increment
Geplante Sendezeit
DATETIME
R
yes
i18n_string
"ecs_plugin_ewarehouse.DELIVERY.dv_time_planned_send"
table
[
"ecs_delivery"
]
listCfg
{
"viewMode": 0,
"fullSearch": false
}
formCfg
{
"editMode": 0
}
i18n_string
"ecs.DELIVERY.fk_dv_shp_c_id"
table
[
"ecs_delivery"
]
fieldset
"base"
listCfg
{
"viewMode": 0,
"fullSearch": false
}
formCfg
{
"cssLayout": "col-6",
"editMode": 0
}
dv_carrier_time_pickedup
auto increment
Abgeholt am (laut Logistiker)
DATETIME
R
yes
i18n_string
"ecs.DELIVERY.dv_carrier_time_pickedup"
table
[
"ecs_delivery"
]
fieldset
"base"
listCfg
{
"viewMode": 0,
"fullSearch": false
}
formCfg
{
"cssLayout": "col-3",
"editMode": 0
}
dv_carrier_time_delivered
auto increment
Geliefert am (laut Logistiker)
DATETIME
R
yes
i18n_string
"ecs.DELIVERY.dv_carrier_time_delivered"
table
[
"ecs_delivery"
]
fieldset
"base"
listCfg
{
"viewMode": 0,
"fullSearch": false
}
formCfg
{
"cssLayout": "col-3",
"editMode": 0
}
dv_carrier_status
auto increment
Logistiker-Sendungsstatus
TEXT
R
yes
i18n_string
"ecs.DELIVERY.dv_carrier_status"
table
[
"ecs_delivery"
]
fieldset
"base"
listCfg
{
"viewMode": 0,
"fullSearch": false
}
formCfg
{
"cssLayout": "col-6",
"editMode": 0
}
dv_carrier_id
auto increment
Logistiker externe ID
TEXT (63)
R
yes
i18n_string
"ecs.DELIVERY.dv_carrier_id"
table
[
"ecs_delivery"
]
listCfg
{
"viewMode": 0,
"fullSearch": false
}
formCfg
{
"editMode": 0
}
dv_shipping_details
auto increment
Detail-Daten
DATA
R
yes
i18n_string
"ecs.DELIVERY.dv_shipping_details"
table
[
"ecs_delivery"
]
fieldset
"extra"
listCfg
{
"viewMode": 0,
"fullSearch": false
}
formCfg
{
"cssLayout": "col-12",
"type": "aceeditor",
"options": {
"mode": "json"
},
"editMode": 0
}
drvd_shipping_label_url
auto increment
Versandlabel
TEXT
R
no
i18n_string
"ecs.DELIVERY.drvd_shipping_label_url"
table
[
"ecs_delivery"
]
drvd_select
JSON_UNQUOTE(json_extract(ecs_delivery.dv_shipping_details,'$.label_url'))
listCfg
{
"viewMode": 0,
"formatter": {
"type": "url",
"params": {
"text": "Versandlabel",
"iconLabel": "hublify\/link-external"
}
},
"fullSearch": false
}
formCfg
{
"editMode": 0
}
drvd_customs_declaration_url
auto increment
Zollerklärung
TEXT
R
no
i18n_string
"ecs.DELIVERY.drvd_customs_declaration_url"
table
[
"ecs_delivery"
]
drvd_select
JSON_UNQUOTE(json_extract(ecs_delivery.dv_shipping_details,'$.customs_declaration.carrier_declaration_document_url'))
listCfg
{
"viewMode": 0,
"formatter": {
"type": "url",
"params": {
"text": "Zollerkl\u00e4rung",
"iconLabel": "hublify\/link-external"
}
},
"fullSearch": false
}
formCfg
{
"editMode": 0
}
drvd_dv_state_name
auto increment
Bundesland (Name)
TEXT
R
no
i18n_string
"ecs.DELIVERY.drvd_dv_state_name"
table
[
"dv_terr_state"
]
drvd_select
dv_terr_state.terr_name
listCfg
{
"viewMode": 0,
"fullSearch": false
}
formCfg
{
"editMode": 0
}
drvd_dv_state_path
auto increment
Bundesland (Pfad)
TEXT
R
no
i18n_string
"ecs.DELIVERY.drvd_dv_state_path"
table
[
"dv_terr_state"
]
drvd_select
dv_terr_state.i18n_node_path_DE
listCfg
{
"viewMode": 0,
"fullSearch": false
}
formCfg
{
"editMode": 0
}
drvd_dv_seller_state_name
auto increment
Bundesland (Name) (Verkäufer)
TEXT
R
no
i18n_string
"ecs.DELIVERY.drvd_dv_seller_state_name"
table
[
"dv_seller_terr_state"
]
drvd_select
dv_seller_terr_state.terr_name
listCfg
{
"viewMode": 0,
"fullSearch": false
}
formCfg
{
"editMode": 0
}
drvd_dv_seller_state_path
auto increment
Bundesland (Pfad) (Verkäufer)
TEXT
R
no
i18n_string
"ecs.DELIVERY.drvd_dv_seller_state_path"
table
[
"dv_seller_terr_state"
]
drvd_select
dv_seller_terr_state.i18n_node_path_DE
listCfg
{
"viewMode": 0,
"fullSearch": false
}
formCfg
{
"editMode": 0
}
order
Following fields can also be selected for reading (JOIN)
oid
auto increment
OID
INT (11)
R
no
i18n_string
"ecs.ORDER.oid"
table
[
"eos_order"
]
drvd_select
eos_order.oid
fieldset
"base_record"
listCfg
{
"viewMode": 0,
"fullSearch": false
}
formCfg
{
"type": "hidden",
"editMode": 0
}
input_translated
Wählen Sie den Shop aus, zu dem dieser Auftrag gehört.
i18n_string
"ecs.ORDER.fk_o_shopid"
table
[
"eos_order"
]
drvd_select
eos_order.fk_o_shopid
fieldset
"marketing"
listCfg
{
"viewMode": 0,
"fullSearch": false
}
formCfg
{
"editMode": 0
}
orderid
auto increment
Auftrags-Nr.
TEXT (63)
R
no
i18n_string
"ecs.ORDER.orderid"
table
[
"eos_order"
]
drvd_select
eos_order.orderid
fieldset
"base_record"
listCfg
{
"fullSearch": false,
"formatter": {
"type": "model-primary",
"params": {
"model": "order",
"primaryKey": "oid",
"statusColorField": "order_state_color",
"subTitleTemplate": "{%invoice_firstname%} {%invoice_lastname%}"
}
},
"viewMode": 0,
"depends_on": "fk_dv_oid"
}
formCfg
{
"cssLayout": "col-12 col-md-6 col-xl-3",
"editMode": 0
}
input_translated
Geben Sie die Kunden-ID eines Kunden ein.
i18n_string
"ecs.ORDER.fk_o_persid"
table
[
"eos_order"
]
drvd_select
eos_order.fk_o_persid
fieldset
"base_record"
listCfg
{
"viewMode": 0,
"fullSearch": false
}
formCfg
{
"cssLayout": "col-12 col-md-6 col-xl-3",
"mandatory": true,
"editMode": 0
}
o_time_ordered
auto increment
Bestelldatum
DATETIME
R
yes
i18n_string
"ecs.ORDER.o_time_ordered"
table
[
"eos_order"
]
drvd_select
eos_order.o_time_ordered
fieldset
"base_record"
listCfg
{
"formatter": {
"type": "date"
},
"viewMode": 0,
"fullSearch": false
}
formCfg
{
"cssLayout": "col-12 col-md-6 col-xl-3",
"editMode": 0
}
total_netto
[EUR]
auto increment
∑ Gesamt, Netto
FLOAT (13,2)
R
no
i18n_string
"ecs.ORDER.total_netto"
table
[
"eos_order"
]
drvd_select
eos_order.total_netto
listCfg
{
"formatter": {
"type": "currency"
},
"viewMode": 0,
"sumType": "SV",
"fullSearch": false
}
formCfg
{
"editMode": 0
}
total_brutto
[EUR]
auto increment
∑ Gesamt, Brutto
FLOAT (13,2)
R
no
i18n_string
"ecs.ORDER.total_brutto"
table
[
"eos_order"
]
drvd_select
eos_order.total_brutto
listCfg
{
"formatter": {
"type": "currency"
},
"sumType": "SV",
"viewMode": 0,
"fullSearch": false
}
formCfg
{
"editMode": 0
}
o_orderid_external
auto increment
Externe Auftrags-Nr.
TEXT (255)
R
yes
input_translated
Geben Sie hier ggf. eine externe erhaltene Auftragsnummer ein. Diese bekommen Sie z.B. wenn der Auftrag über einen externen Marktplatz (z.B. Amazon Marketplace) erstellt wurde.
i18n_string
"ecs.ORDER.o_orderid_external"
table
[
"eos_order"
]
drvd_select
eos_order.o_orderid_external
fieldset
"base"
listCfg
{
"viewMode": 0,
"fullSearch": false
}
formCfg
{
"cssLayout": "col-12 col-md-6 col-xl-3",
"editMode": 0
}
i18n_string
"ecs.ORDER.fk_o_posid"
table
[
"eos_order"
]
drvd_select
eos_order.fk_o_posid
fieldset
"base"
listCfg
{
"viewMode": 0,
"fullSearch": false
}
formCfg
{
"cssLayout": "col-12 col-md-6 col-xl-3",
"editMode": 0
}
i18n_string
"ecs.ORDER.fk_o_stid"
table
[
"eos_order"
]
drvd_select
eos_order.fk_o_stid
fieldset
"base"
listCfg
{
"viewMode": 3,
"fullSearch": false
}
formCfg
{
"cssLayout": "col-12 col-md-6 col-xl-3",
"editMode": 0
}
i18n_string
"ecs.ORDER.fk_o_st_id"
table
[
"eos_order"
]
drvd_select
eos_order.fk_o_st_id
fieldset
"base"
listCfg
{
"viewMode": 3,
"fullSearch": false
}
formCfg
{
"cssLayout": "col-12 col-md-6 col-xl-3",
"editMode": 0
}
o_pers_reftext
auto increment
Kunden-Referenztext
TEXT
R
yes
input_translated
Geben Sie einen Referenztext des Kunden ein.
i18n_string
"ecs.ORDER.o_pers_reftext"
table
[
"eos_order"
]
drvd_select
eos_order.o_pers_reftext
listCfg
{
"viewMode": 0,
"fullSearch": false
}
formCfg
{
"editMode": 0
}
o_pers_seq_nr
auto increment
Auftrags-Sequenz-Nr.
INT (11)
R
no
i18n_string
"ecs.ORDER.o_pers_seq_nr"
table
[
"eos_order"
]
drvd_select
eos_order.o_pers_seq_nr
listCfg
{
"viewMode": 0,
"fullSearch": false
}
formCfg
{
"editMode": 0
}
quantity
auto increment
Bestellmenge
FLOAT (13,4)
R
no
i18n_string
"ecs.ORDER.quantity"
table
[
"eos_order"
]
drvd_select
eos_order.quantity
listCfg
{
"viewMode": 0,
"sumType": "SV",
"fullSearch": false
}
formCfg
{
"editMode": 0
}
drvd_total_vat
[EUR]
auto increment
MwSt. (Gesamt)
FLOAT (13,2)
R
no
i18n_string
"ecs.ORDER.drvd_total_vat"
table
[
"eos_order"
]
drvd_select
ROUND(eos_order.total_brutto - eos_order.total_netto, 2)
listCfg
{
"formatter": {
"type": "currency"
},
"viewMode": 0,
"sumType": "SV",
"fullSearch": false
}
formCfg
{
"editMode": 0
}
currency
auto increment
Währung
TEXT (3)
R
no
i18n_string
"ecs.ORDER.currency"
table
[
"eos_order"
]
drvd_select
eos_order.currency
listCfg
{
"viewMode": 0,
"fullSearch": false
}
formCfg
{
"editMode": 0
}
otitle
auto increment
Auftragstitel
TEXT
R
yes
input_translated
Geben Sie dem Auftrag einen Titel.
i18n_string
"ecs.ORDER.otitle"
table
[
"eos_order"
]
drvd_select
eos_order.otitle
fieldset
"doc_header"
listCfg
{
"viewMode": 0,
"fullSearch": false
}
formCfg
{
"cssLayout": "col-12",
"editMode": 0
}
otext
auto increment
Auftragsbeschreibung
TEXT
R
yes
i18n_string
"ecs.ORDER.otext"
table
[
"eos_order"
]
drvd_select
eos_order.otext
fieldset
"extra"
listCfg
{
"viewMode": 0,
"fullSearch": false
}
formCfg
{
"type": "textarea",
"editMode": 0
}
o_type
auto increment
Auftragstyp
TEXT (15)
R
yes
enum
[
"order",
"offer"
]
i18n_string
"ecs.ORDER.o_type"
table
[
"eos_order"
]
drvd_select
eos_order.o_type
fieldset
"base_record"
listCfg
{
"viewMode": 0,
"fullSearch": false
}
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
auto increment
Gültig bis
DATETIME
R
yes
i18n_string
"ecs.ORDER.o_valid_until"
table
[
"eos_order"
]
drvd_select
eos_order.o_valid_until
listCfg
{
"viewMode": 0,
"formatter": {
"type": "date"
},
"fullSearch": false
}
formCfg
{
"type": "datetimepicker",
"editMode": 0
}
o_txt_header
auto increment
Kopf-Text
TEXT
R
yes
input_translated
Kopf-Text für die Verwendung in PDFs
i18n_string
"ecs.ORDER.o_txt_header"
table
[
"eos_order"
]
drvd_select
eos_order.o_txt_header
fieldset
"doc_header"
listCfg
{
"viewMode": 0,
"fullSearch": false
}
formCfg
{
"fieldSetCol": "12",
"type": "eoseditor",
"editMode": 0
}
invoice_addr_preset
auto increment
Adressbuch (R)
TEXT
R
yes
i18n_string
"ecs.ORDER.invoice_addr_preset"
table
[
"eos_order"
]
drvd_select
NULL
fieldset
"inv_addr"
listCfg
{
"viewMode": 3,
"fullSearch": false
}
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
auto increment
Anrede (R)
TEXT
R
yes
enum
[
"female",
"male",
"company",
"divers"
]
i18n_string
"ecs.ORDER.invoice_gender"
table
[
"eos_order"
]
drvd_select
eos_order.invoice_gender
fieldset
"inv_addr"
listCfg
{
"viewMode": 0,
"fullSearch": false
}
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
auto increment
Titel (R)
TEXT
R
no
i18n_string
"ecs.ORDER.invoice_title"
table
[
"eos_order"
]
drvd_select
eos_order.invoice_title
fieldset
"inv_addr"
listCfg
{
"viewMode": 0,
"fullSearch": false
}
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
auto increment
Vorname (R)
TEXT
R
no
i18n_string
"ecs.ORDER.invoice_firstname"
table
[
"eos_order"
]
drvd_select
eos_order.invoice_firstname
fieldset
"inv_addr"
listCfg
{
"viewMode": 0,
"fullSearch": false
}
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
auto increment
Nachname (R)
TEXT
R
no
i18n_string
"ecs.ORDER.invoice_lastname"
table
[
"eos_order"
]
drvd_select
eos_order.invoice_lastname
fieldset
"inv_addr"
listCfg
{
"fullSearch": false,
"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
auto increment
Firma (R)
TEXT
R
no
i18n_string
"ecs.ORDER.invoice_company"
table
[
"eos_order"
]
drvd_select
eos_order.invoice_company
fieldset
"inv_addr"
listCfg
{
"fullSearch": false,
"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
auto increment
Adressenzusatz
TEXT
R
no
i18n_string
"ecs.ORDER.invoice_addrextra"
table
[
"eos_order"
]
drvd_select
eos_order.invoice_addrextra
fieldset
"inv_addr"
listCfg
{
"viewMode": 0,
"fullSearch": false
}
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
auto increment
Straße (R)
TEXT
R
no
i18n_string
"ecs.ORDER.invoice_street"
table
[
"eos_order"
]
drvd_select
eos_order.invoice_street
fieldset
"inv_addr"
listCfg
{
"viewMode": 0,
"fullSearch": false
}
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
auto increment
Hausnummer (R)
TEXT
R
no
i18n_string
"ecs.ORDER.invoice_housenr"
table
[
"eos_order"
]
drvd_select
eos_order.invoice_housenr
fieldset
"inv_addr"
listCfg
{
"viewMode": 0,
"fullSearch": false
}
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
auto increment
PLZ (R)
TEXT
R
no
i18n_string
"ecs.ORDER.invoice_zip"
table
[
"eos_order"
]
drvd_select
eos_order.invoice_zip
fieldset
"inv_addr"
listCfg
{
"viewMode": 0,
"fullSearch": false
}
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
auto increment
Ort (R)
TEXT
R
no
i18n_string
"ecs.ORDER.invoice_town"
table
[
"eos_order"
]
drvd_select
eos_order.invoice_town
fieldset
"inv_addr"
listCfg
{
"fullSearch": false,
"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
auto increment
Bundesland (Code) (R)
TEXT (15)
R
yes
i18n_string
"ecs.ORDER.invoice_state_code"
table
[
"eos_order"
]
drvd_select
eos_order.invoice_state_code
fieldset
"inv_addr"
listCfg
{
"viewMode": 0,
"fullSearch": false
}
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_select
eos_order.invoice_country
fieldset
"inv_addr"
listCfg
{
"viewMode": 0,
"formatter": {
"type": "country-flag"
},
"fullSearch": false
}
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
auto increment
Rechnungsart
TEXT
R
yes
enum
[
"noncommercial",
"commercial"
]
i18n_string
"ecs.ORDER.invoice_type"
table
[
"eos_order"
]
drvd_select
eos_order.invoice_type
fieldset
"inv_extra"
listCfg
{
"viewMode": 0,
"fullSearch": false
}
formCfg
{
"cssLayout": "col-4",
"type": "eosdropdown",
"options": {
"optI18nValuePrefix": "ecs.invoice_type",
"optI18nName": true,
"data": {
"options": [
{
"value": "noncommercial"
},
{
"value": "commercial"
}
]
}
},
"editMode": 0
}
invoice_email
auto increment
E-Mail (R)
TEXT
R
no
i18n_string
"ecs.ORDER.invoice_email"
table
[
"eos_order"
]
drvd_select
eos_order.invoice_email
fieldset
"inv_extra"
listCfg
{
"viewMode": 0,
"fullSearch": false
}
formCfg
{
"cssLayout": "col-4",
"editMode": 0
}
invoice_taxidentnumber
auto increment
USt.ID-Nr.
TEXT
R
no
i18n_string
"ecs.ORDER.invoice_taxidentnumber"
table
[
"eos_order"
]
drvd_select
eos_order.invoice_taxidentnumber
fieldset
"inv_extra"
listCfg
{
"viewMode": 0,
"fullSearch": false
}
formCfg
{
"cssLayout": "col-4",
"editMode": 0
}
invoice_taxident_status
auto increment
USt.ID-Nr. Status
TEXT
R
yes
enum
[
"invalid",
"valid_conditional",
"valid_confirmed"
]
i18n_string
"ecs.ORDER.invoice_taxident_status"
table
[
"eos_order"
]
drvd_select
eos_order.invoice_taxident_status
fieldset
"inv_extra"
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
}
invoice_third_country_export
auto increment
Ausfuhrbescheinigung
TEXT
R
yes
enum
[
"none",
"certificate_promised",
"certificate_received"
]
i18n_string
"ecs.ORDER.invoice_third_country_export"
table
[
"eos_order"
]
drvd_select
eos_order.invoice_third_country_export
fieldset
"inv_extra"
listCfg
{
"viewMode": 0,
"fullSearch": false
}
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
auto increment
Rechnungssprache
TEXT (2)
R
no
input_translated
Geben Sie den Sprache der Rechnung als ISO-Code (z.B. DE, EN) an.
i18n_string
"ecs.ORDER.invoice_lang_iso"
table
[
"eos_order"
]
drvd_select
eos_order.invoice_lang_iso
fieldset
"inv_extra"
listCfg
{
"viewMode": 0,
"formatter": {
"type": "country-flag"
},
"fullSearch": false
}
formCfg
{
"editMode": 0
}
drvd_invoice_street_housenr
auto increment
Straße+Nr (R)
TEXT
R
no
i18n_string
"ecs.ORDER.drvd_invoice_street_housenr"
table
[
"eos_order"
]
drvd_select
CONCAT_WS("",eos_order.invoice_street," ",eos_order.invoice_housenr)
listCfg
{
"viewMode": 0,
"fullSearch": false
}
formCfg
{
"editMode": 0
}
deliver_addr_preset
auto increment
Adressbuch (L)
DATA
R
yes
i18n_string
"ecs.ORDER.deliver_addr_preset"
table
[
"eos_order"
]
drvd_select
NULL
fieldset
"dlv_addr"
listCfg
{
"viewMode": 3,
"fullSearch": false
}
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
auto increment
Anrede (L)
TEXT
R
yes
enum
[
"female",
"male",
"company",
"divers"
]
i18n_string
"ecs.ORDER.deliver_gender"
table
[
"eos_order"
]
drvd_select
eos_order.deliver_gender
fieldset
"dlv_addr"
listCfg
{
"viewMode": 0,
"fullSearch": false
}
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
auto increment
Titel (L)
TEXT
R
no
i18n_string
"ecs.ORDER.deliver_title"
table
[
"eos_order"
]
drvd_select
eos_order.deliver_title
fieldset
"dlv_addr"
listCfg
{
"viewMode": 0,
"fullSearch": false
}
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
auto increment
Vorname (L)
TEXT
R
no
i18n_string
"ecs.ORDER.deliver_firstname"
table
[
"eos_order"
]
drvd_select
eos_order.deliver_firstname
fieldset
"dlv_addr"
listCfg
{
"viewMode": 0,
"fullSearch": false
}
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
auto increment
Nachname (L)
TEXT
R
no
i18n_string
"ecs.ORDER.deliver_lastname"
table
[
"eos_order"
]
drvd_select
eos_order.deliver_lastname
fieldset
"dlv_addr"
listCfg
{
"viewMode": 0,
"fullSearch": false
}
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
auto increment
Firma (L)
TEXT
R
no
i18n_string
"ecs.ORDER.deliver_company"
table
[
"eos_order"
]
drvd_select
eos_order.deliver_company
fieldset
"dlv_addr"
listCfg
{
"viewMode": 0,
"fullSearch": false
}
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
auto increment
Adressenzusatz
TEXT
R
no
i18n_string
"ecs.ORDER.deliver_addrextra"
table
[
"eos_order"
]
drvd_select
eos_order.deliver_addrextra
fieldset
"dlv_addr"
listCfg
{
"viewMode": 0,
"fullSearch": false
}
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
auto increment
Straße (L)
TEXT
R
no
i18n_string
"ecs.ORDER.deliver_street"
table
[
"eos_order"
]
drvd_select
eos_order.deliver_street
fieldset
"dlv_addr"
listCfg
{
"viewMode": 0,
"fullSearch": false
}
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
auto increment
Hausnummer (L)
TEXT
R
no
i18n_string
"ecs.ORDER.deliver_housenr"
table
[
"eos_order"
]
drvd_select
eos_order.deliver_housenr
fieldset
"dlv_addr"
listCfg
{
"viewMode": 0,
"fullSearch": false
}
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
auto increment
PLZ (L)
TEXT
R
no
i18n_string
"ecs.ORDER.deliver_zip"
table
[
"eos_order"
]
drvd_select
eos_order.deliver_zip
fieldset
"dlv_addr"
listCfg
{
"viewMode": 0,
"fullSearch": false
}
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
auto increment
Ort (L)
TEXT
R
no
i18n_string
"ecs.ORDER.deliver_town"
table
[
"eos_order"
]
drvd_select
eos_order.deliver_town
fieldset
"dlv_addr"
listCfg
{
"full_search": true,
"viewMode": 0,
"fullSearch": false
}
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
auto increment
Bundesland (Code) (L)
TEXT (15)
R
yes
i18n_string
"ecs.ORDER.deliver_state_code"
table
[
"eos_order"
]
drvd_select
eos_order.deliver_state_code
fieldset
"dlv_addr"
listCfg
{
"viewMode": 0,
"fullSearch": false
}
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_select
eos_order.deliver_country
fieldset
"dlv_addr"
listCfg
{
"viewMode": 0,
"formatter": {
"type": "country-flag"
},
"fullSearch": false
}
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
auto increment
Kunden-Wunschtermin
TEXT
R
no
i18n_string
"ecs.ORDER.deliver_date_req"
table
[
"eos_order"
]
drvd_select
eos_order.deliver_date_req
fieldset
"dlv_extra"
listCfg
{
"viewMode": 0,
"fullSearch": false
}
formCfg
{
"editMode": 0
}
deliver_phone
auto increment
Telefon
TEXT
R
no
i18n_string
"ecs.ORDER.deliver_phone"
table
[
"eos_order"
]
drvd_select
eos_order.deliver_phone
fieldset
"dlv_extra"
listCfg
{
"viewMode": 0,
"fullSearch": false
}
formCfg
{
"editMode": 0
}
deliver_email
auto increment
E-Mail (L)
TEXT
R
no
i18n_string
"ecs.ORDER.deliver_email"
table
[
"eos_order"
]
drvd_select
eos_order.deliver_email
fieldset
"dlv_extra"
listCfg
{
"viewMode": 0,
"fullSearch": false
}
formCfg
{
"editMode": 0
}
deliver_comment
auto increment
Liefer-Hinweise
TEXT
R
no
input_translated
Geben Sie hier einen Lieferhinweis für den Lieferanten ein.
i18n_string
"ecs.ORDER.deliver_comment"
table
[
"eos_order"
]
drvd_select
eos_order.deliver_comment
fieldset
"dlv_extra"
listCfg
{
"viewMode": 0,
"fullSearch": false
}
formCfg
{
"editMode": 0
}
drvd_deliver_street_housenr
auto increment
Straße+Nr (L)
TEXT
R
no
i18n_string
"ecs.ORDER.drvd_deliver_street_housenr"
table
[
"eos_order"
]
drvd_select
CONCAT_WS("",eos_order.deliver_street," ",eos_order.deliver_housenr)
listCfg
{
"viewMode": 0,
"fullSearch": false
}
formCfg
{
"editMode": 0
}
deliver_notes_xdata
auto increment
Lieferhinweise
DATA
R
yes
i18n_string
"ecs.ORDER.deliver_notes_xdata"
table
[
"eos_order"
]
drvd_select
eos_order.deliver_notes_xdata
fieldset
"dlv_extra"
listCfg
{
"viewMode": 0,
"fullSearch": false
}
formCfg
{
"cssLayout": "col-12",
"type": "aceeditor",
"options": {
"mode": "json"
},
"editMode": 0
}
ip_address
auto increment
IP-Adresse
TEXT
R
yes
i18n_string
"ecs.ORDER.ip_address"
table
[
"eos_order"
]
drvd_select
eos_order.ip_address
fieldset
"sys_record"
listCfg
{
"viewMode": 0,
"fullSearch": false
}
formCfg
{
"editMode": 0
}
o_referrer
auto increment
Referrer
TEXT
R
yes
i18n_string
"ecs.ORDER.o_referrer"
table
[
"eos_order"
]
drvd_select
eos_order.o_referrer
fieldset
"sys_record"
listCfg
{
"viewMode": 0,
"fullSearch": false
}
formCfg
{
"editMode": 0
}
o_useragent
auto increment
User-Agent
TEXT
R
yes
i18n_string
"ecs.ORDER.o_useragent"
table
[
"eos_order"
]
drvd_select
eos_order.o_useragent
fieldset
"sys_record"
listCfg
{
"viewMode": 0,
"fullSearch": false
}
formCfg
{
"editMode": 0
}
o_comment
auto increment
Kundenkommentar
TEXT
R
yes
input_translated
Geben Sie hier einen Kommentar zum Auftrag ein.
i18n_string
"ecs.ORDER.o_comment"
table
[
"eos_order"
]
drvd_select
eos_order.o_comment
fieldset
"extra"
listCfg
{
"viewMode": 0,
"fullSearch": false
}
formCfg
{
"type": "textarea",
"editMode": 0
}
o_comment_internal
auto increment
Interner Bestellhinweis
TEXT
R
yes
input_translated
Vergeben Sie hier einen internen Kommentar, z.B. für andere Auftragsbearbeiter.
i18n_string
"ecs.ORDER.o_comment_internal"
table
[
"eos_order"
]
drvd_select
eos_order.o_comment_internal
fieldset
"extra"
listCfg
{
"viewMode": 0,
"fullSearch": false
}
formCfg
{
"type": "textarea",
"editMode": 0
}
o_lock_time
auto increment
Bearbeitungs-Sperre (Zeitpunkt)
DATETIME
R
yes
i18n_string
"ecs.ORDER.o_lock_time"
table
[
"eos_order"
]
drvd_select
eos_order.o_lock_time
listCfg
{
"viewMode": 0,
"fullSearch": false
}
formCfg
{
"editMode": 0
}
o_lock_user
auto increment
Bearbeitungs-Sperre (Benutzer)
TEXT (31)
R
yes
i18n_string
"ecs.ORDER.o_lock_user"
table
[
"eos_order"
]
drvd_select
eos_order.o_lock_user
listCfg
{
"viewMode": 0,
"fullSearch": false
}
formCfg
{
"editMode": 0
}
o_insert_time
auto increment
Angelegt am
DATETIME
R
no
i18n_string
"insert_time"
table
[
"eos_order"
]
drvd_select
eos_order.o_insert_time
fieldset
"sys_record"
listCfg
{
"viewMode": 0,
"fullSearch": false
}
formCfg
{
"editMode": 0
}
o_update_time
auto increment
Geändert am
DATETIME
R
yes
i18n_string
"update_time"
table
[
"eos_order"
]
drvd_select
eos_order.o_update_time
fieldset
"sys_record"
listCfg
{
"viewMode": 0,
"fullSearch": false
}
formCfg
{
"editMode": 0
}
o_insert_user
auto increment
Ersteller
TEXT (127)
R
yes
i18n_string
"insert_user"
table
[
"eos_order"
]
drvd_select
eos_order.o_insert_user
fieldset
"sys_record"
listCfg
{
"formatter": {
"type": "user"
},
"viewMode": 0,
"fullSearch": false
}
formCfg
{
"editMode": 0
}
o_update_user
auto increment
Letzte Änderung durch
TEXT (127)
R
yes
i18n_string
"update_user"
table
[
"eos_order"
]
drvd_select
eos_order.o_update_user
fieldset
"sys_record"
listCfg
{
"viewMode": 0,
"fullSearch": false
}
formCfg
{
"editMode": 0
}
input_translated
Wählen Sie eine Kampagne aus, zu der dieser Auftrag zugeordnet werden soll.
i18n_string
"ecs.ORDER.fk_o_campid"
table
[
"eos_order"
]
drvd_select
eos_order.fk_o_campid
fieldset
"marketing"
listCfg
{
"viewMode": 0,
"fullSearch": false
}
formCfg
{
"cssLayout": "col-6",
"editMode": 0
}
drvd_o_shoplabel
auto increment
Shop
TEXT
R
no
i18n_string
"ecs.ORDER.drvd_o_shoplabel"
table
[
"eos_order"
]
drvd_select
eos_order.fk_o_shopid
listCfg
{
"viewMode": 0,
"fullSearch": false
}
formCfg
{
"editMode": 0
}
drvd_invoice_address
auto increment
Auftrag-Rg.Adresse
TEXT
R
no
i18n_string
"ecs.ORDER.drvd_invoice_address"
table
[
"eos_order"
]
drvd_select
CONCAT(
IF(CHAR_LENGTH(eos_order.invoice_company)>0,CONCAT(eos_order.invoice_company,CHAR(13)),""),
TRIM(CONCAT(eos_order.invoice_title," ",eos_order.invoice_firstname," ",eos_order.invoice_lastname)),CHAR(13),
IF(CHAR_LENGTH(eos_order.invoice_addrextra)>0,CONCAT(eos_order.invoice_addrextra,CHAR(13)),""),
eos_order.invoice_street," ",eos_order.invoice_housenr,CHAR(13),
eos_order.invoice_country," - ",eos_order.invoice_zip," ",eos_order.invoice_town)
listCfg
{
"viewMode": 0,
"fullSearch": false
}
formCfg
{
"editMode": 0
}
drvd_deliver_address
auto increment
Auftrag-Lfg.Adresse
TEXT
R
no
i18n_string
"ecs.ORDER.drvd_deliver_address"
table
[
"eos_order"
]
drvd_select
CONCAT(
IF(CHAR_LENGTH(eos_order.deliver_company)>0,CONCAT(eos_order.deliver_company,CHAR(13)),""),
TRIM(CONCAT(eos_order.deliver_title," ",eos_order.deliver_firstname," ",eos_order.deliver_lastname)),CHAR(13),
IF(CHAR_LENGTH(eos_order.deliver_addrextra)>0,CONCAT(eos_order.deliver_addrextra,CHAR(13)),""),
eos_order.deliver_street," ",eos_order.deliver_housenr,CHAR(13),
eos_order.deliver_country," - ",eos_order.deliver_zip," ",eos_order.deliver_town)
listCfg
{
"viewMode": 0,
"fullSearch": false
}
formCfg
{
"editMode": 0
}
o_pay_profile_xdata
auto increment
Zahlungsziel-Daten
DATA
R
yes
i18n_string
"ecs.ORDER.o_pay_profile_xdata"
table
[
"eos_order"
]
drvd_select
eos_order.o_pay_profile_xdata
listCfg
{
"viewMode": 0,
"fullSearch": false
}
formCfg
{
"cssLayout": "col-12",
"type": "aceeditor",
"options": {
"mode": "json"
},
"editMode": 0
}
Unteraccount
INT (11)
R
yes
i18n_string
"ecs.plugin_companyaccount.fk_o_companyaccount_subaccount_persid"
table
[
"eos_order"
]
drvd_select
eos_order.fk_o_companyaccount_subaccount_persid
fieldset
"extra"
listCfg
{
"viewMode": 3,
"fullSearch": false
}
formCfg
{
"editMode": 0
}
i18n_string
"ecs.ORDER.fk_o_mrch_id"
table
[
"eos_order"
]
drvd_select
eos_order.fk_o_mrch_id
fieldset
"extra"
listCfg
{
"viewMode": 3,
"fullSearch": false
}
formCfg
{
"editMode": 0
}
i18n_string
"ecs.ORDER.fk_o_parent_oid"
table
[
"eos_order"
]
drvd_select
eos_order.fk_o_parent_oid
fieldset
"extra"
listCfg
{
"viewMode": 3,
"fullSearch": false
}
formCfg
{
"editMode": 0
}
o_merchant_xdata
auto increment
Anbieter (Zusatzdaten)
DATA
R
yes
i18n_string
"ecs.ORDER.o_merchant_xdata"
table
[
"eos_order"
]
drvd_select
eos_order.o_merchant_xdata
fieldset
"extra"
listCfg
{
"viewMode": 0,
"fullSearch": false
}
formCfg
{
"cssLayout": "col-12",
"type": "aceeditor",
"options": {
"mode": "json"
},
"editMode": 0
}
o_periodic_time_first
auto increment
Abo-Startdatum
DATETIME
R
yes
i18n_string
"ecs.ORDER.o_periodic_time_first"
table
[
"eos_order"
]
drvd_select
eos_order.o_periodic_time_first
fieldset
"time_settings"
listCfg
{
"viewMode": 3,
"fullSearch": false
}
formCfg
{
"type": "datetimepicker",
"cssLayout": "col-12 col-md-6 col-xl-6",
"editMode": 0
}
o_periodic_time_last
auto increment
Abo-Enddatum
DATETIME
R
yes
i18n_string
"ecs.ORDER.o_periodic_time_last"
table
[
"eos_order"
]
drvd_select
eos_order.o_periodic_time_last
fieldset
"time_settings"
listCfg
{
"viewMode": 3,
"fullSearch": false
}
formCfg
{
"type": "datetimepicker",
"cssLayout": "col-12 col-md-6 col-xl-6",
"editMode": 0
}
o_periodic_time_next
auto increment
Nächste Abo-Ausführung
DATETIME
R
yes
i18n_string
"ecs.ORDER.o_periodic_time_next"
table
[
"eos_order"
]
drvd_select
eos_order.o_periodic_time_next
fieldset
"time_settings"
listCfg
{
"viewMode": 3,
"fullSearch": false
}
formCfg
{
"editMode": 0,
"cssLayout": "col-12 col-md-6 col-xl-6"
}
o_periodic_timeorder_offset
auto increment
Abweichendes Auftragsdatum
TEXT (31)
R
no
i18n_string
"ecs.ORDER.o_periodic_timeorder_offset"
table
[
"eos_order"
]
drvd_select
eos_order.o_periodic_timeorder_offset
fieldset
"time_settings"
listCfg
{
"viewMode": 3,
"formatter": {
"type": "cron"
},
"fullSearch": false
}
formCfg
{
"cssLayout": "col-12 col-md-6 col-xl-6",
"editMode": 0
}
o_periodic_time_strict
auto increment
Strikt
INT (1)
R
no
i18n_string
"ecs.ORDER.o_periodic_time_strict"
table
[
"eos_order"
]
drvd_select
eos_order.o_periodic_time_strict
fieldset
"time_settings"
listCfg
{
"viewMode": 3,
"formatter": {
"type": "active-flag"
},
"fullSearch": false
}
formCfg
{
"type": "checkbox",
"value": 1,
"editMode": 0
}
o_periodic_exec_period
auto increment
Abo-Intervall
TEXT (31)
R
no
i18n_string
"ecs.ORDER.o_periodic_exec_period"
table
[
"eos_order"
]
drvd_select
eos_order.o_periodic_exec_period
fieldset
"time_settings"
listCfg
{
"viewMode": 3,
"formatter": {
"type": "cron"
},
"fullSearch": false
}
formCfg
{
"type": "hfycron",
"editMode": 0
}
o_periodic_exec_inprogress
auto increment
Wird gerade ausgeführt
INT (1)
R
no
i18n_string
"ecs.ORDER.o_periodic_exec_inprogress"
table
[
"eos_order"
]
drvd_select
eos_order.o_periodic_exec_inprogress
listCfg
{
"viewMode": 3,
"fullSearch": false
}
formCfg
{
"editMode": 0
}
o_periodic_xdata
auto increment
DATA
R
yes
i18n_string
"ecs.ORDER.o_periodic_xdata"
table
[
"eos_order"
]
drvd_select
eos_order.o_periodic_xdata
fieldset
"time_settings_xdata"
listCfg
{
"viewMode": 0,
"fullSearch": false
}
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
auto increment
Wochentag
TEXT
R
no
i18n_string
"ecs.ORDER.drvd_weekday_timeordered"
table
[
"eos_order"
]
drvd_select
DATE_FORMAT(eos_order.o_time_ordered, '%a')
listCfg
{
"viewMode": 0,
"fullSearch": false
}
formCfg
{
"editMode": 0
}
drvd_hour_timeordered
auto increment
Stunde
TEXT
R
no
i18n_string
"ecs.ORDER.drvd_hour_timeordered"
table
[
"eos_order"
]
drvd_select
DATE_FORMAT(eos_order.o_time_ordered, '%H')
listCfg
{
"viewMode": 0,
"fullSearch": false
}
formCfg
{
"editMode": 0
}
drvd_month_timeordered
auto increment
Bestellmonat
TEXT
R
no
i18n_string
"ecs.ORDER.drvd_month_timeordered"
table
[
"eos_order"
]
drvd_select
DATE_FORMAT(eos_order.o_time_ordered, '%m')
listCfg
{
"viewMode": 0,
"fullSearch": false
}
formCfg
{
"editMode": 0
}
drvd_dayofmonth_timeordered
auto increment
Bestelltag im Monat
TEXT
R
no
i18n_string
"ecs.ORDER.drvd_dayofmonth_timeordered"
table
[
"eos_order"
]
drvd_select
DATE_FORMAT(eos_order.o_time_ordered, '%d')
listCfg
{
"viewMode": 0,
"fullSearch": false
}
formCfg
{
"editMode": 0
}
drvd_timeonly_timeordered
auto increment
Bestellzeit
TEXT
R
no
i18n_string
"ecs.ORDER.drvd_timeonly_timeordered"
table
[
"eos_order"
]
drvd_select
DATE_FORMAT(eos_order.o_time_ordered, '%H:%i')
listCfg
{
"viewMode": 0,
"fullSearch": false
}
formCfg
{
"editMode": 0
}
drvd_cluster_seq
auto increment
Erst-/Wiederkauf
TEXT
R
no
i18n_string
"ecs.ORDER.drvd_cluster_seq"
table
[
"eos_order"
]
drvd_select
IF(eos_order.o_pers_seq_nr > 1,"Wiederkauf","Erstkauf")
listCfg
{
"viewMode": 0,
"fullSearch": false
}
formCfg
{
"editMode": 0
}
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"
]
drvd_select
eos_person.persid
fieldset
"base_record"
listCfg
{
"viewMode": 0,
"fullSearch": false
}
formCfg
{
"type": "hidden",
"editMode": 0
}
personid
auto increment
Kunden-Nr.
TEXT (32)
R
no
i18n_string
"ecs.PERSON.personid"
table
[
"eos_person"
]
drvd_select
eos_person.personid
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": 0,
"fullSearch": false,
"depends_on": "fk_dv_persid"
}
formCfg
{
"cssLayout": "col-6",
"editMode": 0
}
i18n_string
"ecs.PERSON.fk_p_grpid"
table
[
"eos_person"
]
drvd_select
eos_person.fk_p_grpid
fieldset
"base_record"
listCfg
{
"viewMode": 3,
"fullSearch": false
}
formCfg
{
"cssLayout": "col-6",
"editMode": 0
}
i18n_string
"ecs.PERSON.fk_p_shopid"
table
[
"eos_person"
]
drvd_select
eos_person.fk_p_shopid
listCfg
{
"viewMode": 0,
"fullSearch": false
}
formCfg
{
"editMode": 0
}
gender
auto increment
Anrede
TEXT
R
yes
enum
[
"female",
"male",
"company",
"divers"
]
i18n_string
"ecs.PERSON.gender"
valueColorField
"gender_color"
table
[
"eos_person"
]
drvd_select
eos_person.gender
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
auto increment
TEXT (15)
R
yes
i18n_string
"ecs.PERSON.gender_color"
table
[
"eos_person"
]
drvd_select
CASE eos_person.gender WHEN "female" THEN "#BF117F" WHEN "male" THEN "#1f96cb" WHEN "divers" THEN "#7D47B9" WHEN "company" THEN "#41cbd9" WHEN "unknown" THEN "#AAAAAA" ELSE NULL END
listCfg
{
"viewMode": 3,
"fullSearch": false
}
formCfg
{
"editMode": 0
}
title
auto increment
Titel
TEXT
R
no
input_translated
Geben Sie hier einen Titel des Kunden an (z.B. Dr.).
i18n_string
"ecs.PERSON.title"
table
[
"eos_person"
]
drvd_select
eos_person.title
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
auto increment
Anrede formal
TEXT
R
no
i18n_string
"ecs.PERSON.salutation"
table
[
"eos_person"
]
drvd_select
eos_person.salutation
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
auto increment
Vorname
TEXT
R
no
input_translated
Vorname der Registrierungsadresse.
i18n_string
"ecs.PERSON.firstname"
table
[
"eos_person"
]
drvd_select
eos_person.firstname
fieldset
"base"
listCfg
{
"width": 128,
"viewMode": 0,
"fullSearch": false
}
formCfg
{
"cssLayout": "col-6",
"editMode": 0
}
lastname
auto increment
Nachname
TEXT
R
no
i18n_string
"ecs.PERSON.lastname"
table
[
"eos_person"
]
drvd_select
eos_person.lastname
fieldset
"base"
listCfg
{
"width": 128,
"viewMode": 0,
"fullSearch": false
}
formCfg
{
"cssLayout": "col-6",
"editMode": 0
}
bday
auto increment
Geburtsdatum
DATE
R
yes
input_translated
Tragen Sie hier das Geburtsdatum des Kunden ein.
Vorzugsweise im Format: tt.mm.JJJJ.
Vorzugsweise im Format: tt.mm.JJJJ.
i18n_string
"ecs.PERSON.bday"
table
[
"eos_person"
]
drvd_select
eos_person.bday
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]
auto increment
Alter
INT
R
yes
i18n_string
"ecs.PERSON.drvd_age"
table
[
"eos_person"
]
drvd_select
DATE_FORMAT(NOW(), '%Y') - DATE_FORMAT(eos_person.bday, '%Y') - (DATE_FORMAT(NOW(), '00-%m-%d') < DATE_FORMAT(eos_person.bday, '00-%m-%d'))
fieldset
"analytics"
listCfg
{
"viewMode": 0,
"fullSearch": false
}
formCfg
{
"editMode": 0
}
drvd_bday_days_until_next
[d]
auto increment
Nächster Geburtstag (in Tagen)
INT
R
yes
i18n_string
"ecs.PERSON.drvd_bday_days_until_next"
table
[
"eos_person"
]
drvd_select
IF(DAYOFYEAR(eos_person.bday)>DAYOFYEAR(CURDATE()) , DATEDIFF(CONCAT(YEAR(CURDATE()),'-',MONTH(eos_person.bday),'-',DAY(eos_person.bday) ) , CURDATE() ), DATEDIFF(CONCAT(YEAR(CURDATE())+1,'-',MONTH(eos_person.bday),'-',DAY(eos_person.bday) ) , CURDATE()))
fieldset
"analytics"
listCfg
{
"viewMode": 0,
"fullSearch": false
}
formCfg
{
"editMode": 0
}
drvd_bday_next
auto increment
Nächster Geburtstag
DATE
R
yes
i18n_string
"ecs.PERSON.drvd_bday_next"
table
[
"eos_person"
]
drvd_select
IF(DAYOFYEAR(eos_person.bday)>DAYOFYEAR(CURDATE()) , CONCAT(YEAR(CURDATE()),'-',LPAD(MONTH(eos_person.bday),2,'0'),'-',LPAD(DAY(eos_person.bday),2,'0') ), CONCAT(YEAR(CURDATE())+1,'-',LPAD(MONTH(eos_person.bday),2,'0'),'-',LPAD(DAY(eos_person.bday),2,'0')))
fieldset
"analytics"
listCfg
{
"viewMode": 0,
"fullSearch": false
}
formCfg
{
"editMode": 0
}
company
auto increment
Firma
TEXT
R
no
i18n_string
"ecs.PERSON.company"
table
[
"eos_person"
]
drvd_select
eos_person.company
fieldset
"addr"
listCfg
{
"viewMode": 0,
"fullSearch": false
}
formCfg
{
"cssLayout": "col-4",
"editMode": 0
}
p_department
auto increment
Abteilung
TEXT
R
no
i18n_string
"ecs.PERSON.p_department"
table
[
"eos_person"
]
drvd_select
eos_person.p_department
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
auto increment
Position
TEXT
R
no
i18n_string
"ecs.PERSON.p_job_position"
table
[
"eos_person"
]
drvd_select
eos_person.p_job_position
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
auto increment
Adressenzusatz
TEXT
R
no
i18n_string
"ecs.PERSON.address2"
table
[
"eos_person"
]
drvd_select
eos_person.address2
fieldset
"addr"
listCfg
{
"viewMode": 0,
"fullSearch": false
}
formCfg
{
"cssLayout": "col-12",
"editMode": 0
}
street
auto increment
Straße
TEXT
R
no
i18n_string
"ecs.PERSON.street"
table
[
"eos_person"
]
drvd_select
eos_person.street
fieldset
"addr"
listCfg
{
"width": 96,
"viewMode": 0,
"fullSearch": false
}
formCfg
{
"cssLayout": "col-9",
"editMode": 0
}
housenr
auto increment
Hausnummer
TEXT
R
no
i18n_string
"ecs.PERSON.housenr"
table
[
"eos_person"
]
drvd_select
eos_person.housenr
fieldset
"addr"
listCfg
{
"width": 64,
"viewMode": 0,
"fullSearch": false
}
formCfg
{
"cssLayout": "col-3",
"editMode": 0
}
zip
auto increment
PLZ
TEXT
R
no
i18n_string
"ecs.PERSON.zip"
table
[
"eos_person"
]
drvd_select
eos_person.zip
fieldset
"addr"
listCfg
{
"width": 64,
"viewMode": 0,
"fullSearch": false
}
formCfg
{
"cssLayout": "col-4",
"editMode": 0
}
town
auto increment
Ort
TEXT
R
no
i18n_string
"ecs.PERSON.town"
table
[
"eos_person"
]
drvd_select
eos_person.town
fieldset
"addr"
listCfg
{
"width": 96,
"viewMode": 0,
"fullSearch": false
}
formCfg
{
"cssLayout": "col-8",
"editMode": 0
}
state_code
auto increment
Bundesland (Code)
TEXT (15)
R
yes
i18n_string
"ecs.PERSON.state_code"
table
[
"eos_person"
]
drvd_select
eos_person.state_code
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"
]
drvd_select
eos_person.country
fieldset
"addr"
listCfg
{
"viewMode": 0,
"width": 64,
"formatter": {
"type": "country-flag"
},
"fullSearch": false
}
formCfg
{
"cssLayout": "col-6",
"editMode": 0
}
drvd_person_name
auto increment
Kundenname (kombiniert)
TEXT
R
no
i18n_string
"ecs.PERSON.drvd_person_name"
table
[
"eos_person"
]
drvd_select
CONCAT_WS("",eos_person.company,IF((eos_person.company IS NOT NULL AND eos_person.company != "") AND ((eos_person.firstname IS NOT NULL AND eos_person.firstname != "") OR (eos_person.lastname IS NOT NULL AND eos_person.lastname != "")),", ",""),eos_person.firstname,IF(eos_person.firstname IS NOT NULL," ",""),eos_person.lastname)
listCfg
{
"viewMode": 0,
"fullSearch": false
}
formCfg
{
"editMode": 0
}
drvd_p_address
auto increment
Adresse
TEXT
R
yes
i18n_string
"ecs.PERSON.drvd_p_address"
table
[
"eos_person"
]
drvd_select
CONCAT(
IF(CHAR_LENGTH(eos_person.company)>0,CONCAT(eos_person.company,CHAR(13)),""),
TRIM(CONCAT(eos_person.title," ",eos_person.firstname," ",eos_person.lastname)),CHAR(13),
IF(CHAR_LENGTH(eos_person.address2)>0,CONCAT(eos_person.address2,CHAR(13)),""),
eos_person.street," ",eos_person.housenr,CHAR(13),
eos_person.country," - ",eos_person.zip," ",eos_person.town)
listCfg
{
"viewMode": 0,
"fullSearch": false
}
formCfg
{
"editMode": 0
}
email
auto increment
E-Mail
TEXT (127)
R
no
i18n_string
"ecs.PERSON.email"
table
[
"eos_person"
]
drvd_select
eos_person.email
fieldset
"communication"
listCfg
{
"width": 256,
"viewMode": 0,
"fullSearch": false
}
formCfg
{
"type": "hfyemail",
"cssLayout": "col-6",
"editMode": 0
}
telephone
auto increment
Telefon
TEXT
R
no
i18n_string
"ecs.PERSON.telephone"
table
[
"eos_person"
]
drvd_select
eos_person.telephone
fieldset
"communication"
listCfg
{
"viewMode": 0,
"fullSearch": false
}
formCfg
{
"type": "hfyphone",
"cssLayout": "col-6",
"editMode": 0
}
telephone_mobile
auto increment
Tel. mobil
TEXT
R
no
i18n_string
"ecs.PERSON.telephone_mobile"
table
[
"eos_person"
]
drvd_select
eos_person.telephone_mobile
fieldset
"communication"
listCfg
{
"viewMode": 0,
"fullSearch": false
}
formCfg
{
"type": "hfyphone",
"cssLayout": "col-6",
"editMode": 0
}
telefax
auto increment
Fax
TEXT
R
no
i18n_string
"ecs.PERSON.telefax"
table
[
"eos_person"
]
drvd_select
eos_person.telefax
fieldset
"communication"
listCfg
{
"viewMode": 0,
"fullSearch": false
}
formCfg
{
"type": "hfyphone",
"cssLayout": "col-6",
"editMode": 0
}
p_invoice_type
auto increment
Rechnungsart
TEXT
R
yes
i18n_string
"ecs.PERSON.p_invoice_type"
table
[
"eos_person"
]
drvd_select
eos_person.p_invoice_type
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
auto increment
E-Mail (Rechnung)
TEXT
R
no
i18n_string
"ecs.PERSON.p_invoice_email"
table
[
"eos_person"
]
drvd_select
eos_person.p_invoice_email
fieldset
"commercial"
listCfg
{
"viewMode": 0,
"fullSearch": false
}
formCfg
{
"type": "hfyemail",
"editMode": 0
}
taxident
auto increment
Umsatzsteuer-ID
TEXT
R
no
i18n_string
"ecs.PERSON.taxident"
table
[
"eos_person"
]
drvd_select
eos_person.taxident
fieldset
"commercial"
listCfg
{
"viewMode": 0,
"fullSearch": false
}
formCfg
{
"editMode": 0
}
taxident_status
auto increment
Umsatzsteuer-ID-Status
TEXT
R
yes
input_translated
Status der Umsatzsteuer-ID des Kundenkontos. Nur Kundenkonten mit bestätigter Umsatzsteuer-ID werden für Netto-Aufträge bei Lieferung in andere EU Länder berücksichtigt.
enum
[
"invalid",
"valid_conditional",
"valid_confirmed"
]
i18n_string
"ecs.PERSON.taxident_status"
table
[
"eos_person"
]
drvd_select
eos_person.taxident_status
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
auto increment
Bonitätswert
INT (7)
R
no
i18n_string
"ecs.PERSON.score"
table
[
"eos_person"
]
drvd_select
eos_person.score
fieldset
"credit_rating"
listCfg
{
"viewMode": 0,
"sumType": "AVG",
"fullSearch": false
}
formCfg
{
"editMode": 0
}
score_time_set
auto increment
Letzter Rating-Check
DATETIME
R
yes
i18n_string
"ecs.PERSON.score_time_set"
table
[
"eos_person"
]
drvd_select
eos_person.score_time_set
fieldset
"credit_rating"
listCfg
{
"viewMode": 0,
"fullSearch": false
}
formCfg
{
"editMode": 0
}
score_time_invalid
auto increment
Abgelaufen am
DATETIME
R
yes
i18n_string
"ecs.PERSON.score_time_invalid"
table
[
"eos_person"
]
drvd_select
eos_person.score_time_invalid
fieldset
"credit_rating"
listCfg
{
"viewMode": 0,
"fullSearch": false
}
formCfg
{
"editMode": 0
}
svc_code
auto increment
Rating ServiceCode
TEXT
R
yes
i18n_string
"ecs.PERSON.svc_code"
table
[
"eos_person"
]
drvd_select
eos_person.svc_code
fieldset
"credit_rating"
listCfg
{
"viewMode": 0,
"fullSearch": false
}
formCfg
{
"editMode": 0
}
svc_txt
auto increment
Rating ServiceText
TEXT
R
yes
i18n_string
"ecs.PERSON.svc_txt"
table
[
"eos_person"
]
drvd_select
eos_person.svc_txt
fieldset
"credit_rating"
listCfg
{
"viewMode": 0,
"fullSearch": false
}
formCfg
{
"editMode": 0
}
p_login_username
auto increment
Benutzername
TEXT (63)
R
yes
i18n_string
"ecs.PERSON.p_login_username"
table
[
"eos_person"
]
drvd_select
eos_person.p_login_username
fieldset
"login"
listCfg
{
"viewMode": 0,
"fullSearch": false
}
formCfg
{
"editMode": 0
}
p_login_pwd_encrypted
auto increment
Passwort (verschlüsselt)
TEXT
R
yes
i18n_string
"ecs.PERSON.p_login_pwd_encrypted"
table
[
"eos_person"
]
drvd_select
eos_person.p_login_pwd_encrypted
fieldset
"login"
listCfg
{
"viewMode": 3,
"fullSearch": false
}
formCfg
{
"editMode": 0
}
p_login_pwd_key
auto increment
Direct-Login-Token
TEXT
R
yes
i18n_string
"ecs.PERSON.p_login_pwd_key"
table
[
"eos_person"
]
drvd_select
eos_person.p_login_pwd_key
fieldset
"login"
listCfg
{
"viewMode": 0,
"fullSearch": false
}
formCfg
{
"editMode": 0
}
p_login_time_last
auto increment
Letzter Login
DATETIME
R
yes
i18n_string
"ecs.PERSON.p_login_time_last"
table
[
"eos_person"
]
drvd_select
eos_person.p_login_time_last
fieldset
"login"
listCfg
{
"viewMode": 0,
"fullSearch": false
}
formCfg
{
"editMode": 0
}
p_login_pwd_must_renew_after
auto increment
Passwort-Änderung auffordern ab
DATETIME
R
yes
i18n_string
"ecs.PERSON.p_login_pwd_must_renew_after"
table
[
"eos_person"
]
drvd_select
eos_person.p_login_pwd_must_renew_after
fieldset
"login"
listCfg
{
"viewMode": 0,
"fullSearch": false
}
formCfg
{
"type": "datetimepicker",
"editMode": 0
}
p_login_pwd_key_timeout
auto increment
Direct-Login-Token Timeout
DATETIME
R
yes
i18n_string
"ecs.PERSON.p_login_pwd_key_timeout"
table
[
"eos_person"
]
drvd_select
eos_person.p_login_pwd_key_timeout
fieldset
"login"
listCfg
{
"viewMode": 0,
"fullSearch": false
}
formCfg
{
"editMode": 0
}
p_login_pwd_last_renewed
auto increment
Passwort zuletzt geändert
DATETIME
R
yes
i18n_string
"ecs.PERSON.p_login_pwd_last_renewed"
table
[
"eos_person"
]
drvd_select
eos_person.p_login_pwd_last_renewed
fieldset
"login"
listCfg
{
"viewMode": 0,
"fullSearch": false
}
formCfg
{
"editMode": 0
}
p_login_active
auto increment
Aktiv
INT (1)
R
no
i18n_string
"ecs.PERSON.p_login_active"
table
[
"eos_person"
]
drvd_select
eos_person.p_login_active
fieldset
"login"
listCfg
{
"formatter": {
"type": "active-flag"
},
"width": 64,
"viewMode": 0,
"fullSearch": false
}
formCfg
{
"type": "checkbox",
"editMode": 0
}
p_email_verify_token
auto increment
TEXT (32)
R
yes
i18n_string
"ecs.PERSON.p_email_verify_token"
table
[
"eos_person"
]
drvd_select
eos_person.p_email_verify_token
fieldset
"login"
listCfg
{
"viewMode": 0,
"fullSearch": false
}
formCfg
{
"editMode": 0
}
p_email_verify_token_timeout
auto increment
DATETIME
R
yes
i18n_string
"ecs.PERSON.p_email_verify_token_timeout"
table
[
"eos_person"
]
drvd_select
eos_person.p_email_verify_token_timeout
fieldset
"login"
listCfg
{
"viewMode": 0,
"fullSearch": false
}
formCfg
{
"editMode": 0
}
p_email_verified_time
auto increment
DATETIME
R
yes
i18n_string
"ecs.PERSON.p_email_verified_time"
table
[
"eos_person"
]
drvd_select
eos_person.p_email_verified_time
fieldset
"login"
listCfg
{
"viewMode": 0,
"fullSearch": false
}
formCfg
{
"editMode": 0
}
p_login_mode
auto increment
Login-Modus
TEXT (15)
R
yes
enum
[
"simple",
"2fa_email"
]
i18n_string
"ecs.PERSON.p_login_mode"
table
[
"eos_person"
]
drvd_select
eos_person.p_login_mode
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
auto increment
2FA - Login Code
TEXT
R
yes
i18n_string
"ecs.PERSON.p_login_2fa_code"
table
[
"eos_person"
]
drvd_select
eos_person.p_login_2fa_code
fieldset
"login"
listCfg
{
"viewMode": 0,
"fullSearch": false
}
formCfg
{
"editMode": 0
}
p_login_2fa_timeout
auto increment
2FA - Login Code Timeout
DATETIME
R
yes
i18n_string
"ecs.PERSON.p_login_2fa_timeout"
table
[
"eos_person"
]
drvd_select
eos_person.p_login_2fa_timeout
fieldset
"login"
listCfg
{
"viewMode": 0,
"fullSearch": false
}
formCfg
{
"editMode": 0
}
p_login_err_count
auto increment
Anzahl Fehllogins
INT (4)
R
no
i18n_string
"ecs.PERSON.p_login_err_count"
table
[
"eos_person"
]
drvd_select
eos_person.p_login_err_count
fieldset
"login"
listCfg
{
"viewMode": 0,
"fullSearch": false
}
formCfg
{
"editMode": 0
}
p_login_time_min
auto increment
Login Sperrzeit
DATETIME
R
yes
i18n_string
"ecs.PERSON.p_login_time_min"
table
[
"eos_person"
]
drvd_select
eos_person.p_login_time_min
fieldset
"login"
listCfg
{
"viewMode": 0,
"fullSearch": false
}
formCfg
{
"editMode": 0
}
p_register_state
auto increment
Registrierungsstatus
TEXT (15)
R
yes
i18n_string
"ecs.PERSON.p_register_state"
table
[
"eos_person"
]
drvd_select
eos_person.p_register_state
fieldset
"login"
listCfg
{
"viewMode": 0,
"fullSearch": false
}
formCfg
{
"editMode": 0
}
p_register_code
auto increment
Registrierungscode
TEXT (32)
R
yes
i18n_string
"ecs.PERSON.p_register_code"
table
[
"eos_person"
]
drvd_select
eos_person.p_register_code
fieldset
"login"
listCfg
{
"viewMode": 0,
"fullSearch": false
}
formCfg
{
"editMode": 0
}
p_register_code_timeout
auto increment
Registrierungscode Timeout
DATETIME
R
yes
i18n_string
"ecs.PERSON.p_register_code_timeout"
table
[
"eos_person"
]
drvd_select
eos_person.p_register_code_timeout
fieldset
"login"
listCfg
{
"viewMode": 0,
"fullSearch": false
}
formCfg
{
"editMode": 0
}
p_onetime_pwd
auto increment
Einmal-Passwort
TEXT
R
yes
i18n_string
"ecs.PERSON.p_onetime_pwd"
table
[
"eos_person"
]
drvd_select
eos_person.p_onetime_pwd
fieldset
"login"
listCfg
{
"viewMode": 0,
"fullSearch": false
}
formCfg
{
"editMode": 0
}
p_onetime_pwd_timeout
auto increment
Einmal-Passwort Timeout
DATETIME
R
yes
i18n_string
"ecs.PERSON.p_onetime_pwd_timeout"
table
[
"eos_person"
]
drvd_select
eos_person.p_onetime_pwd_timeout
fieldset
"login"
listCfg
{
"viewMode": 0,
"fullSearch": false
}
formCfg
{
"editMode": 0
}
p_login_state
auto increment
Login Status
TEXT (15)
R
no
enum
[
"possible",
"disabled",
"suspended",
"retry"
]
i18n_string
"ecs.PERSON.p_login_state"
table
[
"eos_person"
]
drvd_select
IF(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
auto increment
TEXT (15)
R
yes
i18n_string
"ecs.PERSON.p_login_state_color"
table
[
"eos_person"
]
drvd_select
IF(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"
]
drvd_select
eos_person.p_oo_set_label
fieldset
"order_options"
listCfg
{
"viewMode": 0,
"fullSearch": false
}
formCfg
{
"editMode": 0
}
Zahlungsziel-Profil
INT (11)
R
yes
i18n_string
"ecs.PERSON.fk_p_pay_profile_id"
table
[
"eos_person"
]
drvd_select
eos_person.fk_p_pay_profile_id
fieldset
"order_options"
listCfg
{
"viewMode": 3,
"fullSearch": false
}
formCfg
{
"editMode": 0
}
input_translated
Eine 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"
]
drvd_select
eos_person.fk_p_prcgrp_id
fieldset
"order_options"
listCfg
{
"viewMode": 3,
"fullSearch": false
}
formCfg
{
"editMode": 0
}
p_price_factor
auto increment
Preis-Faktor
FLOAT (10,4)
R
yes
input_translated
Der 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"
]
drvd_select
eos_person.p_price_factor
fieldset
"order_options"
listCfg
{
"viewMode": 0,
"fullSearch": false
}
formCfg
{
"editMode": 0
}
p_person_prices
auto increment
Persönliche Preise
INT (1)
R
no
i18n_string
"ecs.PERSON.p_person_prices"
table
[
"eos_person"
]
drvd_select
eos_person.p_person_prices
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"
]
drvd_select
eos_person.fk_p_campid
fieldset
"marketing"
listCfg
{
"viewMode": 0,
"fullSearch": false
}
formCfg
{
"editMode": 0
}
p_allow_email_marketing
auto increment
Zustimmung zu Marketing-Mails
INT (1)
R
no
i18n_string
"ecs.PERSON.p_allow_email_marketing"
table
[
"eos_person"
]
drvd_select
eos_person.p_allow_email_marketing
fieldset
"marketing"
listCfg
{
"formatter": {
"type": "active-flag"
},
"width": 64,
"viewMode": 0,
"fullSearch": false
}
formCfg
{
"type": "checkbox",
"editMode": 0
}
drvd_emailmarketing_unsubscribetoken
auto increment
Token für Direktabmeldung Marketingmails
TEXT
R
no
i18n_string
"ecs.PERSON.drvd_emailmarketing_unsubscribetoken"
table
[
"eos_person"
]
drvd_select
md5(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
auto increment
IP-Adresse
TEXT (15)
R
no
i18n_string
"ecs.PERSON.p_ip_address"
table
[
"eos_person"
]
drvd_select
eos_person.p_ip_address
fieldset
"registration"
listCfg
{
"viewMode": 0,
"fullSearch": false
}
formCfg
{
"editMode": 0
}
p_referrer
auto increment
Referrer
TEXT
R
yes
i18n_string
"ecs.PERSON.p_referrer"
table
[
"eos_person"
]
drvd_select
eos_person.p_referrer
fieldset
"registration"
listCfg
{
"viewMode": 0,
"fullSearch": false
}
formCfg
{
"editMode": 0
}
p_useragent
auto increment
User Agent
TEXT
R
yes
i18n_string
"ecs.PERSON.p_useragent"
table
[
"eos_person"
]
drvd_select
eos_person.p_useragent
fieldset
"registration"
listCfg
{
"viewMode": 0,
"fullSearch": false
}
formCfg
{
"editMode": 0
}
p_personid_external
auto increment
Externe Kunden-Nr.
TEXT (127)
R
yes
input_translated
Eine externe Kunden-Nr. aus einem anderen System.
i18n_string
"ecs.PERSON.p_personid_external"
table
[
"eos_person"
]
drvd_select
eos_person.p_personid_external
fieldset
"external"
listCfg
{
"viewMode": 0,
"fullSearch": false
}
formCfg
{
"editMode": 0
}
p_comment_internal
auto increment
Interner Kommentar
TEXT
R
yes
i18n_string
"ecs.PERSON.p_comment_internal"
table
[
"eos_person"
]
drvd_select
eos_person.p_comment_internal
fieldset
"extra"
listCfg
{
"viewMode": 0,
"fullSearch": false
}
formCfg
{
"editMode": 0
}
p_locale
auto increment
Locale Kunde
DATA
R
yes
i18n_string
"ecs.PERSON.p_locale"
table
[
"eos_person"
]
drvd_select
eos_person.p_locale
fieldset
"extra"
listCfg
{
"viewMode": 0,
"fullSearch": false
}
formCfg
{
"editMode": 0
}
p_volfile
auto increment
DATA
R
yes
i18n_string
"ecs.PERSON.p_volfile"
table
[
"eos_person"
]
drvd_select
NULL
fieldset
"documents"
listCfg
{
"viewMode": 3,
"fullSearch": false
}
formCfg
{
"type": "hfyvolumefile",
"options": {
"vol_label": "person_documents",
"vol_primKeyVar": "persid",
"vol_primKey": null
},
"editMode": 0
}
time_insert
auto increment
Angelegt am
DATETIME
R
no
i18n_string
"insert_time"
table
[
"eos_person"
]
drvd_select
eos_person.time_insert
fieldset
"sys_record"
listCfg
{
"viewMode": 0,
"fullSearch": false
}
formCfg
{
"editMode": 0
}
user_insert
auto increment
Ersteller
TEXT (127)
R
yes
i18n_string
"insert_user"
table
[
"eos_person"
]
drvd_select
eos_person.user_insert
fieldset
"sys_record"
listCfg
{
"formatter": {
"type": "user"
},
"viewMode": 0,
"fullSearch": false
}
formCfg
{
"editMode": 0
}
time_update
auto increment
Geändert am
DATETIME
R
yes
i18n_string
"update_time"
table
[
"eos_person"
]
drvd_select
eos_person.time_update
fieldset
"sys_record"
listCfg
{
"viewMode": 0,
"fullSearch": false
}
formCfg
{
"editMode": 0
}
user_update
auto increment
Letzte Änderung durch
TEXT (127)
R
yes
i18n_string
"update_user"
table
[
"eos_person"
]
drvd_select
eos_person.user_update
fieldset
"sys_record"
listCfg
{
"viewMode": 0,
"fullSearch": false
}
formCfg
{
"editMode": 0
}
drvd_timeonly_timeinsert
auto increment
Angelegt (Uhrzeit)
TEXT
R
no
i18n_string
"ecs.PERSON.drvd_timeonly_timeinsert"
table
[
"eos_person"
]
drvd_select
DATE_FORMAT(eos_person.time_insert, '%H:%i')
fieldset
"analytics"
listCfg
{
"viewMode": 0,
"fullSearch": false
}
formCfg
{
"editMode": 0
}
p_anonymize_time
auto increment
Anoymisiert am
DATETIME
R
yes
i18n_string
"ecs.PERSON.p_anonymize_time"
table
[
"eos_person"
]
drvd_select
eos_person.p_anonymize_time
fieldset
"sys_record"
listCfg
{
"viewMode": 0,
"fullSearch": false
}
formCfg
{
"editMode": 0
}
input_translated
Verknü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"
]
drvd_select
eos_person.fk_p_companyaccount_parent_persid
fieldset
"extra"
listCfg
{
"viewMode": 3,
"fullSearch": false
}
formCfg
{
"editMode": 0
}
p_companyaccount_budget_cart_max
[EUR]
auto increment
Budget Warenkorb
FLOAT (10,2)
R
yes
input_translated
Legen 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"
]
drvd_select
eos_person.p_companyaccount_budget_cart_max
fieldset
"extra"
listCfg
{
"viewMode": 0,
"fullSearch": false
}
formCfg
{
"type": "eosnumber",
"options": {
"decimalsCalculate": 2,
"decimalshowMin": 2,
"decimalshowMax": 2
},
"editMode": 0
}
p_companyaccount_cost_center_customer
auto increment
Kunden Kostenstelle
TEXT
R
yes
input_translated
Standard Kostenstelle des Kunden.
i18n_string
"ecs.plugin_companyaccount.p_companyaccount_cost_center_customer"
table
[
"eos_person"
]
drvd_select
eos_person.p_companyaccount_cost_center_customer
fieldset
"extra"
listCfg
{
"viewMode": 0,
"fullSearch": false
}
formCfg
{
"editMode": 0
}
p_companyaccount_type
auto increment
TEXT
R
yes
i18n_string
"ecs.plugin_companyaccount.p_companyaccount_type"
table
[
"eos_person"
]
drvd_select
eos_person.p_companyaccount_type
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
auto increment
DATA
R
yes
i18n_string
"ecs.plugin_companyaccount.p_companyaccount_xdata"
table
[
"eos_person"
]
drvd_select
eos_person.p_companyaccount_xdata
fieldset
"extra"
listCfg
{
"viewMode": 0,
"fullSearch": false
}
formCfg
{
"cssLayout": "col-12",
"type": "aceeditor",
"options": {
"mode": "json"
},
"editMode": 0
}
p_accounting_debtor_account
auto increment
Buchhaltung Debitorenkonto
TEXT
R
yes
input_translated
Tragen 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"
]
drvd_select
eos_person.p_accounting_debtor_account
fieldset
"accounting"
listCfg
{
"viewMode": 0,
"fullSearch": false
}
formCfg
{
"editMode": 0
}
fk_pers_inv_reminder_profile
auto increment
Mahnprofil
TEXT (127)
R
yes
i18n_string
"ecs.PERSON.fk_pers_inv_reminder_profile"
table
[
"eos_person"
]
drvd_select
eos_person.fk_pers_inv_reminder_profile
listCfg
{
"viewMode": 0,
"fullSearch": false
}
formCfg
{
"editMode": 0
}
p_merchant_xdata
auto increment
Anbieter (Zusatzdaten)
DATA
R
yes
input_translated
Geben 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"
]
drvd_select
eos_person.p_merchant_xdata
fieldset
"extra"
listCfg
{
"viewMode": 0,
"fullSearch": false
}
formCfg
{
"cssLayout": "col-12",
"type": "aceeditor",
"options": {
"mode": "json"
},
"editMode": 0
}
p_shopuserright_profiles
auto increment
Benutzer-Rollen
TEXT
R
yes
input_translated
Wählen Sie hier die Benutzer-Rollen für den Kunden aus.
i18n_string
"ecs.plugin_shopuserright.p_shopuserright_profiles"
table
[
"eos_person"
]
drvd_select
eos_person.p_shopuserright_profiles
listCfg
{
"viewMode": 0,
"fullSearch": false
}
formCfg
{
"editMode": 0
}
p_shopuserright_rights
auto increment
Benutzer-Rechte
TEXT
R
yes
input_translated
Tragen Sie hier einzelne Benutzer-Rechte für den Kunden ein.
i18n_string
"ecs.plugin_shopuserright.p_shopuserright_rights"
table
[
"eos_person"
]
drvd_select
eos_person.p_shopuserright_rights
listCfg
{
"viewMode": 0,
"fullSearch": false
}
formCfg
{
"editMode": 0
}
p_login_pwd_plain
auto increment
Neues Passwort
TEXT (64)
R
yes
input_translated
Nur ausfüllen, wenn ein neues Passwort vergeben werden soll.
i18n_string
"ecs.PERSON.p_login_pwd_plain"
table
[
"eos_person"
]
drvd_select
NULL
fieldset
"login"
listCfg
{
"viewMode": 3,
"fullSearch": false
}
formCfg
{
"editMode": 0,
"type": "hfypassword",
"options": {
"reqs_dataStreamCall": {
"method": "person_getPasswordRequirements"
}
}
}
drvd_order_timelast
auto increment
Letzte Bestellung
DATETIME
R
no
i18n_string
"ecs.PERSON.drvd_order_timelast"
table
[
"eos_person"
]
drvd_select
eos_person.drvd_order_timelast
fieldset
"analytics"
listCfg
{
"viewMode": 0,
"fullSearch": false
}
formCfg
{
"editMode": 0
}
drvd_order_timefirst
auto increment
Erste Bestellung
DATETIME
R
no
i18n_string
"ecs.PERSON.drvd_order_timefirst"
table
[
"eos_person"
]
drvd_select
eos_person.drvd_order_timefirst
fieldset
"analytics"
listCfg
{
"viewMode": 0,
"fullSearch": false
}
formCfg
{
"editMode": 0
}
drvd_order_frequency
[d]
auto increment
Bestellfrequenz
FLOAT (9,2)
R
no
i18n_string
"ecs.PERSON.drvd_order_frequency"
table
[
"eos_person"
]
drvd_select
eos_person.drvd_order_frequency
fieldset
"analytics"
listCfg
{
"viewMode": 0,
"fullSearch": false
}
formCfg
{
"editMode": 0
}
drvd_order_count
auto increment
# Aufträge
INT (11)
R
no
i18n_string
"ecs.PERSON.drvd_order_count"
table
[
"eos_person"
]
drvd_select
eos_person.drvd_order_count
fieldset
"analytics"
listCfg
{
"viewMode": 0,
"fullSearch": false
}
formCfg
{
"editMode": 0
}
p_profile_photo
auto increment
Bild
TEXT
R
yes
i18n_string
"ecs.PERSON.p_profile_photo"
table
[
"eos_person"
]
drvd_select
eos_person.p_profile_photo
fieldset
"profile"
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_select
eos_person_group.grpid
fieldset
"base_record"
listCfg
{
"viewMode": 0,
"fullSearch": false
}
formCfg
{
"type": "hidden",
"editMode": 0
}
grp_name
auto increment
Kundengruppe
TEXT (127)
R
no
input_translated
Geben Sie einen aussagekräftigen Namen für die Kundengruppe ein.
i18n_string
"ecs.PERSONGRP.grp_name"
table
[
"eos_person_group"
]
drvd_select
eos_person_group.grp_name
fieldset
"base"
listCfg
{
"viewMode": 0,
"fullSearch": false,
"depends_on": "fk_p_grpid"
}
formCfg
{
"mandatory": 1,
"editMode": 0
}
description
auto increment
Beschreibung
TEXT
R
no
input_translated
Geben Sie eine Beschreibung der Kundengruppe ein (z.B. für WEN wurde sie angelegt)
i18n_string
"ecs.PERSONGRP.description"
table
[
"eos_person_group"
]
drvd_select
eos_person_group.description
fieldset
"base"
listCfg
{
"viewMode": 0,
"fullSearch": false
}
formCfg
{
"type": "textarea",
"editMode": 0
}
grp_default
auto increment
Default
INT (1)
R
no
input_translated
Aktivieren 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_select
eos_person_group.grp_default
fieldset
"register"
listCfg
{
"formatter": {
"type": "active-flag"
},
"width": 64,
"viewMode": 0,
"fullSearch": false
}
formCfg
{
"type": "checkbox",
"editMode": 0
}
grp_p_login_active
auto increment
Kundenlogin Default Aktiv
INT (1)
R
no
i18n_string
"ecs.PERSONGRP.grp_p_login_active"
table
[
"eos_person_group"
]
drvd_select
eos_person_group.grp_p_login_active
fieldset
"defaults_person"
listCfg
{
"formatter": {
"type": "active-flag"
},
"width": 64,
"viewMode": 0,
"fullSearch": false
}
formCfg
{
"type": "checkbox",
"editMode": 0
}
grp_locale
auto increment
Locale Kundengruppe
DATA
R
yes
i18n_string
"ecs.PERSONGRP.grp_locale"
table
[
"eos_person_group"
]
drvd_select
eos_person_group.grp_locale
fieldset
"defaults_person"
listCfg
{
"viewMode": 0,
"fullSearch": false
}
formCfg
{
"editMode": 0
}
grp_state
auto increment
Bestellstatus
TEXT (63)
R
no
input_translated
Tragen Sie hier den Eingangsstatus für Bestellung von Kunden aus dieser Kundengruppe ein.
i18n_string
"ecs.PERSONGRP.grp_state"
table
[
"eos_person_group"
]
drvd_select
eos_person_group.grp_state
fieldset
"defaults_order"
listCfg
{
"viewMode": 0,
"fullSearch": false
}
formCfg
{
"editMode": 0
}
grp_pos
auto increment
POS Channel
TEXT (63)
R
no
input_translated
Geben 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_select
eos_person_group.grp_pos
fieldset
"defaults_order"
listCfg
{
"viewMode": 0,
"fullSearch": false
}
formCfg
{
"editMode": 0
}
prc_display_mode
auto increment
Preisanzeige
TEXT (15)
R
no
input_translated
Wä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_select
eos_person_group.prc_display_mode
fieldset
"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
auto increment
Preis-Faktor
FLOAT (10,4)
R
yes
input_translated
Der 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_select
eos_person_group.grp_price_factor
fieldset
"prices"
listCfg
{
"viewMode": 0,
"fullSearch": false
}
formCfg
{
"cssLayout": "col-12",
"type": "eosnumber",
"editMode": 0
}
input_translated
Falls 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_select
eos_person_group.fk_grp_prcgrp_id
fieldset
"prices"
listCfg
{
"viewMode": 3,
"fullSearch": false
}
formCfg
{
"editMode": 0
}
grp_persongrp_prices
auto increment
Gruppenspezifische Preise
INT (1)
R
no
i18n_string
"ecs.PERSONGRP.grp_persongrp_prices"
table
[
"eos_person_group"
]
drvd_select
eos_person_group.grp_persongrp_prices
fieldset
"orderoptions"
listCfg
{
"formatter": {
"type": "active-flag"
},
"width": 64,
"viewMode": 0,
"fullSearch": false
}
formCfg
{
"type": "checkbox",
"editMode": 0
}
grp_price_col
auto increment
Preisspalte
TEXT (31)
R
yes
input_translated
Geben 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_select
eos_person_group.grp_price_col
fieldset
"price_col_cfg"
listCfg
{
"viewMode": 0,
"fullSearch": false
}
formCfg
{
"editMode": 0
}
grp_discount_col
auto increment
Preisspalte (Discount)
TEXT (63)
R
yes
i18n_string
"ecs.PERSONGRP.grp_discount_col"
table
[
"eos_person_group"
]
drvd_select
IF(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
auto increment
Preisspalte (Discount Start)
TEXT (63)
R
yes
i18n_string
"ecs.PERSONGRP.grp_discount_start_col"
table
[
"eos_person_group"
]
drvd_select
IF(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
auto increment
Preisspalte (Discount Ende)
TEXT (63)
R
yes
i18n_string
"ecs.PERSONGRP.grp_discount_end_col"
table
[
"eos_person_group"
]
drvd_select
IF(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
auto increment
Preisspalte (Staffelpreise)
TEXT (63)
R
no
i18n_string
"ecs.PERSONGRP.grp_price_dsc_scale_col"
table
[
"eos_person_group"
]
drvd_select
eos_person_group.grp_price_dsc_scale_col
fieldset
"price_col_cfg"
listCfg
{
"viewMode": 0,
"fullSearch": false
}
formCfg
{
"editMode": 0
}
grp_price_prcgrp_col
auto increment
Preisgruppen-Spalte
TEXT (63)
R
no
input_translated
Legen 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_select
eos_person_group.grp_price_prcgrp_col
fieldset
"price_col_cfg"
listCfg
{
"viewMode": 0,
"fullSearch": false
}
formCfg
{
"editMode": 0
}
grp_price_state_col
auto increment
Spalte für Shop-Status
TEXT (63)
R
no
i18n_string
"ecs.PERSONGRP.grp_price_state_col"
table
[
"eos_person_group"
]
drvd_select
eos_person_group.grp_price_state_col
fieldset
"price_col_cfg"
listCfg
{
"viewMode": 0,
"fullSearch": false
}
formCfg
{
"editMode": 0
}
grp_price_hide_price_dsp_col
auto increment
Spalte für Preis ausblenden
TEXT (63)
R
no
i18n_string
"ecs.PERSONGRP.grp_price_hide_price_dsp_col"
table
[
"eos_person_group"
]
drvd_select
eos_person_group.grp_price_hide_price_dsp_col
fieldset
"price_col_cfg"
listCfg
{
"viewMode": 0,
"fullSearch": false
}
formCfg
{
"editMode": 0
}
input_translated
Geben 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_select
eos_person_group.grp_oo_set_label
fieldset
"orderoptions"
listCfg
{
"viewMode": 0,
"fullSearch": false
}
formCfg
{
"editMode": 0
}
Zahlungsziel-Profil
INT (11)
R
yes
i18n_string
"ecs.PERSONGRP.fk_grp_pay_profile_id"
table
[
"eos_person_group"
]
drvd_select
eos_person_group.fk_grp_pay_profile_id
fieldset
"orderoptions"
listCfg
{
"viewMode": 3,
"fullSearch": false
}
formCfg
{
"editMode": 0
}
data
auto increment
Daten
DATA
R
yes
input_translated
Geben 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_select
eos_person_group.data
fieldset
"extra"
listCfg
{
"viewMode": 0,
"fullSearch": false
}
formCfg
{
"cssLayout": "col-12",
"type": "aceeditor",
"options": {
"mode": "json"
},
"editMode": 0
}
grp_shopuserright_profiles
auto increment
Gruppen-Rollen
TEXT
R
yes
input_translated
Wählen Sie hier die Benutzer-Rollen für die Kundengruppen aus.
i18n_string
"ecs.plugin_shopuserright.grp_shopuserright_profiles"
table
[
"eos_person_group"
]
drvd_select
eos_person_group.grp_shopuserright_profiles
listCfg
{
"viewMode": 0,
"fullSearch": false
}
formCfg
{
"editMode": 0
}
grp_shopuserright_rights
auto increment
Gruppen-Rechte
TEXT
R
yes
input_translated
Tragen Sie hier einzelne Benutzer-Rechte für die Kundengruppe ein.
i18n_string
"ecs.plugin_shopuserright.grp_shopuserright_rights"
table
[
"eos_person_group"
]
drvd_select
eos_person_group.grp_shopuserright_rights
listCfg
{
"viewMode": 0,
"fullSearch": false
}
formCfg
{
"editMode": 0
}