Model fields

The model consists of the following fields.

Field Name
Display Name
Type
Permissions
Nullable

product

xc__active
Aktiv
INT (1)
R+W
no
i18n_string
"cdb_record.xc__active"
fieldset
"cdb_meta"
listCfg
{
    "formatter": {
        "type": "active-flag"
    }
}
formCfg
{
    "type": "checkbox",
    "value": true
}
xc__searchable
Suchbar
INT (1)
R+W
no
i18n_string
"cdb_record.xc__searchable"
fieldset
"base"
listCfg
{
    "formatter": {
        "type": "active-flag"
    }
}
formCfg
{
    "type": "checkbox",
    "value": true
}
xc__version
Version
INT (11)
R
no
i18n_string
"cdb_record.xc__version"
xc__current
Aktuell
INT (1)
R
no
i18n_string
"cdb_record.xc__current"
xc__insert_user
Ersteller
TEXT (127)
R+W
yes
i18n_string
"insert_user"
fieldset
"sys_record"
listCfg
{
    "formatter": {
        "type": "user"
    },
    "viewMode": 0
}
formCfg
{
    "editMode": 2
}
xc__insert_time
Angelegt am
DATETIME
R+W
no
i18n_string
"insert_time"
fieldset
"sys_record"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "editMode": 2
}
xc__valid
Valide
INT (1)
R
no
i18n_string
"cdb_record.xc__valid"
xc__update_time
Geändert am
DATETIME
R+W
yes
i18n_string
"update_time"
fieldset
"sys_record"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "editMode": 2
}
xc__install_time
Installiert am
DATETIME
R+W
no
i18n_string
"plugin_install_time"
fieldset
"sys_plugin"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "editMode": 2
}
xc__publish_start
Veröffentlichung (Start)
DATETIME
R+W
yes
i18n_string
"cdb_record.xc__publish_start"
fieldset
"cdb_advanced"
formCfg
{
    "cssLayout": "col-6"
}
xc__publish_end
Veröffentlichung (Ende)
DATETIME
R+W
yes
i18n_string
"cdb_record.xc__publish_end"
fieldset
"cdb_advanced"
formCfg
{
    "cssLayout": "col-6"
}
xc__update_user
Letzte Änderung durch
TEXT (127)
R+W
yes
i18n_string
"update_user"
fieldset
"sys_record"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "editMode": 2
}
xc__ecms_data
eCMS-Daten
TEXT
R
yes
xc__id primary
ID
INT (11)
R+W
no
i18n_string
"cdb_record.xc__id"
fieldset
"cdb_base"
formCfg
{
    "type": "HIDDEN",
    "editMode": 1
}
drvd_xc_display
Titel
TEXT
R
no
i18n_string
"cdb_record.xc__title"
drvd_select
COALESCE(excdb_data_ecs_product_de.name,excdb_data_ecs_product_de.pcode)
formCfg
{
    "editMode": 0
}
drvd_is_master
Ist Masterprodukt
INT (1)
R
no
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"
    }
}
formCfg
{
    "editMode": 0
}
drvd_categories
Kategorien
DATA
R
yes
table
[ "i2n", "n" ]
drvd_select
CONCAT(" {\"model\": \"productgroup\",\"primaryKey\": \"node_id\",\"displayKey\": \"node_name\",\"data\": [",
                    GROUP_CONCAT(DISTINCT IF(n.node_id IS NULL, null, JSON_OBJECT(
                    'node_id',n.node_id,
                    'node_code',n.node_code,
                    'node_name', n.i18n_node_name_DE,
                    'node_path', n.i18n_node_path_DE
                    )) ORDER BY i2n.pos_n2i ASC, n.i18n_node_path_DE ASC SEPARATOR ",") ,"]}")
fieldset
"cdb_base_2"
listCfg
{
    "formatter": {
        "type": "sub-data-chip",
        "params": {
            "chipCssClass": "chip"
        }
    }
}
formCfg
{
    "type": "eossubmodel",
    "options": {
        "model": "productgroup"
    },
    "editMode": 1
}
category_code_list
Kategoriecode-Liste
TEXT
R
no
table
[ "i2n", "n" ]
drvd_select
GROUP_CONCAT(distinct n.node_code ORDER BY i2n.pos_n2i ASC SEPARATOR ";")
listCfg
{
    "viewMode": 0
}
formCfg
{
    "editMode": 1
}
category_path_list
Kategoriepfad-Liste
TEXT
R
no
table
[ "i2n", "n" ]
drvd_select
GROUP_CONCAT(distinct n.i18n_node_path_DE ORDER BY i2n.pos_n2i ASC SEPARATOR ";")
listCfg
{
    "viewMode": 0
}
formCfg
{
    "editMode": 1
}
node_id
INT
R
no
table
[ "n" ]
drvd_select
n.node_id
listCfg
{
    "viewMode": 3
}
formCfg
{
    "editMode": 0
}
node_code
TEXT (63)
R+W
no
table
[ "n" ]
listCfg
{
    "viewMode": 3
}
formCfg
{
    "editMode": 0
}
node_path
Kategoriepfad
TEXT
R
no
table
[ "n" ]
drvd_select
n.i18n_node_path_de
listCfg
{
    "viewMode": 3
}
formCfg
{
    "editMode": 1
}
node_idfather
INT (11)
R+W
no
table
[ "n" ]
listCfg
{
    "viewMode": 3
}
formCfg
{
    "editMode": 0
}
ngr_id
INT (11)
R+W
no
table
[ "n" ]
listCfg
{
    "viewMode": 3
}
formCfg
{
    "editMode": 0
}
lft
INT (11)
R+W
no
table
[ "n" ]
listCfg
{
    "viewMode": 3
}
formCfg
{
    "editMode": 0
}
rgt
INT (11)
R+W
no
table
[ "n" ]
listCfg
{
    "viewMode": 3
}
formCfg
{
    "editMode": 0
}
drvd_category_code
Kategorie-Code
TEXT
R
no
table
[ "n" ]
drvd_select
n.node_code
listCfg
{
    "viewMode": 3
}
formCfg
{
    "editMode": 0
}
drvd_category_id
INT
R
no
table
[ "n" ]
drvd_select
n.node_id
listCfg
{
    "viewMode": 3
}
formCfg
{
    "editMode": 0
}
drvd_category_name
Kategorie-Name
TEXT
R
no
table
[ "n" ]
drvd_select
n.i18n_node_name_DE
listCfg
{
    "viewMode": 3
}
formCfg
{
    "editMode": 0
}
drvd_category_path
Kategorie-Pfad
TEXT
R
no
table
[ "n" ]
drvd_select
n.i18n_node_path_DE
listCfg
{
    "viewMode": 3
}
formCfg
{
    "editMode": 0
}
pcode primaryDisplay
Produktcode
TEXT
R+W
yes
input_translated
Häufig hilfreich, wenn ähnliche oder Varianten-Produkte auch angrenzende Nummern hier verwenden und einen gleichen Prefix haben.
fieldset
"cdb_base"
formCfg
{
    "mandatory": true
}
name
Name
TEXT
R+W
yes
fieldset
"cdb_base"
formCfg
{
    "mandatory": true
}
master_pcode
Varianten-Master PCode
TEXT
R+W
yes
input_translated
Bei Einzelprodukten (ohne Varianten) ist dies gleich dem PCode. Bei Variantenprodukten wird hier der PCode des Hauptprodukts der Variantengruppe eingetragen.
fieldset
"cdb_base"
formCfg
{
    "type": "text",
    "options": {
        "XXXobserver": {
            "fields": [
                {
                    "field": "pcode",
                    "trigger": "onChange",
                    "exec": [
                        {
                            "cmd": "copy"
                        }
                    ]
                }
            ]
        }
    },
    "mandatory": true
}
prdv_color
Varianten-Farbe
TEXT
R+W
yes
fieldset
"cdb_base"
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
}
prdv_size
Varianten-Größe
TEXT
R+W
yes
fieldset
"cdb_base"
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
}
prdv_other
Varianten-Ausführung
TEXT
R+W
yes
fieldset
"cdb_base"
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
}
prd_comment
Kommentar
TEXT
R+W
yes
fieldset
"comment"
formCfg
{
    "type": "textarea",
    "mandatory": false
}
files_doc
Produkt-Dateien
DATA
R+W
yes
fieldset
"cdb_media"
formCfg
{
    "type": "eosmedia",
    "options": {
        "uploadDirDefault": "\/products"
    },
    "mandatory": false
}
pack_amount
Verpackungs­menge
FLOAT
R+W
yes
fieldset
"packaging"
formCfg
{
    "type": "eosnumber",
    "mandatory": false
}
pack_unit
Verpackungs­einheit
TEXT
R+W
yes
fieldset
"packaging"
formCfg
{
    "type": "text",
    "mandatory": false
}
prd_ingr_amount
Verpackungs­inhalt (Menge)
FLOAT
R+W
yes
fieldset
"packaging"
formCfg
{
    "type": "eosnumber",
    "mandatory": false
}
prd_ingr_unit
Verpackungs­inhalt (Einheit)
TEXT
R+W
yes
fieldset
"packaging"
formCfg
{
    "type": "text",
    "mandatory": false
}
prd_weight [g]
Produktgewicht
FLOAT
R+W
yes
fieldset
"dimensions"
formCfg
{
    "type": "eosnumber",
    "mandatory": false
}
prd_virtual
Virtuelles Produkt
TEXT
R+W
yes
fieldset
"virtual"
formCfg
{
    "type": "checkbox",
    "mandatory": false
}
products_replace
Nachfolge­produkte
DATA
R+W
yes
input_translated
Produkte durch Drag-and-Drop hinzufügen. Beispielsweise aus der Trefferliste der "Hublify Suche".
fieldset
"cdb_marketing"
listCfg
{
    "formatter": {
        "type": "sub-data-chip",
        "params": {
            "chipCssClass": "chip"
        }
    }
}
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
}
pcode_manufacturer
Hersteller-PCode
TEXT
R+W
yes
fieldset
"cdb_base"
formCfg
{
    "type": "text",
    "mandatory": false
}
brand
Brand
TEXT
R+W
yes
fieldset
"cdb_base"
formCfg
{
    "mandatory": false
}
products_upselling
Upselling-Produkte
DATA
R+W
yes
input_translated
Produkte durch Drag-and-Drop hinzufügen. Beispielsweise aus der Trefferliste der "Hublify Suche".
fieldset
"cdb_marketing"
listCfg
{
    "formatter": {
        "type": "sub-data-chip",
        "params": {
            "chipCssClass": "chip"
        }
    }
}
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
}
products_related
Zugehörige Produkte
DATA
R+W
yes
orderitem_name
Auftrags­posten-Name
TEXT
R+W
yes
fieldset
"proc_order"
formCfg
{
    "type": "text",
    "mandatory": false
}
orderitem_text
Auftrags­posten-Text
TEXT
R+W
yes
fieldset
"proc_order"
formCfg
{
    "type": "text",
    "mandatory": false
}
marketing_name
Marketing-Name
TEXT
R+W
yes
fieldset
"cdb_marketing"
formCfg
{
    "mandatory": false
}
marketing_teaser
Marketing-Teaser
TEXT
R+W
yes
fieldset
"cdb_marketing"
formCfg
{
    "type": "eoseditor",
    "options": {
        "useCfgPreset": "basic"
    },
    "mandatory": false
}
marketing_image
Marketing-Bild
DATA
R+W
yes
fieldset
"cdb_marketing"
formCfg
{
    "type": "eosmedia",
    "options": {
        "uploadDirDefault": "\/products"
    },
    "mandatory": false
}
new_product
Neues Produkt?
TEXT
R+W
yes
fieldset
"cdb_marketing"
formCfg
{
    "type": "checkbox",
    "mandatory": false
}
special_offer_product
Special-Offer Produkt?
TEXT
R+W
yes
fieldset
"cdb_marketing"
formCfg
{
    "type": "checkbox",
    "mandatory": false
}
plugin
Plugin
TEXT
R+W
yes
fieldset
"cdb_advanced"
formCfg
{
    "mandatory": false
}
meta_title
Produkt-Meta-Titel
TEXT
R+W
yes
fieldset
"cdb_meta"
formCfg
{
    "type": "text",
    "mandatory": false
}
meta_keywords
Produkt-Meta-Keywords
TEXT
R+W
yes
fieldset
"cdb_meta"
formCfg
{
    "type": "text",
    "mandatory": false
}
meta_description
Produkt-Meta-Beschreibung
TEXT
R+W
yes
fieldset
"cdb_meta"
formCfg
{
    "type": "textarea",
    "mandatory": false
}
meta_robots_noindex
Produkt-Meta-Robots-NoIndex
TEXT
R+W
yes
fieldset
"cdb_meta"
formCfg
{
    "type": "checkbox",
    "mandatory": false
}
meta_robots_nofollow
Produkt-Meta-Robots-NoFollow
TEXT
R+W
yes
fieldset
"cdb_meta"
formCfg
{
    "type": "checkbox",
    "mandatory": false
}
marketing_image_background
Marketing-Hintergrundbild
DATA
R+W
yes
fieldset
"cdb_marketing"
formCfg
{
    "type": "eosmedia",
    "options": {
        "uploadDirDefault": "\/products"
    },
    "mandatory": false
}
marketing_overlay_html
Marketing-Overlay-HTML
TEXT
R+W
yes
fieldset
"cdb_marketing"
formCfg
{
    "mandatory": false
}
description_seo
SEO-Beschreibung
TEXT
R+W
yes
fieldset
"cdb_meta"
formCfg
{
    "type": "eoseditor",
    "mandatory": false
}
prd_width [mm]
Produktgröße - Breite
FLOAT
R+W
yes
fieldset
"dimensions"
formCfg
{
    "type": "eosnumber",
    "mandatory": false
}
prd_height [mm]
Produktgröße - Höhe
FLOAT
R+W
yes
fieldset
"dimensions"
formCfg
{
    "type": "eosnumber",
    "mandatory": false
}
prd_depth [mm]
Produktgröße - Tiefe
FLOAT
R+W
yes
fieldset
"dimensions"
formCfg
{
    "type": "eosnumber",
    "mandatory": false
}
prd_rating_avg
FLOAT
R+W
yes
fieldset
"cdb_base"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "type": "hidden",
    "mandatory": false
}
prd_rating_cnt
TEXT
R+W
yes
fieldset
"cdb_base"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "type": "hidden",
    "mandatory": false
}
convertable_pack_unit
DATA
R+W
yes
fieldset
"packaging"
listCfg
{
    "formatter": {
        "type": "sub-data-chip",
        "params": {
            "chipCssClass": "chip"
        }
    }
}
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
}
prd_accounting_cost_center
Buchhaltung Kostenstelle
TEXT
R+W
yes
fieldset
"proc_accounting"
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
}
prd_accounting_revenue_account
Buchhaltung Erlöskonto
TEXT
R+W
yes
fieldset
"proc_accounting"
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
}
base_color → color.xc__label
Grundfarbe
TEXT
R+W
yes
fieldset
"cdb_base"
formCfg
{
    "mandatory": false
}
html_canonical
TEXT
R+W
yes
fieldset
"cdb_meta"
formCfg
{
    "type": "checkbox",
    "mandatory": false
}
pack_size_width [mm]
Verpackungs­größe - Breite
TEXT
R+W
yes
fieldset
"packaging"
formCfg
{
    "mandatory": false
}
pack_size_height [mm]
Verpackungs­größe - Höhe
TEXT
R+W
yes
fieldset
"packaging"
formCfg
{
    "mandatory": false
}
pack_size_depth [mm]
Verpackungs­größe - Tiefe
TEXT
R+W
yes
fieldset
"packaging"
formCfg
{
    "mandatory": false
}
pack_weight [g]
Verpackungs­gewicht
FLOAT
R+W
yes
fieldset
"packaging"
formCfg
{
    "type": "eosnumber",
    "mandatory": false
}
features
DATA
R+W
yes
fieldset
"cdb_marketing"
listCfg
{
    "formatter": {
        "type": "sub-data-chip",
        "params": {
            "chipCssClass": "chip"
        }
    }
}
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
}
drvd_features__feature__label
text (255)
R
no
table
[ "features__feature", "features__r2r__159" ]
drvd_select
features__feature.label
drvd_features__feature__name
text
R
no
table
[ "features__feature", "features__r2r__159" ]
drvd_select
features__feature.name
drvd_features__feature__short_description
text
R
no
table
[ "features__feature", "features__r2r__159" ]
drvd_select
features__feature.short_description
drvd_features__feature__description
text
R
no
table
[ "features__feature", "features__r2r__159" ]
drvd_select
features__feature.description
drvd_features__feature__type
text (63)
R
no
table
[ "features__feature", "features__r2r__159" ]
drvd_select
features__feature.type
gtin
GTIN/EAN
TEXT
R+W
yes
fieldset
"cdb_base"
formCfg
{
    "type": "text",
    "mandatory": false
}
ppn
PPN
TEXT
R+W
yes
fieldset
"cdb_base"
formCfg
{
    "type": "text",
    "mandatory": false
}
origin_country
Ursprungsland
TEXT
R+W
yes
fieldset
"extra"
formCfg
{
    "mandatory": false
}
customs_tariff_number
HS-Tariff-Code
TEXT
R+W
yes
fieldset
"extra"
listCfg
{
    "view_mode": 0
}
formCfg
{
    "mandatory": false
}
customs_value_amount
TEXT
R+W
yes
fieldset
"extra"
listCfg
{
    "view_mode": 0
}
formCfg
{
    "unit": "EUR",
    "type": "eosnumber",
    "options": {
        "decimalsCalculate": 2,
        "decimalshowMin": 2,
        "decimalshowMax": 2
    },
    "mandatory": false
}
customs_description
Zoll-Beschreibung
TEXT
R+W
yes
fieldset
"extra"
listCfg
{
    "view_mode": 0
}
formCfg
{
    "mandatory": false
}
files_download
Download-Dateien
DATA
R+W
yes
fieldset
"cdb_media"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "type": "eosmedia",
    "options": {
        "uploadDirDefault": "\/products",
        "xDataDialogConfig": {
            "layoutLabel": "mamasset_2_prd_filesdownload_popup"
        },
        "xDataKey": "a2r_xdata"
    },
    "mandatory": false
}
products_contain
Produkte im Bundle
DATA
R+W
yes
fieldset
"bundle"
listCfg
{
    "formatter": {
        "type": "sub-data-chip",
        "params": {
            "chipCssClass": "chip"
        }
    }
}
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
}
prd_keywords
Keywords
TEXT
R+W
yes
fieldset
"cdb_advanced"
formCfg
{
    "mandatory": false
}
files_img
Bilder
DATA
R+W
yes
input_translated
Bilder mit Drag-and-Drop hinzufügen. Entweder aus Hublify Media-Manager oder von eigener Festplatte.
fieldset
"cdb_base_2"
formCfg
{
    "type": "eosmedia",
    "options": {
        "uploadDirDefault": "\/products"
    },
    "mandatory": false
}
prd_bundle_price_discount_perc [%]
Bundle-Preis %-Discount
FLOAT
R+W
yes
fieldset
"bundle"
formCfg
{
    "mandatory": false
}
desc_short
Kurz­beschreibung
TEXT
R+W
yes
fieldset
"cdb_base_2"
formCfg
{
    "type": "eoseditor",
    "options": {
        "useCfgPreset": "basic"
    },
    "mandatory": false
}
description
Beschreibung
TEXT
R+W
yes
fieldset
"cdb_base_2"
formCfg
{
    "type": "eoseditor",
    "options": {
        "useCfgPreset": "rich",
        "hfyImgUpload": true,
        "hfyImgUploadDir": "products\/content",
        "hfyContentBrowser": true
    },
    "mandatory": false
}
prd_snr_xdata_subtype
Zusatzdaten-Typ
TEXT
R+W
yes
fieldset
"cdb_base_2"
formCfg
{
    "type": "eosdropdown",
    "options": {
        "serverSideSearch": false,
        "dataStreamCall": {
            "method": "prd_subtypes_getOptions"
        }
    },
    "mandatory": false
}
prd_bundle_resolve_mode
Bundle-Modus
TEXT
R+W
yes
fieldset
"bundle"
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
}
desc_tech
Technische Beschreibung
TEXT
R+W
yes
fieldset
"cdb_base_2"
formCfg
{
    "mandatory": false
}
manufacturer → manufacturer.xc__label
Hersteller
TEXT
R+W
yes
fieldset
"cdb_base"
formCfg
{
    "mandatory": false
}
xc__label
TEXT
R
yes
table
[ "excdb_data_ecs_product_de" ]
drvd_select
excdb_data_ecs_product_de.pcode
fieldset
"cdb_base"
formCfg
{
    "type": "HIDDEN",
    "editMode": 0
}
xc__title
TEXT
R
yes
table
[ "excdb_data_ecs_product_de" ]
drvd_select
excdb_data_ecs_product_de.name
fieldset
"cdb_base"
formCfg
{
    "type": "HIDDEN",
    "editMode": 0
}
xc__image
DATA
R
yes
table
[ "excdb_data_ecs_product_de" ]
drvd_select
excdb_data_ecs_product_de.files_img
fieldset
"cdb_base_2"
formCfg
{
    "type": "HIDDEN",
    "editMode": 0
}
drvd_pagealias_master_url
Seiten-Alias Master
TEXT
R
no
i18n_string
"ecms.CDB_RECORD.drvd_pagealias_master_url"
table
[ "ecms_page_alias" ]
drvd_select
GROUP_CONCAT(DISTINCT IF(pa_master=1, pa_filename, NULL) SEPARATOR ",")
fieldset
"page_alias"
drvd_pagealias_alternative_url
Seiten-Alias Alternativen
TEXT
R
no
i18n_string
"ecms.CDB_RECORD.drvd_pagealias_alternative_url"
table
[ "ecms_page_alias" ]
drvd_select
GROUP_CONCAT(DISTINCT IF(ecms_page_alias.pa_master != 1, ecms_page_alias.pa_filename, NULL) SEPARATOR ",")
fieldset
"page_alias"
prc_id primary auto increment
Preis-ID
INT (11)
R+W
no
table
"prc"
fieldset
"base_record"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "type": "hidden"
}
state
Shop Status
INT (3)
R+W
no
input_translated
Legt fest, ob das Produkt überhaupt in dem gewähltem Shop sichtbar sein soll.
valueColorField
"state_color"
table
"prc"
fieldset
"cdb_base"
listCfg
{
    "formatter": {
        "type": "status",
        "params": {
            "statusColorField": "state_color"
        }
    }
}
formCfg
{
    "type": "eosdropdown",
    "options": {
        "clearable": false,
        "data": {
            "options": [
                {
                    "value": "0",
                    "name": "0 - unbekannt",
                    "color": "#A3CBEB",
                    "iconLabel": "hublify\/circle",
                    "iconColor": "#A3CBEB"
                },
                {
                    "value": "1",
                    "name": "1 - offline",
                    "color": "#CE0002",
                    "iconLabel": "hublify\/subtract-circle",
                    "iconWeight": "bold",
                    "iconColor": "#CE0002"
                },
                {
                    "value": "2",
                    "name": "2 - online",
                    "color": "#85B200",
                    "iconLabel": "hublify\/check-circle",
                    "iconWeight": "bold",
                    "iconColor": "#85B200"
                }
            ]
        },
        "optValueColorField": "state_color",
        "optIconColorField": "state_color"
    }
}
state_color
Shop Status - Farbe
TEXT (15)
R
yes
table
"prc"
drvd_select
CASE prc.state WHEN 1 THEN "#CE0002" WHEN 2 THEN "#85B200" ELSE "#CCCCCC" END
fieldset
"price_base"
listCfg
{
    "viewMode": 3
}
formCfg
{
    "editMode": 0
}
price [EUR]
Preis (Brutto)
FLOAT (13,2)
R+W
no
table
"prc"
fieldset
"price_base"
listCfg
{
    "formatter": {
        "type": "currency"
    }
}
formCfg
{
    "type": "hfyprice",
    "options": {
        "valueVatType": "brutto",
        "vatField": "vat",
        "sessionStatePresetId": "PIM__primaryPriceMode",
        "sessionStateId": "PIM__prd__price",
        "decimalsCalculate": 2,
        "decimalshowMin": 2,
        "decimalshowMax": 2,
        "observer": {
            "fields": [
                {
                    "field": "vat",
                    "trigger": "onChange",
                    "exec": [
                        {
                            "cmd": "setVat"
                        }
                    ]
                }
            ]
        }
    }
}
vat [%]
Mehrwertsteuer
FLOAT (6,2)
R+W
no
table
"prc"
fieldset
"price_base"
listCfg
{
    "formatter": {
        "type": "decimal",
        "params": {
            "unit": " %",
            "format": "1.0-1"
        }
    },
    "viewMode": 0
}
formCfg
{
    "type": "eosnumber",
    "options": {
        "decimalsCalculate": 2,
        "decimalshowMin": 0,
        "decimalshowMax": 2
    }
}
discount [EUR]
Discount-Preis (Brutto)
FLOAT (13,2)
R+W
no
table
"prc"
fieldset
"price_base"
listCfg
{
    "formatter": {
        "type": "currency"
    }
}
formCfg
{
    "type": "hfyprice",
    "options": {
        "valueVatType": "brutto",
        "vatField": "vat",
        "sessionStatePresetId": "PIM__prd__price",
        "decimalsCalculate": 2,
        "decimalshowMin": 2,
        "decimalshowMax": 2,
        "observer": {
            "fields": [
                {
                    "field": "vat",
                    "trigger": "onChange",
                    "exec": [
                        {
                            "cmd": "setVat"
                        }
                    ]
                }
            ]
        }
    }
}
discount_text
Discount-Text
TEXT
R+W
yes
table
"prc"
fieldset
"price_base"
listCfg
{
    "viewMode": 0
}
discount_start
Discount Startdatum
DATETIME
R+W
yes
table
"prc"
fieldset
"price_base"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "type": "datetimepicker"
}
discount_end
Discount Enddatum
DATETIME
R+W
yes
table
"prc"
fieldset
"price_base"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "type": "datetimepicker"
}
drvd_price_netto
Netto Preis
FLOAT (13,2)
R
no
i18n_string
"ecs.PRICE.drvd_price_netto"
table
"prc"
drvd_select
ROUND((prc.price / ( (100+ prc.vat) / 100 ) ), 2)
fieldset
"price_base"
drvd_price_discount_netto
Discount Netto Preis
FLOAT (13,2)
R
no
i18n_string
"ecs.PRICE.drvd_price_discount_netto"
table
"prc"
drvd_select
ROUND((prc.discount / ( (100+ prc.vat) / 100 ) ), 2)
fieldset
"price_base"
drvd_current_price_brutto
Aktueller Brutto­preis
FLOAT (13,2)
R
no
i18n_string
"ecs.PRICE.drvd_current_price_brutto"
table
"prc"
drvd_select
IF(((prc.discount > 0.00 AND (prc.discount < prc.price || prc.price = 0.00)) AND (prc.discount_start IS NULL || prc.discount_start < '2022-03-31 19:06:26')  AND (prc.discount_end IS NULL || prc.discount_end < '2022-03-31 19:06:26')), prc.discount, prc.price)
fieldset
"price_base"
drvd_discount_diff_brutto [EUR]
Discount Preisminderung (brutto)
FLOAT (13,2)
R
no
table
"prc"
drvd_select
IF((prc.discount>0.00 AND (prc.discount_start IS NULL || prc.discount_start < '2022-03-31 19:06:26') AND (prc.discount_end IS NULL || prc.discount_end > '2022-03-31 19:06:26')), prc.price-prc.discount, NULL)
fieldset
"price_base"
listCfg
{
    "formatter": {
        "type": "currency"
    }
}
formCfg
{
    "editMode": 0
}
drvd_current_price_netto
Aktueller Netto­preis
FLOAT (13,2)
R
no
i18n_string
"ecs.PRICE.drvd_current_price_netto"
table
"prc"
drvd_select
ROUND((IF(((prc.discount > 0.00 AND (prc.discount < prc.price || prc.price = 0.00)) AND (prc.discount_start IS NULL || prc.discount_start < '2022-03-31 19:06:26')  AND (prc.discount_end IS NULL || prc.discount_end < '2022-03-31 19:06:26')), prc.discount, prc.price) / ( (100+ prc.vat) / 100 ) ) ,2)
fieldset
"price_base"
drvd_discount_diff_netto [EUR]
Discount Preisminderung (netto)
FLOAT (13,2)
R
no
table
"prc"
drvd_select
IF(prc.discount>0.00 AND (prc.discount_start IS NULL || prc.discount_start < '2022-03-31 19:06:26') AND (prc.discount_end IS NULL || prc.discount_end > '2022-03-31 19:06:26'), ROUND(prc.price*100/(100+prc.vat),2)-ROUND(prc.discount*100/(100+prc.vat),2), NULL)
fieldset
"price_base"
listCfg
{
    "formatter": {
        "type": "currency"
    }
}
formCfg
{
    "editMode": 0
}
drvd_currently_discounted
INT (1)
R
no
table
"prc"
drvd_select
IF(prc.discount>0.00 AND prc.discount '2022-03-31 19:06:26'), 1, 0)
fieldset
"price_base"
listCfg
{
    "viewMode": 0,
    "formatter": {
        "type": "active-flag"
    }
}
formCfg
{
    "editMode": 0
}
price_dsc_scale
Preis-Staffel
DATA
R+W
yes
table
"prc"
fieldset
"price_base"
listCfg
{
    "viewMode": 0,
    "formatter": {
        "type": "sub-scale-price"
    }
}
formCfg
{
    "type": "eossubformarray",
    "options": {
        "model": "priceScale",
        "sortable": true,
        "enableAdd": true,
        "enableRemove": true,
        "itemsMinCount": 0,
        "itemsMaxCount": -1,
        "fieldDefinition": {
            "qty_range_min": {
                "type": "eosnumber",
                "hideLabel": true,
                "options": {
                    "prepend": "\u2265"
                }
            },
            "value": {
                "type": "eosnumber",
                "options": {
                    "decimalsCalculate": 2,
                    "decimalshowMin": 0,
                    "decimalshowMax": 2
                },
                "hideLabel": true
            },
            "type": {
                "type": "eosdropdown",
                "hideLabel": true,
                "options": {
                    "optI18nValuePrefix": "ecs.pricescale",
                    "optI18nName": true,
                    "optI18nSubTitle": true,
                    "data": {
                        "options": [
                            {
                                "value": "price_brutto"
                            },
                            {
                                "value": "price_netto"
                            },
                            {
                                "value": "discount_brutto_abs"
                            },
                            {
                                "value": "discount_netto_abs"
                            },
                            {
                                "value": "discount_perc"
                            },
                            {
                                "value": "poa"
                            }
                        ]
                    }
                }
            }
        },
        "layoutSettings": {
            "hideTabs": true,
            "tabs": [
                {
                    "label": "base",
                    "cssLayoutGroupDefault": "col-12",
                    "groups": [
                        {
                            "label": "price_scale",
                            "hideHeader": true,
                            "fdLabelLayoutDefault": "vt",
                            "fields": [
                                {
                                    "field": "qty_range_min",
                                    "cssLayout": "col-3"
                                },
                                {
                                    "field": "type",
                                    "cssLayout": "col-6"
                                },
                                {
                                    "field": "value",
                                    "cssLayout": "col-3"
                                }
                            ]
                        }
                    ]
                }
            ]
        }
    }
}
fk_prc_prcgrp_id → price_group.prcgrp_id
Preis-Gruppe
INT (11)
R+W
yes
table
"prc"
fieldset
"price_base"
listCfg
{
    "viewMode": 0
}
price_wholesale [EUR]
EK (Netto)
FLOAT (13,2)
R+W
yes
table
"prc"
fieldset
"price_base"
listCfg
{
    "formatter": {
        "type": "currency"
    },
    "viewMode": 0
}
formCfg
{
    "type": "eosnumber",
    "options": {
        "decimalsCalculate": 2,
        "decimalshowMin": 2,
        "decimalshowMax": 2
    }
}
drvd_prd_margin_gross [%]
Handelsspanne
FLOAT (11,2)
R
no
table
"prc"
drvd_select
IF(prc.price_wholesale IS NULL, NULL, (1-( prc.price_wholesale*(100+prc.vat) / (prc.price*100)) )*100 )
fieldset
"price_base"
listCfg
{
    "formatter": {
        "type": "decimal",
        "params": {
            "unit": " %",
            "format": "1.0-1"
        }
    }
}
formCfg
{
    "editMode": 0
}
drvd_prd_profit_perc [%]
Gewinn Marge
FLOAT (11,2)
R
yes
table
"prc"
drvd_select
IF(prc.price_wholesale IS NULL, NULL, ROUND( ((prc.price*100/(100+prc.vat))-prc.price_wholesale)*100/prc.price_wholesale,2))
fieldset
"price_base"
listCfg
{
    "formatter": {
        "type": "decimal",
        "params": {
            "unit": " %",
            "format": "1.0-1"
        }
    }
}
formCfg
{
    "editMode": 0
}
drvd_prd_profit [EUR]
Gewinn
FLOAT (13,4)
R
yes
table
"prc"
drvd_select
(prc.price*100/(100+prc.vat)) - prc.price_wholesale
fieldset
"price_base"
listCfg
{
    "formatter": {
        "type": "currency"
    },
    "viewMode": 0,
    "sum_type": "AVG"
}
formCfg
{
    "editMode": 0
}
prd_storage_counter
Lager­bestand
FLOAT (13,4)
R+W
yes
table
"prc"
fieldset
"price_availability"
formCfg
{
    "type": "eosnumber",
    "options": {
        "decimalsCalculate": 4,
        "decimalshowMin": 0,
        "decimalshowMax": 4
    }
}
prd_storage_counter_update_time
Letzte Bestands­aktualisierung
DATETIME
R
yes
table
"prc"
fieldset
"price_base"
listCfg
{
    "viewMode": 0
}
drvd_storage_wholesale_value [EUR]
FLOAT (13,2)
R
no
table
"prc"
drvd_select
ROUND(prc.prd_storage_counter*prc.price_wholesale,2)
fieldset
"price_availability"
listCfg
{
    "formatter": {
        "type": "currency"
    }
}
formCfg
{
    "editMode": 0
}
drvd_storage_brutto_value [EUR]
FLOAT (13,2)
R
no
table
"prc"
drvd_select
ROUND(prc.prd_storage_counter*prc.price,2)
fieldset
"price_availability"
listCfg
{
    "formatter": {
        "type": "currency"
    }
}
formCfg
{
    "editMode": 0
}
drvd_storage_netto_value [EUR]
FLOAT (13,2)
R
no
table
"prc"
drvd_select
ROUND(prc.prd_storage_counter* ROUND(prc.price*100/(100+prc.vat),2),2)
fieldset
"price_availability"
listCfg
{
    "formatter": {
        "type": "currency"
    }
}
formCfg
{
    "editMode": 0
}
drvd_storage_profit_value [EUR]
FLOAT (13,2)
R
no
table
"prc"
drvd_select
ROUND(prc.prd_storage_counter* (ROUND(prc.price*100/(100+prc.vat),2)-prc.price_wholesale),2)
fieldset
"price_availability"
listCfg
{
    "formatter": {
        "type": "currency"
    }
}
formCfg
{
    "editMode": 0
}
prd_storage_limit_notify
Info geringer Bestand
FLOAT (13,4)
R+W
yes
table
"prc"
fieldset
"price_availability"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "type": "eosnumber",
    "options": {
        "decimalsCalculate": 4,
        "decimalshowMin": 0,
        "decimalshowMax": 4
    }
}
prd_storage_limit_reorder
Info Nachbestellung
FLOAT (13,4)
R+W
yes
table
"prc"
fieldset
"price_availability"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "type": "eosnumber",
    "options": {
        "decimalsCalculate": 4,
        "decimalshowMin": 0,
        "decimalshowMax": 4
    }
}
order_quanti_max
Max. Bestellmenge
FLOAT (13,4)
R+W
yes
table
"prc"
fieldset
"price_availability"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "type": "eosnumber",
    "options": {
        "decimalsCalculate": 4,
        "decimalshowMin": 0,
        "decimalshowMax": 4
    }
}
order_quanti_min
Min. Bestellmenge
FLOAT (13,4)
R+W
yes
table
"prc"
fieldset
"price_availability"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "type": "eosnumber",
    "options": {
        "decimalsCalculate": 4,
        "decimalshowMin": 0,
        "decimalshowMax": 4
    }
}
order_quanti_inc
Schritt Bestellmenge
FLOAT (13,4)
R+W
yes
table
"prc"
fieldset
"price_availability"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "type": "eosnumber",
    "options": {
        "decimalsCalculate": 4,
        "decimalshowMin": 0,
        "decimalshowMax": 4
    }
}
offer_level
Offer-Level
INT (11)
R+W
no
table
"prc"
fieldset
"cdb_meta"
formCfg
{
    "type": "eosnumber"
}
prd_delivery
Lieferhinweis
TEXT
R+W
yes
table
"prc"
fieldset
"price_availability"
searchable
Suchbar
INT (1)
R+W
no
table
"prc"
fieldset
"cdb_advanced"
listCfg
{
    "viewMode": 0,
    "formatter": {
        "type": "active-flag"
    }
}
formCfg
{
    "type": "checkbox"
}
single_buy
Kaufbar
INT (1)
R+W
no
table
"prc"
fieldset
"price_availability"
listCfg
{
    "viewMode": 0,
    "formatter": {
        "type": "active-flag"
    }
}
formCfg
{
    "type": "checkbox"
}
available_date
Verfügbar ab
DATETIME
R+W
yes
table
"prc"
fieldset
"price_availability"
listCfg
{
    "viewMode": 0
}
hide_price_dsp
Preis ausblenden
INT (1)
R+W
no
table
"prc"
fieldset
"price_availability"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "type": "eosdropdown",
    "options": {
        "optI18nValuePrefix": "ecs.hide_price_dsp",
        "optI18nName": true,
        "data": {
            "options": [
                {
                    "value": "0"
                },
                {
                    "value": "1"
                },
                {
                    "value": "2"
                }
            ]
        },
        "optValueColorField": "state_color",
        "optIconLabel": "hublify\/circle",
        "optIconColorField": "state_color"
    }
}
bookable
Vorbestellung möglich
INT (1)
R+W
no
table
"prc"
fieldset
"price_availability"
listCfg
{
    "viewMode": 0,
    "formatter": {
        "type": "active-flag"
    }
}
formCfg
{
    "type": "checkbox"
}
free_shipping
Versand­kosten­frei
TEXT
R+W
no
table
"prc"
fieldset
"price_base"
listCfg
{
    "viewMode": 0
}
xdata
Zusatzdaten
DATA
R+W
yes
table
"prc"
fieldset
"price_base"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "cssLayout": "col-12",
    "type": "aceeditor",
    "options": {
        "mode": "json"
    }
}
price_first_online
Erstmalig gelistet am
DATETIME
R
yes
table
"prc"
fieldset
"price_base"
listCfg
{
    "viewMode": 0
}
prc_insert_time
Angelegt am
DATETIME
R+W
no
i18n_string
"insert_time"
table
"prc"
fieldset
"sys_record"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "editMode": 2
}
prc_insert_user
Ersteller
TEXT (127)
R+W
yes
i18n_string
"insert_user"
table
"prc"
fieldset
"sys_record"
listCfg
{
    "formatter": {
        "type": "user"
    },
    "viewMode": 0
}
formCfg
{
    "editMode": 2
}
prc_update_time
Geändert am
DATETIME
R+W
yes
i18n_string
"update_time"
table
"prc"
fieldset
"sys_record"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "editMode": 2
}
prc_update_user
Letzte Änderung durch
TEXT (127)
R+W
yes
i18n_string
"update_user"
table
"prc"
fieldset
"sys_record"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "editMode": 2
}
prc_external_id
Externe Preis-ID
TEXT (63)
R
yes
table
"prc"
fieldset
"price_base"
listCfg
{
    "viewMode": 0
}
prc_configurator_adaptor
Konfiguration-Typ
TEXT
R+W
yes
table
"prc"
fieldset
"configurator_head"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "type": "eosdropdown",
    "options": {
        "serverSideSearch": true,
        "dataStreamCall": {
            "method": "product_configurator_getList"
        },
        "optValueField": "label",
        "optNameField": "name",
        "optSubTitleField": "shortdesc",
        "optIconLabelField": "icon",
        "optExtraField": "vendor"
    }
}
prc_configurator_params
Konfiguration
TEXT
R+W
yes
table
"prc"
fieldset
"configurator_body"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "type": "eossubform",
    "options": {
        "dynSubForm": {
            "labelDefault": null,
            "loadDataStreamCall": {
                "method": "product_configurator_get",
                "params": {
                    "fields": [],
                    "filter": {
                        "label": "{%label%}"
                    }
                }
            }
        },
        "observer": {
            "fields": [
                {
                    "field": "prc_configurator_adaptor",
                    "trigger": "onInit",
                    "exec": [
                        {
                            "cmd": "loadForm",
                            "params": null
                        }
                    ]
                },
                {
                    "field": "prc_configurator_adaptor",
                    "trigger": "onChange",
                    "exec": [
                        {
                            "cmd": "loadForm",
                            "params": null
                        }
                    ]
                }
            ]
        }
    }
}
drvd_variant_specification
Ausprägung
TEXT
R
no
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)
currency
TEXT
R
no
drvd_select
"EUR"
xc__drvd_category
Kategorie (depr.)
TEXT
R
no
table
[ "i2n", "n" ]
drvd_select
GROUP_CONCAT(distinct CONCAT_WS("<#>", n.node_id,n.node_code,n.i18n_node_path_DE)  ORDER BY i2n.pos_n2i ASC SEPARATOR "###")
pos_n2i
INT
R
no
table
[ "i2n" ]
drvd_select
i2n.pos_n2i
listCfg
{
    "viewMode": 3
}
formCfg
{
    "editMode": 0
}
drvd_fk_prc_prcgrp_id
Preisgruppe (%col_name%)
TEXT (127)
R
no
input_translated
Eine hier gesetzte Preisgruppe greift nur, wenn Sie keine spezifischen Staffelpreise eingetragen haben.
i18n_string
"ecs.PRICE.dynx__fk_prcgrp_id"
table
[ "ecs_price_group", "ecs_prd_price" ]
drvd_select
GROUP_CONCAT(IF(ecs_prd_price.fk_prc_prcgrp_id = ecs_price_group.prcgrp_id,ecs_price_group.prcgrp_label,null))