Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

APVENLOC


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

       

   FILE - APVENLOC


  Condition         Type
--------------------------------------------------------------------------------
  ACTIVE-LOC        FILEFLD

  where  (                  Active Status != "I"                            )


  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
--------------------------------------------------------------------------------
  ADDR-LOC          OTOFLDS

  where ((             Relation: Address1 Exists         ))


  Is Used In No Indexes
  Is Used In No Rels
  Is Used In No SubType
  Is Used In No States
  Is Used In CndFld - VDR-ADDR1
                    - VDR-ADDR2
                    - VDR-ADDR3
                    - VDR-ADDR4
                    - VDR-CITY-ADDR5
                    - VDR-COUNTRY
                    - VDR-COUNTY
                    - VDR-POSTAL
                    - VDR-STATE
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  ADDRESS1          OTOFLDS

  where ((            Relation: Apvenaddr 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
--------------------------------------------------------------------------------
  COMMENT-EXIST     OTOFLDS

  where  (           Relation: Apcomments 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
--------------------------------------------------------------------------------
  DIVERSE-EXISTS    OTOFLDS

  where  (             Relation: Apvendiv 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
--------------------------------------------------------------------------------
  NO-PRENOTIFY      FILEFLD

  where  (                     Ach Prenot  = "N"                            
     Or                        Ach Prenot  = "P"                            )


  Is Used In Index - VLOSET4
  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
--------------------------------------------------------------------------------
  PO-ADD-ACTIVE     FILEFLD

  where ((                  Active Status != "I"                            )
    And  (                  Active Status != "D"                            ))


  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
--------------------------------------------------------------------------------
  PO-ADD-INACTIV    FILEFLD

  where ((                  Active Status  = "D"                            ))


  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
--------------------------------------------------------------------------------
  VLOCPY-EXISTS     OTOFLDS

  where  (             Relation: Apcpyvnd 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
--------------------------------------------------------------------------------
  VLOSET2           FILEFLD

  where  (                       Loc Type != "P"                            )


  Is Used In Index - VLOSET2
  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
--------------------------------------------------------------------------------
  VLOSET3           FILEFLD

  where  (                       Loc Type != "R"                            )


  Is Used In Index - VLOSET3
  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