Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

DATE


                              FIELD USAGE REPORT


    FIELDNAME - DATE          

  FieldName      In File     Element        Occurs    FldType    IndexUsg
-------------------------------------------------------------------------------
  DATE           ACMILESTNX  DATE                     FT_DB      
                             yyyymmdd,  8      

                 ACPERCCMPL  DATE                     FT_DB      PECSET1   
                             yyyymmdd,  8                        PECSET2   

                 ACPERCMPLX  DATE                     FT_DB      PEXSET1   
                             yyyymmdd,  8                        PEXSET2   

                 ACRETNGX    DATE                     FT_DB      
                             yyyymmdd,  8      

                 ARAUDIT     DATE                     FT_DB      DITSET1   
                             yyyymmdd,  8                        DITSET2   
                                                                 DITSET4   
                                                                 DITSET5   

                 ARCDSELECT  DATE                     FT_DB      SELSET1   
                             yyyymmdd,  8                        SELSET2   

                 ATTENDHIST  DATE                     FT_DB      ATHSET1   
                             yyyymmdd,  8                        ATHSET2   
                                                                 ATHSET3   
                                                                 ATHSET4   

                 BALFWDTOT   DATE                     FT_DB      
                             yyyymmdd,  8      

                 BNANNENR    DATE                     FT_DB      
                             yyyymmdd,  8      

                 BNCOMMENTS  DATE                     FT_DB      
                             yyyymmdd,  8      

                 BNPAYMENT   DATE                     FT_DB      
                             yyyymmdd,  8      

                 BNSIMHDR    DATE                     FT_DB      
                             yyyymmdd,  8      

                 CUAMOUNTX   DATE                     FT_DB      CAXSET1   
                             yyyymmdd,  8                        CAXSET3   
                                                                 CAXSET4   

                 EMPCOMMENT  DATE                     FT_DB      ECMSET1   
                             yyyymmdd,  8      

                 EMTATRANS   DATE                     FT_DB      ETTSET1   
                             yyyymmdd,  8                        ETTSET2   
                                                                 ETTSET3   
                                                                 ETTSET4   
                                                                 ETTSET5   
                                                                 ETTSET6   

                 EPBATCH     DATE                     FT_DB      
                             yyyymmdd,  8      

                 FBCONTROL   DATE                     FT_DB      
                             yyyymmdd,  8      

                 FBTRANS     DATE                     FT_DB      
                             yyyymmdd,  8      

                 FRISALES    DATE                     FT_DB      FRISET1   
                             yyyymmdd,  8                        FRISET2   

                 FRSALES     DATE                     FT_DB      FRLSET1   
                             yyyymmdd,  8                        FRLSET2   
                                                                 FRLSET3   
                                                                 FRLSET4   
                                                                 FRLSET5   
                                                                 FRLSET6   
                                                                 FRLSET7   
                                                                 FRLSET9   

                 GLAMOUNTSX  DATE                     FT_DB      GAXSET1   
                             yyyymmdd,  8                        GAXSET2   
                                                                 GAXSET3   
                                                                 GAXSET4   

                 GLCONTROL   DATE                     FT_DB      
                             yyyymmdd,  8      

                 GLREMOTETX  DATE                     FT_DB      
                             yyyymmdd,  8      

                 GLTRANS     DATE                     FT_DB      
                             yyyymmdd,  8      

                 GLTRANSREL  DATE                     FT_DB      
                             yyyymmdd,  8      

                 GLUNITSX    DATE                     FT_DB      GUXSET1   
                             yyyymmdd,  8                        GUXSET2   
                                                                 GUXSET3   
                                                                 GUXSET4   

                 GMDELIV     DATE                     FT_DB      
                             yyyymmdd,  8      

                 GMPROTOCOL  DATE                     FT_DB      
                             yyyymmdd,  8      

                 HRCONTNBR   DATE                     FT_DB      HCNSET3   
                             yyyymmdd,  8      

                 ICAUDIT     DATE                     FT_DB      IAUSET1   
                             yyyymmdd,  8      

                 LETTERCODE  DATE                     FT_DB      LTCSET1   
                             yyyymmdd,  8      

                 LETTERTEXT  DATE                     FT_DB      LTTSET1   
                             yyyymmdd,  8      

                 MLTRANS     DATE                     FT_DB      
                             yyyymmdd,  8      

                 NOTICEWRK   DATE                     FT_DB      
                             yyyymmdd,  8      

                 OSHA        DATE                     FT_DB      OSHSET2   
                             yyyymmdd,  8      

                 PACOMMENTS  DATE                     FT_DB      PACSET2   
                             yyyymmdd,  8      

                 PAEMPCOSTS  DATE                     FT_DB      EMCSET1   
                             yyyymmdd,  8                        EMCSET2   

                 PAGRDI      DATE                     FT_DB      PAGSET3   
                             yyyymmdd,  8      

                 PAOFFLANG   DATE                     FT_DB      PLASET2   
                             yyyymmdd,  8      

                 PAREQCOST   DATE                     FT_DB      PRCSET1   
                             yyyymmdd,  8                        PRCSET2   

                 PAREQLOG    DATE                     FT_DB      PQLSET1   
                             yyyymmdd,  8                        PQLSET2   
                                                                 PQLSET3   

                 PAREQOFFER  DATE                     FT_DB      PRFSET1   
                             yyyymmdd,  8                        PRFSET2   

                 PBTRANS     DATE                     FT_DB      PTNSET1   
                             yyyymmdd,  8                        PTNSET2   
                                                                 PTNSET3   
                                                                 PTNSET4   
                                                                 PTNSET5   

                 PORECADJHD  DATE                     FT_DB      PJHSET4   
                             yyyymmdd,  8      

                 PORECADJLN  DATE                     FT_DB      PJLSET3   
                             yyyymmdd,  8      

                 PRAUDIT     DATE                     FT_DB      
                             yyyymmdd,  8      

                 PRPENDTIME  DATE                     FT_DB      PPTSET4   
                             yyyymmdd,  8                        PPTSET7   

                 RESTRANS    DATE                     FT_DB      RTRSET1   
                             yyyymmdd,  8                        RTRSET2   

                 RETURNHDR   DATE                     FT_DB      
                             yyyymmdd,  8      

                 RETURNLINE  DATE                     FT_DB      RTLSET2   
                             yyyymmdd,  8      

                 ROUTEDOC    DATE                     FT_DB      RDCSET1   
                             yyyymmdd,  8      

                 ROUTEHDR    DATE                     FT_DB      RTESET1   
                             yyyymmdd,  8                        RTESET2   

                 ROUTESTOP   DATE                     FT_DB      RTSSET1   
                             yyyymmdd,  8      

                 SLTRANS     DATE                     FT_DB      
                             yyyymmdd,  8      

                 SLTRANSERR  DATE                     FT_DB      
                             yyyymmdd,  8      

                 TAEMPTRANS  TA-TRAN-DATE             FT_DB      TTRSET1   
                             yyyymmdd,  8                        TTRSET2   
                                                                 TTRSET3   
                                                                 TTRSET4   
                                                                 TTRSET5   
                                                                 TTRSET6   

                 WOSCHEDULE  DATE                     FT_DB      WOSSET2   
                             yyyymmdd,  8                        WOSSET4   
                                                                 WOSSET5   


                 In File     CndUsage                 DerivedUsage
                 --------------------------------------------------------------
                 ACMILESTNX  DATE-TYPE                
                             MANUAL-TYPE              

                 ACPERCCMPL  

                 ACPERCMPLX  

                 ACRETNGX    

                 ARAUDIT     

                 ARCDSELECT  

                 ATTENDHIST  

                 BALFWDTOT   

                 BNANNENR    

                 BNCOMMENTS  

                 BNPAYMENT   

                 BNSIMHDR    

                 CUAMOUNTX   

                 EMPCOMMENT  

                 EMTATRANS   

                 EPBATCH     

                 FBCONTROL   

                 FBTRANS     

                 FRISALES    

                 FRSALES     

                 GLAMOUNTSX  

                 GLCONTROL   

                 GLREMOTETX  

                 GLTRANS     

                 GLTRANSREL  

                 GLUNITSX    

                 GMDELIV     

                 GMPROTOCOL  

                 HRCONTNBR   

                 ICAUDIT     

                 LETTERCODE  STANDARD                 

                 LETTERTEXT  

                 MLTRANS     

                 NOTICEWRK   

                 OSHA        

                 PACOMMENTS  

                 PAEMPCOSTS  

                 PAGRDI      

                 PAOFFLANG   

                 PAREQCOST   

                 PAREQLOG    

                 PAREQOFFER  

                 PBTRANS     

                 PORECADJHD  

                 PORECADJLN  

                 PRAUDIT     

                 PRPENDTIME  

                 RESTRANS    

                 RETURNHDR   

                 RETURNLINE  

                 ROUTEDOC    

                 ROUTEHDR    

                 ROUTESTOP   

                 SLTRANS     

                 SLTRANSERR  

                 TAEMPTRANS  

                 WOSCHEDULE  


                 In File     RuleUsage
                 --------------------------------------------------------------
                 ACMILESTNX  

                 ACPERCCMPL  

                 ACPERCMPLX  

                 ACRETNGX    

                 ARAUDIT     

                 ARCDSELECT  

                 ATTENDHIST  

                 BALFWDTOT   

                 BNANNENR    

                 BNCOMMENTS  

                 BNPAYMENT   

                 BNSIMHDR    

                 CUAMOUNTX   

                 EMPCOMMENT  

                 EMTATRANS   

                 EPBATCH     

                 FBCONTROL   

                 FBTRANS     

                 FRISALES    

                 FRSALES     

                 GLAMOUNTSX  

                 GLCONTROL   

                 GLREMOTETX  

                 GLTRANS     

                 GLTRANSREL  

                 GLUNITSX    

                 GMDELIV     

                 GMPROTOCOL  

                 HRCONTNBR   

                 ICAUDIT     

                 LETTERCODE  

                 LETTERTEXT  

                 MLTRANS     

                 NOTICEWRK   

                 OSHA        

                 PACOMMENTS  

                 PAEMPCOSTS  

                 PAGRDI      

                 PAOFFLANG   

                 PAREQCOST   

                 PAREQLOG    

                 PAREQOFFER  

                 PBTRANS     

                 PORECADJHD  

                 PORECADJLN  

                 PRAUDIT     

                 PRPENDTIME  

                 RESTRANS    

                 RETURNHDR   

                 RETURNLINE  

                 ROUTEDOC    

                 ROUTEHDR    

                 ROUTESTOP   

                 SLTRANS     

                 SLTRANSERR  

                 TAEMPTRANS  

                 WOSCHEDULE  


                 In File     Relation
                 --------------------------------------------------------------
                 ACMILESTNX  

                 ACPERCCMPL   ACPERCMPLX

                 ACPERCMPLX  

                 ACRETNGX    

                 ARAUDIT     

                 ARCDSELECT  

                 ATTENDHIST   PRTIME

                 BALFWDTOT   

                 BNANNENR    

                 BNCOMMENTS  

                 BNPAYMENT   

                 BNSIMHDR    

                 CUAMOUNTX    GLTRANS

                 EMPCOMMENT  

                 EMTATRANS   

                 EPBATCH     

                 FBCONTROL   

                 FBTRANS     

                 FRISALES    

                 FRSALES      FRCYCCHG
                              FRFRLUF
                              FRUSALES

                 GLAMOUNTSX   GLTRANS

                 GLCONTROL   

                 GLREMOTETX  

                 GLTRANS     

                 GLTRANSREL  

                 GLUNITSX    

                 GMDELIV     

                 GMPROTOCOL  

                 HRCONTNBR   

                 ICAUDIT     

                 LETTERCODE   LETTER-TEXT

                 LETTERTEXT  

                 MLTRANS     

                 NOTICEWRK   

                 OSHA        

                 PACOMMENTS  

                 PAEMPCOSTS  

                 PAGRDI      

                 PAOFFLANG   

                 PAREQCOST   

                 PAREQLOG    

                 PAREQOFFER  

                 PBTRANS     

                 PORECADJHD  

                 PORECADJLN  

                 PRAUDIT     

                 PRPENDTIME  

                 RESTRANS    

                 RETURNHDR   

                 RETURNLINE  

                 ROUTEDOC     ROUTEHDR
                              ROUTESTOP

                 ROUTEHDR     ROUTESTOP

                 ROUTESTOP    ROUTEDOC
                              ROUTEHDR

                 SLTRANS     

                 SLTRANSERR  

                 TAEMPTRANS  

                 WOSCHEDULE