Who's On?

	Membership:
	Latest: Saef
	Past 24 Hours: 0
	Prev. 24 Hours: 0
	Overall: 5226

	People Online:
	Visitors: 145
	Members: 0
	Total: 145

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

How do I identify the data in a particular field in the HREMPLOYEE table?

1 Replies

0 Subscribed to this topic

68 Subscribed to this forum

Sort:

Author

Messages

Bev Edwards

Veteran Member

Posts: 366

8/22/2011 3:37 PM

I ran a query of the entire table and the field numbers are listed sequentially in a Field ID column. How can I go into the table to see data is in a particular field.
For instance, field 20 is the Employee Status, but how do I go into Lawson and actually SEE the status IN field 20? I'm not sure where to look because I'm new to Lawson.:confused:

John Henley

Posts: 3353

8/22/2011 7:07 PM

Hi Bev,
The field definitions are stored in data is stored in the PADICT table; the data that is stored in HRHISTORY is stored in either A_VALUE (for alpha fields), D_VALUE (for date fields), or N_VALUE (for numeric fields). So, for field id 20, look at the A_VALUE, since Employee Status is alpha.

You can use the Excel addins to dump out the contents of the PADICT table; also I have a simple Crystal Report for sale in the store that reports the definitions:
https://www.lawsonguru.co...duct&product=3612943