Adressen |
Bemerkungen |
VARCHAR |
|
|
|
|
|
|
|
|
|
0 |
|
|
|
|
|
|
Mitgliedsnummer |
SMALLINT |
|
✔ |
ASC |
|
|
|
|
|
|
100 |
|
1 |
|
|
|
|
Nr |
VARCHAR |
|
|
|
|
|
|
|
|
wird Small Integer nach der Umstellung |
100 |
|
|
|
|
3 |
|
NrZusatz |
VARCHAR |
|
|
|
|
|
|
|
|
|
100 |
|
|
|
|
2 |
|
OrtID |
INTEGER |
|
|
|
|
ASC |
|
|
|
|
100 |
|
37 |
|
|
|
|
PlzID |
INTEGER |
|
|
|
ASC |
|
|
|
|
|
100 |
|
34 |
|
|
|
|
StaatCode |
VARCHAR |
|
|
|
|
|
|
|
|
für KiSt, LEER für Deutschland |
0 |
|
|
|
|
|
|
StrasseID |
INTEGER |
|
|
|
|
|
ASC |
|
|
|
100 |
|
210 |
|
|
|
Ansicht_EmailsanMitglieder |
EMAIL |
VARCHAR |
|
|
|
|
|
|
|
|
|
100 |
|
|
|
|
15 |
|
LIEBER |
VARCHAR |
|
|
|
|
|
|
|
|
|
100 |
|
|
|
|
6 |
|
MITGLNR |
SMALLINT |
|
|
|
|
|
|
|
|
|
100 |
|
1 |
|
|
|
|
NAME |
VARCHAR |
|
|
|
|
|
|
|
|
|
100 |
|
|
|
|
7 |
|
ORGA |
VARCHAR |
|
|
|
|
|
|
|
|
|
0 |
|
|
|
|
|
|
SEHR |
VARCHAR |
|
|
|
|
|
|
|
|
|
100 |
|
|
|
|
18 |
|
VORNAME |
VARCHAR |
|
|
|
|
|
|
|
|
|
100 |
|
|
|
|
6 |
Anteile |
AnteilePlusMinus |
SMALLINT |
|
|
|
|
|
|
|
|
|
100 |
|
1 |
|
|
|
|
AnteileSaldo |
SMALLINT |
|
|
|
|
|
|
|
|
|
100 |
|
1 |
|
|
|
|
AusProzent |
DECIMAL |
2 |
|
|
|
|
|
|
|
|
0 |
|
|
|
|
|
|
Ausschuettung |
DECIMAL |
2 |
|
|
|
|
|
|
|
|
0 |
|
|
|
|
|
|
Bemerkungen |
VARCHAR |
|
|
|
|
|
|
|
|
|
100 |
|
|
|
|
12 |
|
ID |
INTEGER |
|
✔ |
|
|
|
|
|
|
|
100 |
|
3 |
|
|
|
|
Mitgliedsnummer |
SMALLINT |
|
|
|
ASC |
|
|
|
|
|
100 |
|
1 |
|
|
|
|
TagEintrag |
DATE |
|
|
|
|
|
|
|
|
|
100 |
|
|
29/05/2014 |
29/05/2014 |
|
|
TagZahlung |
DATE |
|
|
|
|
|
|
|
|
|
100 |
|
|
29/08/2014 |
29/08/2014 |
|
|
VorgangID |
TINYINT |
|
|
ASC |
|
|
|
|
|
|
100 |
|
2 |
|
|
|
BankDaten |
BankID |
INTEGER |
|
|
ASC |
|
|
|
|
|
|
100 |
|
36 |
|
|
|
|
IBAN |
VARCHAR |
|
|
|
|
|
|
|
|
|
100 |
|
|
|
|
22 |
|
Kontoinhaber |
VARCHAR |
|
|
|
|
|
|
|
|
|
100 |
|
|
|
|
6 |
|
KtoNummer |
VARCHAR |
|
|
|
|
|
|
|
|
|
0 |
|
|
|
|
|
|
Mitgliedsnummer |
SMALLINT |
|
✔ |
|
ASC |
|
|
|
|
|
100 |
|
1 |
|
|
|
Banken |
Bankname |
VARCHAR |
|
|
|
|
|
|
|
|
|
91 |
|
|
|
|
29 |
|
BIC |
VARCHAR |
|
|
|
|
|
|
|
|
|
75 |
|
|
|
|
11 |
|
BLZ |
VARCHAR |
|
|
|
|
|
|
|
|
|
45 |
|
|
|
|
8 |
|
ID |
INTEGER |
|
✔ |
|
|
|
|
|
|
|
100 |
|
47 |
|
|
|
Dividenden |
AnteileSaldo |
SMALLINT |
|
|
|
|
|
|
|
|
aus Mitgliedsanteile |
|
|
|
|
|
|
|
ausgezahlt |
BOOLEAN |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
AusProzent |
DECIMAL |
2 |
|
|
|
|
|
|
|
aus Dividendenzentrale |
|
|
|
|
|
|
|
Auszahlung |
DECIMAL |
2 |
|
|
|
|
|
|
|
in Euro |
|
|
|
|
|
|
|
DividID |
TINYINT |
|
|
ASC |
|
|
|
|
|
1,2 von Dividendenzentrale gesetzt/3,4 manuell |
|
|
|
|
|
|
|
FSABetrag |
DECIMAL |
2 |
|
|
|
|
|
|
|
aus Steuerdaten/Dividendenzentrale |
|
|
|
|
|
|
|
ID |
INTEGER |
|
✔ |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
KapErtr |
DECIMAL |
2 |
|
|
|
|
|
|
|
Ausschuettung oder Zinsen, Tilgung |
|
|
|
|
|
|
|
KapErtrSt |
DECIMAL |
2 |
|
|
|
|
|
|
|
von Dividendenzentrale |
|
|
|
|
|
|
|
Kennung |
VARCHAR |
|
|
|
|
|
|
|
|
bei 1,2: Verwendungsszweck aus Divid.Zentrale |
|
|
|
|
|
|
|
KEStproz |
DECIMAL |
2 |
|
|
|
|
|
|
|
aus DividHist |
|
|
|
|
|
|
|
KiSt |
DECIMAL |
2 |
|
|
|
|
|
|
|
von Dividendenzentrale |
|
|
|
|
|
|
|
KiStproz |
DECIMAL |
2 |
|
|
|
|
|
|
|
aus Steuerdaten/Dividendenzentrale |
|
|
|
|
|
|
|
Mitgliedsnummer |
SMALLINT |
|
|
|
ASC |
|
|
|
|
|
|
|
|
|
|
|
|
ProjektID |
TINYINT |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Soli |
DECIMAL |
2 |
|
|
|
|
|
|
|
von Dividendenzentrale |
|
|
|
|
|
|
|
Soliproz |
DECIMAL |
2 |
|
|
|
|
|
|
|
aus DividHist |
|
|
|
|
|
|
|
TagEintrag |
DATE |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
TagZahlungAblauf |
DATE |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
DividendenHistorie |
AusProzent |
DECIMAL |
2 |
|
|
|
|
|
|
|
|
100 |
2,6 |
5 |
|
|
|
|
ID |
INTEGER |
|
✔ |
|
|
|
|
|
|
|
100 |
|
6 |
|
|
|
|
KEStproz |
DECIMAL |
2 |
|
|
|
|
|
|
|
aus SteuerDaten |
100 |
25 |
25 |
|
|
|
|
ProjektID |
TINYINT |
|
|
ASC |
|
|
|
|
|
|
100 |
|
2 |
|
|
|
|
Soliproz |
DECIMAL |
2 |
|
|
|
|
|
|
|
aus SteuerDaten |
100 |
5,5 |
5,5 |
|
|
|
|
TagEintrag |
DATE |
|
|
|
|
|
|
|
|
GV-Beschluss-Datum |
100 |
|
|
23/01/2018 |
05/04/2018 |
|
|
TagZahlung |
DATE |
|
|
|
|
|
|
|
|
REQDEXCTNDT |
100 |
|
|
26/01/2018 |
03/03/2033 |
|
|
Verwendungszweck |
VARCHAR |
|
|
|
|
|
|
|
|
|
100 |
|
|
|
|
45 |
DividendenVorgaenge |
ID |
TINYINT |
|
✔ |
|
|
|
|
|
|
|
100 |
|
4 |
|
|
|
|
Vorgang |
VARCHAR |
|
|
|
|
|
|
|
|
|
100 |
|
|
|
|
33 |
Domaenen |
Domains |
VARCHAR |
|
|
|
|
|
|
|
|
|
100 |
|
|
|
|
31 |
|
ID |
INTEGER |
|
✔ |
|
|
|
|
|
|
|
100 |
|
109 |
|
|
|
eMail_Pfade |
Pfad |
VARCHAR |
|
|
|
|
|
|
|
|
|
100 |
|
|
|
|
49 |
|
PfadID |
INTEGER |
|
✔ |
|
|
|
|
|
|
|
100 |
|
|
|
|
|
Export_Pfade |
Pfad |
VARCHAR |
|
|
|
|
|
|
|
|
|
100 |
|
|
|
|
51 |
|
PfadID |
INTEGER |
|
✔ |
|
|
|
|
|
|
|
100 |
|
3 |
|
|
|
Fenster |
Breite |
INTEGER |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Hoehe |
INTEGER |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
ID |
SMALLINT |
|
✔ |
|
|
|
|
|
|
|
|
|
|
|
|
|
Filter_I |
ID |
TINYINT |
|
✔ |
|
|
|
|
|
|
|
100 |
|
|
|
|
|
|
Integer |
INTEGER |
|
|
|
|
|
|
|
|
|
100 |
|
1 |
|
|
|
Filter_M |
ID |
TINYINT |
|
✔ |
|
|
|
|
|
|
|
100 |
|
|
|
|
|
|
Integer |
INTEGER |
|
|
|
|
|
|
|
|
|
100 |
|
1 |
|
|
|
Fix-KiSt |
Bemerkung |
VARCHAR |
|
|
|
|
|
|
|
|
|
100 |
|
|
|
|
90 |
|
ID |
SMALLINT |
|
✔ |
|
|
|
|
|
|
|
100 |
|
17 |
|
|
|
|
Spaltenname |
VARCHAR |
|
|
|
|
|
|
|
|
|
100 |
|
|
|
|
23 |
|
Wert |
VARCHAR |
|
|
|
|
|
|
|
|
|
22 |
|
|
|
|
10 |
Fixwerte |
Art |
VARCHAR |
|
|
|
|
|
|
|
|
|
100 |
|
|
|
|
25 |
|
Bemerkungen |
VARCHAR |
|
|
|
|
|
|
|
|
|
80 |
|
|
|
|
52 |
|
ID |
SMALLINT |
|
✔ |
|
|
|
|
|
|
|
100 |
|
999 |
|
|
|
|
Wert |
DECIMAL |
2 |
|
|
|
|
|
|
|
|
100 |
110 |
500 |
|
|
|
Geschlechter |
Anrede |
VARCHAR |
|
|
|
|
|
|
|
|
Briefumschlag |
100 |
|
|
|
|
5 |
|
Briefanrede |
VARCHAR |
|
|
|
|
|
|
|
|
Sehr... |
100 |
|
|
|
|
29 |
|
Geschlecht |
VARCHAR |
|
✔ |
|
|
|
|
|
|
w oder m oder o (=ohne Person) |
100 |
|
|
|
|
1 |
|
Lieber |
VARCHAR |
|
|
|
|
|
|
|
|
Liebe(r) oder SgDuH |
100 |
|
|
|
|
29 |
Import_Dateien |
Pfad |
VARCHAR |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
PfadID |
INTEGER |
|
✔ |
|
|
|
|
|
|
|
|
|
|
|
|
|
Interessenten |
Bemerkungen |
VARCHAR |
|
|
|
|
|
|
|
|
Beruf/Arbeitsfeld... |
100 |
|
|
|
|
20 |
|
Domain1ID |
INTEGER |
|
|
|
|
|
|
ASC |
|
|
100 |
|
82 |
|
|
|
|
Email1 |
VARCHAR |
|
|
|
|
|
|
|
|
|
100 |
|
|
|
|
3 |
|
Geschlecht |
VARCHAR |
|
|
|
|
|
|
|
ASC |
|
100 |
|
|
|
|
1 |
|
ID |
INTEGER |
|
✔ |
|
|
|
|
|
|
|
100 |
|
1 |
|
|
|
|
Nachname |
VARCHAR |
|
|
|
|
|
|
|
|
|
100 |
|
|
|
|
5 |
|
Nr |
VARCHAR |
|
|
|
|
|
|
|
|
|
100 |
|
|
|
|
2 |
|
Organisation |
VARCHAR |
|
|
|
|
|
|
|
|
|
0 |
|
|
|
|
|
|
OrtID |
INTEGER |
|
|
|
ASC |
|
|
|
|
|
100 |
|
37 |
|
|
|
|
PlzID |
INTEGER |
|
|
|
|
ASC |
|
|
|
|
100 |
|
45 |
|
|
|
|
StrasseID |
INTEGER |
|
|
ASC |
|
|
|
|
|
|
100 |
|
210 |
|
|
|
|
Telefon1 |
VARCHAR |
|
|
|
|
|
|
|
|
|
100 |
|
|
|
|
9 |
|
Telefon2 |
VARCHAR |
|
|
|
|
|
|
|
|
|
0 |
|
|
|
|
|
|
Vorname |
VARCHAR |
|
|
|
|
|
|
|
|
|
100 |
|
|
|
|
6 |
|
Vorwahl1ID |
INTEGER |
|
|
|
|
|
ASC |
|
|
|
100 |
|
21 |
|
|
|
|
Vorwahl2ID |
INTEGER |
|
|
|
|
|
|
|
|
|
0 |
|
|
|
|
|
inWorten |
inworten |
VARCHAR |
|
|
|
|
|
|
|
|
|
100 |
|
|
|
|
8 |
|
zahl |
TINYINT |
|
✔ |
|
|
|
|
|
|
|
100 |
|
20 |
|
|
|
Kontakte |
Domain1ID |
INTEGER |
|
|
|
|
ASC |
|
|
|
|
100 |
|
16 |
|
|
|
|
Domain2ID |
INTEGER |
|
|
|
|
|
|
|
|
|
0 |
|
|
|
|
|
|
Email1 |
VARCHAR |
|
|
|
|
|
|
|
|
|
100 |
|
|
|
|
8 |
|
Email2 |
VARCHAR |
|
|
|
|
|
|
|
|
|
0 |
|
|
|
|
|
|
Mitgliedsnummer |
SMALLINT |
|
✔ |
ASC |
|
|
|
|
|
|
100 |
|
1 |
|
|
|
|
Telefon1 |
VARCHAR |
|
|
|
|
|
|
|
|
|
100 |
|
|
|
|
6 |
|
Telefon2 |
VARCHAR |
|
|
|
|
|
|
|
|
|
100 |
|
|
|
|
6 |
|
Vorwahl1ID |
INTEGER |
|
|
|
ASC |
|
|
|
|
|
100 |
|
27 |
|
|
|
|
Vorwahl2ID |
INTEGER |
|
|
|
|
|
|
|
|
|
100 |
|
9 |
|
|
|
M_Campain |
Mitgliedsnummer |
SMALLINT |
|
✔ |
|
|
|
|
|
|
|
100 |
|
1 |
|
|
|
Mitglieder |
Geburtsdatum |
DATE |
|
|
|
|
|
|
|
|
|
100 |
|
|
01/01/1950 |
01/01/1950 |
|
|
Geschlecht |
VARCHAR |
|
|
ASC |
|
|
|
|
|
m oder w oder o |
100 |
|
|
|
|
1 |
|
Mitgliedsnummer |
SMALLINT |
|
✔ |
|
|
|
|
|
|
es gibt auch leere Mitgliedsnummern!!! |
100 |
|
1 |
|
|
|
|
Nachname |
VARCHAR |
|
|
|
|
|
|
|
|
|
100 |
|
|
|
|
7 |
|
Organisation |
VARCHAR |
|
|
|
|
|
|
|
|
Mitglied: Verein/Firma/... |
0 |
|
|
|
|
|
|
Vorname |
VARCHAR |
|
|
|
|
|
|
|
|
|
100 |
|
|
|
|
6 |
Orte |
ID |
INTEGER |
|
✔ |
|
|
|
|
|
|
|
100 |
|
42 |
|
|
|
|
Ort |
VARCHAR |
|
|
|
|
|
|
|
|
|
100 |
|
|
|
|
15 |
Pfade |
Dateiname |
VARCHAR |
|
|
|
|
|
|
|
|
|
100 |
|
|
|
|
28 |
|
ID |
SMALLINT |
|
✔ |
|
|
|
|
|
|
|
100 |
|
5 |
|
|
|
|
Muster |
VARCHAR |
|
|
|
|
|
|
|
|
|
100 |
|
|
|
|
15 |
|
Pfad_Drucke |
VARCHAR |
|
|
|
|
|
|
|
|
|
100 |
|
|
|
|
13 |
|
Pfad_Vorlagen |
VARCHAR |
|
|
|
|
|
|
|
|
|
100 |
|
|
|
|
16 |
|
Spaltenzahl |
SMALLINT |
|
|
|
|
|
|
|
|
|
100 |
|
4 |
|
|
|
Pfade_Briefe |
Abfrage |
VARCHAR |
|
|
|
|
|
|
|
|
|
100 |
|
|
|
|
15 |
|
Dateiname |
VARCHAR |
|
|
|
|
|
|
|
|
|
100 |
|
|
|
|
24 |
|
ID |
SMALLINT |
|
✔ |
|
|
|
|
|
|
|
100 |
|
9 |
|
|
|
|
Muster |
VARCHAR |
|
|
|
|
|
|
|
|
|
100 |
|
|
|
|
22 |
|
Pfad_Drucke |
VARCHAR |
|
|
|
|
|
|
|
|
|
100 |
|
|
|
|
13 |
|
Pfad_Vorlagen |
VARCHAR |
|
|
|
|
|
|
|
|
|
100 |
|
|
|
|
15 |
|
Spaltenzahl |
SMALLINT |
|
|
|
|
|
|
|
|
|
100 |
|
4 |
|
|
|
Pfade_Briefe_I |
Abfrage |
VARCHAR |
|
|
|
|
|
|
|
|
|
100 |
|
|
|
|
13 |
|
Dateiname |
VARCHAR |
|
|
|
|
|
|
|
|
|
100 |
|
|
|
|
21 |
|
ID |
SMALLINT |
|
✔ |
|
|
|
|
|
|
|
100 |
|
3 |
|
|
|
|
Muster |
VARCHAR |
|
|
|
|
|
|
|
|
|
100 |
|
|
|
|
15 |
|
Pfad_Drucke |
VARCHAR |
|
|
|
|
|
|
|
|
|
100 |
|
|
|
|
13 |
|
Pfad_Vorlagen |
VARCHAR |
|
|
|
|
|
|
|
|
|
100 |
|
|
|
|
15 |
|
Spaltenzahl |
SMALLINT |
|
|
|
|
|
|
|
|
|
100 |
|
|
|
|
|
Pfade_BZStExport |
Dateiname |
VARCHAR |
|
|
|
|
|
|
|
|
|
0 |
|
|
|
|
|
|
Pfad |
VARCHAR |
|
|
|
|
|
|
|
|
|
100 |
|
|
|
|
11 |
|
PfadID |
INTEGER |
|
✔ |
|
|
|
|
|
|
|
100 |
|
1 |
|
|
|
Pfade_BZStImport |
Dateiname |
VARCHAR |
|
|
|
|
|
|
|
|
|
0 |
|
|
|
|
|
|
Pfad |
VARCHAR |
|
|
|
|
|
|
|
|
|
100 |
|
|
|
|
11 |
|
PfadID |
INTEGER |
|
✔ |
|
|
|
|
|
|
|
100 |
|
15 |
|
|
|
Pfade_eMail |
Dateiname |
VARCHAR |
|
|
|
|
|
|
|
|
|
0 |
|
|
|
|
|
|
Pfad |
VARCHAR |
|
|
|
|
|
|
|
|
|
100 |
|
|
|
|
9 |
|
PfadID |
INTEGER |
|
✔ |
|
|
|
|
|
|
|
100 |
|
1 |
|
|
|
Pfade_SEPA |
Dateiname |
VARCHAR |
|
|
|
|
|
|
|
|
|
100 |
|
|
|
|
18 |
|
ID |
CHAR |
|
✔ |
|
|
|
|
|
|
|
100 |
|
|
|
|
1 |
|
Pfad |
VARCHAR |
|
|
|
|
|
|
|
|
|
100 |
|
|
|
|
13 |
PLZen |
ID |
INTEGER |
|
✔ |
|
|
|
|
|
|
-> PLZID |
100 |
|
52 |
|
|
|
|
PLZ |
VARCHAR |
|
|
|
|
|
|
|
|
ggf. mit Ausland-Kennzeichen |
100 |
|
|
|
|
5 |
Projekt_aktID |
ID |
TINYINT |
|
✔ |
|
|
|
|
|
|
|
100 |
|
|
|
|
|
|
Integer |
TINYINT |
|
|
|
|
|
|
|
|
|
100 |
|
2 |
|
|
|
ProjektDaten |
Bemerkungen |
VARCHAR |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Betrag |
DECIMAL |
2 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Endfälligkeit |
DATE |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
ID |
INTEGER |
|
✔ |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Mitgliedsnummer |
SMALLINT |
|
|
ASC |
|
|
|
|
|
|
|
|
|
|
|
|
|
ProjektID |
TINYINT |
|
|
|
|
ASC |
|
|
|
|
|
|
|
|
|
|
|
TagEintrag |
DATE |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
TagZahlung |
DATE |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Vertragsnummer |
VARCHAR |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
VorgangID |
TINYINT |
|
|
|
ASC |
|
|
|
|
|
|
|
|
|
|
|
Projekte |
ID |
TINYINT |
|
✔ |
|
|
|
|
|
|
|
100 |
|
2 |
|
|
|
|
Projekt |
VARCHAR |
|
|
|
|
|
|
|
|
|
100 |
|
|
|
|
14 |
ProjVorgaenge |
ID |
TINYINT |
|
✔ |
|
|
|
|
|
|
|
100 |
|
5 |
|
|
|
|
Vorgang |
VARCHAR |
|
|
|
|
|
|
|
|
|
100 |
|
|
|
|
17 |
Raten |
Bemerkungen |
VARCHAR |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
ID |
INTEGER |
|
✔ |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Mitgliedsnummer |
SMALLINT |
|
|
ASC |
|
|
|
|
|
|
|
|
|
|
|
|
|
RatePlusMinus |
DECIMAL |
2 |
|
|
|
|
|
|
|
ggf. Rücküberweisung? |
|
|
|
|
|
|
|
Saldo |
DECIMAL |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
TagEintrag |
DATE |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
TagZahlung |
DATE |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
VorgangID |
TINYINT |
|
|
|
ASC |
|
|
|
|
|
|
|
|
|
|
|
RatenVorgaenge |
ID |
TINYINT |
|
✔ |
|
|
|
|
|
|
|
100 |
|
7 |
|
|
|
|
Vorgang |
VARCHAR |
|
|
|
|
|
|
|
|
|
100 |
|
|
|
|
27 |
Religionen |
Meldeschl |
VARCHAR |
|
|
|
|
|
|
|
|
|
100 |
|
|
|
|
4 |
|
Name |
VARCHAR |
|
|
|
|
|
|
|
|
|
100 |
|
|
|
|
138 |
|
stOeId |
VARCHAR |
|
✔ |
|
|
|
|
|
|
|
100 |
|
|
|
|
5 |
SEPAaktZeile |
ID |
TINYINT |
|
✔ |
|
|
|
|
|
|
nur 0 |
100 |
|
|
|
|
|
|
SEPAZeile |
SMALLINT |
|
|
|
|
|
|
|
|
|
100 |
|
5 |
|
|
|
SEPAHistorie |
CREDTTM |
TIMESTAMP |
|
|
|
|
|
|
|
|
Erzeugungsdatum |
100 |
|
|
02/03/2017 |
02/03/2017 |
|
|
CTRLSUM |
DECIMAL |
2 |
|
|
|
|
|
|
|
|
100 |
17 |
17 |
|
|
|
|
DivHistZeile |
SMALLINT |
|
|
|
|
|
|
|
|
|
100 |
|
1 |
|
|
|
|
ENDTOENDID |
VARCHAR |
|
|
|
|
|
|
|
|
NOTPROVIDED |
0 |
|
|
|
|
|
|
ID |
INTEGER |
|
✔ |
|
|
|
|
|
|
|
100 |
|
1 |
|
|
|
|
MSGID |
VARCHAR |
|
|
|
|
|
|
|
|
|
100 |
|
|
|
|
26 |
|
NBOFTXS |
SMALLINT |
|
|
|
|
|
|
|
|
|
100 |
|
2 |
|
|
|
|
PMTINFID |
VARCHAR |
|
|
|
|
|
|
|
|
|
100 |
|
|
|
|
25 |
|
REQDEXCTNDT |
DATE |
|
|
|
|
|
|
|
|
aus DividendenHistorie |
100 |
|
|
26/01/2018 |
26/01/2018 |
|
|
USTRD_Muster |
VARCHAR |
|
|
|
|
|
|
|
|
|
100 |
|
|
|
|
9 |
SEPAselbst |
DB_BIC |
VARCHAR |
|
|
|
|
|
|
|
|
|
100 |
|
|
|
|
12 |
|
DB_IBAN |
VARCHAR |
|
|
|
|
|
|
|
|
|
100 |
|
|
|
|
14 |
|
DB_NM |
VARCHAR |
|
|
|
|
|
|
|
|
Kontoinhaber |
100 |
|
|
|
|
16 |
|
ID |
INTEGER |
|
✔ |
|
|
|
|
|
|
|
100 |
|
|
|
|
|
|
INITGPTY_NM |
VARCHAR |
|
|
|
|
|
|
|
|
Auftraggeber, Firma... |
100 |
|
|
|
|
19 |
SEPA-Tabelle |
Bemerkungen |
VARCHAR |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Feldname |
VARCHAR |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
ID |
VARCHAR |
|
✔ |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Wert |
VARCHAR |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
SEPAXML |
CD_BIC |
VARCHAR |
|
|
|
|
|
|
|
|
|
100 |
|
|
|
|
5 |
|
CD_IBAN |
VARCHAR |
|
|
|
|
|
|
|
|
|
100 |
|
|
|
|
6 |
|
CD_NM |
VARCHAR |
|
|
|
|
|
|
|
|
|
100 |
|
|
|
|
6 |
|
CREDTTM |
TIMESTAMP |
|
|
|
|
|
|
|
|
|
100 |
|
|
00:00:00 |
00:00:00 |
|
|
CTRLSUM |
DECIMAL |
2 |
|
|
|
|
|
|
|
|
100 |
12,34 |
12,34 |
|
|
|
|
DB_BIC |
VARCHAR |
|
|
|
|
|
|
|
|
|
100 |
|
|
|
|
9 |
|
DB_IBAN |
VARCHAR |
|
|
|
|
|
|
|
|
|
100 |
|
|
|
|
22 |
|
DB_NM |
VARCHAR |
|
|
|
|
|
|
|
|
|
100 |
|
|
|
|
26 |
|
ENDTOENDID |
VARCHAR |
|
|
|
|
|
|
|
|
|
100 |
|
|
|
|
5 |
|
ID |
INTEGER |
|
✔ |
|
|
|
|
|
|
|
100 |
|
1 |
|
|
|
|
INITGPTY_NM |
VARCHAR |
|
|
|
|
|
|
|
|
|
100 |
|
|
|
|
22 |
|
INSTAMT |
DECIMAL |
2 |
|
|
|
|
|
|
|
|
100 |
12 |
12 |
|
|
|
|
MSGID |
VARCHAR |
|
|
|
|
|
|
|
|
|
100 |
|
|
|
|
27 |
|
NBOFTXS |
SMALLINT |
|
|
|
|
|
|
|
|
|
100 |
|
2 |
|
|
|
|
PMTINFID |
VARCHAR |
|
|
|
|
|
|
|
|
|
100 |
|
|
|
|
25 |
|
REQDEXCTNDT |
DATE |
|
|
|
|
|
|
|
|
|
100 |
|
|
25/08/2017 |
25/08/2017 |
|
|
USTRD |
VARCHAR |
|
|
|
|
|
|
|
|
|
100 |
|
|
|
|
24 |
SEPAXML-b |
CD_BIC |
VARCHAR |
|
|
|
|
|
|
|
|
|
100 |
|
|
|
|
5 |
|
CD_IBAN |
VARCHAR |
|
|
|
|
|
|
|
|
|
100 |
|
|
|
|
6 |
|
CD_NM |
VARCHAR |
|
|
|
|
|
|
|
|
|
100 |
|
|
|
|
6 |
|
ENDTOENDID |
VARCHAR |
|
|
|
|
|
|
|
|
|
100 |
|
|
|
|
5 |
|
ID |
INTEGER |
|
✔ |
|
|
|
|
|
|
|
100 |
|
1 |
|
|
|
|
INSTAMT |
DECIMAL |
2 |
|
|
|
|
|
|
|
|
100 |
12 |
12 |
|
|
|
|
USTRD |
VARCHAR |
|
|
|
|
|
|
|
|
|
100 |
|
|
|
|
24 |
Staaten |
Bezeichnung |
VARCHAR |
|
|
|
|
|
|
|
|
|
100 |
|
|
|
|
46 |
|
Code |
VARCHAR |
|
|
|
|
|
|
|
|
da Code für Deutschland LEER sein muss! |
100 |
|
|
|
|
2 |
|
ID |
SMALLINT |
|
✔ |
|
|
|
|
|
|
nur zur Auswahl, kann nicht verknüpft weden, |
100 |
|
249 |
|
|
|
SteuerDaten |
Aktualisierung |
DATE |
|
|
|
|
|
|
|
|
|
0 |
|
|
|
|
|
|
FSA |
BOOLEAN |
|
|
|
|
|
|
|
|
|
0 |
|
|
|
|
|
|
FSAbis |
DATE |
|
|
|
|
|
|
|
|
|
0 |
|
|
|
|
|
|
FSARest |
DECIMAL |
2 |
|
|
|
|
|
|
|
Anfangs- oder Restbetrag |
0 |
|
|
|
|
|
|
Identifikationsnummer |
VARCHAR |
|
|
|
|
|
|
|
|
vom BZSt |
100 |
|
|
|
|
8 |
|
KiStOrgan |
VARCHAR |
|
|
|
|
|
|
|
|
|
0 |
|
|
|
|
|
|
KiStproz |
DECIMAL |
2 |
|
|
|
|
|
|
|
0,00 oder 9,00 oder 8,00 |
0 |
|
|
|
|
|
|
Mitgliedsnummer |
SMALLINT |
|
✔ |
ASC |
|
|
|
|
|
|
100 |
|
1 |
|
|
|
|
NV |
BOOLEAN |
|
|
|
|
|
|
|
|
|
0 |
|
|
|
|
|
|
NVbis |
DATE |
|
|
|
|
|
|
|
|
|
0 |
|
|
|
|
|
Strassen |
ID |
INTEGER |
|
✔ |
|
|
|
|
|
|
|
100 |
|
253 |
|
|
|
|
Strasse |
VARCHAR |
|
|
|
|
|
|
|
|
ohne HausNummer |
100 |
|
|
|
|
26 |
StromGas_Interessenten |
AnzahlGaszaehler |
VARCHAR |
|
|
|
|
|
|
|
|
0,1,2,... |
100 |
|
|
|
|
1 |
|
AnzahlStromzaehler |
TINYINT |
|
|
|
|
|
|
|
|
0,1,2,.. |
100 |
|
|
|
|
|
|
ID |
INTEGER |
|
✔ |
ASC |
|
|
|
|
|
|
100 |
|
1 |
|
|
|
|
LieferbeginnGas |
DATE |
|
|
|
|
|
|
|
|
|
0 |
|
|
|
|
|
|
LieferbeginnStrom |
DATE |
|
|
|
|
|
|
|
|
|
0 |
|
|
|
|
|
|
StatusGasID |
TINYINT |
|
|
|
|
|
|
|
|
|
100 |
|
|
|
|
|
|
StatusStromID |
TINYINT |
|
|
|
ASC |
|
|
|
|
ohne,Privat,Familie,Gewerbe |
100 |
|
|
|
|
|
StromGas_Mitglieder |
AnzahlGaszaehler |
TINYINT |
|
|
|
|
|
|
|
|
bei Familie=0 |
100 |
|
|
|
|
|
|
AnzahlStromzaehler |
TINYINT |
|
|
|
|
|
|
|
|
bei Familie=0 |
100 |
|
1 |
|
|
|
|
LieferbeginnGas |
DATE |
|
|
|
|
|
|
|
|
|
0 |
|
|
|
|
|
|
LieferbeginnStrom |
DATE |
|
|
|
|
|
|
|
|
|
100 |
|
|
01/01/2016 |
01/01/2016 |
|
|
Mitgliedsnummer |
SMALLINT |
|
✔ |
ASC |
|
|
|
|
|
|
100 |
|
1 |
|
|
|
|
StatusGasID |
TINYINT |
|
|
|
|
|
|
|
|
ohne,Privat,Familie,Gewerbe |
100 |
|
|
|
|
|
|
StatusStromID |
TINYINT |
|
|
|
ASC |
|
|
|
|
ohne,Privat,Familie,Gewerbe |
100 |
|
1 |
|
|
|
StromGasStatus |
ID |
TINYINT |
|
✔ |
|
|
|
|
|
|
|
100 |
|
3 |
|
|
|
|
Text |
VARCHAR |
|
|
|
|
|
|
|
|
|
100 |
|
|
|
|
7 |
Texte |
Betreff |
VARCHAR |
|
|
|
|
|
|
|
|
max. 100 Zeichen |
100 |
|
|
|
|
27 |
|
ID |
VARCHAR |
|
✔ |
|
|
|
|
|
|
Codierung: MAIL-STROM-MITGLIEDER |
100 |
|
|
|
|
20 |
|
Text |
LONGVARCHAR |
|
|
|
|
|
|
|
|
max. 10.000 Zeichen. Email-Text-Absaetze=%0A |
100 |
|
|
|
|
1324 |
Versorger |
ID |
INTEGER |
|
✔ |
|
|
|
|
|
|
|
100 |
|
2 |
|
|
|
|
Versorger |
VARCHAR |
|
|
|
|
|
|
|
|
|
100 |
|
|
|
|
11 |
von_bis |
aktuell |
SMALLINT |
|
|
|
|
|
|
|
|
|
100 |
|
1 |
|
|
|
|
bis |
SMALLINT |
|
|
|
|
|
|
|
|
|
100 |
|
1 |
|
|
|
|
ID |
INTEGER |
|
✔ |
|
|
|
|
|
|
|
100 |
|
|
|
|
|
|
von |
SMALLINT |
|
|
|
|
|
|
|
|
|
100 |
|
1 |
|
|
|
von_bis_I |
aktuell |
SMALLINT |
|
|
|
|
|
|
|
|
|
100 |
|
1 |
|
|
|
|
bis |
SMALLINT |
|
|
|
|
|
|
|
|
|
100 |
|
1 |
|
|
|
|
ID |
INTEGER |
|
✔ |
|
|
|
|
|
|
|
100 |
|
|
|
|
|
|
von |
SMALLINT |
|
|
|
|
|
|
|
|
|
100 |
|
1 |
|
|
|
Vorgaenge |
ID |
TINYINT |
|
✔ |
|
|
|
|
|
|
|
100 |
|
50 |
|
|
|
|
nichtmehr |
BOOLEAN |
|
|
|
|
|
|
|
|
|
100 |
|
|
|
|
|
|
Vorgang |
VARCHAR |
|
|
|
|
|
|
|
|
|
100 |
|
|
|
|
64 |
Vorwahlen |
ID |
INTEGER |
|
✔ |
|
|
|
|
|
|
|
100 |
|
30 |
|
|
|
|
Vorwahl |
VARCHAR |
|
|
|
|
|
|
|
|
|
100 |
|
|
|
|
9 |