Forums
Lawson Business Intelligence/Reporting/Crystal
Lawson Table Relationship Question
Author
Messages
DataCarniv0r
New Member
Posts: 2
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: 468
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
9/20/2022 7:06 PM
Ragu, thanks very much!
-Trevor