Users Master (SY01400)

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

Product: Microsoft Dynamics GP (0)
Series: System

Display Name: Users Master
Physical Name: SY01400
Technical Name: SY_Users_MSTR

Group Display Name: Users Master
Group Technical Name: Users Master

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
2	USERNAME	User Name	STR30	String	32	30
3	Zoom_Fields_Font_Color	Zoom Fields Font Color	DDL_Font_Color	Integer	2	0
4	Zoom_Fields_Font_Style	Zoom Fields Font Style	DDL_Zoom_Font_Style	Integer	2	0
5	Editable_Fields_Backgrou	Editable Fields Background Color	DDL_Background_Color	Integer	2	0
6	Editable_Fields_Font_Col	Editable Fields Font Color	DDL_Font_Color	Integer	2	0
7	Editable_Fields_Pattern	Editable Fields Pattern	DDL_Field_Pattern	Integer	2	0
8	Editable_Fields_Pattern_	Editable Fields Pattern Color	DDL_Pattern_Color	Integer	2	0
9	Scrolling_Fields_Backgro	Scrolling Fields Background Color	DDL_Background_Color	Integer	2	0
10	Scrolling_Fields_Font_Co	Scrolling Fields Font Color	DDL_Font_Color	Integer	2	0
11	Scrolling_Fields_Pattern	Scrolling Fields Pattern	DDL_Field_Pattern	Integer	2	0
12	Scrolling_Fields_PatCor	Scrolling Fields Pattern Color	DDL_Pattern_Color	Integer	2	0
13	Required_Fields_Font_Col	Required Fields Font Color	DDL_Required_Font_Color	Integer	2	0
14	Required_Fields_Font_Sty	Required Fields Font Style	DDL_Required_Font_Style	Integer	2	0
15	Internet_Browser	Internet Browser	STR255	String	256	255
16	Internet_Address	Internet Address	STR255	String	256	255
17	Internet_Type	Internet Type	INT	Integer	2	0
18	Internet_Address_Name	Internet Address Name	STR80	String	82	80
19	PASSWORD	Password	STR15_LB	String	16	15
20	USRCLASS	User Class	STR15_User_Class	String	16	15
21	MDFRDENT	Method For Data Entry	GB	Integer	2	0
22	MODIFDT	Modified Date	DT	Date	4	8
23	CREATDDT	Created Date	DT	Date	4	8
24	LSTUSRED	Last User to Edit	STR15	String	16	15
25	PRTOSCRN	Print to Screen	CB_Print_to_Screen	Boolean	2	0
26	PRTOPRTR	Print to Printer	CB_Print_to_Printer	Boolean	2	0
27	SHRQFLDS	Show Required Fields	CB	Boolean	2	0
28	DISTPROC	Distributed Processes	GB	Integer	2	0
29	HSCRLARW	Horizontal Scroll Arrows	CB_HZ_Scroll_Switch	Boolean	2	0
30	SOPTYPE	SOP Type	DDL_SOP_Type	Integer	2	0
31	RELID	RelationID	Long Int	Long Integer	4	8
32	SECACCS	Security Access	ML_Security_Access	Long Integer	4	0
33	TODOOPEN	To Do Open	CB_To_Do_Open	Boolean	2	0
34	TODOPERSOPEN	To Do Personal Open	CB_To_Do_Personal_Open	Boolean	2	0
35	TODOPERSROLL	To Do Personal Roll	CB_To_Do_Personal_Roll	Boolean	2	0
36	PALETTETYPE	Palette Type	GB	Integer	2	0
37	ORGANIZATIONALVIEW	Organizational View	GB	Integer	2	0
38	ACCOUNTINGVIEW	Accounting View	CB_AccountingView	Boolean	2	0
39	USERLANG	User Language ID	INT	Integer	2	0
40	UserRole	UserRole	DDL_UserRoles	Integer	2	0
41	UserType	UserType	UserTypeDDL	Integer	2	0
42	UserStatus	UserStatus	UserStatusDDL	Integer	2	0
43	DateInactivated	DateInactivated	DATE	Date	4	6
44	Last_EWS_User_Name	Last EWS User Name	STR238	String	238	0
45	Last_EWS_Email_Address	Last EWS Email Address	STR238	String	238	0
46	WCUser	Web Client User	CB	Boolean	2	0
47	ADObjectGuid	ADObjectGuid	GUIDString	String	38	36
48	SQLLoginID	SQLLoginID	User_ID	String	16	15
49	WindowCommandDisplay	Window Command Display	DDL_Window_Command_Display	Integer	2	0
50	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.

azurecurve Products Microsoft Dynamics GP (0)SystemUsers Master (SY01400)

Leave a Reply Cancel reply