Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms


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

         

   FILE - RWROWDET


  Condition         Type
--------------------------------------------------------------------------------
  ACCOUNT-TYPE      FILEFLD

  where  (                    Record Type  = "A"                            )


  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
--------------------------------------------------------------------------------
  ACCOUNTSROW       FILEFLD

  where  (                    Record Type  = "A"                            )


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



  Condition         Type
--------------------------------------------------------------------------------
  ACT-GRP-ENTERD    FILEFLD

  where  (                     Acct Group != Spaces                         )


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



  Condition         Type
--------------------------------------------------------------------------------
  ACT-GRP-SPACES    FILEFLD

  where  (                     Acct Group  = 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 2 Rules



  Condition         Type
--------------------------------------------------------------------------------
  ACT-UNIT-ENTRD    FILEFLD

  where  (                    Acct Unit 1 != Spaces                         
     Or                       Acct Unit 2 != Spaces                         
     Or                       Acct Unit 3 != Spaces                         
     Or                       Acct Unit 4 != 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 2 Rules



  Condition         Type
--------------------------------------------------------------------------------
  BASELINE          FILEFLD

  where  (                      Line Type  = "B"                            )


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



  Condition         Type
--------------------------------------------------------------------------------
  BOTH-TYPE         FILEFLD

  where  (                    Record Type  = "B"                            )


  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
--------------------------------------------------------------------------------
  BOTHROW           FILEFLD

  where  (                    Record Type  = "B"                            )


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



  Condition         Type
--------------------------------------------------------------------------------
  DET-BASE-LINE     FILEFLD

  where  (                      Line Type  = "D"                            
     Or                         Line Type  = "B"                            )


  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
--------------------------------------------------------------------------------
  DETAILLINE        FILEFLD

  where  (                      Line Type  = "D"                            )


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



  Condition         Type
--------------------------------------------------------------------------------
  FR-ACCT-ENTERD    FILEFLD

  where  (                     Fr Account != Zeroes                         )


  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
--------------------------------------------------------------------------------
  FR-ACCT-ENTRD     FILEFLD

  where  (                     Fr Account != Zeroes                         )


  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 1 Rule



  Condition         Type
--------------------------------------------------------------------------------
  FR-ACCT-ENTRED    FILEFLD

  where  (                    Fr Sub Acct  = Zeroes                         )


  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 1 Rule



  Condition         Type
--------------------------------------------------------------------------------
  FR-ACCT-ZEROS     FILEFLD

  where  (                     Fr Account  = Zeroes                         )


  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
--------------------------------------------------------------------------------
  FR-SUB-ACT-ENT    FILEFLD

  where  (                    Fr Sub Acct != Zeroes                         )


  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 2 Rules



  Condition         Type
--------------------------------------------------------------------------------
  FR-VAR-LEV-ENT    FILEFLD

  where  (                  Fr Var Levels != 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 2 Rules



  Condition         Type
--------------------------------------------------------------------------------
  HEADERLINE        FILEFLD

  where  (                      Line Type  = "H"                            )


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



  Condition         Type
--------------------------------------------------------------------------------
  LEV-GRP-SPACES    FILEFLD

  where  (                    Level Group  = 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 2 Rules



  Condition         Type
--------------------------------------------------------------------------------
  LEVEL-TYPE        FILEFLD

  where  (                    Record Type  = "L"                            )


  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
--------------------------------------------------------------------------------
  LEVELSROW         FILEFLD

  where  (                    Record Type  = "L"                            )


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



  Condition         Type
--------------------------------------------------------------------------------
  LIST-ENTERED      FILEFLD

  where  (                    Matrix List != 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
--------------------------------------------------------------------------------
  LVL-GRP-ENTERD    FILEFLD

  where  (                    Level Group != Spaces                         )


  Is Used In No Indexes
  Is Used In Rel - LEVEL-GROUP
  Is Used In No SubType
  Is Used In No States
  Is Used In No CndFlds
  Is Used In No AvfFlds
  Is Used In 2 Rules



  Condition         Type
--------------------------------------------------------------------------------
  NO-VAR-LEVELS     FILEFLD

  where  (                  Fr Var Levels  = Spaces                         
    And                     Th Var Levels  = 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 2 Rules



  Condition         Type
--------------------------------------------------------------------------------
  OVD-ACT-SPACES    FILEFLD

  where  (                    Acct Unit 1  = Spaces                         
    And                       Acct Unit 2  = Spaces                         
    And                       Acct Unit 3  = Spaces                         
    And                       Acct Unit 4  = 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
--------------------------------------------------------------------------------
  ROW-FILE          FILEFLD

  where  (                    Record Type  = "A"                            
     Or                       Record Type  = "L"                            
     Or                       Record Type  = "B"                            )


  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
--------------------------------------------------------------------------------
  SUB-GRP-ENTERD    FILEFLD

  where  (                   Sub Acct Grp != Spaces                         )


  Is Used In No Indexes
  Is Used In Rel - SUBACCT-GROUP
  Is Used In No SubType
  Is Used In No States
  Is Used In No CndFlds
  Is Used In No AvfFlds
  Is Used In 2 Rules



  Condition         Type
--------------------------------------------------------------------------------
  SUM-ACCT-ENTRD    FILEFLD

  where  (                  Sumry Acct Id != Zeroes                         )


  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
--------------------------------------------------------------------------------
  TH-ACT-ENTERED    FILEFLD

  where  (                     Th Account != Zeroes                         )


  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 2 Rules



  Condition         Type
--------------------------------------------------------------------------------
  TH-ACT-GE-FR      FILEFLD

  where  (                     Th Account >= Fr Account                     )


  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 2 Rules



  Condition         Type
--------------------------------------------------------------------------------
  TH-CO-ENTERED     FILEFLD

  where  (                     Th Company != Zeroes                         )


  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 2 Rules



  Condition         Type
--------------------------------------------------------------------------------
  TH-CO-GE-FR-CO    FILEFLD

  where  (                     Th Company >= Fr 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 2 Rules



  Condition         Type
--------------------------------------------------------------------------------
  TH-CO-ZEROS       FILEFLD

  where  (                     Th Company  = Zeroes                         )


  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 2 Rules



  Condition         Type
--------------------------------------------------------------------------------
  TH-SUB-ACT-ENT    FILEFLD

  where  (                    Th Sub Acct != Zeroes                         )


  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 2 Rules



  Condition         Type
--------------------------------------------------------------------------------
  TH-SUB-ACT-GE     FILEFLD

  where  (                    Th Sub Acct >= Fr Sub Acct                    )


  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 2 Rules



  Condition         Type
--------------------------------------------------------------------------------
  TH-SUB-ACT-ZER    FILEFLD

  where  (                    Th Sub Acct  = Zeroes                         )


  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 2 Rules



  Condition         Type
--------------------------------------------------------------------------------
  TH-VAR-LEV-ENT    FILEFLD

  where  (                  Th Var Levels != 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 1 Rule



  Condition         Type
--------------------------------------------------------------------------------
  TH-VAR-LEV-GE     FILEFLD

  where  (                  Th Var Levels >= Fr Var Levels                  )


  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 2 Rules



  Condition         Type
--------------------------------------------------------------------------------
  TH-VAR-LEV-SPC    FILEFLD

  where  (                  Th Var Levels  = 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 2 Rules



  Condition         Type
--------------------------------------------------------------------------------
  THRU-ACT-ZEROS    FILEFLD

  where  (                     Th Account  = Zeroes                         )


  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 2 Rules



  Condition         Type
--------------------------------------------------------------------------------
  TOTAL-RANGES      FILEFLD

  where  (                    Record Type  = "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
--------------------------------------------------------------------------------
  TOTALLINE         FILEFLD

  where  (                      Line Type  = "T"                            )


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



  Condition         Type
--------------------------------------------------------------------------------
  UNDERLINE         FILEFLD

  where ((                      Line Type  = "S"                            )
     Or  (                      Line Type  = "U"                            ))


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