| id |
int(10)
|
|
|
|
| MemberID |
int(11)
|
|
|
|
| JahrMonat |
int(10)
|
|
|
|
| Rechnungsnummer |
bigint(20)
|
|
|
|
| BankName |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| IBAN |
varchar(50)
|
utf8mb4_general_ci
|
|
|
| BIC |
varchar(50)
|
utf8mb4_general_ci
|
|
|
| Mandatsreferenz |
varchar(30)
|
utf8mb4_general_ci
|
|
|
| Betrag_Amount |
decimal(13,2)
|
|
|
|
| IssuedOn |
date
|
|
|
|
| SEPAExportTime |
datetime
|
|
|
|
| FileName |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| BenutzerIDneu |
int(11)
|
|
|
|
| Type |
int(10)
|
|
|
|
| Purpose |
varchar(140)
|
utf8mb4_general_ci
|
|
|
| status |
int(11)
|
|
|
|
| deleted |
int(11)
|
|
|
|
| addedOn |
datetime
|
|
|
|
| addedBy |
int(11)
|
|
|
|
| modifiedBy |
int(11)
|
|
|
|
| modifiedOn |
timestamp
|
|
|
|