Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

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   
                                                 BDTSET7   

                 ACBUDDTLX                       BDXSET1    ACBUDDTL
                                                 BDXSET2    ACCUAMTX
                                                 BDXSET3    ACMASTERX
                                                 BDXSET4   
                                                 BDXSET5   

                 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   
                                                 MITSET6   

                 ACCOMMITX                       MIXSET1    ACCOMMIT
                                                 MIXSET3   
                                                 MIXSET4   
                                                 MIXSET5   

                 ACCONSOL                        CSLSET1    ACCONSOLX
                                                 CSLSET2   
                                                 CSLSET4   
                                                 CSLSET5   
                                                 CSLSET6   

                 ACCONSOLX                       CSXSET1    ACCONSOL
                                                 CSXSET2   
                                                 CSXSET3   
                                                 CSXSET4   

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

                 ACCUAMTX                        ACXSET1    ACBUDDTLX
                                                 ACXSET2    ACCUAMT
                                                 ACXSET3    ACMASTERX
                                                 ACXSET4    POSTED-ACTRANS
                                                 ACXSET5   
                                                 ACXSET6   

                 ACGLCONSL                       GCOSET1    ACGLCONSLX
                                                 GCOSET2   
                                                 GCOSET3   
                                                 GCOSET4   
                                                 GCOSET5   
                                                 GCOSET6   
                                                 GCOSET7   
                                                 GCOSET8   
                                                 GCOSET9   

                 ACGLCONSLX                      GCXSET1    ACGLCONSL
                                                 GCXSET2   
                                                 GCXSET3   

                 ACGLMAST                        GMTSET1    ACGLMASTX
                                                 GMTSET10  
                                                 GMTSET2   
                                                 GMTSET3   
                                                 GMTSET4   
                                                 GMTSET5   
                                                 GMTSET6   
                                                 GMTSET7   
                                                 GMTSET8   
                                                 GMTSET9   

                 ACGLMASTX                       GMXSET1    ACGLMAST
                                                 GMXSET2    POSTED-ACTRANS
                                                 GMXSET3   

                 ACMASTER                        MSTSET1    ACMASTERX
                                                 MSTSET2   
                                                 MSTSET3   
                                                 MSTSET4   
                                                 MSTSET5   

                 ACMASTERX                       MSXSET1    ACMASTER
                                                 MSXSET2    ACTRANS
                                                 MSXSET3   
                                                 MSXSET4   

                 ACTOTALS             

                 ACTOTBAL                        TOTSET1    ACCONSOL
                                                 TOTSET2    ACCONSOL-GRP
                                                 TOTSET3    ACCUAMT
                                                 TOTSET4    ACMASTER
                                                            ACTOTBAL-CHILD
                                                            ACTOTBAL-PARNT
                                                            ACTOTBAL-TYPE
                                                            ACTOTBALX
                                                            ACTOTBALX-GRP
                                                            TOT-TYPE-GRP

                 ACTOTBALX                       TOXSET1    ACCONSOLX
                                                 TOXSET2    ACCONSOLX-GRP
                                                            ACCUAMTX
                                                            ACMASTERX
                                                            ACTOTBALX-CHLD
                                                            ACTOTBALX-PRNT

                 ACTRANS                         ATNSET10   ACCUAMT
                                                 ATNSET4    ACCUAMTX
                                                            ACGLMASTX
                                                            ACMASTER
                                                            ACMASTERX

                 ADAMOUNTSX                      BADSET3   

                 ADAVGBAL             

                 ADCFBAL              

                 CATRANS                         CATSET3   
                                                 CATSET4   
                                                 CATSET5   
                                                 CATSET6   

                 CUAMOUNT                        CAMSET1    CURR-1
                                                 CAMSET2    CURR-2
                                                 CAMSET3    GAM-SIBLING
                                                 CAMSET4    GLTRANS-1-PRD
                                                 CAMSET5    GLTRANS-1-YEAR
                                                 CAMSET6   
                                                 CAMSET7   
                                                 CAMSET8   
                                                 CAMSET9   

                 CUAMOUNTX                       CAXSET3    GLTRANS

                 CUCONTROL                       CLCSET1   

                 CUTRANSL                        CTRSET1   
                                                 CTRSET2   
                                                 CTRSET3   
                                                 CTRSET4   
                                                 CTRSET5   

                 CUTRATEREL                      CULSET3   
                                                 CULSET4   

                 FBCONTROL                       FLCSET1    FBTRANS
                                                 FLCSET2   
                                                 FLCSET3   

                 FBDETAIL                        FBDSET1    BUDGET
                                                 FBDSET2    FBSPREAD
                                                 FBDSET3   
                                                 FBDSET4   
                                                 FBDSET5   
                                                 FBDSET6   
                                                 FBDSET7   
                                                 FBDSET8   

                 FBDTLHIST                       FDHSET1   
                                                 FDHSET2   
                                                 FDHSET3   

                 FBHEADER                        FBHSET1    BUDGET-DETAIL
                                                 FBHSET2   
                                                 FBHSET3   
                                                 FBHSET4   

                 FBHISTHDR                       FHHSET1   

                 FBSPREAD                        FBSSET1   
                                                 FBSSET2   

                 FBTRANS                         FLTSET2    FBCONTROL
                                                 FLTSET3    FBTRANS

                 FBUDGETREL                      FBRSET2   

                 FRSALES              

                 GLAMOUNTS                       GAMSET1    BUDGET-1
                                                 GAMSET2    CAM-CURR-1
                                                 GAMSET3    CAM-CURR-2
                                                 GAMSET4    COMPANY-TRANS
                                                 GAMSET5    TRANS-ONE-PRD
                                                 GAMSET6   
                                                 GAMSET7   
                                                 GAMSET8   
                                                 GAMSET9   

                 GLAMOUNTSX                      GAXSET3    GLTRANS

                 GLCLSAUDIT                      GCASET1    GLCONTROL

                 GLCOMMIT                        GOTSET1    GLCOMMITX
                                                 GOTSET2   
                                                 GOTSET3   

                 GLCOMMITX                       GOXSET1    GLCOMMIT
                                                 GOXSET3   

                 GLCONDRILL                                  GLAMACCT
                                                            GLAMOUNTS

                 GLCONSOL                        GCNSET1    BASE
                                                 GCNSET2    CURR-1
                                                 GCNSET3    CURR-2
                                                 GCNSET4    GLCONSOL-0
                                                 GCNSET5    GLCONSOL-1
                                                 GCNSET6    GLCONSOL-2
                                                 GCNSET7    GLCONSOL-3
                                                            GLCONSOL-4
                                                            GLCONSOL-BUD-1

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

                 GLIAMBR              

                 GLJELOG                         GJLSET1    GLCONTROL
                                                 GJLSET2    GLTRANS
                                                 GJLSET3   

                 GLMASTREL                       GMRSET1   

                 GLSYSJE                         GSJSET1   
                                                 GSJSET2   

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

                 GLTRANS                         GLTSET1    CUAMOUNTX-3
                                                 GLTSET2    CUAMOUNTX-4
                                                 GLTSET3    GLCOMMIT
                                                 GLTSET6    GLCOMMITX
                                                 GLTSET8    GLCONTROL
                                                            GLTRANS

                 GLUNITS                         GLUSET1   
                                                 GLUSET2   
                                                 GLUSET3   
                                                 GLUSET4   
                                                 GLUSET5   
                                                 GLUSET6   
                                                 GLUSET8   

                 GLUNITSX                        GUXSET3   

                 INSTDETAIL                      INGSET1   

                 INSTHEADER                      INHSET1    INTRASTAT-DTL

                 INSTNBR                         INBSET1   

                 JBKSEQNBR                       JSQSET1   

                 LMINVOICE                       INVSET10  
                                                 INVSET9   

                 MLAMOUNTS                       MLASET1    COMPANY-TRANS
                                                 MLASET2    MCA-CURR-1
                                                 MLASET3    MCA-CURR-2
                                                 MLASET4    TRANS-ONE-PRD
                                                 MLASET5   
                                                 MLASET6   
                                                 MLASET7   
                                                 MLASET8   
                                                 MLASET9   

                 MLCALMAP                        MCMSET1   
                                                 MCMSET2   

                 MLCOLEDGER                                  MLAMOUNTS:TRANS-ONE-PRDS
                                                            MLCALMAP

                 MLCONSOL                        MCNSET1    BASE
                                                 MCNSET2    CURR-1
                                                 MCNSET3    CURR-2
                                                 MCNSET4   
                                                 MCNSET5   
                                                 MCNSET6   
                                                 MCNSET7   

                 MLCUAMOUNT                      MCASET1    CURR-1
                                                 MCASET2    CURR-2
                                                 MCASET3    MLA-SIBLING
                                                 MCASET4    MLTRANS-1-PRD
                                                 MCASET5    MLTRANS-1-YEAR
                                                 MCASET6   
                                                 MCASET7   
                                                 MCASET8   
                                                 MCASET9   

                 MLCUCNTRL                       MCCSET1   

                 MLTRANS                         MLTSET2    MLCONTROL
                                                 MLTSET3    MLTRANS
                                                 MLTSET4   
                                                 MLTSET7   

                 MLUNITS                         MLUSET1   
                                                 MLUSET2   
                                                 MLUSET3   
                                                 MLUSET4   
                                                 MLUSET5   
                                                 MLUSET6   
                                                 MLUSET7   

                 RADEFINE                        RADSET3   
                                                 RADSET4   

                 RATOTALS                        RATSET1    ACCT-UNIT-AMTS
                                                 RATSET2   
                                                 RATSET3   
                                                 RATSET4   
                                                 RATSET5   

                 RJSCHEDULE                      RJSSET1   

                 SLAMOUNTS                       SAMSET2   
                                                 SAMSET4   

                 SLCALDTL                        CDTSET1    SLCALDTL
                                                 CDTSET2   
                                                 CDTSET3   

                 SLCALHDR                        CHDSET1    SLCALDTL

                 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   

                 ACTOTALS    

                 ACTOTBAL    BLANK-YEAR               
                             HAS-YEAR                 
                             LTD-BLANK-TYPE           
                             LTD-CAT-TYPE             
                             YTD-ACCRL-TYPE           
                             YTD-BLANK-TYPE           
                             YTD-CAT-TYPE             
                             YTD-COST-TYPE            
                             YTD-FEE-TYPE             
                             YTD-REV-TYPE             

                 ACTOTBALX   

                 ACTRANS     

                 ADAMOUNTSX  

                 ADAVGBAL    

                 ADCFBAL     

                 CATRANS     

                 CUAMOUNT    

                 CUAMOUNTX   

                 CUCONTROL   

                 CUTRANSL    

                 CUTRATEREL  

                 FBCONTROL   

                 FBDETAIL    

                 FBDTLHIST   

                 FBHEADER    

                 FBHISTHDR   

                 FBSPREAD    

                 FBTRANS     

                 FBUDGETREL  

                 FRSALES     

                 GLAMOUNTS   CURRENT-YEAR             

                 GLAMOUNTSX  

                 GLCLSAUDIT  

                 GLCOMMIT    

                 GLCOMMITX   

                 GLCONDRILL  

                 GLCONSOL    

                 GLCONTROL   CURRENT-PERIOD           WF-JE-CTRL-NBR

                 GLIAMBR     

                 GLJELOG     

                 GLMASTREL   

                 GLSYSJE     

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

                 GLTRANS     CURRENT-PERIOD           

                 GLUNITS     

                 GLUNITSX    

                 INSTDETAIL  

                 INSTHEADER  

                 INSTNBR     

                 JBKSEQNBR   

                 LMINVOICE                           LMDISTRIB:INV-FISCAL-YR

                 MLAMOUNTS   CURRENT-YEAR             

                 MLCALMAP    

                 MLCOLEDGER  MLAMOUNTS:CURRENT-YEAR   
                             MLTRANS:CURRENT-PERIOD   

                 MLCONSOL    

                 MLCUAMOUNT  

                 MLCUCNTRL   

                 MLTRANS     CURRENT-PERIOD           

                 MLUNITS     

                 RADEFINE    

                 RATOTALS    

                 RJSCHEDULE  

                 SLAMOUNTS   

                 SLCALDTL    

                 SLCALHDR    

                 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   

                 ACTOTALS    

                 ACTOTBAL    

                 ACTOTBALX   

                 ACTRANS     

                 ADAMOUNTSX  

                 ADAVGBAL    

                 ADCFBAL     

                 CATRANS     

                 CUAMOUNT    

                 CUAMOUNTX   

                 CUCONTROL   

                 CUTRANSL    Default

                 CUTRATEREL  

                 FBCONTROL   

                 FBDETAIL    

                 FBDTLHIST   

                 FBHEADER    

                 FBHISTHDR   

                 FBSPREAD    

                 FBTRANS     

                 FBUDGETREL  

                 FRSALES     

                 GLAMOUNTS   

                 GLAMOUNTSX  

                 GLCLSAUDIT  

                 GLCOMMIT    

                 GLCOMMITX   

                 GLCONDRILL  

                 GLCONSOL    

                 GLCONTROL   

                 GLIAMBR     

                 GLJELOG     

                 GLMASTREL   

                 GLSYSJE     

                 GLSYSTEM    Default CUTRANSL:

                 GLTRANS     

                 GLUNITS     

                 GLUNITSX    

                 INSTDETAIL  

                 INSTHEADER  

                 INSTNBR     

                 JBKSEQNBR   

                 LMINVOICE   

                 MLAMOUNTS   

                 MLCALMAP    

                 MLCOLEDGER  

                 MLCONSOL    

                 MLCUAMOUNT  

                 MLCUCNTRL   

                 MLTRANS     

                 MLUNITS     

                 RADEFINE    

                 RATOTALS    

                 RJSCHEDULE  

                 SLAMOUNTS   

                 SLCALDTL    

                 SLCALHDR    

                 SLTRANS     

                 SLTRANSERR  

                 ULTOTALS