Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

BUDGET-NBR


                              FIELD USAGE REPORT


    FIELDNAME - BUDGET-NBR    

  FieldName      In File     Element        Occurs    FldType    IndexUsg
-------------------------------------------------------------------------------
  BUDGET-NBR     ACBUDDTL    BUDGET-NBR               FT_DB      BDTSET1   
                             Numeric,  3                         BDTSET2   
                                                                 BDTSET3   
                                                                 BDTSET4   
                                                                 BDTSET6   
                                                                 BDTSET7   

                 ACBUDHDR    BUDGET-NBR               FT_DB      BDHSET1   
                             Numeric,  3                         BDHSET3   

                 ACBUDRATE   BUDGET-NBR               FT_DB      BURSET1   
                             Numeric,  3       

                 ACBUDREL    BUDGET-NBR               FT_DB      ACBSET2   
                             Numeric,  3                         ACBSET4   

                 ACCHGORDER  BUDGET-NBR               FT_DB      CHOSET1   
                             Numeric,  3                         CHOSET2   
                                                                 CHOSET3   

                 ACCHGORDX   BUDGET-NBR               FT_DB      CHXSET1   
                             Numeric,  3                         CHXSET3   

                 ACCMPPARAM  BUDGET-NBR               FT_DB      
                             Numeric,  3       

                 ACCONSOL    BUDGET-NBR               FT_DB      CSLSET1   
                             Numeric,  3                         CSLSET2   
                                                                 CSLSET3   
                                                                 CSLSET4   
                                                                 CSLSET5   
                                                                 CSLSET6   

                 ACCUAMT     BUDGET-NBR               FT_DB      ACUSET1   
                             Numeric,  3                         ACUSET2   
                                                                 ACUSET3   
                                                                 ACUSET4   
                                                                 ACUSET5   

                 ACIAMBR     BUDGET-NBR               FT_DB      MEMSET1   
                             Numeric,  3       

                 ACIASCNMBR  BUDGET-NBR               FT_DB      ANMSET1   
                             Numeric,  3       

                 ACMYFAVS    BUDGET-NBR               FT_DB      AMFSET1   
                             Numeric,  3       

                 ACPERCCMPL  BUDGET-NBR               FT_DB      
                             Numeric,  3       

                 ACSUMBAL    BUDGET-NBR               FT_DB      SMBSET1   
                             Numeric,  3                         SMBSET2   

                 ACTOTALS    BUDGET-NBR               FT_DB      
                             Numeric,  3       

                 ACTOTBAL    BUDGET-NBR               FT_DB      TOTSET1   
                             Numeric,  3                         TOTSET2   
                                                                 TOTSET4   
                                                                 TOTSET5   

                 CAHEADER    BUDGET-NBR               FT_DB      
                             Numeric,  3       

                 CUTRANSL    BUDGET-NBR               FT_DB      CTRSET1   
                             Numeric,  3                         CTRSET2   
                                                                 CTRSET3   
                                                                 CTRSET4   
                                                                 CTRSET5   

                 CUTRATEREL  BUDGET-NBR               FT_DB      CULSET3   
                             Numeric,  3                         CULSET4   

                 FBCONTROL   BUDGET-NBR               FT_DB      FLCSET1   
                             Numeric,  3                         FLCSET2   

                 FBDETAIL    BUDGET-NBR               FT_DB      FBDSET1   
                             Numeric,  3                         FBDSET2   
                                                                 FBDSET3   
                                                                 FBDSET4   
                                                                 FBDSET5   
                                                                 FBDSET6   
                                                                 FBDSET7   
                                                                 FBDSET8   
                                                                 FBDSET9   

                 FBDTLHIST   BUDGET-NBR               FT_DB      FDHSET1   
                             Numeric,  3                         FDHSET2   
                                                                 FDHSET3   

                 FBHEADER    BUDGET-NBR               FT_DB      FBHSET1   
                             Numeric,  3                         FBHSET2   
                                                                 FBHSET3   
                                                                 FBHSET4   

                 FBHISTHDR   BUDGET-NBR               FT_DB      FHHSET1   
                             Numeric,  3       

                 FBTRANS     BUDGET-NBR               FT_DB      FLTSET2   
                             Numeric,  3                         FLTSET3   
                                                                 FLTSET5   

                 FBUDGETREL  BUDGET-NBR               FT_DB      FBRSET2   
                             Numeric,  3       

                 GLCONSOL    BUDGET-NBR               FT_DB      GCNSET1   
                             Numeric,  3                         GCNSET2   
                                                                 GCNSET3   
                                                                 GCNSET4   
                                                                 GCNSET5   
                                                                 GCNSET8   
                                                                 GCNSET9   

                 GLIAMBR     BUDGET-NBR               FT_DB      GIMSET1   
                             Numeric,  3       

                 RATOTALS    BUDGET-NBR               FT_DB      
                             Numeric,  3       

                 RWFORMAT    BUDGET-NBR               FT_DB      
                             Numeric,  3       

                 SBBUDREL    BUDGET-NBR               FT_DB      SBRSET2   
                             Numeric,  3                         SBRSET4   

                 SCNSTRUCX   BUDGET-NBR               FT_DB      SCXSET1   
                             Numeric,  3       

                 ULTOTALS    BUDGET-NBR               FT_DB      ULTSET1   
                             Numeric,  3       


                 In File     CndUsage                 DerivedUsage
                 --------------------------------------------------------------
                 ACBUDDTL    ACV-ACTIVE-BUD           
                             AG-ACTIVE-BUD            

                 ACBUDHDR    ACT-ACTIVE-BUD           
                             GRP-ACTIVE-BUD           

                 ACBUDRATE   

                 ACBUDREL    

                 ACCHGORDER  ACV-ACTIVE-BUD           
                             AG-ACTIVE-BUD            

                 ACCHGORDX   

                 ACCMPPARAM  

                 ACCONSOL    ACTGRP-AMOUNTS           
                             ACTGRP-BUDGET            
                             ACTVTY-AMOUNTS           
                             ACTVTY-BUDGET            

                 ACCUAMT     ACTVTY-AMOUNTS           
                             ACTVTY-BUDGET            
                             BUDGET                   

                 ACIAMBR     

                 ACIASCNMBR  

                 ACMYFAVS    

                 ACPERCCMPL  

                 ACSUMBAL    

                 ACTOTALS    

                 ACTOTBAL    BLANK-BUDGET             
                             HAS-BUDGET               

                 CAHEADER    

                 CUTRANSL    

                 CUTRATEREL  

                 FBCONTROL   

                 FBDETAIL    

                 FBDTLHIST   

                 FBHEADER    

                 FBHISTHDR   

                 FBTRANS     

                 FBUDGETREL  

                 GLCONSOL    

                 GLIAMBR     

                 RATOTALS    

                 RWFORMAT    

                 SBBUDREL    

                 SCNSTRUCX   

                 ULTOTALS    


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

                 ACBUDHDR    

                 ACBUDRATE   

                 ACBUDREL    

                 ACCHGORDER  

                 ACCHGORDX   

                 ACCMPPARAM  

                 ACCONSOL    

                 ACCUAMT     

                 ACIAMBR     

                 ACIASCNMBR  

                 ACMYFAVS    

                 ACPERCCMPL  

                 ACSUMBAL    

                 ACTOTALS    

                 ACTOTBAL    

                 CAHEADER    

                 CUTRANSL    

                 CUTRATEREL  

                 FBCONTROL   

                 FBDETAIL    

                 FBDTLHIST   

                 FBHEADER    

                 FBHISTHDR   

                 FBTRANS     

                 FBUDGETREL  

                 GLCONSOL    

                 GLIAMBR     

                 RATOTALS    

                 RWFORMAT    

                 SBBUDREL    

                 SCNSTRUCX   

                 ULTOTALS    


                 In File     Relation
                 --------------------------------------------------------------
                 ACBUDDTL     ACBUDHDR
                              ACCUAMT

                 ACBUDHDR     ACBUDDTL
                              ACBUDDTL-GRP
                              ACCHGORDER
                              ACCUAMT
                              ACCUAMT-GRP
                              ACCUAMT-RPT1
                              ACCUAMT-RPT2
                              ACU-GRP-RPT1
                              ACU-GRP-RPT2

                 ACBUDRATE   

                 ACBUDREL    

                 ACCHGORDER   ACBUDHDR
                              ACCHGORDX

                 ACCHGORDX    ACBUDHDR
                              ACCHGORDER

                 ACCMPPARAM  

                 ACCONSOL     ACBUDDTL-CHILD
                              ACCONSOL-CHILD
                              ACCUAMT-CHILD

                 ACCUAMT      ACBUDDTL
                              ACBUDHDR

                 ACIAMBR     

                 ACIASCNMBR  

                 ACMYFAVS    

                 ACPERCCMPL  

                 ACSUMBAL    

                 ACTOTALS    

                 ACTOTBAL     ACCONSOL
                              ACCONSOL-GRP
                              ACCUAMT
                              ACTOTBAL-CHILD
                              ACTOTBAL-PARNT
                              ACTOTBAL-TYPE
                              ACTOTBAL-YEAR
                              ACTOTBAL-YR-TP
                              TOT-TYPE-GRP
                              TOT-YEAR-GRP
                              TOT-YR-TP-GRP

                 CAHEADER     FBHEADER

                 CUTRANSL    

                 CUTRATEREL  

                 FBCONTROL    FBHEADER
                              FBTRANS

                 FBDETAIL     BUD-UNT-PARENT
                              BUDGET
                              BUDGET-PARENT
                              FBTRANS

                 FBDTLHIST   

                 FBHEADER     BUDGET-DETAIL

                 FBHISTHDR   

                 FBTRANS      FBCONTROL
                              FBHEADER
                              FBTRANS

                 FBUDGETREL  

                 GLCONSOL     CHILDREN-BUD
                              FBD-CHILDREN
                              GCN-BUD-PARENT
                              GLCONSOL-0
                              GLCONSOL-1
                              GLCONSOL-2
                              GLCONSOL-3
                              GLCONSOL-4

                 GLIAMBR     

                 RATOTALS    

                 RWFORMAT    

                 SBBUDREL    

                 SCNSTRUCX   

                 ULTOTALS