Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ACTOTBAL


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

       

   FILE - ACTOTBAL


  Condition         Type
--------------------------------------------------------------------------------
  ACCRUAL-TYPE      FILEFLD

  where  (                  Category Type  = "A"                            
     Or                     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
--------------------------------------------------------------------------------
  ACT-GROUP-AMT     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
--------------------------------------------------------------------------------
  ACTOTBAL-CHILD    OTOFLDS

  where  (       Relation: Actotbal 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
--------------------------------------------------------------------------------
  ACTOTBAL-PARNT    OTOFLDS

  where  (       Relation: Actotbal Parnt 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
--------------------------------------------------------------------------------
  ACTVY-AMOUNT      FILEFLD

  where  (                       Activity != Spaces                         )


  Is Used In No Indexes
  Is Used In Rel - ACTOTBAL-CHILD
                 - ACTOTBAL-PARNT
  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 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
--------------------------------------------------------------------------------
  BLANK-BUDGET      FILEFLD

  where  (                     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
--------------------------------------------------------------------------------
  BLANK-CAT-TYPE    FILEFLD

  where  (                  Category Type != "A"                            
    And                     Category Type != "C"                            
    And                     Category Type != "F"                            
    And                     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
--------------------------------------------------------------------------------
  BLANK-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
--------------------------------------------------------------------------------
  COST-TYPE         FILEFLD

  where  (                  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 No CndFlds
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  HAS-BUDGET        FILEFLD

  where  (                     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
--------------------------------------------------------------------------------
  HAS-CAT-TYPE      FILEFLD

  where  (                  Category Type  = "A"                            
     Or                     Category Type  = "C"                            
     Or                     Category Type  = "F"                            
     Or                     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
--------------------------------------------------------------------------------
  HAS-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
--------------------------------------------------------------------------------
  LTD-BLANK-TYPE    FILEFLD

  where  (                  Category Type != "A"                            
    And                     Category Type != "C"                            
    And                     Category Type != "R"                            
    And                     Category Type != "F"                            
    And                       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
--------------------------------------------------------------------------------
  LTD-CAT-TYPE      FILEFLD

  where ((                  Category Type  = "A"                            
     Or                     Category Type  = "C"                            
     Or                     Category Type  = "R"                            
     Or                     Category Type  = "F"                            )
    And                       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
--------------------------------------------------------------------------------
  POSTING-ACTVY     OTOFLDS

  where  (       Acactivity->Posting Flag  = "P"                            )


  Is Used In No Indexes
  Is Used In Rel - ACMASTER
  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      FILEFLD

  where  (                  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
--------------------------------------------------------------------------------
  RPT-CURR          FILEFLD, OTOFLDS

  where  (                  Currency Code  = Acactgrp->Curr Code 1          
     Or                     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
--------------------------------------------------------------------------------
  SUMMARY-ACTVY     OTOFLDS

  where  (       Acactivity->Posting Flag  = "S"                            
     Or          Acactivity->Posting Flag  = "C"                            )


  Is Used In No Indexes
  Is Used In Rel - ACCONSOL
  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
--------------------------------------------------------------------------------
  YTD-ACCRL-TYPE    FILEFLD

  where  (                  Category Type  = "A"                            
    And                       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
--------------------------------------------------------------------------------
  YTD-BLANK-TYPE    FILEFLD

  where  (                  Category Type != "A"                            
    And                     Category Type != "C"                            
    And                     Category Type != "R"                            
    And                     Category Type != "F"                            
    And                       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
--------------------------------------------------------------------------------
  YTD-CAT-TYPE      FILEFLD

  where ((                  Category Type  = "A"                            
     Or                     Category Type  = "C"                            
     Or                     Category Type  = "R"                            
     Or                     Category Type  = "F"                            )
    And                       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
--------------------------------------------------------------------------------
  YTD-COST-TYPE     FILEFLD

  where  (                  Category Type  = "C"                            
    And                       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
--------------------------------------------------------------------------------
  YTD-FEE-TYPE      FILEFLD

  where  (                  Category Type  = "F"                            
    And                       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
--------------------------------------------------------------------------------
  YTD-REV-TYPE      FILEFLD

  where  (                  Category Type  = "R"                            
    And                       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