It has been asked of me to run some custom queries and build reports for each package(OE, AP, AR, PR, ect.) using their corresponding Periods(Period Start and End Dates). The problem I am running into is I can't seem to find the table where the packages are stored with their package_codes(AP, OE, AR) and their Period_Ids. I have found where the Periods are stored. They can be found in syprdfil_sql. Each entry has a unique prd_key. I know this is where the periods are stored because inside Progression Explorer >> System Manager >> Maintain >> System Periods >> I was able to make changes to each of them, one at a time, and determine which prd_key goes to what package. At the same time verified there was one row in syprdfil_sql for each package displayed in the drop-down boxes(AP, AR, OE, PR, ect).

Where are the table(s) that hold this information for the different packages? I have attached a couple of screenshots to help everyone understand what I'm asking for.

Many thanks for any help!

It is the SYPRDFIL_SQL table you are looking for. I am guessing you cannot determine which record belongs to which module. Am I correct?

Yes, I have found the syprdfil_sql table and figured out that's where the period records are stored. You are correct, the only way I was able to determine which record belongs to which module was to make a change to a period for each module one at a time and observe which changed by querying the syprdfil_sql table. If there is a table that stores module data including which period record belongs to which module, I'd rather include that table in my queries. Many thanks for the help dgillz!

A fellow member of tek-tips, Macola10, was able to get me an answer. This information is actually in the Knowledge Base. I am posting what he posted on tek-tips...