Database / Tables

 3 Replies
 0 Subscribed to this topic
 17 Subscribed to this forum
Sort:
Author
Messages
apk_iyer
New Member Send Private Message
Posts: 0
New Member
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 Send Private Message
Posts: 142
Veteran Member
use ctrl+shift+O (i think) in portal, it will give you that data
Chris Martin
Veteran Member Send Private Message
Posts: 277
Veteran Member
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
Send Private Message
Posts: 3351
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
Thanks for using the LawsonGuru.com forums!
John