SY70500 - System Report Options | Prospr - Dynamics GP Table Reference

SY70500 - System Report Options

Query Builder

Select * from SY70500

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
STDPSSRS	Start DPS Series	Integer	2	View
ENDPSERS	End DPS Series	Integer	2	View
STSERVID	Start Server ID	String	82	View
ENDSRVID	End Server ID	String	82	View
FINRPTNM	Financial Report Name	String	32	View
PRNTNOTS	Print Notes	Boolean	2	View
PRNTTYPE	Print Type	Integer	2	View
STRTCMNM	Start Company Name	String	66	View
STRTZPCD	Start Zip Code	String	12	View
STWSTNTY	Start Work Station Type	String	16	View
STTCATEG	Start Category	Integer	2	View
ENDCATEG	End Category	Integer	2	View
ENDCMPNM	End Company Name	String	66	View
ENDZIPCD	End Zip Code	String	12	View
ENDWSTYP	End Work Station Type	String	16	View
ASKECHTM	Ask Each Time	Boolean	2	View
INCLGNDS	Include Legends	Boolean	2	View
PRNTOFIL	Print to File	Boolean	2	View
PRTOPRTR	Print to Printer	Boolean	2	View
PRTOSCRN	Print to Screen	Boolean	2	View
IFFILXST	If File Existing	Integer	2	View
FILEXPNM	File Export Name	String	256	View
EXPTTYPE	Export Type	Integer	2	View
RPTGRIND	Report Group Index	Integer	2	View
RTPACHIN	Report Palette Choice Index	Integer	2	View
RTGRSBIN	Report Group Sub Index	Currency	10	View
SORTBY	Sort By	Integer	2	View
RPTYPSEC	Report Type Security	Integer	2	View
ENDUSRID	End User ID	String	16	View
ENDUSRNM	End User Name	String	32	View
ENDUSRCL	End User Class	String	16	View
ENDINGDT	Ending Date	Date	4	View
ENDTKNDT	End Token Date	Integer	2	View
ENDFRSRS	End Form Series	Integer	2	View
STTUSRID	Start User ID	String	16	View
STTUSRNM	Start User Name	String	32	View
STTUSRCL	Start User Class	String	16	View
STRTNGDT	Starting Date	Date	4	View
STTOKNDT	Start Token Date	Integer	2	View
STTFMSRS	Start Form Series	Integer	2	View
STCURRID	Start Currency ID	String	16	View
ENDCURID	End Currency ID	String	16	View
STCURRDESC	Start Currency Description	String	32	View
ENDCURRDESC	End Currency Description	String	32	View
STEXTABID	Start Exchange Table ID	String	16	View
ENDEXTABID	End Exchange Table ID	String	16	View
STEXTABDESC	Start Exchange Table Description	String	32	View
ENDEXTABDESC	End Exchange Table Description	String	32	View
STICID	Start Intercompany ID	String	6	View
ENDICID	End Intercompany ID	String	6	View
STSECMODALTID	Start Security ModAlt Forms ID	String	26	View
STSECROLEID	Start Security Role ID	String	26	View
STSECTASKCAT	Start Security Task Category	Integer	2	View
STSECTASKID	Start Security Task ID	String	26	View
ENDSECMODALTID	End Security ModAlt Forms ID	String	26	View
ENDSECROLEID	End Security Role ID	String	26	View
ENDSECTASKCAT	End Security Task Category	Integer	2	View
ENDSECTASKID	End Security Task ID	String	26	View
IncludeInactiveUsers	IncludeInactiveUsers	Boolean	2	View

SY70500 - System Report Options

Query Builder

Customer Service

Information

My Account

Contact Us