Users Master (SY01400)

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