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.
Page 1 of 212 > >>
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
    (2285 points)
    Veteran Member
    Posts:779


    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
    (3957 points)
    Veteran Member
    Posts:1407


    Send Message:

    --
    11/08/2016 4:06 PM
    You can generate your own--- See my comment on SchemaSpy here: https://www.lawsonguru.com/forums/ux/office-addins/query-po-comments-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
    (1237 points)
    Veteran Member
    Posts:443


    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.
    You are not authorized to post a reply.
    Page 1 of 212 > >>