Modul 134 - Kundenverwaltung
Kontonummer |
customers_accountnumber |
varchar |
45 |
Strasse Zusatz |
customers_addstreet |
varchar |
45 |
Bankname |
customers_bankname |
varchar |
45 |
Kontoinhaber |
customers_bankowner |
varchar |
45 |
BIC |
customers_bic |
varchar |
100 |
BLZ |
customers_blz |
varchar |
45 |
Ort |
customers_city |
varchar |
45 |
Firma |
customers_company |
varchar |
45 |
Land |
customers_country |
varchar |
45 |
Erstellt am |
customers_created |
datetime |
|
Strasse Zusatz (Lieferadresse) |
customers_del_addstreet |
varchar |
45 |
Stadt (Lieferadresse) |
customers_del_city |
varchar |
45 |
Firma (Lieferadresse) |
customers_del_company |
varchar |
45 |
Land (Lieferadresse) |
customers_del_country |
varchar |
45 |
FAX (Lieferadresse) |
customers_del_fax |
varchar |
100 |
Vorname (Lieferadresse) |
customers_del_fname |
varchar |
45 |
Geschlecht (Lieferadresse) |
customers_del_gender |
varchar |
5 |
Nachname (Lieferadresse) |
customers_del_lname |
varchar |
45 |
Telefonnummer (Lieferadresse) |
customers_del_phone |
varchar |
100 |
Strasse (Lieferadresse) |
customers_del_street |
varchar |
45 |
PLZ (Lieferadresse) |
customers_del_zip |
varchar |
45 |
Geburtstag |
customers_dop |
datetime |
|
|
customers_email |
varchar |
100 |
Fax |
customers_fax |
varchar |
45 |
Vorname |
customers_fname |
varchar |
45 |
Geschlecht |
customers_gender |
varchar |
10 |
customers_groupid |
customers_groupid |
int |
|
IBAN |
customers_iban |
varchar |
100 |
Interne ID |
customers_id |
int |
|
Nachname |
customers_lname |
varchar |
45 |
Mobilnummer |
customers_mobile |
varchar |
30 |
Geaendert am |
customers_modified |
datetime |
|
Newsletter |
customers_newsletter |
int |
|
Newsletter Kategorie |
customers_newslettercategory |
varchar |
45 |
customers_notes |
customers_notes |
text |
65535 |
Nummer |
customers_number |
int |
|
customers_number_ext |
customers_number_ext |
varchar |
100 |
customers_number_extern |
customers_number_extern |
int |
|
e7 ID |
customers_oldid |
int |
|
customers_oneadr |
customers_oneadr |
int |
|
Telefon |
customers_phone |
varchar |
45 |
Bundesland |
customers_state |
varchar |
45 |
Strasse |
customers_street |
varchar |
45 |
UserID |
customers_userid |
varchar |
45 |
UmSt ID |
customers_vatid |
varchar |
45 |
PLZ |
customers_zip |
varchar |
15 |
et8_accountid |
et8_accountid |
int |
|
et8_deleted |
et8_deleted |
int |
|
et8_label |
et8_label |
int |
|
free_Frei01 |
free_Frei01 |
varchar |
100 |
free_Frei02 |
free_Frei02 |
varchar |
100 |
free_Frei03 |
free_Frei03 |
varchar |
100 |