|
Quote_Id
|
int(11)
|
|
|
|
|
quote_seqid
|
int(15)
|
|
|
|
|
quote_noid
|
varchar(50)
|
latin1_swedish_ci
|
|
|
|
Quote_No
|
varchar(255)
|
latin1_swedish_ci
|
|
|
|
Cust_No
|
int(11)
|
|
|
|
|
Cust_Ref
|
varchar(255)
|
latin1_swedish_ci
|
|
|
|
Qdate
|
varchar(55)
|
latin1_swedish_ci
|
|
|
|
Total
|
double(10,2)
|
|
|
|
|
Discount
|
double(10,2)
|
|
|
|
|
t_remarks
|
varchar(255)
|
latin1_swedish_ci
|
|
|
|
transportation
|
double(10,2)
|
|
|
|
|
vat_rate
|
int(15)
|
|
|
|
|
vat_amt
|
double(10,2)
|
|
|
|
|
round_amount
|
varchar(100)
|
latin1_swedish_ci
|
|
|
|
Grand_Total
|
double(10,2)
|
|
|
|
|
d_remarks
|
varchar(255)
|
latin1_swedish_ci
|
|
|
|
dismatling
|
double(10,2)
|
|
|
|
|
Note1
|
text
|
latin1_swedish_ci
|
|
|
|
Note2
|
text
|
latin1_swedish_ci
|
|
|
|
Payment_Terms
|
varchar(255)
|
latin1_swedish_ci
|
|
|
|
Rental_name
|
varchar(200)
|
latin1_swedish_ci
|
|
|
|
Validity
|
varchar(255)
|
latin1_swedish_ci
|
|
|
|
Delivery
|
varchar(255)
|
latin1_swedish_ci
|
|
|
|
Availability
|
varchar(255)
|
latin1_swedish_ci
|
|
|
|
QStatus
|
varchar(55)
|
latin1_swedish_ci
|
|
|
|
Assign_quo
|
varchar(100)
|
latin1_swedish_ci
|
|
|
|
CreateUser
|
varchar(55)
|
latin1_swedish_ci
|
|
|
|
CreateTime
|
varchar(55)
|
latin1_swedish_ci
|
|
|
|
Con_follow_date
|
varchar(60)
|
latin1_swedish_ci
|
|
|
|
Con_follow_time
|
varchar(60)
|
latin1_swedish_ci
|
|
|
|
Con_follow_user
|
int(22)
|
|
|
|
|
prodcution_status
|
varchar(100)
|
latin1_swedish_ci
|
|
|
|
quote_comments
|
text
|
latin1_swedish_ci
|
|
|
|
quote_commentuser
|
int(20)
|
|
|
|
|
quote_commenttime
|
varchar(150)
|
latin1_swedish_ci
|
|
|
|
Quote_siteperson
|
int(20)
|
|
|
|
|
Quote_sitedate
|
varchar(100)
|
latin1_swedish_ci
|
|
|
|
Quote_sitetime
|
varchar(50)
|
latin1_swedish_ci
|
|
|
|
Quote_sitecountry
|
int(20)
|
|
|
|
|
Quote_sitecity
|
int(30)
|
|
|
|
|
Quote_sitearea
|
varchar(100)
|
latin1_swedish_ci
|
|
|
|
Quote_sitegatepass
|
varchar(50)
|
latin1_swedish_ci
|
|
|
|
Quote_siteinfo
|
text
|
latin1_swedish_ci
|
|
|
|
Quote_windate
|
varchar(150)
|
latin1_swedish_ci
|
|
|
|
Quote_winuser
|
int(20)
|
|
|
|
|
Quote_reason
|
text
|
latin1_swedish_ci
|
|
|
|
Quote_reasontype
|
varchar(100)
|
latin1_swedish_ci
|
|
|
|
Quote_lostreason
|
varchar(100)
|
latin1_swedish_ci
|
|
|
|
Quote_reasonappby
|
int(20)
|
|
|
|
|
Quote_reasonappcom
|
varchar(200)
|
latin1_swedish_ci
|
|
|
|
Quote_appstatus
|
varchar(100)
|
latin1_swedish_ci
|
|
|
|
Quote_appstatus_commnt
|
varchar(100)
|
latin1_swedish_ci
|
|
|
|
Quote_resonapproveby
|
int(20)
|
|
|
|
|
Quote_invoicestatus
|
varchar(100)
|
latin1_swedish_ci
|
|
|
|
Quote_lopno
|
varchar(150)
|
latin1_swedish_ci
|
|
|
|
modifyuser
|
int(20)
|
|
|
|
|
Quotation_priority
|
varchar(50)
|
latin1_swedish_ci
|
|
|
|
Quote_appreasontype
|
varchar(200)
|
latin1_swedish_ci
|
|
|
|
Quote_suporvisorcmnts
|
varchar(200)
|
latin1_swedish_ci
|
|
|
|
person_name
|
varchar(100)
|
latin1_swedish_ci
|
|
|
|
contact_no
|
varchar(100)
|
latin1_swedish_ci
|
|
|
|
payment_collection
|
varchar(200)
|
latin1_swedish_ci
|
|
|
|
quotation_type
|
varchar(100)
|
latin1_swedish_ci
|
|
|
|
delivery_type
|
varchar(111)
|
latin1_swedish_ci
|
|
|
|
lost_by
|
varchar(111)
|
latin1_swedish_ci
|
|
|
|
losttime
|
varchar(111)
|
latin1_swedish_ci
|
|
|
|
Quote_suporvisorcmnts_time
|
varchar(111)
|
latin1_swedish_ci
|
|
|
|
Quote_suporvisorcmnts_user
|
varchar(111)
|
latin1_swedish_ci
|
|
|
|
quotation_status
|
varchar(111)
|
latin1_swedish_ci
|
|
|
|
quotation_status_comment
|
varchar(111)
|
latin1_swedish_ci
|
|
|
|
quotation_status_time
|
varchar(111)
|
latin1_swedish_ci
|
|
|
|
quotation_status_user
|
varchar(111)
|
latin1_swedish_ci
|
|
|
|
quotation_transfer
|
int(15)
|
|
|
|
|
admin_approval
|
varchar(30)
|
latin1_swedish_ci
|
|
|
|
admin_approvalby
|
int(15)
|
|
|
|
|
admin_approvaldate
|
varchar(80)
|
latin1_swedish_ci
|
|
|
|
admin_approvalremak
|
text
|
latin1_swedish_ci
|
|
|
