Lawson Insight Technical Documentation


ERDs Tables Elements Libraries App Forms

                              FIELD USAGE REPORT


  Element        In File    Occurs    FldType    IndexUsg   Relation
-------------------------------------------------------------------------------
  FISCAL-YEAR   ACBUDDTL             FT_DB      BDTSET1   ACBUDDTLX
                                                 BDTSET2   ACCUAMT
                                                 BDTSET3   ACMASTER
                                                 BDTSET4   
                                                 BDTSET5   
                                                 BDTSET6   

                ACBUDDTLX                       BDXSET1   ACBUDDTL
                                                 BDXSET2   ACCUAMTX
                                                 BDXSET3   ACMASTERX
                                                 BDXSET4   

                ACBUDREL                        ACBSET2   
                                                 ACBSET4   

                ACCAL                           CDHSET1   ACCALX
                                                            CALDETAIL-1
                                                            CALDETAIL-10
                                                            CALDETAIL-11
                                                            CALDETAIL-12
                                                            CALDETAIL-13
                                                            CALDETAIL-2
                                                            CALDETAIL-3
                                                            CALDETAIL-4
                                                            CALDETAIL-5
                                                            CALDETAIL-6
                                                            CALDETAIL-7
                                                            CALDETAIL-8
                                                            CALDETAIL-9

                ACCALX                          CDDSET1   ACCAL
                                                 CDDSET2   

                ACCATRANS                       TRNSET1   

                ACCHGORDX                       CHXSET1   
                                                 CHXSET2   
                                                 CHXSET3   

                ACCOMMIT                        MITSET1   ACCOMMITX
                                                 MITSET2   
                                                 MITSET3   
                                                 MITSET4   
                                                 MITSET5   

                ACCOMMITX                       MIXSET1   ACCOMMIT
                                                 MIXSET3   
                                                 MIXSET4   

                ACCONSOL                        CSLSET1   ACCONSOLX
                                                 CSLSET2   
                                                 CSLSET3   
                                                 CSLSET4   
                                                 CSLSET5   
                                                 CSLSET6   

                ACCONSOLX                       CSXSET1   ACCONSOL
                                                 CSXSET2   
                                                 CSXSET3   

                ACCUAMT                         ACUSET1   ACBUDDTL
                                                 ACUSET10  ACCUAMTX
                                                 ACUSET2   ACCUAMTX-BUD
                                                 ACUSET3   ACMASTER
                                                 ACUSET4   
                                                 ACUSET5   

                ACCUAMTX                        ACXSET1   ACBUDDTLX
                                                 ACXSET2   ACCUAMT
                                                 ACXSET3   ACMASTERX
                                                 ACXSET4   
                                                 ACXSET5   

                ACGLCONSL                       GCOSET1   ACGLCONSLX
                                                 GCOSET2   
                                                 GCOSET3   

                ACGLCONSLX                      GCXSET1   ACGLCONSL
                                                 GCXSET2   

                ACGLMAST                        GMTSET1   ACGLMASTX
                                                 GMTSET2   
                                                 GMTSET3   
                                                 GMTSET4   
                                                 GMTSET5   

                ACGLMASTX                       GMXSET1   ACGLMAST

                ACMASTER                        MSTSET1   ACMASTERX
                                                 MSTSET2   
                                                 MSTSET3   
                                                 MSTSET4   

                ACMASTERX                       MSXSET1   ACMASTER
                                                 MSXSET2   
                                                 MSXSET3   

                ACTRANS                                    ACCUAMT
                                                           ACCUAMTX
                                                           ACMASTER
                                                           ACMASTERX

                CATRANS                         CATSET3   
                                                 CATSET4   
                                                 CATSET5   
                                                 CATSET6   

                CUAMOUNT                        CAMSET1   GLTRANS-1-PRD
                                                 CAMSET2   GLTRANS-1-YEAR
                                                 CAMSET3   
                                                 CAMSET4   
                                                 CAMSET5   
                                                 CAMSET6   
                                                 CAMSET7   
                                                 CAMSET9   

                CUAMOUNTX                       CAXSET3   GLTRANS

                CUCONTROL                       CLCSET1   

                CUTRANSL                        CTRSET1   
                                                 CTRSET2   
                                                 CTRSET3   
                                                 CTRSET4   
                                                 CTRSET5   

                FBDETAIL                        FBDSET1    BUDGET
                                                 FBDSET2   FBSPREAD
                                                 FBDSET3   
                                                 FBDSET4   
                                                 FBDSET5   
                                                 FBDSET6   
                                                 FBDSET7   
                                                 FBDSET8   

                FBDTLHIST                       FDHSET1   
                                                 FDHSET2   
                                                 FDHSET3   

                FBHEADER                        FBHSET1    BUDGET-DETAIL
                                                 FBHSET2   
                                                 FBHSET3   

                FBHISTHDR                       FHHSET1   

                FBSPREAD                        FBSSET1   
                                                 FBSSET2   

                FBUDGETREL                      FBRSET2   

                FRSALES              

                GLAMOUNTS                       GAMSET1    BUDGET-1
                                                 GAMSET2    TRANS-ONE-PRD
                                                 GAMSET3    TRANS-ONE-PRDS
                                                 GAMSET4   
                                                 GAMSET5   
                                                 GAMSET6   
                                                 GAMSET7   
                                                 GAMSET8   

                GLAMOUNTSX                      GAXSET3   GLAMOUNTS
                                                           GLTRANS

                GLCLSAUDIT                      GCASET1   GLCONTROL

                GLCOMMENT                       GCMSET1   

                GLCONSOL                        GCNSET1   GLCONSOL-0
                                                 GCNSET2   GLCONSOL-1
                                                 GCNSET3   GLCONSOL-2
                                                 GCNSET4   GLCONSOL-3
                                                 GCNSET5   GLCONSOL-4
                                                           GLCONSOL-BUD-1

                GLCONTROL                       GLCSET1    COMMENTS
                                                 GLCSET2   CUCONTROL-ONE
                                                 GLCSET3   CUCONTROL-TWO
                                                 GLCSET4   GLJELOG
                                                 GLCSET5   GLJELOG-CNTRL
                                                 GLCSET6   GLJELOG-LINE
                                                           GLSYSJE
                                                           GLTRANS

                GLCONVJE             

                GLIAMBR              

                GLJELOG                         GJLSET1   GLCONTROL
                                                 GJLSET2   GLTRANS
                                                 GJLSET3   

                GLMASTREL                       GMRSET1   

                GLSYSJE                         GSJSET1   
                                                 GSJSET2   

                GLSYSTEM                                   GLCONSOL:CUAMOUNT3
                                                           GLCONSOL:CUAMOUNT4
                                                           GLCONSOL:GLAMOUNTS-ACCT
                                                            GLMASTER:BUDGET-1
                                                            GLMASTER:CONSOL
                                                            GLMASTER:TRANSACTIONS
                                                            GLNAMES:GLCONSOL
                                                            CONSOL
                                                            CONSOL-Y
                                                            CONSOL-Z
                                                           GLSYSJE-CP
                                                            JBOOKHDR:JBKSEQNBR-FY

                GLTRANS                         GLTSET1    COMMENTS
                                                 GLTSET2   CUAMOUNTX-3
                                                 GLTSET3   CUAMOUNTX-4
                                                 GLTSET4   GLCONTROL
                                                 GLTSET6   GLTRANS

                GLUNITS                         GLUSET1   
                                                 GLUSET2   
                                                 GLUSET3   
                                                 GLUSET4   
                                                 GLUSET5   
                                                 GLUSET6   
                                                 GLUSET8   

                GLUNITSX                        GUXSET3   

                INSTDETAIL                      INDSET1   

                INSTHEADER                      INHSET1   

                INSTNBR                         INBSET1   

                JBKSEQNBR                       JSQSET1   

                RADEFINE                        RADSET3   
                                                 RADSET4   

                RATOTALS                        RATSET1    ACCT-UNIT-AMTS
                                                 RATSET2   
                                                 RATSET3   
                                                 RATSET4   
                                                 RATSET5   

                RJSCHEDULE                      RJSSET1   

                SLTRANS              

                SLTRANSERR           

                ULTOTALS                        ULTSET1   


                 In File     CndUsage                 DerivedUsage
                 --------------------------------------------------------------
                ACBUDDTL    FISCAL-YEAR              
                             ZERO-FISCAL-YR           

                ACBUDDTLX   

                ACBUDREL    

                ACCAL       

                ACCALX      

                ACCATRANS   

                ACCHGORDX   

                ACCOMMIT    

                ACCOMMITX   

                ACCONSOL    FISCAL-YEAR              
                             ZERO-FISCAL-YR           

                ACCONSOLX   

                ACCUAMT     FISCAL-YEAR              
                             ZERO-FISCAL-YR           

                ACCUAMTX    

                ACGLCONSL   

                ACGLCONSLX  

                ACGLMAST    

                ACGLMASTX   

                ACMASTER    

                ACMASTERX   

                ACTRANS     

                CATRANS     

                CUAMOUNT    

                CUAMOUNTX   

                CUCONTROL   

                CUTRANSL    

                FBDETAIL    

                FBDTLHIST   

                FBHEADER    

                FBHISTHDR   

                FBSPREAD    

                FBUDGETREL  

                FRSALES     

                GLAMOUNTS   CURRENT-YEAR             

                GLAMOUNTSX  

                GLCLSAUDIT  

                GLCOMMENT   

                GLCONSOL    

                GLCONTROL   CURRENT-PERIOD           WF-JE-CTRL-NBR

                GLCONVJE    

                GLIAMBR     

                GLJELOG     

                GLMASTREL   

                GLSYSJE     

                GLSYSTEM   GLAMOUNTS:CURRENT-YEAR   LAST-FISC-YR
                            GLCONTROL:CURRENT-PERIOD NEXT-FISC-YR
                            GLTRANS:CURRENT-PERIOD   

                GLTRANS     CURRENT-PERIOD           

                GLUNITS     

                GLUNITSX    

                INSTDETAIL  

                INSTHEADER  

                INSTNBR     

                JBKSEQNBR   

                RADEFINE    

                RATOTALS    

                RJSCHEDULE  

                SLTRANS     

                SLTRANSERR  

                ULTOTALS    


                 In File     RuleUsage
                 --------------------------------------------------------------
                ACBUDDTL    

                ACBUDDTLX   

                ACBUDREL    

                ACCAL       

                ACCALX      

                ACCATRANS   

                ACCHGORDX   

                ACCOMMIT    

                ACCOMMITX   

                ACCONSOL    

                ACCONSOLX   

                ACCUAMT     

                ACCUAMTX    

                ACGLCONSL   

                ACGLCONSLX  

                ACGLMAST    

                ACGLMASTX   

                ACMASTER    

                ACMASTERX   

                ACTRANS     

                CATRANS     

                CUAMOUNT    

                CUAMOUNTX   

                CUCONTROL   

                CUTRANSL    Default

                FBDETAIL    

                FBDTLHIST   

                FBHEADER    

                FBHISTHDR   

                FBSPREAD    

                FBUDGETREL  

                FRSALES     

                GLAMOUNTS   

                GLAMOUNTSX  

                GLCLSAUDIT  

                GLCOMMENT   

                GLCONSOL    

                GLCONTROL   

                GLCONVJE    

                GLIAMBR     

                GLJELOG     

                GLMASTREL   

                GLSYSJE     

                GLSYSTEM    DefaultCUTRANSL:

                GLTRANS     

                GLUNITS     

                GLUNITSX    

                INSTDETAIL  

                INSTHEADER  

                INSTNBR     

                JBKSEQNBR   

                RADEFINE    

                RATOTALS    

                RJSCHEDULE  

                SLTRANS     

                SLTRANSERR  

                ULTOTALS