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

                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   

                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    CAM-CURR-1
                                                 GAMSET3    CAM-CURR-2
                                                 GAMSET4    COMPANY-TRANS
                                                 GAMSET5    TRANS-ONE-PRD
                                                 GAMSET6   
                                                 GAMSET7   
                                                 GAMSET8   
                                                 GAMSET9   

                GLAMOUNTSX                      GAXSET3   GLTRANS

                GLCLSAUDIT                      GCASET1   GLCONTROL

                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   GLCONTROL
                                                 GLTSET6   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

                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   

                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     

                CATRANS     

                CUAMOUNT    

                CUAMOUNTX   

                CUCONTROL   

                CUTRANSL    

                CUTRATEREL  

                FBDETAIL    

                FBDTLHIST   

                FBHEADER    

                FBHISTHDR   

                FBSPREAD    

                FBUDGETREL  

                FRSALES     

                GLAMOUNTS   CURRENT-YEAR             

                GLAMOUNTSX  

                GLCLSAUDIT  

                GLCONDRILL  

                GLCONSOL    

                GLCONTROL   CURRENT-PERIOD           WF-JE-CTRL-NBR

                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   

                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  

                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     

                CATRANS     

                CUAMOUNT    

                CUAMOUNTX   

                CUCONTROL   

                CUTRANSL    Default

                CUTRATEREL  

                FBDETAIL    

                FBDTLHIST   

                FBHEADER    

                FBHISTHDR   

                FBSPREAD    

                FBUDGETREL  

                FRSALES     

                GLAMOUNTS   

                GLAMOUNTSX  

                GLCLSAUDIT  

                GLCONDRILL  

                GLCONSOL    

                GLCONTROL   

                GLIAMBR     

                GLJELOG     

                GLMASTREL   

                GLSYSJE     

                GLSYSTEM    DefaultCUTRANSL:

                GLTRANS     

                GLUNITS     

                GLUNITSX    

                INSTDETAIL  

                INSTHEADER  

                INSTNBR     

                JBKSEQNBR   

                LMINVOICE   

                MLAMOUNTS   

                MLCALMAP    

                MLCOLEDGER  

                MLCONSOL    

                MLCUAMOUNT  

                MLCUCNTRL   

                MLTRANS     

                MLUNITS     

                RADEFINE    

                RATOTALS    

                RJSCHEDULE  

                SLTRANS     

                SLTRANSERR  

                ULTOTALS