Need to extract payroll totals by pay code

Hi All,

I am hoping someone can help me quickly.

I need to extract payroll information from the system. I need to know our pay code, how much Gross pay and how much tax was paid by each pay code.

I have looked in F0719 and F0618 and can get the gross pay and the taxes

I have looked in the Pay Check History Summary table (F06156) which gives me Gross, Net, Deductions, Benefits and Taxes for each pay - I would like to know what pay code is associated with each of those

Is this even possible?