Model fields

The model consists of the following fields.

Field Name
Display Name
Type
Permissions
Nullable

orderitem

oiid primary auto increment
Auftragitem-ID
INT (11)
R+W
no
fieldset
"base_record"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "type": "hidden"
}
fk_oi_oidorder.oid
Auftrag
INT (11)
R+W
no
fieldset
"base_record"
listCfg
{
    "viewMode": 3
}
formCfg
{
    "cssLayout": "col-6",
    "mandatory": true
}
oi_position
Position
INT (5)
R+W
yes
fieldset
"base_record"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "cssLayout": "col-3"
}
fk_oi_father_oiidorderitem.oiid
übergeordneter Posten
INT (11)
R+W
yes
fieldset
"base_record"
listCfg
{
    "viewMode": 3
}
formCfg
{
    "cssLayout": "col-3",
    "editMode": 2
}
oi_type
Typ
TEXT (15)
R+W
no
fieldset
"base"
formCfg
{
    "cssLayout": "col-3"
}
oi_pcode primaryDisplay
Produktcode
TEXT (255)
R+W
yes
fieldset
"base"
listCfg
{
    "fullSearch": true
}
formCfg
{
    "cssLayout": "col-3"
}
pcode
Produktcode
R
no
drvd_select
eos_orderitem.oi_pcode
listCfg
{
    "viewMode": 3
}
formCfg
{
    "editMode": 0
}
oi_name
Name
TEXT
R+W
yes
fieldset
"base"
formCfg
{
    "cssLayout": "col-6"
}
oi_text
Text
TEXT
R+W
yes
fieldset
"base"
formCfg
{
    "type": "eoseditor",
    "options": {
        "useCfgPreset": "inlineBasic"
    }
}
oi_code
Code
TEXT (63)
R+W
yes
fieldset
"extra"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "cssLayout": "col-6"
}
oi_quantity
Bestell­menge
FLOAT (13,1)
R+W
no
fieldset
"base"
listCfg
{
    "sumType": "SV"
}
formCfg
{
    "cssLayout": "col-3",
    "type": "eosnumber",
    "options": {
        "decimalsCalculate": 1,
        "decimalshowMin": 0,
        "decimalshowMax": 1
    }
}
oi_vat_pct [%]
% MwSt.
FLOAT (6,2)
R+W
no
fieldset
"base"
listCfg
{
    "formatter": {
        "type": "decimal",
        "params": {
            "unit": " %",
            "format": "1.0-1"
        }
    }
}
formCfg
{
    "cssLayout": "col-3",
    "type": "eosnumber",
    "options": {
        "decimalsCalculate": 2,
        "decimalshowMin": 0,
        "decimalshowMax": 2
    }
}
oi_price_single_brutto [EUR]
Stückpreis Brutto
FLOAT (13,2)
R+W
yes
fieldset
"base"
listCfg
{
    "formatter": {
        "type": "currency"
    },
    "viewMode": 0
}
formCfg
{
    "cssLayout": "col-3",
    "type": "eosnumber",
    "options": {
        "decimalsCalculate": 2,
        "decimalshowMin": 2,
        "decimalshowMax": 2
    }
}
drvd_oi_total_brutto [EUR]
Gesamt Brutto
FLOAT (13,2)
R
no
drvd_select
ROUND((IF(eos_orderitem.oi_price_single_brutto IS NOT NULL, eos_orderitem.oi_price_single_brutto, 
                    (eos_orderitem.oi_price_single_netto * ( (100 + eos_orderitem.oi_vat_pct) / 100 ) )) * eos_orderitem.oi_quantity), 2)
fieldset
"base"
listCfg
{
    "formatter": {
        "type": "currency"
    },
    "sumType": "SV"
}
formCfg
{
    "cssLayout": "col-3",
    "editMode": 2,
    "type": "eosnumber",
    "options": {
        "decimalsCalculate": 2,
        "decimalshowMin": 2,
        "decimalshowMax": 2
    }
}
drvd_oi_price_single_brutto [EUR]
Einzelpreis Brutto
FLOAT (13,2)
R
no
drvd_select
ROUND((IF(eos_orderitem.oi_price_single_brutto IS NOT NULL, eos_orderitem.oi_price_single_brutto, 
                    (eos_orderitem.oi_price_single_netto * ( (100 + eos_orderitem.oi_vat_pct) / 100 ) ))), 2)
fieldset
"base"
listCfg
{
    "formatter": {
        "type": "currency"
    },
    "viewMode": 0
}
formCfg
{
    "editMode": 0
}
oi_price_single_netto [EUR]
Einzelpreis Netto
FLOAT (13,2)
R+W
yes
fieldset
"base"
listCfg
{
    "formatter": {
        "type": "currency"
    },
    "viewMode": 0
}
formCfg
{
    "cssLayout": "col-3",
    "editMode": 0
}
drvd_oi_price_single_netto [EUR]
Einzelpreis Netto
FLOAT (13,2)
R
no
drvd_select
ROUND((IF(eos_orderitem.oi_price_single_netto IS NOT NULL, eos_orderitem.oi_price_single_netto, 
                    (eos_orderitem.oi_price_single_brutto / ( (100 + eos_orderitem.oi_vat_pct) / 100 ) ))), 2)
fieldset
"base"
listCfg
{
    "formatter": {
        "type": "currency"
    },
    "viewMode": 0
}
formCfg
{
    "cssLayout": "col-3",
    "editMode": 2,
    "type": "eosnumber",
    "options": {
        "decimalsCalculate": 2,
        "decimalshowMin": 2,
        "decimalshowMax": 2
    }
}
drvd_oi_total_netto [EUR]
Gesamt Netto
FLOAT (13,2)
R
no
drvd_select
ROUND((IF(eos_orderitem.oi_price_single_netto IS NOT NULL, eos_orderitem.oi_price_single_netto, 
                    (eos_orderitem.oi_price_single_brutto / ( (100 + eos_orderitem.oi_vat_pct) / 100 ) )) * eos_orderitem.oi_quantity), 2)
fieldset
"base"
listCfg
{
    "formatter": {
        "type": "currency"
    },
    "viewMode": 0,
    "sumType": "SV"
}
formCfg
{
    "cssLayout": "col-3",
    "editMode": 2,
    "type": "eosnumber",
    "options": {
        "decimalsCalculate": 2,
        "decimalshowMin": 2,
        "decimalshowMax": 2
    }
}
oi_qty_invoiced
In Rechnung gestellt
FLOAT (13,1)
R+W
no
fieldset
"processed_qty"
listCfg
{
    "viewMode": 0,
    "sumType": "SV"
}
formCfg
{
    "cssLayout": "col-3",
    "editMode": 2,
    "type": "eosnumber",
    "options": {
        "decimalsCalculate": 1,
        "decimalshowMin": 0,
        "decimalshowMax": 1
    }
}
oi_qty_refunded
Erstattet
FLOAT (13,1)
R+W
no
fieldset
"processed_qty"
listCfg
{
    "viewMode": 0,
    "sumType": "SV"
}
formCfg
{
    "cssLayout": "col-3",
    "editMode": 2,
    "type": "eosnumber",
    "options": {
        "decimalsCalculate": 1,
        "decimalshowMin": 0,
        "decimalshowMax": 1
    }
}
oi_qty_shipped
Versendet
FLOAT (13,1)
R+W
no
fieldset
"processed_qty"
listCfg
{
    "viewMode": 0,
    "sumType": "SV"
}
formCfg
{
    "cssLayout": "col-3",
    "editMode": 2,
    "type": "eosnumber",
    "options": {
        "decimalsCalculate": 1,
        "decimalshowMin": 0,
        "decimalshowMax": 1
    }
}
oi_qty_returned
Zurückgeschickt
FLOAT (13,1)
R+W
no
fieldset
"processed_qty"
listCfg
{
    "viewMode": 0,
    "sumType": "SV"
}
formCfg
{
    "cssLayout": "col-3",
    "editMode": 2,
    "type": "eosnumber",
    "options": {
        "decimalsCalculate": 1,
        "decimalshowMin": 0,
        "decimalshowMax": 1
    }
}
drvd_oi_qty_not_invoiced
FLOAT (13,1)
R
no
drvd_select
(eos_orderitem.oi_quantity - eos_orderitem.oi_qty_invoiced + eos_orderitem.oi_qty_refunded)
drvd_oi_qty_not_shipped
FLOAT (13,1)
R
no
drvd_select
IF(eos_orderitem.oi_type = 'product',(eos_orderitem.oi_quantity - eos_orderitem.oi_qty_shipped + eos_orderitem.oi_qty_returned),0)
oi_block
Block
INT (3)
R+W
no
fieldset
"extra"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "cssLayout": "col-6"
}
oi_xdata
Weitere Daten
DATA
R+W
yes
fieldset
"extra"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "cssLayout": "col-12",
    "type": "aceeditor",
    "options": {
        "mode": "json"
    }
}
oi_price_single_brutto_xcurrency
Stückpreis Brutto (X-Währung)
FLOAT (13,2)
R+W
yes
fieldset
"xcurrency"
listCfg
{
    "viewMode": 0
}
oi_price_single_netto_xcurrency
Stückpreis Netto (X-Währung)
FLOAT (13,2)
R+W
yes
fieldset
"xcurrency"
listCfg
{
    "viewMode": 0
}
oi_xcurrency
X-Währung
TEXT (3)
R+W
no
fieldset
"xcurrency"
listCfg
{
    "viewMode": 0
}
drvd_oi_total_brutto_xcurrency
Gesamt Brutto (X-Währung)
FLOAT (13,2)
R
no
drvd_select
ROUND((IF(eos_orderitem.oi_price_single_brutto_xcurrency IS NOT NULL, eos_orderitem.oi_price_single_brutto_xcurrency, (eos_orderitem.oi_price_single_netto_xcurrency * ( (100 + eos_orderitem.oi_vat_pct) / 100 ) )) * eos_orderitem.oi_quantity), 2)
fieldset
"xcurrency"
listCfg
{
    "viewMode": 0
}
drvd_oi_total_netto_xcurrency
Gesamt Netto (X-Währung)
FLOAT (13,2)
R
no
drvd_select
ROUND((IF(eos_orderitem.oi_price_single_netto_xcurrency IS NOT NULL, eos_orderitem.oi_price_single_netto_xcurrency, (eos_orderitem.oi_price_single_brutto_xcurrency / ( (100 + eos_orderitem.oi_vat_pct) / 100 ) )) * eos_orderitem.oi_quantity), 2)
fieldset
"xcurrency"
listCfg
{
    "viewMode": 0
}
drvd_oi_price_single_brutto_xcurrency
Einzelpreis Brutto (X-Währung)
FLOAT (13,2)
R
no
drvd_select
ROUND((IF(eos_orderitem.oi_price_single_brutto_xcurrency IS NOT NULL, eos_orderitem.oi_price_single_brutto_xcurrency, (eos_orderitem.oi_price_single_netto_xcurrency * ( (100 + eos_orderitem.oi_vat_pct) / 100 ) ))), 2)
fieldset
"xcurrency"
listCfg
{
    "viewMode": 0
}
drvd_oi_price_single_netto_xcurrency
Einzelpreis Netto (X-Währung)
FLOAT (13,2)
R
no
drvd_select
ROUND((IF(eos_orderitem.oi_price_single_netto_xcurrency IS NOT NULL, eos_orderitem.oi_price_single_netto_xcurrency, (eos_orderitem.oi_price_single_brutto_xcurrency / ( (100 + eos_orderitem.oi_vat_pct) / 100 ) ))), 2)
fieldset
"xcurrency"
listCfg
{
    "viewMode": 0
}
oi_time_insert
Angelegt am
DATETIME
R+W
no
i18n_string
"insert_time"
fieldset
"sys_record"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "editMode": 2
}
oi_time_update
Geändert am
DATETIME
R+W
yes
i18n_string
"update_time"
fieldset
"sys_record"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "editMode": 2
}
oi_user_insert
Ersteller
TEXT (127)
R+W
yes
i18n_string
"insert_user"
fieldset
"sys_record"
listCfg
{
    "formatter": {
        "type": "user"
    },
    "viewMode": 0
}
formCfg
{
    "editMode": 2
}
oi_user_update
Letzte Änderung durch
TEXT (127)
R+W
yes
i18n_string
"update_user"
fieldset
"sys_record"
listCfg
{
    "viewMode": 0
}
formCfg
{
    "editMode": 2
}
fk_oi_mrch_idmerchant.mrch_id
INT (11)
R+W
yes
fieldset
"extra"
listCfg
{
    "viewMode": 3
}