SY40100 - Period Setup | Prospr - Dynamics GP Table Reference

SY40100 - Period Setup

Select * from SY40100

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
CLOSED	Origin Closed	Boolean	2	View
SERIES	Series 1 = All 2 = Financial 3 = Sales 4 = Purchasing 5 = Inventory 6 = Payroll - USA 7 = Project	Integer	2	View
ODESCTN	Origin Description	String	52	View
FORIGIN	First Origin	Boolean	2	View
PERIODID	Period ID	Integer	2	View
PERIODDT	Period Date	Date	4	View
PERNAME	Period Name	String	22	View
PSERIES_1	Period Series[1]	Boolean	2	View
PSERIES_2	Period Series[2]	Boolean	2	View
PSERIES_3	Period Series[3]	Boolean	2	View
PSERIES_4	Period Series[4]	Boolean	2	View
PSERIES_5	Period Series[5]	Boolean	2	View
PSERIES_6	Period Series[6]	Boolean	2	View
YEAR1	Year	Integer	2	View
PERDENDT	Period-Ending Date	Date	4	View