| ID |
int(11)
|
|
|
|
| Timestamp |
timestamp
|
|
|
|
| UserName |
varchar(20)
|
utf8_general_ci
|
|
|
| BranchOffice |
varchar(20)
|
utf8_general_ci
|
|
|
| loanID |
int(11)
|
|
|
|
| InvoiceType |
varchar(10)
|
utf8_general_ci
|
|
|
| CustomerID |
int(11)
|
|
|
|
| BookingType |
varchar(50)
|
utf8_general_ci
|
|
|
| DateBooking |
date
|
|
|
|
| Currency |
varchar(10)
|
utf8_general_ci
|
|
|
| AmtDeposit |
double
|
|
|
|
| AmtWithdraw |
double
|
|
|
|
| AccountID |
varchar(10)
|
utf8_general_ci
|
|
|
| Note |
varchar(50)
|
utf8_general_ci
|
|
|
| StaffID |
int(11)
|
|
|
|
| UserNTm |
varchar(100)
|
utf8_general_ci
|
|
|
| Principlepaid |
double
|
|
|
|
| Interestpaid |
double
|
|
|
|
| OperationPaid |
double
|
|
|
|
| SavingPaid |
double
|
|
|
|
| PenaltyPaid |
double
|
|
|
|
| AmtPaid |
double
|
|
|
|
| No |
int(11)
|
|
|
|
| datepayment |
date
|
|
|
|
