delivery - "Lieferung" Model fields
The model consists of the following fields.
Field Name
Display Name
Type
Permissions
Nullable
delivery
did
primary
auto increment
INT (11)
R+W
no
fieldset"base_record"listCfg{
"viewMode": 0
}formCfg{
"type": "hidden"
}dv_seller_name
Verkäufername
TEXT
R+W
no
fieldset"seller_addr"listCfg{
"viewMode": 0
}dv_seller_name2
Adressenzusatz
TEXT
R+W
no
fieldset"seller_addr"listCfg{
"viewMode": 0
}dv_seller_street
Straße
TEXT
R+W
no
fieldset"seller_addr"listCfg{
"viewMode": 0
}formCfg{
"cssLayout": "col-9"
}dv_seller_hnr
Hausnr.
TEXT
R+W
no
fieldset"seller_addr"listCfg{
"viewMode": 0
}formCfg{
"cssLayout": "col-3"
}dv_seller_zip
PLZ
TEXT
R+W
no
fieldset"seller_addr"listCfg{
"viewMode": 0
}formCfg{
"cssLayout": "col-4"
}dv_seller_city
Ort
TEXT
R+W
no
fieldset"seller_addr"listCfg{
"viewMode": 0
}formCfg{
"cssLayout": "col-8"
}dv_seller_state_code
Bundesland (Code) (Verkäufer)
TEXT (15)
R+W
yes
fieldset"seller_addr"listCfg{
"viewMode": 0
}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%}"
}
}
}
}
}
]
}
]
}
}
}fieldset"seller_addr"listCfg{
"viewMode": 0,
"width": 64,
"formatter": {
"type": "country-flag"
}
}formCfg{
"cssLayout": "col-6"
}dv_code
primaryDisplay
Lieferungs-Nr.
TEXT (63)
R+W
no
fieldset"base_record"listCfg{
"fullSearch": true,
"formatter": {
"type": "model-primary",
"params": {
"model": "delivery",
"primaryKey": "did",
"statusColorField": "delivery_state_color",
"subTitleTemplate": "{%dv_name%} {%dv_name2%}"
}
}
}formCfg{
"cssLayout": "col-12 col-md-6 col-xl-3"
}dv_extcode
Sendungsnr.
TEXT (63)
R+W
no
fieldset"base"listCfg{
"viewMode": 0
}formCfg{
"cssLayout": "col-6"
}fieldset"base_record"listCfg{
"viewMode": 0
}formCfg{
"cssLayout": "col-12 col-md-6 col-xl-3"
}fieldset"base_record"listCfg{
"viewMode": 0
}formCfg{
"cssLayout": "col-12 col-md-6 col-xl-3"
}fieldset"base_record"listCfg{
"viewMode": 3
}formCfg{
"cssLayout": "col-12 col-md-6 col-xl-3"
}dv_time_insert
Angelegt am
DATETIME
R+W
no
i18n_string"insert_time"fieldset"sys_record"listCfg{
"viewMode": 0
}formCfg{
"editMode": 2
}dv_time_update
Geändert am
DATETIME
R+W
yes
i18n_string"update_time"fieldset"sys_record"listCfg{
"viewMode": 0
}formCfg{
"editMode": 2
}dv_user_insert
Ersteller
TEXT (127)
R+W
yes
i18n_string"insert_user"fieldset"sys_record"listCfg{
"formatter": {
"type": "user"
},
"viewMode": 0
}formCfg{
"editMode": 2
}dv_user_update
Letzte Änderung durch
TEXT (127)
R+W
yes
i18n_string"update_user"fieldset"sys_record"listCfg{
"viewMode": 0
}formCfg{
"editMode": 2
}dv_time_sent
Versendet am
DATETIME
R+W
yes
fieldset"extra"listCfg{
"viewMode": 0
}formCfg{
"type": "datepicker"
}dv_comment
Kommentar
TEXT
R+W
no
fieldset"extra"listCfg{
"viewMode": 0
}formCfg{
"type": "textarea"
}dv_comment_internal
Interner Kommentar
TEXT
R+W
yes
fieldset"extra"listCfg{
"viewMode": 0
}formCfg{
"type": "textarea"
}dv_name
Name
TEXT
R+W
no
fieldset"dlv_addr"dv_company
Firma
TEXT
R+W
no
fieldset"dlv_addr"listCfg{
"fullSearch": true,
"viewMode": 0
}formCfg{
"cssLayout": "col-6"
}dv_name2
Adressenzusatz
TEXT
R+W
no
fieldset"dlv_addr"listCfg{
"viewMode": 0,
"fullSearch": true
}formCfg{
"cssLayout": "col-6"
}dv_street
Straße
TEXT
R+W
no
fieldset"dlv_addr"listCfg{
"viewMode": 0
}formCfg{
"cssLayout": "col-9"
}dv_hnr
Hausnr.
TEXT
R+W
no
fieldset"dlv_addr"listCfg{
"viewMode": 0
}formCfg{
"cssLayout": "col-3"
}dv_zip
PLZ
TEXT
R+W
no
fieldset"dlv_addr"listCfg{
"viewMode": 0
}formCfg{
"cssLayout": "col-4"
}dv_city
Ort
TEXT
R+W
no
fieldset"dlv_addr"listCfg{
"fullSearch": true,
"viewMode": 0
}formCfg{
"cssLayout": "col-8"
}dv_state_code
Bundesland (Code)
TEXT (15)
R+W
yes
fieldset"dlv_addr"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%}"
}
}
}
}
}
]
}
]
}
}
}fieldset"dlv_addr"listCfg{
"viewMode": 0,
"width": 64,
"formatter": {
"type": "country-flag"
}
}formCfg{
"cssLayout": "col-6"
}dv_phone
Telefon
TEXT
R+W
no
fieldset"dlv_addr"listCfg{
"viewMode": 0
}drvd_dv_seller_street_hnr
Straße+Nr (Verkäufer)
TEXT
R
no
drvd_selectCONCAT_WS("",ecs_delivery.dv_seller_street," ",ecs_delivery.dv_seller_hnr)listCfg{
"viewMode": 0
}formCfg{
"editMode": 0
}drvd_dv_street_hnr
Straße+Nr (L)
TEXT
R
no
drvd_selectCONCAT_WS("",ecs_delivery.dv_street," ",ecs_delivery.dv_hnr)listCfg{
"viewMode": 0
}formCfg{
"editMode": 0
}drvd_dv_cnt_dvi
Anzahl Lagerartikel
FLOAT (13,4)
R
no
table[
"ecs_deliveryitem"
]drvd_selectSUM(ecs_deliveryitem.dvi_cnt)/IF(COUNT(ecs_deliveryitem.dviid),(COUNT(ecs_delivery.did) /COUNT(DISTINCT ecs_deliveryitem.dviid)),1) listCfg{
"sumType": "SV"
}formCfg{
"editMode": 0
}delivery_state_color
TEXT (15)
R
no
table[
"eos_states"
]drvd_selecteos_states.st_colorlistCfg{
"viewMode": 0
}formCfg{
"editMode": 0
}item_id
INT
R
no
drvd_selectecs_delivery.didlistCfg{
"viewMode": 3
}formCfg{
"editMode": 0
}i18n_st_name
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"
}
}
}formCfg{
"editMode": 0
}i18n_st_name_public
Ö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"
}
}
}formCfg{
"editMode": 0
}st_x_dv_sent
INT (4)
R
no
table[
"eos_states"
]drvd_selecteos_states.st_x_dv_sentlistCfg{
"viewMode": 3
}formCfg{
"editMode": 0
}st_code
Status
TEXT
R
no
table[
"eos_states"
]drvd_selecteos_states.st_codelistCfg{
"viewMode": 3
}formCfg{
"editMode": 0
}st_position
INT
R
no
table[
"eos_states"
]drvd_selecteos_states.st_positionlistCfg{
"viewMode": 3
}formCfg{
"editMode": 0
}is_current
INT (1)
R+W
no
table[
"eos_statelog"
]listCfg{
"viewMode": 3
}formCfg{
"editMode": 0
}transtime
DATETIME
R+W
no
table[
"eos_statelog"
]listCfg{
"viewMode": 0
}formCfg{
"editMode": 0
}node_id
INT (11)
R+W
yes
table[
"ewh_nstgrp_item2node"
]listCfg{
"viewMode": 3
}formCfg{
"editMode": 0
}drvd_dv_dvi_si_weight
Gewicht (kg)
FLOAT (13,4)
R
no
table[
"ewh_nstgrp_item2node"
]drvd_selectIF(COUNT(ewh_nstgrp_item2node.si_weight) < COUNT(*),NULL,(SUM(ecs_deliveryitem.dvi_cnt * ewh_nstgrp_item2node.si_weight)))/IF(COUNT(ecs_deliveryitem.dviid),(COUNT(ecs_delivery.did) /COUNT(DISTINCT ecs_deliveryitem.dviid)),1) listCfg{
"viewMode": 0,
"sumType": "SV"
}formCfg{
"editMode": 0
}drvd_dv_dvi_si_available_confirm_date
DATETIME
R
yes
table[
"ewh_nstgrp_item2node"
]drvd_selectMAX(IF(ewh_nstgrp_item2node.si_preconfirm_incoming != 1, ewh_nstgrp_item2node.si_time_available,null))listCfg{
"viewMode": 0
}formCfg{
"editMode": 0
}i18n_string"ecs_plugin_ewarehouse.DELIVERY.ps_name"table"ecs_delivery"i18n_string"ecs_plugin_ewarehouse.DELIVERY.fk_dv_dgrp_id"table"ecs_delivery"dv_cost_total_ship
Versandkosten
FLOAT (13,2)
R+W
yes
i18n_string"ecs_plugin_ewarehouse.DELIVERY.dv_cost_total_ship"dv_cost_total_purchase
Artikel-Einkaufskosten
FLOAT (13,2)
R+W
yes
i18n_string"ecs_plugin_ewarehouse.DELIVERY.dv_cost_total_purchase"dv_time_rsvd
Reserviert am
DATETIME
R+W
yes
i18n_string"ecs_plugin_ewarehouse.DELIVERY.dv_time_rsvd"dv_time_transfer
Transferiert am
DATETIME
R+W
yes
i18n_string"ecs_plugin_ewarehouse.DELIVERY.dv_time_transfer"listCfg{
"viewMode": 0
}formCfg{
"editMode": 0
}dv_time_planned_send
Geplante Sendezeit
DATETIME
R+W
yes
i18n_string"ecs_plugin_ewarehouse.DELIVERY.dv_time_planned_send"drvd_dv_cnt_dvi_reserved
Reserviert
FLOAT (13,4)
R
no
i18n_string"ecs_plugin_ewarehouse.DELIVERY.drvd_dv_cnt_dvi_reserved"table"ecs_deliveryitem"drvd_selectSUM(ecs_deliveryitem.dvi_rsvd_cnt)/IF(COUNT(ecs_deliveryitem.dviid),(COUNT(ecs_delivery.did) /COUNT(DISTINCT ecs_deliveryitem.dviid)),1) listCfg{
"viewMode": 0,
"sumType": "SV"
}formCfg{
"editMode": 0
}drvd_dv_cnt_dvi_not_reserved
Nicht reserviert
FLOAT (13,4)
R
no
i18n_string"ecs_plugin_ewarehouse.DELIVERY.drvd_dv_cnt_dvi_not_reserved"table[
"ecs_delivery",
"ecs_deliveryitem"
]drvd_selectIF(ecs_delivery.dv_time_sent IS NOT NULL,0,(SUM(ecs_deliveryitem.dvi_cnt) - SUM(ecs_deliveryitem.dvi_rsvd_cnt))/IF(COUNT(ecs_deliveryitem.dviid),(COUNT(ecs_delivery.did) /COUNT(DISTINCT ecs_deliveryitem.dviid)),1) )listCfg{
"viewMode": 0,
"sumType": "SV"
}formCfg{
"editMode": 0
}drvd_dv_cnt_dvi_reserved_confirmed
Reserviert (bestätigt)
FLOAT (13,4)
R
no
i18n_string"ecs_plugin_ewarehouse.DELIVERY.drvd_dv_cnt_dvi_reserved_confirmed"table"ecs_deliveryitem"drvd_selectSUM(ecs_deliveryitem.dvi_rsvd_confirmed_cnt)/IF(COUNT(ecs_deliveryitem.dviid),(COUNT(ecs_delivery.did) /COUNT(DISTINCT ecs_deliveryitem.dviid)),1) listCfg{
"viewMode": 0,
"sumType": "SV"
}formCfg{
"editMode": 0
}drvd_dv_cnt_dvi_not_reserved_confirmed
Nicht reserviert (bestätigt)
FLOAT (13,4)
R
no
i18n_string"ecs_plugin_ewarehouse.DELIVERY.drvd_dv_cnt_dvi_not_reserved_confirmed"table[
"ecs_delivery",
"ecs_deliveryitem"
]drvd_selectIF(ecs_delivery.dv_time_sent IS NOT NULL,0,(SUM(ecs_deliveryitem.dvi_cnt) - SUM(ecs_deliveryitem.dvi_rsvd_confirmed_cnt))/IF(COUNT(ecs_deliveryitem.dviid),(COUNT(ecs_delivery.did) /COUNT(DISTINCT ecs_deliveryitem.dviid)),1) )listCfg{
"viewMode": 0,
"sumType": "SV"
}formCfg{
"editMode": 0
}drvd_dvi_items_info
Lieferartikel
TEXT
R
no
i18n_string"ecs_plugin_ewarehouse.DELIVERY.drvd_dvi_items_info"table"ecs_deliveryitem"drvd_selectGROUP_CONCAT(DISTINCT CONCAT(IF(ecs_deliveryitem.fk_dvi_item_id IS NOT NULL,ecs_deliveryitem.fk_dvi_item_id,""),"|",ecs_deliveryitem.dvi_pcode,"|",ecs_deliveryitem.dvi_cnt,"|",ecs_deliveryitem.dvi_rsvd_cnt,"|",ecs_deliveryitem.dvi_rsvd_confirmed_cnt) SEPARATOR "#")listCfg{
"viewMode": 0,
"sortable": 0
}formCfg{
"editMode": 0
}dgrp_id
INT (11)
R+W
no
i18n_string"ecs_plugin_ewarehouse.DELIVERYGROUP.dgrp_id"table"ewh_delivery_group"listCfg{
"viewMode": 3
}formCfg{
"editMode": 0
}dgrp_code
Versandliste
TEXT (27)
R+W
yes
i18n_string"ecs_plugin_ewarehouse.DELIVERYGROUP.dgrp_code"table"ewh_delivery_group"listCfg{
"viewMode": 0,
"fullSearch": true
}formCfg{
"editMode": 0
}dgrp_time_sent
Lieferdatum
DATETIME
R+W
yes
i18n_string"ecs_plugin_ewarehouse.DELIVERYGROUP.dgrp_time_sent"table"ewh_delivery_group"listCfg{
"viewMode": 0
}formCfg{
"editMode": 0
}st_x_dv_reqtopick
INT (4)
R
no
table[
"eos_statelog",
"eos_states",
"eos_statesets"
]drvd_selecteos_states.st_x_dv_reqtopicklistCfg{
"viewMode": 3
}formCfg{
"editMode": 0
}st_x_dv_inpicking
INT (4)
R
no
table[
"eos_statelog",
"eos_states",
"eos_statesets"
]drvd_selecteos_states.st_x_dv_inpickinglistCfg{
"viewMode": 3
}formCfg{
"editMode": 0
}st_x_dv_delivered
INT (4)
R
no
table[
"eos_statelog",
"eos_states",
"eos_statesets"
]drvd_selecteos_states.st_x_dv_deliveredlistCfg{
"viewMode": 3
}formCfg{
"editMode": 0
}st_x_dv_unrsvd
INT (4)
R
no
table[
"eos_statelog",
"eos_states",
"eos_statesets"
]drvd_selecteos_states.st_x_dv_unrsvdlistCfg{
"viewMode": 3
}formCfg{
"editMode": 0
}st_x_dv_rsvd
INT (4)
R
no
table[
"eos_statelog",
"eos_states",
"eos_statesets"
]drvd_selecteos_states.st_x_dv_rsvdlistCfg{
"viewMode": 3
}formCfg{
"editMode": 0
}st_x_dv_sendable
INT (4)
R
no
table[
"eos_statelog",
"eos_states",
"eos_statesets"
]drvd_selecteos_states.st_x_dv_sendablelistCfg{
"viewMode": 3
}formCfg{
"editMode": 0
}fieldset"base"listCfg{
"viewMode": 0
}formCfg{
"cssLayout": "col-6"
}dv_carrier_time_pickedup
Abgeholt am (laut Logistiker)
DATETIME
R+W
yes
fieldset"base"listCfg{
"viewMode": 0
}formCfg{
"cssLayout": "col-3",
"editMode": 2
}dv_carrier_time_delivered
Geliefert am (laut Logistiker)
DATETIME
R+W
yes
fieldset"base"listCfg{
"viewMode": 0
}formCfg{
"cssLayout": "col-3",
"editMode": 2
}dv_carrier_status
Logistiker-Sendungsstatus
TEXT
R+W
yes
fieldset"base"listCfg{
"viewMode": 0
}formCfg{
"cssLayout": "col-6",
"editMode": 2
}dv_carrier_id
Logistiker externe ID
TEXT (63)
R+W
yes
listCfg{
"viewMode": 0
}formCfg{
"editMode": 0
}dv_shipping_details
Detail-Daten
DATA
R+W
yes
fieldset"extra"listCfg{
"viewMode": 0
}formCfg{
"cssLayout": "col-12",
"type": "aceeditor",
"options": {
"mode": "json"
}
}drvd_dv_trace_url
Sendung verfolgen
TEXT
R
no
table[
"ecs_delivery",
"ecs_shp_carrier"
]drvd_selectIF((ecs_delivery.dv_extcode is not null AND ecs_shp_carrier.shp_c_track_url is not null),
REPLACE(ecs_shp_carrier.shp_c_track_url, '{dv_extcode}', ecs_delivery.dv_extcode),null)listCfg{
"formatter": {
"type": "url",
"params": {
"text": "Sendung verfolgen",
"iconLabel": "hublify\/link-external"
}
}
}formCfg{
"editMode": 0
}drvd_shipping_label_url
Versandlabel
TEXT
R
no
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"
}
}
}formCfg{
"editMode": 0
}drvd_customs_declaration_url
Zollerklärung
TEXT
R
no
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"
}
}
}formCfg{
"editMode": 0
}drvd_dv_state_name
Bundesland (Name)
TEXT
R
no
table[
"dv_terr_state"
]drvd_selectdv_terr_state.terr_namelistCfg{
"viewMode": 0
}formCfg{
"editMode": 0
}drvd_dv_state_path
Bundesland (Pfad)
TEXT
R
no
table[
"dv_terr_state"
]drvd_selectdv_terr_state.i18n_node_path_DElistCfg{
"viewMode": 0
}formCfg{
"editMode": 0
}drvd_dv_seller_state_name
Bundesland (Name) (Verkäufer)
TEXT
R
no
table[
"dv_seller_terr_state"
]drvd_selectdv_seller_terr_state.terr_namelistCfg{
"viewMode": 0
}formCfg{
"editMode": 0
}drvd_dv_seller_state_path
Bundesland (Pfad) (Verkäufer)
TEXT
R
no
table[
"dv_seller_terr_state"
]drvd_selectdv_seller_terr_state.i18n_node_path_DElistCfg{
"viewMode": 0
}formCfg{
"editMode": 0
}drvd_dv_dvi_weight
Gewicht (kg)
FLOAT
R
no
table[
"ecs_deliveryitem",
"excdb_data_ecs_product_de"
]drvd_selectIF(COUNT(excdb_data_ecs_product_de.prd_weight) < COUNT(*),NULL,(SUM(ecs_deliveryitem.dvi_cnt * excdb_data_ecs_product_de.prd_weight)/1000))/IF(COUNT(ecs_deliveryitem.dviid),(COUNT(ecs_delivery.did) /COUNT(DISTINCT ecs_deliveryitem.dviid)),1) listCfg{
"viewMode": 0
}formCfg{
"editMode": 0
}drvd_dv_itemlist
TEXT
R
no
table[
"ecs_deliveryitem"
]drvd_selectGROUP_CONCAT(distinct CONCAT_WS("|", ecs_deliveryitem.dvi_pcode,ecs_deliveryitem.dvi_name,ecs_deliveryitem.dvi_cnt) ORDER BY ecs_deliveryitem.dvi_pcode ASC SEPARATOR "###")listCfg{
"viewMode": 0
}formCfg{
"editMode": 0
}drvd_inv_info
Rechnungen zum Auftrag
DATA
R
yes
table"ecs_invoice"drvd_selectCONCAT("{\"model\": \"invoice\",\"primaryKey\": \"inv_id\",\"displayKey\": \"inv_code\",\"data\": [",
GROUP_CONCAT(DISTINCT IF(ecs_invoice.inv_id IS NULL, null, JSON_OBJECT(
'inv_id',ecs_invoice.inv_id,
'inv_code',ecs_invoice.inv_code,
'inv_time_invoice', ecs_invoice.inv_time_invoice,
'inv_amount',ecs_invoice.inv_amount,
'inv_status_color',CASE ecs_invoice.inv_status WHEN "open" THEN "#CE0002" WHEN "done" THEN "#85B200" ELSE NULL END
)) ORDER BY ecs_invoice.inv_id ASC SEPARATOR ","),"]}")listCfg{
"viewMode": 0,
"formatter": {
"type": "sub-data-chip",
"params": {
"chipOptions": {
"subTitleTemplate": "{% inv_amount|money(2) %} \u20ac ({% inv_time_invoice|date() %})",
"statusColorField": "inv_status_color"
}
}
}
}formCfg{
"editMode": 0
}drvd_inv_codes
Rg.Nummern zum Auftrag
TEXT
R
no
table"ecs_invoice"drvd_selectGROUP_CONCAT(DISTINCT ecs_invoice.inv_code)listCfg{
"viewMode": 0
}formCfg{
"editMode": 0
}inv_code
TEXT
R+W
no
table"ecs_invoice"listCfg{
"viewMode": 3
}formCfg{
"editMode": 0
}drvd_inv_amount_total
Gesamtrechnungsbetrag zum Auftrag
FLOAT
R
no
table[
"ecs_invoice"
]drvd_selectSUM(ecs_invoice.inv_amount)/IF (count(ecs_invoice.inv_id), (count(ecs_delivery.did)/count(distinct ecs_invoice.inv_id)),1)listCfg{
"viewMode": 3
}formCfg{
"editMode": 0
}drvd_inv_amount_not_paid
Ausstehender Rechnungsbetrag für den Auftrag
FLOAT
R
no
table[
"ecs_invoice"
]drvd_selectSUM(IF(ecs_invoice.inv_status='open', ecs_invoice.inv_amount-ecs_invoice.inv_amount_paid,0.00))/IF (count(ecs_invoice.inv_id), (count(ecs_delivery.did)/count(distinct ecs_invoice.inv_id)),1)listCfg{
"viewMode": 0
}formCfg{
"editMode": 0
}drvd_dv_info_others
Weitere Lieferungen zum Auftrag
TEXT
R
no
table[
"ecs_delivery_others"
]drvd_selectGROUP_CONCAT(DISTINCT CONCAT(ecs_delivery_others.dv_code,'|',ecs_delivery_others.did) SEPARATOR '###')listCfg{
"viewMode": 0
}formCfg{
"editMode": 0
}drvd_dv_codes_others
Weitere Lfg.Nummern zum Auftrag
TEXT
R
no
table[
"ecs_delivery_others"
]drvd_selectGROUP_CONCAT(DISTINCT ecs_delivery_others.dv_code)listCfg{
"viewMode": 0
}formCfg{
"editMode": 0
}order
Following fields can also be selected for reading (JOIN)
oid
OID
INT (11)
R
no
i18n_string"ecs.ORDER.oid"table[
"eos_order"
]fieldset"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"
]fieldset"marketing"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}orderid
Auftrags-Nr.
TEXT (63)
R
no
i18n_string"ecs.ORDER.orderid"table[
"eos_order"
]fieldset"base_record"listCfg{
"fullSearch": false,
"formatter": {
"type": "model-primary",
"params": {
"model": "order",
"primaryKey": "oid",
"statusColorField": "order_state_color",
"subTitleTemplate": "{%invoice_firstname%} {%invoice_lastname%}"
}
},
"viewMode": 1,
"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"
]fieldset"base_record"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"cssLayout": "col-12 col-md-6 col-xl-3",
"mandatory": true,
"editMode": 0
}o_time_ordered
Bestelldatum
DATETIME
R
yes
i18n_string"ecs.ORDER.o_time_ordered"table[
"eos_order"
]fieldset"base_record"listCfg{
"formatter": {
"type": "date"
},
"viewMode": 0,
"fullSearch": false
}formCfg{
"cssLayout": "col-12 col-md-6 col-xl-3",
"editMode": 0
}total_netto
[EUR]
∑ Gesamt, Netto
FLOAT (13,2)
R
no
i18n_string"ecs.ORDER.total_netto"table[
"eos_order"
]listCfg{
"formatter": {
"type": "currency"
},
"viewMode": 0,
"sumType": "SV",
"fullSearch": false
}formCfg{
"editMode": 0
}total_brutto
[EUR]
∑ Gesamt, Brutto
FLOAT (13,2)
R
no
i18n_string"ecs.ORDER.total_brutto"table[
"eos_order"
]listCfg{
"formatter": {
"type": "currency"
},
"sumType": "SV",
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}o_orderid_external
Externe Auftrags-Nr.
TEXT (255)
R
yes
input_translatedGeben Sie hier ggf. eine externe erhaltene Auftragsnummer ein. Diese bekommen Sie z.B. wenn der Auftrag über einen externen Marktplatz (z.B. Amazon Marketplace) erstellt wurde.
i18n_string"ecs.ORDER.o_orderid_external"table[
"eos_order"
]fieldset"base"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"cssLayout": "col-12 col-md-6 col-xl-3",
"editMode": 0
}i18n_string"ecs.ORDER.fk_o_posid"table[
"eos_order"
]fieldset"base"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"cssLayout": "col-12 col-md-6 col-xl-3",
"editMode": 0
}i18n_string"ecs.ORDER.fk_o_stid"table[
"eos_order"
]fieldset"base"listCfg{
"viewMode": 3,
"fullSearch": false
}formCfg{
"cssLayout": "col-12 col-md-6 col-xl-3",
"editMode": 0
}i18n_string"ecs.ORDER.fk_o_st_id"table[
"eos_order"
]fieldset"base"listCfg{
"viewMode": 3,
"fullSearch": false
}formCfg{
"cssLayout": "col-12 col-md-6 col-xl-3",
"editMode": 0
}o_pers_reftext
Kunden-Referenztext
TEXT
R
yes
input_translatedGeben Sie einen Referenztext des Kunden ein.
i18n_string"ecs.ORDER.o_pers_reftext"table[
"eos_order"
]listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}o_pers_seq_nr
Auftrags-Sequenz-Nr.
INT (11)
R
no
i18n_string"ecs.ORDER.o_pers_seq_nr"table[
"eos_order"
]listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}quantity
Bestellmenge
FLOAT (13,4)
R
no
i18n_string"ecs.ORDER.quantity"table[
"eos_order"
]listCfg{
"viewMode": 0,
"sumType": "SV",
"fullSearch": false
}formCfg{
"editMode": 0
}drvd_total_vat
[EUR]
MwSt. (Gesamt)
FLOAT (13,2)
R
no
i18n_string"ecs.ORDER.drvd_total_vat"table[
"eos_order"
]drvd_selectROUND(eos_order.total_brutto - eos_order.total_netto, 2)listCfg{
"formatter": {
"type": "currency"
},
"viewMode": 0,
"sumType": "SV",
"fullSearch": false
}formCfg{
"editMode": 0
}currency
Währung
TEXT (3)
R
no
i18n_string"ecs.ORDER.currency"table[
"eos_order"
]listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}otitle
Auftragstitel
TEXT
R
yes
input_translatedGeben Sie dem Auftrag einen Titel.
i18n_string"ecs.ORDER.otitle"table[
"eos_order"
]fieldset"doc_header"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"cssLayout": "col-12",
"editMode": 0
}otext
Auftragsbeschreibung
TEXT
R
yes
i18n_string"ecs.ORDER.otext"table[
"eos_order"
]fieldset"extra"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"type": "textarea",
"editMode": 0
}o_type
Auftragstyp
TEXT (15)
R
yes
enum[
"order",
"offer"
]i18n_string"ecs.ORDER.o_type"table[
"eos_order"
]fieldset"base_record"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"cssLayout": "col-12 col-md-6 col-xl-3",
"type": "eosdropdown",
"value": "order",
"options": {
"optI18nValuePrefix": "ecs.o_type",
"optI18nName": true,
"data": {
"options": [
{
"value": "order"
},
{
"value": "offer"
},
{
"value": "tpl"
}
]
}
},
"editMode": 0
}o_valid_until
Gültig bis
DATETIME
R
yes
i18n_string"ecs.ORDER.o_valid_until"table[
"eos_order"
]listCfg{
"viewMode": 0,
"formatter": {
"type": "date"
},
"fullSearch": false
}formCfg{
"type": "datetimepicker",
"editMode": 0
}o_txt_header
Kopf-Text
TEXT
R
yes
input_translatedKopf-Text für die Verwendung in PDFs
i18n_string"ecs.ORDER.o_txt_header"table[
"eos_order"
]fieldset"doc_header"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"fieldSetCol": "12",
"type": "eoseditor",
"editMode": 0
}invoice_addr_preset
Adressbuch (R)
TEXT
R
yes
i18n_string"ecs.ORDER.invoice_addr_preset"table[
"eos_order"
]drvd_selectNULLfieldset"inv_addr"listCfg{
"viewMode": 3,
"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
Anrede (R)
TEXT
R
yes
enum[
"female",
"male",
"company",
"divers"
]i18n_string"ecs.ORDER.invoice_gender"table[
"eos_order"
]fieldset"inv_addr"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"cssLayout": "col-6 col-xl-2",
"type": "eosdropdown",
"options": {
"optI18nValuePrefix": "ecs.gender",
"optI18nName": true,
"data": {
"options": [
{
"value": null
},
{
"value": "female"
},
{
"value": "male"
},
{
"value": "company"
},
{
"value": "divers"
}
]
},
"observer": {
"fields": [
{
"field": "invoice_addr_preset",
"trigger": "onChange",
"exec": [
{
"cmd": "template",
"params": {
"tpl": "{% FIELD.value.data.adr_gender %}"
}
}
]
}
]
}
},
"editMode": 0
}invoice_title
Titel (R)
TEXT
R
no
i18n_string"ecs.ORDER.invoice_title"table[
"eos_order"
]fieldset"inv_addr"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"cssLayout": "col-6 col-xl-2",
"type": "text",
"options": {
"observer": {
"fields": [
{
"field": "invoice_addr_preset",
"trigger": "onChange",
"exec": [
{
"cmd": "template",
"params": {
"tpl": "{% FIELD.value.data.adr_title %}"
}
}
]
}
]
}
},
"editMode": 0
}invoice_firstname
Vorname (R)
TEXT
R
no
i18n_string"ecs.ORDER.invoice_firstname"table[
"eos_order"
]fieldset"inv_addr"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"cssLayout": "col-6 col-xl-4",
"type": "text",
"options": {
"observer": {
"fields": [
{
"field": "invoice_addr_preset",
"trigger": "onChange",
"exec": [
{
"cmd": "template",
"params": {
"tpl": "{% FIELD.value.data.adr_firstname%}"
}
}
]
}
]
}
},
"editMode": 0
}invoice_lastname
Nachname (R)
TEXT
R
no
i18n_string"ecs.ORDER.invoice_lastname"table[
"eos_order"
]fieldset"inv_addr"listCfg{
"fullSearch": false,
"viewMode": 0
}formCfg{
"cssLayout": "col-6 col-xl-4",
"type": "text",
"options": {
"observer": {
"fields": [
{
"field": "invoice_addr_preset",
"trigger": "onChange",
"exec": [
{
"cmd": "template",
"params": {
"tpl": "{% FIELD.value.data.adr_lastname %}"
}
}
]
}
]
}
},
"editMode": 0
}invoice_company
Firma (R)
TEXT
R
no
i18n_string"ecs.ORDER.invoice_company"table[
"eos_order"
]fieldset"inv_addr"listCfg{
"fullSearch": false,
"viewMode": 0
}formCfg{
"cssLayout": "col-6",
"type": "text",
"options": {
"observer": {
"fields": [
{
"field": "invoice_addr_preset",
"trigger": "onChange",
"exec": [
{
"cmd": "template",
"params": {
"tpl": "{% FIELD.value.data.adr_company %}"
}
}
]
}
]
}
},
"editMode": 0
}invoice_addrextra
Adressenzusatz
TEXT
R
no
i18n_string"ecs.ORDER.invoice_addrextra"table[
"eos_order"
]fieldset"inv_addr"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"cssLayout": "col-6",
"type": "text",
"options": {
"observer": {
"fields": [
{
"field": "invoice_addr_preset",
"trigger": "onChange",
"exec": [
{
"cmd": "template",
"params": {
"tpl": "{% FIELD.value.data.adr_extra1 %}"
}
}
]
}
]
}
},
"editMode": 0
}invoice_street
Straße (R)
TEXT
R
no
i18n_string"ecs.ORDER.invoice_street"table[
"eos_order"
]fieldset"inv_addr"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"cssLayout": "col-9",
"type": "text",
"options": {
"observer": {
"fields": [
{
"field": "invoice_addr_preset",
"trigger": "onChange",
"exec": [
{
"cmd": "template",
"params": {
"tpl": "{% FIELD.value.data.adr_street %}"
}
}
]
}
]
}
},
"editMode": 0
}invoice_housenr
Hausnummer (R)
TEXT
R
no
i18n_string"ecs.ORDER.invoice_housenr"table[
"eos_order"
]fieldset"inv_addr"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"cssLayout": "col-3",
"type": "text",
"options": {
"observer": {
"fields": [
{
"field": "invoice_addr_preset",
"trigger": "onChange",
"exec": [
{
"cmd": "template",
"params": {
"tpl": "{% FIELD.value.data.adr_housenr %}"
}
}
]
}
]
}
},
"editMode": 0
}invoice_zip
PLZ (R)
TEXT
R
no
i18n_string"ecs.ORDER.invoice_zip"table[
"eos_order"
]fieldset"inv_addr"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"cssLayout": "col-4",
"type": "text",
"options": {
"observer": {
"fields": [
{
"field": "invoice_addr_preset",
"trigger": "onChange",
"exec": [
{
"cmd": "template",
"params": {
"tpl": "{% FIELD.value.data.adr_zip %}"
}
}
]
}
]
}
},
"editMode": 0
}invoice_town
Ort (R)
TEXT
R
no
i18n_string"ecs.ORDER.invoice_town"table[
"eos_order"
]fieldset"inv_addr"listCfg{
"fullSearch": false,
"viewMode": 0
}formCfg{
"cssLayout": "col-8",
"type": "text",
"options": {
"observer": {
"fields": [
{
"field": "invoice_addr_preset",
"trigger": "onChange",
"exec": [
{
"cmd": "template",
"params": {
"tpl": "{% FIELD.value.data.adr_town %}"
}
}
]
}
]
}
},
"editMode": 0
}invoice_state_code
Bundesland (Code) (R)
TEXT (15)
R
yes
i18n_string"ecs.ORDER.invoice_state_code"table[
"eos_order"
]fieldset"inv_addr"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"cssLayout": "col-6",
"type": "eosdropdown",
"options": {
"dataStreamCall": {
"method": "state_getlist"
},
"serverSideSearch": false,
"optValueField": "terr_code",
"optNameField": "terr_name",
"optExtraField": "terr_code",
"observer": {
"fields": [
{
"field": "invoice_addr_preset",
"trigger": "onChange",
"exec": [
{
"cmd": "template",
"params": {
"tpl": "{%FIELD.value.data.adr_state_code%}"
}
}
]
},
{
"field": "invoice_country",
"trigger": "onInit",
"exec": [
{
"cmd": "loadOptions",
"params": {
"dataStreamCall": {
"method": "state_getlist",
"params": {
"filter": {
"state_country": "{%FIELD.value%}"
}
}
}
}
}
]
},
{
"field": "invoice_country",
"trigger": "onChange",
"exec": [
{
"cmd": "loadOptions",
"params": {
"dataStreamCall": {
"method": "state_getlist",
"params": {
"filter": {
"state_country": "{%FIELD.value%}"
}
}
}
}
}
]
}
]
}
},
"editMode": 0
}i18n_string"ecs.ORDER.invoice_country"table[
"eos_order"
]fieldset"inv_addr"listCfg{
"viewMode": 0,
"formatter": {
"type": "country-flag"
},
"fullSearch": false
}formCfg{
"cssLayout": "col-6",
"options": {
"observer": {
"fields": [
{
"field": "invoice_addr_preset",
"trigger": "onChange",
"exec": [
{
"cmd": "template",
"params": {
"tpl": "{% FIELD.value.data.adr_country %}"
}
}
]
}
]
}
},
"editMode": 0
}invoice_type
Rechnungsart
TEXT
R
yes
enum[
"noncommercial",
"commercial"
]i18n_string"ecs.ORDER.invoice_type"table[
"eos_order"
]fieldset"inv_extra"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"cssLayout": "col-4",
"type": "eosdropdown",
"options": {
"optI18nValuePrefix": "ecs.invoice_type",
"optI18nName": true,
"data": {
"options": [
{
"value": "noncommercial"
},
{
"value": "commercial"
}
]
}
},
"editMode": 0
}invoice_email
E-Mail (R)
TEXT
R
no
i18n_string"ecs.ORDER.invoice_email"table[
"eos_order"
]fieldset"inv_extra"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"cssLayout": "col-4",
"editMode": 0
}invoice_taxidentnumber
USt.ID-Nr.
TEXT
R
no
i18n_string"ecs.ORDER.invoice_taxidentnumber"table[
"eos_order"
]fieldset"inv_extra"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"cssLayout": "col-4",
"editMode": 0
}invoice_taxident_status
USt.ID-Nr. Status
TEXT
R
yes
enum[
"invalid",
"valid_conditional",
"valid_confirmed"
]i18n_string"ecs.ORDER.invoice_taxident_status"table[
"eos_order"
]fieldset"inv_extra"listCfg{
"viewMode": 0,
"formatter": {
"type": "status"
},
"fullSearch": false
}formCfg{
"type": "eosdropdown",
"options": {
"optI18nValuePrefix": "ecs.taxident_status",
"optI18nName": true,
"data": {
"options": [
{
"value": null
},
{
"value": "invalid"
},
{
"value": "valid_conditional"
},
{
"value": "valid_confirmed"
}
]
}
},
"editMode": 0
}invoice_third_country_export
Ausfuhrbescheinigung
TEXT
R
yes
enum[
"none",
"certificate_promised",
"certificate_received"
]i18n_string"ecs.ORDER.invoice_third_country_export"table[
"eos_order"
]fieldset"inv_extra"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"type": "eosdropdown",
"options": {
"optI18nValuePrefix": "ecs.invoice_third_country_export",
"optI18nName": true,
"data": {
"options": [
{
"value": "none"
},
{
"value": "certificate_promised"
},
{
"value": "certificate_received"
}
]
}
},
"editMode": 0
}invoice_lang_iso
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"
]fieldset"inv_extra"listCfg{
"viewMode": 0,
"formatter": {
"type": "country-flag"
},
"fullSearch": false
}formCfg{
"editMode": 0
}drvd_invoice_street_housenr
Straße+Nr (R)
TEXT
R
no
i18n_string"ecs.ORDER.drvd_invoice_street_housenr"table[
"eos_order"
]drvd_selectCONCAT_WS("",eos_order.invoice_street," ",eos_order.invoice_housenr)listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}deliver_addr_preset
Adressbuch (L)
DATA
R
yes
i18n_string"ecs.ORDER.deliver_addr_preset"table[
"eos_order"
]drvd_selectNULLfieldset"dlv_addr"listCfg{
"viewMode": 3,
"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
Anrede (L)
TEXT
R
yes
enum[
"female",
"male",
"company",
"divers"
]i18n_string"ecs.ORDER.deliver_gender"table[
"eos_order"
]fieldset"dlv_addr"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"cssLayout": "col-6 col-xl-2",
"type": "eosdropdown",
"options": {
"optI18nValuePrefix": "ecs.gender",
"optI18nName": true,
"data": {
"options": [
{
"value": null
},
{
"value": "female"
},
{
"value": "male"
},
{
"value": "company"
},
{
"value": "divers"
}
]
},
"observer": {
"fields": [
{
"field": "deliver_addr_preset",
"trigger": "onChange",
"exec": [
{
"cmd": "template",
"params": {
"tpl": "{% FIELD.value.data.adr_gender %}"
}
}
]
}
]
}
},
"editMode": 0
}deliver_title
Titel (L)
TEXT
R
no
i18n_string"ecs.ORDER.deliver_title"table[
"eos_order"
]fieldset"dlv_addr"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"cssLayout": "col-6 col-xl-2",
"options": {
"observer": {
"fields": [
{
"field": "deliver_addr_preset",
"trigger": "onChange",
"exec": [
{
"cmd": "template",
"params": {
"tpl": "{%FIELD.value.data.adr_title%}"
}
}
]
}
]
}
},
"editMode": 0
}deliver_firstname
Vorname (L)
TEXT
R
no
i18n_string"ecs.ORDER.deliver_firstname"table[
"eos_order"
]fieldset"dlv_addr"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"cssLayout": "col-6 col-xl-4",
"options": {
"observer": {
"fields": [
{
"field": "deliver_addr_preset",
"trigger": "onChange",
"exec": [
{
"cmd": "template",
"params": {
"tpl": "{%FIELD.value.data.adr_firstname%}"
}
}
]
}
]
}
},
"editMode": 0
}deliver_lastname
Nachname (L)
TEXT
R
no
i18n_string"ecs.ORDER.deliver_lastname"table[
"eos_order"
]fieldset"dlv_addr"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"cssLayout": "col-6 col-xl-4",
"options": {
"observer": {
"fields": [
{
"field": "deliver_addr_preset",
"trigger": "onChange",
"exec": [
{
"cmd": "template",
"params": {
"tpl": "{%FIELD.value.data.adr_lastname%}"
}
}
]
}
]
}
},
"editMode": 0
}deliver_company
Firma (L)
TEXT
R
no
i18n_string"ecs.ORDER.deliver_company"table[
"eos_order"
]fieldset"dlv_addr"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"cssLayout": "col-6",
"options": {
"observer": {
"fields": [
{
"field": "deliver_addr_preset",
"trigger": "onChange",
"exec": [
{
"cmd": "template",
"params": {
"tpl": "{%FIELD.value.data.adr_company%}"
}
}
]
}
]
}
},
"editMode": 0
}deliver_addrextra
Adressenzusatz
TEXT
R
no
i18n_string"ecs.ORDER.deliver_addrextra"table[
"eos_order"
]fieldset"dlv_addr"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"cssLayout": "col-6",
"options": {
"observer": {
"fields": [
{
"field": "deliver_addr_preset",
"trigger": "onChange",
"exec": [
{
"cmd": "template",
"params": {
"tpl": "{%FIELD.value.data.adr_extra1%}"
}
}
]
}
]
}
},
"editMode": 0
}deliver_street
Straße (L)
TEXT
R
no
i18n_string"ecs.ORDER.deliver_street"table[
"eos_order"
]fieldset"dlv_addr"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"cssLayout": "col-9",
"options": {
"observer": {
"fields": [
{
"field": "deliver_addr_preset",
"trigger": "onChange",
"exec": [
{
"cmd": "template",
"params": {
"tpl": "{%FIELD.value.data.adr_street%}"
}
}
]
}
]
}
},
"editMode": 0
}deliver_housenr
Hausnummer (L)
TEXT
R
no
i18n_string"ecs.ORDER.deliver_housenr"table[
"eos_order"
]fieldset"dlv_addr"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"cssLayout": "col-3",
"options": {
"observer": {
"fields": [
{
"field": "deliver_addr_preset",
"trigger": "onChange",
"exec": [
{
"cmd": "template",
"params": {
"tpl": "{%FIELD.value.data.adr_housenr%}"
}
}
]
}
]
}
},
"editMode": 0
}deliver_zip
PLZ (L)
TEXT
R
no
i18n_string"ecs.ORDER.deliver_zip"table[
"eos_order"
]fieldset"dlv_addr"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"cssLayout": "col-4",
"options": {
"observer": {
"fields": [
{
"field": "deliver_addr_preset",
"trigger": "onChange",
"exec": [
{
"cmd": "template",
"params": {
"tpl": "{%FIELD.value.data.adr_zip%}"
}
}
]
}
]
}
},
"editMode": 0
}deliver_town
Ort (L)
TEXT
R
no
i18n_string"ecs.ORDER.deliver_town"table[
"eos_order"
]fieldset"dlv_addr"listCfg{
"full_search": true,
"viewMode": 0,
"fullSearch": false
}formCfg{
"cssLayout": "col-8",
"options": {
"observer": {
"fields": [
{
"field": "deliver_addr_preset",
"trigger": "onChange",
"exec": [
{
"cmd": "template",
"params": {
"tpl": "{%FIELD.value.data.adr_town%}"
}
}
]
}
]
}
},
"editMode": 0
}deliver_state_code
Bundesland (Code) (L)
TEXT (15)
R
yes
i18n_string"ecs.ORDER.deliver_state_code"table[
"eos_order"
]fieldset"dlv_addr"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"cssLayout": "col-6",
"type": "eosdropdown",
"options": {
"dataStreamCall": {
"method": "state_getlist"
},
"serverSideSearch": false,
"optValueField": "terr_code",
"optNameField": "terr_name",
"optExtraField": "terr_code",
"observer": {
"fields": [
{
"field": "deliver_addr_preset",
"trigger": "onChange",
"exec": [
{
"cmd": "template",
"params": {
"tpl": "{%FIELD.value.data.adr_state_code%}"
}
}
]
},
{
"field": "deliver_country",
"trigger": "onInit",
"exec": [
{
"cmd": "loadOptions",
"params": {
"dataStreamCall": {
"method": "state_getlist",
"params": {
"filter": {
"state_country": "{%FIELD.value%}"
}
}
}
}
}
]
},
{
"field": "deliver_country",
"trigger": "onChange",
"exec": [
{
"cmd": "loadOptions",
"params": {
"dataStreamCall": {
"method": "state_getlist",
"params": {
"filter": {
"state_country": "{%FIELD.value%}"
}
}
}
}
}
]
}
]
}
},
"editMode": 0
}i18n_string"ecs.ORDER.deliver_country"table[
"eos_order"
]fieldset"dlv_addr"listCfg{
"viewMode": 0,
"formatter": {
"type": "country-flag"
},
"fullSearch": false
}formCfg{
"cssLayout": "col-6",
"options": {
"observer": {
"fields": [
{
"field": "deliver_addr_preset",
"trigger": "onChange",
"exec": [
{
"cmd": "template",
"params": {
"tpl": "{%FIELD.value.data.adr_country%}"
}
}
]
}
]
}
},
"editMode": 0
}deliver_date_req
Kunden-Wunschtermin
TEXT
R
no
i18n_string"ecs.ORDER.deliver_date_req"table[
"eos_order"
]fieldset"dlv_extra"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}deliver_phone
Telefon
TEXT
R
no
i18n_string"ecs.ORDER.deliver_phone"table[
"eos_order"
]fieldset"dlv_extra"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}deliver_email
E-Mail (L)
TEXT
R
no
i18n_string"ecs.ORDER.deliver_email"table[
"eos_order"
]fieldset"dlv_extra"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}deliver_comment
Liefer-Hinweise
TEXT
R
no
input_translatedGeben Sie hier einen Lieferhinweis für den Lieferanten ein.
i18n_string"ecs.ORDER.deliver_comment"table[
"eos_order"
]fieldset"dlv_extra"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}drvd_deliver_street_housenr
Straße+Nr (L)
TEXT
R
no
i18n_string"ecs.ORDER.drvd_deliver_street_housenr"table[
"eos_order"
]drvd_selectCONCAT_WS("",eos_order.deliver_street," ",eos_order.deliver_housenr)listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}deliver_notes_xdata
Lieferhinweise
DATA
R
yes
i18n_string"ecs.ORDER.deliver_notes_xdata"table[
"eos_order"
]fieldset"dlv_extra"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"cssLayout": "col-12",
"type": "aceeditor",
"options": {
"mode": "json"
},
"editMode": 0
}ip_address
IP-Adresse
TEXT
R
yes
i18n_string"ecs.ORDER.ip_address"table[
"eos_order"
]fieldset"sys_record"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}o_referrer
Referrer
TEXT
R
yes
i18n_string"ecs.ORDER.o_referrer"table[
"eos_order"
]fieldset"sys_record"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}o_useragent
User-Agent
TEXT
R
yes
i18n_string"ecs.ORDER.o_useragent"table[
"eos_order"
]fieldset"sys_record"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}o_comment
Kundenkommentar
TEXT
R
yes
input_translatedGeben Sie hier einen Kommentar zum Auftrag ein.
i18n_string"ecs.ORDER.o_comment"table[
"eos_order"
]fieldset"extra"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"type": "textarea",
"editMode": 0
}o_comment_internal
Interner Bestellhinweis
TEXT
R
yes
input_translatedVergeben Sie hier einen internen Kommentar, z.B. für andere Auftragsbearbeiter.
i18n_string"ecs.ORDER.o_comment_internal"table[
"eos_order"
]fieldset"extra"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"type": "textarea",
"editMode": 0
}o_lock_time
Bearbeitungs-Sperre (Zeitpunkt)
DATETIME
R
yes
i18n_string"ecs.ORDER.o_lock_time"table[
"eos_order"
]listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}o_lock_user
Bearbeitungs-Sperre (Benutzer)
TEXT (31)
R
yes
i18n_string"ecs.ORDER.o_lock_user"table[
"eos_order"
]listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}o_insert_time
Angelegt am
DATETIME
R
no
i18n_string"insert_time"table[
"eos_order"
]fieldset"sys_record"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}o_update_time
Geändert am
DATETIME
R
yes
i18n_string"update_time"table[
"eos_order"
]fieldset"sys_record"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}o_insert_user
Ersteller
TEXT (127)
R
yes
i18n_string"insert_user"table[
"eos_order"
]fieldset"sys_record"listCfg{
"formatter": {
"type": "user"
},
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}o_update_user
Letzte Änderung durch
TEXT (127)
R
yes
i18n_string"update_user"table[
"eos_order"
]fieldset"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"
]fieldset"marketing"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"cssLayout": "col-6",
"editMode": 0
}drvd_o_shoplabel
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
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
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
Zahlungsziel-Daten
DATA
R
yes
i18n_string"ecs.ORDER.o_pay_profile_xdata"table[
"eos_order"
]listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"cssLayout": "col-12",
"type": "aceeditor",
"options": {
"mode": "json"
},
"editMode": 0
}drvd_o_omsg_cnt
INT (11)
R
yes
i18n_string"ecs.ORDER.drvd_o_omsg_cnt"table[
"ecs_order_message"
]drvd_selectCOUNT(ecs_order_message.omsg_id)listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}drvd_o_omsg_time_last
DATETIME (11)
R
yes
i18n_string"ecs.ORDER.drvd_o_omsg_time_last"table[
"ecs_order_message"
]drvd_selectMAX(ecs_order_message.omsg_insert_time)listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}i18n_string"ecs.plugin_companyaccount.fk_o_companyaccount_subaccount_persid"table[
"eos_order"
]fieldset"extra"listCfg{
"viewMode": 3,
"fullSearch": false
}formCfg{
"editMode": 0
}i18n_string"ecs.ORDER.fk_o_mrch_id"table[
"eos_order"
]fieldset"extra"listCfg{
"viewMode": 3,
"fullSearch": false
}formCfg{
"editMode": 0
}i18n_string"ecs.ORDER.fk_o_parent_oid"table[
"eos_order"
]fieldset"extra"listCfg{
"viewMode": 3,
"fullSearch": false
}formCfg{
"editMode": 0
}drvd_parent_orderid
Hauptauftrag
TEXT
R
yes
i18n_string"ecs.ORDER.drvd_parent_orderid"table[
"parent_order"
]drvd_selectparent_order.orderidlistCfg{
"viewMode": 0,
"fullSearch": false,
"formatter": {
"type": "model-primary",
"params": {
"model": "order",
"primaryKey": "fk_o_parent_oid"
}
}
}formCfg{
"editMode": 0
}o_merchant_xdata
Anbieter (Zusatzdaten)
DATA
R
yes
i18n_string"ecs.ORDER.o_merchant_xdata"table[
"eos_order"
]fieldset"extra"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"cssLayout": "col-12",
"type": "aceeditor",
"options": {
"mode": "json"
},
"editMode": 0
}o_periodic_time_first
Abo-Startdatum
DATETIME
R
yes
i18n_string"ecs.ORDER.o_periodic_time_first"table[
"eos_order"
]fieldset"time_settings"listCfg{
"viewMode": 3,
"fullSearch": false
}formCfg{
"type": "datetimepicker",
"cssLayout": "col-12 col-md-6 col-xl-6",
"editMode": 0
}o_periodic_time_last
Abo-Enddatum
DATETIME
R
yes
i18n_string"ecs.ORDER.o_periodic_time_last"table[
"eos_order"
]fieldset"time_settings"listCfg{
"viewMode": 3,
"fullSearch": false
}formCfg{
"type": "datetimepicker",
"cssLayout": "col-12 col-md-6 col-xl-6",
"editMode": 0
}o_periodic_time_next
Nächste Abo-Ausführung
DATETIME
R
yes
i18n_string"ecs.ORDER.o_periodic_time_next"table[
"eos_order"
]fieldset"time_settings"listCfg{
"viewMode": 3,
"fullSearch": false
}formCfg{
"editMode": 0,
"cssLayout": "col-12 col-md-6 col-xl-6"
}o_periodic_timeorder_offset
Abweichendes Auftragsdatum
TEXT (31)
R
no
i18n_string"ecs.ORDER.o_periodic_timeorder_offset"table[
"eos_order"
]fieldset"time_settings"listCfg{
"viewMode": 3,
"formatter": {
"type": "cron"
},
"fullSearch": false
}formCfg{
"cssLayout": "col-12 col-md-6 col-xl-6",
"editMode": 0
}o_periodic_time_strict
Strikt
INT (1)
R
no
i18n_string"ecs.ORDER.o_periodic_time_strict"table[
"eos_order"
]fieldset"time_settings"listCfg{
"viewMode": 3,
"formatter": {
"type": "active-flag"
},
"fullSearch": false
}formCfg{
"type": "checkbox",
"value": 1,
"editMode": 0
}o_periodic_exec_period
Abo-Intervall
TEXT (31)
R
no
i18n_string"ecs.ORDER.o_periodic_exec_period"table[
"eos_order"
]fieldset"time_settings"listCfg{
"viewMode": 3,
"formatter": {
"type": "cron"
},
"fullSearch": false
}formCfg{
"type": "hfycron",
"editMode": 0
}o_periodic_exec_inprogress
Wird gerade ausgeführt
INT (1)
R
no
i18n_string"ecs.ORDER.o_periodic_exec_inprogress"table[
"eos_order"
]listCfg{
"viewMode": 3,
"fullSearch": false
}formCfg{
"editMode": 0
}o_periodic_xdata
DATA
R
yes
i18n_string"ecs.ORDER.o_periodic_xdata"table[
"eos_order"
]fieldset"time_settings_xdata"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"type": "eossubform",
"hideLabel": true,
"options": {
"fieldDefinition": {
"time_paused": {
"type": "eossubformarray",
"options": {
"model": "time_paused",
"sortable": true,
"enableAdd": true,
"enableRemove": true,
"itemsMinCount": 0,
"itemsMaxCount": -1,
"fieldDefinition": {
"pause_start": {
"type": "datetimepicker",
"hideLabel": true
},
"pause_end": {
"type": "datetimepicker",
"hideLabel": true
}
},
"layoutSettings": {
"hideTabs": true,
"tabs": [
{
"label": "base",
"cssLayoutGroupDefault": "col-12",
"groups": [
{
"label": "time_paused",
"hideHeader": true,
"fdLabelLayoutDefault": "vt",
"fields": [
{
"field": "pause_start",
"cssLayout": "col-6"
},
{
"field": "pause_end",
"cssLayout": "col-6"
}
]
}
]
}
]
}
}
}
}
},
"editMode": 0
}drvd_weekday_timeordered
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
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
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
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
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
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
}shipping_type_label
Versandart
TEXT (63)
R
no
i18n_string"ecs.ORDER.shipping_type_label"table[
"eos_shipping_types"
]drvd_selecteos_shipping_types.st_labellistCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}shipping_type_grp_name
Versandart-Gruppe
TEXT (63)
R
no
i18n_string"ecs.ORDER.shipping_type_grp_name"table[
"eos_shipping_types"
]drvd_selecteos_shipping_types.st_grp_namelistCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}shipping_type_deliver_category
Lieferkategorie
TEXT (31)
R
no
i18n_string"ecs.ORDER.shipping_type_deliver_category"table[
"eos_shipping_types"
]drvd_selecteos_shipping_types.st_deliver_categorylistCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}drvd_inv_cy_name
Rechnungsland
TEXT
R
no
i18n_string"ecs.ORDER.drvd_inv_cy_name"table[
"inv_country"
]drvd_selectinv_country.cy_namelistCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}drvd_inv_cy_nameshort
Rechnungsland Kurzname
TEXT
R
no
i18n_string"ecs.ORDER.drvd_inv_cy_nameshort"table[
"inv_country"
]drvd_selectinv_country.cy_nameshortlistCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}drvd_del_cy_name
Lieferland
TEXT
R
no
i18n_string"ecs.ORDER.drvd_del_cy_name"table[
"del_country"
]drvd_selectdel_country.cy_namelistCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}drvd_del_cy_nameshort
Lieferland Kurzname
TEXT
R
no
i18n_string"ecs.ORDER.drvd_del_cy_nameshort"table[
"del_country"
]drvd_selectdel_country.cy_nameshortlistCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}drvd_invoice_state_name
Bundesland (R)
TEXT
R
no
i18n_string"ecs.ORDER.drvd_invoice_state_name"table[
"invoice_terr_state"
]drvd_selectinvoice_terr_state.terr_namelistCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}drvd_invoice_state_path
Bundesland (Pfad) (R)
TEXT
R
no
i18n_string"ecs.ORDER.drvd_invoice_state_path"table[
"invoice_terr_state"
]drvd_selectinvoice_terr_state.i18n_node_path_DElistCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}drvd_deliver_state_name
Bundesland (L)
TEXT
R
no
i18n_string"ecs.ORDER.drvd_deliver_state_name"table[
"deliver_terr_state"
]drvd_selectdeliver_terr_state.terr_namelistCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}drvd_deliver_state_path
Bundesland (Pfad) (L)
TEXT
R
no
i18n_string"ecs.ORDER.drvd_deliver_state_path"table[
"deliver_terr_state"
]drvd_selectdeliver_terr_state.i18n_node_path_DElistCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}campaign
Following fields can also be selected for reading (JOIN)
campaign_name
Kampagne
TEXT (127)
R
no
i18n_string"ecs.ORDER.campaign_name"table[
"eos_campaign"
]drvd_selecteos_campaign.camp_namelistCfg{
"full_search": true,
"viewMode": 3,
"fullSearch": false
}formCfg{
"editMode": 0
}campid
auto increment
INT (11)
R
no
i18n_string"ecs.CAMPAIGN.campid"table[
"eos_campaign"
]drvd_selecteos_campaign.campidfieldset"base"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"type": "hidden",
"editMode": 0
}i18n_string"ecs.CAMPAIGN.fk_camp_shopid"table[
"eos_campaign"
]drvd_selecteos_campaign.fk_camp_shopidfieldset"base"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}camp_name
Kampagnen-Name
TEXT (127)
R
no
input_translatedInterner Name dieser Kampagne.
i18n_string"ecs.CAMPAIGN.camp_name"table[
"eos_campaign"
]drvd_selecteos_campaign.camp_namefieldset"base"listCfg{
"formatter": {
"type": "model-primary",
"params": {
"model": "campaign",
"primaryKey": "campid",
"iconLabel": "ecs\/campaign.model",
"iconColorField": "camp_color"
}
},
"viewMode": 0,
"depends_on": "fk_o_campid",
"fullSearch": false
}formCfg{
"mandatory": true,
"editMode": 0
}camp_short_desc
Kurzbeschreibung
TEXT (127)
R
yes
i18n_string"ecs.CAMPAIGN.camp_short_desc"table[
"eos_campaign"
]drvd_selecteos_campaign.camp_short_descfieldset"base"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}camp_objective
Zielsetzung
TEXT (65536)
R
yes
i18n_string"ecs.CAMPAIGN.camp_objective"table[
"eos_campaign"
]drvd_selecteos_campaign.camp_objectivefieldset"goals"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}camp_desc
Beschreibung
TEXT
R
yes
i18n_string"ecs.CAMPAIGN.camp_desc"table[
"eos_campaign"
]drvd_selecteos_campaign.camp_descfieldset"extra"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}camp_active
Aktiv
INT (2)
R
no
input_translatedNur hierüber aktivierte Kampagnen werden getrackt.
i18n_string"ecs.CAMPAIGN.camp_active"table[
"eos_campaign"
]drvd_selecteos_campaign.camp_activefieldset"base"listCfg{
"formatter": {
"type": "active-flag"
},
"viewMode": 0,
"fullSearch": false
}formCfg{
"type": "checkbox",
"editMode": 0
}camp_color
Farbcode
TEXT (31)
R
yes
i18n_string"ecs.CAMPAIGN.camp_color"table[
"eos_campaign"
]drvd_selecteos_campaign.camp_colorfieldset"analytics"listCfg{
"viewMode": 3,
"formatter": {
"type": "color-code"
},
"fullSearch": false
}formCfg{
"editMode": 0
}camp_time_start
Startzeit
DATETIME
R
yes
input_translatedWählen Sie über die optionale Startzeit (TT-MM-YYYY hh:mm), ab wann diese Kampagne beim Tracking berücksichtigt wird.
i18n_string"ecs.CAMPAIGN.camp_time_start"table[
"eos_campaign"
]drvd_selecteos_campaign.camp_time_startfieldset"planning"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}camp_time_end
Endzeit
DATETIME
R
yes
input_translatedWählen Sie die optionale Endzeit (TT-MM-YYYY hh:mm), bis wann diese Kampagne beim Tracking berücksichtigt wird.
i18n_string"ecs.CAMPAIGN.camp_time_end"table[
"eos_campaign"
]drvd_selecteos_campaign.camp_time_endfieldset"planning"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}camp_urlvarvalue
URL Variablenwert
TEXT (31)
R
yes
input_translatedDies ist der Variablenwert, der dem URL-GET-Parameter "xr" zugewiesen werden muss, damit ein Besucher dieser Kampagne zugeordnet wird.
Beispiel:
Variablenwert = "MyCampaign123"
Dann könnte exemplarisch eine Shop-URL mit Tracking, wie folgt aussehen:
www.Ihr-Shop.de/eineSeite.html?xr=MyCampaign123
Beispiel:
Variablenwert = "MyCampaign123"
Dann könnte exemplarisch eine Shop-URL mit Tracking, wie folgt aussehen:
www.Ihr-Shop.de/eineSeite.html?xr=MyCampaign123
i18n_string"ecs.CAMPAIGN.camp_urlvarvalue"table[
"eos_campaign"
]drvd_selecteos_campaign.camp_urlvarvaluefieldset"analytics"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}camp_source
Quelle
TEXT (31)
R
yes
input_translatedDie Quelle des Traffics zur Vereinfachung, wenn mehrere Kampagnen verwendet werden. Hier könnte beispielsweise retention-newsletter, google, bing, etc. eingetragen werden.
i18n_string"ecs.CAMPAIGN.camp_source"table[
"eos_campaign"
]drvd_selecteos_campaign.camp_sourcefieldset"analytics"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}camp_medium
Medium
TEXT (31)
R
yes
input_translatedTragen Sie hier die Art des Traffics ein, die über die Quelle geliefert wird. Damit kann die Bewertung von Kampagnenergebnissen besser bewertet werden, da unterschiedliche Arten zumeist auch unterschiedliche Eigenschaften (z.B. andere Absprungraten,etc.) besitzen. Hier kann also beispielsweise email, pay-per-view, CPC, etc. stehen.
i18n_string"ecs.CAMPAIGN.camp_medium"table[
"eos_campaign"
]drvd_selecteos_campaign.camp_mediumfieldset"analytics"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}camp_term
Begriff
TEXT (31)
R
yes
input_translatedWenn die Kampagne eine Werbemaßnahme betrifft, können Sie hier Keywords definieren, die getrackt werden sollen. Mehrere Keywords können mit einem + getrennt werden, also beispielsweise mode+damen+shirts
i18n_string"ecs.CAMPAIGN.camp_term"table[
"eos_campaign"
]drvd_selecteos_campaign.camp_termfieldset"analytics"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}camp_content
Inhalt
TEXT (31)
R
yes
input_translatedWenn Sie unterschiedliche Werbemittel verwenden, die aber auf dieselbe URL verweisen, kann hierüber erfasst werden, welches Werbemittel geklickt wurde. Hier kann also beispielsweise banner-skyscraper, textlink, etc. eingetragen werden.
i18n_string"ecs.CAMPAIGN.camp_content"table[
"eos_campaign"
]drvd_selecteos_campaign.camp_contentfieldset"analytics"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}camp_campaign
Zusatz-Name
TEXT (31)
R
yes
input_translatedDefinieren Sie hierüber einen möglichst eindeutigen Kampagnennamen oder Namen der Produktwerbeaktion (über alle verwendeten Kampagnen) mit der das Werbemittel verbunden ist. Machen Sie es sich an dieser Stelle nicht zu kompliziert, um den Überblick zu bewahren. Beispielsweise könnte hier winterschlussverkauf eingetragen werden.
i18n_string"ecs.CAMPAIGN.camp_campaign"table[
"eos_campaign"
]drvd_selecteos_campaign.camp_campaignfieldset"analytics"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}camp_track_interval
Erkennungszeitraum
INT (11)
R
no
input_translatedAnzahl der TAGE, innerhalb derer ein Besucher, der ursprünglich über diese Kampagne gekommen ist, auch bei Folgebesuchen dieser Kampagne automatisch wieder zugeordnet wird.
Ein typischer Wert ist: "30" Tage.
Ein typischer Wert ist: "30" Tage.
i18n_string"ecs.CAMPAIGN.camp_track_interval"table[
"eos_campaign"
]drvd_selecteos_campaign.camp_track_intervalfieldset"tracking"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}camp_trackvars
Tracking-Variablen
TEXT
R
yes
input_translatedZu einer Kampagne lassen sich zusätzliche Variablen definieren, deren Werte vom Referrer im Link per URL-GET-Variablen übergeben werden. Auf die Variablen kann später im dynamischen Erstellen des Tracing-Codes auf der Bestellabschlussseite zugegriffen werden.
Mehrere Variablen müssen mit Semikolon ; getrennt werden.
Beispiel: var1;var2;var3
Mehrere Variablen müssen mit Semikolon ; getrennt werden.
Beispiel: var1;var2;var3
i18n_string"ecs.CAMPAIGN.camp_trackvars"table[
"eos_campaign"
]drvd_selecteos_campaign.camp_trackvarsfieldset"tracking"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}camp_tracing_javascript
Verfolgungs-Javascript
TEXT
R
yes
input_translatedTragen Sie hier Javascript-Code ein, der für die Kampagnenverfolgung auf der Bestellabschlussseite eingebunden wird. Innerhalb des Codes kann via Platzhaltern {} dynamisch auf alle Daten des neuen Auftrages zugegriffen werden. Mehrere Ebenen innerhalb des Platzhalters können via Slash / getrennt werden.
Platzhalterbeispiel: {person/personid} oder {orderid}
Platzhalterbeispiel: {person/personid} oder {orderid}
i18n_string"ecs.CAMPAIGN.camp_tracing_javascript"table[
"eos_campaign"
]drvd_selecteos_campaign.camp_tracing_javascriptfieldset"tracking"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}camp_tracing_code
Verfolgungs-Code
TEXT
R
yes
input_translatedTragen Sie hier HTML-Code ein, der für die Kampagnenverfolgung auf der Bestellabschlussseite eingebunden wird. Innerhalb des Codes kann via Platzhaltern {} dynamisch auf alle Daten des neuen Auftrages zugegriffen werden. Mehrere Ebenen innerhalb des Platzhalters können dabei via Slash / getrennt werden.
Platzhalterbeispiel: {person/personid} oder {orderid}
Platzhalterbeispiel: {person/personid} oder {orderid}
i18n_string"ecs.CAMPAIGN.camp_tracing_code"table[
"eos_campaign"
]drvd_selecteos_campaign.camp_tracing_codefieldset"tracking"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}camp_external_id
Externer Kampagnen-Id
TEXT (63)
R
yes
i18n_string"ecs.CAMPAIGN.camp_external_id"table[
"eos_campaign"
]drvd_selecteos_campaign.camp_external_idfieldset"external"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}camp_external_src
Externer Kampagnen-Quelle
TEXT (127)
R
yes
i18n_string"ecs.CAMPAIGN.camp_external_src"table[
"eos_campaign"
]drvd_selecteos_campaign.camp_external_srcfieldset"external"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}input_translatedKommt ein Besucher über diese Kampagne, so wird er automatisch dieser Kundengruppe zugeordnet.
i18n_string"ecs.CAMPAIGN.camp_person_grpid"table[
"eos_campaign"
]drvd_selecteos_campaign.camp_person_grpidfieldset"dynpricing"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}camp_prc_col
Preisspalte
TEXT (63)
R
yes
input_translatedKommt ein Besucher über diese Kampagne, so werden ihm Produkt-Preise aus dieser Preisspalte angzeigt.
Wird dies Feld leer gelassen, so wird die Standard-Produktpreisspalte genommen.
Wird dies Feld leer gelassen, so wird die Standard-Produktpreisspalte genommen.
i18n_string"ecs.CAMPAIGN.camp_prc_col"table[
"eos_campaign"
]drvd_selecteos_campaign.camp_prc_colfieldset"dynpricing"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}camp_prc_mode
Preismodus
TEXT (7)
R
yes
input_translatedKommt ein Besucher über diese Kampagne, so kann hierüber konfiguriert werden, ob er NETTO- oder BRUTTO-Preise (default) angezeigt bekommen soll.
i18n_string"ecs.CAMPAIGN.camp_prc_mode"table[
"eos_campaign"
]drvd_selecteos_campaign.camp_prc_modefieldset"dynpricing"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}camp_expected_order_revenue
[EUR]
Erwarteter Umsatz (Order)
FLOAT (13,4)
R
yes
i18n_string"ecs.CAMPAIGN.camp_expected_order_revenue"table[
"eos_campaign"
]drvd_selecteos_campaign.camp_expected_order_revenuefieldset"goals"listCfg{
"formatter": {
"type": "currency"
},
"viewMode": 0,
"sumType": "SV",
"fullSearch": false
}formCfg{
"editMode": 0
}camp_expected_order_cnt
[#]
Erwartete Anzahl (Order)
INT (11)
R
yes
i18n_string"ecs.CAMPAIGN.camp_expected_order_cnt"table[
"eos_campaign"
]drvd_selecteos_campaign.camp_expected_order_cntfieldset"goals"listCfg{
"viewMode": 0,
"sumType": "SV",
"fullSearch": false
}formCfg{
"editMode": 0
}camp_expected_lead_cnt
[#]
Erwartete Anzahl (Leads)
INT (11)
R
yes
i18n_string"ecs.CAMPAIGN.camp_expected_lead_cnt"table[
"eos_campaign"
]drvd_selecteos_campaign.camp_expected_lead_cntfieldset"goals"listCfg{
"viewMode": 0,
"sumType": "SV",
"fullSearch": false
}formCfg{
"editMode": 0
}camp_expected_impression_cnt
[#]
Erwartete Impressions
INT (11)
R
yes
i18n_string"ecs.CAMPAIGN.camp_expected_impression_cnt"table[
"eos_campaign"
]drvd_selecteos_campaign.camp_expected_impression_cntfieldset"goals"listCfg{
"viewMode": 0,
"sumType": "SV",
"fullSearch": false
}formCfg{
"editMode": 0
}camp_expected_costs
[EUR]
Erwartete Kosten
FLOAT (13,4)
R
yes
i18n_string"ecs.CAMPAIGN.camp_expected_costs"table[
"eos_campaign"
]drvd_selecteos_campaign.camp_expected_costsfieldset"costs"listCfg{
"formatter": {
"type": "currency"
},
"viewMode": 0,
"sumType": "SV",
"fullSearch": false
}formCfg{
"editMode": 0
}camp_costs_actual
[EUR]
Kosten - aktuell
FLOAT (13,4)
R
yes
i18n_string"ecs.CAMPAIGN.camp_costs_actual"table[
"eos_campaign"
]drvd_selecteos_campaign.camp_costs_actualfieldset"costs"listCfg{
"formatter": {
"type": "currency"
},
"viewMode": 0,
"sumType": "SV",
"fullSearch": false
}formCfg{
"editMode": 0
}camp_costs_initial
[EUR]
Kosten, einmalig
FLOAT (13,4)
R
yes
i18n_string"ecs.CAMPAIGN.camp_costs_initial"table[
"eos_campaign"
]drvd_selecteos_campaign.camp_costs_initialfieldset"costs"listCfg{
"formatter": {
"type": "currency"
},
"viewMode": 0,
"sumType": "SV",
"fullSearch": false
}formCfg{
"editMode": 0
}camp_costs_po_abs
[EUR]
Kosten pro Order, absolut (CPO-a)
FLOAT (13,4)
R
yes
i18n_string"ecs.CAMPAIGN.camp_costs_po_abs"table[
"eos_campaign"
]drvd_selecteos_campaign.camp_costs_po_absfieldset"costs"listCfg{
"formatter": {
"type": "currency"
},
"viewMode": 0,
"sumType": "SV",
"fullSearch": false
}formCfg{
"editMode": 0
}camp_costs_po_perc
[%]
Kosten pro Order, prozentual (CPO-p)
FLOAT (8,4)
R
yes
i18n_string"ecs.CAMPAIGN.camp_costs_po_perc"table[
"eos_campaign"
]drvd_selecteos_campaign.camp_costs_po_percfieldset"costs"listCfg{
"viewMode": 0,
"sumType": "SV",
"fullSearch": false
}formCfg{
"editMode": 0
}camp_costs_pi_abs
[EUR]
Kosten pro Impression, absolut (CPI)
FLOAT (13,4)
R
yes
i18n_string"ecs.CAMPAIGN.camp_costs_pi_abs"table[
"eos_campaign"
]drvd_selecteos_campaign.camp_costs_pi_absfieldset"costs"listCfg{
"formatter": {
"type": "currency"
},
"viewMode": 0,
"sumType": "SV",
"fullSearch": false
}formCfg{
"editMode": 0
}camp_commission_initial
[EUR]
Provision, einmalig
FLOAT (13,4)
R
yes
i18n_string"ecs.CAMPAIGN.camp_commission_initial"table[
"eos_campaign"
]drvd_selecteos_campaign.camp_commission_initialfieldset"commissions"listCfg{
"formatter": {
"type": "currency"
},
"viewMode": 0,
"sumType": "SV",
"fullSearch": false
}formCfg{
"editMode": 0
}camp_commission_po_abs
[EUR]
Provision per Order, absolut
FLOAT (13,4)
R
yes
i18n_string"ecs.CAMPAIGN.camp_commission_po_abs"table[
"eos_campaign"
]drvd_selecteos_campaign.camp_commission_po_absfieldset"commissions"listCfg{
"formatter": {
"type": "currency"
},
"viewMode": 0,
"sumType": "SV",
"fullSearch": false
}formCfg{
"editMode": 0
}camp_commission_po_perc
[%]
Provision per Order, prozentual
FLOAT (8,4)
R
yes
i18n_string"ecs.CAMPAIGN.camp_commission_po_perc"table[
"eos_campaign"
]drvd_selecteos_campaign.camp_commission_po_percfieldset"commissions"listCfg{
"viewMode": 0,
"sumType": "SV",
"fullSearch": false
}formCfg{
"editMode": 0
}camp_commission_pi_abs
Provision pro Impression
FLOAT (13,4)
R
yes
i18n_string"ecs.CAMPAIGN.camp_commission_pi_abs"table[
"eos_campaign"
]drvd_selecteos_campaign.camp_commission_pi_absfieldset"commissions"listCfg{
"viewMode": 0,
"sumType": "SV",
"fullSearch": false
}formCfg{
"editMode": 0
}camp_progress_data
Verlaufsdaten
DATA
R
yes
i18n_string"ecs.CAMPAIGN.camp_progress_data"table[
"eos_campaign"
]drvd_selecteos_campaign.camp_progress_datalistCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"cssLayout": "col-12",
"type": "aceeditor",
"options": {
"mode": "json"
},
"editMode": 0
}camp_insert_user
Ersteller
TEXT (127)
R
yes
i18n_string"insert_user"table[
"eos_campaign"
]drvd_selecteos_campaign.camp_insert_userfieldset"sys_record"listCfg{
"formatter": {
"type": "user"
},
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}camp_update_user
Letzte Änderung durch
TEXT (127)
R
yes
i18n_string"update_user"table[
"eos_campaign"
]drvd_selecteos_campaign.camp_update_userfieldset"sys_record"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}camp_time_insert
Angelegt am
DATETIME
R
no
i18n_string"insert_time"table[
"eos_campaign"
]drvd_selecteos_campaign.camp_time_insertfieldset"sys_record"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}camp_time_update
Geändert am
DATETIME
R
yes
i18n_string"update_time"table[
"eos_campaign"
]drvd_selecteos_campaign.camp_time_updatefieldset"sys_record"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}drvd_camp_difftime_end_day
[d]
Zeit bis Ende
INT (11)
R
yes
i18n_string"ecs.CAMPAIGN.drvd_camp_difftime_end_day"table[
"eos_campaign"
]drvd_selectTIMESTAMPDIFF(DAY, eos_campaign.camp_time_end, NOW())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"
]fieldset"base_record"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"type": "hidden",
"editMode": 0
}personid
Kunden-Nr.
TEXT (32)
R
no
i18n_string"ecs.PERSON.personid"table[
"eos_person"
]fieldset"base_record"listCfg{
"width": 160,
"formatter": {
"type": "model-primary",
"params": {
"model": "person",
"primaryKey": "persid",
"iconLabel": "hublify\/sign-questionmark",
"iconMapField": "gender",
"iconMap": [
{
"value": "female",
"iconLabel": "ecs\/gender_female"
},
{
"value": "male",
"iconLabel": "ecs\/gender_male"
},
{
"value": "company",
"iconLabel": "ecs\/gender_company"
},
{
"value": "divers",
"iconLabel": "ecs\/gender_divers"
}
],
"iconColorField": "gender_color"
}
},
"viewMode": 1,
"fullSearch": false,
"depends_on": "fk_dv_persid"
}formCfg{
"cssLayout": "col-6",
"editMode": 0
}i18n_string"ecs.PERSON.fk_p_grpid"table[
"eos_person"
]fieldset"base_record"listCfg{
"viewMode": 3,
"fullSearch": false
}formCfg{
"cssLayout": "col-6",
"editMode": 0
}i18n_string"ecs.PERSON.fk_p_shopid"table[
"eos_person"
]listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}gender
Anrede
TEXT
R
yes
enum[
"female",
"male",
"company",
"divers"
]i18n_string"ecs.PERSON.gender"valueColorField"gender_color"table[
"eos_person"
]fieldset"base"listCfg{
"width": 96,
"viewMode": 0,
"fullSearch": false
}formCfg{
"cssLayout": "col-3",
"type": "eosdropdown",
"options": {
"optI18nValuePrefix": "ecs.gender",
"optI18nName": true,
"data": {
"options": [
{
"value": null
},
{
"value": "female"
},
{
"value": "male"
},
{
"value": "company"
},
{
"value": "divers"
}
]
}
},
"editMode": 0
}gender_color
TEXT (15)
R
yes
i18n_string"ecs.PERSON.gender_color"table[
"eos_person"
]drvd_selectCASE eos_person.gender WHEN "female" THEN "#BF117F" WHEN "male" THEN "#1f96cb" WHEN "divers" THEN "#7D47B9" WHEN "company" THEN "#41cbd9" WHEN "unknown" THEN "#AAAAAA" ELSE NULL ENDlistCfg{
"viewMode": 3,
"fullSearch": false
}formCfg{
"editMode": 0
}title
Titel
TEXT
R
no
input_translatedGeben Sie hier einen Titel des Kunden an (z.B. Dr.).
i18n_string"ecs.PERSON.title"table[
"eos_person"
]fieldset"base"listCfg{
"width": 96,
"viewMode": 0,
"fullSearch": false
}formCfg{
"cssLayout": "col-3",
"type": "eosdropdown",
"options": {
"addTag": true,
"optValueField": "title",
"optNameField": "title",
"dataStreamCall": {
"method": "datahub_generate_reportList",
"params": {
"ds_label": "person",
"field_groupby": [
{
"field": "title"
}
]
}
}
},
"editMode": 0
}salutation
Anrede formal
TEXT
R
no
i18n_string"ecs.PERSON.salutation"table[
"eos_person"
]fieldset"base"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"cssLayout": "col-6",
"type": "eosdropdown",
"options": {
"addTag": true,
"optValueField": "salutation",
"optNameField": "salutation",
"dataStreamCall": {
"method": "datahub_generate_reportList",
"params": {
"ds_label": "person",
"field_groupby": [
{
"field": "salutation"
}
]
}
}
},
"editMode": 0
}firstname
Vorname
TEXT
R
no
input_translatedVorname der Registrierungsadresse.
i18n_string"ecs.PERSON.firstname"table[
"eos_person"
]fieldset"base"listCfg{
"width": 128,
"viewMode": 0,
"fullSearch": false
}formCfg{
"cssLayout": "col-6",
"editMode": 0
}lastname
Nachname
TEXT
R
no
i18n_string"ecs.PERSON.lastname"table[
"eos_person"
]fieldset"base"listCfg{
"width": 128,
"viewMode": 0,
"fullSearch": false
}formCfg{
"cssLayout": "col-6",
"editMode": 0
}bday
Geburtsdatum
DATE
R
yes
input_translatedTragen Sie hier das Geburtsdatum des Kunden ein.
Vorzugsweise im Format: tt.mm.JJJJ.
Vorzugsweise im Format: tt.mm.JJJJ.
i18n_string"ecs.PERSON.bday"table[
"eos_person"
]fieldset"base"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"type": "datepicker",
"options": {
"showWeekdays": false,
"showWeekNumbers": false,
"minDate": {
"day": 1,
"month": 1,
"year": "1900"
}
},
"editMode": 0
}drvd_age
[y]
Alter
INT
R
yes
i18n_string"ecs.PERSON.drvd_age"table[
"eos_person"
]drvd_selectDATE_FORMAT(NOW(), '%Y') - DATE_FORMAT(eos_person.bday, '%Y') - (DATE_FORMAT(NOW(), '00-%m-%d') < DATE_FORMAT(eos_person.bday, '00-%m-%d'))fieldset"analytics"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}drvd_bday_days_until_next
[d]
Nächster Geburtstag (in Tagen)
INT
R
yes
i18n_string"ecs.PERSON.drvd_bday_days_until_next"table[
"eos_person"
]drvd_selectIF(DAYOFYEAR(eos_person.bday)>DAYOFYEAR(CURDATE()) , DATEDIFF(CONCAT(YEAR(CURDATE()),'-',MONTH(eos_person.bday),'-',DAY(eos_person.bday) ) , CURDATE() ), DATEDIFF(CONCAT(YEAR(CURDATE())+1,'-',MONTH(eos_person.bday),'-',DAY(eos_person.bday) ) , CURDATE()))fieldset"analytics"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}drvd_bday_next
Nächster Geburtstag
DATE
R
yes
i18n_string"ecs.PERSON.drvd_bday_next"table[
"eos_person"
]drvd_selectIF(DAYOFYEAR(eos_person.bday)>DAYOFYEAR(CURDATE()) , CONCAT(YEAR(CURDATE()),'-',LPAD(MONTH(eos_person.bday),2,'0'),'-',LPAD(DAY(eos_person.bday),2,'0') ), CONCAT(YEAR(CURDATE())+1,'-',LPAD(MONTH(eos_person.bday),2,'0'),'-',LPAD(DAY(eos_person.bday),2,'0')))fieldset"analytics"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}company
Firma
TEXT
R
no
i18n_string"ecs.PERSON.company"table[
"eos_person"
]fieldset"addr"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"cssLayout": "col-4",
"editMode": 0
}p_department
Abteilung
TEXT
R
no
i18n_string"ecs.PERSON.p_department"table[
"eos_person"
]fieldset"addr"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"cssLayout": "col-4",
"type": "eosdropdown",
"options": {
"addTag": true,
"optValueField": "p_department",
"optNameField": "p_department",
"dataStreamCall": {
"method": "data_getList",
"params": {
"dataset": "person",
"fieldGroupBy": [
{
"field": "p_department"
}
],
"filter": {
"p_department": {
"search": "!$EMPTY"
}
}
}
}
},
"editMode": 0
}p_job_position
Position
TEXT
R
no
i18n_string"ecs.PERSON.p_job_position"table[
"eos_person"
]fieldset"addr"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"cssLayout": "col-4",
"type": "eosdropdown",
"options": {
"addTag": true,
"optValueField": "p_job_position",
"optNameField": "p_job_position",
"dataStreamCall": {
"method": "data_getList",
"params": {
"dataset": "person",
"fieldGroupBy": [
{
"field": "p_job_position"
}
],
"filter": {
"p_job_position": {
"search": "!$EMPTY"
}
}
}
}
},
"editMode": 0
}address2
Adressenzusatz
TEXT
R
no
i18n_string"ecs.PERSON.address2"table[
"eos_person"
]fieldset"addr"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"cssLayout": "col-12",
"editMode": 0
}street
Straße
TEXT
R
no
i18n_string"ecs.PERSON.street"table[
"eos_person"
]fieldset"addr"listCfg{
"width": 96,
"viewMode": 0,
"fullSearch": false
}formCfg{
"cssLayout": "col-9",
"editMode": 0
}housenr
Hausnummer
TEXT
R
no
i18n_string"ecs.PERSON.housenr"table[
"eos_person"
]fieldset"addr"listCfg{
"width": 64,
"viewMode": 0,
"fullSearch": false
}formCfg{
"cssLayout": "col-3",
"editMode": 0
}zip
PLZ
TEXT
R
no
i18n_string"ecs.PERSON.zip"table[
"eos_person"
]fieldset"addr"listCfg{
"width": 64,
"viewMode": 0,
"fullSearch": false
}formCfg{
"cssLayout": "col-4",
"editMode": 0
}town
Ort
TEXT
R
no
i18n_string"ecs.PERSON.town"table[
"eos_person"
]fieldset"addr"listCfg{
"width": 96,
"viewMode": 0,
"fullSearch": false
}formCfg{
"cssLayout": "col-8",
"editMode": 0
}state_code
Bundesland (Code)
TEXT (15)
R
yes
i18n_string"ecs.PERSON.state_code"table[
"eos_person"
]fieldset"addr"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"cssLayout": "col-6",
"type": "eosdropdown",
"options": {
"serverSideSearch": false,
"optValueField": "terr_code",
"optNameField": "terr_name",
"optExtraField": "terr_code",
"observer": {
"fields": [
{
"field": "country",
"trigger": "onInit",
"exec": [
{
"cmd": "loadOptions",
"params": {
"dataStreamCall": {
"method": "state_getlist",
"params": {
"filter": {
"state_country": "{%FIELD.value%}"
}
}
}
}
}
]
},
{
"field": "country",
"trigger": "onChange",
"exec": [
{
"cmd": "loadOptions",
"params": {
"dataStreamCall": {
"method": "state_getlist",
"params": {
"filter": {
"state_country": "{%FIELD.value%}"
}
}
}
}
}
]
}
]
}
},
"editMode": 0
}i18n_string"ecs.PERSON.country"table[
"eos_person"
]fieldset"addr"listCfg{
"viewMode": 0,
"width": 64,
"formatter": {
"type": "country-flag"
},
"fullSearch": false
}formCfg{
"cssLayout": "col-6",
"editMode": 0
}drvd_person_name
Kundenname (kombiniert)
TEXT
R
no
i18n_string"ecs.PERSON.drvd_person_name"table[
"eos_person"
]drvd_selectCONCAT_WS("",eos_person.company,IF((eos_person.company IS NOT NULL AND eos_person.company != "") AND ((eos_person.firstname IS NOT NULL AND eos_person.firstname != "") OR (eos_person.lastname IS NOT NULL AND eos_person.lastname != "")),", ",""),eos_person.firstname,IF(eos_person.firstname IS NOT NULL," ",""),eos_person.lastname)listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}drvd_p_address
Adresse
TEXT
R
yes
i18n_string"ecs.PERSON.drvd_p_address"table[
"eos_person"
]drvd_selectCONCAT(
IF(CHAR_LENGTH(eos_person.company)>0,CONCAT(eos_person.company,CHAR(13)),""),
TRIM(CONCAT(eos_person.title," ",eos_person.firstname," ",eos_person.lastname)),CHAR(13),
IF(CHAR_LENGTH(eos_person.address2)>0,CONCAT(eos_person.address2,CHAR(13)),""),
eos_person.street," ",eos_person.housenr,CHAR(13),
eos_person.country," - ",eos_person.zip," ",eos_person.town)listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}email
E-Mail
TEXT (127)
R
no
i18n_string"ecs.PERSON.email"table[
"eos_person"
]fieldset"communication"listCfg{
"width": 256,
"viewMode": 0,
"fullSearch": false
}formCfg{
"type": "hfyemail",
"cssLayout": "col-6",
"editMode": 0
}telephone
Telefon
TEXT
R
no
i18n_string"ecs.PERSON.telephone"table[
"eos_person"
]fieldset"communication"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"type": "hfyphone",
"cssLayout": "col-6",
"editMode": 0
}telephone_mobile
Tel. mobil
TEXT
R
no
i18n_string"ecs.PERSON.telephone_mobile"table[
"eos_person"
]fieldset"communication"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"type": "hfyphone",
"cssLayout": "col-6",
"editMode": 0
}telefax
Fax
TEXT
R
no
i18n_string"ecs.PERSON.telefax"table[
"eos_person"
]fieldset"communication"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"type": "hfyphone",
"cssLayout": "col-6",
"editMode": 0
}p_invoice_type
Rechnungsart
TEXT
R
yes
i18n_string"ecs.PERSON.p_invoice_type"table[
"eos_person"
]fieldset"commercial"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"type": "eosdropdown",
"options": {
"optI18nValuePrefix": "ecs.invoice_type",
"optI18nName": true,
"data": {
"options": [
{
"value": "noncommercial"
},
{
"value": "commercial"
}
]
}
},
"editMode": 0
}p_invoice_email
E-Mail (Rechnung)
TEXT
R
no
i18n_string"ecs.PERSON.p_invoice_email"table[
"eos_person"
]fieldset"commercial"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"type": "hfyemail",
"editMode": 0
}taxident
Umsatzsteuer-ID
TEXT
R
no
i18n_string"ecs.PERSON.taxident"table[
"eos_person"
]fieldset"commercial"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}taxident_status
Umsatzsteuer-ID-Status
TEXT
R
yes
input_translatedStatus der Umsatzsteuer-ID des Kundenkontos. Nur Kundenkonten mit bestätigter Umsatzsteuer-ID werden für Netto-Aufträge bei Lieferung in andere EU Länder berücksichtigt.
enum[
"invalid",
"valid_conditional",
"valid_confirmed"
]i18n_string"ecs.PERSON.taxident_status"table[
"eos_person"
]fieldset"commercial"listCfg{
"viewMode": 0,
"formatter": {
"type": "status"
},
"fullSearch": false
}formCfg{
"type": "eosdropdown",
"options": {
"optI18nValuePrefix": "ecs.taxident_status",
"optI18nName": true,
"data": {
"options": [
{
"value": null
},
{
"value": "invalid"
},
{
"value": "valid_conditional"
},
{
"value": "valid_confirmed"
}
]
}
},
"editMode": 0
}score
Bonitätswert
INT (7)
R
no
i18n_string"ecs.PERSON.score"table[
"eos_person"
]fieldset"credit_rating"listCfg{
"viewMode": 0,
"sumType": "AVG",
"fullSearch": false
}formCfg{
"editMode": 0
}score_time_set
Letzter Rating-Check
DATETIME
R
yes
i18n_string"ecs.PERSON.score_time_set"table[
"eos_person"
]fieldset"credit_rating"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}score_time_invalid
Abgelaufen am
DATETIME
R
yes
i18n_string"ecs.PERSON.score_time_invalid"table[
"eos_person"
]fieldset"credit_rating"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}svc_code
Rating ServiceCode
TEXT
R
yes
i18n_string"ecs.PERSON.svc_code"table[
"eos_person"
]fieldset"credit_rating"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}svc_txt
Rating ServiceText
TEXT
R
yes
i18n_string"ecs.PERSON.svc_txt"table[
"eos_person"
]fieldset"credit_rating"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}p_login_username
Benutzername
TEXT (63)
R
yes
i18n_string"ecs.PERSON.p_login_username"table[
"eos_person"
]fieldset"login"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}p_login_pwd_encrypted
Passwort (verschlüsselt)
TEXT
R
yes
i18n_string"ecs.PERSON.p_login_pwd_encrypted"table[
"eos_person"
]fieldset"login"listCfg{
"viewMode": 3,
"fullSearch": false
}formCfg{
"editMode": 0
}p_login_pwd_key
Direct-Login-Token
TEXT
R
yes
i18n_string"ecs.PERSON.p_login_pwd_key"table[
"eos_person"
]fieldset"login"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}p_login_time_last
Letzter Login
DATETIME
R
yes
i18n_string"ecs.PERSON.p_login_time_last"table[
"eos_person"
]fieldset"login"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}p_login_pwd_must_renew_after
Passwort-Änderung auffordern ab
DATETIME
R
yes
i18n_string"ecs.PERSON.p_login_pwd_must_renew_after"table[
"eos_person"
]fieldset"login"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"type": "datetimepicker",
"editMode": 0
}p_login_pwd_key_timeout
Direct-Login-Token Timeout
DATETIME
R
yes
i18n_string"ecs.PERSON.p_login_pwd_key_timeout"table[
"eos_person"
]fieldset"login"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}p_login_pwd_last_renewed
Passwort zuletzt geändert
DATETIME
R
yes
i18n_string"ecs.PERSON.p_login_pwd_last_renewed"table[
"eos_person"
]fieldset"login"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}p_login_active
Aktiv
INT (1)
R
no
i18n_string"ecs.PERSON.p_login_active"table[
"eos_person"
]fieldset"login"listCfg{
"formatter": {
"type": "active-flag"
},
"width": 64,
"viewMode": 0,
"fullSearch": false
}formCfg{
"type": "checkbox",
"editMode": 0
}p_email_verify_token
TEXT (32)
R
yes
i18n_string"ecs.PERSON.p_email_verify_token"table[
"eos_person"
]fieldset"login"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}p_email_verify_token_timeout
DATETIME
R
yes
i18n_string"ecs.PERSON.p_email_verify_token_timeout"table[
"eos_person"
]fieldset"login"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}p_email_verified_time
DATETIME
R
yes
i18n_string"ecs.PERSON.p_email_verified_time"table[
"eos_person"
]fieldset"login"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}p_login_mode
Login-Modus
TEXT (15)
R
yes
enum[
"simple",
"2fa_email"
]i18n_string"ecs.PERSON.p_login_mode"table[
"eos_person"
]fieldset"login"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"cssLayout": "col-3",
"type": "eosdropdown",
"options": {
"optI18nValuePrefix": "ecs.p_login_mode",
"optI18nName": true,
"optI18nSubTitle": true,
"data": {
"options": [
{
"value": "simple"
},
{
"value": "2fa_email"
}
]
}
},
"editMode": 0
}p_login_2fa_code
2FA - Login Code
TEXT
R
yes
i18n_string"ecs.PERSON.p_login_2fa_code"table[
"eos_person"
]fieldset"login"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}p_login_2fa_timeout
2FA - Login Code Timeout
DATETIME
R
yes
i18n_string"ecs.PERSON.p_login_2fa_timeout"table[
"eos_person"
]fieldset"login"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}p_login_err_count
Anzahl Fehllogins
INT (4)
R
no
i18n_string"ecs.PERSON.p_login_err_count"table[
"eos_person"
]fieldset"login"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}p_login_time_min
Login Sperrzeit
DATETIME
R
yes
i18n_string"ecs.PERSON.p_login_time_min"table[
"eos_person"
]fieldset"login"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}p_register_state
Registrierungsstatus
TEXT (15)
R
yes
i18n_string"ecs.PERSON.p_register_state"table[
"eos_person"
]fieldset"login"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}p_register_code
Registrierungscode
TEXT (32)
R
yes
i18n_string"ecs.PERSON.p_register_code"table[
"eos_person"
]fieldset"login"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}p_register_code_timeout
Registrierungscode Timeout
DATETIME
R
yes
i18n_string"ecs.PERSON.p_register_code_timeout"table[
"eos_person"
]fieldset"login"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}p_onetime_pwd
Einmal-Passwort
TEXT
R
yes
i18n_string"ecs.PERSON.p_onetime_pwd"table[
"eos_person"
]fieldset"login"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}p_onetime_pwd_timeout
Einmal-Passwort Timeout
DATETIME
R
yes
i18n_string"ecs.PERSON.p_onetime_pwd_timeout"table[
"eos_person"
]fieldset"login"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}p_login_state
Login Status
TEXT (15)
R
no
enum[
"possible",
"disabled",
"suspended",
"retry"
]i18n_string"ecs.PERSON.p_login_state"table[
"eos_person"
]drvd_selectIF(eos_person.p_login_active!=1, "disabled", IF(eos_person.p_login_err_count>0 ,IF(eos_person.p_login_time_min>NOW() ,"suspended","retry"),"possible"))listCfg{
"viewMode": 0,
"formatter": {
"type": "status",
"params": {
"statusColorField": "p_login_state_color"
}
},
"fullSearch": false
}formCfg{
"editMode": 0
}p_login_state_color
TEXT (15)
R
yes
i18n_string"ecs.PERSON.p_login_state_color"table[
"eos_person"
]drvd_selectIF(eos_person.p_login_active!=1, "#CCCCCC", IF(eos_person.p_login_err_count>0 ,IF(eos_person.p_login_time_min>NOW() ,"#CE0002","#EEAB00"),"#85B200"))listCfg{
"viewMode": 0,
"formatter": {
"type": "color-code"
},
"fullSearch": false
}formCfg{
"editMode": 0
}i18n_string"ecs.PERSON.p_oo_set_label"table[
"eos_person"
]fieldset"order_options"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}i18n_string"ecs.PERSON.fk_p_pay_profile_id"table[
"eos_person"
]fieldset"order_options"listCfg{
"viewMode": 3,
"fullSearch": false
}formCfg{
"editMode": 0
}input_translatedEine hier eingetragene Preisgruppe hat Vorrang vor den Preisgruppen-Einstellungen der Kundengruppe und auch den direkt im Produkt gesetzten Staffelpreisen.
i18n_string"ecs.PERSON.fk_p_prcgrp_id"table[
"eos_person"
]fieldset"order_options"listCfg{
"viewMode": 3,
"fullSearch": false
}formCfg{
"editMode": 0
}p_price_factor
Preis-Faktor
FLOAT (10,4)
R
yes
input_translatedDer angegebene Faktor wird bei allen für den Kunden angezeigten Standard-Preisen als Multiplikator verwendet.
Ein eventuell für die zugehörige Kundengruppe angegebener Preis-Faktor wird durch einen speziell für den Kunden gesetzten Preisfaktor (!= 1) ersetzt.
i18n_string"ecs.PERSON.p_price_factor"table[
"eos_person"
]fieldset"order_options"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}p_person_prices
Persönliche Preise
INT (1)
R
no
i18n_string"ecs.PERSON.p_person_prices"table[
"eos_person"
]fieldset"order_options"listCfg{
"formatter": {
"type": "active-flag"
},
"width": 64,
"viewMode": 0,
"fullSearch": false
}formCfg{
"type": "checkbox",
"editMode": 0
}i18n_string"ecs.PERSON.fk_p_campid"table[
"eos_person"
]fieldset"marketing"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}p_allow_email_marketing
Zustimmung zu Marketing-Mails
INT (1)
R
no
i18n_string"ecs.PERSON.p_allow_email_marketing"table[
"eos_person"
]fieldset"marketing"listCfg{
"formatter": {
"type": "active-flag"
},
"width": 64,
"viewMode": 0,
"fullSearch": false
}formCfg{
"type": "checkbox",
"editMode": 0
}drvd_emailmarketing_unsubscribetoken
Token für Direktabmeldung Marketingmails
TEXT
R
no
i18n_string"ecs.PERSON.drvd_emailmarketing_unsubscribetoken"table[
"eos_person"
]drvd_selectmd5(CONCAT(eos_person.persid,'disallow',eos_person.personid,'emailmarketing',eos_person.time_insert))fieldset"marketing"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}p_ip_address
IP-Adresse
TEXT (15)
R
no
i18n_string"ecs.PERSON.p_ip_address"table[
"eos_person"
]fieldset"registration"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}p_referrer
Referrer
TEXT
R
yes
i18n_string"ecs.PERSON.p_referrer"table[
"eos_person"
]fieldset"registration"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}p_useragent
User Agent
TEXT
R
yes
i18n_string"ecs.PERSON.p_useragent"table[
"eos_person"
]fieldset"registration"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}p_personid_external
Externe Kunden-Nr.
TEXT (127)
R
yes
input_translatedEine externe Kunden-Nr. aus einem anderen System.
i18n_string"ecs.PERSON.p_personid_external"table[
"eos_person"
]fieldset"external"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}p_comment_internal
Interner Kommentar
TEXT
R
yes
i18n_string"ecs.PERSON.p_comment_internal"table[
"eos_person"
]fieldset"extra"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}p_locale
Locale Kunde
DATA
R
yes
i18n_string"ecs.PERSON.p_locale"table[
"eos_person"
]fieldset"extra"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}p_volfile
DATA
R
yes
i18n_string"ecs.PERSON.p_volfile"table[
"eos_person"
]drvd_selectNULLfieldset"documents"listCfg{
"viewMode": 3,
"fullSearch": false
}formCfg{
"type": "hfyvolumefile",
"options": {
"vol_label": "person_documents",
"vol_primKeyVar": "persid",
"vol_primKey": null
},
"editMode": 0
}time_insert
Angelegt am
DATETIME
R
no
i18n_string"insert_time"table[
"eos_person"
]fieldset"sys_record"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}user_insert
Ersteller
TEXT (127)
R
yes
i18n_string"insert_user"table[
"eos_person"
]fieldset"sys_record"listCfg{
"formatter": {
"type": "user"
},
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}time_update
Geändert am
DATETIME
R
yes
i18n_string"update_time"table[
"eos_person"
]fieldset"sys_record"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}user_update
Letzte Änderung durch
TEXT (127)
R
yes
i18n_string"update_user"table[
"eos_person"
]fieldset"sys_record"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}drvd_timeonly_timeinsert
Angelegt (Uhrzeit)
TEXT
R
no
i18n_string"ecs.PERSON.drvd_timeonly_timeinsert"table[
"eos_person"
]drvd_selectDATE_FORMAT(eos_person.time_insert, '%H:%i')fieldset"analytics"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}p_anonymize_time
Anoymisiert am
DATETIME
R
yes
i18n_string"ecs.PERSON.p_anonymize_time"table[
"eos_person"
]fieldset"sys_record"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}input_translatedVerknüpfen Sie das Kundenkonto mit einem Firmenaccount. Das Kundenkonto wird damit zu einem Unteraccount des Firmenaccounts.
i18n_string"ecs.plugin_companyaccount.fk_p_companyaccount_parent_persid"table[
"eos_person"
]fieldset"extra"listCfg{
"viewMode": 3,
"fullSearch": false
}formCfg{
"editMode": 0
}p_companyaccount_budget_cart_max
[EUR]
Budget Warenkorb
FLOAT (10,2)
R
yes
input_translatedLegen Sie hier den maximalen Netto-Warenkorb-Wert fest, der durch den Benutzer bestellt werden darf.
i18n_string"ecs.plugin_companyaccount.p_companyaccount_budget_cart_max"table[
"eos_person"
]fieldset"extra"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"type": "eosnumber",
"options": {
"decimalsCalculate": 2,
"decimalshowMin": 2,
"decimalshowMax": 2
},
"editMode": 0
}p_companyaccount_cost_center_customer
Kunden Kostenstelle
TEXT
R
yes
input_translatedStandard Kostenstelle des Kunden.
i18n_string"ecs.plugin_companyaccount.p_companyaccount_cost_center_customer"table[
"eos_person"
]fieldset"extra"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}p_companyaccount_type
TEXT
R
yes
i18n_string"ecs.plugin_companyaccount.p_companyaccount_type"table[
"eos_person"
]fieldset"extra"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"type": "eosdropdown",
"options": {
"optI18nValuePrefix": "ecs.plugin_companyaccount.p_companyaccount_type",
"optI18nName": true,
"data": {
"options": [
{
"value": "company"
},
{
"value": "subaccount"
}
]
}
},
"editMode": 0
}p_companyaccount_xdata
DATA
R
yes
i18n_string"ecs.plugin_companyaccount.p_companyaccount_xdata"table[
"eos_person"
]fieldset"extra"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"cssLayout": "col-12",
"type": "aceeditor",
"options": {
"mode": "json"
},
"editMode": 0
}p_accounting_debtor_account
Buchhaltung Debitorenkonto
TEXT
R
yes
input_translatedTragen Sie hier das Debitorenkonto für diesen Kunden ein, welches im Buchungsstapel-Export verwendet werden soll.
i18n_string"ecs.ecs_plugin_interface_accounting.p_accounting_debtor_account"table[
"eos_person"
]fieldset"accounting"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}fk_pers_inv_reminder_profile
Mahnprofil
TEXT (127)
R
yes
i18n_string"ecs.PERSON.fk_pers_inv_reminder_profile"table[
"eos_person"
]listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}p_merchant_xdata
Anbieter (Zusatzdaten)
DATA
R
yes
input_translatedGeben Sie hier spezifische Informationen an, die für Anbieter relevant sein können (z.B. Kundennummer zu einem Anbieter).
i18n_string"ecs.PERSON.p_merchant_xdata"table[
"eos_person"
]fieldset"extra"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"cssLayout": "col-12",
"type": "aceeditor",
"options": {
"mode": "json"
},
"editMode": 0
}p_shopuserright_profiles
Benutzer-Rollen
TEXT
R
yes
input_translatedWählen Sie hier die Benutzer-Rollen für den Kunden aus.
i18n_string"ecs.plugin_shopuserright.p_shopuserright_profiles"table[
"eos_person"
]listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}p_shopuserright_rights
Benutzer-Rechte
TEXT
R
yes
input_translatedTragen Sie hier einzelne Benutzer-Rechte für den Kunden ein.
i18n_string"ecs.plugin_shopuserright.p_shopuserright_rights"table[
"eos_person"
]listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}p_login_pwd_plain
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
Letzte Bestellung
DATETIME
R
no
i18n_string"ecs.PERSON.drvd_order_timelast"table[
"eos_person"
]fieldset"analytics"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}drvd_order_timefirst
Erste Bestellung
DATETIME
R
no
i18n_string"ecs.PERSON.drvd_order_timefirst"table[
"eos_person"
]fieldset"analytics"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}drvd_order_frequency
[d]
Bestellfrequenz
FLOAT (9,2)
R
no
i18n_string"ecs.PERSON.drvd_order_frequency"table[
"eos_person"
]fieldset"analytics"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}drvd_order_count
# Aufträge
INT (11)
R
no
i18n_string"ecs.PERSON.drvd_order_count"table[
"eos_person"
]fieldset"analytics"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}p_profile_photo
Bild
TEXT
R
yes
i18n_string"ecs.PERSON.p_profile_photo"table[
"eos_person"
]fieldset"profile"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}persongroup
Following fields can also be selected for reading (JOIN)
grpid
auto increment
INT (11)
R
no
i18n_string"ecs.PERSONGRP.grpid"table[
"eos_person_group"
]drvd_selecteos_person_group.grpidfieldset"base_record"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"type": "hidden",
"editMode": 0
}grp_name
Kundengruppe
TEXT (127)
R
no
input_translatedGeben Sie einen aussagekräftigen Namen für die Kundengruppe ein.
i18n_string"ecs.PERSONGRP.grp_name"table[
"eos_person_group"
]drvd_selecteos_person_group.grp_namefieldset"base"listCfg{
"viewMode": 0,
"fullSearch": false,
"depends_on": "fk_p_grpid"
}formCfg{
"mandatory": 1,
"editMode": 0
}description
Beschreibung
TEXT
R
no
input_translatedGeben Sie eine Beschreibung der Kundengruppe ein (z.B. für WEN wurde sie angelegt)
i18n_string"ecs.PERSONGRP.description"table[
"eos_person_group"
]drvd_selecteos_person_group.descriptionfieldset"base"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"type": "textarea",
"editMode": 0
}grp_default
Default
INT (1)
R
no
input_translatedAktivieren Sie die Checkbox, wenn diese Kundengruppe die Standardgruppe für alle Neuregistrierten Kunden sein soll. Diese werden dann automatisch zugeordnet.
i18n_string"ecs.PERSONGRP.grp_default"table[
"eos_person_group"
]drvd_selecteos_person_group.grp_defaultfieldset"register"listCfg{
"formatter": {
"type": "active-flag"
},
"width": 64,
"viewMode": 0,
"fullSearch": false
}formCfg{
"type": "checkbox",
"editMode": 0
}grp_p_login_active
Kundenlogin Default Aktiv
INT (1)
R
no
i18n_string"ecs.PERSONGRP.grp_p_login_active"table[
"eos_person_group"
]drvd_selecteos_person_group.grp_p_login_activefieldset"defaults_person"listCfg{
"formatter": {
"type": "active-flag"
},
"width": 64,
"viewMode": 0,
"fullSearch": false
}formCfg{
"type": "checkbox",
"editMode": 0
}grp_locale
Locale Kundengruppe
DATA
R
yes
i18n_string"ecs.PERSONGRP.grp_locale"table[
"eos_person_group"
]drvd_selecteos_person_group.grp_localefieldset"defaults_person"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}grp_state
Bestellstatus
TEXT (63)
R
no
input_translatedTragen Sie hier den Eingangsstatus für Bestellung von Kunden aus dieser Kundengruppe ein.
i18n_string"ecs.PERSONGRP.grp_state"table[
"eos_person_group"
]drvd_selecteos_person_group.grp_statefieldset"defaults_order"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}grp_pos
POS Channel
TEXT (63)
R
no
input_translatedGeben Sie hier den POS Channel an, für den diese Kundengruppe gelten soll. Lassen Sie dieses Feld leer, so steht die Kundengruppe in allen POS Channels zur Verfügung.
i18n_string"ecs.PERSONGRP.grp_pos"table[
"eos_person_group"
]drvd_selecteos_person_group.grp_posfieldset"defaults_order"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}prc_display_mode
Preisanzeige
TEXT (15)
R
no
input_translatedWählen Sie aus, ob die Preise im Shopfrontend für Kunden dieser Gruppe in brutto (also mit einberechneter Umsatzsteuer) oder netto (also ohne einberechnete Umsatzsteuer) angezeigt werden sollen.
i18n_string"ecs.PERSONGRP.prc_display_mode"table[
"eos_person_group"
]drvd_selecteos_person_group.prc_display_modefieldset"prices"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"cssLayout": "col-12",
"type": "eosdropdown",
"options": {
"optI18nValuePrefix": "ecs.prc_display_mode",
"optI18nName": true,
"optI18nSubTitle": true,
"data": {
"options": [
{
"value": "brutto"
},
{
"value": "netto"
}
]
}
},
"editMode": 0
}grp_price_factor
Preis-Faktor
FLOAT (10,4)
R
yes
input_translatedDer angegebene Faktor wird bei allen Standard-Shoppreisen als Multiplikator verwendet, wenn Mitglieder dieser Kundengruppe eingeloggt sind. Falls zusätzliche ein Preisfaktor für den Kunden gesetzt wurde oder ein spezifischer Standard-Preis für die Kundengruppe gesetzt ist, wird der Kundengruppen-Preisfaktor ignoriert.
i18n_string"ecs.PERSONGRP.grp_price_factor"table[
"eos_person_group"
]drvd_selecteos_person_group.grp_price_factorfieldset"prices"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"cssLayout": "col-12",
"type": "eosnumber",
"editMode": 0
}input_translatedFalls die gewählte Preisgruppen-Spalte bei einem Produkt nicht gefüllt ist, wird die hier eingetragene Preisgruppe verwendet
i18n_string"ecs.PERSONGRP.fk_grp_prcgrp_id"table[
"eos_person_group"
]drvd_selecteos_person_group.fk_grp_prcgrp_idfieldset"prices"listCfg{
"viewMode": 3,
"fullSearch": false
}formCfg{
"editMode": 0
}grp_persongrp_prices
Gruppenspezifische Preise
INT (1)
R
no
i18n_string"ecs.PERSONGRP.grp_persongrp_prices"table[
"eos_person_group"
]drvd_selecteos_person_group.grp_persongrp_pricesfieldset"orderoptions"listCfg{
"formatter": {
"type": "active-flag"
},
"width": 64,
"viewMode": 0,
"fullSearch": false
}formCfg{
"type": "checkbox",
"editMode": 0
}grp_price_col
Preisspalte
TEXT (31)
R
yes
input_translatedGeben Sie den Namen einer speziellen Preisspalte an, die für diese Kundengruppe gelten soll. Es werden passend dazu auch Spalten für Discountpreis und Discount-Start/Enddatum erzeugt. Wird dieses Feld nicht definiert, so werden die Standardpreisspalten verwendet.
i18n_string"ecs.PERSONGRP.grp_price_col"table[
"eos_person_group"
]drvd_selecteos_person_group.grp_price_colfieldset"price_col_cfg"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}grp_discount_col
Preisspalte (Discount)
TEXT (63)
R
yes
i18n_string"ecs.PERSONGRP.grp_discount_col"table[
"eos_person_group"
]drvd_selectIF(eos_person_group.grp_price_col IS NOT NULL, REPLACE(eos_person_group.grp_price_col,'price_','discount_'),null)listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}grp_discount_start_col
Preisspalte (Discount Start)
TEXT (63)
R
yes
i18n_string"ecs.PERSONGRP.grp_discount_start_col"table[
"eos_person_group"
]drvd_selectIF(eos_person_group.grp_price_col IS NOT NULL, REPLACE(eos_person_group.grp_price_col,'price_','discount_start_'),null)listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}grp_discount_end_col
Preisspalte (Discount Ende)
TEXT (63)
R
yes
i18n_string"ecs.PERSONGRP.grp_discount_end_col"table[
"eos_person_group"
]drvd_selectIF(eos_person_group.grp_price_col IS NOT NULL, REPLACE(eos_person_group.grp_price_col,'price_','discount_end_'),null)listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}grp_price_dsc_scale_col
Preisspalte (Staffelpreise)
TEXT (63)
R
no
i18n_string"ecs.PERSONGRP.grp_price_dsc_scale_col"table[
"eos_person_group"
]drvd_selecteos_person_group.grp_price_dsc_scale_colfieldset"price_col_cfg"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}grp_price_prcgrp_col
Preisgruppen-Spalte
TEXT (63)
R
no
input_translatedLegen Sie fest, welche Spalte in den Preisdaten die Preisgruppe für diese Kundengruppe enthält.
i18n_string"ecs.PERSONGRP.grp_price_prcgrp_col"table[
"eos_person_group"
]drvd_selecteos_person_group.grp_price_prcgrp_colfieldset"price_col_cfg"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}grp_price_state_col
Spalte für Shop-Status
TEXT (63)
R
no
i18n_string"ecs.PERSONGRP.grp_price_state_col"table[
"eos_person_group"
]drvd_selecteos_person_group.grp_price_state_colfieldset"price_col_cfg"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}grp_price_hide_price_dsp_col
Spalte für Preis ausblenden
TEXT (63)
R
no
i18n_string"ecs.PERSONGRP.grp_price_hide_price_dsp_col"table[
"eos_person_group"
]drvd_selecteos_person_group.grp_price_hide_price_dsp_colfieldset"price_col_cfg"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}input_translatedGeben Sie das Label des Bestelloptionen-Profils an, dass Sie verwenden möchten. Lassen Sie dieses Feld leer, wenn Sie das Standard-Profil nutzen wollen.
i18n_string"ecs.PERSONGRP.grp_oo_set_label"table[
"eos_person_group"
]drvd_selecteos_person_group.grp_oo_set_labelfieldset"orderoptions"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}i18n_string"ecs.PERSONGRP.fk_grp_pay_profile_id"table[
"eos_person_group"
]drvd_selecteos_person_group.fk_grp_pay_profile_idfieldset"orderoptions"listCfg{
"viewMode": 3,
"fullSearch": false
}formCfg{
"editMode": 0
}data
Daten
DATA
R
yes
input_translatedGeben Sie hier zusätzliche Daten als Array an.
array(
'var1' => 'wert1',
'var2' => 'wert2',
)
array(
'var1' => 'wert1',
'var2' => 'wert2',
)
i18n_string"ecs.PERSONGRP.data"table[
"eos_person_group"
]drvd_selecteos_person_group.datafieldset"extra"listCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"cssLayout": "col-12",
"type": "aceeditor",
"options": {
"mode": "json"
},
"editMode": 0
}grp_shopuserright_profiles
Gruppen-Rollen
TEXT
R
yes
input_translatedWählen Sie hier die Benutzer-Rollen für die Kundengruppen aus.
i18n_string"ecs.plugin_shopuserright.grp_shopuserright_profiles"table[
"eos_person_group"
]drvd_selecteos_person_group.grp_shopuserright_profileslistCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}grp_shopuserright_rights
Gruppen-Rechte
TEXT
R
yes
input_translatedTragen Sie hier einzelne Benutzer-Rechte für die Kundengruppe ein.
i18n_string"ecs.plugin_shopuserright.grp_shopuserright_rights"table[
"eos_person_group"
]drvd_selecteos_person_group.grp_shopuserright_rightslistCfg{
"viewMode": 0,
"fullSearch": false
}formCfg{
"editMode": 0
}