Who's On?

	Membership:
	Latest: sakkatan
	Past 24 Hours: 0
	Prev. 24 Hours: 0
	Overall: 5216

	People Online:
	Visitors: 26
	Members: 0
	Total: 26

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

Reason Descriptions in PA52

4 Replies

0 Subscribed to this topic

69 Subscribed to this forum

Sort:

Author

Messages

Dave Williams

Advanced Member

Posts: 27

6/30/2014 7:27 PM

I can not find the Table and Field that stores the Reason Description on PA52.1 or 52.5.
When I do a Ctrl-Sht-O, LAWSON tells me it is "PCT-Reason1" I believe this is referring to Table PERSACTION (which does have a "Reason_01" field in it BUT, I don't want the CODE, I want the Description that is linked to the CODE. I have looked in PADICT and PADICT2 but don't see it there either.

Anyone know where I can find the Descriptions?

Thanks,

Dave Williams

John Henley

Posts: 3364

New Poster

Engaged Reader

Avid Reader

6/30/2014 7:38 PM

Table is PCODES (PCO)
WHERE PCO.TYPE = 'RA' AND PCO.CODE = PCT.REASON

The.Sam.Groves

Veteran Member

Posts: 89

6/30/2014 8:13 PM

Would this be version dependent? On my system they aren't in PCODE but PAACTREAS. At least database-wise they aren't.

Dave Williams

Advanced Member

Posts: 27

6/30/2014 8:16 PM

Thanks John!

John Henley

Posts: 3364

New Poster

Engaged Reader

Avid Reader

6/30/2014 8:27 PM

Posted By The.Sam.Groves on 06/30/2014 04:13 PM
Would this be version dependent? On my system they aren't in PCODE but PAACTREAS. At least database-wise they aren't.

Good catch. They were moved to PAACTREAS in 9.0.1.