Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ITEM


                              FIELD USAGE REPORT


    FIELDNAME - ITEM          

  FieldName      In File     Element        Occurs    FldType    IndexUsg
-------------------------------------------------------------------------------
  ITEM           ACCOMMITX   ITEM                     FT_DB      
                             Alpha, 32         

                 ARIITEM     ITEM                     FT_DB      
                             Alpha, 32         

                 ARITEM      ITEM                     FT_DB      
                             Alpha, 32         

                 AROITEMS    ITEM                     FT_DB      
                             Alpha, 32         

                 BILLOPER    ITEM                     FT_DB      BOPSET1   
                             Alpha, 32                           BOPSET2   

                 BLRICLINE   ITEM                     FT_DB      BULSET4   
                             Alpha, 32         

                 BLRIMLINE   ITEM                     FT_DB      
                             Alpha, 32         

                 COCOMP      ITEM                     FT_DB      
                             Alpha, 32         

                 COLINE      ITEM                     FT_DB      COLSET2   
                             Alpha, 32                           COLSET3   

                 COMPONENT   ITEM                     FT_DB      COMSET2   
                             Alpha, 32                           COMSET3   

                 CXITEMHIST  ITEM                     FT_DB      CIHSET2   
                             Alpha, 32         

                 CXPREFITEM  ITEM                     FT_DB      CPISET4   
                             Alpha, 32         

                 CXPTMPITEM  ITEM                     FT_DB      CTISET2   
                             Alpha, 32         

                 GLCOMMITX   ITEM                     FT_DB      
                             Alpha, 32         

                 HCCHRGITEM  ITEM                     FT_DB      HCISET1   
                             Alpha, 32                           HCISET2   
                                                                 HCISET3   

                 HCPATCHRG   ITEM                     FT_DB      HPRSET1   
                             Alpha, 32                           HPRSET2   

                 ICAUDIT     ITEM                     FT_DB      IAUSET1   
                             Alpha, 32         

                 ICFGBYPROD  ITEM                     FT_DB      ICPSET2   
                             Alpha, 32         

                 ICFORECAST  ITEM                     FT_DB      IFOSET1   
                             Alpha, 32         

                 ICFREEZE    ITEM                     FT_DB      ICFSET2   
                             Alpha, 32         

                 ICHISTORY   ITEM                     FT_DB      ICHSET1   
                             Alpha, 32                           ICHSET2   

                 ICITEUF     ITEM                     FT_DB      UFMSET1   
                             Alpha, 32         

                 ICITLLBL    ITEM                     FT_DB      ILLSET1   
                             Alpha, 32                           ILLSET2   

                 ICITLUF     ITEM                     FT_DB      UFLSET1   
                             Alpha, 32         

                 ICITSUF     ITEM                     FT_DB      UFSSET1   
                             Alpha, 32         

                 ICLOT       ITEM                     FT_DB      ILTSET1   
                             Alpha, 32         

                 ICRECEIPTS  ITEM                     FT_DB      ICRSET1   
                             Alpha, 32                           ICRSET2   
                                                                 ICRSET3   
                                                                 ICRSET4   
                                                                 ICRSET5   

                 ICTRANS     ITEM                     FT_DB      ICTSET2   
                             Alpha, 32                           ICTSET3   
                                                                 ICTSET4   
                                                                 ICTSET5   
                                                                 ICTSET7   

                 ICTRANSDTL  ITEM                     FT_DB      ICDSET2   
                             Alpha, 32                           ICDSET3   
                                                                 ICDSET4   

                 ITCOMMENT   ITEM                     FT_DB      ICOSET1   
                             Alpha, 32         

                 ITEMADDON   ITEM                     FT_DB      ITASET1   
                             Alpha, 32         

                 ITEMASTOUT  ITEM                     FT_DB      ITOSET1   
                             Alpha, 32                           ITOSET2   
                                                                 ITOSET3   

                 ITEMLOC     ITEM                     FT_DB      ITLSET1   
                             Alpha, 32                           ITLSET2   
                                                                 ITLSET5   
                                                                 ITLSET7   
                                                                 ITLSET8   
                                                                 ITLSET9   

                 ITEMMAST    ITEM                     FT_DB      ITESET1   
                             Alpha, 32                           ITESET10  
                                                                 ITESET11  
                                                                 ITESET12  
                                                                 ITESET13  
                                                                 ITESET2   
                                                                 ITESET3   
                                                                 ITESET4   
                                                                 ITESET5   
                                                                 ITESET6   
                                                                 ITESET7   
                                                                 ITESET8   

                 ITEMNDC     ITEM                     FT_DB      IDCSET1   
                             Alpha, 32                           IDCSET5   

                 ITEMSKU     ITEM                     FT_DB      ISKSET1   
                             Alpha, 32                           ISKSET6   

                 ITEMSRC     ITEM                     FT_DB      ITMSET1   
                             Alpha, 32                           ITMSET2   
                                                                 ITMSET3   
                                                                 ITMSET4   
                                                                 ITMSET5   

                 ITEMSUB     ITEM                     FT_DB      ITSSET1   
                             Alpha, 32                           ITSSET2   
                                                                 ITSSET3   

                 ITEMUPC     ITEM                     FT_DB      IPCSET1   
                             Alpha, 32                           IPCSET6   

                 ITEMUPN1    ITEM                     FT_DB      IPNSET1   
                             Alpha, 32                           IPNSET5   

                 ITEMUPN2    ITEM                     FT_DB      IP2SET1   
                             Alpha, 32                           IP2SET5   

                 ITSERIAL    ITEM                     FT_DB      SERSET1   
                             Alpha, 32                           SERSET2   
                                                                 SERSET3   
                                                                 SERSET4   

                 KITITEM     ITEM                     FT_DB      KITSET1   
                             Alpha, 32                           KITSET2   

                 KWDDETAIL   ITEM                     FT_DB      IC2SET1   
                             Alpha, 32                           IC2SET2   
                                                                 IC2SET3   
                                                                 IC2SET4   

                 MAAOCDTL    ITEM                     FT_DB      
                             Alpha, 32         

                 MACINVDTL   ITEM                     FT_DB      
                             Alpha, 32         

                 MACRECLINE  ITEM                     FT_DB      
                             Alpha, 32         

                 MACRECPOT   ITEM                     FT_DB      
                             Alpha, 32         

                 MAINVDTL    ITEM                     FT_DB      MADSET4   
                             Alpha, 32         

                 MAINVMSG    ITEM                     FT_DB      MAGSET3   
                             Alpha, 32         

                 MAMAAHIST   ITEM                     FT_DB      
                             Alpha, 32         

                 MAMADHIST   ITEM                     FT_DB      
                             Alpha, 32         

                 MSDSACK     ITEM                     FT_DB      MSASET1   
                             Alpha, 32         

                 OEBASE      ITEM                     FT_DB      OEBSET1   
                             Alpha, 32                           OEBSET2   
                                                                 OEBSET3   

                 OEBPAUDIT   ITEM                     FT_DB      OBASET1   
                             Alpha, 32         

                 OECUSTITEM  ITEM                     FT_DB      OCISET1   
                             Alpha, 32                           OCISET2   

                 OEINVCLINE  ITEM                     FT_DB      
                             Alpha, 32         

                 OEPBITEM    ITEM                     FT_DB      PBISET1   
                             Alpha, 32         

                 OEPLITEM    ITEM                     FT_DB      OPISET1   
                             Alpha, 32                           OPISET2   
                                                                 OPISET3   
                                                                 OPISET5   
                                                                 OPISET6   

                 OEWKPRICE   ITEM                     FT_DB      OWPSET1   
                             Alpha, 32         

                 OIINVCLINE  ITEM                     FT_DB      
                             Alpha, 32         

                 PDCHRGDTL   ITEM                     FT_DB      
                             Alpha, 32         

                 POBIDITEM   ITEM                     FT_DB      PBTSET1   
                             Alpha, 32                           PBTSET2   
                                                                 PBTSET3   

                 POCLINE     ITEM                     FT_DB      
                             Alpha, 32         

                 POINTERFAC  ITEM                     FT_DB      PIFSET2   
                             Alpha, 32                           PIFSET3   
                                                                 PIFSET9   

                 POITEMVEN   ITEM                     FT_DB      PIVSET1   
                             Alpha, 32                           PIVSET2   
                                                                 PIVSET4   
                                                                 PIVSET5   

                 POLINE      ITEM                     FT_DB      PLISET6   
                             Alpha, 32                           PLISET7   

                 POLINEOUT   ITEM                     FT_DB      
                             Alpha, 32         

                 POLINEPVT   ITEM                     FT_DB      PLPSET2   
                             Alpha, 32                           PLPSET3   
                                                                 PLPSET6   

                 POMATCHOBJ  ITEM                     FT_DB      
                             Alpha, 32         

                 POPIVUF     ITEM                     FT_DB      UFISET1   
                             Alpha, 32         

                 PORECLINE   ITEM                     FT_DB      PRLSET13  
                             Alpha, 32                           PRLSET2   
                                                                 PRLSET7   
                                                                 PRLSET9   

                 PORETURNLN  ITEM                     FT_DB      
                             Alpha, 32         

                 POTRANSDTL  ITEM                     FT_DB      
                             Alpha, 32         

                 POVAGRMTLN  ITEM                     FT_DB      PVNSET2   
                             Alpha, 32                           PVNSET3   
                                                                 PVNSET4   
                                                                 PVNSET5   
                                                                 PVNSET6   
                                                                 PVNSET7   
                                                                 PVNSET9   

                 PROCTEMPLN  ITEM                     FT_DB      POESET2   
                             Alpha, 32                           POESET3   

                 REQLINE     ITEM                     FT_DB      RLNSET3   
                             Alpha, 32                           RLNSET5   
                                                                 RLNSET6   
                                                                 RLNSET8   

                 RETURNLINE  ITEM                     FT_DB      RTLSET2   
                             Alpha, 32                           RTLSET4   

                 RQTRANS     ITEM                     FT_DB      RQTSET2   
                             Alpha, 32                           RQTSET4   

                 SOHDETAIL   ITEM                     FT_DB      SDTSET1   
                             Alpha, 32                           SDTSET2   
                                                                 SDTSET3   
                                                                 SDTSET4   

                 WHDEMAND    ITEM                     FT_DB      WDMSET2   
                             Alpha, 32                           WDMSET4   
                                                                 WDMSET5   
                                                                 WDMSET6   

                 WHDVAUDIT   ITEM                     FT_DB      
                             Alpha, 32         

                 WHSCOMPOUT  ITEM                     FT_DB      
                             Alpha, 32         

                 WHSHIPCOMP  ITEM                     FT_DB      WHCSET2   
                             Alpha, 32         

                 WHSHIPLINE  ITEM                     FT_DB      WHLSET3   
                             Alpha, 32                           WHLSET7   

                 WHSHLINEIN  ITEM                     FT_DB      
                             Alpha, 32         

                 WHSLINEOUT  ITEM                     FT_DB      
                             Alpha, 32         

                 WOBYPROD    ITEM                     FT_DB      
                             Alpha, 32         

                 WODETAIL    ITEM                     FT_DB      WODSET3   
                             Alpha, 32                           WODSET4   

                 WOITEM      ITEM                     FT_DB      
                             Alpha, 32         

                 WORDER      ITEM                     FT_DB      WORSET4   
                             Alpha, 32         


                 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  

                 GLCOMMITX   

                 HCCHRGITEM  

                 HCPATCHRG   

                 ICAUDIT     

                 ICFGBYPROD  

                 ICFORECAST  

                 ICFREEZE    

                 ICHISTORY   

                 ICITEUF     

                 ICITLLBL    

                 ICITLUF     

                 ICITSUF     

                 ICLOT       

                 ICRECEIPTS  

                 ICTRANS     

                 ICTRANSDTL  

                 ITCOMMENT   

                 ITEMADDON   

                 ITEMASTOUT  

                 ITEMLOC     ITEM-ENTERED             

                 ITEMMAST    ITEM-ENTERED             

                 ITEMNDC     

                 ITEMSKU     

                 ITEMSRC     

                 ITEMSUB     ITEM-ENTERED             

                 ITEMUPC     

                 ITEMUPN1    

                 ITEMUPN2    

                 ITSERIAL    

                 KITITEM     ITEM-ENTERED             

                 KWDDETAIL   

                 MAAOCDTL    

                 MACINVDTL   

                 MACRECLINE  

                 MACRECPOT   

                 MAINVDTL    

                 MAINVMSG    

                 MAMAAHIST   

                 MAMADHIST   

                 MSDSACK     

                 OEBASE      

                 OEBPAUDIT   

                 OECUSTITEM  LþC                      ITEM-16

                 OEINVCLINE  ITEM-CHANGED             ITEM-16

                 OEPBITEM    

                 OEPLITEM    

                 OEWKPRICE   

                 OIINVCLINE  

                 PDCHRGDTL   

                 POBIDITEM   RESPONSE-ENTRY           

                 POCLINE     

                 POINTERFAC  

                 POITEMVEN   ITEM-ENTERED             

                 POLINE      

                 POLINEOUT   

                 POLINEPVT   

                 POMATCHOBJ  

                 POPIVUF     

                 PORECLINE   

                 PORETURNLN  

                 POTRANSDTL  

                 POVAGRMTLN  NO-ITEM                  

                 PROCTEMPLN  HAS-ITEMSLINE            

                 REQLINE     

                 RETURNLINE  

                 RQTRANS     

                 SOHDETAIL   

                 WHDEMAND    

                 WHDVAUDIT   

                 WHSCOMPOUT  

                 WHSHIPCOMP                          WHSHLDTL:ITEM-X

                 WHSHIPLINE                          WHSHLDTL:ITEM-X

                 WHSHLINEIN  

                 WHSLINEOUT  

                 WOBYPROD    

                 WODETAIL    

                 WOITEM      

                 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  Default CXPREFITEM:EDIT, ADD
                             Default CXPREFITEM:EDIT, ADD

                 GLCOMMITX   

                 HCCHRGITEM  

                 HCPATCHRG   

                 ICAUDIT     

                 ICFGBYPROD  

                 ICFORECAST  

                 ICFREEZE    

                 ICHISTORY   

                 ICITEUF     

                 ICITLLBL    

                 ICITLUF     

                 ICITSUF     

                 ICLOT       

                 ICRECEIPTS  

                 ICTRANS     

                 ICTRANSDTL  

                 ITCOMMENT   

                 ITEMADDON   

                 ITEMASTOUT  

                 ITEMLOC     

                 ITEMMAST    

                 ITEMNDC     

                 ITEMSKU     

                 ITEMSRC     

                 ITEMSUB     

                 ITEMUPC     

                 ITEMUPN1    

                 ITEMUPN2    

                 ITSERIAL    

                 KITITEM     

                 KWDDETAIL   

                 MAAOCDTL    

                 MACINVDTL   

                 MACRECLINE  

                 MACRECPOT   

                 MAINVDTL    

                 MAINVMSG    

                 MAMAAHIST   

                 MAMADHIST   

                 MSDSACK     

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

                 OEBPAUDIT   Assign OEBASE:EDIT, ADD
                             Assign OEBASE:EDIT, CHANGE
                             Assign OEBASE:EDIT, DELETE

                 OECUSTITEM  

                 OEINVCLINE  Req

                 OEPBITEM    

                 OEPLITEM    

                 OEWKPRICE   

                 OIINVCLINE  

                 PDCHRGDTL   

                 POBIDITEM   

                 POCLINE     

                 POINTERFAC  

                 POITEMVEN   

                 POLINE      

                 POLINEOUT   

                 POLINEPVT   

                 POMATCHOBJ  

                 POPIVUF     

                 PORECLINE   

                 PORETURNLN  

                 POTRANSDTL  

                 POVAGRMTLN  

                 PROCTEMPLN  

                 REQLINE     

                 RETURNLINE  

                 RQTRANS     

                 SOHDETAIL   

                 WHDEMAND    

                 WHDVAUDIT   

                 WHSCOMPOUT  

                 WHSHIPCOMP  

                 WHSHIPLINE  

                 WHSHLINEIN  

                 WHSLINEOUT  

                 WOBYPROD    

                 WODETAIL    

                 WOITEM      

                 WORDER      


                 In File     Relation
                 --------------------------------------------------------------
                 ACCOMMITX    ITEMMAST

                 ARIITEM     

                 ARITEM      

                 AROITEMS    

                 BILLOPER     ITEMMAST

                 BLRICLINE    ITEMMAST

                 BLRIMLINE    ITEMMAST

                 COCOMP       ITEMLOC
                              ITEMMAST

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

                 COMPONENT    COMP-IS-KIT
                              ITEMLOC
                              ITEMMAST

                 CXITEMHIST  

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

                 CXPTMPITEM   ITEM
                              ITEM-LOCATION
                              ITEMSUB

                 GLCOMMITX   

                 HCCHRGITEM   ITEMMAST

                 HCPATCHRG    HCCHRGITEM
                              ITEMLOC
                              ITEMMAST

                 ICAUDIT      ITEMMAST

                 ICFGBYPROD   ITEMMAST

                 ICFORECAST   ICHISTORY
                              ITEMMAST

                 ICFREEZE     ITEMLOC
                              ITEMMAST
                              ITSERIAL
                              SOHDETAIL

                 ICHISTORY    ITEMLOC
                              ITEMMAST

                 ICITEUF      ITEMMAST

                 ICITLLBL    

                 ICITLUF      ITEMLOC

                 ICITSUF     

                 ICLOT        ITEMLOC
                              ITEMMAST
                              SOHDETAIL

                 ICRECEIPTS   ITEMLOC
                              ITEMMAST

                 ICTRANS      ITEMLOC
                              ITEMMAST
                              SERIAL

                 ICTRANSDTL   ITEM
                              ITSERIAL

                 ITCOMMENT    ITEMMASTER

                 ITEMADDON    ITEMMAST

                 ITEMASTOUT  

                 ITEMLOC      FORECAST
                              ICHISTORY
                              ICITLUF
                              ICPLANORD
                              ICT-BY-DATE
                              ITCOMMENT
                              ITEMMAST
                              ITEMSRC
                              ITLSET2
                              ITSERIAL
                              POLINE
                              PORECLINE
                              REPL-ITEMLOC
                              RRPL-ITEMLOC
                              SOH-DET-PATH-3
                              SOHDETAIL
                              WHDEMAND

                 ITEMMAST     COCOMP:OPTIONS-GROUP
                              ICTRANS:ITCOMMENT
                              ICITEUF
                              ITEMCOMMENTS
                              ITEMCOMPANION
                              ITEMSUB
                              ITEMTOUPC
                              ITEMTOUPN1
                              ITEMTOUPN2
                              OEDIAGDTL
                              POITEMVEN

                 ITEMNDC      ITEMNDCTOITEM

                 ITEMSKU      ITEMSKUTOITEM

                 ITEMSRC      ITEMMAST
                              POITEMVEN
                              REPL-ITEMLOC

                 ITEMSUB      ITEMMAST
                              ITEMMASTER

                 ITEMUPC      ITEMUPCTOITEM

                 ITEMUPN1     ITEMUPN1TOITEM
                              UPN1TOITEM

                 ITEMUPN2     ITEMUPN2TOITEM
                              UPN2TOITEM

                 ITSERIAL     ITEMLOC
                              ITEMMAST

                 KITITEM      COMPONENT
                              FGBURDEN
                              FGBYPROD
                              ITEMMAST
                              KTINSTRUCT
                              WORDER

                 KWDDETAIL   

                 MAAOCDTL    

                 MACINVDTL   

                 MACRECLINE  

                 MACRECPOT   

                 MAINVDTL     ITEMLOC
                              ITEMMAST

                 MAINVMSG    

                 MAMAAHIST   

                 MAMADHIST   

                 MSDSACK      ITEMMAST

                 OEBASE       ITEMMAST
                              OEBPAUDIT
                              OEPBITEM

                 OEBPAUDIT    ITEMMAST
                              OEBASE

                 OECUSTITEM   ITEMMAST

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

                 OEPBITEM     ITEMMAST

                 OEPLITEM     ITEMLOC
                              ITEMMAST

                 OEWKPRICE    ITEMMAST
                              OEBASE

                 OIINVCLINE  

                 PDCHRGDTL   

                 POBIDITEM   

                 POCLINE     

                 POINTERFAC   ITEMLOC
                              ITEMMAST

                 POITEMVEN    ITEMMAST
                              ITEMNDC
                              POPIVUF

                 POLINE       IPOVAGRMTLN
                              ITEMLOC
                              ITEMMAST
                              PLISET6
                              POITEMVEN
                              POMESSAGE:ITEMMAST

                 POLINEOUT   

                 POLINEPVT   

                 POMATCHOBJ  

                 POPIVUF      POITEMVEN

                 PORECLINE    POMESSAGE:ITEMLOC
                              ITEMLOC
                              ITEMMAST

                 PORETURNLN   ITEMLOC
                              ITEMMAST
                              SOHDETAIL

                 POTRANSDTL  

                 POVAGRMTLN   ITEMNDC

                 PROCTEMPLN   ITEMMAST

                 REQLINE      ITEM
                              ITEM-LOCATION
                              ITEMSUB
                              RQLINEDTL:SERIAL

                 RETURNLINE   ITEMLOC
                              ITEMMAST
                              SOHDETAIL

                 RQTRANS      ITEM
                              ITEMLOC

                 SOHDETAIL    ICLOT
                              ITEM
                              ITEMLOC

                 WHDEMAND     ITEMLOC
                              ITEMLOCS
                              ITEMMAST
                              SOHDETAIL
                              SUBLOC
                              WHDEMNDDTL:ITEMLOC
                              WHDEMNDDTL:SOHDETAIL

                 WHDVAUDIT   

                 WHSCOMPOUT  

                 WHSHIPCOMP   ITEMLOC
                              ITEMMAST
                              WHSHLDTL:COM-ITCOMMENT

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

                 WHSHLINEIN  

                 WHSLINEOUT  

                 WOBYPROD     ITEMLOC
                              ITEMMAST

                 WODETAIL    

                 WOITEM       WODETAIL:ITEMLOC
                              WODETAIL:ITEMMAST
                              WODETAIL:SOHDETAIL
                              ITEMLOC
                              ITEMMAST
                              ITEMSUB
                              ITSERIAL
                              SOHBINS
                              SOHLOTS

                 WORDER       ITEMLOC
                              ITEMMAST