Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms


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

         

   FILE - AMASSET


  Condition         Type
--------------------------------------------------------------------------------
  ACCUM-AU-EXIST    OTOFLDS

  where  (            Relation: Amaugroup Exists         
    And          Amaugroup->Acm Acct Unit != Spaces                         )


  Is Used In No Indexes
  Is Used In No Rels
  Is Used In No SubType
  Is Used In No States
  Is Used In CndFld - ACCUM-AU
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  ADJ-BK-EXIST      FILEFLD, OTOFLDS

  where  (           Relation: Amastbkadj Exists         
    And                            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 No CndFlds
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  ADJ-EXIST         OTOFLDS

  where  (           Relation: Amassetadj 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
--------------------------------------------------------------------------------
  ALLOC-EXISTS      OTOFLDS

  where  (           Relation: Amtypalloc 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
--------------------------------------------------------------------------------
  AMASTMXVAL        OTOFLDS

  where  (           Relation: Amastmxval 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
--------------------------------------------------------------------------------
  ASD-EXCHANGE      OTOFLDS

  where  (         Amassetdsp->Dsp Method  = "E"                            )


  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-AU-EXIST    OTOFLDS

  where  (            Relation: Amaugroup Exists         
    And          Amaugroup->Ast Acct Unit != Spaces                         )


  Is Used In No Indexes
  Is Used In No Rels
  Is Used In No SubType
  Is Used In No States
  Is Used In CndFld - ASSET-AU
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  ASSET-EXIST       FILEFLD

  where  (                          Asset != 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
--------------------------------------------------------------------------------
  ASSETGRP-EXIST    FILEFLD

  where  (                    Asset Group != Spaces                         )


  Is Used In Index - ASTSET6
  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
--------------------------------------------------------------------------------
  ASTGROUP-EXIST    OTOFLDS

  where  (           Relation: Amassetgrp 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
--------------------------------------------------------------------------------
  AU-GROUP-EXIST    FILEFLD

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



  Condition         Type
--------------------------------------------------------------------------------
  BOOK-EXIST        FILEFLD, OTOFLDS

  where  (            Relation: Amastbook Exists         
    And                            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 No CndFlds
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  CAPITAL           FILEFLD

  where  (                 Classification  = "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
--------------------------------------------------------------------------------
  CLEAR-AU-EXIST    OTOFLDS

  where  (            Relation: Amaugroup Exists         
    And          Amaugroup->Clr Acct Unit != Spaces                         )


  Is Used In No Indexes
  Is Used In No Rels
  Is Used In No SubType
  Is Used In No States
  Is Used In CndFld - CLEARING-AU
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  COLUMN-LABELS     FILEFLD

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



  Condition         Type
--------------------------------------------------------------------------------
  COMPANY-EXIST     OTOFLDS

  where  (            Relation: Amcontrol 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
--------------------------------------------------------------------------------
  COST-AU-EXISTS    OTOFLDS

  where  (            Relation: Amaugroup Exists         
    And          Amaugroup->Cos Acct Unit != Spaces                         )


  Is Used In No Indexes
  Is Used In No Rels
  Is Used In No SubType
  Is Used In No States
  Is Used In CndFld - COST-AU
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  DEFGN-AU-EXIST    OTOFLDS

  where  (            Relation: Amaugroup Exists         
    And          Amaugroup->Dgn Acct Unit != Spaces                         )


  Is Used In No Indexes
  Is Used In No Rels
  Is Used In No SubType
  Is Used In No States
  Is Used In CndFld - DEF-GAIN-AU
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  DEFLS-AU-EXIST    OTOFLDS

  where  (            Relation: Amaugroup Exists         
    And          Amaugroup->Dls Acct Unit != Spaces                         )


  Is Used In No Indexes
  Is Used In No Rels
  Is Used In No SubType
  Is Used In No States
  Is Used In CndFld - DEF-LOSS-AU
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  DEPR-AU-EXISTS    OTOFLDS

  where  (            Relation: Amaugroup Exists         
    And          Amaugroup->Exp Acct Unit != Spaces                         )


  Is Used In No Indexes
  Is Used In No Rels
  Is Used In No SubType
  Is Used In No States
  Is Used In CndFld - DEPR-EXP-AU
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  DISPOSED          FILEFLD

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



  Condition         Type
--------------------------------------------------------------------------------
  DSP-BK-EXIST      FILEFLD, OTOFLDS

  where  (           Relation: Amastbkdsp Exists         
    And                            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 No CndFlds
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  DSP-NOT-UPDATE    FILEFLD

  where  (                         Status  = 3                              
    And                     Asset Process  = "DSP"                          
    And                         Dsp Asset != Zeroes                         )


  Is Used In Index - ASTSET8
  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
--------------------------------------------------------------------------------
  ENTRD-POST-ACT    FILEFLD

  where  (                         Status  = 1                              
     Or                            Status  = 3                              )


  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
--------------------------------------------------------------------------------
  GAIN-AU-EXISTS    OTOFLDS

  where  (            Relation: Amaugroup Exists         
    And          Amaugroup->Gan Acct Unit != Spaces                         )


  Is Used In No Indexes
  Is Used In No Rels
  Is Used In No SubType
  Is Used In No States
  Is Used In CndFld - GAIN-AU
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  LEASE-EXISTS      FILEFLD, OTOFLDS

  where  (                  Lease Company != Zeroes                         
    And                             Lease != Spaces                         
    And                 Relation: Lmlease 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
--------------------------------------------------------------------------------
  LOSS-AU-EXISTS    OTOFLDS

  where  (            Relation: Amaugroup Exists         
    And          Amaugroup->Los Acct Unit != Spaces                         )


  Is Used In No Indexes
  Is Used In No Rels
  Is Used In No SubType
  Is Used In No States
  Is Used In CndFld - LOSS-AU
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  NOT-DISPOSED      FILEFLD

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



  Condition         Type
--------------------------------------------------------------------------------
  OPERATING         FILEFLD

  where  (                 Classification  = "O"                            )


  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
--------------------------------------------------------------------------------
  PARTIAL-DISPOS    FILEFLD, OTOFLDS

  where  (           Relation: Amastitdsp Exists         
    And                            Status != 9                              
    And                            Status != 3                              )


  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
--------------------------------------------------------------------------------
  PROC-AU-EXISTS    OTOFLDS

  where  (            Relation: Amaugroup Exists         
    And          Amaugroup->Pro Acct Unit != Spaces                         )


  Is Used In No Indexes
  Is Used In No Rels
  Is Used In No SubType
  Is Used In No States
  Is Used In CndFld - PROCEEDS-AU
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  PURCHASED         FILEFLD

  where  (                 Classification  = "P"                            
     Or                    Classification  = 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
--------------------------------------------------------------------------------
  REINST-EXIST      OTOFLDS

  where  (           Relation: Amassetrin 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
--------------------------------------------------------------------------------
  REPAIR-EXIST      OTOFLDS

  where  (           Relation: Amastrpair 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
--------------------------------------------------------------------------------
  TAG-EXIST         FILEFLD

  where  (                        Tag Nbr != 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
--------------------------------------------------------------------------------
  TRANS-EXIST       OTOFLDS

  where  (              Relation: Amtrans 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
--------------------------------------------------------------------------------
  TRF-BK-EXIST      FILEFLD, OTOFLDS

  where  (           Relation: Amastbktrf Exists         
    And                            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 No CndFlds
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  TRF-EXIST         OTOFLDS

  where  (           Relation: Amassettrf 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
--------------------------------------------------------------------------------
  UPDATED           FILEFLD

  where  (                         Status  = 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
--------------------------------------------------------------------------------
  WIP               FILEFLD

  where  (                         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
--------------------------------------------------------------------------------
  WIP-TAG           FILEFLD

  where  (                         Status  = 1                              
    And                           Tag Nbr != 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