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