GEN Database Programs and Screens

 2 Replies
 0 Subscribed to this topic
 22 Subscribed to this forum
Sort:
Author
Messages
Layne
Basic Member
Posts: 24
Basic Member
    I am running the following query on GEN. I wanted to see what fields are being used by a certain Program and Screen.

    SELECT *
    FROM dbo.PGMFLD
    WHERE PROGRAMCODE = 'HR11'
    AND SCRNBR = 1
    AND PRODUCTLINE = 'LAWPROD'

    What is the prefix field used for. Is there a list of the defintions of these fields? Let's say I was in the Lawson Portal on Screen HR11.1. I want to know what tables and fields that this form uses, so I can write a report. I am not worried about how to connect back to other tables to get the actual tables used in this form and screen. I know how to do that. What prefix would I use. Do I further constrain on prefix = 'EMP'. If this is correct, then why are the other prefixes evern listed here. Doing a distinct on prefix using the same query gives me the following:



    AAX
    AJH
    APL
    BEN
    BNB
    BNG
    BNH
    BTE
    CCH
    CCT
    CTC
    CUC
    DDC
    DIP
    DPT
    EDM
    EFD
    EMP
    EMS
    EPC
    ETM
    GCD
    GDT
    GIC
    GLS
    HER
    HEU
    HRH
    HRU
    HSL
    HSU
    INT
    ITV
    JBC
    LTR
    MIL
    OTD
    PA2
    PAA
    PAB
    PAC
    PAD
    PAH
    PAP
    PAS
    PAT
    PBG
    PCD
    PCO
    PCT
    PDD
    PDH
    PEA
    PEM
    PEP
    PEU
    PGE
    PGS
    PJR
    PLM
    PLN
    PMD
    PMN
    POS
    PPC
    PPP
    PPR
    PPV
    PQC
    PRA
    PRC
    PRF
    PRG
    PRH
    PRO
    PRQ
    PRR
    PRS
    PRX
    PSA
    PTF
    PTS
    PW4
    PWU
    PXL
    PYD
    PYM
    QTD
    QTW
    REG
    RGP
    RQC
    SGD
    SGH
    STM
    TAP
    TAR
    TBL
    TEM
    TEN
    TES
    TGE
    TGR
    TLM
    TPR
    TRD
    TSC
    TST
    TTR
    TXG
    WSC
    WUP
    David Williams
    Veteran Member
    Posts: 1127
    Veteran Member
      Lawson's Technical Text documentation should give you what you need.
      David Williams
      Greg Moeller
      Veteran Member
      Posts: 1498
      Veteran Member
        Or you could do it another way.
        Select prefix, filename, productline
        from gen.filedef