V10 Database Diagram

 6 Replies
 0 Subscribed to this topic
 1 Subscribed to this forum
Sort:
Author
Messages
RobJC
Basic Member Send Private Message
Posts: 8
Basic Member

Does it exist? Does anyone have it?  Looking for information on how the PFI tables relate.

lm_ipa.PfiWorkUnit lm_ipa.PfiWorkUnitVariable lm_ipa.PfiQueueTask lm_ipa.PfiUserCategory

Kat V
Veteran Member Send Private Message
Posts: 1020
Veteran Member
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'
Greg Moeller
Veteran Member Send Private Message
Posts: 1498
Veteran Member
You can generate your own--- See my comment on SchemaSpy here: https://www.lawsonguru.co...-po-comments-fields/
RobJC
Basic Member Send Private Message
Posts: 8
Basic Member

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

JimY
Veteran Member Send Private Message
Posts: 510
Veteran Member
There is POLINESRC. It will show if the PO Line came from a requisition or other sources such as IC140.
RobJC
Basic Member Send Private Message
Posts: 8
Basic Member

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.

Jason Beard
Veteran Member Send Private Message
Posts: 124
Veteran Member
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
Jason Beard
617-548-5568
jabeard3@gmail.com