Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms


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

         

   FILE - LMINVOICE


  Condition         Type
--------------------------------------------------------------------------------
  APAPIHIST         OTOFLDS

  where  (            Relation: Apapihist 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
--------------------------------------------------------------------------------
  APINVOICE         OTOFLDS

  where  (            Relation: Apinvoice 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
--------------------------------------------------------------------------------
  CANCELLED-AP      FILEFLD

  where  (                     Cancel Seq != 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 - CANCELLED-AP
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  CANCELLED-LM      FILEFLD

  where  (                   Cancelled Fl  = "Y"                            )


  Is Used In No Indexes
  Is Used In No Rels
  Is Used In No SubType
  Is Used In No States
  Is Used In CndFld - CANCELLED-LM
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  LMDISTRIB         OTOFLDS

  where  (            Relation: Lmdistrib 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
--------------------------------------------------------------------------------
  LMTRANS           OTOFLDS

  where  (              Relation: Lmtrans 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
--------------------------------------------------------------------------------
  NOT-CANCELLED     FILEFLD

  where ((                     Cancel Seq  = Zeroes                         )
    And  (                         Status  = Zeroes                         ))


  Is Used In Index - INVSET2
                   - INVSET3
                   - INVSET4
                   - INVSET8
  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
--------------------------------------------------------------------------------
  UPDATE-BALANCE    FILEFLD

  where(((                         Status  = 1                              )
    And  (                     Cancel Seq  = Zeroes                         ))
     Or ((                         Status  = 9                              )
    And  (                     Cancel Seq != Zeroes                         )
    And  (                   Cancelled Fl != "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