API Client
Obtaining model metadata

Using the Model::metadata() method, you can obtain model metadata, containing information about model fields and filters

$model = $client->model('Contact');
$result = $model->metadata();
echo json_encode($result, JSON_PRETTY_PRINT);
1 {
2  "fields": {
3  "id": {
4  "vname": "ID",
5  "vname_module": "app",
6  "required": true,
7  "reportable": false,
8  "type": "id",
9  "comment": "Unique identifier",
10  "editable": false,
11  "module_designer": "disabled",
12  "from_app_field": "app.id",
13  "name": "id",
14  "dbType": "char",
15  "charset": "ascii",
16  "len": 36,
17  "source": {
18  "type": "db"
19  }
20  },
21  "deleted": {
22  "vname": "Deleted",
23  "vname_module": "app",
24  "type": "bool",
25  "required": true,
26  "default": 0,
27  "editable": false,
28  "reportable": false,
29  "module_designer": "disabled",
30  "from_app_field": "app.deleted",
31  "name": "deleted",
32  "source": {
33  "type": "db"
34  }
35  },
36  "date_entered": {
37  "vname": "Date Created",
38  "vname_module": "app",
39  "type": "datetime",
40  "required": true,
41  "editable": false,
42  "module_designer": "label_only",
43  "from_app_field": "app.date_entered",
44  "name": "date_entered",
45  "source": {
46  "type": "db"
47  }
48  },
49  "date_modified": {
50  "vname": "Last Modified",
51  "vname_module": "app",
52  "type": "datetime",
53  "required": true,
54  "editable": false,
55  "module_designer": "label_only",
56  "from_app_field": "app.date_modified",
57  "name": "date_modified",
58  "source": {
59  "type": "db"
60  }
61  },
62  "modified_user": {
63  "id_name": "modified_user_id",
64  "vname": "Modified by",
65  "vname_module": "app",
66  "type": "ref",
67  "bean_name": "User",
68  "isnull": false,
69  "reportable": true,
70  "required": true,
71  "comment": "User who last modified record",
72  "editable": false,
73  "module_designer": "label_only",
74  "from_app_field": "app.modified_user",
75  "name": "modified_user",
76  "detail_link": true,
77  "source": {
78  "type": "non-db"
79  }
80  },
81  "modified_user_id": {
82  "name": "modified_user_id",
83  "type": "id",
84  "reportable": false,
85  "inferred": true,
86  "for_ref": "modified_user",
87  "required": true,
88  "vname": "ID",
89  "isnull": false,
90  "dbType": "char",
91  "charset": "ascii",
92  "len": 36,
93  "editable": false,
94  "source": {
95  "type": "db"
96  }
97  },
98  "assigned_user": {
99  "id_name": "assigned_user_id",
100  "vname": "Assigned to",
101  "vname_list": "User",
102  "vname_module": "app",
103  "type": "ref",
104  "bean_name": "User",
105  "reportable": true,
106  "audited": true,
107  "comment": "User ID assigned to record",
108  "duplicate_merge": false,
109  "massupdate": true,
110  "required": true,
111  "module_designer": "label_only",
112  "from_app_field": "app.assigned_user",
113  "name": "assigned_user",
114  "detail_link": true,
115  "source": {
116  "type": "non-db"
117  }
118  },
119  "assigned_user_id": {
120  "name": "assigned_user_id",
121  "type": "id",
122  "reportable": false,
123  "inferred": true,
124  "for_ref": "assigned_user",
125  "required": true,
126  "audited": true,
127  "vname": "ID",
128  "dbType": "char",
129  "charset": "ascii",
130  "len": 36,
131  "editable": false,
132  "source": {
133  "type": "db"
134  }
135  },
136  "created_by_user": {
137  "id_name": "created_by",
138  "vname": "Created by",
139  "vname_module": "app",
140  "type": "ref",
141  "bean_name": "User",
142  "isnull": false,
143  "comment": "User ID who created the record",
144  "editable": false,
145  "module_designer": "label_only",
146  "from_app_field": "app.created_by_user",
147  "name": "created_by_user",
148  "detail_link": true,
149  "source": {
150  "type": "non-db"
151  }
152  },
153  "created_by": {
154  "name": "created_by",
155  "type": "id",
156  "reportable": false,
157  "inferred": true,
158  "for_ref": "created_by_user",
159  "vname": "ID",
160  "isnull": false,
161  "dbType": "char",
162  "charset": "ascii",
163  "len": 36,
164  "editable": false,
165  "source": {
166  "type": "db"
167  }
168  },
169  "name": {
170  "vname": "Name",
171  "type": "name",
172  "source": {
173  "type": "person_name",
174  "fields": [
175  "first_name",
176  "last_name",
177  "salutation"
178  ]
179  },
180  "importable": false,
181  "unified_search": true,
182  "name": "name",
183  "dbType": "varchar",
184  "len": 150,
185  "detail_link": true
186  },
187  "primary_account": {
188  "vname": "Primary Account",
189  "vname_list": "Account Name",
190  "type": "ref",
191  "bean_name": "Account",
192  "importable": false,
193  "massupdate": false,
194  "audited": true,
195  "name": "primary_account",
196  "detail_link": true,
197  "source": {
198  "type": "non-db"
199  },
200  "id_name": "primary_account_id"
201  },
202  "primary_account_id": {
203  "name": "primary_account_id",
204  "type": "id",
205  "reportable": false,
206  "inferred": true,
207  "for_ref": "primary_account",
208  "audited": true,
209  "vname": "ID",
210  "dbType": "char",
211  "charset": "ascii",
212  "len": 36,
213  "editable": false,
214  "source": {
215  "type": "db"
216  }
217  },
218  "b2c_account": {
219  "vname": "B2C Account",
220  "type": "ref",
221  "bean_name": "Account",
222  "id_name": "primary_contact_for",
223  "importable": false,
224  "massupdate": false,
225  "reportable": false,
226  "name": "b2c_account",
227  "detail_link": true,
228  "source": {
229  "type": "non-db"
230  }
231  },
232  "primary_contact_for": {
233  "name": "primary_contact_for",
234  "type": "id",
235  "reportable": false,
236  "inferred": true,
237  "for_ref": "b2c_account",
238  "vname": "ID",
239  "dbType": "char",
240  "charset": "ascii",
241  "len": 36,
242  "editable": false,
243  "source": {
244  "type": "db"
245  }
246  },
247  "categories": {
248  "vname": "Category",
249  "vname_list": "Category",
250  "type": "multienum",
251  "options": [
252  {
253  "label": "Business",
254  "value": "Business"
255  },
256  {
257  "label": "Company Staff",
258  "value": "Company Staff"
259  },
260  {
261  "label": "Customers",
262  "value": "Customers"
263  },
264  {
265  "label": "Friends & Family",
266  "value": "Friends and Family"
267  },
268  {
269  "label": "Partners",
270  "value": "Partners"
271  },
272  {
273  "label": "Personal Services",
274  "value": "Personal Services"
275  },
276  {
277  "label": "Press & Analysts",
278  "value": "Press and Analysts"
279  },
280  {
281  "label": "Professional Advisors",
282  "value": "Professional Advisors"
283  },
284  {
285  "label": "Restaurants",
286  "value": "Restaurants"
287  },
288  {
289  "label": "Suppliers",
290  "value": "Suppliers"
291  }
292  ],
293  "len": 40,
294  "multi_select_group": "category",
295  "multi_select_count": 10,
296  "massupdate": true,
297  "name": "categories",
298  "dbType": "varchar",
299  "charset": "ascii",
300  "source": {
301  "type": "multienum"
302  }
303  },
304  "category": {
305  "name": "category",
306  "type": "enum",
307  "options": [
308  {
309  "label": "Business",
310  "value": "Business"
311  },
312  {
313  "label": "Company Staff",
314  "value": "Company Staff"
315  },
316  {
317  "label": "Customers",
318  "value": "Customers"
319  },
320  {
321  "label": "Friends & Family",
322  "value": "Friends and Family"
323  },
324  {
325  "label": "Partners",
326  "value": "Partners"
327  },
328  {
329  "label": "Personal Services",
330  "value": "Personal Services"
331  },
332  {
333  "label": "Press & Analysts",
334  "value": "Press and Analysts"
335  },
336  {
337  "label": "Professional Advisors",
338  "value": "Professional Advisors"
339  },
340  {
341  "label": "Restaurants",
342  "value": "Restaurants"
343  },
344  {
345  "label": "Suppliers",
346  "value": "Suppliers"
347  }
348  ],
349  "reportable": false,
350  "massupdate": false,
351  "multi_select_group": "category",
352  "vname": "Category",
353  "len": 50,
354  "dbType": "varchar",
355  "charset": "ascii",
356  "source": {
357  "type": "db"
358  }
359  },
360  "category2": {
361  "name": "category2",
362  "type": "enum",
363  "options": [
364  {
365  "label": "Business",
366  "value": "Business"
367  },
368  {
369  "label": "Company Staff",
370  "value": "Company Staff"
371  },
372  {
373  "label": "Customers",
374  "value": "Customers"
375  },
376  {
377  "label": "Friends & Family",
378  "value": "Friends and Family"
379  },
380  {
381  "label": "Partners",
382  "value": "Partners"
383  },
384  {
385  "label": "Personal Services",
386  "value": "Personal Services"
387  },
388  {
389  "label": "Press & Analysts",
390  "value": "Press and Analysts"
391  },
392  {
393  "label": "Professional Advisors",
394  "value": "Professional Advisors"
395  },
396  {
397  "label": "Restaurants",
398  "value": "Restaurants"
399  },
400  {
401  "label": "Suppliers",
402  "value": "Suppliers"
403  }
404  ],
405  "reportable": false,
406  "massupdate": false,
407  "multi_select_group": "category",
408  "vname": "Category",
409  "len": 50,
410  "dbType": "varchar",
411  "charset": "ascii",
412  "source": {
413  "type": "db"
414  }
415  },
416  "category3": {
417  "name": "category3",
418  "type": "enum",
419  "options": [
420  {
421  "label": "Business",
422  "value": "Business"
423  },
424  {
425  "label": "Company Staff",
426  "value": "Company Staff"
427  },
428  {
429  "label": "Customers",
430  "value": "Customers"
431  },
432  {
433  "label": "Friends & Family",
434  "value": "Friends and Family"
435  },
436  {
437  "label": "Partners",
438  "value": "Partners"
439  },
440  {
441  "label": "Personal Services",
442  "value": "Personal Services"
443  },
444  {
445  "label": "Press & Analysts",
446  "value": "Press and Analysts"
447  },
448  {
449  "label": "Professional Advisors",
450  "value": "Professional Advisors"
451  },
452  {
453  "label": "Restaurants",
454  "value": "Restaurants"
455  },
456  {
457  "label": "Suppliers",
458  "value": "Suppliers"
459  }
460  ],
461  "reportable": false,
462  "massupdate": false,
463  "multi_select_group": "category",
464  "vname": "Category",
465  "len": 50,
466  "dbType": "varchar",
467  "charset": "ascii",
468  "source": {
469  "type": "db"
470  }
471  },
472  "category4": {
473  "name": "category4",
474  "type": "enum",
475  "options": [
476  {
477  "label": "Business",
478  "value": "Business"
479  },
480  {
481  "label": "Company Staff",
482  "value": "Company Staff"
483  },
484  {
485  "label": "Customers",
486  "value": "Customers"
487  },
488  {
489  "label": "Friends & Family",
490  "value": "Friends and Family"
491  },
492  {
493  "label": "Partners",
494  "value": "Partners"
495  },
496  {
497  "label": "Personal Services",
498  "value": "Personal Services"
499  },
500  {
501  "label": "Press & Analysts",
502  "value": "Press and Analysts"
503  },
504  {
505  "label": "Professional Advisors",
506  "value": "Professional Advisors"
507  },
508  {
509  "label": "Restaurants",
510  "value": "Restaurants"
511  },
512  {
513  "label": "Suppliers",
514  "value": "Suppliers"
515  }
516  ],
517  "reportable": false,
518  "massupdate": false,
519  "multi_select_group": "category",
520  "vname": "Category",
521  "len": 50,
522  "dbType": "varchar",
523  "charset": "ascii",
524  "source": {
525  "type": "db"
526  }
527  },
528  "category5": {
529  "name": "category5",
530  "type": "enum",
531  "options": [
532  {
533  "label": "Business",
534  "value": "Business"
535  },
536  {
537  "label": "Company Staff",
538  "value": "Company Staff"
539  },
540  {
541  "label": "Customers",
542  "value": "Customers"
543  },
544  {
545  "label": "Friends & Family",
546  "value": "Friends and Family"
547  },
548  {
549  "label": "Partners",
550  "value": "Partners"
551  },
552  {
553  "label": "Personal Services",
554  "value": "Personal Services"
555  },
556  {
557  "label": "Press & Analysts",
558  "value": "Press and Analysts"
559  },
560  {
561  "label": "Professional Advisors",
562  "value": "Professional Advisors"
563  },
564  {
565  "label": "Restaurants",
566  "value": "Restaurants"
567  },
568  {
569  "label": "Suppliers",
570  "value": "Suppliers"
571  }
572  ],
573  "reportable": false,
574  "massupdate": false,
575  "multi_select_group": "category",
576  "vname": "Category",
577  "len": 50,
578  "dbType": "varchar",
579  "charset": "ascii",
580  "source": {
581  "type": "db"
582  }
583  },
584  "category6": {
585  "name": "category6",
586  "type": "enum",
587  "options": [
588  {
589  "label": "Business",
590  "value": "Business"
591  },
592  {
593  "label": "Company Staff",
594  "value": "Company Staff"
595  },
596  {
597  "label": "Customers",
598  "value": "Customers"
599  },
600  {
601  "label": "Friends & Family",
602  "value": "Friends and Family"
603  },
604  {
605  "label": "Partners",
606  "value": "Partners"
607  },
608  {
609  "label": "Personal Services",
610  "value": "Personal Services"
611  },
612  {
613  "label": "Press & Analysts",
614  "value": "Press and Analysts"
615  },
616  {
617  "label": "Professional Advisors",
618  "value": "Professional Advisors"
619  },
620  {
621  "label": "Restaurants",
622  "value": "Restaurants"
623  },
624  {
625  "label": "Suppliers",
626  "value": "Suppliers"
627  }
628  ],
629  "reportable": false,
630  "massupdate": false,
631  "multi_select_group": "category",
632  "vname": "Category",
633  "len": 50,
634  "dbType": "varchar",
635  "charset": "ascii",
636  "source": {
637  "type": "db"
638  }
639  },
640  "category7": {
641  "name": "category7",
642  "type": "enum",
643  "options": [
644  {
645  "label": "Business",
646  "value": "Business"
647  },
648  {
649  "label": "Company Staff",
650  "value": "Company Staff"
651  },
652  {
653  "label": "Customers",
654  "value": "Customers"
655  },
656  {
657  "label": "Friends & Family",
658  "value": "Friends and Family"
659  },
660  {
661  "label": "Partners",
662  "value": "Partners"
663  },
664  {
665  "label": "Personal Services",
666  "value": "Personal Services"
667  },
668  {
669  "label": "Press & Analysts",
670  "value": "Press and Analysts"
671  },
672  {
673  "label": "Professional Advisors",
674  "value": "Professional Advisors"
675  },
676  {
677  "label": "Restaurants",
678  "value": "Restaurants"
679  },
680  {
681  "label": "Suppliers",
682  "value": "Suppliers"
683  }
684  ],
685  "reportable": false,
686  "massupdate": false,
687  "multi_select_group": "category",
688  "vname": "Category",
689  "len": 50,
690  "dbType": "varchar",
691  "charset": "ascii",
692  "source": {
693  "type": "db"
694  }
695  },
696  "category8": {
697  "name": "category8",
698  "type": "enum",
699  "options": [
700  {
701  "label": "Business",
702  "value": "Business"
703  },
704  {
705  "label": "Company Staff",
706  "value": "Company Staff"
707  },
708  {
709  "label": "Customers",
710  "value": "Customers"
711  },
712  {
713  "label": "Friends & Family",
714  "value": "Friends and Family"
715  },
716  {
717  "label": "Partners",
718  "value": "Partners"
719  },
720  {
721  "label": "Personal Services",
722  "value": "Personal Services"
723  },
724  {
725  "label": "Press & Analysts",
726  "value": "Press and Analysts"
727  },
728  {
729  "label": "Professional Advisors",
730  "value": "Professional Advisors"
731  },
732  {
733  "label": "Restaurants",
734  "value": "Restaurants"
735  },
736  {
737  "label": "Suppliers",
738  "value": "Suppliers"
739  }
740  ],
741  "reportable": false,
742  "massupdate": false,
743  "multi_select_group": "category",
744  "vname": "Category",
745  "len": 50,
746  "dbType": "varchar",
747  "charset": "ascii",
748  "source": {
749  "type": "db"
750  }
751  },
752  "category9": {
753  "name": "category9",
754  "type": "enum",
755  "options": [
756  {
757  "label": "Business",
758  "value": "Business"
759  },
760  {
761  "label": "Company Staff",
762  "value": "Company Staff"
763  },
764  {
765  "label": "Customers",
766  "value": "Customers"
767  },
768  {
769  "label": "Friends & Family",
770  "value": "Friends and Family"
771  },
772  {
773  "label": "Partners",
774  "value": "Partners"
775  },
776  {
777  "label": "Personal Services",
778  "value": "Personal Services"
779  },
780  {
781  "label": "Press & Analysts",
782  "value": "Press and Analysts"
783  },
784  {
785  "label": "Professional Advisors",
786  "value": "Professional Advisors"
787  },
788  {
789  "label": "Restaurants",
790  "value": "Restaurants"
791  },
792  {
793  "label": "Suppliers",
794  "value": "Suppliers"
795  }
796  ],
797  "reportable": false,
798  "massupdate": false,
799  "multi_select_group": "category",
800  "vname": "Category",
801  "len": 50,
802  "dbType": "varchar",
803  "charset": "ascii",
804  "source": {
805  "type": "db"
806  }
807  },
808  "category10": {
809  "name": "category10",
810  "type": "enum",
811  "options": [
812  {
813  "label": "Business",
814  "value": "Business"
815  },
816  {
817  "label": "Company Staff",
818  "value": "Company Staff"
819  },
820  {
821  "label": "Customers",
822  "value": "Customers"
823  },
824  {
825  "label": "Friends & Family",
826  "value": "Friends and Family"
827  },
828  {
829  "label": "Partners",
830  "value": "Partners"
831  },
832  {
833  "label": "Personal Services",
834  "value": "Personal Services"
835  },
836  {
837  "label": "Press & Analysts",
838  "value": "Press and Analysts"
839  },
840  {
841  "label": "Professional Advisors",
842  "value": "Professional Advisors"
843  },
844  {
845  "label": "Restaurants",
846  "value": "Restaurants"
847  },
848  {
849  "label": "Suppliers",
850  "value": "Suppliers"
851  }
852  ],
853  "reportable": false,
854  "massupdate": false,
855  "multi_select_group": "category",
856  "vname": "Category",
857  "len": 50,
858  "dbType": "varchar",
859  "charset": "ascii",
860  "source": {
861  "type": "db"
862  }
863  },
864  "business_role": {
865  "vname": "Business Role",
866  "type": "enum",
867  "options": [
868  {
869  "label": "CEO",
870  "value": "CEO"
871  },
872  {
873  "label": "MIS",
874  "value": "MIS"
875  },
876  {
877  "label": "CFO",
878  "value": "CFO"
879  },
880  {
881  "label": "Sales",
882  "value": "Sales"
883  },
884  {
885  "label": "Admin",
886  "value": "Admin"
887  }
888  ],
889  "len": 40,
890  "massupdate": true,
891  "audited": true,
892  "name": "business_role",
893  "dbType": "varchar",
894  "charset": "ascii",
895  "source": {
896  "type": "db"
897  }
898  },
899  "last_activity_date": {
900  "vname": "Last Activity Date",
901  "type": "datetime",
902  "editable": false,
903  "name": "last_activity_date",
904  "source": {
905  "type": "db"
906  }
907  },
908  "salutation": {
909  "vname": "Salutation",
910  "type": "enum",
911  "options": [
912  {
913  "label": "Mr.",
914  "value": "Mr."
915  },
916  {
917  "label": "Ms.",
918  "value": "Ms."
919  },
920  {
921  "label": "Mrs.",
922  "value": "Mrs."
923  },
924  {
925  "label": "Dr.",
926  "value": "Dr."
927  },
928  {
929  "label": "Prof.",
930  "value": "Prof."
931  }
932  ],
933  "massupdate": false,
934  "len": 20,
935  "comment": "Contact salutation (e.g., Mr, Ms)",
936  "name": "salutation",
937  "dbType": "varchar",
938  "charset": "ascii",
939  "source": {
940  "type": "db"
941  }
942  },
943  "first_name": {
944  "vname": "First Name",
945  "type": "varchar",
946  "len": 100,
947  "comment": "First name of the contact",
948  "name": "first_name",
949  "source": {
950  "type": "db"
951  }
952  },
953  "last_name": {
954  "vname": "Last Name",
955  "type": "name",
956  "len": 100,
957  "comment": "Last name of the contact",
958  "required": true,
959  "name": "last_name",
960  "dbType": "varchar",
961  "detail_link": true,
962  "source": {
963  "type": "db"
964  }
965  },
966  "lead_source": {
967  "vname": "Lead Source",
968  "type": "enum",
969  "options": [
970  {
971  "label": "Cold Call",
972  "value": "Cold Call"
973  },
974  {
975  "label": "Existing Customer",
976  "value": "Existing Customer"
977  },
978  {
979  "label": "Self Generated",
980  "value": "Self Generated"
981  },
982  {
983  "label": "Employee",
984  "value": "Employee"
985  },
986  {
987  "label": "Partner",
988  "value": "Partner"
989  },
990  {
991  "label": "Public Relations",
992  "value": "Public Relations"
993  },
994  {
995  "label": "Direct Mail",
996  "value": "Direct Mail"
997  },
998  {
999  "label": "Conference",
1000  "value": "Conference"
1001  },
1002  {
1003  "label": "Trade Show",
1004  "value": "Trade Show"
1005  },
1006  {
1007  "label": "Web Site",
1008  "value": "Web Site"
1009  },
1010  {
1011  "label": "Customer Portal",
1012  "value": "Customer Portal"
1013  },
1014  {
1015  "label": "Word of mouth",
1016  "value": "Word of mouth"
1017  },
1018  {
1019  "label": "Email",
1020  "value": "Email"
1021  },
1022  {
1023  "label": "Other",
1024  "value": "Other"
1025  }
1026  ],
1027  "len": 100,
1028  "comment": "How did the contact come about",
1029  "massupdate": true,
1030  "name": "lead_source",
1031  "dbType": "varchar",
1032  "charset": "ascii",
1033  "source": {
1034  "type": "db"
1035  }
1036  },
1037  "title": {
1038  "vname": "Title",
1039  "type": "varchar",
1040  "len": 50,
1041  "comment": "The title of the contact",
1042  "vname_list": "Title",
1043  "audited": true,
1044  "list_subtitle": true,
1045  "name": "title",
1046  "source": {
1047  "type": "db"
1048  }
1049  },
1050  "department": {
1051  "vname": "Department",
1052  "type": "varchar",
1053  "len": 100,
1054  "comment": "The department of the contact",
1055  "audited": true,
1056  "name": "department",
1057  "source": {
1058  "type": "db"
1059  }
1060  },
1061  "reports_to": {
1062  "vname": "Reports To",
1063  "type": "ref",
1064  "comment": "The contact this contact reports to",
1065  "bean_name": "Contact",
1066  "massupdate": true,
1067  "name": "reports_to",
1068  "detail_link": true,
1069  "source": {
1070  "type": "non-db"
1071  },
1072  "id_name": "reports_to_id"
1073  },
1074  "reports_to_id": {
1075  "name": "reports_to_id",
1076  "type": "id",
1077  "reportable": false,
1078  "inferred": true,
1079  "for_ref": "reports_to",
1080  "vname": "ID",
1081  "dbType": "char",
1082  "charset": "ascii",
1083  "len": 36,
1084  "editable": false,
1085  "source": {
1086  "type": "db"
1087  }
1088  },
1089  "birthdate": {
1090  "vname": "Birthdate",
1091  "massupdate": false,
1092  "type": "date",
1093  "comment": "The birthdate of the contact",
1094  "name": "birthdate",
1095  "source": {
1096  "type": "db"
1097  }
1098  },
1099  "do_not_call": {
1100  "vname": "Do Not Call",
1101  "type": "bool",
1102  "dbType": "varchar",
1103  "len": 3,
1104  "default": 0,
1105  "audited": true,
1106  "comment": "An indicator of whether contact can be called",
1107  "massupdate": true,
1108  "name": "do_not_call",
1109  "source": {
1110  "type": "db"
1111  }
1112  },
1113  "email_accounts": {
1114  "vname": "Accounting Contact",
1115  "type": "bool",
1116  "dbType": "varchar",
1117  "len": 3,
1118  "default": 0,
1119  "audited": true,
1120  "comment": "An indicator of whether we should email the account invoice\nto this client",
1121  "massupdate": true,
1122  "name": "email_accounts",
1123  "source": {
1124  "type": "db"
1125  }
1126  },
1127  "phone_home": {
1128  "vname": "Home Phone",
1129  "type": "phone",
1130  "unified_search": true,
1131  "comment": "Home phone number of the contact",
1132  "name": "phone_home",
1133  "len": 40,
1134  "width": 18,
1135  "dbType": "varchar",
1136  "source": {
1137  "type": "db"
1138  }
1139  },
1140  "phone_home__raw": {
1141  "name": "phone_home__raw",
1142  "type": "varchar",
1143  "reportable": false,
1144  "editable": false,
1145  "inferred": true,
1146  "len": 40,
1147  "source": {
1148  "type": "db"
1149  }
1150  },
1151  "phone_mobile": {
1152  "vname": "Mobile Phone",
1153  "type": "phone",
1154  "unified_search": true,
1155  "comment": "Mobile phone number of the contact",
1156  "name": "phone_mobile",
1157  "len": 40,
1158  "width": 18,
1159  "dbType": "varchar",
1160  "source": {
1161  "type": "db"
1162  }
1163  },
1164  "phone_mobile__raw": {
1165  "name": "phone_mobile__raw",
1166  "type": "varchar",
1167  "reportable": false,
1168  "editable": false,
1169  "inferred": true,
1170  "len": 40,
1171  "source": {
1172  "type": "db"
1173  }
1174  },
1175  "phone_work": {
1176  "vname": "Office Phone",
1177  "type": "phone",
1178  "audited": true,
1179  "unified_search": true,
1180  "comment": "Work phone number of the contact",
1181  "name": "phone_work",
1182  "len": 40,
1183  "width": 18,
1184  "dbType": "varchar",
1185  "source": {
1186  "type": "db"
1187  }
1188  },
1189  "phone_work__raw": {
1190  "name": "phone_work__raw",
1191  "type": "varchar",
1192  "reportable": false,
1193  "editable": false,
1194  "inferred": true,
1195  "len": 40,
1196  "source": {
1197  "type": "db"
1198  }
1199  },
1200  "phone_other": {
1201  "vname": "Other Phone",
1202  "type": "phone",
1203  "unified_search": true,
1204  "comment": "Other phone number for the contact",
1205  "name": "phone_other",
1206  "len": 40,
1207  "width": 18,
1208  "dbType": "varchar",
1209  "source": {
1210  "type": "db"
1211  }
1212  },
1213  "phone_other__raw": {
1214  "name": "phone_other__raw",
1215  "type": "varchar",
1216  "reportable": false,
1217  "editable": false,
1218  "inferred": true,
1219  "len": 40,
1220  "source": {
1221  "type": "db"
1222  }
1223  },
1224  "phone_fax": {
1225  "vname": "Fax Number",
1226  "type": "fax",
1227  "unified_search": true,
1228  "comment": "Contact fax number",
1229  "name": "phone_fax",
1230  "len": 40,
1231  "width": 18,
1232  "dbType": "varchar",
1233  "source": {
1234  "type": "db"
1235  }
1236  },
1237  "phone_fax__raw": {
1238  "name": "phone_fax__raw",
1239  "type": "varchar",
1240  "reportable": false,
1241  "editable": false,
1242  "inferred": true,
1243  "len": 40,
1244  "source": {
1245  "type": "db"
1246  }
1247  },
1248  "skype_id": {
1249  "vname": "Skype ID",
1250  "type": "skype",
1251  "unified_search": true,
1252  "comment": "Contact Skype ID",
1253  "name": "skype_id",
1254  "width": 18,
1255  "source": {
1256  "type": "db"
1257  }
1258  },
1259  "email1": {
1260  "vname": "Email",
1261  "type": "email",
1262  "audited": true,
1263  "unified_search": true,
1264  "comment": "Primary email address of the contact",
1265  "vname_list": "Email",
1266  "name": "email1",
1267  "len": 150,
1268  "dbType": "varchar",
1269  "width": 18,
1270  "source": {
1271  "type": "db"
1272  }
1273  },
1274  "email2": {
1275  "vname": "Other Email",
1276  "type": "email",
1277  "unified_search": true,
1278  "comment": "Secondary email address of the contact",
1279  "vname_list": "Email",
1280  "name": "email2",
1281  "len": 150,
1282  "dbType": "varchar",
1283  "width": 18,
1284  "source": {
1285  "type": "db"
1286  }
1287  },
1288  "assistant": {
1289  "vname": "Assistant",
1290  "type": "varchar",
1291  "len": 75,
1292  "unified_search": true,
1293  "comment": "Name of the assistant of the contact",
1294  "name": "assistant",
1295  "source": {
1296  "type": "db"
1297  }
1298  },
1299  "assistant_phone": {
1300  "vname": "Assistant Phone",
1301  "type": "phone",
1302  "unified_search": true,
1303  "comment": "Phone number of the assistant of the contact",
1304  "name": "assistant_phone",
1305  "len": 40,
1306  "width": 18,
1307  "dbType": "varchar",
1308  "source": {
1309  "type": "db"
1310  }
1311  },
1312  "assistant_phone__raw": {
1313  "name": "assistant_phone__raw",
1314  "type": "varchar",
1315  "reportable": false,
1316  "editable": false,
1317  "inferred": true,
1318  "len": 40,
1319  "source": {
1320  "type": "db"
1321  }
1322  },
1323  "email_opt_out": {
1324  "vname": "Email Opt Out",
1325  "type": "bool",
1326  "dbType": "varchar",
1327  "len": 3,
1328  "default": 0,
1329  "comment": "Indicator whether the contact has elected to opt out of\nemails",
1330  "massupdate": true,
1331  "name": "email_opt_out",
1332  "source": {
1333  "type": "db"
1334  }
1335  },
1336  "email_opt_in": {
1337  "vname": "Email Opt In",
1338  "type": "bool",
1339  "default": 0,
1340  "massupdate": false,
1341  "name": "email_opt_in",
1342  "source": {
1343  "type": "db"
1344  }
1345  },
1346  "email_opt_in_date": {
1347  "type": "date",
1348  "editable": false,
1349  "vname": "Email Opt-In Date",
1350  "name": "email_opt_in_date",
1351  "source": {
1352  "type": "db"
1353  }
1354  },
1355  "website": {
1356  "vname": "Website",
1357  "type": "url",
1358  "name": "website",
1359  "len": 255,
1360  "dbType": "varchar",
1361  "width": 18,
1362  "source": {
1363  "type": "db"
1364  }
1365  },
1366  "primary_address_street": {
1367  "vname": "Primary Address Street",
1368  "type": "varchar",
1369  "len": 150,
1370  "comment": "Street address for primary address",
1371  "name": "primary_address_street",
1372  "source": {
1373  "type": "db"
1374  }
1375  },
1376  "primary_address_city": {
1377  "vname": "Primary Address City",
1378  "vname_list": "City",
1379  "type": "varchar",
1380  "len": 100,
1381  "comment": "City for primary address",
1382  "name": "primary_address_city",
1383  "source": {
1384  "type": "db"
1385  }
1386  },
1387  "primary_address_state": {
1388  "vname": "Primary Address State",
1389  "vname_list": "State",
1390  "type": "varchar",
1391  "len": 100,
1392  "comment": "State for primary address",
1393  "name": "primary_address_state",
1394  "source": {
1395  "type": "db"
1396  }
1397  },
1398  "primary_address_postalcode": {
1399  "vname": "Primary Address Postal Code",
1400  "type": "varchar",
1401  "len": 20,
1402  "comment": "Postal code for primary address",
1403  "name": "primary_address_postalcode",
1404  "source": {
1405  "type": "db"
1406  }
1407  },
1408  "primary_address_country": {
1409  "vname": "Primary Address Country",
1410  "type": "varchar",
1411  "len": 100,
1412  "comment": "Country for primary address",
1413  "name": "primary_address_country",
1414  "source": {
1415  "type": "db"
1416  }
1417  },
1418  "primary_address_statecode": {
1419  "vname": "Primary Address State Code",
1420  "type": "varchar",
1421  "len": 100,
1422  "name": "primary_address_statecode",
1423  "source": {
1424  "type": "db"
1425  }
1426  },
1427  "primary_address_countrycode": {
1428  "vname": "Primary Address Country Code",
1429  "type": "varchar",
1430  "len": 100,
1431  "name": "primary_address_countrycode",
1432  "source": {
1433  "type": "db"
1434  }
1435  },
1436  "alt_address_street": {
1437  "vname": "Alternate Address Street",
1438  "type": "varchar",
1439  "len": 150,
1440  "comment": "Street address for alternate address",
1441  "name": "alt_address_street",
1442  "source": {
1443  "type": "db"
1444  }
1445  },
1446  "alt_address_city": {
1447  "vname": "Alternate Address City",
1448  "type": "varchar",
1449  "len": 100,
1450  "comment": "City for alternate address",
1451  "name": "alt_address_city",
1452  "source": {
1453  "type": "db"
1454  }
1455  },
1456  "alt_address_state": {
1457  "vname": "Alternate Address State",
1458  "type": "varchar",
1459  "len": 100,
1460  "comment": "State for alternate address",
1461  "name": "alt_address_state",
1462  "source": {
1463  "type": "db"
1464  }
1465  },
1466  "alt_address_postalcode": {
1467  "vname": "Alternate Address Postal Code",
1468  "type": "varchar",
1469  "len": 20,
1470  "comment": "Postal code for alternate address",
1471  "name": "alt_address_postalcode",
1472  "source": {
1473  "type": "db"
1474  }
1475  },
1476  "alt_address_country": {
1477  "vname": "Alternate Address Country",
1478  "type": "varchar",
1479  "len": 100,
1480  "comment": "Country for alternate address",
1481  "name": "alt_address_country",
1482  "source": {
1483  "type": "db"
1484  }
1485  },
1486  "alt_address_statecode": {
1487  "vname": "Alternate Address State Code",
1488  "type": "varchar",
1489  "len": 100,
1490  "name": "alt_address_statecode",
1491  "source": {
1492  "type": "db"
1493  }
1494  },
1495  "alt_address_countrycode": {
1496  "vname": "Alternate Address Country Code",
1497  "type": "varchar",
1498  "len": 100,
1499  "name": "alt_address_countrycode",
1500  "source": {
1501  "type": "db"
1502  }
1503  },
1504  "description": {
1505  "vname": "Description",
1506  "type": "text",
1507  "comment": "Description of contact",
1508  "name": "description",
1509  "multiline": true,
1510  "source": {
1511  "type": "db"
1512  }
1513  },
1514  "portal_name": {
1515  "vname": "Portal Name",
1516  "type": "varchar",
1517  "len": 255,
1518  "comment": "Name as it appears in the portal",
1519  "name": "portal_name",
1520  "source": {
1521  "type": "db"
1522  }
1523  },
1524  "portal_active": {
1525  "vname": "Portal Active",
1526  "type": "bool",
1527  "required": true,
1528  "default": 0,
1529  "comment": "Indicator whether this contact is a portal user",
1530  "massupdate": true,
1531  "name": "portal_active",
1532  "source": {
1533  "type": "db"
1534  }
1535  },
1536  "portal_app": {
1537  "vname": "Portal Application",
1538  "type": "varchar",
1539  "len": 255,
1540  "comment": "Reference to the portal",
1541  "name": "portal_app",
1542  "source": {
1543  "type": "db"
1544  }
1545  },
1546  "invalid_email": {
1547  "vname": "Invalid Email",
1548  "type": "bool",
1549  "comment": "Indicator that contact email address is invalid",
1550  "name": "invalid_email",
1551  "source": {
1552  "type": "db"
1553  }
1554  },
1555  "partner": {
1556  "type": "ref",
1557  "vname": "Partner",
1558  "bean_name": "Partner",
1559  "massupdate": true,
1560  "audited": true,
1561  "name": "partner",
1562  "detail_link": true,
1563  "source": {
1564  "type": "non-db"
1565  },
1566  "id_name": "partner_id"
1567  },
1568  "partner_id": {
1569  "name": "partner_id",
1570  "type": "id",
1571  "reportable": false,
1572  "inferred": true,
1573  "for_ref": "partner",
1574  "audited": true,
1575  "vname": "ID",
1576  "dbType": "char",
1577  "charset": "ascii",
1578  "len": 36,
1579  "editable": false,
1580  "source": {
1581  "type": "db"
1582  }
1583  },
1584  "campaign": {
1585  "comment": "Campaign that generated lead",
1586  "vname": "Campaign",
1587  "rname": "id",
1588  "id_name": "campaign_id",
1589  "type": "ref",
1590  "table": "campaigns",
1591  "isnull": true,
1592  "module": "Campaigns",
1593  "massupdate": false,
1594  "duplicate_merge": "disabled",
1595  "bean_name": "Campaign",
1596  "name": "campaign",
1597  "detail_link": true,
1598  "source": {
1599  "type": "non-db"
1600  }
1601  },
1602  "campaign_id": {
1603  "name": "campaign_id",
1604  "type": "id",
1605  "reportable": false,
1606  "inferred": true,
1607  "for_ref": "campaign",
1608  "vname": "ID",
1609  "isnull": true,
1610  "dbType": "char",
1611  "charset": "ascii",
1612  "len": 36,
1613  "editable": false,
1614  "source": {
1615  "type": "db"
1616  }
1617  },
1618  "vcard_size": {
1619  "type": "int",
1620  "comment": "Size of vCard",
1621  "duplicate_merge": "disabled",
1622  "reportable": false,
1623  "name": "vcard_size",
1624  "source": {
1625  "type": "db"
1626  }
1627  },
1628  "vcard": {
1629  "type": "text",
1630  "comment": "Pre-generated vCard for contact",
1631  "duplicate_merge": "disabled",
1632  "reportable": false,
1633  "name": "vcard",
1634  "multiline": true,
1635  "source": {
1636  "type": "db"
1637  }
1638  },
1639  "vcard_uri": {
1640  "type": "varchar",
1641  "len": 255,
1642  "comment": "URI generated by external contacts app",
1643  "reportable": false,
1644  "duplicate_merge": "disabled",
1645  "name": "vcard_uri",
1646  "source": {
1647  "type": "db"
1648  }
1649  },
1650  "photo": {
1651  "vname": "Photo",
1652  "type": "image",
1653  "placeholder": "themes\/Default\/images\/no_user.png",
1654  "alt_image": "primary_account.photo",
1655  "name": "photo",
1656  "source": {
1657  "type": "non-db"
1658  },
1659  "display_size": [
1660  90,
1661  90
1662  ],
1663  "thumbnail_size": [
1664  120,
1665  120,
1666  1
1667  ],
1668  "thumbnail": "auto",
1669  "max_size": 1000,
1670  "upload_dir": "{FILES}\/images\/photos\/",
1671  "filename": "photo_filename",
1672  "thumbnail_name": "photo_thumb"
1673  },
1674  "photo_filename": {
1675  "vname": "Photo Filename",
1676  "type": "file_ref",
1677  "name": "photo_filename",
1678  "size": 255,
1679  "reportable": false,
1680  "source": {
1681  "type": "db"
1682  }
1683  },
1684  "photo_thumb": {
1685  "vname": "Thumbnail Filename",
1686  "type": "file_ref",
1687  "name": "photo_thumb",
1688  "size": 255,
1689  "reportable": false,
1690  "source": {
1691  "type": "db"
1692  }
1693  },
1694  "chat_activity": {
1695  "type": "bool",
1696  "vname": "Chat Activity",
1697  "vname_module": "Chats",
1698  "default": 0,
1699  "name": "chat_activity",
1700  "source": {
1701  "type": "db"
1702  }
1703  },
1704  "mautic_id": {
1705  "type": "int",
1706  "vname": "Lead Guerrilla Contact ID",
1707  "vname_module": "LeadGuerrilla",
1708  "comment": "ID of related contact in Mautic\/Lead Guerrilla",
1709  "name": "mautic_id",
1710  "source": {
1711  "type": "db"
1712  }
1713  },
1714  "livechat_activity": {
1715  "type": "bool",
1716  "vname": "Live Chat Activity",
1717  "vname_module": "LiveChatInc",
1718  "default": 0,
1719  "name": "livechat_activity",
1720  "source": {
1721  "type": "db"
1722  }
1723  }
1724  },
1725  "filters": {
1726  "filter_text": {
1727  "name": "filter_text",
1728  "vname": "Search Text",
1729  "type": "unified_search",
1730  "basic": true,
1731  "fulltext_search": false,
1732  "search_what": "all",
1733  "report_filter": true,
1734  "quick_view": true
1735  },
1736  "filter_owner": {
1737  "vname": "Owner",
1738  "type": "owner",
1739  "default_value": "all",
1740  "options": {
1741  "all": {
1742  "vname": "LBL_FILTER_OWNER_ANY",
1743  "icon": "icon-users"
1744  },
1745  "mine": {
1746  "field": "assigned_user_id",
1747  "link": "",
1748  "vname": "LBL_FILTER_OWNER_MINE",
1749  "value": "1",
1750  "icon": "icon-adminuser"
1751  },
1752  "not_mine": {
1753  "field": "assigned_user_id",
1754  "link": "",
1755  "vname": "LBL_FILTER_OWNER_NOT_MINE",
1756  "operator": "!=",
1757  "value": "1",
1758  "icon": "icon-users"
1759  },
1760  "select": {
1761  "field": "assigned_user_id",
1762  "link": "",
1763  "vname": "LBL_FILTER_OWNER_SELECT",
1764  "icon": "icon-popup"
1765  }
1766  },
1767  "options_icon": "icon",
1768  "options_blank_key": "all",
1769  "input_class": "OwnerSelect",
1770  "report_filter": true,
1771  "var_width": true,
1772  "basic": true
1773  },
1774  "filter_favorites": {
1775  "name": "filter_favorites",
1776  "vname": "Only Favorites",
1777  "type": "flag",
1778  "class": "check-star",
1779  "basic": true,
1780  "field": "favorites.deleted",
1781  "default_value": false,
1782  "operator": "eq",
1783  "value": "0"
1784  },
1785  "primary_account": {
1786  "vname": "Primary Account",
1787  "vname_list": "Account Name",
1788  "type": "ref",
1789  "bean_name": "Account",
1790  "importable": false,
1791  "massupdate": false,
1792  "audited": true,
1793  "name": "primary_account",
1794  "id_name": "primary_account_id",
1795  "vname_module": "Contacts",
1796  "field": "primary_account",
1797  "editable": true,
1798  "updateable": true,
1799  "allow_custom": true,
1800  "basic": true
1801  },
1802  "first_name": {
1803  "vname": "First Name",
1804  "type": "varchar",
1805  "len": 100,
1806  "comment": "First name of the contact",
1807  "name": "first_name",
1808  "vname_module": "Contacts",
1809  "field": "first_name",
1810  "editable": true,
1811  "updateable": true
1812  },
1813  "last_name": {
1814  "vname": "Last Name",
1815  "type": "name",
1816  "len": 100,
1817  "comment": "Last name of the contact",
1818  "name": "last_name",
1819  "dbType": "varchar",
1820  "vname_module": "Contacts",
1821  "field": "last_name",
1822  "editable": true,
1823  "updateable": true
1824  },
1825  "categories": {
1826  "vname": "Category",
1827  "vname_list": "Category",
1828  "type": "multienum",
1829  "options": {
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"
1840  },
1841  "len": 40,
1842  "multi_select_group": "category",
1843  "multi_select_count": 10,
1844  "massupdate": true,
1845  "name": "categories",
1846  "dbType": "varchar",
1847  "charset": "ascii",
1848  "vname_module": "Contacts",
1849  "field": "categories",
1850  "editable": true,
1851  "updateable": true
1852  },
1853  "lead_source": {
1854  "vname": "Lead Source",
1855  "type": "enum",
1856  "options": {
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",
1869  "Email": "Email",
1870  "Other": "Other"
1871  },
1872  "len": 100,
1873  "comment": "How did the contact come about",
1874  "massupdate": true,
1875  "name": "lead_source",
1876  "dbType": "varchar",
1877  "charset": "ascii",
1878  "vname_module": "Contacts",
1879  "field": "lead_source",
1880  "editable": true,
1881  "updateable": true
1882  },
1883  "do_not_call": {
1884  "vname": "Do Not Call",
1885  "type": "bool",
1886  "dbType": "varchar",
1887  "len": 3,
1888  "audited": true,
1889  "comment": "An indicator of whether contact can be called",
1890  "massupdate": true,
1891  "name": "do_not_call",
1892  "vname_module": "Contacts",
1893  "field": "do_not_call",
1894  "editable": true,
1895  "updateable": true
1896  },
1897  "any_phone": {
1898  "vname": "Any Phone",
1899  "type": "phone",
1900  "fields": [
1901  "phone_home",
1902  "phone_mobile",
1903  "phone_work",
1904  "phone_other",
1905  "phone_fax",
1906  "assistant_phone"
1907  ]
1908  },
1909  "any_email": {
1910  "vname": "Any Email",
1911  "type": "email",
1912  "fields": [
1913  "email1",
1914  "email2"
1915  ]
1916  },
1917  "assistant": {
1918  "vname": "Assistant",
1919  "type": "varchar",
1920  "len": 75,
1921  "unified_search": true,
1922  "comment": "Name of the assistant of the contact",
1923  "name": "assistant",
1924  "vname_module": "Contacts",
1925  "field": "assistant",
1926  "editable": true,
1927  "updateable": true
1928  },
1929  "email_opt_out": {
1930  "vname": "Email Opt Out",
1931  "type": "bool",
1932  "dbType": "varchar",
1933  "len": 3,
1934  "comment": "Indicator whether the contact has elected to opt out of\nemails",
1935  "massupdate": true,
1936  "name": "email_opt_out",
1937  "vname_module": "Contacts",
1938  "field": "email_opt_out",
1939  "editable": true,
1940  "updateable": true
1941  },
1942  "address_street": {
1943  "vname": "Any Address",
1944  "type": "varchar",
1945  "fields": [
1946  "primary_address_street",
1947  "alt_address_street"
1948  ]
1949  },
1950  "address_city": {
1951  "vname": "Any City",
1952  "type": "varchar",
1953  "fields": [
1954  "primary_address_city",
1955  "alt_address_city"
1956  ]
1957  },
1958  "address_state": {
1959  "vname": "Any State",
1960  "type": "varchar",
1961  "fields": [
1962  "primary_address_state",
1963  "alt_address_state"
1964  ]
1965  },
1966  "address_postalcode": {
1967  "vname": "Any Postal Code",
1968  "type": "varchar",
1969  "fields": [
1970  "primary_address_postalcode",
1971  "alt_address_postalcode"
1972  ]
1973  },
1974  "address_country": {
1975  "vname": "Any Country",
1976  "type": "varchar",
1977  "fields": [
1978  "primary_address_country",
1979  "alt_address_country"
1980  ]
1981  },
1982  "title": {
1983  "vname": "Title",
1984  "type": "varchar",
1985  "len": 50,
1986  "comment": "The title of the contact",
1987  "vname_list": "Title",
1988  "audited": true,
1989  "list_subtitle": true,
1990  "name": "title",
1991  "vname_module": "Contacts",
1992  "field": "title",
1993  "editable": true,
1994  "updateable": true
1995  },
1996  "business_role": {
1997  "vname": "Business Role",
1998  "type": "enum",
1999  "options": {
2000  "CEO": "CEO",
2001  "MIS": "MIS",
2002  "CFO": "CFO",
2003  "Sales": "Sales",
2004  "Admin": "Admin"
2005  },
2006  "len": 40,
2007  "massupdate": true,
2008  "audited": true,
2009  "name": "business_role",
2010  "dbType": "varchar",
2011  "charset": "ascii",
2012  "vname_module": "Contacts",
2013  "field": "business_role",
2014  "editable": true,
2015  "updateable": true
2016  }
2017  }
2018 }