sales Order, Production Order, Purchase order

Hi ppl..

I have a req to pull and report with Pro order # and status

Purchase order # and status

for a given sales order .... item level...

need tables and relations between Production order, sales Order and Purchase Order and there status's.