The user interface (UI) for the fiscal period master is based on values in the PSERIES fields for all records with the SERIES as 0. So what the user sees on the fiscal period setup window are records which have the series values as 0. For these records, the columns like CLOSED, ODESCTN will always be zero or blank. The FORIGIN field will always be 1 for all the records returned by the query above.
However, there are other records in the table which have a non zero value for the SERIES field, where the SERIES field represents the following modules
1 – Financial Transactions
2 – Sales/Receivables Transactions
3 – Purchasing/Payables Transactions
4 – Payroll Transactions
5 – Project Transactions
So for every type of transaction in each of these series, there will be a record, which will contain either 0 or 1 in the CLOSED field which indicates if the fiscal period is opened for the specific transaction type in the selected series. A 0 value for the CLOSED field indicates that the fiscal period is open for the specific transaction type and a value of 1 indicates that the fiscal period is closed for the specific transaction type.
So if you want to check if the fiscal period is opened for all the transactions in the Financial Series, you can use the following query.
SELECT CLOSED ,
ODESCTN ,
YEAR1 ,
PERIODID ,
PERNAME
FROM SY40100
WHERE YEAR1 = 2017
AND SERIES = 2
ORDER BY PERIODDT