CMFPATCH

Fiber Optic Patch Panel

Field Name	Caption	Mask	Description	Field Type
FK_AACCOUNT	Asset Account #	45x	Asset Account #	Text
FK_APNUMACT	Asset Proj No - Acct	40x	Asset Proj No - Acct	Text
FK_AZONE_CD	Alternate Zone	10x	Alternate Zone	String
FK_AZONE_TY	Alternate Zone Text	60x	Alternate Zone Text	String
FK_BR_CD	Default WO Cat	10x	Default WO Cat	String
FK_BR_TY	Default WO Cat Text	60x	Default WO Cat Text	String
FK_CCOLS	# of Card Columns	nnn	# of Card Columns	integer
FK_COMMENT1	Long Note		Long Note	Memo
FK_COST	Cost	nnnnnnnn.nn	Cost	Double
FK_CROWS	# of Card Rows	nnn	# of Card Rows	integer
FK_CRT_BY	Created By	40x	Created By	String
FK_CRT_DTTM	Creation Date Time	mm/dd/yyyy hh:mm am	Creation Date Time	DateTime
FK_DEPTH	Depth (in)	nnnnnnnn.nn	Depth (in)	Double
FK_DOC_FLG	Doc Available: Doc Flag		Doc Available: Doc Flag	Boolean
FK_FJ_ID	Structure Rec #	nnnnnnnn	Link to CMFSTRUC.FJ_ID	Long Integer
FK_GE_ID	Equipment Rec #	nnnnnnnn	Link to EFEQUIP.GE_ID	Long Integer
FK_GPS	GPS Flag		GPS Flag	Boolean
FK_HEIGHT	Height (in)	nnnnnnnn.nn	Height (in)	Double
FK_ID	Patch Panel Rec #	nnnnnnnn	Fiber Patch Panel AutoID	Long Integer
FK_INMAP	In Map Flag		In Map Flag	Boolean
FK_INST_DT	Installation Date	mm/dd/yyyy hh:mm am	Installation Date	DateTime
FK_INSTBY	Installed By	50x	Installed By	String
FK_LOCATION	Location	250x	Location	String
FK_LWOT_DT	Last WO Task Date	mm/dd/yyyy hh:mm am	Last WO Task Date	DateTime
FK_MAINT_CD	Maintenance By	nnn	Maintenance By	integer
FK_MAINT_TY	Maintenance By Text	50x	Maintenance By Text	String
FK_MANU_CD	Manufacturer	20x	Manufacturer	String
FK_MANU_TY	Manufacturer Text	60x	Manufacturer Text	String
FK_MOD_BY	Last Modified By:	40x	Last Modified By:	String
FK_MOD_DT	Last Modified Date:	mm/dd/yyyy hh:mm am	Last Modified Date:	DateTime
FK_MOD_TM	Modified Time	mm/dd/yyyy hh:mm am	Modified Time	DateTime
FK_MODEL	Model Number	50x	Model Number	String
FK_MZONE_CD	Maintenance Zone	10x	Maintenance Zone	String
FK_MZONE_TY	Maintenance Zone Text	60x	Maintenance Zone Text	String
FK_NOWORK	No WO/PM/Req		No WO/PM/Req	Boolean
FK_NUMBER	Alt Record #	30x	Fiber Patch Panel CommonID	String
FK_OWN_CD	Owner	nnn	Owner	integer
FK_OWN_TY	Owner Text	100x	Owner Text	String
FK_PART	Part Number	30x	Part Number	String
FK_ROWVER	Rowversion for optimistic locking		Rowversion for optimistic locking	TimeStamp
FK_SERIAL	Serial Number	50x	Serial Number	String
FK_STAT_CD	Status	nnn	Status	integer
FK_STAT_TY	Status Text	50x	Status Text	String
FK_USER10CD	User 10	20x	User 10	String
FK_USER10TY	User 10 Text	60x	User 10 Text	String
FK_USER11	User 11	150x	User 11	String
FK_USER12	User 12	150x	User 12	String
FK_USER13	User 13	150x	User 13	String
FK_USER14	User 14	150x	User 14	String
FK_USER15	User 15	150x	User 15	String
FK_USER16	User 16	nnnnnnnn.nn	User 16	Double
FK_USER17	User 17	nnnnnnnn.nn	User 17	Double
FK_USER18	User 18	nnnnnnnn.nn	User 18	Double
FK_USER19	User 19	nnnnnnnn.nn	User 19	Double
FK_USER1CD	User 1	nnn	User 1	integer
FK_USER1TY	User 1 Text	50x	User 1 Text	String
FK_USER20	User 20	nnnnnnnn.nn	User 20	Double
FK_USER21	User 21	mm/dd/yyyy hh:mm am	User 21	DateTime
FK_USER22	User 22	mm/dd/yyyy hh:mm am	User 22	DateTime
FK_USER23	User 23	mm/dd/yyyy hh:mm am	User 23	DateTime
FK_USER24	User 24	mm/dd/yyyy hh:mm am	User 24	DateTime
FK_USER25	User 25	mm/dd/yyyy hh:mm am	User 25	DateTime
FK_USER26	User 26		User 26	Boolean
FK_USER27	User 27		User 27	Boolean
FK_USER28	User 28		User 28	Boolean
FK_USER29	User 29		User 29	Boolean
FK_USER2CD	User 2	nnn	User 2	integer
FK_USER2TY	User 2 Text	50x	User 2 Text	String
FK_USER30	User 30		User 30	Boolean
FK_USER31CD	User 31	nnn	User 31	integer
FK_USER31TY	User 31 Text	50x	User 31 Text	String
FK_USER32CD	User 32	nnn	User 32	integer
FK_USER32TY	User 32 Text	50x	User 32 Text	String
FK_USER33CD	User 33	nnn	User 33	integer
FK_USER33TY	User 33 Text	50x	User 33 Text	String
FK_USER34CD	User 34	nnn	User 34	integer
FK_USER34TY	User 34 Text	50x	User 34 Text	String
FK_USER35CD	User 35	nnn	User 35	integer
FK_USER35TY	User 35 Text	50x	User 35 Text	String
FK_USER36CD	User 36	20x	User 36	String
FK_USER36TY	User 36 Text	60x	User 36 Text	String
FK_USER37CD	User 37	20x	User 37	String
FK_USER37TY	User 37 Text	60x	User 37 Text	String
FK_USER38CD	User 38	20x	User 38	String
FK_USER38TY	User 38 Text	60x	User 38 Text	String
FK_USER39CD	User 39	20x	User 39	String
FK_USER39TY	User 39 Text	60x	User 39 Text	String
FK_USER3CD	User 3	nnn	User 3	integer
FK_USER3TY	User 3 Text	50x	User 3 Text	String
FK_USER40CD	User 40	20x	User 40	String
FK_USER40TY	User 40 Text	60x	User 40 Text	String
FK_USER41	User 41	150x	User 41	String
FK_USER42	User 42	150x	User 42	String
FK_USER43	User 43	150x	User 43	String
FK_USER44	User 44	150x	User 44	String
FK_USER45	User 45	150x	User 45	String
FK_USER46	User 46	nnnnnnnn.nn	User 46	Double
FK_USER47	User 47	nnnnnnnn.nn	User 47	Double
FK_USER48	User 48	nnnnnnnn.nn	User 48	Double
FK_USER49	User 49	nnnnnnnn.nn	User 49	Double
FK_USER4CD	User 4	nnn	User 4	integer
FK_USER4TY	User 4 Text	50x	User 4 Text	String
FK_USER50	User 50	nnnnnnnn.nn	User 50	Double
FK_USER51	User 51	mm/dd/yyyy hh:mm am	User 51	DateTime
FK_USER52	User 52	mm/dd/yyyy hh:mm am	User 52	DateTime
FK_USER53	User 53	mm/dd/yyyy hh:mm am	User 53	DateTime
FK_USER54	User 54	mm/dd/yyyy hh:mm am	User 54	DateTime
FK_USER55	User 55	mm/dd/yyyy hh:mm am	User 55	DateTime
FK_USER56	User 56		User 56	Boolean
FK_USER57	User 57		User 57	Boolean
FK_USER58	User 58		User 58	Boolean
FK_USER59	User 59		User 59	Boolean
FK_USER5CD	User 5	nnn	User 5	integer
FK_USER5TY	User 5 Text	50x	User 5 Text	String
FK_USER60	User 60		User 60	Boolean
FK_USER6CD	User 6	20x	User 6	String
FK_USER6TY	User 6 Text	60x	User 6 Text	String
FK_USER7CD	User 7	20x	User 7	String
FK_USER7TY	User 7 Text	60x	User 7 Text	String
FK_USER8CD	User 8	20x	User 8	String
FK_USER8TY	User 8 Text	60x	User 8 Text	String
FK_USER9CD	User 9	20x	User 9	String
FK_USER9TY	User 9 Text	60x	User 9 Text	String
FK_WIDTH	Width (in)	nnnnnnnn.nn	Width (in)	Double
FK_WO_COMM	Short Work Order Comment	255x	Short Work Order Comment	String