Lawson Insight Technical Documentation


ERDs Tables Elements Libraries App Forms

                              FIELD USAGE REPORT


  Element        In File    Occurs    FldType    IndexUsg   Relation
-------------------------------------------------------------------------------
  LINE-NBR      ACALLOCX             FT_DB      AOXSET1   
  Numeric,  6       
                ACCATRANS                       TRNSET1   
                                                 TRNSET2   
                                                 TRNSET3   

                ACCOMTMPX                       COXSET1   

                ARIITEM              

                AROITEMS             

                BLRICCOMM                       BUCSET1   

                BLRICLINE                       BULSET1   BLRICSGBLK
                                                 BULSET3    OECSCOMM
                                                 BULSET4    OECSMISC
                                                 BULSET5    OEMSLINE

                BLRICMISC                       BUMSET1   BLRICSGBLK
                                                 BUMSET3    OECSLINE
                                                 BUMSET4    OEMSMISC
                                                 BUMSET5   

                BLRICSGBLK                      CGMSET1   BLRICLINE
                                                           BLRICMISC

                BLRIMCOMM                       BMCSET1   BLRIMLINE

                BLRIMLINE                       BMLSET1   BLRIMSGBLK
                                                            OECSLINE
                                                            OEMSCOMM
                                                            OEMSMISC

                BLRIMMISC                       BMMSET1   BLRIMSGBLK
                                                            OECSMISC
                                                            OEMSLINE

                BLRIMSGBLK                      MSGSET1   BLRIMLINE
                                                           BLRIMMISC

                CADETAIL                        CADSET1   
                                                 CADSET2   
                                                 CADSET3   
                                                 CADSET4   
                                                 CADSET5   

                CATRANS                         CATSET1   

                CBSTMTDTL                       CSDSET1   

                COCOMP                          CKTSET1   COLINE
                                                 CKTSET2   

                COLINE                          COLSET1   COCOMP
                                                 COLSET10  COLINEUOM
                                                 COLSET2   COMISC
                                                 COLSET3   COSGBLK
                                                 COLSET4   OEAUDIT
                                                 COLSET6   OEORDCMNT
                                                 COLSET7   POINTERFAC
                                                 COLSET9   WHDEMAND
                                                           WHSHIPLINE

                COLINEDTL                       CLDSET1   COLINE

                COLINEUOM                       COUSET1   COLINE

                COMISC                          CMCSET1   COLINE
                                                 CMCSET3   COSGBLK
                                                 CMCSET6   

                COSGBLK                         OSGSET1   COLINE
                                                           COMISC

                CXCPIUAVAL                      CXVSET1   

                CXCTIUAVAL                      CXTSET1   

                CXITEMHIST                      CIHSET1   

                CXPREFITEM                      CPISET1    GEN-TEMP-ITEM
                                                 CPISET3   POINTERFAC
                                                 CPISET4    PRAC-TEMP-ITEM

                CXPTMPITEM                      CTISET1   
                                                 CTISET2   

                ERSAOCDTL                       ERSSET1   PORECLINE

                GLCONTROL            

                GLCONVJE             

                GLJELOG                         GJLSET1   GLTRANS
                                                 GJLSET2   

                GLTRANS                         GLTSET1   
                                                 GLTSET2   
                                                 GLTSET3   
                                                 GLTSET4   

                ICACTIVITY           

                ICCTRNDTL                       ITDSET1   

                ICCTRNHDR            

                ICCTRNLIN                       ITNSET1   ICCTRNDTL

                ICRECEIPTS                      ICRSET1   
                                                 ICRSET2   
                                                 ICRSET3   
                                                 ICRSET4   
                                                 ICRSET5   

                ICTRANS                         ICTSET1    ACCOUNTS
                                                 ICTSET5   ICTRANSDTL
                                                           MMUAVAL
                                                           WHSHIPLINE

                ICTRANSDTL                      ICDSET1    REC-ADJUST
                                                 ICDSET2    REC-REJECT
                                                 ICDSET3    RECEIVE

                MACRECAOC                       MRASET1   

                MACRECLINE                      MRLSET1   MACRECPOT

                MACRECPOT                       MRPSET1   

                MMDIST                          MMDSET1   ICTRANS
                                                 MMDSET2   POLINE
                                                 MMDSET3   PORECLINE
                                                            PORETURNLN
                                                           REQLINE
                                                           REQLINE2
                                                           WHSHIPLINE

                MMUAVAL                         MUASET1   

                OEAUDIT                         OEASET1   COLINE

                OECREDOVR                       OCOSET1   

                OEDIST                          ODISET1   OEINVCLINE
                                                 ODISET2   OEINVCMISC
                                                 ODISET3   
                                                 ODISET4   

                OEINVCCOMM                      OICSET1   OEINVCLINE

                OEINVCDTL                       OIDSET1   OEINVCLINE

                OEINVCLINE                      OILSET1   OEINVCDTL:COLINE
                                                 OILSET2   BLRICLINE
                                                 OILSET5   COCOMP
                                                           COLINE
                                                           COMISC
                                                            LINE-MISC
                                                            LINE-TAX
                                                            OECSLINE
                                                           OEDIST
                                                           OEINVCCOMM
                                                           OEINVCDTL
                                                           OEINVCMISC
                                                           OEINVCTAX
                                                           OEINVCUOM
                                                           OEINVSGBLK
                                                            OESHIPLINE

                OEINVCMISC                      OIMSET1   BLRICMISC
                                                 OIMSET4    OECSMISC
                                                           OEDIST
                                                           OEINVCLINE
                                                           OEINVCTAX
                                                           OEINVSGBLK

                OEINVCTAX                       OITSET1   OEINVCLINE
                                                 OITSET2   OEINVCMISC
                                                 OITSET3   
                                                 OITSET4   

                OEINVCUOM                       OEUSET1   OEINVCLINE

                OEINVSGBLK                      OSBSET1   OEINVCLINE
                                                           OEINVCMISC

                OEORDCMNT                       OOCSET1   COLINE

                OERETCMTIN                      RCISET1   
                                                 RCISET2   
                                                 RCISET3   

                OERETLNIN                       RLISET1   
                                                 RLISET2   
                                                 RLISET3   

                OESTDLINE                       OSLSET1   OEORDCMNT

                OIINVCCOMM                      OIWSET1   

                OIINVCLINE                      OIZSET1    LINECOMM
                                                            LINEMISC

                OIINVCMISC                      OIXSET1   

                OISGBLK                         ISBSET1   OEINVCLINE
                                                           OEINVCMISC
                                                           OEINVSGBLK

                PBHSTDTL                        PBHSET1   
                                                 PBHSET2   
                                                 PBHSET3   
                                                 PBHSET4   

                POAOCDTL                        PAOSET1   POAPPROVE
                                                 PAOSET2   POLINEDTL
                                                 PAOSET3   STPOLINE
                                                 PAOSET4   
                                                 PAOSET5   
                                                 PAOSET6   
                                                 PAOSET7   

                POAPPROVE                       POASET1    APDISTRIB
                                                 POASET2   MMDIST
                                                 POASET3   POAOCDTL
                                                 POASET4   POLINE
                                                 POASET5   PORECLINE
                                                 POASET6   

                POCOMMENTS                      POCSET1   POLINE
                                                 POCSET2    PORETURNLN
                                                           STPOLINE

                POCOMOUT                        PCMSET1   
                                                 PCMSET2   

                POINTAOC                        PIASET1   POINTERFAC

                POINTCMTS                       PICSET1   POINTERFAC

                POINTERFAC                      PIFSET1    COMMENTS
                                                 PIFSET6   POINTAOC

                POLINE                          PLISET1    HAS-VEND-ITEM
                                                 PLISET2   MMDIST
                                                 PLISET3   MMUAVAL
                                                 PLISET4    POAOCAPPV-DATE
                                                 PLISET5   POAOCDTL
                                                 PLISET6    POAOCLINEDTL
                                                 PLISET7    POAPPR-BY-DATE
                                                 PLISET8   POAPPROVE
                                                 PLISET9    POAUDIT
                                                           POCOMMENTS
                                                           POINTERFACE
                                                            POREC-BY-DATE
                                                            POTAXAPPV-DATE
                                                            REQUISITIONS
                                                            RETURN-LINE

                POLINEOUT                       PLTSET1    HDROUTCOMOUT
                                                 PLTSET2   

                POMESSAGE                       POMSET3   POAPPROVE
                                                 POMSET4   POLINE
                                                           PORECLINE

                PORECLINE                       PRLSET1    BUYER-MESSAGE
                                                 PRLSET10  ERSAOCDTL
                                                 PRLSET2   ICTRANSDTL
                                                 PRLSET3   MMDIST
                                                 PRLSET4   POAPPROVE
                                                 PRLSET5   POCOMMENTS
                                                 PRLSET6   POLINE
                                                 PRLSET7   
                                                 PRLSET9   

                RACMNTOUT                       RCOSET1   
                                                 RCOSET2   

                RALDTLOUT                       RDOSET1   
                                                 RDOSET2   

                RALINEOUT                       RLOSET1   
                                                 RLOSET2   

                REQLINE                         RLNSET1    ACCOUNTS
                                                 RLNSET2    LINE-COMMENTS
                                                 RLNSET3   MMUAVAL
                                                 RLNSET4   RQLINEDTL
                                                 RLNSET5   WHDEMAND
                                                 RLNSET6   WHSHIPLINE
                                                 RLNSET7   
                                                 RLNSET8   

                RETURNCOMM                      RTCSET1   

                RETURNDTL                       RLDSET1   OEINVCDTL
                                                           RETURNLINE

                RETURNLINE                      RTLSET1   RETURNDTL
                                                 RTLSET2   RETURNSGBK

                RETURNSGBK                      RSBSET1   RETURNLINE

                RJCONTROL            

                RJMXVALUE                       RMVSET1   

                RJTRANS                         RJTSET1   RJMXVALUE

                RQCOMMENTS                      RCMSET1    REQ-LINE

                RQLINEDTL                       RQDSET1    REQ-LINE
                                                            RETURN-DETAIL

                RQTEMPLINE                      RQXSET1   
                                                 RQXSET3   

                RQTRANS                         RQTSET1    REQ-LINE
                                                 RQTSET2   
                                                 RQTSET3   

                RWDRILL                         RDDSET1   

                RWFORMAT                        RWFSET1   
                                                 RWFSET2   
                                                 RWFSET4   

                RWHEADER             

                RWROWDET                        RRDSET1   

                SABOOKAOC                       SAASET1   SABOOKLINE

                SABOOKCOMP                      SBCSET1   SABOOKLINE

                SABOOKLINE                      SALSET1   SABOOKAOC

                SAINVCAOC                       SIASET1   SAINVCLINE
                                                 SIASET2   

                SAINVCCOMP                      SICSET1   SAINVCLINE

                SAINVCLINE                      SILSET1   SAINVCAOC
                                                 SILSET2   
                                                 SILSET3   

                STPOLINE                        SPLSET1   MMDIST
                                                 SPLSET3   POAOCDTL
                                                           POCOMMENTS

                WHDEMAND                        WDMSET1    BINS
                                                 WDMSET2    CASELINE
                                                 WDMSET3   COLINE
                                                 WDMSET4    LOTS
                                                 WDMSET5   REQLINE
                                                 WDMSET6   RETURNLINE
                                                 WDMSET7    UOMS
                                                           WHDEMNDDTL

                WHDEMNDCMT                      WDCSET1   

                WHDEMNDDTL                      WDDSET1   WHDEMAND

                WHSCMNTOUT                      WIOSET1   
                                                 WIOSET2   

                WHSCOMPOUT                      WCOSET1   
                                                 WCOSET2   

                WHSHIPCOMP                      WHCSET1    SHIPLINE
                                                 WHCSET2    SHIPLNEDTL

                WHSHIPLINE                      WHLSET1    ATTACHED-BINS
                                                 WHLSET2    ATTACHED-LOTS
                                                 WHLSET3    ATTACHED-RSERS
                                                 WHLSET4    ATTACHED-SERS
                                                            ATTACHED-UOMS
                                                            CASELINE
                                                           COLINE
                                                           REQLINE
                                                            SHIPLNEDTL
                                                           WHDEMAND
                                                           WHSHIPCOMP
                                                           WHSHLAUD
                                                           WHWEBTRACK

                WHSHLAUD                        WHASET1   
                                                 WHASET2   

                WHSHLDTL                        WHDSET1    SHIPCOMP
                                                 WHDSET2    SHIPLINE

                WHSHLINEIN                      WLISET1   
                                                 WLISET2   

                WHSLINEOUT                      WLOSET1   
                                                 WLOSET2   

                WHWEBTRACK                      WSTSET1   

                WOSCHEDULE                      WOSSET2   WHDEMAND-DOC
                                                 WOSSET5   


                 In File     CndUsage                 DerivedUsage
                 --------------------------------------------------------------
                ACALLOCX    

                ACCATRANS   

                ACCOMTMPX   

                ARIITEM     

                AROITEMS    

                BLRICCOMM   

                BLRICLINE   

                BLRICMISC   

                BLRICSGBLK  

                BLRIMCOMM   

                BLRIMLINE   

                BLRIMMISC   LINE-CHARGE              

                BLRIMSGBLK  

                CADETAIL    

                CATRANS     

                CBSTMTDTL   

                COCOMP      

                COLINE      

                COLINEDTL   

                COLINEUOM   

                COMISC     COLINE                   
                             LINE-ADD-ON              
                             LINE-PCT                 
                             LINE-UNIT-PRC            
                             ORDER-AOC                
                             ORDER-PCT                
                             SHIPPED                  
                             SHIPPED-LINE             

                COSGBLK     

                CXCPIUAVAL  

                CXCTIUAVAL  

                CXITEMHIST  

                CXPREFITEM  

                CXPTMPITEM  

                ERSAOCDTL   

                GLCONTROL   

                GLCONVJE    

                GLJELOG     JE-CNTRL-LOG             
                             JE-CREATED               
                             JE-LINE-LOG              
                             JE-RECORD                

                GLTRANS     

                ICACTIVITY  

                ICCTRNDTL   

                ICCTRNHDR   

                ICCTRNLIN   

                ICRECEIPTS  

                ICTRANS     

                ICTRANSDTL  

                MACRECAOC   

                MACRECLINE  

                MACRECPOT   

                MMDIST      

                MMUAVAL     

                OEAUDIT    COLINE                   

                OECREDOVR   

                OEDIST      LINE-POSTING             
                             MISC-POSTING             

                OEINVCCOMM  BOTTOM-COMM              
                            OEINVCLINE               
                             TOP-COMM                 

                OEINVCDTL   

                OEINVCLINE  

                OEINVCMISC  LINE-CHARGE              
                             LINE-PCT                 
                             LINE-UNIT-PRC            
                             ORDER-PCT                

                OEINVCTAX   AOC-TAX                  
                             LINE-TAX                 

                OEINVCUOM   

                OEINVSGBLK  

                OEORDCMNT  COLINE                   
                             HDR-COMMENT              
                             TRL-COMMENT              

                OERETCMTIN  

                OERETLNIN   

                OESTDLINE   

                OIINVCCOMM  

                OIINVCLINE  

                OIINVCMISC  

                OISGBLK     

                PBHSTDTL    

                POAOCDTL    DETAILAOC                
                             MISCAOC                  
                             PO-LINE-DTL              
                            POLINEDTL                
                            STPOLINE                 

                POAPPROVE   LINE-APPV                
                             LINEAOCAPPROVL           
                             LINEAPPROVAL             
                             MISCAOCAPPROVL           
                             ORIG-PO-LINE             

                POCOMMENTS POLINE                   
                            STPOLINE                 
                             STPURCHORD               

                POCOMOUT    

                POINTAOC    

                POINTCMTS   

                POINTERFAC  

                POLINE      ORIGINAL-LINE            
                             PLISET3                  
                             SUBSTITUTE               
                            POAOCDTL:ORIGINAL-LINE   
                            POAPPROVE:ORIG-PO-LINE   
                            POAPPROVE:ORIGINAL-LINE  
                             POAUDIT:ORIGINAL-LINE    
                            POCOMMENTS:ORIGINAL-LINE 
                            PORECLINE:ORIGINAL-LINE  
                            POAOCDTL:PO-LINE-DTL     

                POLINEOUT   

                POMESSAGE  POLINE                   

                PORECLINE   ORIG-RECEIVING           
                            POCOMMENTS               
                             SUB-RECEIVING            

                RACMNTOUT   

                RALDTLOUT   

                RALINEOUT   

                REQLINE     

                RETURNCOMM  HEADER-COMMENT           

                RETURNDTL   Z                        

                RETURNLINE  

                RETURNSGBK  

                RJCONTROL   

                RJMXVALUE   

                RJTRANS     

                RQCOMMENTS  REQ                      
                             REQ-LINE                 

                RQLINEDTL   

                RQTEMPLINE  

                RQTRANS     

                RWDRILL     

                RWFORMAT    

                RWHEADER    

                RWROWDET    

                SABOOKAOC   LINE-AOC                 

                SABOOKCOMP  

                SABOOKLINE  

                SAINVCAOC   LINE-AOC                 

                SAINVCCOMP  

                SAINVCLINE  

                STPOLINE    

                WHDEMAND    

                WHDEMNDCMT  

                WHDEMNDDTL  

                WHSCMNTOUT  

                WHSCOMPOUT  

                WHSHIPCOMP  

                WHSHIPLINE  

                WHSHLAUD    

                WHSHLDTL    

                WHSHLINEIN  

                WHSLINEOUT  

                WHWEBTRACK  

                WOSCHEDULE  DETAIL-SCHEDUL           


                 In File     RuleUsage
                 --------------------------------------------------------------
                ACALLOCX    

                ACCATRANS   

                ACCOMTMPX   

                ARIITEM     

                AROITEMS    

                BLRICCOMM   

                BLRICLINE   

                BLRICMISC   

                BLRICSGBLK  

                BLRIMCOMM   

                BLRIMLINE   AutoSeq, EDIT, ADD

                BLRIMMISC   

                BLRIMSGBLK  

                CADETAIL    

                CATRANS     

                CBSTMTDTL   

                COCOMP      

                COLINE      

                COLINEDTL   

                COLINEUOM   

                COMISC      

                COSGBLK     

                CXCPIUAVAL  

                CXCTIUAVAL  

                CXITEMHIST  

                CXPREFITEM  AutoSeq, EDIT, ADD

                CXPTMPITEM  

                ERSAOCDTL   

                GLCONTROL   

                GLCONVJE    

                GLJELOG     

                GLTRANS     

                ICACTIVITY  

                ICCTRNDTL   

                ICCTRNHDR   

                ICCTRNLIN   

                ICRECEIPTS  

                ICTRANS     

                ICTRANSDTL  

                MACRECAOC   

                MACRECLINE  

                MACRECPOT   

                MMDIST      

                MMUAVAL     

                OEAUDIT     

                OECREDOVR   

                OEDIST      

                OEINVCCOMM  

                OEINVCDTL   

                OEINVCLINE  Req
                             AutoSeq, EDIT, ADD

                OEINVCMISC  

                OEINVCTAX   

                OEINVCUOM   

                OEINVSGBLK  

                OEORDCMNT   

                OERETCMTIN  

                OERETLNIN   

                OESTDLINE   AutoSeq, EDIT, ADD

                OIINVCCOMM  

                OIINVCLINE  

                OIINVCMISC  

                OISGBLK     

                PBHSTDTL    

                POAOCDTL    

                POAPPROVE   

                POCOMMENTS  

                POCOMOUT    

                POINTAOC    

                POINTCMTS   

                POINTERFAC  

                POLINE      Default
                             AutoSeq, EDIT, ADD

                POLINEOUT   

                POMESSAGE   

                PORECLINE   

                RACMNTOUT   

                RALDTLOUT   

                RALINEOUT   

                REQLINE     

                RETURNCOMM  

                RETURNDTL   

                RETURNLINE  

                RETURNSGBK  

                RJCONTROL   

                RJMXVALUE   

                RJTRANS     

                RQCOMMENTS  

                RQLINEDTL   

                RQTEMPLINE  

                RQTRANS     

                RWDRILL     

                RWFORMAT    

                RWHEADER    

                RWROWDET    

                SABOOKAOC   

                SABOOKCOMP  

                SABOOKLINE  

                SAINVCAOC   

                SAINVCCOMP  

                SAINVCLINE  

                STPOLINE    AutoSeq, EDIT, ADD

                WHDEMAND    

                WHDEMNDCMT  

                WHDEMNDDTL  

                WHSCMNTOUT  

                WHSCOMPOUT  

                WHSHIPCOMP  

                WHSHIPLINE  

                WHSHLAUD    

                WHSHLDTL    

                WHSHLINEIN  

                WHSLINEOUT  

                WHWEBTRACK  

                WOSCHEDULE