| id |
int(11)
|
|
|
|
| series |
varchar(255)
|
latin1_swedish_ci
|
|
|
| trans_no |
varchar(50)
|
latin1_swedish_ci
|
|
|
| trans_date |
date
|
|
|
|
| rfi_id |
int(11)
|
|
|
|
| rfi_no |
varchar(250)
|
latin1_swedish_ci
|
|
|
| plateid |
int(11)
|
|
|
|
| plateno |
varchar(255)
|
latin1_swedish_ci
|
|
|
| vehicletype |
varchar(255)
|
latin1_swedish_ci
|
|
|
| description |
text
|
latin1_swedish_ci
|
|
|
| serialno |
varchar(500)
|
latin1_swedish_ci
|
|
|
| brandmodel |
varchar(500)
|
latin1_swedish_ci
|
|
|
| acquired |
varchar(500)
|
latin1_swedish_ci
|
|
|
| amount |
double
|
|
|
|
| dept_id |
int(11)
|
|
|
|
| department_name |
varchar(255)
|
latin1_swedish_ci
|
|
|
| empid |
int(11)
|
|
|
|
| empname |
varchar(500)
|
latin1_swedish_ci
|
|
|
| driver_id |
int(11)
|
|
|
|
| driver_name |
varchar(255)
|
latin1_swedish_ci
|
|
|
| requestedid |
int(11)
|
|
|
|
| requestedname |
varchar(500)
|
latin1_swedish_ci
|
|
|
| approvedid |
int(11)
|
|
|
|
| approvedname |
varchar(500)
|
latin1_swedish_ci
|
|
|
| receivedid |
int(11)
|
|
|
|
| receivedname |
varchar(500)
|
latin1_swedish_ci
|
|
|
| reason |
text
|
latin1_swedish_ci
|
|
|
| remarks |
text
|
latin1_swedish_ci
|
|
|
| Status |
varchar(50)
|
latin1_swedish_ci
|
|
|
| indorse_status |
varchar(50)
|
latin1_swedish_ci
|
|
|
| date_save |
timestamp
|
|
|
|
| userdept_id |
int(11)
|
|
|
|
| userid |
int(11)
|
|
|
|
| userdeptid |
int(11)
|
|
|
|