Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms


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

         

   FILE - ACBUDDTL


  Condition         Type
--------------------------------------------------------------------------------
  ACCRUAL-TYPE      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
--------------------------------------------------------------------------------
  ACTGRP-BUDGET     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
--------------------------------------------------------------------------------
  ACTIVITY-BUDGT    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
--------------------------------------------------------------------------------
  ACV-ACTIVE-BUD    FILEFLD, OTOFLDS

  where  (         Acactivity->Active Bud  = Budget Nbr                     )


  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
--------------------------------------------------------------------------------
  AG-ACTIVE-BUD     FILEFLD, OTOFLDS

  where  (           Acactgrp->Active Bud  = Budget Nbr                     )


  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
                    - BLANK
  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
--------------------------------------------------------------------------------
  LIFE-ONLY         OTOFLDS

  where  (            Acbudhdr->Life Only  = "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
--------------------------------------------------------------------------------
  NO-VARIANCE       FILEFLD

  where  (                       Variance  = 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 - OVER-UNDER
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  NOT-LIFE-ONLY     OTOFLDS

  where  (            Acbudhdr->Life Only != "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
--------------------------------------------------------------------------------
  OVER-VARIANCE     FILEFLD

  where  (                       Variance  > 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 - OVER-UNDER
  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
--------------------------------------------------------------------------------
  UNDER-VARIANCE    FILEFLD

  where  (                       Variance  < 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
--------------------------------------------------------------------------------
  UNITS-NO-VAR      FILEFLD

  where  (                 Variance Units  = 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 - OVER-UNDER-UNT
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  UNITS-OVER-VAR    FILEFLD

  where  (                 Variance Units  > 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 - OVER-UNDER-UNT
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  UNITS-UNDR-VAR    FILEFLD

  where  (                 Variance Units  < 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
--------------------------------------------------------------------------------
  ZERO-AMOUNTS      FILEFLD

  where  (                        Balance  = 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
--------------------------------------------------------------------------------
  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



  Condition         Type
--------------------------------------------------------------------------------
  ZERO-UNITS        FILEFLD

  where  (                   Balance Unit  = 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