deliveryitem - "Lieferartikel" 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_selectCONCAT(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_selectewh_nstgrp_nodes.node_idlistCfg{
"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_selectewh_nstgrp_nodes.i18n_node_name_DElistCfg{
"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_selectewh_nstgrp_nodes.i18n_node_path_DEformCfg{
"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_selectIF(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_selectIF(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_selectIF(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_selectIF(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_translatedDie 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_translatedDer 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_translatedDie 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_translatedDie 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_translatedDie 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_translatedDas 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_selectCONCAT(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_selectIF(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_selectdvi_pcodelistCfg{
"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_selectCOALESCE(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_selectIF(excdb_data_ecs_product_de.pcode = excdb_data_ecs_product_de.master_pcode,1,0)fieldset"cdb_base"listCfg{
"formatter": {
"type": "active-flag"
},
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}name
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_translatedBei Einzelprodukten (ohne Varianten) ist dies gleich dem PCode. Bei Variantenprodukten wird hier der PCode des Hauptprodukts der Variantengruppe eingetragen.
i18n_string"ecs.PRODUCT.master_pcode"table[
"excdb_data_ecs_product_de"
]fieldset"cdb_base"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"type": "text",
"options": {
"XXXobserver": {
"fields": [
{
"field": "pcode",
"trigger": "onChange",
"exec": [
{
"cmd": "copy"
}
]
}
]
}
},
"mandatory": true,
"editMode": 0
}prdv_color
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_translatedProdukte durch Drag-and-Drop hinzufügen. Beispielsweise aus der Trefferliste der "Hublify Suche".
i18n_string"ecs.PRODUCT.products_replace"table[
"excdb_data_ecs_product_de"
]fieldset"cdb_marketing"listCfg{
"formatter": {
"type": "sub-data-chip",
"params": {
"chipCssClass": "chip"
}
},
"viewMode": 0,
"fullSearch": false
}formCfg{
"type": "eossubmodel",
"options": {
"model": "cdb_record",
"xDataKey": "r2r_xdata",
"xDataDialogConfig": {
"layoutLabel": "submodel_product_r2r_xdata_generic_popup"
},
"dataStreamCall": {
"method": "datahub_generate_reportList",
"params": {
"ds_label": "product"
}
},
"optValueField": "xc__id",
"optNameField": "name"
},
"mandatory": false,
"editMode": 0
}pcode_manufacturer
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_translatedProdukte durch Drag-and-Drop hinzufügen. Beispielsweise aus der Trefferliste der "Hublify Suche".
i18n_string"ecs.PRODUCT.products_upselling"table[
"excdb_data_ecs_product_de"
]fieldset"cdb_marketing"listCfg{
"formatter": {
"type": "sub-data-chip",
"params": {
"chipCssClass": "chip"
}
},
"viewMode": 0,
"fullSearch": false
}formCfg{
"type": "eossubmodel",
"options": {
"model": "cdb_record",
"xDataKey": "r2r_xdata",
"xDataDialogConfig": {
"layoutLabel": "submodel_product_r2r_xdata_generic_popup"
},
"dataStreamCall": {
"method": "datahub_generate_reportList",
"params": {
"ds_label": "product"
}
},
"optValueField": "xc__id",
"optNameField": "name"
},
"mandatory": false,
"editMode": 0
}orderitem_name
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_translatedBilder mit Drag-and-Drop hinzufügen. Entweder aus Hublify Media-Manager oder von eigener Festplatte.
i18n_string"ecs.PRODUCT.files_img"table[
"excdb_data_ecs_product_de"
]fieldset"cdb_base_2"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"type": "eosmedia",
"options": {
"uploadDirDefault": "\/products"
},
"mandatory": false,
"editMode": 0
}prd_bundle_price_discount_perc
[%]
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_selectexcdb_data_ecs_product_de.pcodefieldset"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_selectexcdb_data_ecs_product_de.namefieldset"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_selectexcdb_data_ecs_product_de.files_imgfieldset"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_selectCONCAT_WS(',',excdb_data_ecs_product_de.prdv_color, excdb_data_ecs_product_de.prdv_size, excdb_data_ecs_product_de.prdv_other)listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}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_selectCONCAT_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_selectCONCAT_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_selecteos_states.st_colorlistCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}item_id
auto increment
INT
R
no
i18n_string"ecs.DELIVERY.item_id"table[
"ecs_delivery"
]drvd_selectecs_delivery.didlistCfg{
"viewMode": 3,
"fullSearch": false
}formCfg{
"editMode": 0
}i18n_st_name
auto increment
Statusname
TEXT
R
no
i18n_string"st_name"table[
"eos_states"
]drvd_selecteos_states.i18n_st_name_DElistCfg{
"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_selecteos_states.i18n_st_name_public_DElistCfg{
"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_selecteos_states.st_x_dv_sentlistCfg{
"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_selecteos_states.st_codelistCfg{
"viewMode": 3,
"fullSearch": false
}formCfg{
"editMode": 0
}st_position
auto increment
INT
R
no
i18n_string"ecs.DELIVERY.st_position"table[
"eos_states"
]drvd_selecteos_states.st_positionlistCfg{
"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_selecteos_statelog.is_currentlistCfg{
"viewMode": 3,
"fullSearch": false
}formCfg{
"editMode": 0
}transtime
auto increment
DATETIME
R
no
i18n_string"ecs.DELIVERY.transtime"table[
"eos_statelog"
]drvd_selecteos_statelog.transtimelistCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}i18n_string"ecs_plugin_ewarehouse.DELIVERY.ps_name"table"ecs_delivery"drvd_selectecs_delivery.fk_dv_psidlistCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}i18n_string"ecs_plugin_ewarehouse.DELIVERY.fk_dv_dgrp_id"table"ecs_delivery"drvd_selectecs_delivery.fk_dv_dgrp_idlistCfg{
"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_selectJSON_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_selectJSON_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_selectdv_terr_state.terr_namelistCfg{
"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_selectdv_terr_state.i18n_node_path_DElistCfg{
"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_selectdv_seller_terr_state.terr_namelistCfg{
"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_selectdv_seller_terr_state.i18n_node_path_DElistCfg{
"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_selecteos_order.oidfieldset"base_record"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"type": "hidden",
"editMode": 0
}input_translatedWählen Sie den Shop aus, zu dem dieser Auftrag gehört.
i18n_string"ecs.ORDER.fk_o_shopid"table[
"eos_order"
]drvd_selecteos_order.fk_o_shopidfieldset"marketing"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}orderid
auto increment
Auftrags-Nr.
TEXT (63)
R
no
i18n_string"ecs.ORDER.orderid"table[
"eos_order"
]drvd_selecteos_order.orderidfieldset"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_translatedGeben Sie die Kunden-ID eines Kunden ein.
i18n_string"ecs.ORDER.fk_o_persid"table[
"eos_order"
]drvd_selecteos_order.fk_o_persidfieldset"base_record"listCfg{
"viewMode": 0,
"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_selecteos_order.o_time_orderedfieldset"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_selecteos_order.total_nettolistCfg{
"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_selecteos_order.total_bruttolistCfg{
"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_translatedGeben Sie hier ggf. eine externe erhaltene Auftragsnummer ein. Diese bekommen Sie z.B. wenn der Auftrag über einen externen Marktplatz (z.B. Amazon Marketplace) erstellt wurde.
i18n_string"ecs.ORDER.o_orderid_external"table[
"eos_order"
]drvd_selecteos_order.o_orderid_externalfieldset"base"listCfg{
"viewMode": 0,
"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_selecteos_order.fk_o_posidfieldset"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_selecteos_order.fk_o_stidfieldset"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_selecteos_order.fk_o_st_idfieldset"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_translatedGeben Sie einen Referenztext des Kunden ein.
i18n_string"ecs.ORDER.o_pers_reftext"table[
"eos_order"
]drvd_selecteos_order.o_pers_reftextlistCfg{
"viewMode": 0,
"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_selecteos_order.o_pers_seq_nrlistCfg{
"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_selecteos_order.quantitylistCfg{
"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_selectROUND(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_selecteos_order.currencylistCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}otitle
auto increment
Auftragstitel
TEXT
R
yes
input_translatedGeben Sie dem Auftrag einen Titel.
i18n_string"ecs.ORDER.otitle"table[
"eos_order"
]drvd_selecteos_order.otitlefieldset"doc_header"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"cssLayout": "col-12",
"editMode": 0
}otext
auto increment
Auftragsbeschreibung
TEXT
R
yes
i18n_string"ecs.ORDER.otext"table[
"eos_order"
]drvd_selecteos_order.otextfieldset"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_selecteos_order.o_typefieldset"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_selecteos_order.o_valid_untillistCfg{
"viewMode": 0,
"formatter": {
"type": "date"
},
"fullSearch": false
}formCfg{
"type": "datetimepicker",
"editMode": 0
}o_txt_header
auto increment
Kopf-Text
TEXT
R
yes
input_translatedKopf-Text für die Verwendung in PDFs
i18n_string"ecs.ORDER.o_txt_header"table[
"eos_order"
]drvd_selecteos_order.o_txt_headerfieldset"doc_header"listCfg{
"viewMode": 0,
"fullSearch": 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_selectNULLfieldset"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_selecteos_order.invoice_genderfieldset"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_selecteos_order.invoice_titlefieldset"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_selecteos_order.invoice_firstnamefieldset"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_selecteos_order.invoice_lastnamefieldset"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_selecteos_order.invoice_companyfieldset"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_selecteos_order.invoice_addrextrafieldset"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_selecteos_order.invoice_streetfieldset"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_selecteos_order.invoice_housenrfieldset"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_selecteos_order.invoice_zipfieldset"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_selecteos_order.invoice_townfieldset"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_selecteos_order.invoice_state_codefieldset"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_selecteos_order.invoice_countryfieldset"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_selecteos_order.invoice_typefieldset"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_selecteos_order.invoice_emailfieldset"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_selecteos_order.invoice_taxidentnumberfieldset"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_selecteos_order.invoice_taxident_statusfieldset"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_selecteos_order.invoice_third_country_exportfieldset"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_translatedGeben Sie den Sprache der Rechnung als ISO-Code (z.B. DE, EN) an.
i18n_string"ecs.ORDER.invoice_lang_iso"table[
"eos_order"
]drvd_selecteos_order.invoice_lang_isofieldset"inv_extra"listCfg{
"viewMode": 0,
"formatter": {
"type": "country-flag"
},
"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_selectCONCAT_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_selectNULLfieldset"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_selecteos_order.deliver_genderfieldset"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_selecteos_order.deliver_titlefieldset"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_selecteos_order.deliver_firstnamefieldset"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_selecteos_order.deliver_lastnamefieldset"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_selecteos_order.deliver_companyfieldset"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_selecteos_order.deliver_addrextrafieldset"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_selecteos_order.deliver_streetfieldset"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_selecteos_order.deliver_housenrfieldset"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_selecteos_order.deliver_zipfieldset"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_selecteos_order.deliver_townfieldset"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_selecteos_order.deliver_state_codefieldset"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_selecteos_order.deliver_countryfieldset"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_selecteos_order.deliver_date_reqfieldset"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_selecteos_order.deliver_phonefieldset"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_selecteos_order.deliver_emailfieldset"dlv_extra"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}deliver_comment
auto increment
Liefer-Hinweise
TEXT
R
no
input_translatedGeben Sie hier einen Lieferhinweis für den Lieferanten ein.
i18n_string"ecs.ORDER.deliver_comment"table[
"eos_order"
]drvd_selecteos_order.deliver_commentfieldset"dlv_extra"listCfg{
"viewMode": 0,
"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_selectCONCAT_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_selecteos_order.deliver_notes_xdatafieldset"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_selecteos_order.ip_addressfieldset"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_selecteos_order.o_referrerfieldset"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_selecteos_order.o_useragentfieldset"sys_record"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}o_comment
auto increment
Kundenkommentar
TEXT
R
yes
input_translatedGeben Sie hier einen Kommentar zum Auftrag ein.
i18n_string"ecs.ORDER.o_comment"table[
"eos_order"
]drvd_selecteos_order.o_commentfieldset"extra"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"type": "textarea",
"editMode": 0
}o_comment_internal
auto increment
Interner Bestellhinweis
TEXT
R
yes
input_translatedVergeben Sie hier einen internen Kommentar, z.B. für andere Auftragsbearbeiter.
i18n_string"ecs.ORDER.o_comment_internal"table[
"eos_order"
]drvd_selecteos_order.o_comment_internalfieldset"extra"listCfg{
"viewMode": 0,
"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_selecteos_order.o_lock_timelistCfg{
"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_selecteos_order.o_lock_userlistCfg{
"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_selecteos_order.o_insert_timefieldset"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_selecteos_order.o_update_timefieldset"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_selecteos_order.o_insert_userfieldset"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_selecteos_order.o_update_userfieldset"sys_record"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}input_translatedWählen Sie eine Kampagne aus, zu der dieser Auftrag zugeordnet werden soll.
i18n_string"ecs.ORDER.fk_o_campid"table[
"eos_order"
]drvd_selecteos_order.fk_o_campidfieldset"marketing"listCfg{
"viewMode": 0,
"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_selecteos_order.fk_o_shopidlistCfg{
"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_selectCONCAT(
IF(CHAR_LENGTH(eos_order.invoice_company)>0,CONCAT(eos_order.invoice_company,CHAR(13)),""),
TRIM(CONCAT(eos_order.invoice_title," ",eos_order.invoice_firstname," ",eos_order.invoice_lastname)),CHAR(13),
IF(CHAR_LENGTH(eos_order.invoice_addrextra)>0,CONCAT(eos_order.invoice_addrextra,CHAR(13)),""),
eos_order.invoice_street," ",eos_order.invoice_housenr,CHAR(13),
eos_order.invoice_country," - ",eos_order.invoice_zip," ",eos_order.invoice_town) listCfg{
"viewMode": 0,
"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_selectCONCAT(
IF(CHAR_LENGTH(eos_order.deliver_company)>0,CONCAT(eos_order.deliver_company,CHAR(13)),""),
TRIM(CONCAT(eos_order.deliver_title," ",eos_order.deliver_firstname," ",eos_order.deliver_lastname)),CHAR(13),
IF(CHAR_LENGTH(eos_order.deliver_addrextra)>0,CONCAT(eos_order.deliver_addrextra,CHAR(13)),""),
eos_order.deliver_street," ",eos_order.deliver_housenr,CHAR(13),
eos_order.deliver_country," - ",eos_order.deliver_zip," ",eos_order.deliver_town) listCfg{
"viewMode": 0,
"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_selecteos_order.o_pay_profile_xdatalistCfg{
"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_selecteos_order.fk_o_companyaccount_subaccount_persidfieldset"extra"listCfg{
"viewMode": 3,
"fullSearch": false
}formCfg{
"editMode": 0
}i18n_string"ecs.ORDER.fk_o_mrch_id"table[
"eos_order"
]drvd_selecteos_order.fk_o_mrch_idfieldset"extra"listCfg{
"viewMode": 3,
"fullSearch": false
}formCfg{
"editMode": 0
}i18n_string"ecs.ORDER.fk_o_parent_oid"table[
"eos_order"
]drvd_selecteos_order.fk_o_parent_oidfieldset"extra"listCfg{
"viewMode": 3,
"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_selecteos_order.o_merchant_xdatafieldset"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_selecteos_order.o_periodic_time_firstfieldset"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_selecteos_order.o_periodic_time_lastfieldset"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_selecteos_order.o_periodic_time_nextfieldset"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_selecteos_order.o_periodic_timeorder_offsetfieldset"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_selecteos_order.o_periodic_time_strictfieldset"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_selecteos_order.o_periodic_exec_periodfieldset"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_selecteos_order.o_periodic_exec_inprogresslistCfg{
"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_selecteos_order.o_periodic_xdatafieldset"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_selectDATE_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_selectDATE_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_selectDATE_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_selectDATE_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_selectDATE_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_selectIF(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_selecteos_person.persidfieldset"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_selecteos_person.personidfieldset"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_selecteos_person.fk_p_grpidfieldset"base_record"listCfg{
"viewMode": 3,
"fullSearch": false
}formCfg{
"cssLayout": "col-6",
"editMode": 0
}i18n_string"ecs.PERSON.fk_p_shopid"table[
"eos_person"
]drvd_selecteos_person.fk_p_shopidlistCfg{
"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_selecteos_person.genderfieldset"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_selectCASE eos_person.gender WHEN "female" THEN "#BF117F" WHEN "male" THEN "#1f96cb" WHEN "divers" THEN "#7D47B9" WHEN "company" THEN "#41cbd9" WHEN "unknown" THEN "#AAAAAA" ELSE NULL ENDlistCfg{
"viewMode": 3,
"fullSearch": false
}formCfg{
"editMode": 0
}title
auto increment
Titel
TEXT
R
no
input_translatedGeben Sie hier einen Titel des Kunden an (z.B. Dr.).
i18n_string"ecs.PERSON.title"table[
"eos_person"
]drvd_selecteos_person.titlefieldset"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_selecteos_person.salutationfieldset"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_translatedVorname der Registrierungsadresse.
i18n_string"ecs.PERSON.firstname"table[
"eos_person"
]drvd_selecteos_person.firstnamefieldset"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_selecteos_person.lastnamefieldset"base"listCfg{
"width": 128,
"viewMode": 0,
"fullSearch": false
}formCfg{
"cssLayout": "col-6",
"editMode": 0
}bday
auto increment
Geburtsdatum
DATE
R
yes
input_translatedTragen Sie hier das Geburtsdatum des Kunden ein.
Vorzugsweise im Format: tt.mm.JJJJ.
Vorzugsweise im Format: tt.mm.JJJJ.
i18n_string"ecs.PERSON.bday"table[
"eos_person"
]drvd_selecteos_person.bdayfieldset"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_selectDATE_FORMAT(NOW(), '%Y') - DATE_FORMAT(eos_person.bday, '%Y') - (DATE_FORMAT(NOW(), '00-%m-%d') < DATE_FORMAT(eos_person.bday, '00-%m-%d'))fieldset"analytics"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}drvd_bday_days_until_next
[d]
auto increment
Nächster Geburtstag (in Tagen)
INT
R
yes
i18n_string"ecs.PERSON.drvd_bday_days_until_next"table[
"eos_person"
]drvd_selectIF(DAYOFYEAR(eos_person.bday)>DAYOFYEAR(CURDATE()) , DATEDIFF(CONCAT(YEAR(CURDATE()),'-',MONTH(eos_person.bday),'-',DAY(eos_person.bday) ) , CURDATE() ), DATEDIFF(CONCAT(YEAR(CURDATE())+1,'-',MONTH(eos_person.bday),'-',DAY(eos_person.bday) ) , CURDATE()))fieldset"analytics"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}drvd_bday_next
auto increment
Nächster Geburtstag
DATE
R
yes
i18n_string"ecs.PERSON.drvd_bday_next"table[
"eos_person"
]drvd_selectIF(DAYOFYEAR(eos_person.bday)>DAYOFYEAR(CURDATE()) , CONCAT(YEAR(CURDATE()),'-',LPAD(MONTH(eos_person.bday),2,'0'),'-',LPAD(DAY(eos_person.bday),2,'0') ), CONCAT(YEAR(CURDATE())+1,'-',LPAD(MONTH(eos_person.bday),2,'0'),'-',LPAD(DAY(eos_person.bday),2,'0')))fieldset"analytics"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}company
auto increment
Firma
TEXT
R
no
i18n_string"ecs.PERSON.company"table[
"eos_person"
]drvd_selecteos_person.companyfieldset"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_selecteos_person.p_departmentfieldset"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_selecteos_person.p_job_positionfieldset"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_selecteos_person.address2fieldset"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_selecteos_person.streetfieldset"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_selecteos_person.housenrfieldset"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_selecteos_person.zipfieldset"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_selecteos_person.townfieldset"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_selecteos_person.state_codefieldset"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_selecteos_person.countryfieldset"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_selectCONCAT_WS("",eos_person.company,IF((eos_person.company IS NOT NULL AND eos_person.company != "") AND ((eos_person.firstname IS NOT NULL AND eos_person.firstname != "") OR (eos_person.lastname IS NOT NULL AND eos_person.lastname != "")),", ",""),eos_person.firstname,IF(eos_person.firstname IS NOT NULL," ",""),eos_person.lastname)listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}drvd_p_address
auto increment
Adresse
TEXT
R
yes
i18n_string"ecs.PERSON.drvd_p_address"table[
"eos_person"
]drvd_selectCONCAT(
IF(CHAR_LENGTH(eos_person.company)>0,CONCAT(eos_person.company,CHAR(13)),""),
TRIM(CONCAT(eos_person.title," ",eos_person.firstname," ",eos_person.lastname)),CHAR(13),
IF(CHAR_LENGTH(eos_person.address2)>0,CONCAT(eos_person.address2,CHAR(13)),""),
eos_person.street," ",eos_person.housenr,CHAR(13),
eos_person.country," - ",eos_person.zip," ",eos_person.town)listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}email
auto increment
E-Mail
TEXT (127)
R
no
i18n_string"ecs.PERSON.email"table[
"eos_person"
]drvd_selecteos_person.emailfieldset"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_selecteos_person.telephonefieldset"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_selecteos_person.telephone_mobilefieldset"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_selecteos_person.telefaxfieldset"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_selecteos_person.p_invoice_typefieldset"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_selecteos_person.p_invoice_emailfieldset"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_selecteos_person.taxidentfieldset"commercial"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}taxident_status
auto increment
Umsatzsteuer-ID-Status
TEXT
R
yes
input_translatedStatus der Umsatzsteuer-ID des Kundenkontos. Nur Kundenkonten mit bestätigter Umsatzsteuer-ID werden für Netto-Aufträge bei Lieferung in andere EU Länder berücksichtigt.
enum[
"invalid",
"valid_conditional",
"valid_confirmed"
]i18n_string"ecs.PERSON.taxident_status"table[
"eos_person"
]drvd_selecteos_person.taxident_statusfieldset"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_selecteos_person.scorefieldset"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_selecteos_person.score_time_setfieldset"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_selecteos_person.score_time_invalidfieldset"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_selecteos_person.svc_codefieldset"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_selecteos_person.svc_txtfieldset"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_selecteos_person.p_login_usernamefieldset"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_selecteos_person.p_login_pwd_encryptedfieldset"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_selecteos_person.p_login_pwd_keyfieldset"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_selecteos_person.p_login_time_lastfieldset"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_selecteos_person.p_login_pwd_must_renew_afterfieldset"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_selecteos_person.p_login_pwd_key_timeoutfieldset"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_selecteos_person.p_login_pwd_last_renewedfieldset"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_selecteos_person.p_login_activefieldset"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_selecteos_person.p_email_verify_tokenfieldset"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_selecteos_person.p_email_verify_token_timeoutfieldset"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_selecteos_person.p_email_verified_timefieldset"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_selecteos_person.p_login_modefieldset"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_selecteos_person.p_login_2fa_codefieldset"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_selecteos_person.p_login_2fa_timeoutfieldset"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_selecteos_person.p_login_err_countfieldset"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_selecteos_person.p_login_time_minfieldset"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_selecteos_person.p_register_statefieldset"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_selecteos_person.p_register_codefieldset"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_selecteos_person.p_register_code_timeoutfieldset"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_selecteos_person.p_onetime_pwdfieldset"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_selecteos_person.p_onetime_pwd_timeoutfieldset"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_selectIF(eos_person.p_login_active!=1, "disabled", IF(eos_person.p_login_err_count>0 ,IF(eos_person.p_login_time_min>NOW() ,"suspended","retry"),"possible"))listCfg{
"viewMode": 0,
"formatter": {
"type": "status",
"params": {
"statusColorField": "p_login_state_color"
}
},
"fullSearch": false
}formCfg{
"editMode": 0
}p_login_state_color
auto increment
TEXT (15)
R
yes
i18n_string"ecs.PERSON.p_login_state_color"table[
"eos_person"
]drvd_selectIF(eos_person.p_login_active!=1, "#CCCCCC", IF(eos_person.p_login_err_count>0 ,IF(eos_person.p_login_time_min>NOW() ,"#CE0002","#EEAB00"),"#85B200"))listCfg{
"viewMode": 0,
"formatter": {
"type": "color-code"
},
"fullSearch": false
}formCfg{
"editMode": 0
}i18n_string"ecs.PERSON.p_oo_set_label"table[
"eos_person"
]drvd_selecteos_person.p_oo_set_labelfieldset"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_selecteos_person.fk_p_pay_profile_idfieldset"order_options"listCfg{
"viewMode": 3,
"fullSearch": false
}formCfg{
"editMode": 0
}input_translatedEine hier eingetragene Preisgruppe hat Vorrang vor den Preisgruppen-Einstellungen der Kundengruppe und auch den direkt im Produkt gesetzten Staffelpreisen.
i18n_string"ecs.PERSON.fk_p_prcgrp_id"table[
"eos_person"
]drvd_selecteos_person.fk_p_prcgrp_idfieldset"order_options"listCfg{
"viewMode": 3,
"fullSearch": false
}formCfg{
"editMode": 0
}p_price_factor
auto increment
Preis-Faktor
FLOAT (10,4)
R
yes
input_translatedDer angegebene Faktor wird bei allen für den Kunden angezeigten Standard-Preisen als Multiplikator verwendet.
Ein eventuell für die zugehörige Kundengruppe angegebener Preis-Faktor wird durch einen speziell für den Kunden gesetzten Preisfaktor (!= 1) ersetzt.
i18n_string"ecs.PERSON.p_price_factor"table[
"eos_person"
]drvd_selecteos_person.p_price_factorfieldset"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_selecteos_person.p_person_pricesfieldset"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_selecteos_person.fk_p_campidfieldset"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_selecteos_person.p_allow_email_marketingfieldset"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_selectmd5(CONCAT(eos_person.persid,'disallow',eos_person.personid,'emailmarketing',eos_person.time_insert))fieldset"marketing"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}p_ip_address
auto increment
IP-Adresse
TEXT (15)
R
no
i18n_string"ecs.PERSON.p_ip_address"table[
"eos_person"
]drvd_selecteos_person.p_ip_addressfieldset"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_selecteos_person.p_referrerfieldset"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_selecteos_person.p_useragentfieldset"registration"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}p_personid_external
auto increment
Externe Kunden-Nr.
TEXT (127)
R
yes
input_translatedEine externe Kunden-Nr. aus einem anderen System.
i18n_string"ecs.PERSON.p_personid_external"table[
"eos_person"
]drvd_selecteos_person.p_personid_externalfieldset"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_selecteos_person.p_comment_internalfieldset"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_selecteos_person.p_localefieldset"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_selectNULLfieldset"documents"listCfg{
"viewMode": 3,
"fullSearch": false
}formCfg{
"type": "hfyvolumefile",
"options": {
"vol_label": "person_documents",
"vol_primKeyVar": "persid",
"vol_primKey": null
},
"editMode": 0
}time_insert
auto increment
Angelegt am
DATETIME
R
no
i18n_string"insert_time"table[
"eos_person"
]drvd_selecteos_person.time_insertfieldset"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_selecteos_person.user_insertfieldset"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_selecteos_person.time_updatefieldset"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_selecteos_person.user_updatefieldset"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_selectDATE_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_selecteos_person.p_anonymize_timefieldset"sys_record"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}input_translatedVerknüpfen Sie das Kundenkonto mit einem Firmenaccount. Das Kundenkonto wird damit zu einem Unteraccount des Firmenaccounts.
i18n_string"ecs.plugin_companyaccount.fk_p_companyaccount_parent_persid"table[
"eos_person"
]drvd_selecteos_person.fk_p_companyaccount_parent_persidfieldset"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_translatedLegen Sie hier den maximalen Netto-Warenkorb-Wert fest, der durch den Benutzer bestellt werden darf.
i18n_string"ecs.plugin_companyaccount.p_companyaccount_budget_cart_max"table[
"eos_person"
]drvd_selecteos_person.p_companyaccount_budget_cart_maxfieldset"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_translatedStandard Kostenstelle des Kunden.
i18n_string"ecs.plugin_companyaccount.p_companyaccount_cost_center_customer"table[
"eos_person"
]drvd_selecteos_person.p_companyaccount_cost_center_customerfieldset"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_selecteos_person.p_companyaccount_typefieldset"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_selecteos_person.p_companyaccount_xdatafieldset"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_translatedTragen Sie hier das Debitorenkonto für diesen Kunden ein, welches im Buchungsstapel-Export verwendet werden soll.
i18n_string"ecs.ecs_plugin_interface_accounting.p_accounting_debtor_account"table[
"eos_person"
]drvd_selecteos_person.p_accounting_debtor_accountfieldset"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_selecteos_person.fk_pers_inv_reminder_profilelistCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}p_merchant_xdata
auto increment
Anbieter (Zusatzdaten)
DATA
R
yes
input_translatedGeben Sie hier spezifische Informationen an, die für Anbieter relevant sein können (z.B. Kundennummer zu einem Anbieter).
i18n_string"ecs.PERSON.p_merchant_xdata"table[
"eos_person"
]drvd_selecteos_person.p_merchant_xdatafieldset"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_translatedWählen Sie hier die Benutzer-Rollen für den Kunden aus.
i18n_string"ecs.plugin_shopuserright.p_shopuserright_profiles"table[
"eos_person"
]drvd_selecteos_person.p_shopuserright_profileslistCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}p_shopuserright_rights
auto increment
Benutzer-Rechte
TEXT
R
yes
input_translatedTragen Sie hier einzelne Benutzer-Rechte für den Kunden ein.
i18n_string"ecs.plugin_shopuserright.p_shopuserright_rights"table[
"eos_person"
]drvd_selecteos_person.p_shopuserright_rightslistCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}p_login_pwd_plain
auto increment
Neues Passwort
TEXT (64)
R
yes
input_translatedNur ausfüllen, wenn ein neues Passwort vergeben werden soll.
i18n_string"ecs.PERSON.p_login_pwd_plain"table[
"eos_person"
]drvd_selectNULLfieldset"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_selecteos_person.drvd_order_timelastfieldset"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_selecteos_person.drvd_order_timefirstfieldset"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_selecteos_person.drvd_order_frequencyfieldset"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_selecteos_person.drvd_order_countfieldset"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_selecteos_person.p_profile_photofieldset"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_selecteos_person_group.grpidfieldset"base_record"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"type": "hidden",
"editMode": 0
}grp_name
auto increment
Kundengruppe
TEXT (127)
R
no
input_translatedGeben Sie einen aussagekräftigen Namen für die Kundengruppe ein.
i18n_string"ecs.PERSONGRP.grp_name"table[
"eos_person_group"
]drvd_selecteos_person_group.grp_namefieldset"base"listCfg{
"viewMode": 0,
"fullSearch": false,
"depends_on": "fk_p_grpid"
}formCfg{
"mandatory": 1,
"editMode": 0
}description
auto increment
Beschreibung
TEXT
R
no
input_translatedGeben Sie eine Beschreibung der Kundengruppe ein (z.B. für WEN wurde sie angelegt)
i18n_string"ecs.PERSONGRP.description"table[
"eos_person_group"
]drvd_selecteos_person_group.descriptionfieldset"base"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"type": "textarea",
"editMode": 0
}grp_default
auto increment
Default
INT (1)
R
no
input_translatedAktivieren Sie die Checkbox, wenn diese Kundengruppe die Standardgruppe für alle Neuregistrierten Kunden sein soll. Diese werden dann automatisch zugeordnet.
i18n_string"ecs.PERSONGRP.grp_default"table[
"eos_person_group"
]drvd_selecteos_person_group.grp_defaultfieldset"register"listCfg{
"formatter": {
"type": "active-flag"
},
"width": 64,
"viewMode": 0,
"fullSearch": false
}formCfg{
"type": "checkbox",
"editMode": 0
}grp_p_login_active
auto increment
Kundenlogin Default Aktiv
INT (1)
R
no
i18n_string"ecs.PERSONGRP.grp_p_login_active"table[
"eos_person_group"
]drvd_selecteos_person_group.grp_p_login_activefieldset"defaults_person"listCfg{
"formatter": {
"type": "active-flag"
},
"width": 64,
"viewMode": 0,
"fullSearch": false
}formCfg{
"type": "checkbox",
"editMode": 0
}grp_locale
auto increment
Locale Kundengruppe
DATA
R
yes
i18n_string"ecs.PERSONGRP.grp_locale"table[
"eos_person_group"
]drvd_selecteos_person_group.grp_localefieldset"defaults_person"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}grp_state
auto increment
Bestellstatus
TEXT (63)
R
no
input_translatedTragen Sie hier den Eingangsstatus für Bestellung von Kunden aus dieser Kundengruppe ein.
i18n_string"ecs.PERSONGRP.grp_state"table[
"eos_person_group"
]drvd_selecteos_person_group.grp_statefieldset"defaults_order"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}grp_pos
auto increment
POS Channel
TEXT (63)
R
no
input_translatedGeben Sie hier den POS Channel an, für den diese Kundengruppe gelten soll. Lassen Sie dieses Feld leer, so steht die Kundengruppe in allen POS Channels zur Verfügung.
i18n_string"ecs.PERSONGRP.grp_pos"table[
"eos_person_group"
]drvd_selecteos_person_group.grp_posfieldset"defaults_order"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}prc_display_mode
auto increment
Preisanzeige
TEXT (15)
R
no
input_translatedWählen Sie aus, ob die Preise im Shopfrontend für Kunden dieser Gruppe in brutto (also mit einberechneter Umsatzsteuer) oder netto (also ohne einberechnete Umsatzsteuer) angezeigt werden sollen.
i18n_string"ecs.PERSONGRP.prc_display_mode"table[
"eos_person_group"
]drvd_selecteos_person_group.prc_display_modefieldset"prices"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"cssLayout": "col-12",
"type": "eosdropdown",
"options": {
"optI18nValuePrefix": "ecs.prc_display_mode",
"optI18nName": true,
"optI18nSubTitle": true,
"data": {
"options": [
{
"value": "brutto"
},
{
"value": "netto"
}
]
}
},
"editMode": 0
}grp_price_factor
auto increment
Preis-Faktor
FLOAT (10,4)
R
yes
input_translatedDer angegebene Faktor wird bei allen Standard-Shoppreisen als Multiplikator verwendet, wenn Mitglieder dieser Kundengruppe eingeloggt sind. Falls zusätzliche ein Preisfaktor für den Kunden gesetzt wurde oder ein spezifischer Standard-Preis für die Kundengruppe gesetzt ist, wird der Kundengruppen-Preisfaktor ignoriert.
i18n_string"ecs.PERSONGRP.grp_price_factor"table[
"eos_person_group"
]drvd_selecteos_person_group.grp_price_factorfieldset"prices"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"cssLayout": "col-12",
"type": "eosnumber",
"editMode": 0
}input_translatedFalls die gewählte Preisgruppen-Spalte bei einem Produkt nicht gefüllt ist, wird die hier eingetragene Preisgruppe verwendet
i18n_string"ecs.PERSONGRP.fk_grp_prcgrp_id"table[
"eos_person_group"
]drvd_selecteos_person_group.fk_grp_prcgrp_idfieldset"prices"listCfg{
"viewMode": 3,
"fullSearch": false
}formCfg{
"editMode": 0
}grp_persongrp_prices
auto increment
Gruppenspezifische Preise
INT (1)
R
no
i18n_string"ecs.PERSONGRP.grp_persongrp_prices"table[
"eos_person_group"
]drvd_selecteos_person_group.grp_persongrp_pricesfieldset"orderoptions"listCfg{
"formatter": {
"type": "active-flag"
},
"width": 64,
"viewMode": 0,
"fullSearch": false
}formCfg{
"type": "checkbox",
"editMode": 0
}grp_price_col
auto increment
Preisspalte
TEXT (31)
R
yes
input_translatedGeben Sie den Namen einer speziellen Preisspalte an, die für diese Kundengruppe gelten soll. Es werden passend dazu auch Spalten für Discountpreis und Discount-Start/Enddatum erzeugt. Wird dieses Feld nicht definiert, so werden die Standardpreisspalten verwendet.
i18n_string"ecs.PERSONGRP.grp_price_col"table[
"eos_person_group"
]drvd_selecteos_person_group.grp_price_colfieldset"price_col_cfg"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}grp_discount_col
auto increment
Preisspalte (Discount)
TEXT (63)
R
yes
i18n_string"ecs.PERSONGRP.grp_discount_col"table[
"eos_person_group"
]drvd_selectIF(eos_person_group.grp_price_col IS NOT NULL, REPLACE(eos_person_group.grp_price_col,'price_','discount_'),null)listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}grp_discount_start_col
auto increment
Preisspalte (Discount Start)
TEXT (63)
R
yes
i18n_string"ecs.PERSONGRP.grp_discount_start_col"table[
"eos_person_group"
]drvd_selectIF(eos_person_group.grp_price_col IS NOT NULL, REPLACE(eos_person_group.grp_price_col,'price_','discount_start_'),null)listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}grp_discount_end_col
auto increment
Preisspalte (Discount Ende)
TEXT (63)
R
yes
i18n_string"ecs.PERSONGRP.grp_discount_end_col"table[
"eos_person_group"
]drvd_selectIF(eos_person_group.grp_price_col IS NOT NULL, REPLACE(eos_person_group.grp_price_col,'price_','discount_end_'),null)listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}grp_price_dsc_scale_col
auto increment
Preisspalte (Staffelpreise)
TEXT (63)
R
no
i18n_string"ecs.PERSONGRP.grp_price_dsc_scale_col"table[
"eos_person_group"
]drvd_selecteos_person_group.grp_price_dsc_scale_colfieldset"price_col_cfg"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}grp_price_prcgrp_col
auto increment
Preisgruppen-Spalte
TEXT (63)
R
no
input_translatedLegen Sie fest, welche Spalte in den Preisdaten die Preisgruppe für diese Kundengruppe enthält.
i18n_string"ecs.PERSONGRP.grp_price_prcgrp_col"table[
"eos_person_group"
]drvd_selecteos_person_group.grp_price_prcgrp_colfieldset"price_col_cfg"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}grp_price_state_col
auto increment
Spalte für Shop-Status
TEXT (63)
R
no
i18n_string"ecs.PERSONGRP.grp_price_state_col"table[
"eos_person_group"
]drvd_selecteos_person_group.grp_price_state_colfieldset"price_col_cfg"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}grp_price_hide_price_dsp_col
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_selecteos_person_group.grp_price_hide_price_dsp_colfieldset"price_col_cfg"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}input_translatedGeben Sie das Label des Bestelloptionen-Profils an, dass Sie verwenden möchten. Lassen Sie dieses Feld leer, wenn Sie das Standard-Profil nutzen wollen.
i18n_string"ecs.PERSONGRP.grp_oo_set_label"table[
"eos_person_group"
]drvd_selecteos_person_group.grp_oo_set_labelfieldset"orderoptions"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}Zahlungsziel-Profil
INT (11)
R
yes
i18n_string"ecs.PERSONGRP.fk_grp_pay_profile_id"table[
"eos_person_group"
]drvd_selecteos_person_group.fk_grp_pay_profile_idfieldset"orderoptions"listCfg{
"viewMode": 3,
"fullSearch": false
}formCfg{
"editMode": 0
}data
auto increment
Daten
DATA
R
yes
input_translatedGeben Sie hier zusätzliche Daten als Array an.
array(
'var1' => 'wert1',
'var2' => 'wert2',
)
array(
'var1' => 'wert1',
'var2' => 'wert2',
)
i18n_string"ecs.PERSONGRP.data"table[
"eos_person_group"
]drvd_selecteos_person_group.datafieldset"extra"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"cssLayout": "col-12",
"type": "aceeditor",
"options": {
"mode": "json"
},
"editMode": 0
}grp_shopuserright_profiles
auto increment
Gruppen-Rollen
TEXT
R
yes
input_translatedWählen Sie hier die Benutzer-Rollen für die Kundengruppen aus.
i18n_string"ecs.plugin_shopuserright.grp_shopuserright_profiles"table[
"eos_person_group"
]drvd_selecteos_person_group.grp_shopuserright_profileslistCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}grp_shopuserright_rights
auto increment
Gruppen-Rechte
TEXT
R
yes
input_translatedTragen Sie hier einzelne Benutzer-Rechte für die Kundengruppe ein.
i18n_string"ecs.plugin_shopuserright.grp_shopuserright_rights"table[
"eos_person_group"
]drvd_selecteos_person_group.grp_shopuserright_rightslistCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}