Modul 112 - Bestellungen
|
Account ID |
et8_accountid |
int |
|
|
Gelöscht |
et8_deleted |
int |
|
|
Etikett |
et8_label |
int |
|
|
Freifeld 1 |
free_freifeld1 |
varchar |
100 |
|
Freifeld 2 |
free_freifeld2 |
varchar |
255 |
|
Freifeld 3 |
free_freifeld3 |
varchar |
255 |
|
Freifeld 4 |
free_freifeld4 |
varchar |
255 |
|
Freifeld 5 |
free_freifeld5 |
varchar |
255 |
|
Mahnstufe |
order_alertstage |
int |
|
|
RG Sicherheitsnachricht |
order_billsafemessage |
varchar |
255 |
|
RG Sicherheitsstatus |
order_billsafestatus |
varchar |
20 |
|
RG Sicherheitstoken |
order_billsafetoken |
varchar |
150 |
|
RG Zusatz |
order_bill_addstreet |
varchar |
100 |
|
RG Ort |
order_bill_city |
varchar |
45 |
|
RG Firma |
order_bill_company |
varchar |
45 |
|
RG Land |
order_bill_country |
varchar |
45 |
|
RG Ländercode |
order_bill_countrycode |
varchar |
2 |
|
RG Mail |
order_bill_email |
varchar |
100 |
|
RG Fax |
order_bill_fax |
varchar |
45 |
|
RG Vorname |
order_bill_fname |
varchar |
45 |
|
RG Name |
order_bill_fullname |
varchar |
150 |
|
RG Anrede |
order_bill_gender |
varchar |
15 |
|
RG Nachname |
order_bill_lname |
varchar |
45 |
|
RG Mobil |
order_bill_mobile |
varchar |
50 |
|
RG Telefon |
order_bill_phone |
varchar |
45 |
|
RG Bundesland |
order_bill_state |
varchar |
45 |
|
RG Strasse |
order_bill_street |
varchar |
100 |
|
UmSt. ID |
order_bill_vatid |
varchar |
45 |
|
RG PLZ |
order_bill_zip |
varchar |
20 |
|
Plus ebay |
order_ContainseBayPlusTransaction |
tinyint |
|
|
Erstellt |
order_created |
datetime |
|
|
Währung |
order_currency |
varchar |
5 |
|
KundenID |
order_customerid |
int |
|
|
KNr. |
order_customernumber |
int |
|
|
Datum |
order_date |
datetime |
|
|
LS Zusatz |
order_del_addstreet |
varchar |
100 |
|
LS Ort |
order_del_city |
varchar |
45 |
|
LS Firma |
order_del_company |
varchar |
45 |
|
LS Land |
order_del_country |
varchar |
45 |
|
LS Ländercode |
order_del_countrycode |
varchar |
2 |
|
LS Fax |
order_del_fax |
varchar |
50 |
|
LS Vorname |
order_del_fname |
varchar |
45 |
|
LS Name |
order_del_fullname |
varchar |
150 |
|
LS Anrede |
order_del_gender |
varchar |
15 |
|
LS Nachnahme |
order_del_lname |
varchar |
45 |
|
Lieferanschrift geändert |
order_del_mod |
int |
|
|
LS Telefon |
order_del_phone |
varchar |
45 |
|
LS Bundesland |
order_del_state |
varchar |
45 |
|
LS Strasse |
order_del_street |
varchar |
100 |
|
LS PLZ |
order_del_zip |
varchar |
45 |
|
Rabatt |
order_discount |
double |
|
|
Rabattinfo |
order_discountinfo |
text |
65535 |
|
Unstimmigkeit |
order_dispute |
int |
|
|
Unstimmigkeitsdatum |
order_disputetime |
datetime |
|
|
Status Kaufabwicklung |
order_eBayCheckoutStatus |
varchar |
20 |
|
Ebay Stornodatum |
order_ebay_CancelStatus |
varchar |
30 |
|
Exportiert |
order_exported |
int |
|
|
Externe Bestell-ID |
order_ext_orderid |
varchar |
100 |
|
Bewertung erhalten |
order_feedback |
int |
|
|
Bewertung abgegeben |
order_feedbackdone |
int |
|
|
Bewertungstext |
order_feedbacktext |
varchar |
255 |
|
Art.Nr. |
order_firstitemartnr |
varchar |
45 |
|
Bestelltitel |
order_firstitemname |
varchar |
150 |
|
GS Orginal-ID |
order_gs_orgid |
int |
|
|
Org. RG Nr. |
order_gs_orgrnr |
varchar |
20 |
|
Org. RG Datum |
order_gs_orgrnrdate |
datetime |
|
|
GS Total |
order_gs_orgtotal |
double |
|
|
Interne ID |
order_id |
int |
|
|
Infoicon |
order_infoicon |
int |
|
|
Letzte Änderung |
order_lastmodified |
datetime |
|
|
SKU |
order_model |
varchar |
45 |
|
Notiz |
order_notes |
text |
65535 |
|
Gemailt |
order_notified |
int |
|
|
Bestellnummer |
order_nr |
int |
|
|
Ext. Bestellnummer |
order_nr_extern |
int |
|
|
Angebotsnummer |
order_offernumber |
int |
|
|
etope 7 ID |
order_oldid |
int |
|
|
Bezahlt |
order_paymentdone |
int |
|
|
Ebay Bezahl-ID |
order_paymentebayid |
varchar |
45 |
|
Zahlungsgebühren |
order_paymentfees |
double |
|
|
Zahlart |
order_paymentname |
varchar |
45 |
|
Zahlstand |
order_paymentstatus |
tinyint |
|
|
Bez. Datum |
order_paymenttime |
datetime |
|
|
Bezahlt |
order_paymenttotal |
double |
|
|
RG Nr. |
order_rnr |
varchar |
20 |
|
RG Datum |
order_rnrdate |
datetime |
|
|
Verkäuferbezeichnung |
order_selleruserid |
varchar |
45 |
|
Versendet |
order_shippingdone |
int |
|
|
Versandmethode |
order_shippingname |
varchar |
45 |
|
Versendet am |
order_shippingtime |
datetime |
|
|
Versand |
order_shippingtotal |
double |
|
|
Versand MwSt. |
order_shippingvat |
double |
|
|
Versand MwSt Satz |
order_shippingvattype |
double |
|
|
Versandnotizen |
order_shipping_addinfo |
varchar |
255 |
|
Versanddienstleister |
order_shipping_carrier |
varchar |
75 |
|
Plattform |
order_source |
varchar |
45 |
|
Steuerfreie Ausfuhr |
order_steuerfreieausfuhr |
tinyint |
|
|
Herstellernummer |
order_supplierid |
int |
|
|
Testfeld |
order_testfield |
varchar |
45 |
|
Brutto |
order_totalbrutto |
double |
|
|
Netto |
order_totalnetto |
double |
|
|
Stückzahl |
order_totalnumquantity |
int |
|
|
Pos. |
order_totalquantity |
int |
|
|
MwSt |
order_totalvat |
double |
|
|
Gesamtgewicht |
order_totalweight |
double |
|
|
Trackingnr. |
order_trackingcode |
varchar |
45 |
|
Bestelltyp |
order_type |
varchar |
20 |
|
UserID |
order_userid |
varchar |
45 |
|
Ricardo Username |
order_useridric |
varchar |
20 |
|
VA abgerechnet |
order_vadone |
int |
|
|
VA abgerechnet am |
order_vadonedate |
datetime |
|
|
VA ID |
order_vamandantid |
int |
|
|
VA Name |
order_vamandantname |
varchar |
255 |