V10 Database Diagram

I don't know about User Category - but if it helps - when I run a sql to see who approved a requisition the table joins are: from lawsonipa.PfiMetrics M inner join lawsonipa.PfiQueueTask Q on M.PfiWorkunit = Q.PfiWorkunit and M.PfiActivity = Q.PfiActivity and M.PfiQueueAssignment = Q.PfiQueueAssignment inner join lawsonipa.PfiWorkunit W on W.PfiWorkunit = M.PfiWorkunit inner join lawsonipa.PfiWorkunitVariable V on V.PfiWorkunit = W.PfiWorkunit and V.PfiWorkunitVariable = 'RQH_REQ_NUMBER'

You can generate your own--- See my comment on SchemaSpy here: https://www.lawsonguru.co...-po-comments-fields/

Anyone know how to tie Requisitions to PO's with the V10 database tables? I can not seem to find the linkage.

There is POLINESRC. It will show if the PO Line came from a requisition or other sources such as IC140.

Thanks. I saw that table, but not sure how to link that back to the REQ tables. Not sure yet what the key field are, or if there is another table involved.

POLINESRC links to the REQLINE table based on PLS.OPER_COMPANY=RQL.COMPANY and PLS.SOURCE_DOC_N=RQL.REQ_NUMBER and PLS.SRC_LINE_NBR=RQL.LINE_NBR