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"
fk_oi_oid → order.oid
Auftrag
INT (11)
R+W
no
fieldset
"base_record"
oi_position
Position
INT (5)
R+W
yes
fieldset
"base_record"
fk_oi_father_oiid → orderitem.oiid
übergeordneter Posten
INT (11)
R+W
yes
fieldset
"base_record"
oi_type
Typ
TEXT (15)
R+W
no
enum
[ "product", "shipping", "payment", "coupon", "couponprepaid", "document" ]
fieldset
"base"
oi_pcode primaryDisplay
Produktcode
TEXT (255)
R+W
yes
fieldset
"base"
pcode
Produktcode
R
no
drvd_select
eos_orderitem.oi_pcode
oi_name
Name
TEXT
R+W
yes
fieldset
"base"
oi_text
Text
TEXT
R+W
yes
fieldset
"base"
oi_code
Code
TEXT (63)
R+W
yes
fieldset
"extra"
oi_quantity
Bestellmenge
FLOAT (13,4)
R+W
no
fieldset
"base"
oi_vat_pct [%]
% MwSt.
FLOAT (6,2)
R+W
no
fieldset
"base"
oi_price_interval
TEXT (1)
R+W
yes
enum
[ "s", "d", "w", "m", "q", "y", "h", "i", "o" ]
fieldset
"base"
oi_price_single_brutto [EUR]
Stückpreis Brutto
FLOAT (13,4)
R+W
yes
fieldset
"base"
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"
drvd_oi_price_single_brutto [EUR]
Einzelpreis Brutto
FLOAT (13,4)
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 ) ))), 4)
fieldset
"base"
oi_price_single_netto [EUR]
Einzelpreis Netto
FLOAT (13,4)
R
yes
fieldset
"base"
drvd_oi_price_single_netto [EUR]
Einzelpreis Netto
FLOAT (13,4)
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 ) ))), 4)
fieldset
"base"
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"
oi_price_single_brutto_standard [EUR]
Standard Einzelpreis Brutto (Data)
FLOAT (13,4)
R+W
yes
fieldset
"base"
oi_price_single_wholesale [EUR]
Einzel-EK Netto
FLOAT (13,4)
R+W
yes
fieldset
"base"
oi_price_single_netto_standard [EUR]
FLOAT (13,4)
R+W
yes
fieldset
"xcurrency"
drvd_oi_price_single_netto_standard [EUR]
Standard Einzelpreis Netto
FLOAT (13,4)
R
yes
drvd_select
IF(
            eos_orderitem.oi_price_single_netto_standard IS NOT NULL, eos_orderitem.oi_price_single_netto_standard, 
            IF(eos_orderitem.oi_price_single_brutto_standard IS NOT NULL, ROUND( eos_orderitem.oi_price_single_brutto_standard * 100 / (100 + eos_orderitem.oi_vat_pct),4), NULL)
        )
fieldset
"extra"
drvd_oi_total_netto_not_discounted [EUR]
Gesamt Netto (regulär)
FLOAT (13,4)
R
yes
drvd_select
IF(
                    eos_orderitem.oi_price_single_brutto_standard IS NOT NULL OR eos_orderitem.oi_price_single_netto_standard IS NOT NULL,
                    IF (IF(
            eos_orderitem.oi_price_single_netto_standard IS NOT NULL, eos_orderitem.oi_price_single_netto_standard, 
            IF(eos_orderitem.oi_price_single_brutto_standard IS NOT NULL, ROUND( eos_orderitem.oi_price_single_brutto_standard * 100 / (100 + eos_orderitem.oi_vat_pct),4), NULL)
        ) <= 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 ) ))), 4), ROUND(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 ) ))), 4) *  eos_orderitem.oi_quantity,2), 0.00), 
                    NULL)
fieldset
"extra"
drvd_oi_price_single_brutto_standard [EUR]
Standard Einzelpreis Brutto
FLOAT (13,4)
R
yes
drvd_select
IF(
            eos_orderitem.oi_price_single_brutto_standard IS NOT NULL, eos_orderitem.oi_price_single_brutto_standard, 
            IF(eos_orderitem.oi_price_single_netto_standard IS NOT NULL, ROUND(eos_orderitem.oi_price_single_netto_standard * (100 + eos_orderitem.oi_vat_pct) / 100,4),NULL)
        )
fieldset
"extra"
drvd_oi_total_brutto_not_discounted [EUR]
Gesamt Brutto (regulär)
FLOAT (13,4)
R
yes
drvd_select
IF(eos_orderitem.oi_price_single_brutto_standard IS NOT NULL OR eos_orderitem.oi_price_single_netto_standard IS NOT NULL,
                IF (IF(
            eos_orderitem.oi_price_single_brutto_standard IS NOT NULL, eos_orderitem.oi_price_single_brutto_standard, 
            IF(eos_orderitem.oi_price_single_netto_standard IS NOT NULL, ROUND(eos_orderitem.oi_price_single_netto_standard * (100 + eos_orderitem.oi_vat_pct) / 100,4),NULL)
        ) <= 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 ) ))), 4), ROUND(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 ) ))), 4) *  eos_orderitem.oi_quantity,2), 0.00),                     
                NULL)
fieldset
"extra"
drvd_oi_discount_diff_netto [EUR]
Einzelrabatt Netto
FLOAT (13,4)
R
no
drvd_select
IF(eos_orderitem.oi_price_single_brutto_standard IS NOT NULL OR eos_orderitem.oi_price_single_netto_standard IS NOT NULL, 
                    ROUND(IF(
            eos_orderitem.oi_price_single_netto_standard IS NOT NULL, eos_orderitem.oi_price_single_netto_standard, 
            IF(eos_orderitem.oi_price_single_brutto_standard IS NOT NULL, ROUND( eos_orderitem.oi_price_single_brutto_standard * 100 / (100 + eos_orderitem.oi_vat_pct),4), NULL)
        ) - 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 ) ))), 4),4), 
                    NULL )
fieldset
"extra"
drvd_oi_total_netto_discounted [EUR]
Gesamt Netto (discounted)
FLOAT (13,2)
R
yes
drvd_select
IF(eos_orderitem.oi_price_single_brutto_standard IS NOT NULL OR eos_orderitem.oi_price_single_netto_standard IS NOT NULL, 
                IF(IF(
            eos_orderitem.oi_price_single_netto_standard IS NOT NULL, eos_orderitem.oi_price_single_netto_standard, 
            IF(eos_orderitem.oi_price_single_brutto_standard IS NOT NULL, ROUND( eos_orderitem.oi_price_single_brutto_standard * 100 / (100 + eos_orderitem.oi_vat_pct),4), NULL)
        ) > 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 ) ))), 4), ROUND(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 ) ))), 4) * eos_orderitem.oi_quantity,2), 0.00), 
                NULL )
fieldset
"extra"
drvd_oi_discount_diff_brutto [EUR]
Einzelrabatt Brutto
FLOAT (13,4)
R
no
drvd_select
IF(eos_orderitem.oi_price_single_brutto_standard IS NOT NULL OR eos_orderitem.oi_price_single_netto_standard IS NOT NULL, 
                    ROUND(IF(
            eos_orderitem.oi_price_single_brutto_standard IS NOT NULL, eos_orderitem.oi_price_single_brutto_standard, 
            IF(eos_orderitem.oi_price_single_netto_standard IS NOT NULL, ROUND(eos_orderitem.oi_price_single_netto_standard * (100 + eos_orderitem.oi_vat_pct) / 100,4),NULL)
        ) - 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 ) ))), 4),4), 
                    NULL )
fieldset
"extra"
drvd_oi_total_brutto_discounted [EUR]
Gesamt Brutto (discounted)
FLOAT (13,2)
R
yes
drvd_select
IF(eos_orderitem.oi_price_single_brutto_standard IS NOT NULL OR eos_orderitem.oi_price_single_netto_standard IS NOT NULL, 
                IF(IF(
            eos_orderitem.oi_price_single_brutto_standard IS NOT NULL, eos_orderitem.oi_price_single_brutto_standard, 
            IF(eos_orderitem.oi_price_single_netto_standard IS NOT NULL, ROUND(eos_orderitem.oi_price_single_netto_standard * (100 + eos_orderitem.oi_vat_pct) / 100,4),NULL)
        ) > 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 ) ))), 4), ROUND(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 ) ))), 4) * eos_orderitem.oi_quantity,2), 0.00), 
                NULL )
fieldset
"extra"
drvd_oi_is_discounted
Flag Discounted
INT (1)
R
yes
enum
[ "0", "1" ]
drvd_select
IF(eos_orderitem.oi_price_single_brutto_standard IS NOT NULL OR eos_orderitem.oi_price_single_netto_standard IS NOT NULL,
                IF (IF(
            eos_orderitem.oi_price_single_brutto_standard IS NOT NULL, eos_orderitem.oi_price_single_brutto_standard, 
            IF(eos_orderitem.oi_price_single_netto_standard IS NOT NULL, ROUND(eos_orderitem.oi_price_single_netto_standard * (100 + eos_orderitem.oi_vat_pct) / 100,4),NULL)
        ) > 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 ) ))), 4), 1, 0) , NULL )
fieldset
"extra"
drvd_oi_discounted_perc [%]
Discount (prozentual)
FLOAT (6,2)
R
yes
drvd_select
IF(
                    (eos_orderitem.oi_price_single_brutto_standard IS NOT NULL AND eos_orderitem.oi_price_single_brutto_standard != 0.00)
                     OR (eos_orderitem.oi_price_single_netto_standard IS NOT NULL AND eos_orderitem.oi_price_single_netto_standard != 0.00),
                ROUND((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 ) ))), 4) * 100 / IF(
            eos_orderitem.oi_price_single_brutto_standard IS NOT NULL, eos_orderitem.oi_price_single_brutto_standard, 
            IF(eos_orderitem.oi_price_single_netto_standard IS NOT NULL, ROUND(eos_orderitem.oi_price_single_netto_standard * (100 + eos_orderitem.oi_vat_pct) / 100,4),NULL)
        )) - 100,2), 
                NULL )
fieldset
"extra"
drvd_oi_margin_gross [%]
Handelsspanne
FLOAT (11,2)
R
no
drvd_select
IF(eos_orderitem.oi_price_single_wholesale IS NULL, NULL,
                IF(eos_orderitem.oi_price_single_netto IS NOT NULL, 
                    ROUND( (eos_orderitem.oi_price_single_netto-eos_orderitem.oi_price_single_wholesale)*100/eos_orderitem.oi_price_single_netto, 2), 
                    ROUND( (1-( eos_orderitem.oi_price_single_wholesale*(100+eos_orderitem.oi_vat_pct) / (eos_orderitem.oi_price_single_brutto*100)) )*100, 2)
                    ) 
                )
fieldset
"base"
drvd_oi_profit_perc [%]
Gewinn Marge
FLOAT (11,2)
R
yes
drvd_select
IF(eos_orderitem.oi_price_single_wholesale IS NULL, NULL, 
                IF(eos_orderitem.oi_price_single_netto IS NOT NULL, 
                    ROUND( (eos_orderitem.oi_price_single_netto-eos_orderitem.oi_price_single_wholesale)*100/eos_orderitem.oi_price_single_wholesale,2),
                    ROUND( ((eos_orderitem.oi_price_single_brutto*100/(100+eos_orderitem.oi_vat_pct))-eos_orderitem.oi_price_single_wholesale)*100/eos_orderitem.oi_price_single_wholesale,2) 
                    ) 
                )
fieldset
"base"
drvd_oi_profit_single [EUR]
Einzel Gewinn
FLOAT (13,4)
R
yes
drvd_select
IF(eos_orderitem.oi_price_single_wholesale IS NULL, NULL, 
                IF(eos_orderitem.oi_price_single_netto IS NOT NULL, 
                    ROUND( eos_orderitem.oi_price_single_netto-eos_orderitem.oi_price_single_wholesale,4),
                    ROUND( (eos_orderitem.oi_price_single_brutto*100/(100+eos_orderitem.oi_vat_pct))-eos_orderitem.oi_price_single_wholesale,4) 
                    ) 
                )
fieldset
"base"
drvd_oi_profit_total [EUR]
Gesamt Gewinn
FLOAT (13,4)
R
yes
drvd_select
IF(eos_orderitem.oi_price_single_wholesale IS NULL, NULL, 
                IF(eos_orderitem.oi_price_single_netto IS NOT NULL, 
                    ROUND( (eos_orderitem.oi_price_single_netto-eos_orderitem.oi_price_single_wholesale)*eos_orderitem.oi_quantity,2),
                    ROUND( ((eos_orderitem.oi_price_single_brutto*100/(100+eos_orderitem.oi_vat_pct))-eos_orderitem.oi_price_single_wholesale)*eos_orderitem.oi_quantity,2) 
                    ) 
                )
fieldset
"base"
oi_qty_invoiced
In Rechnung gestellt
FLOAT (13,4)
R+W
no
fieldset
"processed_qty"
oi_qty_refunded
Erstattet
FLOAT (13,4)
R+W
no
fieldset
"processed_qty"
oi_qty_shipped
Versendet
FLOAT (13,4)
R+W
no
fieldset
"processed_qty"
oi_qty_returned
Zurückgeschickt
FLOAT (13,4)
R+W
no
fieldset
"processed_qty"
drvd_oi_qty_not_invoiced
FLOAT (13,4)
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,4)
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"
oi_xdata
Weitere Daten
DATA
R+W
yes
fieldset
"extra"
oi_price_single_brutto_xcurrency
Stückpreis Brutto (X-Währung)
FLOAT (13,4)
R+W
yes
fieldset
"xcurrency"
oi_price_single_netto_xcurrency
Stückpreis Netto (X-Währung)
FLOAT (13,4)
R+W
yes
fieldset
"xcurrency"
oi_xcurrency
X-Währung
TEXT (3)
R+W
no
fieldset
"xcurrency"
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), 4)
fieldset
"xcurrency"
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), 4)
fieldset
"xcurrency"
drvd_oi_price_single_brutto_xcurrency
Einzelpreis Brutto (X-Währung)
FLOAT (13,4)
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 ) ))), 4)
fieldset
"xcurrency"
drvd_oi_price_single_netto_xcurrency
Einzelpreis Netto (X-Währung)
FLOAT (13,4)
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 ) ))), 4)
fieldset
"xcurrency"
oi_time_insert
Angelegt am
DATETIME
R+W
no
i18n_string
"insert_time"
fieldset
"sys_record"
oi_time_update
Geändert am
DATETIME
R+W
yes
i18n_string
"update_time"
fieldset
"sys_record"
oi_user_insert
Ersteller
TEXT (127)
R+W
yes
i18n_string
"insert_user"
fieldset
"sys_record"
oi_user_update
Letzte Änderung durch
TEXT (127)
R+W
yes
i18n_string
"update_user"
fieldset
"sys_record"
oi_omsg_status
Status aus Kundendialog
(31)
R+W
no
fieldset
"extra"
drvd_oi_omsg_cnt
# Nachrichten
INT (11)
R
yes
table
[ "ecs_order_message" ]
drvd_select
COUNT(ecs_order_message.omsg_id)
drvd_oi_omsg_time_last
Letzte Nachricht vom
DATETIME (11)
R
yes
table
[ "ecs_order_message" ]
drvd_select
MAX(ecs_order_message.omsg_insert_time)
fk_oi_mrch_id → merchant.mrch_id
Anbieter
INT (11)
R+W
yes
fieldset
"extra"

order

Following fields can also be selected for reading (JOIN)

oid
OID
INT (11)
R
no
i18n_string
"ecs.ORDER.oid"
table
[ "eos_order" ]
fieldset
"base_record"
fk_o_shopid → shopconfig.eshopid
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" ]
fieldset
"marketing"
orderid
Auftrags-Nr.
TEXT (63)
R
no
i18n_string
"ecs.ORDER.orderid"
table
[ "eos_order" ]
fieldset
"base_record"
fk_o_persid → person.persid
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" ]
fieldset
"base_record"
o_time_ordered
Bestelldatum
DATETIME
R
yes
i18n_string
"ecs.ORDER.o_time_ordered"
table
[ "eos_order" ]
fieldset
"base_record"
total_netto [EUR]
∑ Gesamt, Netto
FLOAT (13,2)
R
no
i18n_string
"ecs.ORDER.total_netto"
table
[ "eos_order" ]
total_brutto [EUR]
∑ Gesamt, Brutto
FLOAT (13,2)
R
no
i18n_string
"ecs.ORDER.total_brutto"
table
[ "eos_order" ]
o_orderid_external
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" ]
fieldset
"base"
fk_o_posid → orderpos.posid
POS Channel (ID)
INT (11)
R
yes
i18n_string
"ecs.ORDER.fk_o_posid"
table
[ "eos_order" ]
fieldset
"base"
fk_o_stid → orderstate.stid
Status
INT (11)
R
no
i18n_string
"ecs.ORDER.fk_o_stid"
table
[ "eos_order" ]
fieldset
"base"
order_state_transtime
Transaktionszeit
DATETIME
R
yes
i18n_string
"ecs.ORDER.order_state_transtime"
table
[ "eos_order" ]
fk_o_st_id → shippingtype.st_id
Versandart
INT (11)
R
no
i18n_string
"ecs.ORDER.fk_o_st_id"
table
[ "eos_order" ]
fieldset
"base"
o_pers_reftext
Kunden-Referenztext
TEXT
R
yes
input_translated
Geben Sie einen Referenztext des Kunden ein.
i18n_string
"ecs.ORDER.o_pers_reftext"
table
[ "eos_order" ]
o_pers_seq_nr
Auftrags-Sequenz-Nr.
INT (11)
R
no
i18n_string
"ecs.ORDER.o_pers_seq_nr"
table
[ "eos_order" ]
quantity
Bestellmenge
FLOAT (13,4)
R
no
i18n_string
"ecs.ORDER.quantity"
table
[ "eos_order" ]
drvd_total_vat [EUR]
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)
currency
Währung
TEXT (3)
R
no
i18n_string
"ecs.ORDER.currency"
table
[ "eos_order" ]
otitle
Auftragstitel
TEXT
R
yes
input_translated
Geben Sie dem Auftrag einen Titel.
i18n_string
"ecs.ORDER.otitle"
table
[ "eos_order" ]
fieldset
"doc_header"
otext
Auftragsbeschreibung
TEXT
R
yes
i18n_string
"ecs.ORDER.otext"
table
[ "eos_order" ]
fieldset
"extra"
o_type
Auftragstyp
TEXT (15)
R
yes
enum
[ "order", "offer" ]
i18n_string
"ecs.ORDER.o_type"
table
[ "eos_order" ]
fieldset
"base_record"
o_valid_until
Gültig bis
DATETIME
R
yes
i18n_string
"ecs.ORDER.o_valid_until"
table
[ "eos_order" ]
o_txt_header
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" ]
fieldset
"doc_header"
o_txt_footer
Fuß-Text
TEXT
R
yes
invoice_addr_preset
Adressbuch (R)
TEXT
R
yes
i18n_string
"ecs.ORDER.invoice_addr_preset"
table
[ "eos_order" ]
drvd_select
NULL
fieldset
"inv_addr"
invoice_gender
Anrede (R)
TEXT
R
yes
enum
[ "female", "male", "company", "divers" ]
i18n_string
"ecs.ORDER.invoice_gender"
table
[ "eos_order" ]
fieldset
"inv_addr"
invoice_title
Titel (R)
TEXT
R
no
i18n_string
"ecs.ORDER.invoice_title"
table
[ "eos_order" ]
fieldset
"inv_addr"
invoice_firstname
Vorname (R)
TEXT
R
no
i18n_string
"ecs.ORDER.invoice_firstname"
table
[ "eos_order" ]
fieldset
"inv_addr"
invoice_lastname
Nachname (R)
TEXT
R
no
i18n_string
"ecs.ORDER.invoice_lastname"
table
[ "eos_order" ]
fieldset
"inv_addr"
invoice_company
Firma (R)
TEXT
R
no
i18n_string
"ecs.ORDER.invoice_company"
table
[ "eos_order" ]
fieldset
"inv_addr"
invoice_addrextra
Adressenzusatz
TEXT
R
no
i18n_string
"ecs.ORDER.invoice_addrextra"
table
[ "eos_order" ]
fieldset
"inv_addr"
invoice_street
Straße (R)
TEXT
R
no
i18n_string
"ecs.ORDER.invoice_street"
table
[ "eos_order" ]
fieldset
"inv_addr"
invoice_housenr
Hausnummer (R)
TEXT
R
no
i18n_string
"ecs.ORDER.invoice_housenr"
table
[ "eos_order" ]
fieldset
"inv_addr"
invoice_zip
PLZ (R)
TEXT
R
no
i18n_string
"ecs.ORDER.invoice_zip"
table
[ "eos_order" ]
fieldset
"inv_addr"
invoice_town
Ort (R)
TEXT
R
no
i18n_string
"ecs.ORDER.invoice_town"
table
[ "eos_order" ]
fieldset
"inv_addr"
invoice_state_code
Bundesland (Code) (R)
TEXT (15)
R
yes
i18n_string
"ecs.ORDER.invoice_state_code"
table
[ "eos_order" ]
fieldset
"inv_addr"
invoice_country → country.cy_iso
Land (R)
TEXT (2)
R
no
i18n_string
"ecs.ORDER.invoice_country"
table
[ "eos_order" ]
fieldset
"inv_addr"
invoice_type
Rechnungsart
TEXT
R
yes
enum
[ "noncommercial", "commercial" ]
i18n_string
"ecs.ORDER.invoice_type"
table
[ "eos_order" ]
fieldset
"inv_extra"
invoice_email
E-Mail (R)
TEXT
R
no
i18n_string
"ecs.ORDER.invoice_email"
table
[ "eos_order" ]
fieldset
"inv_extra"
invoice_taxidentnumber
USt.ID-Nr.
TEXT
R
no
i18n_string
"ecs.ORDER.invoice_taxidentnumber"
table
[ "eos_order" ]
fieldset
"inv_extra"
invoice_taxident_status
USt.ID-Nr. Status
TEXT
R
yes
enum
[ "invalid", "valid_conditional", "valid_confirmed" ]
i18n_string
"ecs.ORDER.invoice_taxident_status"
table
[ "eos_order" ]
fieldset
"inv_extra"
invoice_third_country_export
Ausfuhrbescheinigung
TEXT
R
yes
enum
[ "none", "certificate_promised", "certificate_received" ]
i18n_string
"ecs.ORDER.invoice_third_country_export"
table
[ "eos_order" ]
fieldset
"inv_extra"
invoice_lang_iso
Rechnungssprache
TEXT (2)
R
no
input_translated
Geben Sie den Sprache der Rechnung als ISO-Code (z.B. DE, EN) an.
i18n_string
"ecs.ORDER.invoice_lang_iso"
table
[ "eos_order" ]
fieldset
"inv_extra"
drvd_invoice_street_housenr
Straße+Nr (R)
TEXT
R
no
i18n_string
"ecs.ORDER.drvd_invoice_street_housenr"
table
[ "eos_order" ]
drvd_select
CONCAT_WS("",eos_order.invoice_street," ",eos_order.invoice_housenr)
deliver_addr_preset
Adressbuch (L)
DATA
R
yes
i18n_string
"ecs.ORDER.deliver_addr_preset"
table
[ "eos_order" ]
drvd_select
NULL
fieldset
"dlv_addr"
deliver_gender
Anrede (L)
TEXT
R
yes
enum
[ "female", "male", "company", "divers" ]
i18n_string
"ecs.ORDER.deliver_gender"
table
[ "eos_order" ]
fieldset
"dlv_addr"
deliver_title
Titel (L)
TEXT
R
no
i18n_string
"ecs.ORDER.deliver_title"
table
[ "eos_order" ]
fieldset
"dlv_addr"
deliver_firstname
Vorname (L)
TEXT
R
no
i18n_string
"ecs.ORDER.deliver_firstname"
table
[ "eos_order" ]
fieldset
"dlv_addr"
deliver_lastname
Nachname (L)
TEXT
R
no
i18n_string
"ecs.ORDER.deliver_lastname"
table
[ "eos_order" ]
fieldset
"dlv_addr"
deliver_company
Firma (L)
TEXT
R
no
i18n_string
"ecs.ORDER.deliver_company"
table
[ "eos_order" ]
fieldset
"dlv_addr"
deliver_addrextra
Adressenzusatz
TEXT
R
no
i18n_string
"ecs.ORDER.deliver_addrextra"
table
[ "eos_order" ]
fieldset
"dlv_addr"
deliver_street
Straße (L)
TEXT
R
no
i18n_string
"ecs.ORDER.deliver_street"
table
[ "eos_order" ]
fieldset
"dlv_addr"
deliver_housenr
Hausnummer (L)
TEXT
R
no
i18n_string
"ecs.ORDER.deliver_housenr"
table
[ "eos_order" ]
fieldset
"dlv_addr"
deliver_zip
PLZ (L)
TEXT
R
no
i18n_string
"ecs.ORDER.deliver_zip"
table
[ "eos_order" ]
fieldset
"dlv_addr"
deliver_town
Ort (L)
TEXT
R
no
i18n_string
"ecs.ORDER.deliver_town"
table
[ "eos_order" ]
fieldset
"dlv_addr"
deliver_state_code
Bundesland (Code) (L)
TEXT (15)
R
yes
i18n_string
"ecs.ORDER.deliver_state_code"
table
[ "eos_order" ]
fieldset
"dlv_addr"
deliver_country → country.cy_iso
Land (L)
TEXT (2)
R
no
i18n_string
"ecs.ORDER.deliver_country"
table
[ "eos_order" ]
fieldset
"dlv_addr"
deliver_date_req
Kunden-Wunschtermin
TEXT
R
no
i18n_string
"ecs.ORDER.deliver_date_req"
table
[ "eos_order" ]
fieldset
"dlv_extra"
deliver_phone
Telefon
TEXT
R
no
i18n_string
"ecs.ORDER.deliver_phone"
table
[ "eos_order" ]
fieldset
"dlv_extra"
deliver_email
E-Mail (L)
TEXT
R
no
i18n_string
"ecs.ORDER.deliver_email"
table
[ "eos_order" ]
fieldset
"dlv_extra"
deliver_comment
Liefer-Hinweise
TEXT
R
no
input_translated
Geben Sie hier einen Lieferhinweis für den Lieferanten ein.
i18n_string
"ecs.ORDER.deliver_comment"
table
[ "eos_order" ]
fieldset
"dlv_extra"
drvd_deliver_street_housenr
Straße+Nr (L)
TEXT
R
no
i18n_string
"ecs.ORDER.drvd_deliver_street_housenr"
table
[ "eos_order" ]
drvd_select
CONCAT_WS("",eos_order.deliver_street," ",eos_order.deliver_housenr)
deliver_notes_xdata
Lieferhinweise
DATA
R
yes
i18n_string
"ecs.ORDER.deliver_notes_xdata"
table
[ "eos_order" ]
fieldset
"dlv_extra"
ip_address
IP-Adresse
TEXT
R
yes
i18n_string
"ecs.ORDER.ip_address"
table
[ "eos_order" ]
fieldset
"sys_record"
o_referrer
Referrer
TEXT
R
yes
i18n_string
"ecs.ORDER.o_referrer"
table
[ "eos_order" ]
fieldset
"sys_record"
o_useragent
User-Agent
TEXT
R
yes
i18n_string
"ecs.ORDER.o_useragent"
table
[ "eos_order" ]
fieldset
"sys_record"
o_comment
Kundenkommentar
TEXT
R
yes
input_translated
Geben Sie hier einen Kommentar zum Auftrag ein.
i18n_string
"ecs.ORDER.o_comment"
table
[ "eos_order" ]
fieldset
"extra"
o_comment_internal
Interner Bestellhinweis
TEXT
R
yes
input_translated
Vergeben Sie hier einen internen Kommentar, z.B. für andere Auftragsbearbeiter.
i18n_string
"ecs.ORDER.o_comment_internal"
table
[ "eos_order" ]
fieldset
"extra"
o_anonymize_time
DATETIME
R
yes
i18n_string
"ecs.ORDER.o_anonymize_time"
table
[ "eos_order" ]
fieldset
"sys_record"
o_lock_time
Bearbeitungs-Sperre (Zeitpunkt)
DATETIME
R
yes
i18n_string
"ecs.ORDER.o_lock_time"
table
[ "eos_order" ]
o_lock_user
Bearbeitungs-Sperre (Benutzer)
TEXT (31)
R
yes
i18n_string
"ecs.ORDER.o_lock_user"
table
[ "eos_order" ]
o_insert_time
Angelegt am
DATETIME
R
no
i18n_string
"insert_time"
table
[ "eos_order" ]
fieldset
"sys_record"
o_update_time
Geändert am
DATETIME
R
yes
i18n_string
"update_time"
table
[ "eos_order" ]
fieldset
"sys_record"
o_insert_user
Ersteller
TEXT (127)
R
yes
i18n_string
"insert_user"
table
[ "eos_order" ]
fieldset
"sys_record"
o_update_user
Letzte Änderung durch
TEXT (127)
R
yes
i18n_string
"update_user"
table
[ "eos_order" ]
fieldset
"sys_record"
fk_o_campid → campaign.campid
Kampagne
INT (11)
R
no
input_translated
Wählen Sie eine Kampagne aus, zu der dieser Auftrag zugeordnet werden soll.
i18n_string
"ecs.ORDER.fk_o_campid"
table
[ "eos_order" ]
fieldset
"marketing"
drvd_o_shoplabel
Shop
TEXT
R
no
i18n_string
"ecs.ORDER.drvd_o_shoplabel"
table
[ "eos_order" ]
drvd_select
eos_order.fk_o_shopid
drvd_invoice_address
Auftrag-Rg.Adresse
TEXT
R
no
i18n_string
"ecs.ORDER.drvd_invoice_address"
table
[ "eos_order" ]
drvd_select
CONCAT(
					IF(CHAR_LENGTH(eos_order.invoice_company)>0,CONCAT(eos_order.invoice_company,CHAR(13),char(10)),""),
					TRIM(CONCAT(eos_order.invoice_title," ",eos_order.invoice_firstname," ",eos_order.invoice_lastname)),CHAR(13),char(10),
					IF(CHAR_LENGTH(eos_order.invoice_addrextra)>0,CONCAT(eos_order.invoice_addrextra,CHAR(13),char(10)),""),
					eos_order.invoice_street," ",eos_order.invoice_housenr,CHAR(13),char(10),
					eos_order.invoice_country," - ",eos_order.invoice_zip," ",eos_order.invoice_town)
drvd_deliver_address
Auftrag-Lfg.Adresse
TEXT
R
no
i18n_string
"ecs.ORDER.drvd_deliver_address"
table
[ "eos_order" ]
drvd_select
CONCAT(
					IF(CHAR_LENGTH(eos_order.deliver_company)>0,CONCAT(eos_order.deliver_company,CHAR(13),char(10)),""),
					TRIM(CONCAT(eos_order.deliver_title," ",eos_order.deliver_firstname," ",eos_order.deliver_lastname)),CHAR(13),char(10),
					IF(CHAR_LENGTH(eos_order.deliver_addrextra)>0,CONCAT(eos_order.deliver_addrextra,CHAR(13),char(10)),""),
					eos_order.deliver_street," ",eos_order.deliver_housenr,CHAR(13),char(10),
					eos_order.deliver_country," - ",eos_order.deliver_zip," ",eos_order.deliver_town)
o_pay_profile_xdata
Zahlungsziel-Daten
DATA
R
yes
i18n_string
"ecs.ORDER.o_pay_profile_xdata"
table
[ "eos_order" ]
fk_o_companyaccount_subaccount_persid → companysubaccount.persid
Unteraccount
INT (11)
R
yes
i18n_string
"ecs.plugin_companyaccount.fk_o_companyaccount_subaccount_persid"
table
[ "eos_order" ]
fieldset
"base"
fk_o_mrch_id → merchant.mrch_id
Verkaufender Anbieter
INT (11)
R
yes
i18n_string
"ecs.ORDER.fk_o_mrch_id"
table
[ "eos_order" ]
fieldset
"extra"
fk_o_parent_oid → order.oid
Hauptauftrag
INT (11)
R
yes
i18n_string
"ecs.ORDER.fk_o_parent_oid"
table
[ "eos_order" ]
fieldset
"extra"
o_merchant_xdata
Anbieter (Zusatzdaten)
DATA
R
yes
i18n_string
"ecs.ORDER.o_merchant_xdata"
table
[ "eos_order" ]
fieldset
"extra"
o_periodic_time_first
Abo-Startdatum
DATETIME
R
yes
i18n_string
"ecs.ORDER.o_periodic_time_first"
table
[ "eos_order" ]
fieldset
"time_settings"
o_periodic_time_last
Abo-Enddatum
DATETIME
R
yes
i18n_string
"ecs.ORDER.o_periodic_time_last"
table
[ "eos_order" ]
fieldset
"time_settings"
o_periodic_time_next
Nächste Abo-Ausführung
DATETIME
R
yes
i18n_string
"ecs.ORDER.o_periodic_time_next"
table
[ "eos_order" ]
fieldset
"time_settings"
o_periodic_timeorder_offset
Abweichendes Auftragsdatum
TEXT (31)
R
no
i18n_string
"ecs.ORDER.o_periodic_timeorder_offset"
table
[ "eos_order" ]
fieldset
"time_settings"
o_periodic_time_strict
Strikt
INT (1)
R
no
i18n_string
"ecs.ORDER.o_periodic_time_strict"
table
[ "eos_order" ]
fieldset
"time_settings"
o_periodic_exec_period
Abo-Intervall
TEXT (31)
R
no
i18n_string
"ecs.ORDER.o_periodic_exec_period"
table
[ "eos_order" ]
fieldset
"time_settings"
o_periodic_exec_mode
Abo-Modus
TEXT (7)
R
no
enum
[ "daemon", "manual" ]
i18n_string
"ecs.ORDER.o_periodic_exec_mode"
table
[ "eos_order" ]
fieldset
"time_settings"
o_periodic_exec_inprogress
Wird gerade ausgeführt
INT (1)
R
no
i18n_string
"ecs.ORDER.o_periodic_exec_inprogress"
table
[ "eos_order" ]
o_periodic_xdata
DATA
R
yes
i18n_string
"ecs.ORDER.o_periodic_xdata"
table
[ "eos_order" ]
fieldset
"time_settings_xdata"
o_release_user
Freigabe - Hublify User
TEXT
R
yes
i18n_string
"ecs.ORDER.o_release_user"
table
[ "eos_order" ]
fieldset
"sys_record"
o_release_time
Freigabe - Zeitpunkt
DATETIME
R
yes
i18n_string
"ecs.ORDER.o_release_time"
table
[ "eos_order" ]
fieldset
"sys_record"
o_finalinspection_user
Endkontrolle - Hublify User
TEXT
R
yes
i18n_string
"ecs.ORDER.o_finalinspection_user"
table
[ "eos_order" ]
fieldset
"sys_record"
o_finalinspection_time
Endkontrolle - Zeitpunkt
DATETIME
R
yes
i18n_string
"ecs.ORDER.o_finalinspection_time"
table
[ "eos_order" ]
fieldset
"sys_record"
fk_o_crm_opp_id → crm_opportunity.opp_id
CRM Opportunity
INT (11)
R
yes
i18n_string
"ecs.ORDER.fk_o_crm_opp_id"
table
[ "eos_order" ]
fieldset
"base"
drvd_days_since_ordered
INT
R
no
i18n_string
"ecs.ORDER.drvd_days_since_ordered"
table
[ "eos_order" ]
drvd_select
DATEDIFF(NOW(),eos_order.o_time_ordered)
drvd_weekday_timeordered
Wochentag
TEXT
R
no
i18n_string
"ecs.ORDER.drvd_weekday_timeordered"
table
[ "eos_order" ]
drvd_select
DATE_FORMAT(eos_order.o_time_ordered, '%a')
drvd_hour_timeordered
Stunde
TEXT
R
no
i18n_string
"ecs.ORDER.drvd_hour_timeordered"
table
[ "eos_order" ]
drvd_select
DATE_FORMAT(eos_order.o_time_ordered, '%H')
drvd_month_timeordered
Bestellmonat
TEXT
R
no
i18n_string
"ecs.ORDER.drvd_month_timeordered"
table
[ "eos_order" ]
drvd_select
DATE_FORMAT(eos_order.o_time_ordered, '%m')
drvd_dayofmonth_timeordered
Bestelltag im Monat
TEXT
R
no
i18n_string
"ecs.ORDER.drvd_dayofmonth_timeordered"
table
[ "eos_order" ]
drvd_select
DATE_FORMAT(eos_order.o_time_ordered, '%d')
drvd_timeonly_timeordered
Bestellzeit
TEXT
R
no
i18n_string
"ecs.ORDER.drvd_timeonly_timeordered"
table
[ "eos_order" ]
drvd_select
DATE_FORMAT(eos_order.o_time_ordered, '%H:%i')
drvd_cluster_seq
Erst-/Wiederkauf
TEXT
R
no
i18n_string
"ecs.ORDER.drvd_cluster_seq"
table
[ "eos_order" ]
drvd_select
IF(eos_order.o_pers_seq_nr > 1,"Wiederkauf","Erstkauf")
drvd_inv_cy_name
Rechnungsland
TEXT
R
no
i18n_string
"ecs.ORDER.drvd_inv_cy_name"
table
[ "inv_country" ]
drvd_select
inv_country.cy_name
drvd_inv_cy_nameshort
Rechnungsland Kurzname
TEXT
R
no
i18n_string
"ecs.ORDER.drvd_inv_cy_nameshort"
table
[ "inv_country" ]
drvd_select
inv_country.cy_nameshort
drvd_del_cy_name
Lieferland
TEXT
R
no
i18n_string
"ecs.ORDER.drvd_del_cy_name"
table
[ "del_country" ]
drvd_select
del_country.cy_name
drvd_del_cy_nameshort
Lieferland Kurzname
TEXT
R
no
i18n_string
"ecs.ORDER.drvd_del_cy_nameshort"
table
[ "del_country" ]
drvd_select
del_country.cy_nameshort
drvd_invoice_state_name
Bundesland (R)
TEXT
R
no
i18n_string
"ecs.ORDER.drvd_invoice_state_name"
table
[ "invoice_terr_state" ]
drvd_select
invoice_terr_state.terr_name
drvd_invoice_state_path
Bundesland (Pfad) (R)
TEXT
R
no
i18n_string
"ecs.ORDER.drvd_invoice_state_path"
table
[ "invoice_terr_state" ]
drvd_select
invoice_terr_state.i18n_node_path_DE
drvd_deliver_state_name
Bundesland (L)
TEXT
R
no
i18n_string
"ecs.ORDER.drvd_deliver_state_name"
table
[ "deliver_terr_state" ]
drvd_select
deliver_terr_state.terr_name
drvd_deliver_state_path
Bundesland (Pfad) (L)
TEXT
R
no
i18n_string
"ecs.ORDER.drvd_deliver_state_path"
table
[ "deliver_terr_state" ]
drvd_select
deliver_terr_state.i18n_node_path_DE