• Search Forums
    Advanced Search Topics Posts
Prev
Next
Forums General SOx Compliance

Screen Names

 4 Replies
 0 Subscribed to this topic
 2 Subscribed to this forum
Sort:
Author
Messages
k-rock
Veteran Member Send Private Message
Posts: 142
Veteran Member
9/19/2007 11:46 AM
Does anybody have a way to get a listing of screen names? I grabbed the data dictionary here and that was great for the "program code", but I am looking for the more specific names of each form. For example: GL20 in the data dictionary is "Accounting Units", but GL20.1 is "Accounting Units-Account". That second name is the one I am looking for now.
John Henley
Send Private Message
Posts: 3351
9/19/2007 3:51 PM
Those names are stored in the GEN table called TITLE. IF you're on LSF9, you can query that table directly via SQL.
If you're not on LSF9, you can use either rngdbdump, or DME via the browser, to dump it into CSV.
Thanks for using the LawsonGuru.com forums!
John
0
liked by Members
k-rock
Veteran Member Send Private Message
Posts: 142
Veteran Member
9/20/2007 11:39 AM
thanks. I had the DBA dump me TITLE and PROGRAM.
wilcoxmad
Veteran Member Send Private Message
Posts: 87
Veteran Member
3/5/2008 8:01 PM

Lawson also has this info on there web-site. Search for "list of (PR) programs", "List of (HR) programs", etc.

k-rock
Veteran Member Send Private Message
Posts: 142
Veteran Member
3/6/2008 1:01 PM
You must use the TITLE and PROGRAM tables from your own system to capture any customization that your org has done.