id | int(20) |
|
|
|
SrNo | int(50) |
|
|
|
DailyVisitDate | date |
|
|
|
EmpName | varchar(20) |
|
|
|
Department | varchar(20) |
|
|
|
Designation | varchar(20) |
|
|
|
Site | varchar(20) |
|
|
|
ClientName | varchar(30) |
|
|
|
ClientLocation | varchar(50) |
|
|
|
ClientCity | varchar(50) |
|
|
|
ContactPerson | varchar(50) |
|
|
|
MobileNo | int(20) |
|
|
|
OfficeNo | int(20) |
|
|
|
Email | varchar(30) |
|
|
|
Website | varchar(30) |
|
|
|
MeetingType | varchar(20) |
|
|
|
PurposeAssigned | tinyblob |
|
|
Binary - do not edit (0 B) (Max: 256B)
|
MeetingDes | tinyblob |
|
|
Binary - do not edit (0 B) (Max: 256B)
|
ExpenseFrom | date |
|
|
|
ExpenseTo | date |
|
|
|
Mode | varchar(20) |
|
|
|
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) |
|
|
|
PaidStatus | varchar(20) |
|
|
|
Narration | tinyblob |
|
|
Binary - do not edit (0 B) (Max: 256B)
|