Who's On?

	Membership:
	Latest: Raju
	Past 24 Hours: 1
	Prev. 24 Hours: 2
	Overall: 5205

	People Online:
	Visitors: 287
	Members: 0
	Total: 287

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

Linking GLTrans table with APDISTRIB

2 Replies

0 Subscribed to this topic

22 Subscribed to this forum

Sort:

Author

Messages

JL Cabrera

New Member

Posts: 1

2/4/2010 10:32 PM

Can anyone help me with the relationship between the gltrans table and the apdistrib? I need to join both tables for reporting purposes. Thanks in advance for the help.

John Henley

Posts: 3353

2/5/2010 1:55 AM

https://www.lawsonguru.co.../topic/Default.aspx=

John Costa

Veteran Member

Posts: 154

2/5/2010 1:13 PM

SELECT GLT.COMPANY, GLT.FISCAL_YEAR, GLT.ACCT_PERIOD, GLT.CONTROL_GROUP, GLT.SYSTEM, GLT.ACCT_UNIT, GLT.ACCOUNT, GLT.SOURCE_CODE,
LTRIM(RTRIM(GLT.DESCRIPTION)) AS DESCRIPTION, GLT.ACTIVITY, GLT.ACCT_CATEGORY, GLT.STATUS, GLT.TRAN_AMOUNT, APD.INVOICE,
GLT.OBJ_ID
FROM dbo.GLTRANS AS GLT WITH (NOLOCK) LEFT OUTER JOIN
dbo.APDISTRIB AS APD WITH (NOLOCK) ON GLT.OBJ_ID = APD.GLT_OBJ_ID