Lawson Insight Technical Documentation


ERDs Tables Elements Libraries App Forms

                              FIELD USAGE REPORT


  Element        In File    Occurs    FldType    IndexUsg   Relation
-------------------------------------------------------------------------------
  CUSTOMER      ACCUSTOMER           FT_DB      CMRSET1   ARCUSTOMER
  Alpharight,  9    
                APVENMAST            

                AR50WORK                        A50SET1   

                AR53WORK             

                AR73WORK                        A73SET1   

                ARCCUST                         ARUSET1   

                ARCDSELECT                      SELSET1   ARCUSTOMER
                                                 SELSET2   CUSTDESC
                                                 SELSET3   
                                                 SELSET4   

                ARCOMMENT                       CMTSET1   ARCUSTOMER
                                                 CMTSET2   AROIHDR
                                                 CMTSET3   CUSTDESC
                                                 CMTSET4   
                                                 CMTSET5   

                ARCONTACTS                      CONSET1    CUSTCONTACT
                                                           CUSTDESC

                ARCPAYMENT                      ARCSET1   

                ARCUSTFLDS                      ACFSET1   ARCUSTOMER

                ARCUSTOMER                      ACMSET1   ARCOMMENT3
                                                 ACMSET2   ARCOMMENTS
                                                 ACMSET3   ARCONTACTS
                                                 ACMSET6   ARCUSTFLDS
                                                 ACMSET7    ARCUSTPAYMENT
                                                 ACMSET8   ARCUSTPER
                                                           ARDISPUTE
                                                           ARDRAFTS
                                                           ARMICRCUST
                                                           AROIHDR
                                                           AROITEMS
                                                           AROITEMSOPEN
                                                           ARPAYMENT
                                                           BILLTO
                                                            CUSTOMERDESC
                                                            CUSTOMERTOTALS
                                                           DTCUSTBANK
                                                           FRCONTMAST
                                                           FTCUSTGRP
                                                           NATACCT
                                                           PBCLIENT
                                                           ARCUSTTOTS:CUSTOMERNAME

                ARCUSTPER                       ARPSET1   

                ARCUSTTOTS                      CUTSET1   ARCUSTOMER

                ARDFTSEL                        ASLSET1   

                ARDISPUTE                       ADPSET1   ARCUSTOMER
                                                 ADPSET2   AROIHDR
                                                 ADPSET3   CUSTDESC

                ARDISTRIB                       AMDSET2   AROIHDR
                                                 AMDSET4   ARPAYMENT
                                                 AMDSET6   ARUDISTRIB
                                                           CUSTDESC
                                                            CUSTOMER

                ARDRAFTS                        ARDSET1    ARAPPLIED
                                                 ARDSET10  ARCUSTOMER
                                                 ARDSET2   CUSTDESC
                                                 ARDSET3   DTCOMMENT
                                                 ARDSET4   DTCREDIT
                                                 ARDSET5   DTCUSTBANK
                                                 ARDSET6   
                                                 ARDSET7   
                                                 ARDSET8   
                                                 ARDSET9   

                ARDUNHIST                       DUHSET1   

                ARDUNSLDTL                      DDLSET1   

                ARDUNSLHDR                      DHDSET1   

                ARIADJUST                       IADSET1   

                ARIAPPLIED                      IAPSET1   

                ARICOMMENT                      AIMSET1   

                ARICST                          CUSSET1   

                ARICUSTCMT                      ICNSET1   

                ARICUSTPER                      AIESET1   

                ARIDISPUTE                      IDUSET1   

                ARIDISTRIB           

                ARIMICR                         IMISET1   

                ARIOECUST                       AOESET1   

                ARIPAYMENT                      AIPSET1   

                ARIPMT               

                ARIREMIT                        IRMSET1   

                ARITEMAUD                       ARZSET2   

                ARITRANS                        AITSET1   

                ARMICRCUST                      AMXSET2   ARCUSTOMER
                                                           CUSTDESC

                AROBLIGGRP           

                AROIHDR                         ARHSET2   ARCOMMENT
                                                 ARHSET3   ARCUSTOMER
                                                 ARHSET4   ARDISTRIB
                                                           CUSTDESC

                AROITEMS                        AROSET2   ARCUSTOMER
                                                 AROSET3   ARDISPUTE
                                                 AROSET4   ARDUNHIST
                                                 AROSET5    CRAPPLIED
                                                 AROSET6   CUSTDESC
                                                 AROSET7   PBCLIENT

                AROPIVOT                        PVTSET1   
                                                 PVTSET10  
                                                 PVTSET11  
                                                 PVTSET12  
                                                 PVTSET13  
                                                 PVTSET14  
                                                 PVTSET2   
                                                 PVTSET3   
                                                 PVTSET4   
                                                 PVTSET5   
                                                 PVTSET6   
                                                 PVTSET7   
                                                 PVTSET8   
                                                 PVTSET9   

                ARPAYMENT                       APMSET10  ARCOMMENT
                                                 APMSET2    ARMEMODIST
                                                 APMSET6   ARRTM1
                                                 APMSET7   CUSTDESC
                                                 APMSET8    CUSTOMER
                                                 APMSET9   REVERSE

                ARRTM                           RTMSET1    ARAPPLIED
                                                 RTMSET2   ARCUSTOMER
                                                 RTMSET3   ARPAYMENT
                                                 RTMSET4   ARRTMADJ
                                                           CUSTDESC

                ARRTMADJ                        ARJSET1   

                ARUDISTRIB                      DGMSET1   ARDISTRIB
                                                 DGMSET2   

                ARURTM                          UTMSET1   ARRTM

                BALFWDTOT                       BFTSET1   

                BILLTO                          ABSSET1   
                                                 ABSSET2   

                BLRICCOMM                       BUCSET1   

                BLRICLINE                       BULSET1   ARCUSTOMER
                                                 BULSET2   BLRICSGBLK
                                                 BULSET3   CUSTDESC
                                                 BULSET4    OECSCOMM
                                                 BULSET5    OECSMISC
                                                           OECUSTSRVC

                BLRICMISC                       BUMSET1   ARCUSTOMER
                                                 BUMSET2   BLRICSGBLK
                                                 BUMSET3   CUSTDESC
                                                 BUMSET4    OECSLINE
                                                 BUMSET5   OECUSTSRVC

                BLRICSGBLK                      CGMSET1   BLRICLINE
                                                           BLRICMISC
                                                           BLRICUST

                BLRICUST                        BRCSET1   ARCUSTOMER
                                                           BLRICSGBLK
                                                           CUSTDESC
                                                            OECSCOMM
                                                            OECSLINE
                                                            OECSMISC
                                                            OECSMISC-ALL

                CBSTMTDTL            

                CBTRANS              

                COLINE                          COLSET3   ARCUSTOMER
                                                 COLSET6    CONTRACT
                                                           CUSTDESC
                                                           OECUST
                                                           RETURNLINE
                                                           SHIPTO
                                                           COLINEUOM:ARCUSTOMER

                CUSTDESC                        CUDSET1   ARCUSTOMER
                                                 CUDSET4   BILLTO
                                                 CUDSET5   DTCUSTBANK
                                                 CUDSET6   FTCUSTGRP
                                                 CUDSET8   

                CUSTORDER                       CORSET2   COLINEUOM:CONTRACT
                                                 CORSET6   ARCUSTOMER
                                                           BILLTO
                                                           CUSTDESC
                                                           CUSTORDER
                                                           OECUST
                                                           OESTDORDER
                                                           SHIPTO
                                                            WHSHIPMENT:SHIPTO

                DTCOMMENT                       DMTSET1   

                DTCREDIT                        DTXSET1   ARDRAFTS
                                                            DTAPPLIED

                DTCUSTBANK                      DTBSET1    ARCUSTGRP
                                                 DTBSET2   CUSTDESC
                                                 DTBSET3   
                                                 DTBSET4   

                DTIDRAFTS                       DTISET1   

                FRBALANCE                       FRBSET1   ARCUSTOMER
                                                           CUSTDESC

                FRCHARGE                        FRGSET1   ARCUSTOMER
                                                 FRGSET2   CUSTDESC
                                                           FRCONTMAST
                                                            FRPREPAY
                                                           SHIPTO

                FRCONTMAST                      FRMSET1   ARCUSTOMER
                                                 FRMSET2   CUSTDESC
                                                 FRMSET3   FRCHARGE
                                                            FRPREPAY
                                                           FRSALES
                                                           SHIPTO

                FRSALES                         FRLSET1   CUSTDESC
                                                 FRLSET10  FRCONTMAST
                                                 FRLSET2    FRCYCCHG
                                                 FRLSET3    FRUSALES
                                                 FRLSET4   SHIPTO
                                                 FRLSET5   
                                                 FRLSET6   
                                                 FRLSET7   
                                                 FRLSET8   
                                                 FRLSET9   

                FTCUSTGRP                       FTGSET1   
                                                 FTGSET2   

                FTCUSTNOTE                      FTNSET1   

                INSTHEADER           

                MSDSACK                         MSASET1   SHIPTO

                NATACCT                         NACSET1    INCUSTDESC
                                                 NACSET2    INVCUSTOMER
                                                 NACSET3    INVOITEMS

                NOTICEWRK                       NTWSET1   
                                                 NTWSET2   
                                                 NTWSET3   

                OEAUDIT              

                OECREDOVR                       OCOSET1   CUSTDESC

                OECUST                          OETSET1   ARCUSTOMER
                                                           CUSTDESC

                OECUSTITEM                      OCISET1   CUSTDESC
                                                 OCISET2   

                OEDIST                                     CUSTDESC

                OEICUST                         AEISET1   

                OEINVOICE                       OEISET4    OEINVCLINE:BLRICLINE
                                                            OEINVCLINE:CUSTDESC
                                                            OEINVCLINE:OECSLINE
                                                            OEINVCLINE:OECUSTSRVC
                                                            OEINVCLINE:RETURNLINE
                                                            OEINVCMISC:BLRICMISC
                                                            OEINVCMISC:BLRICUST
                                                            OEINVCMISC:OECSMISC
                                                            OEINVCMISC:OECUSTSRVC
                                                            OEINVCUOM:ARCUSTOMER
                                                            OEINVCUOM:CONTRACT
                                                           ARCUSTOMER
                                                           BILLTO
                                                           BLRICUST
                                                           CUSTDESC
                                                           OECUST
                                                           OECUSTSRVC
                                                           OEORDCMNT
                                                           SHIPTO

                OEORDCMNT                       OOCSET1   

                OEPLCLASS                       OPCSET1   CUSTDESC
                                                 OPCSET3   OEPRCLIST
                                                 OPCSET4   
                                                 OPCSET5   

                OEPLITEM                        OPISET1   ARCUSTOMER
                                                 OPISET3   CUSTDESC
                                                 OPISET5   OEPRCLIST

                OEPRCLIST                       OPLSET1   ARCUSTOMER
                                                 OPLSET4    CONT-CLASSES
                                                 OPLSET5    CONT-ITEMS
                                                           CUSTDESC
                                                            LIST-CLASSES
                                                           OEPLCLASS
                                                           OEPLITEM

                OERETHDRIN           

                OERETLNIN            

                OEROUTE                         ORTSET2   ARCUSTOMER
                                                           CUSTDESC
                                                           SHIPTO

                OESTDLINE                       OSLSET1   OEORDCMNT
                                                           OESTDORDER

                OESTDORDER                      OSOSET1   ARCUSTOMER
                                                           CUSTDESC
                                                            HDR-COMMENTS
                                                           OESTDLINE
                                                            TRL-COMMENTS

                OIINVOICE            

                PBCLIENT                        PCCSET3   ARCUSTOMER

                PBHSTHDR             

                RAHDROUT             

                RALINEOUT            

                RETURNHDR                                  ARCUSTOMER
                                                           BILLTO
                                                           CUSTDESC
                                                           SHIPTO

                RETURNLINE                      RTLSET2   

                REVERSE                         RVHSET1   ARCUSTOMER
                                                           CUSTDESC

                REVERSEDTL           

                ROUTESTOP                                  CUSTDESC
                                                           SHIPTO

                SABOOKED                        SABSET2   CUSTDESC
                                                           SHIPTO

                SABOOKLINE                                 CUSTDESC
                                                           SHIPTO

                SABUDGET                        SBDSET1   
                                                 SBDSET3   

                SAINVCLINE                                 ARCUSTOMER
                                                            CONTRACT
                                                           CUSTDESC
                                                           SHIPTO

                SAINVOICE                       SAISET3   ARCUSTOMER
                                                           CUSTDESC
                                                           SHIPTO

                SAPERFORM                       SPFSET1   
                                                 SPFSET2   

                SAREASON                        SARSET1   
                                                 SARSET2   

                SASUMMARY                       SUMSET1   
                                                 SUMSET3   

                SHIPTO                          SHPSET1   ARCUSTOMER
                                                 SHPSET2    COMMENTS
                                                           CUSTDESC

                SHIPTOCMNT                      SPCSET1   SHIPTO

                STATICCUST                      STASET1   ARCUSTOMER

                WFGRPTEMP                       GUTSET5   CUSTDESC

                WFRDIDTEMP                      DTPSET4   CUSTDESC

                WHDEMNDHDR           

                WHSHPMTOUT           


                 In File     CndUsage                 DerivedUsage
                 --------------------------------------------------------------
                ACCUSTOMER  

                APVENMAST   

                AR50WORK    

                AR53WORK    

                AR73WORK    

                ARCCUST     

                ARCDSELECT  

                ARCOMMENT   

                ARCONTACTS  

                ARCPAYMENT  

                ARCUSTFLDS  

                ARCUSTOMER  

                ARCUSTPER   

                ARCUSTTOTS  

                ARDFTSEL    

                ARDISPUTE   

                ARDISTRIB  CUSTDESC                 

                ARDRAFTS    

                ARDUNHIST   

                ARDUNSLDTL  

                ARDUNSLHDR  

                ARIADJUST   

                ARIAPPLIED  

                ARICOMMENT  

                ARICST      

                ARICUSTCMT  

                ARICUSTPER  

                ARIDISPUTE  

                ARIDISTRIB  

                ARIMICR     

                ARIOECUST   

                ARIPAYMENT  

                ARIPMT      

                ARIREMIT    

                ARITEMAUD   

                ARITRANS    

                ARMICRCUST  

                AROBLIGGRP  

                AROIHDR     

                AROITEMS    

                AROPIVOT    

                ARPAYMENT   APMSET3                  
                            CUSTDESC                 
                             CUSTOMER                 

                ARRTM       

                ARRTMADJ    

                ARUDISTRIB  

                ARURTM      

                BALFWDTOT   

                BILLTO      

                BLRICCOMM   

                BLRICLINE   

                BLRICMISC   

                BLRICSGBLK  

                BLRICUST    

                CBSTMTDTL   

                CBTRANS     

                COLINE      

                CUSTDESC    

                CUSTORDER   

                DTCOMMENT   

                DTCREDIT    

                DTCUSTBANK  

                DTIDRAFTS   

                FRBALANCE   

                FRCHARGE    

                FRCONTMAST  

                FRSALES     

                FTCUSTGRP   

                FTCUSTNOTE  

                INSTHEADER  

                MSDSACK     

                NATACCT     

                NOTICEWRK   

                OEAUDIT     

                OECREDOVR   

                OECUST      

                OECUSTITEM  

                OEDIST      

                OEICUST     

                OEINVOICE   CUST-CHANGED             

                OEORDCMNT   

                OEPLCLASS   CONTRACT                 
                             OPCSET4                  
                             PRICE-LIST               

                OEPLITEM    CONTRACT                 
                             OPISET2                  
                             OPISET3                  
                             OPISET4                  
                             PRICE-LIST               
                             PROMOTION                

                OEPRCLIST   CONTRACT                 
                             DEFLT-CONTRACT           
                             OPLSET3                  
                             PRICE-LIST               
                             PROMOTION                

                OERETHDRIN  

                OERETLNIN   

                OEROUTE     

                OESTDLINE   

                OESTDORDER  CUST-ENTERED             
                             CUST-SPECIFIC            
                             SHARED                   

                OIINVOICE   

                PBCLIENT    

                PBHSTHDR    

                RAHDROUT    

                RALINEOUT   

                RETURNHDR   

                RETURNLINE  

                REVERSE     

                REVERSEDTL  

                ROUTESTOP   

                SABOOKED    

                SABOOKLINE  

                SABUDGET    COMPANY-BUDGET           
                             ITEM-BUDGET              

                SAINVCLINE  

                SAINVOICE   

                SAPERFORM   

                SAREASON    

                SASUMMARY   

                SHIPTO      

                SHIPTOCMNT  

                STATICCUST  

                WFGRPTEMP   GUTSET5                  

                WFRDIDTEMP  DTPSET4                  

                WHDEMNDHDR  

                WHSHPMTOUT  


                 In File     RuleUsage
                 --------------------------------------------------------------
                ACCUSTOMER  

                APVENMAST   

                AR50WORK    

                AR53WORK    

                AR73WORK    

                ARCCUST     

                ARCDSELECT  

                ARCOMMENT   

                ARCONTACTS  

                ARCPAYMENT  

                ARCUSTFLDS  

                ARCUSTOMER  

                ARCUSTPER   

                ARCUSTTOTS  

                ARDFTSEL    

                ARDISPUTE   

                ARDISTRIB   

                ARDRAFTS    Req, CREATED, ADD

                ARDUNHIST   

                ARDUNSLDTL  

                ARDUNSLHDR  

                ARIADJUST   

                ARIAPPLIED  

                ARICOMMENT  

                ARICST      

                ARICUSTCMT  

                ARICUSTPER  

                ARIDISPUTE  

                ARIDISTRIB  

                ARIMICR     

                ARIOECUST   

                ARIPAYMENT  

                ARIPMT      

                ARIREMIT    

                ARITEMAUD   

                ARITRANS    

                ARMICRCUST  

                AROBLIGGRP  

                AROIHDR     

                AROITEMS    

                AROPIVOT    

                ARPAYMENT   

                ARRTM       

                ARRTMADJ    

                ARUDISTRIB  

                ARURTM      

                BALFWDTOT   

                BILLTO      

                BLRICCOMM   

                BLRICLINE   

                BLRICMISC   

                BLRICSGBLK  

                BLRICUST    

                CBSTMTDTL   

                CBTRANS     

                COLINE      

                CUSTDESC    

                CUSTORDER   

                DTCOMMENT   

                DTCREDIT    

                DTCUSTBANK  

                DTIDRAFTS   

                FRBALANCE   

                FRCHARGE    

                FRCONTMAST  

                FRSALES     

                FTCUSTGRP   

                FTCUSTNOTE  

                INSTHEADER  

                MSDSACK     

                NATACCT     

                NOTICEWRK   

                OEAUDIT     

                OECREDOVR   

                OECUST      

                OECUSTITEM  

                OEDIST      

                OEICUST     

                OEINVOICE   

                OEORDCMNT   

                OEPLCLASS   

                OEPLITEM    Req, EDIT, ADD, CONTRACT

                OEPRCLIST   

                OERETHDRIN  

                OERETLNIN   

                OEROUTE     

                OESTDLINE   

                OESTDORDER  

                OIINVOICE   

                PBCLIENT    

                PBHSTHDR    

                RAHDROUT    

                RALINEOUT   

                RETURNHDR   

                RETURNLINE  

                REVERSE     

                REVERSEDTL  

                ROUTESTOP   

                SABOOKED    

                SABOOKLINE  

                SABUDGET    

                SAINVCLINE  

                SAINVOICE   

                SAPERFORM   

                SAREASON    

                SASUMMARY   

                SHIPTO      Req

                SHIPTOCMNT  

                STATICCUST  

                WFGRPTEMP   

                WFRDIDTEMP  

                WHDEMNDHDR  

                WHSHPMTOUT