CONDITION REPORT
                               ----------------
       
   FILE - LMINVOICE
  Condition         Type
--------------------------------------------------------------------------------
  APAPIHIST         OTOFLDS
  where  (            Relation: Apapihist Exists         )
  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
--------------------------------------------------------------------------------
  APINVOICE         OTOFLDS
  where  (            Relation: Apinvoice Exists         )
  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
--------------------------------------------------------------------------------
  CANCELLED-AP      FILEFLD
  where  (                     Cancel Seq != 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 - CANCELLED-AP
  Is Used In No AvfFlds
  Is Used In No Rules
  Condition         Type
--------------------------------------------------------------------------------
  CANCELLED-LM      FILEFLD
  where  (                   Cancelled 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 CndFld - CANCELLED-LM
  Is Used In No AvfFlds
  Is Used In No Rules
  Condition         Type
--------------------------------------------------------------------------------
  LMDISTRIB         OTOFLDS
  where  (            Relation: Lmdistrib Exists         )
  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
--------------------------------------------------------------------------------
  LMTRANS           OTOFLDS
  where  (              Relation: Lmtrans Exists         )
  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
--------------------------------------------------------------------------------
  NOT-CANCELLED     FILEFLD
  where ((                     Cancel Seq  = Zeroes                         )
    And  (                         Status  = Zeroes                         ))
  Is Used In Index - INVSET2
                   - INVSET3
                   - INVSET4
                   - INVSET8
  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
--------------------------------------------------------------------------------
  UPDATE-BALANCE    FILEFLD
  where(((                         Status  = 1                              )
    And  (                     Cancel Seq  = Zeroes                         ))
     Or ((                         Status  = 9                              )
    And  (                     Cancel Seq != Zeroes                         )
    And  (                   Cancelled 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
 |