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	Length
1	TECHID	Tech ID	String	STR10_LBAU	10
2	USERID	User ID	String	STR15_User_ID	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	String	STR20	20
4	SVC_Last_Conn_DATE	SVC_Last_Conn_DATE	Date	DATE_LONG	8
5	SVC_Last_Conn_TIME	SVC_Last_Conn_TIME	Time	TM6	6
6	SVC_Last_DisConn_DATE	SVC_Last_DisConn_DATE	Date	DATE_LONG	8
7	SVC_Last_DisConn_TIME	SVC_Last_DisConn_TIME	Time	TM6	6
8	SVC_eTech_Status	SVC_eTech_Status	Integer	INT	0
9	SVC_MAP_Location1	SVC MAP Location1	String	STR60	60
10	SVC_MAP_Location2	SVC MAP Location2	String	STR60	60
11	ACTIVE	Active	Boolean	CB_Active	0
12	SVC_LastAccessDate	SVC LastAccessDate	Date	DT_Date	6
13	SVC_LastAccessTime	SVC LastAccessTime	Time	TM6	6