CONDITION REPORT
                               ----------------
       
   FILE - WHSHIPLINE
  Condition         Type
--------------------------------------------------------------------------------
  BIN-TRACKED       OTOFLDS
  where  (         Itemmast->Lot Track Fl  = "N"                            
    And             Itemloc->Bin Track Fl  = "Y"                            
    And            Itemmast->Ser Track Fl  = "N"                            )
  Is Used In No Indexes
  Is Used In Rel - ATTACHED-BINS
                 - BINS
  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
--------------------------------------------------------------------------------
  CASELINE          FILEFLD
  where  (                      System Cd  = "CX"                           )
  Is Used In No Indexes
  Is Used In Rel - CASELINE
  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
--------------------------------------------------------------------------------
  COLINE            OTOFLDS
  where  (            Shipment->System Cd  = "OE"                           )
  Is Used In No Indexes
  Is Used In Rel - COLINE
  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
--------------------------------------------------------------------------------
  CWT-ITEM          OTOFLDS
  where  (             Itemmast->Ctw Code != "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
--------------------------------------------------------------------------------
  FULL-VOID         FILEFLD
  where  (                   Full Void Fl  = "Y"                            )
  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
--------------------------------------------------------------------------------
  IN-PROCESS        FILEFLD
  where  (                 In Process Qty != Zeroes                         )
  Is Used In No Indexes
  Is Used In No Rels
  Is Used In No SubType
  Is Used In No States
  Is Used In CndFld - OPEN-QUANTITY
  Is Used In No AvfFlds
  Is Used In No Rules
  Condition         Type
--------------------------------------------------------------------------------
  INVENTORIED       FILEFLD
  where  (                      Line Type  = "I"                            )
  Is Used In No Indexes
  Is Used In Rel - ITEMLOC
  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
--------------------------------------------------------------------------------
  ITEMMAST          FILEFLD
  where  (                      Line Type  = "I"                            
     Or                         Line Type  = "N"                            )
  Is Used In No Indexes
  Is Used In Rel - ITEMMAST
  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
--------------------------------------------------------------------------------
  ITSERIAL          OTOFLDS
  where  (         Itemmast->Ser Track Fl  = "R"                            )
  Is Used In No Indexes
  Is Used In Rel - ATCH-SER-RECPT
                 - ITSERIAL
  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
--------------------------------------------------------------------------------
  KIT-ITEM          OTOFLDS
  where  (               Whdemand->Kit Fl  = "O"                            )
  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
--------------------------------------------------------------------------------
  LOT-TRACKED       OTOFLDS
  where  (         Itemmast->Lot Track Fl  = "Y"                            )
  Is Used In No Indexes
  Is Used In Rel - ATTACHED-LOTS
                 - LOTS
  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
--------------------------------------------------------------------------------
  MSDS              OTOFLDS
  where  (            Itemmast->Msds Flag  = "Y"                            )
  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
--------------------------------------------------------------------------------
  NO-DETAILS        FILEFLD
  where  (                     Detail Req  = "N"                            )
  Is Used In Index - WHLSET4
  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
--------------------------------------------------------------------------------
  NON-CWT-ITEM      OTOFLDS
  where  (             Itemmast->Ctw Code  = "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
--------------------------------------------------------------------------------
  REQLINE           OTOFLDS
  where  (            Shipment->System Cd  = ELM Not Found                  )
  Is Used In No Indexes
  Is Used In Rel - REQLINE
  Is Used In No SubType
  Is Used In No States
  Is Used In CndFld - PARTIAL
                    - PARTIAL-VALUE
  Is Used In No AvfFlds
  Is Used In No Rules
  Condition         Type
--------------------------------------------------------------------------------
  SERIAL-TRACKED    OTOFLDS
  where  (         Itemmast->Ser Track Fl  = "I"                            )
  Is Used In No Indexes
  Is Used In Rel - ATTACHED-SERS
                 - ITSERIALS
  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  (            Relation: Sohdetail Exists         
    And            Itemmast->Lot Track Fl  = "N"                            
    And            Itemmast->Ser Track Fl  = "N"                            
    And             Itemloc->Bin Track Fl  = "N"                            )
  Is Used In No Indexes
  Is Used In Rel - ATTACHED-UOMS
                 - UOMS
  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
--------------------------------------------------------------------------------
  WALKTHRU          FILEFLD
  where ((                  Walk Thru Req  = "Y"                            ))
  Is Used In Index - WHLSET3
  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
 |