| id |
int(11)
|
|
|
|
| account_id |
int(11)
|
|
|
|
| transfer_account_id |
int(11)
|
|
|
|
| type |
varchar(255)
|
utf8_general_ci
|
|
|
| number |
varchar(255)
|
utf8_general_ci
|
|
|
| date |
date
|
|
|
|
| payee |
varchar(255)
|
utf8_general_ci
|
|
|
| MemberID |
int(11)
|
|
|
|
| amount |
decimal(10,2)
|
|
|
|
| amount2 |
decimal(10,2)
|
|
|
|
| exchange_rate |
decimal(10,2)
|
|
|
|
| category_id |
int(11)
|
|
|
|
| sub_category_id |
int(11)
|
|
|
|
| sub_sub_category_id |
int(11)
|
|
|
|
| info |
mediumtext
|
utf8_general_ci
|
|
|
| document |
varchar(155)
|
utf8_general_ci
|
|
|
| document_file |
longblob
|
|
|
|
| status |
int(11)
|
|
|
|
| deleted |
int(11)
|
|
|
|
| addedOn |
datetime
|
|
|
|
| addedBy |
int(11)
|
|
|
|
| modifiedBy |
int(11)
|
|
|
|
| modifiedOn |
timestamp
|
|
|
|
| TransactionID |
int(11)
|
|
|
|
| IBAN |
text
|
utf8_general_ci
|
|
|
| is_back_from_bank |
int(11)
|
|
|
|
| back_from_bank_payee |
varchar(255)
|
utf8_general_ci
|
|
|