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

    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
      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
        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

          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

              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: 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