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

                 ACBUDREL    YEAR                     FT_DB      ACBSET2   
                             Numeric,  4                         ACBSET4   

                 ACCAL       YEAR                     FT_DB      CDHSET1   
                             Numeric,  4                         CDHSET2   

                 ACCALX      YEAR                     FT_DB      CDDSET1   
                             Numeric,  4                         CDDSET2   

                 ACCATRANS   YEAR                     FT_DB      TRNSET1   
                             Numeric,  4       

                 ACCHGORDX   YEAR                     FT_DB      CHXSET1   
                             Numeric,  4                         CHXSET3   

                 ACCOMMIT    YEAR                     FT_DB      MITSET1   
                             Numeric,  4                         MITSET3   
                                                                 MITSET4   
                                                                 MITSET6   
                                                                 MITSET7   

                 ACCOMMITX   YEAR                     FT_DB      MIXSET1   
                             Numeric,  4                         MIXSET5   

                 ACCONSOL    YEAR                     FT_DB      CSLSET1   
                             Numeric,  4                         CSLSET2   
                                                                 CSLSET3   
                                                                 CSLSET4   
                                                                 CSLSET5   
                                                                 CSLSET6   

                 ACCUAMT     YEAR                     FT_DB      ACUSET1   
                             Numeric,  4                         ACUSET2   
                                                                 ACUSET3   
                                                                 ACUSET4   
                                                                 ACUSET5   

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

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

                 ACMASTER    YEAR                     FT_DB      MSTSET1   
                             Numeric,  4                         MSTSET2   
                                                                 MSTSET3   
                                                                 MSTSET4   
                                                                 MSTSET5   

                 ACSUMBAL    FISCAL-YEAR              FT_DB      SMBSET1   
                             Numeric,  4                         SMBSET2   

                 ACTOTALS    YEAR                     FT_DB      
                             Numeric,  4       

                 ACTOTBAL    YEAR                     FT_DB      TOTSET1   
                             Numeric,  4                         TOTSET2   
                                                                 TOTSET4   
                                                                 TOTSET5   

                 ACTRANS     YEAR                     FT_DB      ATNSET10  
                             Numeric,  4                         ATNSET4   

                 ADAMOUNTSX  YEAR                     FT_DB      BADSET3   
                             Numeric,  4       

                 ADAVGBAL    YEAR                     FT_DB      
                             Numeric,  4       

                 ADBALANCE   YEAR                     FT_DB      ADESET1   
                             Numeric,  4                         ADESET2   
                                                                 ADESET3   
                                                                 ADESET4   
                                                                 ADESET5   
                                                                 ADESET6   
                                                                 ADESET7   

                 ADCFBAL     YEAR                     FT_DB      
                             Numeric,  4       

                 ADCONSOL    YEAR                     FT_DB      ADOSET1   
                             Numeric,  4                         ADOSET2   
                                                                 ADOSET3   
                                                                 ADOSET4   
                                                                 ADOSET5   

                 CATRANS     YEAR                     FT_DB      CATSET3   
                             Numeric,  4                         CATSET4   
                                                                 CATSET5   
                                                                 CATSET6   

                 CUAMOUNT    YEAR                     FT_DB      CAMSET1   
                             Numeric,  4                         CAMSET2   
                                                                 CAMSET3   
                                                                 CAMSET4   
                                                                 CAMSET5   
                                                                 CAMSET6   
                                                                 CAMSET7   
                                                                 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   

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

                 FBDTLHIST   YEAR                     FT_DB      FDHSET1   
                             Numeric,  4                         FDHSET2   
                                                                 FDHSET3   

                 FBFUNDAMT   FISCAL-YEAR              FT_DB      FBBSET1   
                             Numeric,  4       

                 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   
                                                                 FLTSET5   

                 FBUDGETREL  YEAR                     FT_DB      FBRSET2   
                             Numeric,  4       

                 FRSALES     YEAR                     FT_DB      
                             Numeric,  4       

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

                 GLAMOUNTSX  YEAR                     FT_DB      GAXSET3   
                             Numeric,  4       

                 GLCLSAUDIT  YEAR                     FT_DB      GCASET1   
                             Numeric,  4       

                 GLCOMMIT    YEAR                     FT_DB      GOTSET1   
                             Numeric,  4                         GOTSET2   

                 GLCOMMITX   YEAR                     FT_DB      GOXSET1   
                             Numeric,  4       

                 GLCONDRILL  YEAR                     FT_DB      
                             Numeric,  4       

                 GLCONSOL    YEAR                     FT_DB      GCNSET1   
                             Numeric,  4                         GCNSET2   
                                                                 GCNSET3   
                                                                 GCNSET4   
                                                                 GCNSET5   
                                                                 GCNSET8   
                                                                 GCNSET9   

                 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       

                 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   
                                                                 GLUSET9   

                 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                         MLASET10  
                                                                 MLASET2   
                                                                 MLASET3   
                                                                 MLASET4   
                                                                 MLASET5   
                                                                 MLASET6   
                                                                 MLASET7   

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

                 MLCUAMOUNT  YEAR                     FT_DB      MCASET1   
                             Numeric,  4                         MCASET2   
                                                                 MCASET3   
                                                                 MCASET4   
                                                                 MCASET5   
                                                                 MCASET6   
                                                                 MCASET7   
                                                                 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   

                 RJENCUMB    YEAR                     FT_DB      RJESET2   
                             Numeric,  4       

                 RJSCHEDULE  YEAR                     FT_DB      RJSSET1   
                             Numeric,  4       

                 SBBUDREL    YEAR                     FT_DB      SBRSET2   
                             Numeric,  4                         SBRSET4   

                 SLTRANS     YEAR                     FT_DB      
                             Numeric,  4       

                 SLTRANSERR  YEAR                     FT_DB      
                             Numeric,  4       

                 SNBUDCAL    YEAR                     FT_DB      S30SET1   
                             Numeric,  4       

                 ULTOTALS    YEAR                     FT_DB      ULTSET1   
                             Numeric,  4       


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

                 ACBUDREL    

                 ACCAL       

                 ACCALX      

                 ACCATRANS   

                 ACCHGORDX   

                 ACCOMMIT    

                 ACCOMMITX   

                 ACCONSOL    FISCAL-YEAR              
                             ZERO-FISCAL-YR           

                 ACCUAMT     FISCAL-YEAR              
                             ZERO-FISCAL-YR           

                 ACGLCONSL   

                 ACGLMAST    

                 ACMASTER    

                 ACSUMBAL    

                 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             

                 ACTRANS     

                 ADAMOUNTSX  

                 ADAVGBAL    

                 ADBALANCE   

                 ADCFBAL     

                 ADCONSOL    

                 CATRANS     

                 CUAMOUNT    

                 CUAMOUNTX   

                 CUCONTROL   

                 CUTRANSL    

                 CUTRATEREL  

                 FBCONTROL   

                 FBDETAIL    

                 FBDTLHIST   

                 FBFUNDAMT   

                 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    

                 RJENCUMB    

                 RJSCHEDULE  

                 SBBUDREL    

                 SLTRANS     

                 SLTRANSERR  

                 SNBUDCAL    

                 ULTOTALS    


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

                 ACBUDREL    

                 ACCAL       

                 ACCALX      

                 ACCATRANS   

                 ACCHGORDX   

                 ACCOMMIT    

                 ACCOMMITX   

                 ACCONSOL    

                 ACCUAMT     

                 ACGLCONSL   

                 ACGLMAST    

                 ACMASTER    

                 ACSUMBAL    

                 ACTOTALS    

                 ACTOTBAL    

                 ACTRANS     

                 ADAMOUNTSX  

                 ADAVGBAL    

                 ADBALANCE   

                 ADCFBAL     

                 ADCONSOL    

                 CATRANS     

                 CUAMOUNT    

                 CUAMOUNTX   

                 CUCONTROL   

                 CUTRANSL    Default

                 CUTRATEREL  

                 FBCONTROL   

                 FBDETAIL    

                 FBDTLHIST   

                 FBFUNDAMT   

                 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    

                 RJENCUMB    

                 RJSCHEDULE  

                 SBBUDREL    

                 SLTRANS     

                 SLTRANSERR  

                 SNBUDCAL    

                 ULTOTALS    


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

                 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
                              ACCOMMIT
                              ACCOMMITX
                              ACCONSOL-CHILD
                              ACCUAMT-CHILD
                              ACMASTER-CHILD
                              ACTRANS

                 ACCUAMT      ACBUDDTL
                              ACCOMMIT
                              ACCOMMITX
                              ACMASTER
                              ACTRANS

                 ACGLCONSL   

                 ACGLMAST     ACCOMMIT
                              ACCOMMITX
                              ACTRANS

                 ACMASTER     ACCOMMIT
                              ACCOMMITX
                              ACTRANS

                 ACSUMBAL    

                 ACTOTALS    

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

                 ACTRANS      ACCUAMT
                              ACMASTER

                 ADAMOUNTSX  

                 ADAVGBAL     GLAMOUNTS

                 ADBALANCE    GLAMOUNTS

                 ADCFBAL      GLAMOUNTS

                 ADCONSOL     GLCONSOL

                 CATRANS     

                 CUAMOUNT     CONSOL-PARENT1
                              CONSOL-PARENT2
                              CURR-1
                              CURR-2
                              GAM-SIBLING
                              GLTRANS-1-PRD
                              GLTRANS-1-YEAR

                 CUAMOUNTX    GLTRANS

                 CUCONTROL   

                 CUTRANSL    

                 CUTRATEREL  

                 FBCONTROL    FBHEADER
                              FBTRANS

                 FBDETAIL     BUD-UNT-PARENT
                              BUDGET
                              BUDGET-PARENT
                              FBSPREAD
                              FBTRANS
                              GLCOMMITX
                              GLTRANS

                 FBDTLHIST   

                 FBFUNDAMT   

                 FBHEADER     BUDGET-DETAIL

                 FBHISTHDR   

                 FBSPREAD    

                 FBTRANS      FBCONTROL
                              FBHEADER
                              FBTRANS

                 FBUDGETREL  

                 FRSALES     

                 GLAMOUNTS    ADBALANCE-B
                              ADBALANCE-C
                              CAM-CURR-1
                              CAM-CURR-2
                              COMPANY-TRANS
                              CONSOL-PARENT
                              GLCOMMIT
                              GLCOMMITX
                              TRANS-FIS-YEAR
                              TRANS-ONE-PRD

                 GLAMOUNTSX   GLTRANS

                 GLCLSAUDIT   GLCONTROL

                 GLCOMMIT     GLAMOUNTS
                              GLCOMMITX
                              GLTRANS
                              GLTRANSC

                 GLCOMMITX    GLAMOUNTS
                              GLCOMMIT
                              GLTRANS

                 GLCONDRILL   GLAMACCT
                              GLAMOUNTS

                 GLCONSOL     ADCONSOL-B
                              ADCONSOL-C
                              BASE
                              CAM-CHILDREN-1
                              CAM-CHILDREN-2
                              CHILDREN
                              CHILDREN-BUD
                              CURR-1
                              CURR-2
                              FBD-CHILDREN
                              GAM-CHILDREN
                              GCN-BUD-PARENT
                              GLCONSOL-0
                              GLCONSOL-1
                              GLCONSOL-2
                              GLCONSOL-3
                              GLCONSOL-4
                              GLCONSOL-BUD-1
                              GLU-CHILDREN
                              PARENT

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

                 GLUNITSX    

                 INSTDETAIL  

                 INSTHEADER   INTRASTAT-DTL

                 INSTNBR     

                 JBKSEQNBR   

                 LMINVOICE   

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

                 MLCALMAP    

                 MLCOLEDGER   MLAMOUNTS:TRANS-ONE-PRDS
                              MLCALMAP

                 MLCONSOL     BASE
                              CAM-CHILDREN-1
                              CAM-CHILDREN-2
                              CHILDREN
                              CURR-1
                              CURR-2
                              GAM-CHILDREN
                              MLU-CHILDREN
                              PARENT

                 MLCUAMOUNT   CONSOL-PARENT1
                              CONSOL-PARENT2
                              CURR-1
                              CURR-2
                              MLA-SIBLING
                              MLTRANS-1-PRD
                              MLTRANS-1-YEAR

                 MLCUCNTRL   

                 MLTRANS      MLCONTROL
                              MLTRANS

                 MLUNITS      MLUNIT-PARENT

                 RADEFINE    

                 RATOTALS     ACCT-UNIT-AMTS

                 RJENCUMB    

                 RJSCHEDULE  

                 SBBUDREL    

                 SLTRANS     

                 SLTRANSERR  

                 SNBUDCAL    

                 ULTOTALS