id |
int(20) |
|
|
|
|
SrNo |
int(50) |
|
|
|
|
DailyVisitDate |
date |
|
|
|
|
EmpName |
varchar(20) |
latin1_swedish_ci |
|
|
|
Department |
varchar(20) |
latin1_swedish_ci |
|
|
|
Designation |
varchar(20) |
latin1_swedish_ci |
|
|
|
Site |
varchar(20) |
latin1_swedish_ci |
|
|
|
ClientName |
varchar(30) |
latin1_swedish_ci |
|
|
|
ClientLocation |
varchar(50) |
latin1_swedish_ci |
|
|
|
ClientCity |
varchar(50) |
latin1_swedish_ci |
|
|
|
ContactPerson |
varchar(50) |
latin1_swedish_ci |
|
|
|
MobileNo |
int(20) |
|
|
|
|
OfficeNo |
int(20) |
|
|
|
|
Email |
varchar(30) |
latin1_swedish_ci |
|
|
|
Website |
varchar(30) |
latin1_swedish_ci |
|
|
|
MeetingType |
varchar(20) |
latin1_swedish_ci |
|
|
|
PurposeAssigned |
tinyblob |
|
|
|
|
MeetingDes |
tinyblob |
|
|
|
|
ExpenseFrom |
date |
|
|
|
|
ExpenseTo |
date |
|
|
|
|
Mode |
varchar(20) |
latin1_swedish_ci |
|
|
|
TotalKM |
decimal(10,2) |
|
|
|
|
Rate |
decimal(10,2) |
|
|
|
|
TotalTA |
decimal(10,2) |
|
|
|
|
Fooding |
decimal(10,2) |
|
|
|
|
OtherCharges |
decimal(10,2) |
|
|
|
|
TotalAmt |
decimal(10,2) |
|
|
|
|
ReportTo |
varchar(30) |
latin1_swedish_ci |
|
|
|
PaidStatus |
varchar(20) |
latin1_swedish_ci |
|
|
|
Narration |
tinyblob |
|
|
|
|