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
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.
    0
    John Henley
    Posts: 3353
    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
      Veteran Member
      Posts: 142
      Veteran Member
      9/20/2007 11:39 AM
        thanks. I had the DBA dump me TITLE and PROGRAM.
        0
        wilcoxmad
        Veteran Member
        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.

          0
          k-rock
          Veteran Member
          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.
            0