9             "comment": "Unique identifier",
    11             "module_designer": "disabled",
    12             "from_app_field": "app.id",
    23             "vname_module": "app",
    29             "module_designer": "disabled",
    30             "from_app_field": "app.deleted",
    37             "vname": "Date Created",
    38             "vname_module": "app",
    42             "module_designer": "label_only",
    43             "from_app_field": "app.date_entered",
    44             "name": "date_entered",
    50             "vname": "Last Modified",
    51             "vname_module": "app",
    55             "module_designer": "label_only",
    56             "from_app_field": "app.date_modified",
    57             "name": "date_modified",
    63             "id_name": "modified_user_id",
    64             "vname": "Modified by",
    65             "vname_module": "app",
    71             "comment": "User who last modified record",
    73             "module_designer": "label_only",
    74             "from_app_field": "app.modified_user",
    75             "name": "modified_user",
    82             "name": "modified_user_id",
    86             "for_ref": "modified_user",
    99             "id_name": "assigned_user_id",
   100             "vname": "Assigned to",
   101             "vname_list": "User",
   102             "vname_module": "app",
   107             "comment": "User ID assigned to record",
   108             "duplicate_merge": false,
   111             "module_designer": "label_only",
   112             "from_app_field": "app.assigned_user",
   113             "name": "assigned_user",
   119         "assigned_user_id": {
   120             "name": "assigned_user_id",
   124             "for_ref": "assigned_user",
   137             "id_name": "created_by",
   138             "vname": "Created by",
   139             "vname_module": "app",
   143             "comment": "User ID who created the record",
   145             "module_designer": "label_only",
   146             "from_app_field": "app.created_by_user",
   147             "name": "created_by_user",
   154             "name": "created_by",
   158             "for_ref": "created_by_user",
   173                 "type": "person_name",
   181             "unified_search": true,
   188             "vname": "Primary Account",
   189             "vname_list": "Account Name",
   191             "bean_name": "Account",
   195             "name": "primary_account",
   200             "id_name": "primary_account_id"
   202         "primary_account_id": {
   203             "name": "primary_account_id",
   207             "for_ref": "primary_account",
   219             "vname": "B2C Account",
   221             "bean_name": "Account",
   222             "id_name": "primary_contact_for",
   226             "name": "b2c_account",
   232         "primary_contact_for": {
   233             "name": "primary_contact_for",
   237             "for_ref": "b2c_account",
   249             "vname_list": "Category",
   257                     "label": "Company Staff",
   258                     "value": "Company Staff"
   261                     "label": "Customers",
   265                     "label": "Friends & Family",
   266                     "value": "Friends and Family"
   273                     "label": "Personal Services",
   274                     "value": "Personal Services"
   277                     "label": "Press & Analysts",
   278                     "value": "Press and Analysts"
   281                     "label": "Professional Advisors",
   282                     "value": "Professional Advisors"
   285                     "label": "Restaurants",
   286                     "value": "Restaurants"
   289                     "label": "Suppliers",
   294             "multi_select_group": "category",
   295             "multi_select_count": 10,
   297             "name": "categories",
   313                     "label": "Company Staff",
   314                     "value": "Company Staff"
   317                     "label": "Customers",
   321                     "label": "Friends & Family",
   322                     "value": "Friends and Family"
   329                     "label": "Personal Services",
   330                     "value": "Personal Services"
   333                     "label": "Press & Analysts",
   334                     "value": "Press and Analysts"
   337                     "label": "Professional Advisors",
   338                     "value": "Professional Advisors"
   341                     "label": "Restaurants",
   342                     "value": "Restaurants"
   345                     "label": "Suppliers",
   351             "multi_select_group": "category",
   369                     "label": "Company Staff",
   370                     "value": "Company Staff"
   373                     "label": "Customers",
   377                     "label": "Friends & Family",
   378                     "value": "Friends and Family"
   385                     "label": "Personal Services",
   386                     "value": "Personal Services"
   389                     "label": "Press & Analysts",
   390                     "value": "Press and Analysts"
   393                     "label": "Professional Advisors",
   394                     "value": "Professional Advisors"
   397                     "label": "Restaurants",
   398                     "value": "Restaurants"
   401                     "label": "Suppliers",
   407             "multi_select_group": "category",
   425                     "label": "Company Staff",
   426                     "value": "Company Staff"
   429                     "label": "Customers",
   433                     "label": "Friends & Family",
   434                     "value": "Friends and Family"
   441                     "label": "Personal Services",
   442                     "value": "Personal Services"
   445                     "label": "Press & Analysts",
   446                     "value": "Press and Analysts"
   449                     "label": "Professional Advisors",
   450                     "value": "Professional Advisors"
   453                     "label": "Restaurants",
   454                     "value": "Restaurants"
   457                     "label": "Suppliers",
   463             "multi_select_group": "category",
   481                     "label": "Company Staff",
   482                     "value": "Company Staff"
   485                     "label": "Customers",
   489                     "label": "Friends & Family",
   490                     "value": "Friends and Family"
   497                     "label": "Personal Services",
   498                     "value": "Personal Services"
   501                     "label": "Press & Analysts",
   502                     "value": "Press and Analysts"
   505                     "label": "Professional Advisors",
   506                     "value": "Professional Advisors"
   509                     "label": "Restaurants",
   510                     "value": "Restaurants"
   513                     "label": "Suppliers",
   519             "multi_select_group": "category",
   537                     "label": "Company Staff",
   538                     "value": "Company Staff"
   541                     "label": "Customers",
   545                     "label": "Friends & Family",
   546                     "value": "Friends and Family"
   553                     "label": "Personal Services",
   554                     "value": "Personal Services"
   557                     "label": "Press & Analysts",
   558                     "value": "Press and Analysts"
   561                     "label": "Professional Advisors",
   562                     "value": "Professional Advisors"
   565                     "label": "Restaurants",
   566                     "value": "Restaurants"
   569                     "label": "Suppliers",
   575             "multi_select_group": "category",
   593                     "label": "Company Staff",
   594                     "value": "Company Staff"
   597                     "label": "Customers",
   601                     "label": "Friends & Family",
   602                     "value": "Friends and Family"
   609                     "label": "Personal Services",
   610                     "value": "Personal Services"
   613                     "label": "Press & Analysts",
   614                     "value": "Press and Analysts"
   617                     "label": "Professional Advisors",
   618                     "value": "Professional Advisors"
   621                     "label": "Restaurants",
   622                     "value": "Restaurants"
   625                     "label": "Suppliers",
   631             "multi_select_group": "category",
   649                     "label": "Company Staff",
   650                     "value": "Company Staff"
   653                     "label": "Customers",
   657                     "label": "Friends & Family",
   658                     "value": "Friends and Family"
   665                     "label": "Personal Services",
   666                     "value": "Personal Services"
   669                     "label": "Press & Analysts",
   670                     "value": "Press and Analysts"
   673                     "label": "Professional Advisors",
   674                     "value": "Professional Advisors"
   677                     "label": "Restaurants",
   678                     "value": "Restaurants"
   681                     "label": "Suppliers",
   687             "multi_select_group": "category",
   705                     "label": "Company Staff",
   706                     "value": "Company Staff"
   709                     "label": "Customers",
   713                     "label": "Friends & Family",
   714                     "value": "Friends and Family"
   721                     "label": "Personal Services",
   722                     "value": "Personal Services"
   725                     "label": "Press & Analysts",
   726                     "value": "Press and Analysts"
   729                     "label": "Professional Advisors",
   730                     "value": "Professional Advisors"
   733                     "label": "Restaurants",
   734                     "value": "Restaurants"
   737                     "label": "Suppliers",
   743             "multi_select_group": "category",
   761                     "label": "Company Staff",
   762                     "value": "Company Staff"
   765                     "label": "Customers",
   769                     "label": "Friends & Family",
   770                     "value": "Friends and Family"
   777                     "label": "Personal Services",
   778                     "value": "Personal Services"
   781                     "label": "Press & Analysts",
   782                     "value": "Press and Analysts"
   785                     "label": "Professional Advisors",
   786                     "value": "Professional Advisors"
   789                     "label": "Restaurants",
   790                     "value": "Restaurants"
   793                     "label": "Suppliers",
   799             "multi_select_group": "category",
   809             "name": "category10",
   817                     "label": "Company Staff",
   818                     "value": "Company Staff"
   821                     "label": "Customers",
   825                     "label": "Friends & Family",
   826                     "value": "Friends and Family"
   833                     "label": "Personal Services",
   834                     "value": "Personal Services"
   837                     "label": "Press & Analysts",
   838                     "value": "Press and Analysts"
   841                     "label": "Professional Advisors",
   842                     "value": "Professional Advisors"
   845                     "label": "Restaurants",
   846                     "value": "Restaurants"
   849                     "label": "Suppliers",
   855             "multi_select_group": "category",
   865             "vname": "Business Role",
   892             "name": "business_role",
   899         "last_activity_date": {
   900             "vname": "Last Activity Date",
   903             "name": "last_activity_date",
   909             "vname": "Salutation",
   935             "comment": "Contact salutation (e.g., Mr, Ms)",
   936             "name": "salutation",
   944             "vname": "First Name",
   947             "comment": "First name of the contact",
   948             "name": "first_name",
   954             "vname": "Last Name",
   957             "comment": "Last name of the contact",
   967             "vname": "Lead Source",
   971                     "label": "Cold Call",
   975                     "label": "Existing Customer",
   976                     "value": "Existing Customer"
   979                     "label": "Self Generated",
   980                     "value": "Self Generated"
   991                     "label": "Public Relations",
   992                     "value": "Public Relations"
   995                     "label": "Direct Mail",
   996                     "value": "Direct Mail"
   999                     "label": "Conference",
  1000                     "value": "Conference"
  1003                     "label": "Trade Show",
  1004                     "value": "Trade Show"
  1007                     "label": "Web Site",
  1011                     "label": "Customer Portal",
  1012                     "value": "Customer Portal"
  1015                     "label": "Word of mouth",
  1016                     "value": "Word of mouth"
  1028             "comment": "How did the contact come about",
  1030             "name": "lead_source",
  1031             "dbType": "varchar",
  1041             "comment": "The title of the contact",
  1042             "vname_list": "Title",
  1044             "list_subtitle": true,
  1051             "vname": "Department",
  1054             "comment": "The department of the contact",
  1056             "name": "department",
  1062             "vname": "Reports To",
  1064             "comment": "The contact this contact reports to",
  1065             "bean_name": "Contact",
  1067             "name": "reports_to",
  1068             "detail_link": true,
  1072             "id_name": "reports_to_id"
  1075             "name": "reports_to_id",
  1077             "reportable": false,
  1079             "for_ref": "reports_to",
  1090             "vname": "Birthdate",
  1091             "massupdate": false,
  1093             "comment": "The birthdate of the contact",
  1094             "name": "birthdate",
  1100             "vname": "Do Not Call",
  1102             "dbType": "varchar",
  1106             "comment": "An indicator of whether contact can be called",
  1108             "name": "do_not_call",
  1114             "vname": "Accounting Contact",
  1116             "dbType": "varchar",
  1120             "comment": "An indicator of whether we should email the account invoice\nto this client",
  1122             "name": "email_accounts",
  1128             "vname": "Home Phone",
  1130             "unified_search": true,
  1131             "comment": "Home phone number of the contact",
  1132             "name": "phone_home",
  1135             "dbType": "varchar",
  1140         "phone_home__raw": {
  1141             "name": "phone_home__raw",
  1143             "reportable": false,
  1152             "vname": "Mobile Phone",
  1154             "unified_search": true,
  1155             "comment": "Mobile phone number of the contact",
  1156             "name": "phone_mobile",
  1159             "dbType": "varchar",
  1164         "phone_mobile__raw": {
  1165             "name": "phone_mobile__raw",
  1167             "reportable": false,
  1176             "vname": "Office Phone",
  1179             "unified_search": true,
  1180             "comment": "Work phone number of the contact",
  1181             "name": "phone_work",
  1184             "dbType": "varchar",
  1189         "phone_work__raw": {
  1190             "name": "phone_work__raw",
  1192             "reportable": false,
  1201             "vname": "Other Phone",
  1203             "unified_search": true,
  1204             "comment": "Other phone number for the contact",
  1205             "name": "phone_other",
  1208             "dbType": "varchar",
  1213         "phone_other__raw": {
  1214             "name": "phone_other__raw",
  1216             "reportable": false,
  1225             "vname": "Fax Number",
  1227             "unified_search": true,
  1228             "comment": "Contact fax number",
  1229             "name": "phone_fax",
  1232             "dbType": "varchar",
  1238             "name": "phone_fax__raw",
  1240             "reportable": false,
  1249             "vname": "Skype ID",
  1251             "unified_search": true,
  1252             "comment": "Contact Skype ID",
  1263             "unified_search": true,
  1264             "comment": "Primary email address of the contact",
  1265             "vname_list": "Email",
  1268             "dbType": "varchar",
  1275             "vname": "Other Email",
  1277             "unified_search": true,
  1278             "comment": "Secondary email address of the contact",
  1279             "vname_list": "Email",
  1282             "dbType": "varchar",
  1289             "vname": "Assistant",
  1292             "unified_search": true,
  1293             "comment": "Name of the assistant of the contact",
  1294             "name": "assistant",
  1299         "assistant_phone": {
  1300             "vname": "Assistant Phone",
  1302             "unified_search": true,
  1303             "comment": "Phone number of the assistant of the contact",
  1304             "name": "assistant_phone",
  1307             "dbType": "varchar",
  1312         "assistant_phone__raw": {
  1313             "name": "assistant_phone__raw",
  1315             "reportable": false,
  1324             "vname": "Email Opt Out",
  1326             "dbType": "varchar",
  1329             "comment": "Indicator whether the contact has elected to opt out of\nemails",
  1331             "name": "email_opt_out",
  1337             "vname": "Email Opt In",
  1340             "massupdate": false,
  1341             "name": "email_opt_in",
  1346         "email_opt_in_date": {
  1349             "vname": "Email Opt-In Date",
  1350             "name": "email_opt_in_date",
  1360             "dbType": "varchar",
  1366         "primary_address_street": {
  1367             "vname": "Primary Address Street",
  1370             "comment": "Street address for primary address",
  1371             "name": "primary_address_street",
  1376         "primary_address_city": {
  1377             "vname": "Primary Address City",
  1378             "vname_list": "City",
  1381             "comment": "City for primary address",
  1382             "name": "primary_address_city",
  1387         "primary_address_state": {
  1388             "vname": "Primary Address State",
  1389             "vname_list": "State",
  1392             "comment": "State for primary address",
  1393             "name": "primary_address_state",
  1398         "primary_address_postalcode": {
  1399             "vname": "Primary Address Postal Code",
  1402             "comment": "Postal code for primary address",
  1403             "name": "primary_address_postalcode",
  1408         "primary_address_country": {
  1409             "vname": "Primary Address Country",
  1412             "comment": "Country for primary address",
  1413             "name": "primary_address_country",
  1418         "primary_address_statecode": {
  1419             "vname": "Primary Address State Code",
  1422             "name": "primary_address_statecode",
  1427         "primary_address_countrycode": {
  1428             "vname": "Primary Address Country Code",
  1431             "name": "primary_address_countrycode",
  1436         "alt_address_street": {
  1437             "vname": "Alternate Address Street",
  1440             "comment": "Street address for alternate address",
  1441             "name": "alt_address_street",
  1446         "alt_address_city": {
  1447             "vname": "Alternate Address City",
  1450             "comment": "City for alternate address",
  1451             "name": "alt_address_city",
  1456         "alt_address_state": {
  1457             "vname": "Alternate Address State",
  1460             "comment": "State for alternate address",
  1461             "name": "alt_address_state",
  1466         "alt_address_postalcode": {
  1467             "vname": "Alternate Address Postal Code",
  1470             "comment": "Postal code for alternate address",
  1471             "name": "alt_address_postalcode",
  1476         "alt_address_country": {
  1477             "vname": "Alternate Address Country",
  1480             "comment": "Country for alternate address",
  1481             "name": "alt_address_country",
  1486         "alt_address_statecode": {
  1487             "vname": "Alternate Address State Code",
  1490             "name": "alt_address_statecode",
  1495         "alt_address_countrycode": {
  1496             "vname": "Alternate Address Country Code",
  1499             "name": "alt_address_countrycode",
  1505             "vname": "Description",
  1507             "comment": "Description of contact",
  1508             "name": "description",
  1515             "vname": "Portal Name",
  1518             "comment": "Name as it appears in the portal",
  1519             "name": "portal_name",
  1525             "vname": "Portal Active",
  1529             "comment": "Indicator whether this contact is a portal user",
  1531             "name": "portal_active",
  1537             "vname": "Portal Application",
  1540             "comment": "Reference to the portal",
  1541             "name": "portal_app",
  1547             "vname": "Invalid Email",
  1549             "comment": "Indicator that contact email address is invalid",
  1550             "name": "invalid_email",
  1558             "bean_name": "Partner",
  1562             "detail_link": true,
  1566             "id_name": "partner_id"
  1569             "name": "partner_id",
  1571             "reportable": false,
  1573             "for_ref": "partner",
  1585             "comment": "Campaign that generated lead",
  1586             "vname": "Campaign",
  1588             "id_name": "campaign_id",
  1590             "table": "campaigns",
  1592             "module": "Campaigns",
  1593             "massupdate": false,
  1594             "duplicate_merge": "disabled",
  1595             "bean_name": "Campaign",
  1597             "detail_link": true,
  1603             "name": "campaign_id",
  1605             "reportable": false,
  1607             "for_ref": "campaign",
  1620             "comment": "Size of vCard",
  1621             "duplicate_merge": "disabled",
  1622             "reportable": false,
  1623             "name": "vcard_size",
  1630             "comment": "Pre-generated vCard for contact",
  1631             "duplicate_merge": "disabled",
  1632             "reportable": false,
  1642             "comment": "URI generated by external contacts app",
  1643             "reportable": false,
  1644             "duplicate_merge": "disabled",
  1645             "name": "vcard_uri",
  1653             "placeholder": "themes\/Default\/images\/no_user.png",
  1654             "alt_image": "primary_account.photo",
  1668             "thumbnail": "auto",
  1670             "upload_dir": "{FILES}\/images\/photos\/",
  1671             "filename": "photo_filename",
  1672             "thumbnail_name": "photo_thumb"
  1675             "vname": "Photo Filename",
  1677             "name": "photo_filename",
  1679             "reportable": false,
  1685             "vname": "Thumbnail Filename",
  1687             "name": "photo_thumb",
  1689             "reportable": false,
  1696             "vname": "Chat Activity",
  1697             "vname_module": "Chats",
  1699             "name": "chat_activity",
  1706             "vname": "Lead Guerrilla Contact ID",
  1707             "vname_module": "LeadGuerrilla",
  1708             "comment": "ID of related contact in Mautic\/Lead Guerrilla",
  1709             "name": "mautic_id",
  1714         "livechat_activity": {
  1716             "vname": "Live Chat Activity",
  1717             "vname_module": "LiveChatInc",
  1719             "name": "livechat_activity",
  1727             "name": "filter_text",
  1728             "vname": "Search Text",
  1729             "type": "unified_search",
  1731             "fulltext_search": false,
  1732             "search_what": "all",
  1733             "report_filter": true,
  1739             "default_value": "all",
  1742                     "vname": "LBL_FILTER_OWNER_ANY",
  1743                     "icon": "icon-users"
  1746                     "field": "assigned_user_id",
  1748                     "vname": "LBL_FILTER_OWNER_MINE",
  1750                     "icon": "icon-adminuser"
  1753                     "field": "assigned_user_id",
  1755                     "vname": "LBL_FILTER_OWNER_NOT_MINE",
  1758                     "icon": "icon-users"
  1761                     "field": "assigned_user_id",
  1763                     "vname": "LBL_FILTER_OWNER_SELECT",
  1764                     "icon": "icon-popup"
  1767             "options_icon": "icon",
  1768             "options_blank_key": "all",
  1769             "input_class": "OwnerSelect",
  1770             "report_filter": true,
  1774         "filter_favorites": {
  1775             "name": "filter_favorites",
  1776             "vname": "Only Favorites",
  1778             "class": "check-star",
  1780             "field": "favorites.deleted",
  1781             "default_value": false,
  1785         "primary_account": {
  1786             "vname": "Primary Account",
  1787             "vname_list": "Account Name",
  1789             "bean_name": "Account",
  1790             "importable": false,
  1791             "massupdate": false,
  1793             "name": "primary_account",
  1794             "id_name": "primary_account_id",
  1795             "vname_module": "Contacts",
  1796             "field": "primary_account",
  1799             "allow_custom": true,
  1803             "vname": "First Name",
  1806             "comment": "First name of the contact",
  1807             "name": "first_name",
  1808             "vname_module": "Contacts",
  1809             "field": "first_name",
  1814             "vname": "Last Name",
  1817             "comment": "Last name of the contact",
  1818             "name": "last_name",
  1819             "dbType": "varchar",
  1820             "vname_module": "Contacts",
  1821             "field": "last_name",
  1826             "vname": "Category",
  1827             "vname_list": "Category",
  1828             "type": "multienum",
  1830                 "Business": "Business",
  1831                 "Company Staff": "Company Staff",
  1832                 "Customers": "Customers",
  1833                 "Friends and Family": "Friends & Family",
  1834                 "Partners": "Partners",
  1835                 "Personal Services": "Personal Services",
  1836                 "Press and Analysts": "Press & Analysts",
  1837                 "Professional Advisors": "Professional Advisors",
  1838                 "Restaurants": "Restaurants",
  1839                 "Suppliers": "Suppliers"
  1842             "multi_select_group": "category",
  1843             "multi_select_count": 10,
  1845             "name": "categories",
  1846             "dbType": "varchar",
  1848             "vname_module": "Contacts",
  1849             "field": "categories",
  1854             "vname": "Lead Source",
  1857                 "Cold Call": "Cold Call",
  1858                 "Existing Customer": "Existing Customer",
  1859                 "Self Generated": "Self Generated",
  1860                 "Employee": "Employee",
  1861                 "Partner": "Partner",
  1862                 "Public Relations": "Public Relations",
  1863                 "Direct Mail": "Direct Mail",
  1864                 "Conference": "Conference",
  1865                 "Trade Show": "Trade Show",
  1866                 "Web Site": "Web Site",
  1867                 "Customer Portal": "Customer Portal",
  1868                 "Word of mouth": "Word of mouth",
  1873             "comment": "How did the contact come about",
  1875             "name": "lead_source",
  1876             "dbType": "varchar",
  1878             "vname_module": "Contacts",
  1879             "field": "lead_source",
  1884             "vname": "Do Not Call",
  1886             "dbType": "varchar",
  1889             "comment": "An indicator of whether contact can be called",
  1891             "name": "do_not_call",
  1892             "vname_module": "Contacts",
  1893             "field": "do_not_call",
  1898             "vname": "Any Phone",
  1910             "vname": "Any Email",
  1918             "vname": "Assistant",
  1921             "unified_search": true,
  1922             "comment": "Name of the assistant of the contact",
  1923             "name": "assistant",
  1924             "vname_module": "Contacts",
  1925             "field": "assistant",
  1930             "vname": "Email Opt Out",
  1932             "dbType": "varchar",
  1934             "comment": "Indicator whether the contact has elected to opt out of\nemails",
  1936             "name": "email_opt_out",
  1937             "vname_module": "Contacts",
  1938             "field": "email_opt_out",
  1943             "vname": "Any Address",
  1946                 "primary_address_street",
  1947                 "alt_address_street"
  1951             "vname": "Any City",
  1954                 "primary_address_city",
  1959             "vname": "Any State",
  1962                 "primary_address_state",
  1966         "address_postalcode": {
  1967             "vname": "Any Postal Code",
  1970                 "primary_address_postalcode",
  1971                 "alt_address_postalcode"
  1974         "address_country": {
  1975             "vname": "Any Country",
  1978                 "primary_address_country",
  1979                 "alt_address_country"
  1986             "comment": "The title of the contact",
  1987             "vname_list": "Title",
  1989             "list_subtitle": true,
  1991             "vname_module": "Contacts",
  1997             "vname": "Business Role",
  2009             "name": "business_role",
  2010             "dbType": "varchar",
  2012             "vname_module": "Contacts",
  2013             "field": "business_role",