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

                 ACBUDDTLX   BUDGET-NBR               FT_DB      BDXSET1   
                             Numeric,  3                         BDXSET2   
                                                                 BDXSET3   
                                                                 BDXSET4   
                                                                 BDXSET5   

                 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   
                                                                 CHOSET4   

                 ACCHGORDX   BUDGET-NBR               FT_DB      CHXSET1   
                             Numeric,  3                         CHXSET2   
                                                                 CHXSET3   

                 ACCMPPARAM  BUDGET-NBR               FT_DB      
                             Numeric,  3       

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

                 ACCONSOLX   BUDGET-NBR               FT_DB      CSXSET1   
                             Numeric,  3                         CSXSET2   
                                                                 CSXSET3   
                                                                 CSXSET4   

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

                 ACCUAMTX    BUDGET-NBR               FT_DB      ACXSET1   
                             Numeric,  3                         ACXSET2   
                                                                 ACXSET3   
                                                                 ACXSET4   
                                                                 ACXSET5   
                                                                 ACXSET6   

                 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       

                 ACTOTALS    BUDGET-NBR               FT_DB      
                             Numeric,  3       

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

                 ACTOTBALX   BUDGET-NBR               FT_DB      TOXSET1   
                             Numeric,  3                         TOXSET2   

                 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   
                                                                 FLCSET3   

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

                 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   

                 FBUDGETREL  BUDGET-NBR               FT_DB      FBRSET2   
                             Numeric,  3       

                 GLCONSOL    BUDGET-NBR               FT_DB      GCNSET1   
                             Numeric,  3                         GCNSET2   
                                                                 GCNSET3   
                                                                 GCNSET4   
                                                                 GCNSET5   
                                                                 GCNSET6   
                                                                 GCNSET7   

                 GLIAMBR     BUDGET-NBR               FT_DB      GIMSET1   
                             Numeric,  3       

                 RATOTALS    BUDGET-NBR               FT_DB      
                             Numeric,  3       

                 RWFORMAT    BUDGET-NBR               FT_DB      
                             Numeric,  3       

                 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            

                 ACBUDDTLX   

                 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            

                 ACCONSOLX   ACTGRP-AMOUNTS           
                             ACTGRP-BUDGET            
                             ACTVTY-AMOUNTS           
                             ACTVTY-BUDGET            

                 ACCUAMT     ACTVTY-AMOUNTS           
                             ACTVTY-BUDGET            
                             BUDGET                   

                 ACCUAMTX    ACTVTY-AMOUNTS           
                             ACTVTY-BUDGET            

                 ACIAMBR     

                 ACIASCNMBR  

                 ACMYFAVS    

                 ACPERCCMPL  

                 ACTOTALS    

                 ACTOTBAL    BLANK-BUDGET             
                             HAS-BUDGET               

                 ACTOTBALX   BLANK-BUDGET             

                 CAHEADER    

                 CUTRANSL    

                 CUTRATEREL  

                 FBCONTROL   

                 FBDETAIL    

                 FBDTLHIST   

                 FBHEADER    

                 FBHISTHDR   

                 FBTRANS     

                 FBUDGETREL  

                 GLCONSOL    

                 GLIAMBR     

                 RATOTALS    

                 RWFORMAT    

                 SCNSTRUCX   

                 ULTOTALS    


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

                 ACBUDDTLX   

                 ACBUDHDR    

                 ACBUDRATE   

                 ACBUDREL    

                 ACCHGORDER  

                 ACCHGORDX   

                 ACCMPPARAM  

                 ACCONSOL    

                 ACCONSOLX   

                 ACCUAMT     

                 ACCUAMTX    

                 ACIAMBR     

                 ACIASCNMBR  

                 ACMYFAVS    

                 ACPERCCMPL  

                 ACTOTALS    

                 ACTOTBAL    

                 ACTOTBALX   

                 CAHEADER    

                 CUTRANSL    

                 CUTRATEREL  

                 FBCONTROL   

                 FBDETAIL    

                 FBDTLHIST   

                 FBHEADER    

                 FBHISTHDR   

                 FBTRANS     

                 FBUDGETREL  

                 GLCONSOL    

                 GLIAMBR     

                 RATOTALS    

                 RWFORMAT    

                 SCNSTRUCX   

                 ULTOTALS    


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

                 ACBUDDTLX    ACBUDDTL
                              ACBUDHDR
                              ACCUAMTX

                 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
                              ACCONSOLX
                              ACCUAMT-CHILD

                 ACCONSOLX    ACBUDDTLX-CHLD
                              ACCONSOL
                              ACCONSOLX-CHLD
                              ACCUAMTX-CHLD

                 ACCUAMT      ACBUDDTL
                              ACBUDHDR
                              ACCUAMTX-BUD

                 ACCUAMTX     ACBUDDTLX
                              ACCUAMT

                 ACIAMBR     

                 ACIASCNMBR  

                 ACMYFAVS    

                 ACPERCCMPL  

                 ACTOTALS    

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

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

                 CAHEADER     FBHEADER

                 CUTRANSL    

                 CUTRATEREL  

                 FBCONTROL    FBTRANS

                 FBDETAIL     BUDGET

                 FBDTLHIST   

                 FBHEADER     BUDGET-DETAIL

                 FBHISTHDR   

                 FBTRANS      FBCONTROL
                              FBTRANS

                 FBUDGETREL  

                 GLCONSOL     GLCONSOL-0
                              GLCONSOL-1
                              GLCONSOL-2
                              GLCONSOL-3
                              GLCONSOL-4

                 GLIAMBR     

                 RATOTALS    

                 RWFORMAT    

                 SCNSTRUCX   

                 ULTOTALS