| ID |
int(11)
|
|
|
|
| BPAID |
int(11)
|
|
|
|
| GUID |
varchar(60)
|
latin1_swedish_ci
|
|
|
| TrackingNum |
varchar(50)
|
latin1_swedish_ci
|
|
|
| DocType |
varchar(255)
|
latin1_swedish_ci
|
|
|
| Sender |
text
|
latin1_swedish_ci
|
|
|
| email_add |
varchar(225)
|
latin1_swedish_ci
|
|
|
| Subject |
text
|
latin1_swedish_ci
|
|
|
| Remarks |
text
|
latin1_swedish_ci
|
|
|
| DateSubmitted |
date
|
|
|
|
| ExpectedReturn |
datetime
|
|
|
|
| date_done |
datetime
|
|
|
|
| done_uid |
int(11)
|
|
|
|
| ReceivingDeptID |
int(11)
|
|
|
|
| RecivingOffice |
varchar(255)
|
latin1_swedish_ci
|
|
|
| flow_id |
varchar(225)
|
latin1_swedish_ci
|
|
|
| DocumentFlowCode |
varchar(100)
|
latin1_swedish_ci
|
|
|
| status |
varchar(20)
|
latin1_swedish_ci
|
|
|
| TS |
timestamp
|
|
|
|
| IsTransmitted |
int(1)
|
|
|
|
| ReceivedBy |
int(11)
|
|
|
|
| referred_by |
varchar(225)
|
latin1_swedish_ci
|
|
|
| payeeName |
varchar(50)
|
latin1_swedish_ci
|
|
|
| payeeAmount |
decimal(20,2)
|
|
|
|
| check_number |
varchar(20)
|
latin1_swedish_ci
|
|
|
| check_date |
date
|
|
|
|
| source_of_fund |
varchar(225)
|
latin1_swedish_ci
|
|
|
| employee |
int(11)
|
|
|
|
| main_stat |
varchar(225)
|
latin1_swedish_ci
|
|
|
| last_stat |
varchar(225)
|
latin1_swedish_ci
|
|
|
| docs_qr |
text
|
latin1_swedish_ci
|
|
|
| contact_no |
varchar(225)
|
latin1_swedish_ci
|
|
|
| category_id |
int(11)
|
|
|
|
| pow_id |
int(11)
|
|
|
|