Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms


                               CONDITION REPORT
                               ----------------

         

   FILE - WOITEM


  Condition         Type
--------------------------------------------------------------------------------
  BIN-TRACKED       OTOFLDS

  where  (         Itemmast->Lot Track Fl  = "N"                            
    And            Itemmast->Ser Track Fl  = "N"                            
    And             Itemloc->Bin Track Fl  = "Y"                            )


  Is Used In No Indexes
  Is Used In Rel - BINS
                 - SOHBINS
  Is Used In No SubType
  Is Used In No States
  Is Used In No CndFlds
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  DIFF-LOCATION     FILEFLD

  where  (                       Location != Inv Location                   )


  Is Used In No Indexes
  Is Used In No Rels
  Is Used In No SubType
  Is Used In No States
  Is Used In CndFld - DISP-LOCATION
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  LOT-TRACKED       OTOFLDS

  where  (         Itemmast->Lot Track Fl  = "Y"                            )


  Is Used In No Indexes
  Is Used In Rel - LOTS
                 - SOHLOTS
  Is Used In No SubType
  Is Used In No States
  Is Used In No CndFlds
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  NOT-OFFSITE       FILEFLD

  where  (                 Component Type != "O"                            )


  Is Used In Index - WOISET5
  Is Used In No Rels
  Is Used In No SubType
  Is Used In No States
  Is Used In No CndFlds
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  SERIAL-TRACKED    OTOFLDS

  where  (         Itemmast->Ser Track Fl != "N"                            )


  Is Used In No Indexes
  Is Used In Rel - ITSERIAL
                 - SERIALS
  Is Used In No SubType
  Is Used In No States
  Is Used In No CndFlds
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  UOM-TRACKED       OTOFLDS

  where  (         Itemmast->Lot Track Fl  = "N"                            
    And             Itemloc->Bin Track Fl  = "N"                            )


  Is Used In No Indexes
  Is Used In No Rels
  Is Used In No SubType
  Is Used In No States
  Is Used In No CndFlds
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  WALKTHRUREQ       FILEFLD

  where ((                  Walk Thru Req  = "Y"                            ))


  Is Used In Index - WOISET4
  Is Used In No Rels
  Is Used In No SubType
  Is Used In No States
  Is Used In No CndFlds
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  WASTE-ACCOUNT     FILEFLD

  where  (                  Wst Acct Unit != Spaces                         
     Or                       Wst Account != Zeroes                         
     Or                      Wst Sub Acct != Zeroes                         )


  Is Used In No Indexes
  Is Used In Rel - WASTE-ACCOUNT
  Is Used In No SubType
  Is Used In No States
  Is Used In No CndFlds
  Is Used In No AvfFlds
  Is Used In No Rules