|
id
|
int(10) unsigned
|
|
|
|
|
OwnerID
|
int(10) unsigned
|
|
|
0
|
|
FromDate
|
date
|
|
|
|
|
TillDate
|
date
|
|
|
|
|
Type
|
int(10) unsigned
|
|
|
0
|
|
PayByMonth
|
decimal(10,2)
|
|
|
0.00
|
|
NotIBANCorrectAmount
|
decimal(10,2)
|
|
|
0.00
|
|
PayPeriodType
|
int(11)
|
|
|
-1
|
|
PayBedType
|
int(11)
|
|
|
-1
|
|
FirstMonth
|
int(10) unsigned
|
|
|
0
|
|
FirstMonthNotIBANCorrect
|
int(10) unsigned
|
|
|
0
|
|
FirstMonthSEPAError
|
int(10) unsigned
|
|
|
0
|
|
ClientBankName
|
text
|
|
|
|
|
NotIBANCorrectDate
|
date
|
|
|
|
|
CanTakeClientMoney
|
enum
|
-- |
|
Yes
|
|
ClientBLZ
|
varchar(255)
|
|
|
|
|
IsNotIBANCorrect
|
enum
|
-- |
|
No
|
|
ClientBIC
|
varchar(255)
|
|
|
|
|
IsSEPAError
|
enum
|
-- |
|
No
|
|
StartFile
|
longblob
|
|
|
Binary - do not edit (0 B)
(Max: 4,096MiB)
|
|
ClientAccountNumber
|
varchar(255)
|
|
|
|
|
StartExt
|
varchar(255)
|
|
|
|
|
FinishExt
|
varchar(255)
|
|
|
|
|
FinishFile
|
longblob
|
|
|
Binary - do not edit (0 B)
(Max: 4,096MiB)
|
|
OurAccountID
|
int(10) unsigned
|
|
|
|
|
OurBankID
|
int(10) unsigned
|
|
|
|
|
IssuedOn
|
date
|
|
|
|
|
SequenceType
|
enum
|
-- |
|
|
|
Mandatsreferenz
|
varchar(30)
|
|
|
|
|
status
|
int(11)
|
|
|
1
|
|
deleted
|
int(11)
|
|
|
0
|
|
addedOn
|
datetime
|
|
|
2026-02-10 09:37:33.000000
|
|
addedBy
|
int(11)
|
|
|
|
|
modifiedBy
|
int(11)
|
|
|
|
|
modifiedOn
|
timestamp
|
|
|
current_timestamp()
|