SVC_eTech_Technician_Maint (SVC07500)

Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/SVC07500

Display Name: SVC_eTech_Technician_Maint
Physical Name: SVC07500
Technical Name: SVC_eTech_Technician_Maint

Group Display Name: Service Table Group
Group Technical Name: Service

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	SQL DB Length	Keyable Length
1	TECHID	Tech ID	STR10_LBAU	String	12	10
2	USERID	User ID	STR15_User_ID	String	16	15
	Key to the Users Master (SY01400). Click to show/hide SELECT ['SVC_eTech_Technician_Maint'].USERID AS 'SVC_eTech_Technician_Maint-User ID' ,['Users Master'].USERID AS 'Users Master-User ID' FROM SVC07500 AS ['SVC_eTech_Technician_Maint'] INNER JOIN DYNAMICS..SY01400 AS ['Users Master'] ON ['SVC_eTech_Technician_Maint'].USERID = ['Users Master'].USERID
3	ACCESSIDLST	SVC_AccessID_Last_ACC	STR20	String	22	20
4	SVC_Last_Conn_DATE	SVC_Last_Conn_DATE	DATE_LONG	Date	4	8
5	SVC_Last_Conn_TIME	SVC_Last_Conn_TIME	TM6	Time	4	6
6	SVC_Last_DisConn_DATE	SVC_Last_DisConn_DATE	DATE_LONG	Date	4	8
7	SVC_Last_DisConn_TIME	SVC_Last_DisConn_TIME	TM6	Time	4	6
8	SVC_eTech_Status	SVC_eTech_Status	INT	Integer	2	0
9	SVC_MAP_Location1	SVC MAP Location1	STR60	String	62	60
10	SVC_MAP_Location2	SVC MAP Location2	STR60	String	62	60
11	ACTIVE	Active	CB_Active	Boolean	2	0
12	SVC_LastAccessDate	SVC LastAccessDate	DT_Date	Date	4	6
13	SVC_LastAccessTime	SVC LastAccessTime	TM6	Time	4	6
14	DEX_ROW_ID		int	int	10	10
	DEX_ROW_ID is an auto-numbered IDENTITY column used internally by Dexterity for lock management; it should not be used by developers to identify any particular piece of information. Microsoft MVP Mariano Gomez has a good write up on the DEX_ROW_ID column.