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 |