Prev
Next
Forums Performance Management Lawson Business Intelligence/Reporting/Crystal

Lawson Table Relationship Question

 2 Replies
 1 Subscribed to this topic
 22 Subscribed to this forum
Sort:
Author
Messages
DataCarniv0r
New Member
Posts: 2
New Member
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
    Veteran Member
    Posts: 475
    Veteran Member
    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
      New Member
      Posts: 2
      New Member
      9/20/2022 7:06 PM
        Ragu, thanks very much!

        -Trevor