SY01400 - Users Master | Prospr - Dynamics GP Table Reference

SY01400 - Users Master

Query Builder

Select * from SY01400

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
USERID	User ID	String	16	View
USERNAME	User Name	String	32	View
Zoom_Fields_Font_Color	Zoom Fields Font Color	Integer	2	View
Zoom_Fields_Font_Style	Zoom Fields Font Style	Integer	2	View
Editable_Fields_Backgrou	Editable Fields Background Color	Integer	2	View
Editable_Fields_Font_Col	Editable Fields Font Color	Integer	2	View
Editable_Fields_Pattern	Editable Fields Pattern	Integer	2	View
Editable_Fields_Pattern_	Editable Fields Pattern Color	Integer	2	View
Scrolling_Fields_Backgro	Scrolling Fields Background Color	Integer	2	View
Scrolling_Fields_Font_Co	Scrolling Fields Font Color	Integer	2	View
Scrolling_Fields_Pattern	Scrolling Fields Pattern	Integer	2	View
Scrolling_Fields_PatCor	Scrolling Fields Pattern Color	Integer	2	View
Required_Fields_Font_Col	Required Fields Font Color	Integer	2	View
Required_Fields_Font_Sty	Required Fields Font Style	Integer	2	View
Internet_Browser	Internet Browser	String	256	View
Internet_Address	Internet Address	String	256	View
Internet_Type	Internet Type	Integer	2	View
Internet_Address_Name	Internet Address Name	String	82	View
PASSWORD	Password	String	16	View
USRCLASS	User Class	String	16	View
MDFRDENT	Method For Data Entry	Integer	2	View
MODIFDT	Modified Date	Date	4	View
CREATDDT	Created Date	Date	4	View
LSTUSRED	Last User to Edit	String	16	View
PRTOSCRN	Print to Screen	Boolean	2	View
PRTOPRTR	Print to Printer	Boolean	2	View
SHRQFLDS	Show Required Fields	Boolean	2	View
DISTPROC	Distributed Processes	Integer	2	View
HSCRLARW	Horizontal Scroll Arrows	Boolean	2	View
SOPTYPE	SOP Type 1 = Quote 2 = Order 3 = Invoice 4 = Return 5 = Back Order 6 = Fulfillment Order (In SBF, this value is not available.)	Integer	2	View
RELID	RelationID	Long Integer	4	View
SECACCS	Security Access	Long Integer	4	View
TODOOPEN	To Do Open	Boolean	2	View
TODOPERSOPEN	To Do Personal Open	Boolean	2	View
TODOPERSROLL	To Do Personal Roll	Boolean	2	View
PALETTETYPE	Palette Type	Integer	2	View
ORGANIZATIONALVIEW	Organizational View	Integer	2	View
ACCOUNTINGVIEW	Accounting View	Boolean	2	View
USERLANG	User Language ID	Integer	2	View
UserRole	UserRole	Integer	2	View
UserType	UserType	Integer	2	View
UserStatus	UserStatus	Integer	2	View
DateInactivated	DateInactivated	Date	4	View
Last_EWS_User_Name	Last EWS User Name	String	238	View
Last_EWS_Email_Address	Last EWS Email Address	String	238	View

SY01400 - Users Master

Query Builder

Customer Service

Information

My Account

Contact Us