SY20000 - Report Template Master | Prospr - Dynamics GP Table Reference

SY20000 - Report Template Master

Query Builder

Select * from SY20000

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
TemplateID	TemplateID	Long Integer	4	View
DSPLNAME	Display Name	String	82	View
fileName	fileName	String	256	View
PredefinedTemplateID	PredefinedTemplateID	Long Integer	4	View
EntityDriven	EntityDriven	Boolean	2	View
PRODID	Product ID	Integer	2	View
RESID	Resid	Integer	2	View
ReportStatus	ReportStatus	Integer	2	View
Report_Series_DictID	Report Series DictID	Integer	2	View
ReportSeries_ID	Report Series ID	Integer	2	View
MODIFDT	Modified Date	Date	4	View
MDFUSRID	Modified User ID	String	16	View
CREATDDT	Created Date	Date	4	View
CRUSRID	Created User ID	String	16	View