Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

APVENMAST


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

       

   FILE - APVENMAST


  Condition         Type
--------------------------------------------------------------------------------
  ACTIVE-VENDOR     FILEFLD

  where  (                  Vendor 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: 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
--------------------------------------------------------------------------------
  ADDR-VENDOR       OTOFLDS

  where ((            Relation: Apvenaddr Exists         )
    And  (             Address1->Cur Addr  = "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 - 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
--------------------------------------------------------------------------------
  CHECK-EXISTS      OTOFLDS

  where  (              Relation: Cbcheck 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: Apvcomments 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
--------------------------------------------------------------------------------
  HANDCODE-EXIST    FILEFLD

  where  (                  Handling Code != 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
--------------------------------------------------------------------------------
  LOCATION-EXIST    OTOFLDS

  where  (             Relation: Apvenloc 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 - LOC-INDICATOR
                    - VCOMMENT-EXIST
  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 - VENSET8
  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
--------------------------------------------------------------------------------
  NUMERIC-VENDOR    OTOFLDS

  where  (        Apvengroup->Num Ven Nbr  = "N"                            )


  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
--------------------------------------------------------------------------------
  OBJ-ID-EXISTS     FILEFLD

  where  (                      Ap Obj Id != Zeroes                         )


  Is Used In Index - VENSET11
  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
--------------------------------------------------------------------------------
  ON-HOLD           FILEFLD

  where ((                      Hold Flag  = "Y"                            ))


  Is Used In No Indexes
  Is Used In Rel - APHLDINV
  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 ((                  Vendor Status != "I"                            )
    And  (                  Vendor 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 ((                  Vendor 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
--------------------------------------------------------------------------------
  REP-INC-VENDOR    FILEFLD

  where  (                    Income Code != 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
--------------------------------------------------------------------------------
  TAX-VENDOR        FILEFLD

  where  (                       Tax Code != Spaces                         
     Or                            Tax Id != 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
--------------------------------------------------------------------------------
  VDRCPY-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