Model fields

The model consists of the following fields.

Field Name
Display Name
Type
Permissions
Nullable

deliveryitem

dviid primary auto increment
INT (11)
R+W
no
fieldset
"base_record"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "type": "hidden"
}
fk_dvi_diddelivery.did auto increment
Lieferung
INT (11)
R+W
no
fieldset
"base_record"
listCfg
{
    "viewMode": 3
}
formCfg
{
    "cssLayout": "col-6",
    "mandatory": true
}
dvi_pcode primaryDisplay auto increment
Pcode
TEXT (255)
R+W
yes
fieldset
"base"
listCfg
{
    "fullSearch": true
}
formCfg
{
    "cssLayout": "col-3"
}
dvi_name auto increment
Artikelname
TEXT
R+W
yes
fieldset
"base"
listCfg
{
    "fullSearch": true
}
formCfg
{
    "cssLayout": "col-6"
}
dvi_cnt auto increment
Anzahl
FLOAT (13,4)
R+W
no
fieldset
"base"
listCfg
{
    "sumType": "SV"
}
formCfg
{
    "cssLayout": "col-3",
    "type": "eosnumber",
    "options": {
        "decimalsCalculate": 4,
        "decimalshowMin": 0,
        "decimalshowMax": 4
    }
}
dvi_insert_time auto increment
Angelegt am
DATETIME
R+W
no
i18n_string
"insert_time"
fieldset
"sys_record"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "editMode": 2
}
dvi_update_time auto increment
Geändert am
DATETIME
R+W
yes
i18n_string
"update_time"
fieldset
"sys_record"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "editMode": 2
}
dvi_xdata auto increment
Zusatzdaten
DATA
R+W
yes
fieldset
"extra"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "cssLayout": "col-12",
    "type": "aceeditor",
    "options": {
        "mode": "json"
    }
}
dvi_insert_user auto increment
Ersteller
TEXT (127)
R+W
yes
i18n_string
"insert_user"
fieldset
"sys_record"
listCfg
{
    "formatter": {
        "type": "user"
    },
    "viewMode": 0
}
formCfg
{
    "editMode": 2
}
dvi_update_user auto increment
Letzte Änderung durch
TEXT (127)
R+W
yes
i18n_string
"update_user"
fieldset
"sys_record"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "editMode": 2
}
drvd_dv_address auto increment
Lieferadresse
TEXT
R
no
table
[ "ecs_delivery" ]
drvd_select
CONCAT(IF(CHAR_LENGTH(ecs_delivery.dv_name)>0,CONCAT(ecs_delivery.dv_name,CHAR(13)),""),
                                            IF(CHAR_LENGTH(ecs_delivery.dv_name2)>0,CONCAT(ecs_delivery.dv_name2,CHAR(13)),""),
                                            ecs_delivery.dv_street," ",ecs_delivery.dv_hnr,CHAR(13),
                                            ecs_delivery.dv_country," - ",ecs_delivery.dv_zip," ",ecs_delivery.dv_city
                            )
formCfg
{
    "editMode": 0
}
fk_dvi_item_idstorageitem.item_id auto increment
Lagerartikel-ID
INT (11)
R+W
yes
i18n_string
"ecs_plugin_ewarehouse.DELIVERYITEM.fk_dvi_item_id"
listCfg
{
    "viewMode": 0,
    "searchable": 0,
    "sortable": 0
}
formCfg
{
    "editMode": 0
}
dvi_pcode_ext auto increment
Artikel-Nr. (extern):
TEXT
R+W
yes
i18n_string
"ecs_plugin_ewarehouse.DELIVERYITEM.dvi_pcode_ext"
listCfg
{
    "viewMode": 0,
    "searchable": 0,
    "sortable": 0
}
dvi_rsvd_cnt auto increment
Reservierte Artikel
FLOAT (13,4)
R+W
no
i18n_string
"ecs_plugin_ewarehouse.DELIVERYITEM.dvi_rsvd_cnt"
listCfg
{
    "sumType": "SV"
}
formCfg
{
    "editMode": 0
}
dvi_rsvd_confirmed_cnt auto increment
Reserviert (bestätigt)
FLOAT (13,4)
R+W
no
i18n_string
"ecs_plugin_ewarehouse.DELIVERYITEM.dvi_rsvd_confirmed_cnt"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "editMode": 0
}
dvi_cost_single_purchase auto increment
Einzel-Anschaffungskosten
FLOAT (13,2)
R+W
yes
i18n_string
"ecs_plugin_ewarehouse.DELIVERYITEM.dvi_cost_single_purchase"
listCfg
{
    "viewMode": 0
}
node_id auto increment
Lagerort
INT (11)
R
no
i18n_string
"ecs_plugin_ewarehouse.STORAGEITEM.node_id"
table
[ "ewh_nstgrp_item2node", "ewh_nstgrp_nodes" ]
drvd_select
ewh_nstgrp_nodes.node_id
listCfg
{
    "viewMode": 3
}
formCfg
{
    "editMode": 0
}
node_name auto increment
Lagername
TEXT
R
no
i18n_string
"ecs_plugin_ewarehouse.STORAGE.node_name"
table
[ "ewh_nstgrp_item2node", "ewh_nstgrp_nodes" ]
drvd_select
ewh_nstgrp_nodes.i18n_node_name_DE
listCfg
{
    "viewMode": 0
}
formCfg
{
    "editMode": 0
}
node_path auto increment
Lagerpfad
TEXT
R
no
i18n_string
"ecs_plugin_ewarehouse.STORAGE.node_path"
table
[ "ewh_nstgrp_item2node", "ewh_nstgrp_nodes" ]
drvd_select
ewh_nstgrp_nodes.i18n_node_path_DE
formCfg
{
    "editMode": 0
}
drvd_dvi_cnt_not_reserved auto increment
Nicht reserviert
FLOAT (13,4)
R
no
i18n_string
"ecs_plugin_ewarehouse.DELIVERYITEM.drvd_dvi_cnt_not_reserved"
table
"ecs_deliveryitem"
drvd_select
IF(ecs_deliveryitem.dvi_rsvd_cnt = 0 AND ecs_deliveryitem.fk_dvi_item_id > 0,0,ecs_deliveryitem.dvi_cnt - ecs_deliveryitem.dvi_rsvd_cnt)
listCfg
{
    "sumType": "SV"
}
formCfg
{
    "editMode": 0
}
drvd_dvi_cnt_not_reserved_confirmed auto increment
Nicht reserviert (bestätigt)
FLOAT (13,4)
R
no
i18n_string
"ecs_plugin_ewarehouse.DELIVERYITEM.drvd_dvi_cnt_not_reserved_confirmed"
table
"ecs_deliveryitem"
drvd_select
IF(ecs_deliveryitem.dvi_rsvd_confirmed_cnt = 0 AND ecs_deliveryitem.fk_dvi_item_id > 0,0,ecs_deliveryitem.dvi_cnt - ecs_deliveryitem.dvi_rsvd_confirmed_cnt)
listCfg
{
    "viewMode": 0
}
formCfg
{
    "editMode": 0
}
drvd_si_available auto increment
Verfügbarkeit
INT
R
no
i18n_string
"ecs_plugin_ewarehouse.DELIVERYITEM.drvd_si_available"
table
[ "ewh_nstgrp_item2node", "ewh_nstgrp_nodes" ]
drvd_select
IF(ewh_nstgrp_nodes.s_available = 1 AND ewh_nstgrp_item2node.si_available = 1, 1, 0)
listCfg
{
    "viewMode": 0
}
formCfg
{
    "editMode": 0
}
drvd_si_time_available auto increment
Verfügbarkeitsdatum
INT
R
no
i18n_string
"ecs_plugin_ewarehouse.DELIVERYITEM.drvd_si_time_available"
table
[ "ewh_nstgrp_item2node", "ewh_nstgrp_nodes" ]
drvd_select
IF(ewh_nstgrp_item2node.si_time_available IS NOT NULL,ewh_nstgrp_item2node.si_time_available,ewh_nstgrp_nodes.s_time_available)
listCfg
{
    "viewMode": 0
}
formCfg
{
    "editMode": 0
}
si_cnt_rsvd auto increment
Reservierte Artikel
FLOAT (13,4)
R+W
no
i18n_string
"ecs_plugin_ewarehouse.STORAGEITEM.si_cnt_rsvd"
table
"ewh_nstgrp_item2node"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "editMode": 0
}
si_ean auto increment
EAN/GTIN
TEXT
R+W
yes
input_translated
Die Global Trade Item Number (GTIN) ist eine vergebene Identifikationsnummer, mit der Produkte und Packstücke weltweit eindeutig identifiziert werden können. Sie ersetzt die European Article Number (EAN), die bis 2009 als Globale Artikelidentifikationsnummer diente. Es wird empfohlen im Feld (falls vorhanden) die neuere GTIN anzugeben. Alternativ kann natürlich auch die EAN genutzt werden.
i18n_string
"ecs_plugin_ewarehouse.STORAGEITEM.si_ean"
table
"ewh_nstgrp_item2node"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "editMode": 0
}
si_upc auto increment
UPC
TEXT
R+W
yes
input_translated
Der Universal Product Code (UPC) ist ein Strichcode, durch den Produkte im Einzelhandel gekennzeichnet werden.
i18n_string
"ecs_plugin_ewarehouse.STORAGEITEM.si_upc"
table
"ewh_nstgrp_item2node"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "editMode": 0
}
si_snr auto increment
Seriennummer
TEXT
R+W
yes
i18n_string
"ecs_plugin_ewarehouse.STORAGEITEM.si_snr"
table
"ewh_nstgrp_item2node"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "editMode": 0
}
btch_number auto increment
Chargen-Nr.
TEXT
R+W
yes
i18n_string
"ecs_plugin_ewarehouse.STRGIBATCH.btch_number"
table
[ "ewh_strgi_batch" ]
listCfg
{
    "viewMode": 0
}
formCfg
{
    "editMode": 0
}
si_length auto increment
Länge (cm)
FLOAT (13,4)
R+W
yes
input_translated
Die Breite in Zentimeter (cm).
i18n_string
"ecs_plugin_ewarehouse.STORAGEITEM.si_length"
table
"ewh_nstgrp_item2node"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "editMode": 0
}
si_width auto increment
Tiefe (cm)
FLOAT (13,4)
R+W
yes
input_translated
Die Tiefe in Zentimeter (cm).
i18n_string
"ecs_plugin_ewarehouse.STORAGEITEM.si_width"
table
"ewh_nstgrp_item2node"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "editMode": 0
}
si_height auto increment
Höhe (cm)
FLOAT (13,4)
R+W
yes
input_translated
Die Höhe in Zentimeter (cm).
i18n_string
"ecs_plugin_ewarehouse.STORAGEITEM.si_height"
table
"ewh_nstgrp_item2node"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "editMode": 0
}
si_weight auto increment
Gewicht (kg)
FLOAT (13,4)
R+W
yes
input_translated
Das Gewicht in Kilogramm (Kg).
i18n_string
"ecs_plugin_ewarehouse.STORAGEITEM.si_weight"
table
"ewh_nstgrp_item2node"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "editMode": 0
}
drvd_si_dimension auto increment
Maße (cm)
TEXT
R
yes
i18n_string
"ecs_plugin_ewarehouse.STORAGEITEM.drvd_si_dimension"
table
"ewh_nstgrp_item2node"
drvd_select
CONCAT(si_length,' x ',si_width,' x ',si_height)
listCfg
{
    "viewMode": 0
}
formCfg
{
    "editMode": 0
}
drvd_si_volume auto increment
Volumen
TEXT
R
yes
i18n_string
"ecs_plugin_ewarehouse.STORAGEITEM.drvd_si_volume"
table
"ewh_nstgrp_item2node"
drvd_select
IF(si_length IS NOT NULL && si_width IS NOT NULL && si_height IS NOT NULL, si_length * si_width * si_height, NULL)
listCfg
{
    "viewMode": 0
}
formCfg
{
    "editMode": 0
}

product

Following fields can also be selected for reading (JOIN)

pcode auto increment
Pcode
R
no
drvd_select
dvi_pcode
listCfg
{
    "viewMode": 3
}
formCfg
{
    "editMode": 0
}
xc__active auto increment
Aktiv
INT (1)
R
no
i18n_string
"cdb_record.xc__active"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"cdb_meta"
listCfg
{
    "formatter": {
        "type": "active-flag"
    },
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "checkbox",
    "value": true,
    "editMode": 0
}
xc__searchable auto increment
Suchbar
INT (1)
R
no
i18n_string
"cdb_record.xc__searchable"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"base"
listCfg
{
    "formatter": {
        "type": "active-flag"
    },
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "checkbox",
    "value": true,
    "editMode": 0
}
xc__version auto increment
Version
INT (11)
R
no
i18n_string
"cdb_record.xc__version"
table
[ "excdb_data_ecs_product_de" ]
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
xc__current auto increment
Aktuell
INT (1)
R
no
i18n_string
"cdb_record.xc__current"
table
[ "excdb_data_ecs_product_de" ]
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
xc__insert_user auto increment
Ersteller
TEXT (127)
R
yes
i18n_string
"insert_user"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"sys_record"
listCfg
{
    "formatter": {
        "type": "user"
    },
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
xc__insert_time auto increment
Angelegt am
DATETIME
R
no
i18n_string
"insert_time"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"sys_record"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
xc__valid auto increment
Valide
INT (1)
R
no
i18n_string
"cdb_record.xc__valid"
table
[ "excdb_data_ecs_product_de" ]
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
xc__update_time auto increment
Geändert am
DATETIME
R
yes
i18n_string
"update_time"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"sys_record"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
xc__install_time auto increment
Installiert am
DATETIME
R
no
i18n_string
"plugin_install_time"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"sys_plugin"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
xc__publish_start auto increment
Veröffentlichung (Start)
DATETIME
R
yes
i18n_string
"cdb_record.xc__publish_start"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"cdb_advanced"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "cssLayout": "col-6",
    "editMode": 0
}
xc__publish_end auto increment
Veröffentlichung (Ende)
DATETIME
R
yes
i18n_string
"cdb_record.xc__publish_end"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"cdb_advanced"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "cssLayout": "col-6",
    "editMode": 0
}
xc__update_user auto increment
Letzte Änderung durch
TEXT (127)
R
yes
i18n_string
"update_user"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"sys_record"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
xc__ecms_data auto increment
eCMS-Daten
TEXT
R
yes
i18n_string
"ecs.PRODUCT.xc__ecms_data"
table
[ "excdb_data_ecs_product_de" ]
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
xc__id auto increment
ID
INT (11)
R
no
i18n_string
"cdb_record.xc__id"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"cdb_base"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "HIDDEN",
    "editMode": 0
}
drvd_xc_display auto increment
Titel
TEXT
R
no
i18n_string
"cdb_record.xc__title"
table
[ "excdb_data_ecs_product_de" ]
drvd_select
COALESCE(excdb_data_ecs_product_de.name,excdb_data_ecs_product_de.pcode)
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
drvd_is_master auto increment
Ist Masterprodukt
INT (1)
R
no
i18n_string
"ecs.PRODUCT.drvd_is_master"
table
[ "excdb_data_ecs_product_de" ]
drvd_select
IF(excdb_data_ecs_product_de.pcode = excdb_data_ecs_product_de.master_pcode,1,0)
fieldset
"cdb_base"
listCfg
{
    "formatter": {
        "type": "active-flag"
    },
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
name auto increment
Name
TEXT
R
yes
i18n_string
"ecs.PRODUCT.name"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"cdb_base"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "mandatory": true,
    "editMode": 0
}
master_pcode auto increment
Varianten-Master PCode
TEXT
R
yes
input_translated
Bei Einzelprodukten (ohne Varianten) ist dies gleich dem PCode. Bei Variantenprodukten wird hier der PCode des Hauptprodukts der Variantengruppe eingetragen.
i18n_string
"ecs.PRODUCT.master_pcode"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"cdb_base"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "text",
    "options": {
        "XXXobserver": {
            "fields": [
                {
                    "field": "pcode",
                    "trigger": "onChange",
                    "exec": [
                        {
                            "cmd": "copy"
                        }
                    ]
                }
            ]
        }
    },
    "mandatory": true,
    "editMode": 0
}
prdv_color auto increment
Varianten-Farbe
TEXT
R
yes
i18n_string
"ecs.PRODUCT.prdv_color"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"cdb_base"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "eosdropdown",
    "options": {
        "addTag": true,
        "optValueField": "prdv_color",
        "optNameField": "prdv_color",
        "dataStreamCall": {
            "method": "datahub_generate_reportList",
            "params": {
                "ds_label": "product",
                "field_groupby": [
                    {
                        "field": "prdv_color"
                    }
                ]
            }
        }
    },
    "mandatory": false,
    "editMode": 0
}
prdv_size auto increment
Varianten-Größe
TEXT
R
yes
i18n_string
"ecs.PRODUCT.prdv_size"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"cdb_base"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "eosdropdown",
    "options": {
        "addTag": true,
        "optValueField": "prdv_size",
        "optNameField": "prdv_size",
        "dataStreamCall": {
            "method": "datahub_generate_reportList",
            "params": {
                "ds_label": "product",
                "field_groupby": [
                    {
                        "field": "prdv_size"
                    }
                ]
            }
        }
    },
    "mandatory": false,
    "editMode": 0
}
prdv_other auto increment
Varianten-Ausführung
TEXT
R
yes
i18n_string
"ecs.PRODUCT.prdv_other"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"cdb_base"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "eosdropdown",
    "options": {
        "addTag": true,
        "optValueField": "prdv_other",
        "optNameField": "prdv_other",
        "dataStreamCall": {
            "method": "datahub_generate_reportList",
            "params": {
                "ds_label": "product",
                "field_groupby": [
                    {
                        "field": "prdv_other"
                    }
                ]
            }
        }
    },
    "mandatory": false,
    "editMode": 0
}
prd_comment auto increment
Kommentar
TEXT
R
yes
i18n_string
"ecs.PRODUCT.prd_comment"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"comment"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "textarea",
    "mandatory": false,
    "editMode": 0
}
files_doc auto increment
Produkt-Dateien
DATA
R
yes
i18n_string
"ecs.PRODUCT.files_doc"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"cdb_media"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "eosmedia",
    "options": {
        "uploadDirDefault": "\/products"
    },
    "mandatory": false,
    "editMode": 0
}
pack_amount auto increment
Verpackungs­menge
FLOAT
R
yes
i18n_string
"ecs.PRODUCT.pack_amount"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"packaging"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "eosnumber",
    "mandatory": false,
    "editMode": 0
}
pack_unit auto increment
Verpackungs­einheit
TEXT
R
yes
i18n_string
"ecs.PRODUCT.pack_unit"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"packaging"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "text",
    "mandatory": false,
    "editMode": 0
}
prd_ingr_amount auto increment
Verpackungs­inhalt (Menge)
FLOAT
R
yes
i18n_string
"ecs.PRODUCT.prd_ingr_amount"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"packaging"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "eosnumber",
    "mandatory": false,
    "editMode": 0
}
prd_ingr_unit auto increment
Verpackungs­inhalt (Einheit)
TEXT
R
yes
i18n_string
"ecs.PRODUCT.prd_ingr_unit"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"packaging"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "text",
    "mandatory": false,
    "editMode": 0
}
prd_weight [g] auto increment
Produktgewicht
FLOAT
R
yes
i18n_string
"ecs.PRODUCT.prd_weight"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"dimensions"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "eosnumber",
    "mandatory": false,
    "editMode": 0
}
prd_virtual auto increment
Virtuelles Produkt
TEXT
R
yes
i18n_string
"ecs.PRODUCT.prd_virtual"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"virtual"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "checkbox",
    "mandatory": false,
    "editMode": 0
}
products_replace auto increment
Nachfolge­produkte
DATA
R
yes
input_translated
Produkte durch Drag-and-Drop hinzufügen. Beispielsweise aus der Trefferliste der "Hublify Suche".
i18n_string
"ecs.PRODUCT.products_replace"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"cdb_marketing"
listCfg
{
    "formatter": {
        "type": "sub-data-chip",
        "params": {
            "chipCssClass": "chip"
        }
    },
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "eossubmodel",
    "options": {
        "model": "cdb_record",
        "xDataKey": "r2r_xdata",
        "xDataDialogConfig": {
            "layoutLabel": "submodel_product_r2r_xdata_generic_popup"
        },
        "dataStreamCall": {
            "method": "datahub_generate_reportList",
            "params": {
                "ds_label": "product"
            }
        },
        "optValueField": "xc__id",
        "optNameField": "name"
    },
    "mandatory": false,
    "editMode": 0
}
pcode_manufacturer auto increment
Hersteller-PCode
TEXT
R
yes
i18n_string
"ecs.PRODUCT.pcode_manufacturer"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"cdb_base"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "text",
    "mandatory": false,
    "editMode": 0
}
brand auto increment
Brand
TEXT
R
yes
i18n_string
"ecs.PRODUCT.brand"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"cdb_base"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "mandatory": false,
    "editMode": 0
}
products_upselling auto increment
Upselling-Produkte
DATA
R
yes
input_translated
Produkte durch Drag-and-Drop hinzufügen. Beispielsweise aus der Trefferliste der "Hublify Suche".
i18n_string
"ecs.PRODUCT.products_upselling"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"cdb_marketing"
listCfg
{
    "formatter": {
        "type": "sub-data-chip",
        "params": {
            "chipCssClass": "chip"
        }
    },
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "eossubmodel",
    "options": {
        "model": "cdb_record",
        "xDataKey": "r2r_xdata",
        "xDataDialogConfig": {
            "layoutLabel": "submodel_product_r2r_xdata_generic_popup"
        },
        "dataStreamCall": {
            "method": "datahub_generate_reportList",
            "params": {
                "ds_label": "product"
            }
        },
        "optValueField": "xc__id",
        "optNameField": "name"
    },
    "mandatory": false,
    "editMode": 0
}
orderitem_name auto increment
Auftrags­posten-Name
TEXT
R
yes
i18n_string
"ecs.PRODUCT.orderitem_name"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"proc_order"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "text",
    "mandatory": false,
    "editMode": 0
}
orderitem_text auto increment
Auftrags­posten-Text
TEXT
R
yes
i18n_string
"ecs.PRODUCT.orderitem_text"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"proc_order"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "text",
    "mandatory": false,
    "editMode": 0
}
marketing_name auto increment
Marketing-Name
TEXT
R
yes
i18n_string
"ecs.PRODUCT.marketing_name"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"cdb_marketing"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "mandatory": false,
    "editMode": 0
}
marketing_teaser auto increment
Marketing-Teaser
TEXT
R
yes
i18n_string
"ecs.PRODUCT.marketing_teaser"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"cdb_marketing"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "eoseditor",
    "options": {
        "useCfgPreset": "basic"
    },
    "mandatory": false,
    "editMode": 0
}
marketing_image auto increment
Marketing-Bild
DATA
R
yes
i18n_string
"ecs.PRODUCT.marketing_image"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"cdb_marketing"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "eosmedia",
    "options": {
        "uploadDirDefault": "\/products"
    },
    "mandatory": false,
    "editMode": 0
}
new_product auto increment
Neues Produkt?
TEXT
R
yes
i18n_string
"ecs.PRODUCT.new_product"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"cdb_marketing"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "checkbox",
    "mandatory": false,
    "editMode": 0
}
special_offer_product auto increment
Special-Offer Produkt?
TEXT
R
yes
i18n_string
"ecs.PRODUCT.special_offer_product"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"cdb_marketing"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "checkbox",
    "mandatory": false,
    "editMode": 0
}
plugin auto increment
Plugin
TEXT
R
yes
i18n_string
"ecs.PRODUCT.plugin"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"cdb_advanced"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "mandatory": false,
    "editMode": 0
}
meta_title auto increment
Produkt-Meta-Titel
TEXT
R
yes
i18n_string
"ecs.PRODUCT.meta_title"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"cdb_meta"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "text",
    "mandatory": false,
    "editMode": 0
}
meta_keywords auto increment
Produkt-Meta-Keywords
TEXT
R
yes
i18n_string
"ecs.PRODUCT.meta_keywords"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"cdb_meta"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "text",
    "mandatory": false,
    "editMode": 0
}
meta_description auto increment
Produkt-Meta-Beschreibung
TEXT
R
yes
i18n_string
"ecs.PRODUCT.meta_description"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"cdb_meta"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "textarea",
    "mandatory": false,
    "editMode": 0
}
meta_robots_noindex auto increment
Produkt-Meta-Robots-NoIndex
TEXT
R
yes
i18n_string
"ecs.PRODUCT.meta_robots_noindex"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"cdb_meta"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "checkbox",
    "mandatory": false,
    "editMode": 0
}
meta_robots_nofollow auto increment
Produkt-Meta-Robots-NoFollow
TEXT
R
yes
i18n_string
"ecs.PRODUCT.meta_robots_nofollow"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"cdb_meta"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "checkbox",
    "mandatory": false,
    "editMode": 0
}
marketing_image_background auto increment
Marketing-Hintergrundbild
DATA
R
yes
i18n_string
"ecs.PRODUCT.marketing_image_background"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"cdb_marketing"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "eosmedia",
    "options": {
        "uploadDirDefault": "\/products"
    },
    "mandatory": false,
    "editMode": 0
}
marketing_overlay_html auto increment
Marketing-Overlay-HTML
TEXT
R
yes
i18n_string
"ecs.PRODUCT.marketing_overlay_html"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"cdb_marketing"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "mandatory": false,
    "editMode": 0
}
description_seo auto increment
SEO-Beschreibung
TEXT
R
yes
i18n_string
"ecs.PRODUCT.description_seo"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"cdb_meta"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "eoseditor",
    "mandatory": false,
    "editMode": 0
}
prd_width [mm] auto increment
Produktgröße - Breite
FLOAT
R
yes
i18n_string
"ecs.PRODUCT.prd_width"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"dimensions"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "eosnumber",
    "mandatory": false,
    "editMode": 0
}
prd_height [mm] auto increment
Produktgröße - Höhe
FLOAT
R
yes
i18n_string
"ecs.PRODUCT.prd_height"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"dimensions"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "eosnumber",
    "mandatory": false,
    "editMode": 0
}
prd_depth [mm] auto increment
Produktgröße - Tiefe
FLOAT
R
yes
i18n_string
"ecs.PRODUCT.prd_depth"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"dimensions"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "eosnumber",
    "mandatory": false,
    "editMode": 0
}
prd_rating_avg auto increment
FLOAT
R
yes
i18n_string
"ecs.PRODUCT.prd_rating_avg"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"cdb_base"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "hidden",
    "mandatory": false,
    "editMode": 0
}
prd_rating_cnt auto increment
TEXT
R
yes
i18n_string
"ecs.PRODUCT.prd_rating_cnt"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"cdb_base"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "hidden",
    "mandatory": false,
    "editMode": 0
}
convertable_pack_unit auto increment
DATA
R
yes
i18n_string
"ecs.PRODUCT.convertable_pack_unit"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"packaging"
listCfg
{
    "formatter": {
        "type": "sub-data-chip",
        "params": {
            "chipCssClass": "chip"
        }
    },
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "eossubmodel",
    "options": {
        "model": "cdb_record",
        "xDataKey": "r2r_xdata",
        "xDataDialogConfig": {
            "layoutLabel": "submodel_xdata_json_popup"
        },
        "dataStreamCall": {
            "method": "datahub_generate_reportList",
            "params": {
                "ds_label": "product"
            }
        },
        "optValueField": "xc__id",
        "optNameField": "name"
    },
    "mandatory": false,
    "editMode": 0
}
prd_accounting_cost_center auto increment
Buchhaltung Kostenstelle
TEXT
R
yes
i18n_string
"ecs.PRODUCT.prd_accounting_cost_center"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"proc_accounting"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "eosdropdown",
    "options": {
        "serverSideSearch": true,
        "addTag": true,
        "optValueField": "prd_accounting_cost_center",
        "optNameField": "prd_accounting_cost_center",
        "dataStreamCall": {
            "method": "datahub_generate_reportList",
            "params": {
                "ds_label": "product",
                "field_groupby": [
                    {
                        "field": "prd_accounting_cost_center"
                    }
                ]
            }
        }
    },
    "mandatory": false,
    "editMode": 0
}
prd_accounting_revenue_account auto increment
Buchhaltung Erlöskonto
TEXT
R
yes
i18n_string
"ecs.PRODUCT.prd_accounting_revenue_account"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"proc_accounting"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "eosdropdown",
    "options": {
        "serverSideSearch": true,
        "addTag": true,
        "optValueField": "prd_accounting_revenue_account",
        "optNameField": "prd_accounting_revenue_account",
        "dataStreamCall": {
            "method": "datahub_generate_reportList",
            "params": {
                "ds_label": "product",
                "field_groupby": [
                    {
                        "field": "prd_accounting_revenue_account"
                    }
                ]
            }
        }
    },
    "mandatory": false,
    "editMode": 0
}
base_colorcolor.xc__label auto increment
Grundfarbe
TEXT
R
yes
i18n_string
"ecs.PRODUCT.base_color"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"cdb_base"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "mandatory": false,
    "editMode": 0
}
html_canonical auto increment
TEXT
R
yes
i18n_string
"ecs.PRODUCT.html_canonical"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"cdb_meta"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "checkbox",
    "mandatory": false,
    "editMode": 0
}
pack_size_width [mm] auto increment
Verpackungs­größe - Breite
TEXT
R
yes
i18n_string
"ecs.PRODUCT.pack_size_width"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"packaging"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "mandatory": false,
    "editMode": 0
}
pack_size_height [mm] auto increment
Verpackungs­größe - Höhe
TEXT
R
yes
i18n_string
"ecs.PRODUCT.pack_size_height"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"packaging"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "mandatory": false,
    "editMode": 0
}
pack_size_depth [mm] auto increment
Verpackungs­größe - Tiefe
TEXT
R
yes
i18n_string
"ecs.PRODUCT.pack_size_depth"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"packaging"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "mandatory": false,
    "editMode": 0
}
pack_weight [g] auto increment
Verpackungs­gewicht
FLOAT
R
yes
i18n_string
"ecs.PRODUCT.pack_weight"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"packaging"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "eosnumber",
    "mandatory": false,
    "editMode": 0
}
features auto increment
DATA
R
yes
i18n_string
"ecs.PRODUCT.features"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"cdb_marketing"
listCfg
{
    "formatter": {
        "type": "sub-data-chip",
        "params": {
            "chipCssClass": "chip"
        }
    },
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "eossubmodel",
    "options": {
        "model": "cdb_record",
        "xDataKey": "r2r_xdata",
        "xDataDialogConfig": {
            "layoutLabel": "submodel_xdata_json_popup"
        },
        "dataStreamCall": {
            "method": "datahub_generate_reportList",
            "params": {
                "ds_label": "feature"
            }
        },
        "optValueField": "xc__id",
        "optNameField": "name",
        "optExtraField": "type"
    },
    "mandatory": false,
    "editMode": 0
}
gtin auto increment
GTIN/EAN
TEXT
R
yes
i18n_string
"ecs.PRODUCT.gtin"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"cdb_base"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "text",
    "mandatory": false,
    "editMode": 0
}
ppn auto increment
PPN
TEXT
R
yes
i18n_string
"ecs.PRODUCT.ppn"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"cdb_base"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "text",
    "mandatory": false,
    "editMode": 0
}
origin_country auto increment
Ursprungsland
TEXT
R
yes
i18n_string
"ecs.PRODUCT.origin_country"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"extra"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "mandatory": false,
    "editMode": 0
}
customs_tariff_number auto increment
HS-Tariff-Code
TEXT
R
yes
i18n_string
"ecs.PRODUCT.customs_tariff_number"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"extra"
listCfg
{
    "view_mode": 0,
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "mandatory": false,
    "editMode": 0
}
customs_value_amount auto increment
TEXT
R
yes
i18n_string
"ecs.PRODUCT.customs_value_amount"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"extra"
listCfg
{
    "view_mode": 0,
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "unit": "EUR",
    "type": "eosnumber",
    "options": {
        "decimalsCalculate": 2,
        "decimalshowMin": 2,
        "decimalshowMax": 2
    },
    "mandatory": false,
    "editMode": 0
}
customs_description auto increment
Zoll-Beschreibung
TEXT
R
yes
i18n_string
"ecs.PRODUCT.customs_description"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"extra"
listCfg
{
    "view_mode": 0,
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "mandatory": false,
    "editMode": 0
}
files_download auto increment
Download-Dateien
DATA
R
yes
i18n_string
"ecs.PRODUCT.files_download"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"cdb_media"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "eosmedia",
    "options": {
        "uploadDirDefault": "\/products",
        "xDataDialogConfig": {
            "layoutLabel": "mamasset_2_prd_filesdownload_popup"
        },
        "xDataKey": "a2r_xdata"
    },
    "mandatory": false,
    "editMode": 0
}
products_contain auto increment
Produkte im Bundle
DATA
R
yes
i18n_string
"ecs.PRODUCT.products_contain"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"bundle"
listCfg
{
    "formatter": {
        "type": "sub-data-chip",
        "params": {
            "chipCssClass": "chip"
        }
    },
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "eossubmodel",
    "options": {
        "model": "cdb_record",
        "xDataKey": "r2r_xdata",
        "xDataDialogConfig": {
            "layoutLabel": "submodel_products_contain_popup"
        },
        "dataStreamCall": {
            "method": "datahub_generate_reportList",
            "params": {
                "ds_label": "product"
            }
        },
        "optValueField": "xc__id",
        "optNameField": "name"
    },
    "mandatory": false,
    "editMode": 0
}
prd_keywords auto increment
Keywords
TEXT
R
yes
i18n_string
"ecs.PRODUCT.prd_keywords"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"cdb_advanced"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "mandatory": false,
    "editMode": 0
}
files_img auto increment
Bilder
DATA
R
yes
input_translated
Bilder mit Drag-and-Drop hinzufügen. Entweder aus Hublify Media-Manager oder von eigener Festplatte.
i18n_string
"ecs.PRODUCT.files_img"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"cdb_base_2"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "eosmedia",
    "options": {
        "uploadDirDefault": "\/products"
    },
    "mandatory": false,
    "editMode": 0
}
prd_bundle_price_discount_perc [%] auto increment
Bundle-Preis %-Discount
FLOAT
R
yes
i18n_string
"ecs.PRODUCT.prd_bundle_price_discount_perc"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"bundle"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "mandatory": false,
    "editMode": 0
}
desc_short auto increment
Kurz­beschreibung
TEXT
R
yes
i18n_string
"ecs.PRODUCT.desc_short"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"cdb_base_2"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "eoseditor",
    "options": {
        "useCfgPreset": "basic"
    },
    "mandatory": false,
    "editMode": 0
}
prd_snr_xdata_subtype auto increment
Zusatzdaten-Typ
TEXT
R
yes
i18n_string
"ecs.PRODUCT.prd_snr_xdata_subtype"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"cdb_base_2"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "eosdropdown",
    "options": {
        "serverSideSearch": false,
        "dataStreamCall": {
            "method": "prd_subtypes_getOptions"
        }
    },
    "mandatory": false,
    "editMode": 0
}
prd_bundle_resolve_mode auto increment
Bundle-Modus
TEXT
R
yes
i18n_string
"ecs.PRODUCT.prd_bundle_resolve_mode"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"bundle"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "eosdropdown",
    "options": {
        "optI18nValuePrefix": "ecs.prd_bundle_resolve_mode",
        "optI18nName": true,
        "data": {
            "options": [
                {
                    "value": null
                },
                {
                    "value": "resolve_never"
                },
                {
                    "value": "resolve_order"
                },
                {
                    "value": "resolve_add_childitems"
                }
            ]
        }
    },
    "mandatory": false,
    "editMode": 0
}
desc_tech auto increment
Technische Beschreibung
TEXT
R
yes
i18n_string
"ecs.PRODUCT.desc_tech"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"cdb_base_2"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "mandatory": false,
    "editMode": 0
}
manufacturermanufacturer.xc__label auto increment
Hersteller
TEXT
R
yes
i18n_string
"ecs.PRODUCT.manufacturer"
table
[ "excdb_data_ecs_product_de" ]
fieldset
"cdb_base"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "mandatory": false,
    "editMode": 0
}
xc__label auto increment
TEXT
R
yes
i18n_string
"ecs.PRODUCT.xc__label"
table
[ "excdb_data_ecs_product_de" ]
drvd_select
excdb_data_ecs_product_de.pcode
fieldset
"cdb_base"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "HIDDEN",
    "editMode": 0
}
xc__title auto increment
TEXT
R
yes
i18n_string
"ecs.PRODUCT.xc__title"
table
[ "excdb_data_ecs_product_de" ]
drvd_select
excdb_data_ecs_product_de.name
fieldset
"cdb_base"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "HIDDEN",
    "editMode": 0
}
xc__image auto increment
DATA
R
yes
i18n_string
"ecs.PRODUCT.xc__image"
table
[ "excdb_data_ecs_product_de" ]
drvd_select
excdb_data_ecs_product_de.files_img
fieldset
"cdb_base_2"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "HIDDEN",
    "editMode": 0
}
drvd_variant_specification auto increment
Ausprägung
TEXT
R
no
i18n_string
"ecs.PRODUCT.drvd_variant_specification"
table
[ "excdb_data_ecs_product_de" ]
drvd_select
CONCAT_WS(',',excdb_data_ecs_product_de.prdv_color, excdb_data_ecs_product_de.prdv_size, excdb_data_ecs_product_de.prdv_other)
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}

delivery

Following fields can also be selected for reading (JOIN)

did auto increment
INT (11)
R
no
i18n_string
"ecs.DELIVERY.did"
table
[ "ecs_delivery" ]
fieldset
"base_record"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "hidden",
    "editMode": 0
}
dv_seller_name auto increment
Verkäufername
TEXT
R
no
i18n_string
"ecs.DELIVERY.dv_seller_name"
table
[ "ecs_delivery" ]
fieldset
"seller_addr"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
dv_seller_name2 auto increment
Adressenzusatz
TEXT
R
no
i18n_string
"ecs.DELIVERY.dv_seller_name2"
table
[ "ecs_delivery" ]
fieldset
"seller_addr"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
dv_seller_street auto increment
Straße
TEXT
R
no
i18n_string
"ecs.DELIVERY.dv_seller_street"
table
[ "ecs_delivery" ]
fieldset
"seller_addr"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "cssLayout": "col-9",
    "editMode": 0
}
dv_seller_hnr auto increment
Hausnr.
TEXT
R
no
i18n_string
"ecs.DELIVERY.dv_seller_hnr"
table
[ "ecs_delivery" ]
fieldset
"seller_addr"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "cssLayout": "col-3",
    "editMode": 0
}
dv_seller_zip auto increment
PLZ
TEXT
R
no
i18n_string
"ecs.DELIVERY.dv_seller_zip"
table
[ "ecs_delivery" ]
fieldset
"seller_addr"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "cssLayout": "col-4",
    "editMode": 0
}
dv_seller_city auto increment
Ort
TEXT
R
no
i18n_string
"ecs.DELIVERY.dv_seller_city"
table
[ "ecs_delivery" ]
fieldset
"seller_addr"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "cssLayout": "col-8",
    "editMode": 0
}
dv_seller_state_code auto increment
Bundesland (Code) (Verkäufer)
TEXT (15)
R
yes
i18n_string
"ecs.DELIVERY.dv_seller_state_code"
table
[ "ecs_delivery" ]
fieldset
"seller_addr"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "cssLayout": "col-6",
    "type": "eosdropdown",
    "options": {
        "serverSideSearch": false,
        "optValueField": "terr_code",
        "optNameField": "terr_name",
        "optExtraField": "terr_code",
        "observer": {
            "fields": [
                {
                    "field": "dv_seller_country",
                    "trigger": "onInit",
                    "exec": [
                        {
                            "cmd": "loadOptions",
                            "params": {
                                "dataStreamCall": {
                                    "method": "state_getlist",
                                    "params": {
                                        "filter": {
                                            "state_country": "{%FIELD.value%}"
                                        }
                                    }
                                }
                            }
                        }
                    ]
                },
                {
                    "field": "dv_seller_country",
                    "trigger": "onChange",
                    "exec": [
                        {
                            "cmd": "loadOptions",
                            "params": {
                                "dataStreamCall": {
                                    "method": "state_getlist",
                                    "params": {
                                        "filter": {
                                            "state_country": "{%FIELD.value%}"
                                        }
                                    }
                                }
                            }
                        }
                    ]
                }
            ]
        }
    },
    "editMode": 0
}
dv_seller_countrycountry.cy_iso auto increment
Land
TEXT (2)
R
no
i18n_string
"ecs.DELIVERY.dv_seller_country"
table
[ "ecs_delivery" ]
fieldset
"seller_addr"
listCfg
{
    "viewMode": 0,
    "width": 64,
    "formatter": {
        "type": "country-flag"
    },
    "fullSearch": false
}
formCfg
{
    "cssLayout": "col-6",
    "editMode": 0
}
dv_code auto increment
Lieferungs-Nr.
TEXT (63)
R
no
i18n_string
"ecs.DELIVERY.dv_code"
table
[ "ecs_delivery" ]
fieldset
"base_record"
listCfg
{
    "fullSearch": false,
    "formatter": {
        "type": "model-primary",
        "params": {
            "model": "delivery",
            "primaryKey": "did",
            "statusColorField": "delivery_state_color",
            "subTitleTemplate": "{%dv_name%} {%dv_name2%}"
        }
    },
    "viewMode": 1,
    "depends_on": "fk_dvi_did"
}
formCfg
{
    "cssLayout": "col-12 col-md-6 col-xl-3",
    "editMode": 0
}
dv_extcode auto increment
Sendungsnr.
TEXT (63)
R
no
i18n_string
"ecs.DELIVERY.dv_extcode"
table
[ "ecs_delivery" ]
fieldset
"base"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "cssLayout": "col-6",
    "editMode": 0
}
fk_dv_persidperson.persid auto increment
Kunde
INT (11)
R
yes
i18n_string
"ecs.DELIVERY.fk_dv_persid"
table
[ "ecs_delivery" ]
fieldset
"base_record"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "cssLayout": "col-12 col-md-6 col-xl-3",
    "editMode": 0
}
fk_dv_oidorder.oid auto increment
Auftrags-Nr.
INT (11)
R
yes
i18n_string
"ecs.DELIVERY.fk_dv_oid"
table
[ "ecs_delivery" ]
fieldset
"base_record"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "cssLayout": "col-12 col-md-6 col-xl-3",
    "editMode": 0
}
fk_dv_st_idshippingtype.st_id auto increment
Versandart
INT (11)
R
no
i18n_string
"ecs.DELIVERY.fk_dv_st_id"
table
[ "ecs_delivery" ]
fieldset
"base_record"
listCfg
{
    "viewMode": 3,
    "fullSearch": false
}
formCfg
{
    "cssLayout": "col-12 col-md-6 col-xl-3",
    "editMode": 0
}
dv_time_insert auto increment
Angelegt am
DATETIME
R
no
i18n_string
"insert_time"
table
[ "ecs_delivery" ]
fieldset
"sys_record"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
dv_time_update auto increment
Geändert am
DATETIME
R
yes
i18n_string
"update_time"
table
[ "ecs_delivery" ]
fieldset
"sys_record"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
dv_user_insert auto increment
Ersteller
TEXT (127)
R
yes
i18n_string
"insert_user"
table
[ "ecs_delivery" ]
fieldset
"sys_record"
listCfg
{
    "formatter": {
        "type": "user"
    },
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
dv_user_update auto increment
Letzte Änderung durch
TEXT (127)
R
yes
i18n_string
"update_user"
table
[ "ecs_delivery" ]
fieldset
"sys_record"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
dv_time_sent auto increment
Versendet am
DATETIME
R
yes
i18n_string
"ecs.DELIVERY.dv_time_sent"
table
[ "ecs_delivery" ]
fieldset
"extra"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "datepicker",
    "editMode": 0
}
dv_comment auto increment
Kommentar
TEXT
R
no
i18n_string
"ecs.DELIVERY.dv_comment"
table
[ "ecs_delivery" ]
fieldset
"extra"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "textarea",
    "editMode": 0
}
dv_comment_internal auto increment
Interner Kommentar
TEXT
R
yes
i18n_string
"ecs.DELIVERY.dv_comment_internal"
table
[ "ecs_delivery" ]
fieldset
"extra"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "textarea",
    "editMode": 0
}
dv_name auto increment
Name
TEXT
R
no
i18n_string
"ecs.DELIVERY.dv_name"
table
[ "ecs_delivery" ]
fieldset
"dlv_addr"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
dv_company auto increment
Firma
TEXT
R
no
i18n_string
"ecs.DELIVERY.dv_company"
table
[ "ecs_delivery" ]
fieldset
"dlv_addr"
listCfg
{
    "fullSearch": false,
    "viewMode": 0
}
formCfg
{
    "cssLayout": "col-6",
    "editMode": 0
}
dv_name2 auto increment
Adressenzusatz
TEXT
R
no
i18n_string
"ecs.DELIVERY.dv_name2"
table
[ "ecs_delivery" ]
fieldset
"dlv_addr"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "cssLayout": "col-6",
    "editMode": 0
}
dv_street auto increment
Straße
TEXT
R
no
i18n_string
"ecs.DELIVERY.dv_street"
table
[ "ecs_delivery" ]
fieldset
"dlv_addr"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "cssLayout": "col-9",
    "editMode": 0
}
dv_hnr auto increment
Hausnr.
TEXT
R
no
i18n_string
"ecs.DELIVERY.dv_hnr"
table
[ "ecs_delivery" ]
fieldset
"dlv_addr"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "cssLayout": "col-3",
    "editMode": 0
}
dv_zip auto increment
PLZ
TEXT
R
no
i18n_string
"ecs.DELIVERY.dv_zip"
table
[ "ecs_delivery" ]
fieldset
"dlv_addr"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "cssLayout": "col-4",
    "editMode": 0
}
dv_city auto increment
Ort
TEXT
R
no
i18n_string
"ecs.DELIVERY.dv_city"
table
[ "ecs_delivery" ]
fieldset
"dlv_addr"
listCfg
{
    "fullSearch": false,
    "viewMode": 0
}
formCfg
{
    "cssLayout": "col-8",
    "editMode": 0
}
dv_state_code auto increment
Bundesland (Code)
TEXT (15)
R
yes
i18n_string
"ecs.DELIVERY.dv_state_code"
table
[ "ecs_delivery" ]
fieldset
"dlv_addr"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "cssLayout": "col-6",
    "type": "eosdropdown",
    "options": {
        "serverSideSearch": false,
        "optValueField": "terr_code",
        "optNameField": "terr_name",
        "optExtraField": "terr_code",
        "observer": {
            "fields": [
                {
                    "field": "dv_country",
                    "trigger": "onInit",
                    "exec": [
                        {
                            "cmd": "loadOptions",
                            "params": {
                                "dataStreamCall": {
                                    "method": "state_getlist",
                                    "params": {
                                        "filter": {
                                            "state_country": "{%FIELD.value%}"
                                        }
                                    }
                                }
                            }
                        }
                    ]
                },
                {
                    "field": "dv_country",
                    "trigger": "onChange",
                    "exec": [
                        {
                            "cmd": "loadOptions",
                            "params": {
                                "dataStreamCall": {
                                    "method": "state_getlist",
                                    "params": {
                                        "filter": {
                                            "state_country": "{%FIELD.value%}"
                                        }
                                    }
                                }
                            }
                        }
                    ]
                }
            ]
        }
    },
    "editMode": 0
}
dv_countrycountry.cy_iso auto increment
Land
TEXT (2)
R
no
i18n_string
"ecs.DELIVERY.dv_country"
table
[ "ecs_delivery" ]
fieldset
"dlv_addr"
listCfg
{
    "viewMode": 0,
    "width": 64,
    "formatter": {
        "type": "country-flag"
    },
    "fullSearch": false
}
formCfg
{
    "cssLayout": "col-6",
    "editMode": 0
}
dv_phone auto increment
Telefon
TEXT
R
no
i18n_string
"ecs.DELIVERY.dv_phone"
table
[ "ecs_delivery" ]
fieldset
"dlv_addr"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
drvd_dv_seller_street_hnr auto increment
Straße+Nr (Verkäufer)
TEXT
R
no
i18n_string
"ecs.DELIVERY.drvd_dv_seller_street_hnr"
table
[ "ecs_delivery" ]
drvd_select
CONCAT_WS("",ecs_delivery.dv_seller_street," ",ecs_delivery.dv_seller_hnr)
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
drvd_dv_street_hnr auto increment
Straße+Nr (L)
TEXT
R
no
i18n_string
"ecs.DELIVERY.drvd_dv_street_hnr"
table
[ "ecs_delivery" ]
drvd_select
CONCAT_WS("",ecs_delivery.dv_street," ",ecs_delivery.dv_hnr)
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
delivery_state_color auto increment
TEXT (15)
R
no
i18n_string
"ecs.DELIVERY.delivery_state_color"
table
[ "eos_states" ]
drvd_select
eos_states.st_color
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
item_id auto increment
INT
R
no
i18n_string
"ecs.DELIVERY.item_id"
table
[ "ecs_delivery" ]
drvd_select
ecs_delivery.did
listCfg
{
    "viewMode": 3,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
i18n_st_name auto increment
Statusname
TEXT
R
no
i18n_string
"st_name"
table
[ "eos_states" ]
drvd_select
eos_states.i18n_st_name_DE
listCfg
{
    "viewMode": 0,
    "formatter": {
        "type": "status",
        "params": {
            "statusColorField": "delivery_state_color"
        }
    },
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
i18n_st_name_public auto increment
Öffentlicher Statusname
TEXT
R
no
i18n_string
"st_name_public"
table
[ "eos_states" ]
drvd_select
eos_states.i18n_st_name_public_DE
listCfg
{
    "viewMode": 0,
    "formatter": {
        "type": "status",
        "params": {
            "statusColorField": "delivery_state_color"
        }
    },
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
st_x_dv_sent auto increment
INT (4)
R
no
i18n_string
"ecs.DELIVERY.st_x_dv_sent"
table
[ "eos_states" ]
drvd_select
eos_states.st_x_dv_sent
listCfg
{
    "viewMode": 3,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
st_code auto increment
Status
TEXT
R
no
i18n_string
"ecs.DELIVERY.st_code"
table
[ "eos_states" ]
drvd_select
eos_states.st_code
listCfg
{
    "viewMode": 3,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
st_position auto increment
INT
R
no
i18n_string
"ecs.DELIVERY.st_position"
table
[ "eos_states" ]
drvd_select
eos_states.st_position
listCfg
{
    "viewMode": 3,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
is_current auto increment
INT (1)
R
no
i18n_string
"ecs.DELIVERY.is_current"
table
[ "eos_statelog" ]
drvd_select
eos_statelog.is_current
listCfg
{
    "viewMode": 3,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
transtime auto increment
DATETIME
R
no
i18n_string
"ecs.DELIVERY.transtime"
table
[ "eos_statelog" ]
drvd_select
eos_statelog.transtime
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
fk_dv_psidpackstation.psid auto increment
Packstation
INT (11)
R
no
i18n_string
"ecs_plugin_ewarehouse.DELIVERY.ps_name"
table
"ecs_delivery"
drvd_select
ecs_delivery.fk_dv_psid
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
fk_dv_dgrp_iddeliverygroup.dgrp_id auto increment
Versandliste
INT (11)
R
yes
i18n_string
"ecs_plugin_ewarehouse.DELIVERY.fk_dv_dgrp_id"
table
"ecs_delivery"
drvd_select
ecs_delivery.fk_dv_dgrp_id
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
dv_cost_total_ship auto increment
Versandkosten
FLOAT (13,2)
R
yes
i18n_string
"ecs_plugin_ewarehouse.DELIVERY.dv_cost_total_ship"
table
[ "ecs_delivery" ]
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
dv_cost_total_purchase auto increment
Artikel-Einkaufskosten
FLOAT (13,2)
R
yes
i18n_string
"ecs_plugin_ewarehouse.DELIVERY.dv_cost_total_purchase"
table
[ "ecs_delivery" ]
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
dv_time_rsvd auto increment
Reserviert am
DATETIME
R
yes
i18n_string
"ecs_plugin_ewarehouse.DELIVERY.dv_time_rsvd"
table
[ "ecs_delivery" ]
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
dv_time_transfer auto increment
Transferiert am
DATETIME
R
yes
i18n_string
"ecs_plugin_ewarehouse.DELIVERY.dv_time_transfer"
table
[ "ecs_delivery" ]
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
dv_time_planned_send auto increment
Geplante Sendezeit
DATETIME
R
yes
i18n_string
"ecs_plugin_ewarehouse.DELIVERY.dv_time_planned_send"
table
[ "ecs_delivery" ]
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
fk_dv_shp_c_idshipping_carrier.shp_c_id auto increment
Logistiker
INT (11)
R
no
i18n_string
"ecs.DELIVERY.fk_dv_shp_c_id"
table
[ "ecs_delivery" ]
fieldset
"base"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "cssLayout": "col-6",
    "editMode": 0
}
dv_carrier_time_pickedup auto increment
Abgeholt am (laut Logistiker)
DATETIME
R
yes
i18n_string
"ecs.DELIVERY.dv_carrier_time_pickedup"
table
[ "ecs_delivery" ]
fieldset
"base"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "cssLayout": "col-3",
    "editMode": 0
}
dv_carrier_time_delivered auto increment
Geliefert am (laut Logistiker)
DATETIME
R
yes
i18n_string
"ecs.DELIVERY.dv_carrier_time_delivered"
table
[ "ecs_delivery" ]
fieldset
"base"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "cssLayout": "col-3",
    "editMode": 0
}
dv_carrier_status auto increment
Logistiker-Sendungsstatus
TEXT
R
yes
i18n_string
"ecs.DELIVERY.dv_carrier_status"
table
[ "ecs_delivery" ]
fieldset
"base"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "cssLayout": "col-6",
    "editMode": 0
}
dv_carrier_id auto increment
Logistiker externe ID
TEXT (63)
R
yes
i18n_string
"ecs.DELIVERY.dv_carrier_id"
table
[ "ecs_delivery" ]
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
dv_shipping_details auto increment
Detail-Daten
DATA
R
yes
i18n_string
"ecs.DELIVERY.dv_shipping_details"
table
[ "ecs_delivery" ]
fieldset
"extra"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "cssLayout": "col-12",
    "type": "aceeditor",
    "options": {
        "mode": "json"
    },
    "editMode": 0
}
drvd_shipping_label_url auto increment
Versandlabel
TEXT
R
no
i18n_string
"ecs.DELIVERY.drvd_shipping_label_url"
table
[ "ecs_delivery" ]
drvd_select
JSON_UNQUOTE(json_extract(ecs_delivery.dv_shipping_details,'$.label_url'))
listCfg
{
    "viewMode": 0,
    "formatter": {
        "type": "url",
        "params": {
            "text": "Versandlabel",
            "iconLabel": "hublify\/link-external"
        }
    },
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
drvd_customs_declaration_url auto increment
Zollerklärung
TEXT
R
no
i18n_string
"ecs.DELIVERY.drvd_customs_declaration_url"
table
[ "ecs_delivery" ]
drvd_select
JSON_UNQUOTE(json_extract(ecs_delivery.dv_shipping_details,'$.customs_declaration.carrier_declaration_document_url'))
listCfg
{
    "viewMode": 0,
    "formatter": {
        "type": "url",
        "params": {
            "text": "Zollerkl\u00e4rung",
            "iconLabel": "hublify\/link-external"
        }
    },
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
drvd_dv_state_name auto increment
Bundesland (Name)
TEXT
R
no
i18n_string
"ecs.DELIVERY.drvd_dv_state_name"
table
[ "dv_terr_state" ]
drvd_select
dv_terr_state.terr_name
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
drvd_dv_state_path auto increment
Bundesland (Pfad)
TEXT
R
no
i18n_string
"ecs.DELIVERY.drvd_dv_state_path"
table
[ "dv_terr_state" ]
drvd_select
dv_terr_state.i18n_node_path_DE
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
drvd_dv_seller_state_name auto increment
Bundesland (Name) (Verkäufer)
TEXT
R
no
i18n_string
"ecs.DELIVERY.drvd_dv_seller_state_name"
table
[ "dv_seller_terr_state" ]
drvd_select
dv_seller_terr_state.terr_name
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
drvd_dv_seller_state_path auto increment
Bundesland (Pfad) (Verkäufer)
TEXT
R
no
i18n_string
"ecs.DELIVERY.drvd_dv_seller_state_path"
table
[ "dv_seller_terr_state" ]
drvd_select
dv_seller_terr_state.i18n_node_path_DE
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}

order

Following fields can also be selected for reading (JOIN)

oid auto increment
OID
INT (11)
R
no
i18n_string
"ecs.ORDER.oid"
table
[ "eos_order" ]
drvd_select
eos_order.oid
fieldset
"base_record"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "hidden",
    "editMode": 0
}
fk_o_shopidshopconfig.eshopid auto increment
Shop
INT (11)
R
yes
input_translated
Wählen Sie den Shop aus, zu dem dieser Auftrag gehört.
i18n_string
"ecs.ORDER.fk_o_shopid"
table
[ "eos_order" ]
drvd_select
eos_order.fk_o_shopid
fieldset
"marketing"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
orderid auto increment
Auftrags-Nr.
TEXT (63)
R
no
i18n_string
"ecs.ORDER.orderid"
table
[ "eos_order" ]
drvd_select
eos_order.orderid
fieldset
"base_record"
listCfg
{
    "fullSearch": false,
    "formatter": {
        "type": "model-primary",
        "params": {
            "model": "order",
            "primaryKey": "oid",
            "statusColorField": "order_state_color",
            "subTitleTemplate": "{%invoice_firstname%} {%invoice_lastname%}"
        }
    },
    "viewMode": 0,
    "depends_on": "fk_dv_oid"
}
formCfg
{
    "cssLayout": "col-12 col-md-6 col-xl-3",
    "editMode": 0
}
fk_o_persidperson.persid auto increment
Kunde
INT (11)
R
yes
input_translated
Geben Sie die Kunden-ID eines Kunden ein.
i18n_string
"ecs.ORDER.fk_o_persid"
table
[ "eos_order" ]
drvd_select
eos_order.fk_o_persid
fieldset
"base_record"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "cssLayout": "col-12 col-md-6 col-xl-3",
    "mandatory": true,
    "editMode": 0
}
o_time_ordered auto increment
Bestell­datum
DATETIME
R
yes
i18n_string
"ecs.ORDER.o_time_ordered"
table
[ "eos_order" ]
drvd_select
eos_order.o_time_ordered
fieldset
"base_record"
listCfg
{
    "formatter": {
        "type": "date"
    },
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "cssLayout": "col-12 col-md-6 col-xl-3",
    "editMode": 0
}
total_netto [EUR] auto increment
∑ Gesamt, Netto
FLOAT (13,2)
R
no
i18n_string
"ecs.ORDER.total_netto"
table
[ "eos_order" ]
drvd_select
eos_order.total_netto
listCfg
{
    "formatter": {
        "type": "currency"
    },
    "viewMode": 0,
    "sumType": "SV",
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
total_brutto [EUR] auto increment
∑ Gesamt, Brutto
FLOAT (13,2)
R
no
i18n_string
"ecs.ORDER.total_brutto"
table
[ "eos_order" ]
drvd_select
eos_order.total_brutto
listCfg
{
    "formatter": {
        "type": "currency"
    },
    "sumType": "SV",
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
o_orderid_external auto increment
Externe Auftrags-Nr.
TEXT (255)
R
yes
input_translated
Geben Sie hier ggf. eine externe erhaltene Auftragsnummer ein. Diese bekommen Sie z.B. wenn der Auftrag über einen externen Marktplatz (z.B. Amazon Marketplace) erstellt wurde.
i18n_string
"ecs.ORDER.o_orderid_external"
table
[ "eos_order" ]
drvd_select
eos_order.o_orderid_external
fieldset
"base"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "cssLayout": "col-12 col-md-6 col-xl-3",
    "editMode": 0
}
fk_o_posidorderpos.posid auto increment
POS Channel (ID)
INT (11)
R
yes
i18n_string
"ecs.ORDER.fk_o_posid"
table
[ "eos_order" ]
drvd_select
eos_order.fk_o_posid
fieldset
"base"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "cssLayout": "col-12 col-md-6 col-xl-3",
    "editMode": 0
}
fk_o_stidorderstate.stid auto increment
Status
INT (11)
R
no
i18n_string
"ecs.ORDER.fk_o_stid"
table
[ "eos_order" ]
drvd_select
eos_order.fk_o_stid
fieldset
"base"
listCfg
{
    "viewMode": 3,
    "fullSearch": false
}
formCfg
{
    "cssLayout": "col-12 col-md-6 col-xl-3",
    "editMode": 0
}
fk_o_st_idshippingtype.st_id auto increment
Versandart
INT (11)
R
no
i18n_string
"ecs.ORDER.fk_o_st_id"
table
[ "eos_order" ]
drvd_select
eos_order.fk_o_st_id
fieldset
"base"
listCfg
{
    "viewMode": 3,
    "fullSearch": false
}
formCfg
{
    "cssLayout": "col-12 col-md-6 col-xl-3",
    "editMode": 0
}
o_pers_reftext auto increment
Kunden-Referenztext
TEXT
R
yes
input_translated
Geben Sie einen Referenztext des Kunden ein.
i18n_string
"ecs.ORDER.o_pers_reftext"
table
[ "eos_order" ]
drvd_select
eos_order.o_pers_reftext
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
o_pers_seq_nr auto increment
Auftrags-Sequenz-Nr.
INT (11)
R
no
i18n_string
"ecs.ORDER.o_pers_seq_nr"
table
[ "eos_order" ]
drvd_select
eos_order.o_pers_seq_nr
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
quantity auto increment
Bestellmenge
FLOAT (13,4)
R
no
i18n_string
"ecs.ORDER.quantity"
table
[ "eos_order" ]
drvd_select
eos_order.quantity
listCfg
{
    "viewMode": 0,
    "sumType": "SV",
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
drvd_total_vat [EUR] auto increment
MwSt. (Gesamt)
FLOAT (13,2)
R
no
i18n_string
"ecs.ORDER.drvd_total_vat"
table
[ "eos_order" ]
drvd_select
ROUND(eos_order.total_brutto - eos_order.total_netto, 2)
listCfg
{
    "formatter": {
        "type": "currency"
    },
    "viewMode": 0,
    "sumType": "SV",
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
currency auto increment
Währung
TEXT (3)
R
no
i18n_string
"ecs.ORDER.currency"
table
[ "eos_order" ]
drvd_select
eos_order.currency
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "editMode": 0
}
otitle auto increment
Auftragstitel
TEXT
R
yes
input_translated
Geben Sie dem Auftrag einen Titel.
i18n_string
"ecs.ORDER.otitle"
table
[ "eos_order" ]
drvd_select
eos_order.otitle
fieldset
"doc_header"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "cssLayout": "col-12",
    "editMode": 0
}
otext auto increment
Auftragsbeschreibung
TEXT
R
yes
i18n_string
"ecs.ORDER.otext"
table
[ "eos_order" ]
drvd_select
eos_order.otext
fieldset
"extra"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "type": "textarea",
    "editMode": 0
}
o_type auto increment
Auftragstyp
TEXT (15)
R
yes
enum
[ "order", "offer" ]
i18n_string
"ecs.ORDER.o_type"
table
[ "eos_order" ]
drvd_select
eos_order.o_type
fieldset
"base_record"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "cssLayout": "col-12 col-md-6 col-xl-3",
    "type": "eosdropdown",
    "value": "order",
    "options": {
        "optI18nValuePrefix": "ecs.o_type",
        "optI18nName": true,
        "data": {
            "options": [
                {
                    "value": "order"
                },
                {
                    "value": "offer"
                },
                {
                    "value": "tpl"
                }
            ]
        }
    },
    "editMode": 0
}
o_valid_until auto increment
Gültig bis
DATETIME
R
yes
i18n_string
"ecs.ORDER.o_valid_until"
table
[ "eos_order" ]
drvd_select
eos_order.o_valid_until
listCfg
{
    "viewMode": 0,
    "formatter": {
        "type": "date"
    },
    "fullSearch": false
}
formCfg
{
    "type": "datetimepicker",
    "editMode": 0
}
o_txt_header auto increment
Kopf-Text
TEXT
R
yes
input_translated
Kopf-Text für die Verwendung in PDFs
i18n_string
"ecs.ORDER.o_txt_header"
table
[ "eos_order" ]
drvd_select
eos_order.o_txt_header
fieldset
"doc_header"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "fieldSetCol": "12",
    "type": "eoseditor",
    "editMode": 0
}
invoice_addr_preset auto increment
Adressbuch (R)
TEXT
R
yes
i18n_string
"ecs.ORDER.invoice_addr_preset"
table
[ "eos_order" ]
drvd_select
NULL
fieldset
"inv_addr"
listCfg
{
    "viewMode": 3,
    "fullSearch": false
}
formCfg
{
    "cssLayout": "col-12",
    "type": "eosdropdown",
    "options": {
        "serverSideSearch": false,
        "valueType": "object",
        "optNameTemplate": "{%adr_lastname%}, {%adr_firstname%} ({%adr_company%})",
        "optSubTitleTemplate": "{%adr_extra1%} {%adr_street%} {%adr_housenr%}, {%adr_zip%} {%adr_town%} - {%adr_country%}",
        "optExtraTemplate": "{%adr_ref_type%}",
        "optDataLoad": [
            "adr_gender"
        ],
        "observer": {
            "fields": [
                {
                    "field": "fk_o_persid",
                    "trigger": "onInit",
                    "exec": [
                        {
                            "cmd": "loadOptions",
                            "params": {
                                "dataStreamCall": {
                                    "method": "paddress_getlist",
                                    "params": {
                                        "filter": {
                                            "adr_ref_id": "{%FIELD.value%}"
                                        }
                                    }
                                }
                            }
                        }
                    ]
                },
                {
                    "field": "fk_o_persid",
                    "trigger": "onChange",
                    "exec": [
                        {
                            "cmd": "loadOptions",
                            "params": {
                                "dataStreamCall": {
                                    "method": "paddress_getlist",
                                    "params": {
                                        "filter": {
                                            "adr_ref_id": "{%FIELD.value%}"
                                        }
                                    }
                                }
                            }
                        }
                    ]
                }
            ]
        }
    },
    "editMode": 0
}
invoice_gender auto increment
Anrede (R)
TEXT
R
yes
enum
[ "female", "male", "company", "divers" ]
i18n_string
"ecs.ORDER.invoice_gender"
table
[ "eos_order" ]
drvd_select
eos_order.invoice_gender
fieldset
"inv_addr"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}
formCfg
{
    "cssLayout": "col-6 col-xl-2",
    "type": "eosdropdown",
    "options": {
        "optI18nValuePrefix": "ecs.gender",
        "optI18nName": true,
        "data": {
            "options": [
                {
                    "value": null
                },
                {
                    "value": "female"
                },
                {
                    "value": "male"
                },
                {
                    "value": "company"
                },
                {
                    "value": "divers"
                }
            ]
        },
        "observer": {
            "fields": [
                {
                    "field": "invoice_addr_preset",
                    "trigger": "onChange",
                    "exec": [
                        {
                            "cmd": "template",
                            "params": {
                                "tpl": "{% FIELD.value.data.adr_gender %}"
                            }
                        }
                    ]
                }
            ]
        }
    },
    "editMode": 0
}
invoice_title auto increment
Titel (R)
TEXT
R
no
i18n_string
"ecs.ORDER.invoice_title"
table
[ "eos_order" ]
drvd_select
eos_order.invoice_title
fieldset
"inv_addr"
listCfg
{
    "viewMode": 0,
    "fullSearch": false
}