Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

CBTRANS


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

       

   FILE - CBTRANS


  Condition         Type
--------------------------------------------------------------------------------
  ACTIVE-CASH       OTOFLDS

  where  (      Cbcashcode->Active Status  = "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
--------------------------------------------------------------------------------
  ADJUST-EXISTS     OTOFLDS

  where  (             Relation: Cbadjust 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
--------------------------------------------------------------------------------
  AP-AND-VENDOR     FILEFLD

  where  (                    Source Code  = "AP"                           
    And                            Vendor != "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 4 Rules



  Condition         Type
--------------------------------------------------------------------------------
  AP-DRAFT-TRANS    OTOFLDS

  where  (     Cbbankinst->Bank Inst Type  = "D"                            )


  Is Used In No Indexes
  Is Used In Rel - APDRAFTS
  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
--------------------------------------------------------------------------------
  APHSET4-EXIST     FILEFLD, OTOFLDS

  where  (                    Source Code  = "AR"                           
    And                 Relation: Aphset4 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
--------------------------------------------------------------------------------
  APHSET5-EXIST     FILEFLD, OTOFLDS

  where  (                    Source Code  = "AR"                           
    And                 Relation: Aphset5 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
--------------------------------------------------------------------------------
  ARRTM-EXISTS      OTOFLDS

  where  (                Relation: Arrtm 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
--------------------------------------------------------------------------------
  AUTO-RECON        OTOFLDS

  where  (         Cbbankinst->Auto Recon  = "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
--------------------------------------------------------------------------------
  BL-PERIOD-DATE    FILEFLD

  where  (                    Period 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 5 Rules



  Condition         Type
--------------------------------------------------------------------------------
  BL-REC-BAS-AMT    FILEFLD

  where  (                 Recon Base 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 3 Rules



  Condition         Type
--------------------------------------------------------------------------------
  BL-REC-BNK-AMT    FILEFLD

  where  (                 Recon Base 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 3 Rules



  Condition         Type
--------------------------------------------------------------------------------
  BL-REC-CNV-RT     FILEFLD

  where  (                 Recon Cnv Rate  = 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 3 Rules



  Condition         Type
--------------------------------------------------------------------------------
  BL-REC-DATE       FILEFLD

  where  (                     Recon 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 3 Rules



  Condition         Type
--------------------------------------------------------------------------------
  BNK-CREDIT        FILEFLD

  where  (                 Bnk Trans Sign  = "CR"                           )


  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
--------------------------------------------------------------------------------
  BNK-DEBIT         FILEFLD

  where  (                 Bnk Trans Sign  = "DR"                           )


  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-SIGN
  Is Used In No AvfFlds
  Is Used In 5 Rules



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

  where  (                 Bnk Trans Sign  = "DR"                           
    And        Cbbankinst->Bank Inst Type  = "C"                            )


  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
--------------------------------------------------------------------------------
  CB-DISTRIB        OTOFLDS

  where  (            Relation: Cbdistrib 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
--------------------------------------------------------------------------------
  CB-EFT-EXISTS     FILEFLD

  where  (                       Rec 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
--------------------------------------------------------------------------------
  CB-OUT-OF-BAL     FILEFLD

  where  (                  Issue Bnk Amt != Dist Applied                   
    And                        Rec Status  = 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
--------------------------------------------------------------------------------
  CB-PMT-EXISTS     FILEFLD

  where  (                       Rec Type  = "C"                            
    And                    Summary Option  = 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
--------------------------------------------------------------------------------
  CB-RET-PMT-EXT    OTOFLDS

  where  (             Relation: Cbretpmt 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
--------------------------------------------------------------------------------
  CB-UNRELEASED     FILEFLD

  where  (                     Rec Status  = 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 - DRILL-DOWN-STS
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  CBCHECK-DETAIL    FILEFLD

  where  (                    Source Code  = "AP"                           
    And                    Summary Option  = 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
--------------------------------------------------------------------------------
  CBCHECK-SUMM      FILEFLD

  where  (                    Source Code  = "AP"                           
    And                    Summary Option  = "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
--------------------------------------------------------------------------------
  CBH-EXISTS        FILEFLD

  where  (                    Source Code  = "CB"                           
    And                          Rec Type  = "T"                            )


  Is Used In No Indexes
  Is Used In Rel - CBTRFHDR
  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
--------------------------------------------------------------------------------
  CBL-EXISTS        FILEFLD

  where  (                    Source Code  = "CB"                           
    And                          Rec 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 No CndFlds
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  CBP-EXISTS        FILEFLD

  where  (                    Source Code  = "CB"                           
    And                          Rec Type  = "R"                            )


  Is Used In No Indexes
  Is Used In Rel - CBRECPTHDR
  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
--------------------------------------------------------------------------------
  CC-BANK-SIGN      FILEFLD

  where  (                      Bank Sign  = Bank Sign                      )


  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
--------------------------------------------------------------------------------
  CC-BNK-TRAN-SI    FILEFLD

  where  (            Old(Bnk Trans Sign)  = Bnk Trans Sign                 )


  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
--------------------------------------------------------------------------------
  CC-COMPANY        FILEFLD

  where  (                   Old(Company)  = Company                        )


  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
--------------------------------------------------------------------------------
  CC-SOURCE-CODE    FILEFLD

  where  (               Old(Source Code)  = Source 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
--------------------------------------------------------------------------------
  CC-TRANS-IDENT    FILEFLD

  where  (               Old(Trans Ident)  = Trans Ident                    )


  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
--------------------------------------------------------------------------------
  CC-VENDOR         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



  Condition         Type
--------------------------------------------------------------------------------
  COMP-CHGED        FILEFLD

  where  (                   Old(Company)  = Company                        )


  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
--------------------------------------------------------------------------------
  CSR-STMT-EXIST    FILEFLD

  where  (                   Csr Stmt Nbr != 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
--------------------------------------------------------------------------------
  DRAFT-DEPOSIT     FILEFLD, OTOFLDS

  where  (                 Bnk Trans Sign  = "CR"                           
    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 No CndFlds
  Is Used In No AvfFlds
  Is Used In No Rules



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

  where  (                 Bnk Trans Sign  = "DR"                           
    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 No CndFlds
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  DTCASH-EXISTS     FILEFLD, OTOFLDS

  where  (                    Source Code  = "AR"                           
    And               Relation: Dtcashing 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
--------------------------------------------------------------------------------
  DTREMIT-EXIST     FILEFLD, OTOFLDS

  where  (                    Source Code  = "AR"                           
    And                 Relation: Dtremit 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
--------------------------------------------------------------------------------
  NON-BASE-TRAN     OTOFLDS

  where  (      Cbcashcode->Currency Code != Glsystem->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 No Rules



  Condition         Type
--------------------------------------------------------------------------------
  NON-PAYMENT       OTOFLDS

  where  (     Cbbankinst->Bank Inst Type  = "B"                            )


  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
--------------------------------------------------------------------------------
  OPEN              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 - OPEN
  Is Used In CndFld - DRILL-DOWN-STS
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  RECEIPT-EXIST     OTOFLDS

  where  (           Relation: Cbrecptdtl 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
--------------------------------------------------------------------------------
  RECON-STATUS      FILEFLD

  where  (                     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
--------------------------------------------------------------------------------
  RECON-VARIANCE    FILEFLD

  where  (                     Rec Status  = 2                              
    And                     Issue Bnk Amt != Recon Bnk Amt                  )


  Is Used In No Indexes
  Is Used In No Rels
  Is Used In No SubType
  Is Used In No States
  Is Used In CndFld - RECON-VARIANCE
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  RECONCILE         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 - RECONCILE
  Is Used In CndFld - DRILL-DOWN-STS
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  RECPTHDR-EXIST    OTOFLDS

  where  (           Relation: Cbrecpthdr 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
--------------------------------------------------------------------------------
  RELATED-APP       FILEFLD

  where  (                    Source Code  = "AP"                           
    And                        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 No CndFlds
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  RELEASE           FILEFLD

  where  (                  Issue Bnk Amt  = Dist Applied                   )


  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
--------------------------------------------------------------------------------
  STOP-PAYMENT      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 - STOP-PAYMENT
  Is Used In CndFld - DRILL-DOWN-STS
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  TAPE-PAYMENT      FILEFLD

  where  (                     Serial Num != Zeroes                         )


  Is Used In Index - CBTSET4
  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
--------------------------------------------------------------------------------
  UNREL-RECEIPT     OTOFLDS

  where  (           Relation: Cbrecpthdr Exists         
    And            Cbrecpthdr->Rec Status  = 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
--------------------------------------------------------------------------------
  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 No CndFlds
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  USERFLDS-EXIST    FILEFLD

  where  (                    User Field1 != Spaces                         
     Or                       User Field2 != Spaces                         
     Or                       User Field3 != Spaces                         
     Or                       User Field4 != 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
--------------------------------------------------------------------------------
  VALID-BNK-SRC     FILEFLD

  where  (                 Bnk Trans Sign  = "CR"                           
     Or                    Bnk Trans Sign  = "DR"                           )


  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
--------------------------------------------------------------------------------
  VALID-SOURCE      FILEFLD

  where  (                    Source Code  = "AP"                           
     Or                       Source Code  = "AR"                           
     Or                       Source Code  = "CB"                           )


  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
--------------------------------------------------------------------------------
  VOID              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 - VOID
  Is Used In CndFld - DRILL-DOWN-STS
  Is Used In No AvfFlds
  Is Used In No Rules