|
id
|
int(10) unsigned
|
|
|
|
|
MemberID
|
int(11)
|
|
|
0
|
|
JahrMonat
|
int(10) unsigned
|
|
|
0
|
|
Rechnungsnummer
|
bigint(20) unsigned
|
|
|
0
|
|
BankName
|
varchar(255)
|
|
|
|
|
IBAN
|
varchar(50)
|
|
|
|
|
BIC
|
varchar(50)
|
|
|
|
|
Mandatsreferenz
|
varchar(30)
|
|
|
|
|
Betrag_Amount
|
decimal(13,2)
|
|
|
0.00
|
|
IssuedOn
|
date
|
|
|
|
|
SEPAExportTime
|
datetime
|
|
|
|
|
FileName
|
varchar(255)
|
|
|
|
|
BenutzerIDneu
|
int(11)
|
|
|
0
|
|
Type
|
int(10) unsigned
|
|
|
0
|
|
Purpose
|
varchar(140)
|
|
|
|
|
status
|
int(11)
|
|
|
1
|
|
deleted
|
int(11)
|
|
|
0
|
|
addedOn
|
datetime
|
|
|
2026-02-10 09:38:59.000000
|
|
addedBy
|
int(11)
|
|
|
|
|
modifiedBy
|
int(11)
|
|
|
|
|
modifiedOn
|
timestamp
|
|
|
current_timestamp()
|