Who's On?

	Membership:
	Latest: Emily
	Past 24 Hours: 0
	Prev. 24 Hours: 0
	Overall: 5308

	People Online:
	Visitors: 355
	Members: 0
	Total: 355

Name	Points
Greg Moeller	4184
David Williams	3349
JonA	3290
Kat V	2984
Woozy	1973
Jimmy Chiu	1883
Kwane McNeal	1437
Ragu Raghavan	1377
Roger French	1315
mark.cook	1244

Lawson Table Relationship Question

2 Replies

1 Subscribed to this topic

22 Subscribed to this forum

Sort:

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: 477

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