V10 Database Diagram

 6 Replies
 0 Subscribed to this topic
 1 Subscribed to this forum
Sort:
Author
Messages
RobJC
Basic Member
Posts: 8
Basic Member
New Poster
New Poster
Congrats on posting!

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
Posts: 1020
Veteran Member
New Poster
New Poster
Congrats on posting!
Engaged Reader
Engaged Reader
You are an engaged reader!
Avid Reader
Avid Reader
Avid Reader art thou!
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
Posts: 1498
Veteran Member
MVP
MVP
You're an MVP!
New Poster
New Poster
Congrats on posting!
Engaged Reader
Engaged Reader
You are an engaged reader!
Avid Reader
Avid Reader
Avid Reader art thou!
You can generate your own--- See my comment on SchemaSpy here: https://www.lawsonguru.co...-po-comments-fields/
RobJC
Basic Member
Posts: 8
Basic Member
New Poster
New Poster
Congrats on posting!

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
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
Posts: 8
Basic Member
New Poster
New Poster
Congrats on posting!

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
Posts: 125
Veteran Member
New Poster
New Poster
Congrats on posting!
Engaged Reader
Engaged Reader
You are an engaged reader!
Avid Reader
Avid Reader
Avid Reader art thou!
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