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",