Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                              FIELD USAGE REPORT


  Element        In File    Occurs    FldType    IndexUsg   Relation
-------------------------------------------------------------------------------
  ITEM          ACCOMMITX            FT_DB      ITEMMAST
  Alpha, 32         
                ARIITEM              

                ARITEM               

                AROITEMS             

                BILLOPER                        BOPSET1   ITEMMAST
                                                 BOPSET2   

                BLRICLINE                       BULSET3   ITEMMAST
                                                 BULSET4   

                BLRIMLINE                                  ITEMMAST

                COCOMP                          CKTSET3   ITEMLOC
                                                           ITEMMAST

                COLINE                          COLSET2   COCOMP:COMPONENT
                                                 COLSET3   COCOMP:KITITEM
                                                           COCOMP:OPTIONS-COMP
                                                            COMPANIONS
                                                           COMPONENT
                                                            HDRLOC
                                                            ITEMCOMPANION
                                                           ITEMLOC
                                                           ITEMLOCATION
                                                           ITEMMAST
                                                           ITEMSUB
                                                           ITSERIAL
                                                           KITITEM
                                                            RETURNLINE
                                                            SOHBINS
                                                           SOHDETAIL
                                                            SUBSTITUTIONS
                                                           COLINEUOM:ITEMMAST

                COMPONENT                       COMSET2   ITEMMAST
                                                 COMSET3   

                CXITEMHIST                      CIHSET2   

                CXPREFITEM                      CPISET4    GEN-TEMP-ITEM
                                                           HCCHRGITEM
                                                            ITEM-LOCATION
                                                           ITEMMAST
                                                           ITEMSUB
                                                            PRAC-TEMP-ITEM

                CXPTMPITEM                      CTISET2    ITEM
                                                            ITEM-LOCATION
                                                           ITEMSUB

                HCCHRGITEM                      HCISET1   ITEMMAST
                                                 HCISET2   

                HCPATCHRG                       HPRSET1   HCCHRGITEM
                                                 HPRSET2   ITEMLOC
                                                           ITEMMAST

                ICAUDIT                         IAUSET1   ITEMMAST

                ICCPHYINV                       IPISET1   
                                                 IPISET2   

                ICCTRNDTL            

                ICCTRNLIN            

                ICFGBRDN                        IBRSET1   
                                                 IBRSET2   

                ICFGBYPROD                      ICPSET2   ITEMMAST

                ICFORECAST                      IFOSET1   ICHISTORY
                                                           ITEMMAST

                ICFREEZE                        ICFSET2   ITEMLOC
                                                           ITEMMAST
                                                           ITSERIAL
                                                           SOHDETAIL

                ICHISTORY                       ICHSET1   ITEMLOC
                                                 ICHSET2   ITEMMAST

                ICITEUF                         UFMSET1   

                ICITLLBL                        ILLSET1   
                                                 ILLSET2   

                ICITLUF                         UFLSET1   

                ICITSUF                         UFSSET1   

                ICLOT                           ILTSET1   ITEMLOC
                                                           ITEMMAST
                                                           SOHDETAIL

                ICPLANORD                       IPLSET1   ITEMLOC
                                                 IPLSET2   ITEMMAST
                                                 IPLSET3   
                                                 IPLSET4   

                ICRECEIPTS                      ICRSET1   ITEMLOC
                                                 ICRSET2   ITEMMAST
                                                 ICRSET3   
                                                 ICRSET4   
                                                 ICRSET5   

                ICSELECT     36                            ITEMMAST

                ICTRANS                         ICTSET2   ITEMLOC
                                                 ICTSET3   ITEMMAST
                                                 ICTSET4    SERIAL
                                                 ICTSET5   
                                                 ICTSET7   

                ICTRANSDTL                      ICDSET2    ITEM
                                                 ICDSET3   ITSERIAL
                                                 ICDSET4   

                ITCOMMENT                       ICOSET1   ITEMMASTER

                ITEMADDON                       ITASET1   ITEMMAST

                ITEMASTOUT                      ITOSET1   
                                                 ITOSET2   
                                                 ITOSET3   

                ITEMLOC                         ITLSET1    FORECAST
                                                 ITLSET2   ICHISTORY
                                                 ITLSET5   ICPLANORD
                                                 ITLSET7    ICT-BY-DATE
                                                 ITLSET8   ITCOMMENT
                                                 ITLSET9   ITEMMAST
                                                           ITEMSRC
                                                            ITLSET2
                                                           ITSERIAL
                                                            PHARITTOITMLOC
                                                           POLINE
                                                           PORECLINE
                                                            REPL-ITEMLOC
                                                            RRPL-ITEMLOC
                                                            SOH-DET-PATH-3
                                                           SOHDETAIL
                                                           WHDEMAND

                ITEMLOCBIN                      ILBSET1   ITEMMAST
                                                           SOHDETAIL

                ITEMMAST                        ITESET1   COCOMP:OPTIONS-GROUP
                                                 ITESET2   ICTRANS:ITCOMMENT
                                                 ITESET3    ITEMCOMMENTS
                                                 ITESET4    ITEMCOMPANION
                                                 ITESET5   ITEMSUB
                                                 ITESET6    ITEMTOPHARITEM
                                                 ITESET7    ITEMTOUPC
                                                 ITESET8    ITEMTOUPN1
                                                            ITEMTOUPN2
                                                            OEDIAGDTL

                ITEMNDC                         IDCSET1   ITEMNDCTOITEM
                                                 IDCSET5   

                ITEMSKU                         ISKSET1   ITEMSKUTOITEM
                                                 ISKSET6   

                ITEMSRC                         ITMSET1   ITEMMAST
                                                 ITMSET2    PHARITTOITMLOC
                                                 ITMSET3   POITEMVEN
                                                 ITMSET4    REPL-ITEMLOC
                                                 ITMSET5   

                ITEMSUB                         ITSSET1   ITEMMAST
                                                 ITSSET2   ITEMMASTER

                ITEMUPC                         IPCSET1   ITEMUPCTOITEM
                                                 IPCSET6   

                ITEMUPN1                        IPNSET1   ITEMUPN1TOITEM
                                                 IPNSET5    UPN1TOITEM

                ITEMUPN2                        IP2SET1   ITEMUPN2TOITEM
                                                 IP2SET5    UPN2TOITEM

                ITSERIAL                        SERSET1   ITEMLOC
                                                 SERSET2   ITEMMAST
                                                 SERSET3   
                                                 SERSET4   

                KITITEM                         KITSET1   COMPONENT
                                                 KITSET2    FGBURDEN
                                                            FGBYPROD
                                                           ITEMMAST
                                                            KTINSTRUCT
                                                           WORDER

                MACINVDTL            

                MACRECLINE           

                MACRECPOT            

                MAINVDTL                        MADSET4   ITEMLOC
                                                           ITEMMAST

                MAINVMSG                        MAGSET3   

                MAMADHIST            

                MSDSACK                         MSASET1   ITEMMAST

                OEBASE                          OEBSET1   ITEMMAST
                                                 OEBSET2   OEBPAUDIT
                                                 OEBSET3   OEPBITEM

                OEBPAUDIT                       OBASET1   ITEMMAST
                                                           OEBASE

                OECUSTITEM                      OCISET1   ITEMMAST
                                                 OCISET2   

                OEINVCLINE                                  OEINVCDTL:ITEMLOC
                                                            OEINVCDTL:ITEMMAST
                                                           ITEMLOC
                                                           ITEMMAST
                                                            RETURNLINE
                                                            OEINVCUOM:ITEMMAST

                OEPBITEM                        PBISET1   ITEMMAST

                OEPLITEM                        OPISET1   ITEMLOC
                                                 OPISET2   ITEMMAST
                                                 OPISET3   
                                                 OPISET5   
                                                 OPISET6   

                OEWKPRICE                       OWPSET1   ITEMMAST
                                                           OEBASE

                OIINVCLINE           

                PHARITEM                        PHISET1   ITEMSRC
                                                 PHISET10   PHARITTOITMLOC
                                                 PHISET11  
                                                 PHISET12  
                                                 PHISET13  
                                                 PHISET2   
                                                 PHISET5   
                                                 PHISET6   
                                                 PHISET7   
                                                 PHISET8   
                                                 PHISET9   

                POBIDITEM                       PBTSET1   
                                                 PBTSET2   
                                                 PBTSET3   

                POINTERFAC                      PIFSET2   ITEMLOC
                                                 PIFSET3   ITEMMAST

                POITEMVEN                       PIVSET1   ITEMMAST
                                                 PIVSET2   POPIVUF
                                                 PIVSET4   
                                                 PIVSET5   

                POLINE                          PLISET6    IPOVAGRMTLN
                                                 PLISET7   ITEMLOC
                                                           ITEMMAST
                                                            PLISET6
                                                           POITEMVEN
                                                            POMESSAGE:ITEMMAST

                POLINEOUT            

                POMAGRMTLN                      PMLSET2   ITEMMAST
                                                 PMLSET4   POITEMVEN
                                                 PMLSET5   

                POPIVUF                         UFISET1   

                PORECLINE                       PRLSET2    POMESSAGE:ITEMLOC
                                                 PRLSET7   ITEMLOC
                                                 PRLSET9   ITEMMAST

                PORETURNLN                                 ITEMLOC
                                                           ITEMMAST
                                                           SOHDETAIL

                POTRANSDTL           

                POVAGRMTLN                      PVNSET2   ITEMNDC
                                                 PVNSET3   
                                                 PVNSET4   
                                                 PVNSET5   
                                                 PVNSET6   
                                                 PVNSET9   

                PROCTEMPLN                      POESET2   ITEMMAST
                                                 POESET3   

                REQLINE                         RLNSET3    ITEM
                                                 RLNSET5    ITEM-LOCATION
                                                 RLNSET6   ITEMSUB
                                                            RQLINEDTL:SERIAL

                RQTEMPLINE                      RQXSET2   

                RQTRANS                         RQTSET2    ITEM
                                                 RQTSET4   ITEMLOC

                SOHDETAIL                       SDTSET1   ICLOT
                                                 SDTSET2    ITEM
                                                 SDTSET3   ITEMLOC
                                                 SDTSET4   

                WHDEMAND                        WDMSET2   ITEMLOC
                                                 WDMSET4   ITEMLOCS
                                                 WDMSET5   ITEMMAST
                                                 WDMSET6   SOHDETAIL
                                                            SUBLOC
                                                            WHDEMNDDTL:ITEMLOC
                                                            WHDEMNDDTL:SOHDETAIL

                WHSCOMPOUT           

                WHSHIPCOMP                      WHCSET2   ITEMLOC
                                                           ITEMMAST
                                                            WHSHLDTL:COM-ITCOMMENT

                WHSHIPLINE                      WHLSET3    BINS
                                                           ITCOMMENT
                                                           ITEMLOC
                                                           ITEMMAST
                                                           ITSERIAL
                                                           ITSERIALS
                                                            LOTS
                                                           SOHDETAIL
                                                            UOMS
                                                            WHSHLDTL:SOH
                                                            WHSHLDTL:SOHDETAIL

                WHSHLINEIN           

                WHSLINEOUT           

                WODMNDFCST                      WDFSET1   ITEMMAST
                                                 WDFSET2   
                                                 WDFSET4   

                WORDER                          WORSET4   ITEMLOC
                                                           ITEMMAST


                 In File     CndUsage                 DerivedUsage
                 --------------------------------------------------------------
                ACCOMMITX   

                ARIITEM     

                ARITEM      

                AROITEMS    

                BILLOPER    ITEM-ENTERED             

                BLRICLINE                            ITEM-16

                BLRIMLINE                            ITEM-16

                COCOMP                               ITEM-16

                COLINE      

                COMPONENT   

                CXITEMHIST  

                CXPREFITEM  

                CXPTMPITEM  

                HCCHRGITEM  

                HCPATCHRG   

                ICAUDIT     

                ICCPHYINV   

                ICCTRNDTL   

                ICCTRNLIN   

                ICFGBRDN    

                ICFGBYPROD  

                ICFORECAST  

                ICFREEZE    

                ICHISTORY   

                ICITEUF     

                ICITLLBL    

                ICITLUF     

                ICITSUF     

                ICLOT       

                ICPLANORD   

                ICRECEIPTS  

                ICSELECT    

                ICTRANS     

                ICTRANSDTL  

                ITCOMMENT   

                ITEMADDON   

                ITEMASTOUT  

                ITEMLOC     

                ITEMLOCBIN  

                ITEMMAST    

                ITEMNDC     

                ITEMSKU     

                ITEMSRC     

                ITEMSUB     

                ITEMUPC     

                ITEMUPN1    

                ITEMUPN2    

                ITSERIAL    

                KITITEM     

                MACINVDTL   

                MACRECLINE  

                MACRECPOT   

                MAINVDTL    

                MAINVMSG    

                MAMADHIST   

                MSDSACK     

                OEBASE      

                OEBPAUDIT   

                OECUSTITEM   3°                     ITEM-16

                OEINVCLINE  ITEM-CHANGED             ITEM-16

                OEPBITEM    

                OEPLITEM    

                OEWKPRICE   

                OIINVCLINE  

                PHARITEM    

                POBIDITEM   RESPONSE-ENTRY           

                POINTERFAC  

                POITEMVEN   

                POLINE      

                POLINEOUT   

                POMAGRMTLN  ITEM-EXISTS              

                POPIVUF     

                PORECLINE   

                PORETURNLN  

                POTRANSDTL  

                POVAGRMTLN  

                PROCTEMPLN  HAS-ITEMSLINE            

                REQLINE     

                RQTEMPLINE  

                RQTRANS     

                SOHDETAIL   

                WHDEMAND    

                WHSCOMPOUT  

                WHSHIPCOMP                           WHSHLDTL:ITEM-X

                WHSHIPLINE                           WHSHLDTL:ITEM-X

                WHSHLINEIN  

                WHSLINEOUT  

                WODMNDFCST  

                WORDER      


                 In File     RuleUsage
                 --------------------------------------------------------------
                ACCOMMITX   

                ARIITEM     

                ARITEM      

                AROITEMS    

                BILLOPER    

                BLRICLINE   

                BLRIMLINE   Req, EDIT, ADD

                COCOMP      

                COLINE      

                COMPONENT   

                CXITEMHIST  

                CXPREFITEM  Default, EDIT, ADD
                             Default, EDIT, ADD

                CXPTMPITEM  DefaultCXPREFITEM:EDIT, ADD
                             DefaultCXPREFITEM:EDIT, ADD

                HCCHRGITEM  

                HCPATCHRG   

                ICAUDIT     

                ICCPHYINV   

                ICCTRNDTL   

                ICCTRNLIN   

                ICFGBRDN    

                ICFGBYPROD  

                ICFORECAST  

                ICFREEZE    

                ICHISTORY   

                ICITEUF     

                ICITLLBL    

                ICITLUF     

                ICITSUF     

                ICLOT       

                ICPLANORD   

                ICRECEIPTS  

                ICSELECT    

                ICTRANS     

                ICTRANSDTL  

                ITCOMMENT   

                ITEMADDON   

                ITEMASTOUT  

                ITEMLOC     

                ITEMLOCBIN  

                ITEMMAST    

                ITEMNDC     

                ITEMSKU     

                ITEMSRC     

                ITEMSUB     

                ITEMUPC     

                ITEMUPN1    

                ITEMUPN2    

                ITSERIAL    

                KITITEM     

                MACINVDTL   

                MACRECLINE  

                MACRECPOT   

                MAINVDTL    

                MAINVMSG    

                MAMADHIST   

                MSDSACK     

                OEBASE      Assign, EDIT, ADD
                             Assign, EDIT, CHANGE
                             Assign, EDIT, DELETE

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

                OECUSTITEM  

                OEINVCLINE  Req

                OEPBITEM    

                OEPLITEM    

                OEWKPRICE   

                OIINVCLINE  

                PHARITEM    

                POBIDITEM   

                POINTERFAC  

                POITEMVEN   

                POLINE      

                POLINEOUT   

                POMAGRMTLN  

                POPIVUF     

                PORECLINE   

                PORETURNLN  

                POTRANSDTL  

                POVAGRMTLN  

                PROCTEMPLN  

                REQLINE     

                RQTEMPLINE  

                RQTRANS     

                SOHDETAIL   

                WHDEMAND    

                WHSCOMPOUT  

                WHSHIPCOMP  

                WHSHIPLINE  

                WHSHLINEIN  

                WHSLINEOUT  

                WODMNDFCST  

                WORDER