Modul 134 - Kundenverwaltung

Modul 134 - Kundenverwaltung

Zurück zur Übersicht 

 

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

 

Email

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