Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms


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

         

   FILE - APDRAFTS


  Condition         Type
--------------------------------------------------------------------------------
  ACCEPT-ACCOUNT    FILEFLD

  where  (                        Company  = 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 2 Rules



  Condition         Type
--------------------------------------------------------------------------------
  ACCEPT-PROGRAM    FILEFLD

  where  (                     Rec Status  = 1                              
     Or                        Rec Status  = 2                              )


  Is Used In Index - APTSET3
  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
--------------------------------------------------------------------------------
  ACCEPTED          FILEFLD, STATE

  where  (                     Rec Status  = 2                              )


  Is Used In No Indexes
  Is Used In No Rels
  Is Used In No SubType
  Is Used In State - ACCEPTED
  Is Used In CndFld - DERIVED-STATUS
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  ACPT-DT-NT-ENT    FILEFLD

  where  (                    Accept Date  = 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 1 Rule



  Condition         Type
--------------------------------------------------------------------------------
  AMT-EQLS-APPLD    FILEFLD

  where  (                   Draft Amount  = Applied Amt                    )


  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 1 Rule



  Condition         Type
--------------------------------------------------------------------------------
  AP-ACCEPT-REQD    OTOFLDS

  where  (       Cbbankinst->Ap Accept 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 3 Rules



  Condition         Type
--------------------------------------------------------------------------------
  AP-ORIG-DRAFT     FILEFLD

  where  (                 Pmt Doc Origin  = "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 2 Rules



  Condition         Type
--------------------------------------------------------------------------------
  AR-ORIG-DRAFT     FILEFLD

  where  (                 Pmt Doc Origin  = "R"                            )


  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 2 Rules



  Condition         Type
--------------------------------------------------------------------------------
  AUTO-RECONCILE    OTOFLDS

  where  (         Cbbankinst->Auto Recon  = "Y"                            
    And           Cbcpycash->Rec Gl Entry  = "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



  Condition         Type
--------------------------------------------------------------------------------
  BASE-CURRENCY     FILEFLD, OTOFLDS

  where  (                  Currency Code  = Apcompany->Base Currency       )


  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 1 Rule



  Condition         Type
--------------------------------------------------------------------------------
  BNKINST-NT-CHG    FILEFLD

  where  (            Old(Bank Inst Code)  = Bank Inst Code                 )


  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 1 Rule



  Condition         Type
--------------------------------------------------------------------------------
  CANCELED          FILEFLD, STATE

  where  (                     Rec Status  = 5                              )


  Is Used In No Indexes
  Is Used In No Rels
  Is Used In No SubType
  Is Used In State - CANCELED
  Is Used In CndFld - DERIVED-STATUS
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  CASH-CURRENCY     FILEFLD, OTOFLDS

  where  (                      Cash Code  = Spaces                         
     Or                     Currency Code  = Cbcashcode->Currency Code      )


  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 1 Rule



  Condition         Type
--------------------------------------------------------------------------------
  CASHED            FILEFLD, STATE

  where  (                     Rec Status  = 3                              )


  Is Used In No Indexes
  Is Used In No Rels
  Is Used In No SubType
  Is Used In State - CASHED
  Is Used In CndFld - DERIVED-STATUS
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  COMPANY-EXIST     FILEFLD

  where  (                        Company != 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 - VGROUP
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  CURR-NOT-CHG      FILEFLD

  where  (             Old(Currency Code)  = Currency Code                  )


  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 1 Rule



  Condition         Type
--------------------------------------------------------------------------------
  DISHONORED        FILEFLD, STATE

  where  (                     Rec Status  = 4                              )


  Is Used In No Indexes
  Is Used In No Rels
  Is Used In No SubType
  Is Used In State - DISHONORED
  Is Used In CndFld - DERIVED-STATUS
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  DRAFT-BAL         FILEFLD, OTOFLDS

  where ((     Appaygroup->Accept Accting  = "Y"                            )
    And  (                  Remit To Code  = Spaces                         )
    And ((                     Rec Status  = 2                              )
     Or  (                     Rec Status  = 3                              )
     Or  (                     Rec Status  = 4                              )
    And  (                   Gl Update Fl  = "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
--------------------------------------------------------------------------------
  DRAFT-BAL-LOC     FILEFLD, OTOFLDS

  where ((     Appaygroup->Accept Accting  = "Y"                            )
    And  (                  Remit To Code != Spaces                         )
    And ((                     Rec Status  = 2                              )
     Or  (                     Rec Status  = 3                              )
     Or  (                     Rec Status  = 4                              )
    And  (                   Gl Update Fl  = "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
--------------------------------------------------------------------------------
  DRAFT-NBR-ENTR    FILEFLD

  where  (                      Draft Nbr != 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 1 Rule



  Condition         Type
--------------------------------------------------------------------------------
  GL-NOT-UPDATED    FILEFLD

  where  (                   Gl Update Fl  = "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 2 Rules



  Condition         Type
--------------------------------------------------------------------------------
  GL-UPDATED        FILEFLD

  where  (                   Gl Update 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 4 Rules



  Condition         Type
--------------------------------------------------------------------------------
  NO-AMT-CHG        FILEFLD

  where  (              Old(Draft Amount)  = Draft Amount                   )


  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 1 Rule



  Condition         Type
--------------------------------------------------------------------------------
  NO-CASH-CD-CHG    FILEFLD

  where  (                 Old(Cash Code)  = Cash Code                      )


  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-GL-UPDATE      FILEFLD

  where  (                   Gl Update Fl  = "N"                            
    And                        Rec Status  > 1                              
    And                        Rec Status  < 5                              )


  Is Used In Index - APTSET5
  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
--------------------------------------------------------------------------------
  NON-BASE-CURR     FILEFLD, OTOFLDS

  where  (                  Currency Code != Apcompany->Base Currency       )


  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
--------------------------------------------------------------------------------
  NON-CANCELED      FILEFLD

  where  (                     Rec Status != 5                              )


  Is Used In Index - APTSET6
  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-PRINTED       FILEFLD, OTOFLDS

  where  (                   Print Status  = "N"                            
    And                    Pmt Doc Origin  = "P"                            
    And         Cbbankinst->Output Option  = "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 1 Rule



  Condition         Type
--------------------------------------------------------------------------------
  RATE-ENTRD        FILEFLD

  where  (                      Orig Rate != Zeroes                         
     Or                     Base Orig Amt != 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 1 Rule



  Condition         Type
--------------------------------------------------------------------------------
  RELEASED          FILEFLD, STATE

  where  (                     Rec Status  = 1                              )


  Is Used In No Indexes
  Is Used In No Rels
  Is Used In No SubType
  Is Used In State - RELEASED
  Is Used In CndFld - DERIVED-STATUS
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  REMIT-EXISTS      FILEFLD

  where  (                  Remit To 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 CndFld - SHORT-DFT-NAME
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  STATEMENT         FILEFLD

  where ((                  Statement Nbr != Zeroes                         ))


  Is Used In Index - APTSET10
  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
--------------------------------------------------------------------------------
  UNRELEASED        FILEFLD, STATE

  where  (                     Rec Status  = Zeroes                         )


  Is Used In No Indexes
  Is Used In No Rels
  Is Used In No SubType
  Is Used In State - UNRELEASED
  Is Used In CndFld - DERIVED-STATUS
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  VENBAL-IN-BASE    OTOFLDS

  where  (         Apvenbal->Bal Currency  = 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 5 Rules



  Condition         Type
--------------------------------------------------------------------------------
  VENDOR-MASTER     FILEFLD

  where  (                  Remit To 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
--------------------------------------------------------------------------------
  VENDOR-NOT-CHG    FILEFLD

  where  (                    Old(Vendor)  = Vendor                         )


  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 1 Rule