Tables fields where the system status is getting stored

I need to find out the Quotes which have open and completed system status.

Once I find these orders I need the check the validity dates of the Quotes.

Can experts please let me know the tables where the system status and the validity dates are stored?