MySQL fields_meta_data Definitions:
name | type | len
--- | --- | ---
id | varchar | 255
name | varchar | 255
vname | varchar | 255
comments | varchar | 255
help | varchar | 255
custom_module | varchar | 255
type | varchar | 255
len | int | 11
required | tinyint
default_value | varchar | 255
date_modified | datetime
deleted | tinyint
audited | tinyint
massupdate | tinyint
duplicate_merge | smallint
reportable | tinyint | 1
importable | varchar | 255
ext1 | varchar | 255
ext2 | varchar | 255
ext3 | varchar | 255
ext4 | text

MySQL fields_meta_data Keys:
name | type | fields
--- | --- | ---
primary | primary | id
idx_meta_id_del | index | id,deleted
idx_meta_cm_del | index | custom_module,deleted

# | id | name | vname | comments | help | custom_module | type | len | required | default_value | date_modified | deleted | audited | massupdate | duplicate_merge | reportable | importable | ext1 | ext2 | ext3 | ext4
--- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | ---
1 | Accountsjjwg_maps_address_c | jjwg_maps_address_c | LBL_JJWG_MAPS_ADDRESS | Address | Address | Accounts | varchar | 255 | 0 |  | 2021-07-06 20:47:57 | 0 | 0 | 0 | 0 | 1 | true |  |  |  |
2 | Accountsjjwg_maps_geocode_status_c | jjwg_maps_geocode_status_c | LBL_JJWG_MAPS_GEOCODE_STATUS | Geocode Status | Geocode Status | Accounts | varchar | 255 | 0 |  | 2021-07-06 20:47:57 | 0 | 0 | 0 | 0 | 1 | true |  |  |  |
3 | Accountsjjwg_maps_lat_c | jjwg_maps_lat_c | LBL_JJWG_MAPS_LAT |  | Latitude | Accounts | float | 10 | 0 | 0.00000000 | 2021-07-06 20:47:57 | 0 | 0 | 0 | 0 | 1 | true | 8 |  |  |
4 | Accountsjjwg_maps_lng_c | jjwg_maps_lng_c | LBL_JJWG_MAPS_LNG |  | Longitude | Accounts | float | 11 | 0 | 0.00000000 | 2021-07-06 20:47:57 | 0 | 0 | 0 | 0 | 1 | true | 8 |  |  |
5 | AOS_Invoicesbalanced_c | balanced_c | LBL_BALANCED |  | Abono | AOS_Invoices | currency | 26 | 0 |  | 2021-07-14 01:09:36 | 0 | 1 | 0 | 0 | 1 | true |  |  |  |
6 | Casesjjwg_maps_address_c | jjwg_maps_address_c | LBL_JJWG_MAPS_ADDRESS | Address | Address | Cases | varchar | 255 | 0 |  | 2021-07-06 20:47:57 | 0 | 0 | 0 | 0 | 1 | true |  |  |  |
7 | Casesjjwg_maps_geocode_status_c | jjwg_maps_geocode_status_c | LBL_JJWG_MAPS_GEOCODE_STATUS | Geocode Status | Geocode Status | Cases | varchar | 255 | 0 |  | 2021-07-06 20:47:57 | 0 | 0 | 0 | 0 | 1 | true |  |  |  |
8 | Casesjjwg_maps_lat_c | jjwg_maps_lat_c | LBL_JJWG_MAPS_LAT |  | Latitude | Cases | float | 10 | 0 | 0.00000000 | 2021-07-06 20:47:57 | 0 | 0 | 0 | 0 | 1 | true | 8 |  |  |
9 | Casesjjwg_maps_lng_c | jjwg_maps_lng_c | LBL_JJWG_MAPS_LNG |  | Longitude | Cases | float | 11 | 0 | 0.00000000 | 2021-07-06 20:47:57 | 0 | 0 | 0 | 0 | 1 | true | 8 |  |  |
10 | Contactsjjwg_maps_address_c | jjwg_maps_address_c | LBL_JJWG_MAPS_ADDRESS | Address | Address | Contacts | varchar | 255 | 0 |  | 2021-07-06 20:47:57 | 0 | 0 | 0 | 0 | 1 | true |  |  |  |
11 | Contactsjjwg_maps_geocode_status_c | jjwg_maps_geocode_status_c | LBL_JJWG_MAPS_GEOCODE_STATUS | Geocode Status | Geocode Status | Contacts | varchar | 255 | 0 |  | 2021-07-06 20:47:57 | 0 | 0 | 0 | 0 | 1 | true |  |  |  |
12 | Contactsjjwg_maps_lat_c | jjwg_maps_lat_c | LBL_JJWG_MAPS_LAT |  | Latitude | Contacts | float | 10 | 0 | 0.00000000 | 2021-07-06 20:47:57 | 0 | 0 | 0 | 0 | 1 | true | 8 |  |  |
13 | Contactsjjwg_maps_lng_c | jjwg_maps_lng_c | LBL_JJWG_MAPS_LNG |  | Longitude | Contacts | float | 11 | 0 | 0.00000000 | 2021-07-06 20:47:57 | 0 | 0 | 0 | 0 | 1 | true | 8 |  |  |
14 | Leadsjjwg_maps_address_c | jjwg_maps_address_c | LBL_JJWG_MAPS_ADDRESS | Address | Address | Leads | varchar | 255 | 0 |  | 2021-07-06 20:47:57 | 0 | 0 | 0 | 0 | 1 | true |  |  |  |
15 | Leadsjjwg_maps_geocode_status_c | jjwg_maps_geocode_status_c | LBL_JJWG_MAPS_GEOCODE_STATUS | Geocode Status | Geocode Status | Leads | varchar | 255 | 0 |  | 2021-07-06 20:47:57 | 0 | 0 | 0 | 0 | 1 | true |  |  |  |
16 | Leadsjjwg_maps_lat_c | jjwg_maps_lat_c | LBL_JJWG_MAPS_LAT |  | Latitude | Leads | float | 10 | 0 | 0.00000000 | 2021-07-06 20:47:57 | 0 | 0 | 0 | 0 | 1 | true | 8 |  |  |
17 | Leadsjjwg_maps_lng_c | jjwg_maps_lng_c | LBL_JJWG_MAPS_LNG |  | Longitude | Leads | float | 11 | 0 | 0.00000000 | 2021-07-06 20:47:57 | 0 | 0 | 0 | 0 | 1 | true | 8 |  |  |
18 | Meetingsjjwg_maps_address_c | jjwg_maps_address_c | LBL_JJWG_MAPS_ADDRESS | Address | Address | Meetings | varchar | 255 | 0 |  | 2021-07-06 20:47:57 | 0 | 0 | 0 | 0 | 1 | true |  |  |  |
19 | Meetingsjjwg_maps_geocode_status_c | jjwg_maps_geocode_status_c | LBL_JJWG_MAPS_GEOCODE_STATUS | Geocode Status | Geocode Status | Meetings | varchar | 255 | 0 |  | 2021-07-06 20:47:57 | 0 | 0 | 0 | 0 | 1 | true |  |  |  |
20 | Meetingsjjwg_maps_lat_c | jjwg_maps_lat_c | LBL_JJWG_MAPS_LAT |  | Latitude | Meetings | float | 10 | 0 | 0.00000000 | 2021-07-06 20:47:57 | 0 | 0 | 0 | 0 | 1 | true | 8 |  |  |
21 | Meetingsjjwg_maps_lng_c | jjwg_maps_lng_c | LBL_JJWG_MAPS_LNG |  | Longitude | Meetings | float | 11 | 0 | 0.00000000 | 2021-07-06 20:47:57 | 0 | 0 | 0 | 0 | 1 | true | 8 |  |  |
22 | Opportunitiesjjwg_maps_address_c | jjwg_maps_address_c | LBL_JJWG_MAPS_ADDRESS | Address | Address | Opportunities | varchar | 255 | 0 |  | 2021-07-06 20:47:57 | 0 | 0 | 0 | 0 | 1 | true |  |  |  |
23 | Opportunitiesjjwg_maps_geocode_status_c | jjwg_maps_geocode_status_c | LBL_JJWG_MAPS_GEOCODE_STATUS | Geocode Status | Geocode Status | Opportunities | varchar | 255 | 0 |  | 2021-07-06 20:47:57 | 0 | 0 | 0 | 0 | 1 | true |  |  |  |
24 | Opportunitiesjjwg_maps_lat_c | jjwg_maps_lat_c | LBL_JJWG_MAPS_LAT |  | Latitude | Opportunities | float | 10 | 0 | 0.00000000 | 2021-07-06 20:47:57 | 0 | 0 | 0 | 0 | 1 | true | 8 |  |  |
25 | Opportunitiesjjwg_maps_lng_c | jjwg_maps_lng_c | LBL_JJWG_MAPS_LNG |  | Longitude | Opportunities | float | 11 | 0 | 0.00000000 | 2021-07-06 20:47:57 | 0 | 0 | 0 | 0 | 1 | true | 8 |  |  |
26 | Projectjjwg_maps_address_c | jjwg_maps_address_c | LBL_JJWG_MAPS_ADDRESS | Address | Address | Project | varchar | 255 | 0 |  | 2021-07-06 20:47:57 | 0 | 0 | 0 | 0 | 1 | true |  |  |  |
27 | Projectjjwg_maps_geocode_status_c | jjwg_maps_geocode_status_c | LBL_JJWG_MAPS_GEOCODE_STATUS | Geocode Status | Geocode Status | Project | varchar | 255 | 0 |  | 2021-07-06 20:47:57 | 0 | 0 | 0 | 0 | 1 | true |  |  |  |
28 | Projectjjwg_maps_lat_c | jjwg_maps_lat_c | LBL_JJWG_MAPS_LAT |  | Latitude | Project | float | 10 | 0 | 0.00000000 | 2021-07-06 20:47:57 | 0 | 0 | 0 | 0 | 1 | true | 8 |  |  |
29 | Projectjjwg_maps_lng_c | jjwg_maps_lng_c | LBL_JJWG_MAPS_LNG |  | Longitude | Project | float | 11 | 0 | 0.00000000 | 2021-07-06 20:47:57 | 0 | 0 | 0 | 0 | 1 | true | 8 |  |  |
30 | Prospectsjjwg_maps_address_c | jjwg_maps_address_c | LBL_JJWG_MAPS_ADDRESS | Address | Address | Prospects | varchar | 255 | 0 |  | 2021-07-06 20:47:57 | 0 | 0 | 0 | 0 | 1 | true |  |  |  |
31 | Prospectsjjwg_maps_geocode_status_c | jjwg_maps_geocode_status_c | LBL_JJWG_MAPS_GEOCODE_STATUS | Geocode Status | Geocode Status | Prospects | varchar | 255 | 0 |  | 2021-07-06 20:47:57 | 0 | 0 | 0 | 0 | 1 | true |  |  |  |
32 | Prospectsjjwg_maps_lat_c | jjwg_maps_lat_c | LBL_JJWG_MAPS_LAT |  | Latitude | Prospects | float | 10 | 0 | 0.00000000 | 2021-07-06 20:47:57 | 0 | 0 | 0 | 0 | 1 | true | 8 |  |  |
33 | Prospectsjjwg_maps_lng_c | jjwg_maps_lng_c | LBL_JJWG_MAPS_LNG |  | Longitude | Prospects | float | 11 | 0 | 0.00000000 | 2021-07-06 20:47:57 | 0 | 0 | 0 | 0 | 1 | true | 8 |  |  |