• Search Forums
    Advanced Search
Prev
Next
Forums Performance Management Lawson Business Intelligence/Reporting/Crystal

Lawson Table Relationship Question

 2 Replies
 1 Subscribed to this topic
 24 Subscribed to this forum
Sort:
Author
Messages
DataCarniv0r
New Member
Posts: 2
New Member
New Poster
New Poster
Congrats on posting!
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: 477
Veteran Member
New Poster
New Poster
Congrats on posting!
Engaged Poster
Engaged Poster
Wow, you're on a roll!
Avid Poster
Avid Poster
Seriously, you're a posting maniac!
Engaged Reader
Engaged Reader
You are an engaged reader!
Avid Reader
Avid Reader
Avid Reader art thou!
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
New Poster
New Poster
Congrats on posting!
9/20/2022 7:06 PM
Ragu, thanks very much!

-Trevor