Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

APPAYMENT


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

       

   FILE - APPAYMENT


  Condition         Type
--------------------------------------------------------------------------------
  ACCEPT-DRAFT      OTOFLDS

  where  (             Relation: Apdrafts Exists         
    And              Apdrafts->Rec Status  = 2                              )


  Is Used In No Indexes
  Is Used In No Rels
  Is Used In No SubType
  Is Used In No States
  Is Used In CndFld - BANK-STATUS
                    - PAID-DOC-DATE
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  APINCCODE         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
--------------------------------------------------------------------------------
  APPSET12          FILEFLD

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


  Is Used In Index - APPSET12
  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
--------------------------------------------------------------------------------
  APPSET3           FILEFLD

  where ((                     Rec Status  = 1                              ))


  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
--------------------------------------------------------------------------------
  APPSET4           FILEFLD

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


  Is Used In Index - APPSET4
  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
--------------------------------------------------------------------------------
  APPSET5           FILEFLD

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


  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
--------------------------------------------------------------------------------
  APPSET6           FILEFLD

  where  (                    Trans Ident != Zeroes                         )


  Is Used In Index - APPSET6
  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
--------------------------------------------------------------------------------
  CANCEL-DRAFT      OTOFLDS

  where  (             Relation: Apdrafts Exists         
    And              Apdrafts->Rec Status  = 5                              )


  Is Used In No Indexes
  Is Used In No Rels
  Is Used In No SubType
  Is Used In No States
  Is Used In CndFld - BANK-STATUS
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  CASH-PAYMENT      FILEFLD, OTOFLDS

  where  (                      Trans Nbr != Spaces                         
    And                 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
--------------------------------------------------------------------------------
  CASHED-DRAFT      OTOFLDS

  where  (             Relation: Apdrafts Exists         
    And              Apdrafts->Rec Status  = 3                              )


  Is Used In No Indexes
  Is Used In No Rels
  Is Used In No SubType
  Is Used In No States
  Is Used In CndFld - BANK-STATUS
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  CHK-PROCESSED     OTOFLDS

  where  (              Relation: Cbcheck Exists         
    And               Cbcheck->Rec Status  < 2                              )


  Is Used In No Indexes
  Is Used In No Rels
  Is Used In No SubType
  Is Used In No States
  Is Used In CndFld - BANK-STATUS
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  CSDSET2           FILEFLD, OTOFLDS

  where ((                 Recon Stmt Nbr != Zeroes                         )
    And  (            Relation: Cbstmtdtl 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
--------------------------------------------------------------------------------
  CURR-BAL-LOC      FILEFLD, OTOFLDS

  where  (                     Rec Status  > Zeroes                         
    And                        Rec Status  < 8                              
    And                        Rec Status != 5                              
    And                     Remit To Code != Spaces                         
    And               Relation: Apinvoice Exists         
    And           Apinvoice->Invoice Type != "P"                            
    And           Apinvoice->Invoice Type != "A"                            )


  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
--------------------------------------------------------------------------------
  CURRENT-BAL       FILEFLD, OTOFLDS

  where  (                     Rec Status  > Zeroes                         
    And                        Rec Status  < 8                              
    And                        Rec Status != 5                              
    And                     Remit To Code  = Spaces                         
    And               Relation: Apinvoice Exists         
    And           Apinvoice->Invoice Type != "P"                            
    And           Apinvoice->Invoice Type != "A"                            )


  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
--------------------------------------------------------------------------------
  DETAIL-PMT        OTOFLDS

  where  (            Cbcheck->Serial Num  = Zeroes                         )


  Is Used In No Indexes
  Is Used In Rel - CBTRANS
  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
--------------------------------------------------------------------------------
  DISHONOR-DRAFT    OTOFLDS

  where  (             Relation: Apdrafts Exists         
    And              Apdrafts->Rec Status  = 4                              )


  Is Used In No Indexes
  Is Used In No Rels
  Is Used In No SubType
  Is Used In No States
  Is Used In CndFld - BANK-STATUS
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  DRAFT-ACCRUAL     FILEFLD

  where  (                     Rec Status  = 5                              )


  Is Used In No Indexes
  Is Used In No Rels
  Is Used In No SubType
  Is Used In No States
  Is Used In CndFld - DRAFT-ACCRUED
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  DRAFT-ACCRUED     FILEFLD

  where  (                     Rec Status  = 5                              )


  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-CANCEL      FILEFLD

  where  (                     Rec Status  = 8                              )


  Is Used In No Indexes
  Is Used In No Rels
  Is Used In No SubType
  Is Used In No States
  Is Used In CndFld - PMT-STATUS
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  DRAFT-PAYMENT     FILEFLD, OTOFLDS

  where  (                      Trans Nbr != Spaces                         
    And                Relation: Apdrafts 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
--------------------------------------------------------------------------------
  EMP-ADVANCE       OTOFLDS

  where  (            Relation: Apinvoice Exists         
    And           Apinvoice->Invoice Type  = "A"                            )


  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
--------------------------------------------------------------------------------
  EMP-CREDIT        OTOFLDS

  where  (            Relation: Apinvoice Exists         
    And           Apinvoice->Invoice Type  = "M"                            )


  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
--------------------------------------------------------------------------------
  EMP-EXPENSE       OTOFLDS

  where  (            Relation: Apinvoice Exists         
    And           Apinvoice->Invoice Type  = "E"                            )


  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
--------------------------------------------------------------------------------
  ESCHEATED         OTOFLDS

  where  (              Relation: Cbcheck Exists         
    And                 Relation: Cbtrans Exists         
    And               Cbtrans->Rec Status  = 6                              )


  Is Used In No Indexes
  Is Used In No Rels
  Is Used In No SubType
  Is Used In No States
  Is Used In CndFld - BANK-STATUS
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  INC-WH-PMT        FILEFLD

  where  (                    Tran Inc Wh != 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
--------------------------------------------------------------------------------
  INV-PAID          FILEFLD, OTOFLDS

  where(((                     Rec Status  > 2                              )
    And  (     Cbbankinst->Bank Inst Type  = "C"                            ))
     Or ((                     Rec Status  = 9                              )
    And  (     Cbbankinst->Bank Inst Type  = "D"                            )))


  Is Used In No Indexes
  Is Used In No Rels
  Is Used In No SubType
  Is Used In No States
  Is Used In CndFld - BASE-NET-PMT
                    - TRAN-NET-PMT
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  ISSUED-CASH       OTOFLDS

  where  (              Relation: Cbcheck Exists         
    And               Cbcheck->Rec Status  = 2                              )


  Is Used In No Indexes
  Is Used In No Rels
  Is Used In No SubType
  Is Used In No States
  Is Used In CndFld - BANK-STATUS
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  NO-PAYMENT        FILEFLD

  where  (                      Trans 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 CndFld - BANK-STATUS
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  NO-REINSTATE      OTOFLDS

  where  (              Relation: Cbcheck Exists         
    And               Cbcheck->Rec Status  = 3                              )


  Is Used In No Indexes
  Is Used In No Rels
  Is Used In No SubType
  Is Used In No States
  Is Used In CndFld - NO-REINSTATE
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  NON-BASE-PMT      FILEFLD, OTOFLDS

  where  (                   Inv Currency != 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
--------------------------------------------------------------------------------
  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
--------------------------------------------------------------------------------
  OPEN-PMT          FILEFLD, OTOFLDS

  where  (                     Rec Status  < 3                              
     Or ((     Cbbankinst->Bank Inst Type  = "D"                            )
    And  (                     Rec Status  = 4                              )))


  Is Used In No Indexes
  Is Used In No Rels
  Is Used In No SubType
  Is Used In No States
  Is Used In CndFld - PMT-STATUS
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  PAID-PMT          FILEFLD, OTOFLDS

  where(((     Cbbankinst->Bank Inst Type  = "C"                            )
    And  (                     Rec Status  > 2                              )
    And  (                       Void Seq  = Zeroes                         ))
     Or ((     Cbbankinst->Bank Inst Type  = "D"                            )
    And  (                     Rec Status  = 5                              ))
     Or ((     Cbbankinst->Bank Inst Type  = "D"                            )
    And  (                     Rec Status  = 9                              )
    And  (                       Void 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 - PMT-STATUS
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  RECONCILE-CASH    OTOFLDS

  where  (              Relation: Cbcheck Exists         
    And                 Relation: Cbtrans Exists         
    And               Cbtrans->Rec Status  = 2                              )


  Is Used In No Indexes
  Is Used In No Rels
  Is Used In No SubType
  Is Used In No States
  Is Used In CndFld - BANK-STATUS
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  STALE-DATED       OTOFLDS

  where  (              Relation: Cbcheck Exists         
    And                 Relation: Cbtrans Exists         
    And               Cbtrans->Rec Status  = 5                              )


  Is Used In No Indexes
  Is Used In No Rels
  Is Used In No SubType
  Is Used In No States
  Is Used In CndFld - BANK-STATUS
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  STOP-PMT-CASH     OTOFLDS

  where  (              Relation: Cbcheck Exists         
    And                 Relation: Cbtrans Exists         
    And               Cbtrans->Rec Status  = 4                              )


  Is Used In No Indexes
  Is Used In No Rels
  Is Used In No SubType
  Is Used In No States
  Is Used In CndFld - BANK-STATUS
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  TAPE-ISSUED       OTOFLDS

  where  (         Relation: Cbtrans Tape Exists         
    And          Cbtrans Tape->Rec Status  = 1                              )


  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
--------------------------------------------------------------------------------
  TAPE-PAYMENT      OTOFLDS

  where  (              Relation: Cbcheck Exists         
    And               Cbcheck->Rec Status  = 2                              
    And               Cbcheck->Serial Num != Zeroes                         )


  Is Used In No Indexes
  Is Used In Rel - CBTRANS-TAPE
  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
--------------------------------------------------------------------------------
  TAPE-PMT-REJ      OTOFLDS

  where  (            Cbcheck->Rec Status  = 3                              
     Or               Cbcheck->Rec Status  = 4                              )


  Is Used In No Indexes
  Is Used In No Rels
  Is Used In No SubType
  Is Used In No States
  Is Used In CndFld - BANK-STATUS
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  TAPE-RECONCILE    OTOFLDS

  where  (         Relation: Cbtrans Tape Exists         
    And          Cbtrans Tape->Rec Status  = 2                              )


  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
--------------------------------------------------------------------------------
  TAPE-VOID         FILEFLD, OTOFLDS

  where  (                       Void Seq != Zeroes                         
    And               Cbcheck->Serial Num != 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 - BANK-STATUS
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  UNACCEPT-DRAFT    OTOFLDS

  where  (             Relation: Apdrafts Exists         
    And              Apdrafts->Rec Status  < 2                              )


  Is Used In No Indexes
  Is Used In No Rels
  Is Used In No SubType
  Is Used In No States
  Is Used In CndFld - BANK-STATUS
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  UNOPEN-CASH       FILEFLD, OTOFLDS

  where  (     Cbbankinst->Bank Inst Type  = "C"                            
    And                        Rec Status  > 2                              )


  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
--------------------------------------------------------------------------------
  VOID-CASH         OTOFLDS

  where  (              Relation: Cbcheck Exists         
    And                 Relation: Cbtrans Exists         
    And               Cbtrans->Rec Status  = 3                              )


  Is Used In No Indexes
  Is Used In No Rels
  Is Used In No SubType
  Is Used In No States
  Is Used In CndFld - BANK-STATUS
                    - PMT-STATUS
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  VOID-PMT          FILEFLD

  where  (                     Rec Status  = 9                              
    And                          Void 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 No CndFlds
  Is Used In No AvfFlds
  Is Used In No Rules