MySQL fields_meta_data Definitions:
nametypelen
idvarchar255
namevarchar255
vnamevarchar255
commentsvarchar255
helpvarchar255
custom_modulevarchar255
typevarchar255
lenint11
requiredtinyint
default_valuevarchar255
date_modifieddatetime
deletedtinyint
auditedtinyint
massupdatetinyint
duplicate_mergesmallint
reportabletinyint1
importablevarchar255
ext1varchar255
ext2varchar255
ext3varchar255
ext4text
MySQL fields_meta_data Keys:
nametypefields
primaryprimaryid
idx_meta_id_delindexid,deleted
idx_meta_cm_delindexcustom_module,deleted


#idnamevnamecommentshelpcustom_moduletypelenrequireddefault_valuedate_modifieddeletedauditedmassupdateduplicate_mergereportableimportableext1ext2ext3ext4
1Accountsjjwg_maps_address_cjjwg_maps_address_cLBL_JJWG_MAPS_ADDRESSAddressAddressAccountsvarchar2550 2018-05-17 16:05:4100001true    
2Accountsjjwg_maps_geocode_status_cjjwg_maps_geocode_status_cLBL_JJWG_MAPS_GEOCODE_STATUSGeocode StatusGeocode StatusAccountsvarchar2550 2018-05-17 16:05:4100001true    
3Accountsjjwg_maps_lat_cjjwg_maps_lat_cLBL_JJWG_MAPS_LAT LatitudeAccountsfloat1000.000000002018-05-17 16:05:4100001true8   
4Accountsjjwg_maps_lng_cjjwg_maps_lng_cLBL_JJWG_MAPS_LNG LongitudeAccountsfloat1100.000000002018-05-17 16:05:4100001true8   
5Accountsmapa_cmapa_cLBL_MAPA  Accountsiframe2550http://maps.google.com?q={billing_address_street},{billing_address_city},{billing_address_state}&output=embed2018-05-28 23:04:3800001true  1200
6Accountsnit_cnit_cLBL_NIT  Accountsint2550 2018-05-19 20:16:3100011true    
7AOS_Invoicesfecha_cuenta_cobro_cfecha_cuenta_cobro_cLBL_FECHA_CUENTA_COBRO  AOS_Invoicesdate 1now2018-06-07 18:08:4601001true    
8AOS_Invoicesvalor_cvalor_cLBL_VALOR  AOS_Invoicesint2551 2018-06-07 18:12:2201001true    
9AOS_Invoicesvalor_letras_cvalor_letras_cLBL_VALOR_LETRAS  AOS_Invoicesvarchar2551 2018-06-07 18:13:0901001true    
10AOS_Quotesobservaciones_cobservaciones_cLBL_OBSERVACIONES  AOS_Quotestext 0 2018-05-25 15:19:3801001true 420 
11AOS_Quotesplazo_entrega_cplazo_entrega_cLBL_PLAZO_ENTREGA  AOS_Quotesint2550 2018-05-19 21:03:1700001true    
12Casesjjwg_maps_address_cjjwg_maps_address_cLBL_JJWG_MAPS_ADDRESSAddressAddressCasesvarchar2550 2018-05-17 16:05:4100001true    
13Casesjjwg_maps_geocode_status_cjjwg_maps_geocode_status_cLBL_JJWG_MAPS_GEOCODE_STATUSGeocode StatusGeocode StatusCasesvarchar2550 2018-05-17 16:05:4100001true    
14Casesjjwg_maps_lat_cjjwg_maps_lat_cLBL_JJWG_MAPS_LAT LatitudeCasesfloat1000.000000002018-05-17 16:05:4100001true8   
15Casesjjwg_maps_lng_cjjwg_maps_lng_cLBL_JJWG_MAPS_LNG LongitudeCasesfloat1100.000000002018-05-17 16:05:4100001true8   
16Contactsjjwg_maps_address_cjjwg_maps_address_cLBL_JJWG_MAPS_ADDRESSAddressAddressContactsvarchar2550 2018-05-17 16:05:4100001true    
17Contactsjjwg_maps_geocode_status_cjjwg_maps_geocode_status_cLBL_JJWG_MAPS_GEOCODE_STATUSGeocode StatusGeocode StatusContactsvarchar2550 2018-05-17 16:05:4100001true    
18Contactsjjwg_maps_lat_cjjwg_maps_lat_cLBL_JJWG_MAPS_LAT LatitudeContactsfloat1000.000000002018-05-17 16:05:4100001true8   
19Contactsjjwg_maps_lng_cjjwg_maps_lng_cLBL_JJWG_MAPS_LNG LongitudeContactsfloat1100.000000002018-05-17 16:05:4100001true8   
20Leadsjjwg_maps_address_cjjwg_maps_address_cLBL_JJWG_MAPS_ADDRESSAddressAddressLeadsvarchar2550 2018-05-17 16:05:4100001true    
21Leadsjjwg_maps_geocode_status_cjjwg_maps_geocode_status_cLBL_JJWG_MAPS_GEOCODE_STATUSGeocode StatusGeocode StatusLeadsvarchar2550 2018-05-17 16:05:4100001true    
22Leadsjjwg_maps_lat_cjjwg_maps_lat_cLBL_JJWG_MAPS_LAT LatitudeLeadsfloat1000.000000002018-05-17 16:05:4100001true8   
23Leadsjjwg_maps_lng_cjjwg_maps_lng_cLBL_JJWG_MAPS_LNG LongitudeLeadsfloat1100.000000002018-05-17 16:05:4100001true8   
24Meetingsjjwg_maps_address_cjjwg_maps_address_cLBL_JJWG_MAPS_ADDRESSAddressAddressMeetingsvarchar2550 2018-05-17 16:05:4100001true    
25Meetingsjjwg_maps_geocode_status_cjjwg_maps_geocode_status_cLBL_JJWG_MAPS_GEOCODE_STATUSGeocode StatusGeocode StatusMeetingsvarchar2550 2018-05-17 16:05:4100001true    
26Meetingsjjwg_maps_lat_cjjwg_maps_lat_cLBL_JJWG_MAPS_LAT LatitudeMeetingsfloat1000.000000002018-05-17 16:05:4100001true8   
27Meetingsjjwg_maps_lng_cjjwg_maps_lng_cLBL_JJWG_MAPS_LNG LongitudeMeetingsfloat1100.000000002018-05-17 16:05:4100001true8   
28Notesorden_trabajo_corden_trabajo_cLBL_ORDEN_TRABAJO  Notesint2551 2018-06-08 19:33:2601001true    
29Opportunitiesjjwg_maps_address_cjjwg_maps_address_cLBL_JJWG_MAPS_ADDRESSAddressAddressOpportunitiesvarchar2550 2018-05-17 16:05:4100001true    
30Opportunitiesjjwg_maps_geocode_status_cjjwg_maps_geocode_status_cLBL_JJWG_MAPS_GEOCODE_STATUSGeocode StatusGeocode StatusOpportunitiesvarchar2550 2018-05-17 16:05:4100001true    
31Opportunitiesjjwg_maps_lat_cjjwg_maps_lat_cLBL_JJWG_MAPS_LAT LatitudeOpportunitiesfloat1000.000000002018-05-17 16:05:4100001true8   
32Opportunitiesjjwg_maps_lng_cjjwg_maps_lng_cLBL_JJWG_MAPS_LNG LongitudeOpportunitiesfloat1100.000000002018-05-17 16:05:4100001true8   
33Projectjjwg_maps_address_cjjwg_maps_address_cLBL_JJWG_MAPS_ADDRESSAddressAddressProjectvarchar2550 2018-05-17 16:05:4100001true    
34Projectjjwg_maps_geocode_status_cjjwg_maps_geocode_status_cLBL_JJWG_MAPS_GEOCODE_STATUSGeocode StatusGeocode StatusProjectvarchar2550 2018-05-17 16:05:4100001true    
35Projectjjwg_maps_lat_cjjwg_maps_lat_cLBL_JJWG_MAPS_LAT LatitudeProjectfloat1000.000000002018-05-17 16:05:4100001true8   
36Projectjjwg_maps_lng_cjjwg_maps_lng_cLBL_JJWG_MAPS_LNG LongitudeProjectfloat1100.000000002018-05-17 16:05:4100001true8   
37Prospectsjjwg_maps_address_cjjwg_maps_address_cLBL_JJWG_MAPS_ADDRESSAddressAddressProspectsvarchar2550 2018-05-17 16:05:4100001true    
38Prospectsjjwg_maps_geocode_status_cjjwg_maps_geocode_status_cLBL_JJWG_MAPS_GEOCODE_STATUSGeocode StatusGeocode StatusProspectsvarchar2550 2018-05-17 16:05:4100001true    
39Prospectsjjwg_maps_lat_cjjwg_maps_lat_cLBL_JJWG_MAPS_LAT LatitudeProspectsfloat1000.000000002018-05-17 16:05:4100001true8   
40Prospectsjjwg_maps_lng_cjjwg_maps_lng_cLBL_JJWG_MAPS_LNG LongitudeProspectsfloat1100.000000002018-05-17 16:05:4100001true8