Sales order status in table


I want to know sales order status in ‘Salestable’, in database.

I want to figure out

1-- Sale order which are Invoiced

2-- Sale order confirm but not invoice

3- Sale order created not confirm nor invoice.

can someone tell me which status field I have to check above status of a sale order???

Thanks in Advance…

Combination of Salesstatus and Documentstatus fields in salestable will give you the data you are looking for.