Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ACCONSOL


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

       

   FILE - ACCONSOL


  Condition         Type
--------------------------------------------------------------------------------
  ACBUDDTL-CHILD    OTOFLDS

  where  (       Relation: Acbuddtl Child 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
--------------------------------------------------------------------------------
  ACCONSOL-CHILD    OTOFLDS

  where  (       Relation: Acconsol Child 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
--------------------------------------------------------------------------------
  ACCRUAL           OTOFLDS

  where  (       Acacctcat->Category Type  = "A"                            
     Or          Acacctcat->Category Type  = "P"                            )


  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
--------------------------------------------------------------------------------
  ACCUAMT-CHILD     OTOFLDS

  where  (        Relation: Accuamt Child 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
--------------------------------------------------------------------------------
  ACMASTER-CHILD    OTOFLDS

  where  (       Relation: Acmaster Child 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
--------------------------------------------------------------------------------
  ACTGRP-AMOUNTS    FILEFLD

  where  (                     Budget Nbr  = Zeroes                         
    And                          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
--------------------------------------------------------------------------------
  ACTGRP-BUDGET     FILEFLD

  where  (                       Activity  = Spaces                         
    And                        Budget Nbr != 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
--------------------------------------------------------------------------------
  ACTIVITY-CONSL    FILEFLD

  where  (                     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 No Rules



  Condition         Type
--------------------------------------------------------------------------------
  ACTIVITY-CURR     FILEFLD, OTOFLDS

  where  (                  Currency Code  = Acactivity->Currency Code      )


  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
--------------------------------------------------------------------------------
  ACTIVITY-ONLY     FILEFLD

  where  (                       Activity != Spaces                         )


  Is Used In No Indexes
  Is Used In Rel - ACCONSOL-CHILD
  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
--------------------------------------------------------------------------------
  ACTVTY-AMOUNTS    FILEFLD

  where  (                       Activity != Spaces                         
    And                        Budget Nbr  = 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
--------------------------------------------------------------------------------
  ACTVTY-BUDGET     FILEFLD

  where  (                     Budget Nbr != Zeroes                         
    And                          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
--------------------------------------------------------------------------------
  BASE-CURR         FILEFLD, OTOFLDS

  where  (                  Currency Code  = Acactgrp->Currency Code        )


  Is Used In No Indexes
  Is Used In Rel - ACBUDDTL-CHILD
                 - ACMASTER-CHILD
  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
--------------------------------------------------------------------------------
  COST-OR-REV       OTOFLDS

  where  (       Acacctcat->Category Type  = "C"                            
     Or          Acacctcat->Category 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
--------------------------------------------------------------------------------
  COST-TYPE         OTOFLDS

  where  (       Acacctcat->Category Type  = "C"                            )


  Is Used In No Indexes
  Is Used In No Rels
  Is Used In No SubType
  Is Used In No States
  Is Used In CndFld - ACCT-CAT-TYPE
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  FISCAL-YEAR       FILEFLD

  where  (                    Fiscal Year != 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
--------------------------------------------------------------------------------
  REVENUE-TYPE      OTOFLDS

  where  (       Acacctcat->Category 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 CndFld - ACCT-CAT-TYPE
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  RPT-1-CURR        FILEFLD, OTOFLDS

  where  (                  Currency Code  = Acactgrp->Curr Code 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
--------------------------------------------------------------------------------
  RPT-2-CURR        FILEFLD, OTOFLDS

  where  (                  Currency Code  = Acactgrp->Curr Code 2          )


  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
--------------------------------------------------------------------------------
  ZERO-FISCAL-YR    FILEFLD

  where  (                    Fiscal Year  = 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