SC020030 - Sales Forecast Master | Prospr - Dynamics GP Table Reference

SC020030 - Sales Forecast Master

Query Builder

Select * from SC020030

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
PLANNAME_I	Plan Name	String	16	View
USERID	User ID	String	16	View
CHANGEDATE_I	Change Date	Date	4	View
CHANGETIME_I	Change Time	Time	4	View
PLANDESCRIPTION_I	Plan Description	String	32	View
PLANFREQ_I	Plan Freq	Integer	2	View
PLANSPAN_I	Plan Span	Integer	2	View
PLANSTARTDATE_I	Plan Start Date	Date	4	View
PLANENDDATE_I	Plan End Date	Date	4	View
FORECASTSTARTDATE_I	Forecast Start Date	Date	4	View
FORECASTENDDATE_I	Forecast End Date	Date	4	View
LOCNCODE	Location Code	String	12	View
MFGNOTEINDEX_I	MFG Note Index	Currency	10	View