PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 3/6/2008 1:01 PM by  k-rock
Screen Names
 4 Replies
Sort:
You are not authorized to post a reply.
Author Messages
k-rock
Private
Private
Veteran Member
(416 points)
Veteran Member
Posts:142


Send Message:

--
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.
    0
    John Henley
    Private
    Private
    Senior Member
    (9947 points)
    Senior Member
    Posts:3333


    Send Message:

    --
    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
    k-rock
    Private
    Private
    Veteran Member
    (416 points)
    Veteran Member
    Posts:142


    Send Message:

    --
    9/20/2007 11:39 AM
    thanks. I had the DBA dump me TITLE and PROGRAM.
    0
    wilcoxmad
    Private
    Private
    Veteran Member
    (231 points)
    Veteran Member
    Posts:87


    Send Message:

    --
    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.
    0
    k-rock
    Private
    Private
    Veteran Member
    (416 points)
    Veteran Member
    Posts:142


    Send Message:

    --
    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.
    0
    You are not authorized to post a reply.

    Forums General SOx Compliance