Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms


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

         

   FILE - EEEXPENSE


  Condition         Type
--------------------------------------------------------------------------------
  ADVANCE-EXISTS    OTOFLDS

  where  (           Relation: Eematching 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
--------------------------------------------------------------------------------
  EEMATCHING        OTOFLDS

  where  (           Relation: Eematching 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
--------------------------------------------------------------------------------
  EXP-HISTORY       OTOFLDS

  where  (            Relation: Apinvoice Exists         
    And           Apinvoice->Tran Inv Amt  = Apinvoice->Tran Paid Amt       )


  Is Used In No Indexes
  Is Used In No Rels
  Is Used In No SubType
  Is Used In No States
  Is Used In CndFld - AP-STATUS
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  EXP-OPEN          OTOFLDS

  where  (            Relation: Apinvoice Exists         
    And           Apinvoice->Tran Inv Amt != Apinvoice->Tran Paid Amt       )


  Is Used In No Indexes
  Is Used In No Rels
  Is Used In No SubType
  Is Used In No States
  Is Used In CndFld - AP-STATUS
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  EXP-UNRELEASED    FILEFLD

  where  (                     Rec Status  = 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
--------------------------------------------------------------------------------
  EXPENSE-TYPE      FILEFLD

  where  (                   Expense Type  = "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
--------------------------------------------------------------------------------
  MANUAL-PAYMENT    FILEFLD

  where  (                      Trans Nbr != Spaces                         
    And                        Rec Status  = 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
--------------------------------------------------------------------------------
  OPEN              FILEFLD

  where ((                     Rec Status  = Zeroes                         ))


  Is Used In Index - EXPSET3
  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
--------------------------------------------------------------------------------
  OUT-OF-BALANCE    FILEFLD

  where  (                   Base Exp Amt != Base Dist Tot                  
     Or                      Base Tax Amt != Base Tax Tot                   
     Or                     Base Emp Paid != Base Emp Tot                   )


  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
--------------------------------------------------------------------------------
  PAYBACK-TYPE      FILEFLD

  where  (                   Expense 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
--------------------------------------------------------------------------------
  PAYMENT-EXISTS    OTOFLDS

  where  (            Relation: Appayment 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