CMCONTACT

Common - Contacts Table

Field Name	Default Caption	Mask	Description	Field Type
CT_COMMENT1	Long Note		Long Note	Memo
CT_CRT_BY	Created By	25x	Created By	Text
CT_CRT_DTTM	Creation Date Time	mm/dd/yyyy hh:mm am	Creation Date Time	Date/Time
CT_DOC_FLG	Document Available		Document Attached	Boolean
CT_EMAIL	Email Address	150x	Email Address	Text
CT_HM_PHN	Home Phone	25x	Home Phone Number	Text
CT_ID	Contact Rec #	nnnnnnnn	Unique ID	Long Integer
CT_MOD_BY	Last Mod By	25x	Modified By	Text
CT_MOD_DT	Last Mod Date	mm/dd/yyyy	Modified Date	Date/Time
CT_MOD_TM	Last Modified Time	hh:mm am	Modified Time	Date/Time
CT_NAM_SAL	Salutation	6	Name, Salutation	Text
CT_NAM_MI	M.I.	15	Name, Middle Initial	Text
CT_NAM_SFX	Name Suffix	5	Name, Suffix (jr)	Text
CT_NAME1	Name	40x	First name of contact	Text
CT_NAME2	Name 2	40x	Last name of contact	Text
CT_NUMBER	Contact No	30x	Contact No	Text
CT_PHONE1	Mobile Phone	25x	Mobile Phone Number	Text
CT_PHONE2	Fax Phone	25x	Fax Number	Text
CT_ROWVER		mm/dd/yyyy hh:mm am	Rowversion for optimistic locking	Date/Time
CT_SND_NTF	Send Email Notification		Send Email Notification	Boolean
CT_USER10	User 10	mm/dd/yyyy	User 10	Date/Time
CT_USER11	User 11	mm/dd/yyyy	User 11	Date/Time
CT_USER12	User 12	mm/dd/yyyy	User 12	Date/Time
CT_USER13	User 13		User 13	Boolean
CT_USER14	User 14		User 14	Boolean
CT_USER15	User 15		User 15	Boolean
CT_USER16CD	User 16	nnn	User 16	Short Integer
CT_USER16TY	User 16 Text	50	User 16 Text	Text
CT_USER17CD	User 17	nnn	User 17	Short Integer
CT_USER17TY	User 17 Text	50	User 17 Text	Text
CT_USER18CD	User 18	nnn	User 18	Short Integer
CT_USER18TY	User 18 Text	50	User 18 Text	Text
CT_USER19CD	User 19	nnn	User 19	Short Integer
CT_USER19TY	User 19 Text	50	User 19 Text	Text
CT_USER1CD	User 1	nnn	User 1	Short Integer
CT_USER1TY	User 1 Text	25x	User 1 Text	Text
CT_USER2CD	User 2	nnn	User 2	Short Integer
CT_USER2TY	User 2 Text	25x	User 2 Text	Text
CT_USER20CD	User 20	nnn	User 20	Short Integer
CT_USER20TY	User 20 Text	50x	User 20 Text	Text
CT_USER21	User 21	50x	User 21	Text
CT_USER22	User 22	50x	User 22	Text
CT_USER23	User 23	50x	User 23	Text
CT_USER24	User 24	50x	User 24	Text
CT_USER25	User 25	50x	User 25	Text
CT_USER26	User 26	-nnnnnnnnn.nn	User 26	Double
CT_USER27	User 27	-nnnnnnnnn.nn	User 27	Double
CT_USER28	User 28	-nnnnnnnnn.nn	User 28	Double
CT_USER29	User 29	-nnnnnnnnn.nn	User 29	Double
CT_USER3CD	User 3	nnn	User 3	Short Integer
CT_USER3TY	User 3 Text	25x	User 3 Text	Text
CT_USER30	User 30	-nnnnnnnnn.nn	User 30	Double
CT_USER31	User 31	mm/dd/yyyy	User 31	Date/Time
CT_USER32	User 32	mm/dd/yyyy	User 32	Date/Time
CT_USER33	User 33	mm/dd/yyyy	User 33	Date/Time
CT_USER34	User 34	mm/dd/yyyy	User 34	Date/Time
CT_USER35	User 35	mm/dd/yyyy	User 35	Date/Time
CT_USER36	User 36		User 36	Boolean
CT_USER37	User 37		User 37	Boolean
CT_USER38	User 38		User 38	Boolean
CT_USER39	User 39		User 39	Boolean
CT_USER4	User 4	30x	User 4	Text
CT_USER40	User 40		User 40	Boolean
CT_USER5	User 5	30x	User 5	Text
CT_USER6	User 6	30x	User 6	Text
CT_USER7	User 7	-nnnnnnnnn.nn	User 7	Double
CT_USER8	User 8	-nnnnnnnnn.nn	User 8	Double
CT_USER9	User 9	-nnnnnnnnn.nn	User 9	Double
CT_WK_PHN	Work Phone	25x	Work Phone Number	Text
CT_USER41	User 41		User 41	Boolean
CT_USER42	User 42		User 42	Boolean
CT_USER43	User 43		User 43	Boolean
CT_USER44	User 44		User 44	Boolean
CT_USER45	User 45		User 45	Boolean
CT_USER46	User 46		User 46	Boolean
CT_USER47	User 47		User 47	Boolean
CT_USER48	User 48		User 48	Boolean
CT_USER49	User 49		User 49	Boolean
CT_USER50	User 50		User 50	Boolean
CT_USER51	User 51		User 51	Boolean
CT_USER52	User 52		User 52	Boolean
CT_USER53	User 53		User 53	Boolean
CT_USER54	User 54		User 54	Boolean
CT_USER55	User 55		User 55	Boolean
CT_USER56	User 56		User 56	Boolean
CT_USER57	User 57		User 57	Boolean
CT_USER58	User 58		User 58	Boolean
CT_USER59	User 59		User 59	Boolean
CT_USER60	User 60		User 60	Boolean

Related Tables

Tables that link to this table

Linking Table	Linking Field	Target Field	Purpose
CMACLINK	AC_CONTID	CT_ID	Linking table between Addresses and Contacts.