SYIC1400 - Users Master | Prospr - Dynamics GP Table Reference

SYIC1400 - Users Master

Query Builder

Select * from SYIC1400

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
USERID	User ID	String	16	View
USERID2_I	User ID2	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

SYIC1400 - Users Master

Query Builder

Customer Service

Information

My Account

Contact Us