| 
 | 
                               CONDITION REPORT
                               ----------------
       
   FILE - APDISTRIB
  Condition         Type
--------------------------------------------------------------------------------
  AOC-DIST          FILEFLD
  where  (                    Po Aoc Code != Spaces                         )
  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
--------------------------------------------------------------------------------
  AP-FIN-RPTG       FILEFLD
  where ((                 Pull For Fr Fl  = "Y"                            ))
  Is Used In Index - APDSET11
  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
--------------------------------------------------------------------------------
  AP-FIN-RPTG-D     FILEFLD
  where ((                 Pull For Fr 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
--------------------------------------------------------------------------------
  AP-FIN-RPTING     FILEFLD
  where ((                 Pull For Fr 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
--------------------------------------------------------------------------------
  APDSET5           FILEFLD
  where ((                        Company != Dist Company                   )
    And ((                     Rec Status  = Zeroes                         )
     Or  (                     Rec Status  = 1                              )))
  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
--------------------------------------------------------------------------------
  APUAVAL-EXISTS    OTOFLDS
  where  (              Relation: Apuaval 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
--------------------------------------------------------------------------------
  ASSET-DIST        FILEFLD
  where  (                     Asset Flag  = "A"                            
     Or                        Asset Flag  = "R"                            )
  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
--------------------------------------------------------------------------------
  COMMITTED-COST    FILEFLD
  where  (                     Atn Obj Id != Zeroes                         )
  Is Used In Index - APDSET9
  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
--------------------------------------------------------------------------------
  DST-OBJ-ID        FILEFLD
  where  (                     Dst Obj Id != Zeroes                         )
  Is Used In Index - APDSET6
  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
--------------------------------------------------------------------------------
  GLT-OBJ-ID        FILEFLD
  where  (                     Glt Obj Id != Zeroes                         )
  Is Used In Index - APDSET5
  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
--------------------------------------------------------------------------------
  INTER-COMPANY     FILEFLD
  where  (                        Company != Dist Company                   )
  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-INTERCPY       FILEFLD
  where  (                        Company  = Dist Company                   )
  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
--------------------------------------------------------------------------------
  NON-BASE-DIST     FILEFLD, OTOFLDS
  where  (                   Inv Currency != Apcompany->Base Currency       )
  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
--------------------------------------------------------------------------------
  OPEN-DISTS        FILEFLD
  where  (                        Company != Dist Company                   
    And ((                     Rec Status  = Zeroes                         )
     Or  (                     Rec Status  = 1                              )))
  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
--------------------------------------------------------------------------------
  PO-DISTRIBS       FILEFLD
  where  (                      Po Number != Spaces                         )
  Is Used In Index - APDSET8
  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
--------------------------------------------------------------------------------
  SLTRANS-EXISTS    OTOFLDS
  where  (              Relation: Sltrans 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
--------------------------------------------------------------------------------
  SUMMARY-DIST      FILEFLD
  where  (                       Activity != Spaces                         )
  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
--------------------------------------------------------------------------------
  TAX-DIST          FILEFLD
  where  (                       Tax Code != Spaces                         )
  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
--------------------------------------------------------------------------------
  UNPOSTED-DIST     FILEFLD
  where  (                     Rec Status  < 9                              )
  Is Used In No Indexes
  Is Used In No Rels
  Is Used In No SubType
  Is Used In No States
  Is Used In CndFld - DIST-STATUS
  Is Used In No AvfFlds
  Is Used In No Rules
  Condition         Type
--------------------------------------------------------------------------------
  USER-FIELD-ENT    OTOFLDS
  where  (            Relation: Dstusrfld 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
 |