HR_To_Do_Personal (HR4TOD02)

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

Display Name: HR_To_Do_Personal
Physical Name: HR4TOD02
Technical Name: HR_To_Do_Personal

Group Display Name: HR Multi-Company
Group Technical Name: HR_MultiCmp_File

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	SQL DB Length	Keyable Length
1	USERID	User ID	STR15_User_ID	String	16	15
	Key to the Users Master (SY01400). Click to show/hide SELECT ['HR_To_Do_Personal'].USERID AS 'HR_To_Do_Personal-User ID' ,['Users Master'].USERID AS 'Users Master-User ID' FROM HR4TOD02 AS ['HR_To_Do_Personal'] INNER JOIN DYNAMICS..SY01400 AS ['Users Master'] ON ['HR_To_Do_Personal'].USERID = ['Users Master'].USERID
2	TODOSEQUENCE_I	To Do Sequence	INT60	Long Integer	4	6
3	DATETODO_I	Date To Do	DT	Date	4	8
4	TIMETODO_I	Time To Do	TM	Time	4	6
5	CATEGORYTODOLIST_I	Category To Do List	DDL_Category_To_Do	Integer	2	0
6	PRIORITYTODOLIST_I	Priority To Do List	DDL_Priority_To_Do	Integer	2	0
7	STATUSTODOLIST_I	Status To Do List	DDL_Status_To_Do	Integer	2	0
8	ACTIVITYTODO_I	Activity To Do	STR80	String	82	80
9	USERID2_I	User ID2	STR15_User_ID	String	16	15
10	Date_To_Do_Original	Date To Do Original	DT	Date	4	8
11	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.