Requisition Preparer name in PO tables

Hi,

We still use requisition form to create requisitions.

Does preparer information flow to Purchase order tables ?

Does preparer information flow to invoice tables ?

Please give SQL queries to find the preparer name from requisition number

Please give SQL queries to find the preparer name from PO number

Please give SQL queries to find the preparer name from Invoice number

Thanks,