Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

FISCAL-YEAR


                              FIELD USAGE REPORT


    FIELDNAME - FISCAL-YEAR   

  FieldName      In File     Element        Occurs    FldType    IndexUsg
-------------------------------------------------------------------------------
  FISCAL-YEAR    ACBUDDTL    YEAR                     FT_DB      BDTSET1   
                             Numeric,  4                         BDTSET2   
                                                                 BDTSET3   
                                                                 BDTSET4   
                                                                 BDTSET5   
                                                                 BDTSET6   
                                                                 BDTSET7   

                 ACBUDDTLX   YEAR                     FT_DB      BDXSET1   
                             Numeric,  4                         BDXSET2   
                                                                 BDXSET3   
                                                                 BDXSET4   
                                                                 BDXSET5   

                 ACBUDREL    YEAR                     FT_DB      ACBSET2   
                             Numeric,  4                         ACBSET4   

                 ACCAL       YEAR                     FT_DB      CDHSET1   
                             Numeric,  4       

                 ACCALX      YEAR                     FT_DB      CDDSET1   
                             Numeric,  4                         CDDSET2   

                 ACCATRANS   YEAR                     FT_DB      TRNSET1   
                             Numeric,  4       

                 ACCHGORDX   YEAR                     FT_DB      CHXSET1   
                             Numeric,  4                         CHXSET2   
                                                                 CHXSET3   

                 ACCOMMIT    YEAR                     FT_DB      MITSET1   
                             Numeric,  4                         MITSET2   
                                                                 MITSET3   
                                                                 MITSET4   
                                                                 MITSET5   
                                                                 MITSET6   

                 ACCOMMITX   YEAR                     FT_DB      MIXSET1   
                             Numeric,  4                         MIXSET3   
                                                                 MIXSET4   
                                                                 MIXSET5   

                 ACCONSOL    YEAR                     FT_DB      CSLSET1   
                             Numeric,  4                         CSLSET2   
                                                                 CSLSET4   
                                                                 CSLSET5   
                                                                 CSLSET6   

                 ACCONSOLX   YEAR                     FT_DB      CSXSET1   
                             Numeric,  4                         CSXSET2   
                                                                 CSXSET3   
                                                                 CSXSET4   

                 ACCUAMT     YEAR                     FT_DB      ACUSET1   
                             Numeric,  4                         ACUSET10  
                                                                 ACUSET2   
                                                                 ACUSET3   
                                                                 ACUSET4   
                                                                 ACUSET5   
                                                                 ACUSET6   

                 ACCUAMTX    YEAR                     FT_DB      ACXSET1   
                             Numeric,  4                         ACXSET2   
                                                                 ACXSET3   
                                                                 ACXSET4   
                                                                 ACXSET5   
                                                                 ACXSET6   

                 ACGLCONSL   YEAR                     FT_DB      GCOSET1   
                             Numeric,  4                         GCOSET2   
                                                                 GCOSET3   
                                                                 GCOSET4   
                                                                 GCOSET5   
                                                                 GCOSET6   
                                                                 GCOSET7   
                                                                 GCOSET8   
                                                                 GCOSET9   

                 ACGLCONSLX  YEAR                     FT_DB      GCXSET1   
                             Numeric,  4                         GCXSET2   
                                                                 GCXSET3   

                 ACGLMAST    YEAR                     FT_DB      GMTSET1   
                             Numeric,  4                         GMTSET10  
                                                                 GMTSET2   
                                                                 GMTSET3   
                                                                 GMTSET4   
                                                                 GMTSET5   
                                                                 GMTSET6   
                                                                 GMTSET7   
                                                                 GMTSET8   
                                                                 GMTSET9   

                 ACGLMASTX   YEAR                     FT_DB      GMXSET1   
                             Numeric,  4                         GMXSET2   
                                                                 GMXSET3   

                 ACMASTER    YEAR                     FT_DB      MSTSET1   
                             Numeric,  4                         MSTSET2   
                                                                 MSTSET3   
                                                                 MSTSET4   
                                                                 MSTSET5   

                 ACMASTERX   YEAR                     FT_DB      MSXSET1   
                             Numeric,  4                         MSXSET2   
                                                                 MSXSET3   
                                                                 MSXSET4   

                 ACTOTALS    YEAR                     FT_DB      
                             Numeric,  4       

                 ACTOTBAL    YEAR                     FT_DB      TOTSET1   
                             Numeric,  4                         TOTSET2   
                                                                 TOTSET3   
                                                                 TOTSET4   

                 ACTOTBALX   YEAR                     FT_DB      TOXSET1   
                             Numeric,  4                         TOXSET2   

                 ACTRANS     YEAR                     FT_DB      ATNSET10  
                             Numeric,  4                         ATNSET4   

                 ADAMOUNTSX  YEAR                     FT_DB      BADSET3   
                             Numeric,  4       

                 ADAVGBAL    YEAR                     FT_DB      
                             Numeric,  4       

                 ADCFBAL     YEAR                     FT_DB      
                             Numeric,  4       

                 CATRANS     YEAR                     FT_DB      CATSET3   
                             Numeric,  4                         CATSET4   
                                                                 CATSET5   
                                                                 CATSET6   

                 CUAMOUNT    YEAR                     FT_DB      CAMSET1   
                             Numeric,  4                         CAMSET2   
                                                                 CAMSET3   
                                                                 CAMSET4   
                                                                 CAMSET5   
                                                                 CAMSET6   
                                                                 CAMSET7   
                                                                 CAMSET8   
                                                                 CAMSET9   

                 CUAMOUNTX   YEAR                     FT_DB      CAXSET3   
                             Numeric,  4       

                 CUCONTROL   YEAR                     FT_DB      CLCSET1   
                             Numeric,  4       

                 CUTRANSL    YEAR                     FT_DB      CTRSET1   
                             Numeric,  4                         CTRSET2   
                                                                 CTRSET3   
                                                                 CTRSET4   
                                                                 CTRSET5   

                 CUTRATEREL  YEAR                     FT_DB      CULSET3   
                             Numeric,  4                         CULSET4   

                 FBCONTROL   YEAR                     FT_DB      FLCSET1   
                             Numeric,  4                         FLCSET2   
                                                                 FLCSET3   

                 FBDETAIL    YEAR                     FT_DB      FBDSET1   
                             Numeric,  4                         FBDSET2   
                                                                 FBDSET3   
                                                                 FBDSET4   
                                                                 FBDSET5   
                                                                 FBDSET6   
                                                                 FBDSET7   
                                                                 FBDSET8   

                 FBDTLHIST   YEAR                     FT_DB      FDHSET1   
                             Numeric,  4                         FDHSET2   
                                                                 FDHSET3   

                 FBHEADER    YEAR                     FT_DB      FBHSET1   
                             Numeric,  4                         FBHSET2   
                                                                 FBHSET3   
                                                                 FBHSET4   

                 FBHISTHDR   YEAR                     FT_DB      FHHSET1   
                             Numeric,  4       

                 FBSPREAD    YEAR                     FT_DB      FBSSET1   
                             Numeric,  4                         FBSSET2   

                 FBTRANS     YEAR                     FT_DB      FLTSET2   
                             Numeric,  4                         FLTSET3   

                 FBUDGETREL  YEAR                     FT_DB      FBRSET2   
                             Numeric,  4       

                 FRSALES     YEAR                     FT_DB      
                             Numeric,  4       

                 GLAMOUNTS   YEAR                     FT_DB      GAMSET1   
                             Numeric,  4                         GAMSET2   
                                                                 GAMSET3   
                                                                 GAMSET4   
                                                                 GAMSET5   
                                                                 GAMSET6   
                                                                 GAMSET7   
                                                                 GAMSET8   
                                                                 GAMSET9   

                 GLAMOUNTSX  YEAR                     FT_DB      GAXSET3   
                             Numeric,  4       

                 GLCLSAUDIT  YEAR                     FT_DB      GCASET1   
                             Numeric,  4       

                 GLCOMMIT    YEAR                     FT_DB      GOTSET1   
                             Numeric,  4                         GOTSET2   
                                                                 GOTSET3   

                 GLCOMMITX   YEAR                     FT_DB      GOXSET1   
                             Numeric,  4                         GOXSET3   

                 GLCONDRILL  YEAR                     FT_DB      
                             Numeric,  4       

                 GLCONSOL    YEAR                     FT_DB      GCNSET1   
                             Numeric,  4                         GCNSET2   
                                                                 GCNSET3   
                                                                 GCNSET4   
                                                                 GCNSET5   
                                                                 GCNSET6   
                                                                 GCNSET7   

                 GLCONTROL   YEAR                     FT_DB      GLCSET1   
                             Numeric,  4                         GLCSET2   
                                                                 GLCSET3   
                                                                 GLCSET4   
                                                                 GLCSET5   
                                                                 GLCSET6   

                 GLIAMBR     YEAR                     FT_DB      
                             Numeric,  4       

                 GLJELOG     YEAR                     FT_DB      GJLSET1   
                             Numeric,  4                         GJLSET2   
                                                                 GJLSET3   

                 GLMASTREL   YEAR                     FT_DB      GMRSET1   
                             Numeric,  4       

                 GLSYSJE     YEAR                     FT_DB      GSJSET1   
                             Numeric,  4                         GSJSET2   

                 GLSYSTEM    YEAR                     FT_DB      
                             Numeric,  4       

                 GLTRANS     YEAR                     FT_DB      GLTSET1   
                             Numeric,  4                         GLTSET2   
                                                                 GLTSET3   
                                                                 GLTSET6   
                                                                 GLTSET8   

                 GLUNITS     YEAR                     FT_DB      GLUSET1   
                             Numeric,  4                         GLUSET2   
                                                                 GLUSET3   
                                                                 GLUSET4   
                                                                 GLUSET5   
                                                                 GLUSET6   
                                                                 GLUSET8   

                 GLUNITSX    YEAR                     FT_DB      GUXSET3   
                             Numeric,  4       

                 INSTDETAIL  YEAR                     FT_DB      INGSET1   
                             Numeric,  4       

                 INSTHEADER  YEAR                     FT_DB      INHSET1   
                             Numeric,  4       

                 INSTNBR     YEAR                     FT_DB      INBSET1   
                             Numeric,  4       

                 JBKSEQNBR   YEAR                     FT_DB      JSQSET1   
                             Numeric,  4       

                 LMINVOICE   YEAR                     FT_DB      INVSET10  
                             Numeric,  4                         INVSET9   

                 MLAMOUNTS   YEAR                     FT_DB      MLASET1   
                             Numeric,  4                         MLASET2   
                                                                 MLASET3   
                                                                 MLASET4   
                                                                 MLASET5   
                                                                 MLASET6   
                                                                 MLASET7   
                                                                 MLASET8   
                                                                 MLASET9   

                 MLCALMAP    YEAR                     FT_DB      MCMSET1   
                             Numeric,  4                         MCMSET2   

                 MLCOLEDGER  YEAR                     FT_DB      
                             Numeric,  4       

                 MLCONSOL    YEAR                     FT_DB      MCNSET1   
                             Numeric,  4                         MCNSET2   
                                                                 MCNSET3   
                                                                 MCNSET4   
                                                                 MCNSET5   
                                                                 MCNSET6   
                                                                 MCNSET7   

                 MLCUAMOUNT  YEAR                     FT_DB      MCASET1   
                             Numeric,  4                         MCASET2   
                                                                 MCASET3   
                                                                 MCASET4   
                                                                 MCASET5   
                                                                 MCASET6   
                                                                 MCASET7   
                                                                 MCASET8   
                                                                 MCASET9   

                 MLCUCNTRL   YEAR                     FT_DB      MCCSET1   
                             Numeric,  4       

                 MLTRANS     YEAR                     FT_DB      MLTSET2   
                             Numeric,  4                         MLTSET3   
                                                                 MLTSET4   
                                                                 MLTSET7   

                 MLUNITS     YEAR                     FT_DB      MLUSET1   
                             Numeric,  4                         MLUSET2   
                                                                 MLUSET3   
                                                                 MLUSET4   
                                                                 MLUSET5   
                                                                 MLUSET6   
                                                                 MLUSET7   

                 RADEFINE    YEAR                     FT_DB      RADSET3   
                             Numeric,  4                         RADSET4   

                 RATOTALS    YEAR                     FT_DB      RATSET1   
                             Numeric,  4                         RATSET2   
                                                                 RATSET3   
                                                                 RATSET4   
                                                                 RATSET5   

                 RJSCHEDULE  YEAR                     FT_DB      RJSSET1   
                             Numeric,  4       

                 SLTRANS     YEAR                     FT_DB      
                             Numeric,  4       

                 SLTRANSERR  YEAR                     FT_DB      
                             Numeric,  4       

                 ULTOTALS    YEAR                     FT_DB      ULTSET1   
                             Numeric,  4       


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

                 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  

                 SLTRANS     

                 SLTRANSERR  

                 ULTOTALS    


                 In File     Relation
                 --------------------------------------------------------------
                 ACBUDDTL     ACBUDDTLX
                              ACCUAMT
                              ACMASTER

                 ACBUDDTLX    ACBUDDTL
                              ACCUAMTX
                              ACMASTERX

                 ACBUDREL    

                 ACCAL        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       ACCAL

                 ACCATRANS   

                 ACCHGORDX   

                 ACCOMMIT     ACCOMMITX

                 ACCOMMITX    ACCOMMIT

                 ACCONSOL     ACBUDDTL-CHILD
                              ACCONSOL-CHILD
                              ACCONSOLX
                              ACCUAMT-CHILD
                              ACMASTER-CHILD

                 ACCONSOLX    ACBUDDTLX-CHLD
                              ACCONSOL
                              ACCONSOLX-CHLD
                              ACCUAMTX-CHLD
                              ACMASTERX-CHLD

                 ACCUAMT      ACBUDDTL
                              ACCUAMTX
                              ACCUAMTX-BUD
                              ACMASTER

                 ACCUAMTX     ACBUDDTLX
                              ACCUAMT
                              ACMASTERX
                              POSTED-ACTRANS

                 ACGLCONSL    ACGLCONSLX

                 ACGLCONSLX   ACGLCONSL

                 ACGLMAST     ACGLMASTX

                 ACGLMASTX    ACGLMAST
                              POSTED-ACTRANS

                 ACMASTER     ACMASTERX

                 ACMASTERX    ACMASTER
                              ACTRANS

                 ACTOTALS    

                 ACTOTBAL     ACCONSOL
                              ACCONSOL-GRP
                              ACCUAMT
                              ACMASTER
                              ACTOTBAL-CHILD
                              ACTOTBAL-PARNT
                              ACTOTBAL-TYPE
                              ACTOTBALX
                              ACTOTBALX-GRP
                              TOT-TYPE-GRP

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

                 ACTRANS      ACCUAMT
                              ACCUAMTX
                              ACGLMASTX
                              ACMASTER
                              ACMASTERX

                 ADAMOUNTSX  

                 ADAVGBAL    

                 ADCFBAL     

                 CATRANS     

                 CUAMOUNT     CURR-1
                              CURR-2
                              GAM-SIBLING
                              GLTRANS-1-PRD
                              GLTRANS-1-YEAR

                 CUAMOUNTX    GLTRANS

                 CUCONTROL   

                 CUTRANSL    

                 CUTRATEREL  

                 FBCONTROL    FBTRANS

                 FBDETAIL     BUDGET
                              FBSPREAD

                 FBDTLHIST   

                 FBHEADER     BUDGET-DETAIL

                 FBHISTHDR   

                 FBSPREAD    

                 FBTRANS      FBCONTROL
                              FBTRANS

                 FBUDGETREL  

                 FRSALES     

                 GLAMOUNTS    BUDGET-1
                              CAM-CURR-1
                              CAM-CURR-2
                              COMPANY-TRANS
                              TRANS-ONE-PRD

                 GLAMOUNTSX   GLTRANS

                 GLCLSAUDIT   GLCONTROL

                 GLCOMMIT     GLCOMMITX

                 GLCOMMITX    GLCOMMIT

                 GLCONDRILL   GLAMACCT
                              GLAMOUNTS

                 GLCONSOL     BASE
                              CURR-1
                              CURR-2
                              GLCONSOL-0
                              GLCONSOL-1
                              GLCONSOL-2
                              GLCONSOL-3
                              GLCONSOL-4
                              GLCONSOL-BUD-1

                 GLCONTROL    CUCONTROL-ONE
                              CUCONTROL-TWO
                              GLJELOG
                              GLJELOG-CNTRL
                              GLJELOG-LINE
                              GLSYSJE
                              GLTRANS

                 GLIAMBR     

                 GLJELOG      GLCONTROL
                              GLTRANS

                 GLMASTREL   

                 GLSYSJE     

                 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      CUAMOUNTX-3
                              CUAMOUNTX-4
                              GLCOMMIT
                              GLCOMMITX
                              GLCONTROL
                              GLTRANS

                 GLUNITS     

                 GLUNITSX    

                 INSTDETAIL  

                 INSTHEADER   INTRASTAT-DTL

                 INSTNBR     

                 JBKSEQNBR   

                 LMINVOICE   

                 MLAMOUNTS    COMPANY-TRANS
                              MCA-CURR-1
                              MCA-CURR-2
                              TRANS-ONE-PRD

                 MLCALMAP    

                 MLCOLEDGER   MLAMOUNTS:TRANS-ONE-PRDS
                              MLCALMAP

                 MLCONSOL     BASE
                              CURR-1
                              CURR-2

                 MLCUAMOUNT   CURR-1
                              CURR-2
                              MLA-SIBLING
                              MLTRANS-1-PRD
                              MLTRANS-1-YEAR

                 MLCUCNTRL   

                 MLTRANS      MLCONTROL
                              MLTRANS

                 MLUNITS     

                 RADEFINE    

                 RATOTALS     ACCT-UNIT-AMTS

                 RJSCHEDULE  

                 SLTRANS     

                 SLTRANSERR  

                 ULTOTALS