Modul 164 - Mandanten
|
Gelöscht |
et8_deleted |
int |
|
|
Etikett |
et8_label |
int |
|
|
va_mandant_bankbic |
va_mandant_bankbic |
varchar |
45 |
|
va_mandant_bankcode |
va_mandant_bankcode |
varchar |
45 |
|
va_mandant_bankiban |
va_mandant_bankiban |
varchar |
45 |
|
va_mandant_banknumber |
va_mandant_banknumber |
varchar |
45 |
|
va_mandant_bankowner |
va_mandant_bankowner |
varchar |
45 |
|
Rechnungs-Ort |
va_mandant_bill_city |
varchar |
45 |
|
Rechnungs-Firma |
va_mandant_bill_company |
varchar |
45 |
|
Rechnungs-Land |
va_mandant_bill_country |
varchar |
45 |
|
Rechnungs-Vorname |
va_mandant_bill_fname |
varchar |
45 |
|
Rechnungs-Nachname |
va_mandant_bill_lname |
varchar |
45 |
|
Rechnungs-Strasse |
va_mandant_bill_street |
varchar |
45 |
|
Rechnungs-Zusatz |
va_mandant_bill_streetadd |
varchar |
45 |
|
Rechnungs-PLZ |
va_mandant_bill_zip |
varchar |
45 |
|
Ort |
va_mandant_city |
varchar |
45 |
|
Firma |
va_mandant_company |
varchar |
45 |
|
Land |
va_mandant_country |
varchar |
45 |
|
Erstellt am |
va_mandant_created |
datetime |
|
|
va_mandant_difvat |
va_mandant_difvat |
tinyint |
|
|
|
va_mandant_email |
varchar |
45 |
|
Fax |
va_mandant_fax |
varchar |
45 |
|
Vorname |
va_mandant_fname |
varchar |
45 |
|
Homepage |
va_mandant_homepage |
varchar |
245 |
|
Interne ID |
va_mandant_id |
int |
|
|
Identifizierungstyp |
va_mandant_identtype |
varchar |
45 |
|
Identifizierungswert |
va_mandant_identvalue |
varchar |
145 |
|
Nachname |
va_mandant_lname |
varchar |
45 |
|
Mobil |
va_mandant_mobile |
varchar |
45 |
|
Ge‰ndert am |
va_mandant_modified |
datetime |
|
|
Notizen |
va_mandant_notes |
text |
65535 |
|
Nummer |
va_mandant_nr |
int |
|
|
Offene Artikel |
va_mandant_openpos |
int |
|
|
Telefon |
va_mandant_phone |
varchar |
45 |
|
Letzte Rechnugsnummer |
va_mandant_rnr |
varchar |
20 |
|
Letztes Rechnungsdatum |
va_mandant_rnrdate |
datetime |
|
|
Strasse |
va_mandant_street |
varchar |
45 |
|
Zusatz |
va_mandant_streetadd |
varchar |
45 |
|
PLZ |
va_mandant_zip |
varchar |
45 |