Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

EEADVANCE


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

       

   FILE - EEADVANCE


  Condition         Type
--------------------------------------------------------------------------------
  ADV-HISTORY       OTOFLDS

  where  (           Relation: Apinvoice2 Exists         
    And         Apinvoice2->Tran Paid Amt  = Apinvoice2->Tran Inv 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
--------------------------------------------------------------------------------
  ADV-ISSUED        OTOFLDS

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


  Is Used In No Indexes
  Is Used In Rel - CBCHECK1
  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
--------------------------------------------------------------------------------
  ADV-RELEASED      OTOFLDS

  where  (           Relation: Apinvoice1 Exists         
    And          Apinvoice1->Tran Inv Amt != Apinvoice1->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
--------------------------------------------------------------------------------
  ADV-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
--------------------------------------------------------------------------------
  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
--------------------------------------------------------------------------------
  OPEN              FILEFLD

  where ((                     Rec Status  = Zeroes                         ))


  Is Used In Index - EEASET3
  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
--------------------------------------------------------------------------------
  UNRECONCILED      OTOFLDS

  where  (           Relation: Appayment2 Exists         
    And            Appayment2->Rec 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