PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 04/27/2017 12:59 PM by  Jason Beard
V10 Database Diagram
 6 Replies
Sort:
You are not authorized to post a reply.
Author Messages
RobJC
Applications Support
RUSD
Basic Member
(14 points)
Basic Member
Posts:8


Send Message:

--
10/21/2016 2:30 PM

    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
    Sr Supply Chain System Analyst
    South Broward Hospital District
    Veteran Member
    (1831 points)
    Veteran Member
    Posts:625


    Send Message:

    --
    10/24/2016 3:02 PM
    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
    Private
    Private
    Veteran Member
    (3873 points)
    Veteran Member
    Posts:1377


    Send Message:

    --
    11/08/2016 4:06 PM
    You can generate your own--- See my comment on SchemaSpy here: https://www.lawsonguru.com/forums/u...ts-fields/
    RobJC
    Applications Support
    RUSD
    Basic Member
    (14 points)
    Basic Member
    Posts:8


    Send Message:

    --
    04/06/2017 9:10 AM

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

    JimY
    Private
    Private
    Veteran Member
    (1089 points)
    Veteran Member
    Posts:389


    Send Message:

    --
    04/06/2017 9:40 AM
    There is POLINESRC. It will show if the PO Line came from a requisition or other sources such as IC140.
    RobJC
    Applications Support
    RUSD
    Basic Member
    (14 points)
    Basic Member
    Posts:8


    Send Message:

    --
    04/06/2017 9:45 AM

    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
    Private
    Private
    Veteran Member
    (219 points)
    Veteran Member
    Posts:79


    Send Message:

    --
    04/27/2017 12:59 PM
    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
    You are not authorized to post a reply.