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 |
|
|
二进制 - 无法编辑 (0 字节) (最大限制:256 字节)
|
MeetingDes | tinyblob |
|
|
二进制 - 无法编辑 (0 字节) (最大限制:256 字节)
|
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 |
|
|
二进制 - 无法编辑 (0 字节) (最大限制:256 字节)
|