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 Send Private Message
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
klkemp100
Veteran Member Send Private Message
Posts: 477
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 Send Private Message
Posts: 2
New Member
9/20/2022 7:06 PM
Ragu, thanks very much! -Trevor