Database / Tables - LawsonGuru.com - LawsonGuru.com Forums -

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
Chris Martin	825

apk_iyer

New Member

Posts: 0

10/3/2007 5:46 AM

Hi,

I need to capture the following data for all the employees

a. Federal Marital Status
b. Federal exemption
c. Fedral Allowances
d. State Marital Status
e. State Exemption
f. State Allowances
g. Local Marital Status
h. Local Exemption
i. Local Allowances
j. Federal Exemption Status

We are using Lawson 9.0. Can anybody let me know from which database/tables these fields are defined.

Thanks in Advance

k-rock

Veteran Member

Posts: 142

10/4/2007 5:31 PM

use ctrl+shift+O (i think) in portal, it will give you that data

Chris Martin

Veteran Member

Posts: 277

New Poster

10/4/2007 8:06 PM

Good suggestion Kelly.

Here's a link to a discussion that touches on interpreting the results of CTRL+SHIFT+O.

http://lawsontalk.com/ind...topic=300&st=0&#last

John Henley

Posts: 3366

New Poster

Engaged Reader

Avid Reader

10/10/2007 2:46 PM

I've posted some slides (from user group sessions I've done on the Excel Addins) which explain how to determine the table containing a given field on a form:
https://www.lawsonguru.co...%20Field%20Names.pdf