Lawson Insight Technical Documentation


ERDs Tables Elements Libraries App Forms

                              FIELD USAGE REPORT


  Element        In File    Occurs    FldType    IndexUsg   Relation
-------------------------------------------------------------------------------
  LOCATION      BINGROUP             FT_DB      BGRSET1   BINGRPDTL
                                                 BGRSET2    LOCATION

                BINGRPDTL                       BGDSET1    BIN
                                                 BGDSET2   BINGROUP

                BINSTORAGE                      BSTSET1    LOCATION

                BLRICUST                                   ICLOCATION

                BLRIMAST                                   ICLOCATION

                BUYER                                      ICLOCATION

                COMPONENT                       COMSET1   KITITEM
                                                 COMSET2   KTINSTRUCT
                                                 COMSET3   

                FROPTIONS                                  ICLOCATION

                ICACCURACY                      ACCSET1    LOCATION

                ICACTIVITY                      IACSET1   ICTRANS
                                                 IACSET2    LOCATION
                                                           MMUAVAL

                ICAUDIT                         IAUSET1    LOCATION

                ICBIN                           ICBSET1   BINSTORAGE
                                                 ICBSET3    LOCATION
                                                 ICBSET4    STOCKONHAND

                ICBRDNTMPL                      IBTSET1   ICFGBRDN
                                                 IBTSET2   ICLOCATION

                ICCATEGORY                      ICASET1   ICLOCATION

                ICCOUT                          OWCSET1   
                                                 OWCSET2   

                ICCPHYINV                       IPISET1   
                                                 IPISET2   

                ICCTRNDTL                       ITDSET1   

                ICCTRNHDR                       ITHSET1   ICCTRNLIN
                                                 ITHSET2   

                ICCTRNLIN                       ITNSET1   ICCTRNDTL

                ICFGBRDN                        IBRSET1   ICBRDNTMPL
                                                 IBRSET2   

                ICFGBYPROD                      ICPSET1   
                                                 ICPSET2   

                ICFORECAST                      IFOSET1   ICHISTORY
                                                            LOCATION

                ICFREEZE                        ICFSET2   BINGROUP
                                                           BINGRPDTL
                                                           ITEMLOC
                                                           SOHDETAIL

                ICHISTORY                       ICHSET1   ICLOCATION
                                                 ICHSET2   ITEMLOC

                ICITLLBL                        ILLSET1   
                                                 ILLSET2   

                ICLOCATION                      ICLSET1   ICBIN
                                                 ICLSET2   ICCATEGORY
                                                           ICLOCGRP
                                                           ITEMLOC

                ICLOCGRP                        ILGSET1    ICLOC
                                                 ILGSET2   

                ICLOT                           ILTSET1   ICLOCATION
                                                           ITEMLOC
                                                           SOHDETAIL

                ICPLANORD                       IPLSET1   ICLOCATION
                                                 IPLSET2   ITEMLOC
                                                 IPLSET3   
                                                 IPLSET4   

                ICRECEIPTS                      ICRSET1   ICLOCATION
                                                 ICRSET2   ITEMLOC
                                                 ICRSET3   
                                                 ICRSET4   
                                                 ICRSET5   

                ICRPTGRP                        IRGSET1    LOCATION
                                                 IRGSET2   

                ICTRANS                         ICTSET1    ACCOUNTS
                                                 ICTSET2   ICLOCATION
                                                 ICTSET3   ICTRANSDTL
                                                 ICTSET4   ITEMLOC
                                                 ICTSET5   MMUAVAL
                                                 ICTSET7   

                ICTRANSDTL                      ICDSET1    BIN
                                                 ICDSET2   
                                                 ICDSET3   

                ITEMFORMAT           

                ITEMLOC                         ITLSET1   BINGRPDTL
                                                 ITLSET2   BINGRPDTL
                                                 ITLSET5    FORECAST
                                                 ITLSET6   ICCATEGORY
                                                 ITLSET7   ICHISTORY
                                                 ITLSET8   ICPLANORD
                                                            ICT-BY-DATE
                                                            LOCATION
                                                           POLINE
                                                           PORECLINE
                                                            PREFERRED-BIN
                                                            REPL-FROM-BIN
                                                            SOH-DET-PATH-3
                                                           SOHDETAIL
                                                            STORAGE-CODE
                                                           WHDEMAND

                ITEMLOCBIN                      ILBSET1   ICLOCATION
                                                           SOHDETAIL

                ITSERIAL                        SERSET2   ITEMLOC
                                                 SERSET3    LOCATION

                KITITEM                         KITSET1   COMPONENT
                                                 KITSET2    FGBURDEN
                                                            FGBYPROD
                                                           ICLOCATION
                                                           KTINSTRUCT
                                                           WORDER

                KTINSTRUCT                      KTISET1   COMPONENT
                                                           KITITEM

                MACRECHDR            

                MACRECLINE           

                MMDIST                          MMDSET1   ICTRANS
                                                 MMDSET2   WHSHIPLINE
                                                 MMDSET3   

                MMUAVAL                         MUASET1   

                OEBASE                          OEBSET1   ICLOCATION
                                                 OEBSET2   OEBPAUDIT
                                                 OEBSET3   

                OEBPAUDIT                       OBASET1   ICLOCATION
                                                           OEBASE

                OEINVCLINE                                  OEINVCDTL:ITEMLOC
                                                           ICCATEGORY
                                                           ITEMLOC
                                                            OESHIPLINE
                                                            OESHIPMENT

                OEINVOICE                                  ICLOCATION
                                                           WHSHIPMENT

                OERETCMTIN                      RCISET3   

                OERETHDRIN                      RHISET3   

                OERETLNIN                       RLISET3   

                OEROUTE                         ORTSET1   ICLOCATION
                                                 ORTSET2   

                OIINVCLINE           

                OIINVOICE            

                POAOCDTL                                   ICLOCATION
                                                           POLINE-DLV-DTE

                POAUDIT              

                POHDROUT                        PHOSET3    HDROUTICCOUT

                POINTERFAC                      PIFSET3   ICLOCATION
                                                 PIFSET4   ITEMLOC
                                                 PIFSET5   

                POLINE                          PLISET3    POAPPROVE:ITEMLOC
                                                 PLISET4    POAPPROVE:LOCATION
                                                 PLISET5   ICCATEGORY
                                                 PLISET6   ICLOCATION
                                                 PLISET8   ITEMLOC
                                                           POQUOTES

                POLINEOUT            

                POMESSAGE            

                POQUOTES                        POQSET1   ICLOCATION
                                                 POQSET2   ITEMLOC
                                                 POQSET3   
                                                 POQSET5   

                PORECEIVE                       PORSET4   ICLOCATION
                                                 PORSET6   

                PORECLINE                       PRLSET3   POMESSAGE:ITEMLOC
                                                 PRLSET6   ICBIN
                                                 PRLSET7   ICCATEGORY
                                                 PRLSET8   ICLOCATION
                                                 PRLSET9   ICTRANSDTL
                                                           ITEMLOC

                PURCHORDER                      PCRSET4    POCOMMENTS:ICLOCATION
                                                           ICLOCATION

                RACMNTOUT                       RCOSET2   

                RAHDROUT                        RHOSET2   

                RALDTLOUT                       RDOSET2   

                RALINEOUT                       RLOSET2   

                RETURNHDR                                  ICLOCATION

                RETURNLINE                                  RETURNDTL:ITEMLOC
                                                            RETURNDTL:SOHDETAIL
                                                            BINS
                                                           ICLOCATION
                                                           ITEMLOC
                                                            LOTS
                                                            OESHIPDTL
                                                            SERIALS
                                                           SOHDETAIL
                                                            UOMS

                ROUTEDOC                        RDCSET1   ICLOCATION
                                                           ROUTEHDR
                                                           ROUTESTOP

                ROUTEHDR                        RTESET1   ICLOCATION
                                                 RTESET2   ROUTESTOP

                ROUTESTOP                       RTSSET1   ICLOCATION
                                                           ROUTEDOC
                                                           ROUTEHDR

                SABOOKED             

                SAINVOICE            

                SAPERFORM                       SPFSET1   
                                                 SPFSET2   

                SOHDETAIL                       SDTSET1   ICBIN
                                                 SDTSET2   ICLOT
                                                 SDTSET3   ITEMLOC
                                                 SDTSET4    LOCATION

                STPURCHORD                                  STPOLINE:ITEMLOC
                                                            STPOLINE:POQUOTES
                                                           ICLOCATION

                WHBATCH                         WHBSET1   ICLOCATION
                                                            SHIPMENT

                WHDEMAND                        WDMSET2   ICLOCATION
                                                 WDMSET3   ITEMLOC
                                                 WDMSET4    WHDEMNDDTL:ICLOCATION
                                                 WDMSET5    WHDEMNDDTL:ITEMLOC
                                                 WDMSET6    WHDEMNDDTL:SOHDETAIL
                                                 WDMSET7   

                WHSCOMPOUT                      WCOSET1   
                                                 WCOSET2   

                WHSHIPCOMP                      WHCSET1   ICLOCATION
                                                 WHCSET2    SHIPLINE
                                                            SHIPLNEDTL
                                                            SHIPMENT

                WHSHIPLINE                      WHLSET1   WHSHIPCOMP:ITEMLOC
                                                 WHLSET3    ATTACHED-BINS
                                                 WHLSET4    ATTACHED-LOTS
                                                            ATTACHED-RSERS
                                                            ATTACHED-SERS
                                                            ATTACHED-UOMS
                                                            BINS
                                                           ICLOCATION
                                                           ITEMLOC
                                                            LOTS
                                                            SHIPLNEDTL
                                                            SHIPMENT
                                                           SOHDETAIL
                                                            UOMS
                                                           WHSHIPCOMP
                                                           WHSHLAUD
                                                           WHWEBTRACK
                                                           WHSHLDTL:ITEMLOC

                WHSHIPMENT                      WHSSET1   ICLOCATION
                                                 WHSSET2    NO-DETAILS
                                                 WHSSET3    SHIPLINE
                                                 WHSSET4    SHIPLNEDTL
                                                 WHSSET5   
                                                 WHSSET6   
                                                 WHSSET7   

                WHSHLAUD                        WHASET1   
                                                 WHASET2   

                WHSHLDTL                        WHDSET1   ICLOCATION
                                                 WHDSET2    SHIPCOMP
                                                            SHIPLINE
                                                            SHIPMENT
                                                           SOHDETAIL

                WHSHLINEIN                      WLISET1   
                                                 WLISET2   

                WHSHPMNTIN                      WSISET1   
                                                 WSISET2   
                                                 WSISET3   

                WHSHPMTOUT                      WSOSET1   
                                                 WSOSET2   
                                                 WSOSET3   

                WHSLINEOUT                      WLOSET1   
                                                 WLOSET2   

                WHWEBTRACK                      WSTSET1   

                WOBRDN                          WBNSET1   ICBRDNTMPL
                                                 WBNSET2   WORDER
                                                           WOSGBLK

                WOBYPROD                        WOBSET1    BINS
                                                 WOBSET2   ICLOCATION
                                                           ITEMLOC
                                                            LOTS
                                                            SERIALS
                                                            UOMS
                                                           WODETAIL
                                                           WORDER

                WODETAIL                        WODSET1   ICTRANSDTL
                                                 WODSET2   ITEMLOC
                                                 WODSET4   SOHDETAIL
                                                           WOITEM

                WODMNDFCST                      WDFSET1   ICLOCATION
                                                 WDFSET2   
                                                 WDFSET4   

                WOITEM                          WOISET1    BINS
                                                 WOISET2    LOTS
                                                 WOISET3    SERIALS
                                                 WOISET4    SOHBINS
                                                 WOISET5    SOHLOTS
                                                            UOMS
                                                            WO-LOCATION
                                                           WODETAIL
                                                           WORDER
                                                           WOSGBLK

                WORDER                          WORSET1    BIN-DETAILS
                                                 WORSET2   ICLOCATION
                                                 WORSET3   ITEMLOC
                                                 WORSET4    ITEMS-BY-LOC
                                                 WORSET5    LOT-DETAILS
                                                 WORSET6    SERIAL-DETAILS
                                                 WORSET7    UOM-DETAILS
                                                           WHDEMAND
                                                            WHSUPPLY
                                                            WOBURDEN
                                                           WOBYPROD
                                                            WOCOMP
                                                           WODETAIL
                                                           WOITEM
                                                           WOSGBLK

                WOSCHEDHDR                      WOHSET1   ICLOCATION
                                                           ITEMLOC

                WOSGBLK                         WSBSET1   WOBRDN
                                                           WOITEM
                                                           WORDER


                 In File     CndUsage                 DerivedUsage
                 --------------------------------------------------------------
                BINGROUP    

                BINGRPDTL   

                BINSTORAGE  

                BLRICUST    LOCATION-ENTRD           

                BLRIMAST    LOCATION-ENTRD           

                BUYER       

                COMPONENT   

                FROPTIONS   

                ICACCURACY  

                ICACTIVITY  

                ICAUDIT     

                ICBIN       

                ICBRDNTMPL  

                ICCATEGORY  

                ICCOUT      

                ICCPHYINV   

                ICCTRNDTL   

                ICCTRNHDR   

                ICCTRNLIN   

                ICFGBRDN    

                ICFGBYPROD  

                ICFORECAST  

                ICFREEZE    

                ICHISTORY   

                ICITLLBL    

                ICLOCATION  

                ICLOCGRP    

                ICLOT       

                ICPLANORD   

                ICRECEIPTS  

                ICRPTGRP    

                ICTRANS     

                ICTRANSDTL  

                ITEMFORMAT  

                ITEMLOC     

                ITEMLOCBIN  

                ITSERIAL    

                KITITEM    ICLOCATION               

                KTINSTRUCT  

                MACRECHDR   

                MACRECLINE  

                MMDIST      

                MMUAVAL     

                OEBASE     ICLOCATION               

                OEBPAUDIT  ICLOCATION               

                OEINVCLINE  

                OEINVOICE   

                OERETCMTIN  

                OERETHDRIN  

                OERETLNIN   

                OEROUTE     

                OIINVCLINE  

                OIINVOICE   

                POAOCDTL    

                POAUDIT     

                POHDROUT    

                POINTERFAC  

                POLINE     POQUOTESWIN              POAPPROVE:LINE-LOCATION

                POLINEOUT   

                POMESSAGE   

                POQUOTES   POLINE:POQUOTESWIN       

                PORECEIVE  ICLOCATION               

                PORECLINE   

                PURCHORDER  

                RACMNTOUT   

                RAHDROUT    

                RALDTLOUT   

                RALINEOUT   

                RETURNHDR   

                RETURNLINE  

                ROUTEDOC    

                ROUTEHDR    

                ROUTESTOP   

                SABOOKED    

                SAINVOICE   

                SAPERFORM   

                SOHDETAIL   

                STPURCHORD  

                WHBATCH     

                WHDEMAND    

                WHSCOMPOUT  

                WHSHIPCOMP  

                WHSHIPLINE  

                WHSHIPMENT  

                WHSHLAUD    

                WHSHLDTL    

                WHSHLINEIN  

                WHSHPMNTIN  

                WHSHPMTOUT  

                WHSLINEOUT  

                WHWEBTRACK  

                WOBRDN      

                WOBYPROD    

                WODETAIL    

                WODMNDFCST  

                WOITEM      DIFF-LOCATION            

                WORDER      

                WOSCHEDHDR  

                WOSGBLK     


                 In File     RuleUsage
                 --------------------------------------------------------------
                BINGROUP    

                BINGRPDTL   

                BINSTORAGE  

                BLRICUST    

                BLRIMAST    Req, EDIT, ADD

                BUYER       DefaultPURCHORDER:

                COMPONENT   

                FROPTIONS   

                ICACCURACY  

                ICACTIVITY  

                ICAUDIT     

                ICBIN       

                ICBRDNTMPL  

                ICCATEGORY  

                ICCOUT      

                ICCPHYINV   

                ICCTRNDTL   

                ICCTRNHDR   

                ICCTRNLIN   

                ICFGBRDN    

                ICFGBYPROD  

                ICFORECAST  

                ICFREEZE    

                ICHISTORY   

                ICITLLBL    

                ICLOCATION  

                ICLOCGRP    

                ICLOT       

                ICPLANORD   

                ICRECEIPTS  

                ICRPTGRP    

                ICTRANS     

                ICTRANSDTL  

                ITEMFORMAT  

                ITEMLOC     

                ITEMLOCBIN  

                ITSERIAL    

                KITITEM     

                KTINSTRUCT  

                MACRECHDR   

                MACRECLINE  

                MMDIST      

                MMUAVAL     

                OEBASE      Req
                             NoEnt
                             Assign, EDIT, ADD
                             Assign, EDIT, CHANGE
                             Assign, EDIT, DELETE

                OEBPAUDIT   AssignOEBASE:EDIT, ADD
                             AssignOEBASE:EDIT, CHANGE
                             AssignOEBASE:EDIT, DELETE

                OEINVCLINE  Req
                             Default

                OEINVOICE   DefaultOEINVCLINE:

                OERETCMTIN  

                OERETHDRIN  

                OERETLNIN   

                OEROUTE     

                OIINVCLINE  

                OIINVOICE   

                POAOCDTL    Default

                POAUDIT     

                POHDROUT    

                POINTERFAC  

                POLINE      Default

                POLINEOUT   

                POMESSAGE   

                POQUOTES    

                PORECEIVE   DefaultPORECLINE:

                PORECLINE   Default

                PURCHORDER  Default
                             DefaultPOAOCDTL:
                             DefaultPOLINE:

                RACMNTOUT   

                RAHDROUT    

                RALDTLOUT   

                RALINEOUT   

                RETURNHDR   

                RETURNLINE  

                ROUTEDOC    

                ROUTEHDR    

                ROUTESTOP   

                SABOOKED    

                SAINVOICE   

                SAPERFORM   

                SOHDETAIL   

                STPURCHORD  

                WHBATCH     

                WHDEMAND    

                WHSCOMPOUT  

                WHSHIPCOMP  

                WHSHIPLINE  

                WHSHIPMENT  

                WHSHLAUD    

                WHSHLDTL    

                WHSHLINEIN  

                WHSHPMNTIN  

                WHSHPMTOUT  

                WHSLINEOUT  

                WHWEBTRACK  

                WOBRDN      

                WOBYPROD    

                WODETAIL    

                WODMNDFCST  

                WOITEM      

                WORDER      

                WOSCHEDHDR  

                WOSGBLK