Screen Names

Sort:
You are not authorized to post a reply.
Author
Messages
k-rock
Veteran Member
Posts: 142
Veteran Member
    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
    Senior Member
    Posts: 3348
    Senior Member
      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
      k-rock
      Veteran Member
      Posts: 142
      Veteran Member
        thanks. I had the DBA dump me TITLE and PROGRAM.
        wilcoxmad
        Veteran Member
        Posts: 87
        Veteran Member

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

          k-rock
          Veteran Member
          Posts: 142
          Veteran Member
            You must use the TITLE and PROGRAM tables from your own system to capture any customization that your org has done.
            You are not authorized to post a reply.