If you begin to handle more deeply with vtiger, you will quickly face the issue, that somehow the data structure of vtiger seems to be odd. But it is not, it is well structured and you need to identify how.
Location of the database schema definition for Quotes
Let’s say you want to know all standard and custom fields of the module Quotes. You can use this SQL for it:
select vtiger_field.tablename, vtiger_field.columnname, vtiger_field.fieldlabel, vtiger_field.fieldname, `generatedtype`, `sequence` from vtiger_field inner join vtiger_tab on vtiger_field.tabid = vtiger_tab.tabid where vtiger_tab.name = 'Quotes' ORDER by `sequence`The sorting is the same sorting like on your Settings page in Settings > Module Management > Module Layouts & Fields
Related articles
How to find custom field name in vtiger Module Layouts & Fields UI?