Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

APAPPHIST


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

       

   FILE - APAPPHIST


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

  where  (                    Trans Ident != Zeroes                         )


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