CMACCT

Common - Account Number for the Addresses

Field name	Default Caption	Mask	Description	Field Type
ACT_ACCTNO	Account Number	30x	Account Number	Text
ACT_ACT_CD	Account Type	nnn	Account Type Code	Short Integer
ACT_ACT_TY	Account Type Desc	25x	Account Type Text	Text
ACT_ADDID	Address Rec #	nnnnnnnn	Link to CMADDR.AD_ID	Long Integer
ACT_CRT_BY	Created By	25x	Created By	Text
ACT_CRT_DTTM	Creation Date Time	mm/dd/yyyy hh:mm am	Creation Date Time	Date/Time
ACT_ID	Account Rec #	nnnnnnnn	Unique ID	Long Integer
ACT_MOD_BY	Last Modified By	25x	Last Modified By:	Text
ACT_MOD_DT	Last Modified Date	mm/dd/yyyy	Last Modified Date:	Date/Time
ACT_MOD_TM	Last Modified Time	hh:mm am	Modified Time	Date/Time
ACT_ROWVER		mm/dd/yyyy hh:mm am	Rowversion for optimistic locking	Date/Time
ACT_USER1CD	User 1		User 1	Small Integer
ACT_USER1TY	User 1 Text	50x	User 1 Text	String
ACT_USER2CD	User 2		User 2	Small Integer
ACT_USER2TY	User 2 Text	50x	User 2 Text	String
ACT_USER3CD	User 3		User 3	Small Integer
ACT_USER3TY	User 3 Text	50x	User 3 Text	String
ACT_USER4CD	User 4		User 4	Small Integer
ACT_USER4TY	User 4 Text	50x	User 4 Text	String
ACT_USER5CD	User 5		User 5	Small Integer
ACT_USER5TY	User 5 Text	50x	User 5 Text	String
ACT_USER6CD	User 6		User 6	Small Integer
ACT_USER6TY	User 6 Text	50x	User 6 Text	String
ACT_USER7CD	User 7		User 7	Small Integer
ACT_USER7TY	User 7 Text	50x	User 7 Text	String
ACT_USER8CD	User 8		User 8	Small Integer
ACT_USER8TY	User 8 Text	50x	User 8 Text	String
ACT_USER9CD	User 9		User 9	Small Integer
ACT_USER9TY	User 9 Text	50x	User 9 Text	String
ACT_USER10CD	User 10		User 10	Small Integer
ACT_USER10TY	User 10 Text	50x	User 10 Text	String
ACT_USER11CD	User 11	10x	User 11	String
ACT_USER11TY	User 11 Text	60x	User 11 Text	String
ACT_USER12CD	User 12	10x	User 12	String
ACT_USER12TY	User 12 Text	60x	User 12 Text	String
ACT_USER13CD	User 13	10x	User 13	String
ACT_USER13TY	User 13 Text	60x	User 13 Text	String
ACT_USER14CD	User 14	10x	User 14	String
ACT_USER14TY	User 14 Text	60x	User 14 Text	String
ACT_USER15CD	User 15	10x	User 15	String
ACT_USER15TY	User 15 Text	60x	User 15 Text	String
ACT_USER16CD	User 16	10x	User 16	String
ACT_USER16TY	User 16 Text	60x	User 16 Text	String
ACT_USER17CD	User 17	10x	User 17	String
ACT_USER17TY	User 17 Text	60x	User 17 Text	String
ACT_USER18CD	User 18	10x	User 18	String
ACT_USER18TY	User 18 Text	60x	User 18 Text	String
ACT_USER19CD	User 19	10x	User 19	String
ACT_USER19TY	User 19 Text	60x	User 19 Text	String
ACT_USER20CD	User 20	10x	User 20	String
ACT_USER20TY	User 20 Text	60x	User 20 Text	String
ACT_USER21	User 21	75x	User 21	String
ACT_USER22	User 22	75x	User 22	String
ACT_USER23	User 23	75x	User 23	String
ACT_USER24	User 24	75x	User 24	String
ACT_USER25	User 25	75x	User 25	String
ACT_USER26	User 26	75x	User 26	String
ACT_USER27	User 27	75x	User 27	String
ACT_USER28	User 28	75x	User 28	String
ACT_USER29	User 29	75x	User 29	String
ACT_USER30	User 30	75x	User 30	String
ACT_USER31	User 31	nnnnnnnn.nn	User 31	Double
ACT_USER32	User 32	nnnnnnnn.nn	User 32	Double
ACT_USER33	User 33	nnnnnnnn.nn	User 33	Double
ACT_USER34	User 34	nnnnnnnn.nn	User 34	Double
ACT_USER35	User 35	nnnnnnnn.nn	User 35	Double
ACT_USER36	User 36	nnnnnnnn.nn	User 36	Double
ACT_USER37	User 37	nnnnnnnn.nn	User 37	Double
ACT_USER38	User 38	nnnnnnnn.nn	User 38	Double
ACT_USER39	User 39	nnnnnnnn.nn	User 39	Double
ACT_USER40	User 40	nnnnnnnn.nn	User 40	Double
ACT_USER41	User 41	mm/dd/yyyy hh:mm am	User 41	DateTime
ACT_USER42	User 42	mm/dd/yyyy hh:mm am	User 42	DateTime
ACT_USER43	User 43	mm/dd/yyyy hh:mm am	User 43	DateTime
ACT_USER44	User 44	mm/dd/yyyy hh:mm am	User 44	DateTime
ACT_USER45	User 45	mm/dd/yyyy hh:mm am	User 45	DateTime
ACT_USER46	User 46	mm/dd/yyyy hh:mm am	User 46	DateTime
ACT_USER47	User 47	mm/dd/yyyy hh:mm am	User 47	DateTime
ACT_USER48	User 48	mm/dd/yyyy hh:mm am	User 48	DateTime
ACT_USER49	User 49	mm/dd/yyyy hh:mm am	User 49	DateTime
ACT_USER50	User 50	mm/dd/yyyy hh:mm am	User 50	DateTime
ACT_USER51	User 51		User 51	Boolean
ACT_USER52	User 52		User 52	Boolean
ACT_USER53	User 53		User 53	Boolean
ACT_USER54	User 54		User 54	Boolean
ACT_USER55	User 55		User 55	Boolean
ACT_USER56	User 56		User 56	Boolean
ACT_USER57	User 57		User 57	Boolean
ACT_USER58	User 58		User 58	Boolean
ACT_USER59	User 59		User 59	Boolean
ACT_USER60	User 60		User 60	Boolean

Related Tables

Parent tables this table links to

Target Table	Target Field	Linking Field	Purpose
CMADDR	AD_ID	ACT_ADDID	Links the account number record to an Address record.