PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 9/20/2022 7:06 PM by  DataCarniv0r
Lawson Table Relationship Question
 2 Replies
Sort:
You are not authorized to post a reply.
Author Messages
DataCarniv0r
Analyst
Private
New Member
(4 points)
New Member
Posts:2


Send Message:

--
9/20/2022 1:49 PM
    Hello, I'm new to Lawson data. I have been provided 5 Lawson tables and only 5 tables in a data warehouse to report from.

    I'm hoping to get help understanding how to link them including which fields to link on, any composite joins, etc. I found some ERD's online, but couldn't find one that would fully visualize what I'm trying to do.

    The tables I need to link for reporting include:
    APINVOICE
    APDISTRIB
    APPAYMENTS
    APVENMAST
    TERMS

    Help appreciated. Thank you!
    Trevor

    Ragu Raghavan
    Private
    Private
    Veteran Member
    (1318 points)
    Veteran Member
    Posts:458


    Send Message:

    --
    9/20/2022 3:39 PM
    try this site
    https://www.nogalis.com/l...reens-documentation/
    under each table, there is a section that shows the relationships
    DataCarniv0r
    Analyst
    Private
    New Member
    (4 points)
    New Member
    Posts:2


    Send Message:

    --
    9/20/2022 7:06 PM
    Ragu, thanks very much!

    -Trevor
    You are not authorized to post a reply.

    Forums Performance Management Lawson Business Intelligence/Reporting/Crystal