Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms


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

         

   FILE - DTREMIT


  Condition         Type
--------------------------------------------------------------------------------
  BANKINSTCODE      FILEFLD

  where  (                 Bank Inst Code != Spaces                         )


  Is Used In Index - DRMSET5
  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
--------------------------------------------------------------------------------
  CANCELED          FILEFLD, STATE

  where  (                         Status  = 8                              )


  Is Used In No Indexes
  Is Used In No Rels
  Is Used In No SubType
  Is Used In State - CANCELED
  Is Used In No CndFlds
  Is Used In No AvfFlds
  Is Used In No Rules



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

  where  (                         Status  = 9                              )


  Is Used In No Indexes
  Is Used In No Rels
  Is Used In No SubType
  Is Used In State - CASHED
  Is Used In No CndFlds
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  CREATE            FILEFLD, STATE

  where  (                         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
--------------------------------------------------------------------------------
  CXL-DT-BLANK      FILEFLD

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



  Condition         Type
--------------------------------------------------------------------------------
  DISC-REMIT        FILEFLD

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



  Condition         Type
--------------------------------------------------------------------------------
  DRMSET2           FILEFLD

  where  (                         Status  > Zeroes                         
    And  (                      Remit Nbr != Zeroes                         ))


  Is Used In Index - DRMSET2
  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
--------------------------------------------------------------------------------
  DRMSET4           FILEFLD

  where  (                  Dep Inst Code != Spaces                         )


  Is Used In Index - DRMSET4
  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
--------------------------------------------------------------------------------
  FULLY-PROCESSD    FILEFLD

  where  (                    Process 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
--------------------------------------------------------------------------------
  GENERATED         FILEFLD, STATE

  where  (                         Status  = 1                              )


  Is Used In No Indexes
  Is Used In No Rels
  Is Used In No SubType
  Is Used In State - GENERATED
  Is Used In No CndFlds
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  NOT-CASHED        FILEFLD

  where  (                     Cashed Amt  = Zeroes                         
    And                         Unpay 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
--------------------------------------------------------------------------------
  NOT-CASHED-YET    FILEFLD

  where  (                 Gl Update Code  = Spaces                         
    And                        Cashed Amt  = Zeroes                         
    And                         Unpay 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
--------------------------------------------------------------------------------
  NOT-FULLY-CSHD    FILEFLD

  where  (                    Process 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
--------------------------------------------------------------------------------
  NOT-GL-UPDATED    FILEFLD

  where  (                 Gl Update 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 1 Rule



  Condition         Type
--------------------------------------------------------------------------------
  NOT-UPD-CASH      FILEFLD

  where  (                 Gl Update Code != "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 1 Rule



  Condition         Type
--------------------------------------------------------------------------------
  NOT-UPD-FORCSH    FILEFLD

  where  (                 Gl Update Code != "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
--------------------------------------------------------------------------------
  PRESENTED         FILEFLD, STATE

  where  (                         Status  = 2                              )


  Is Used In No Indexes
  Is Used In No Rels
  Is Used In No SubType
  Is Used In State - PRESENTED
  Is Used In No CndFlds
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  PRINTED           FILEFLD, STATE

  where  (                         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
--------------------------------------------------------------------------------
  PRSNT-DT-BLANK    FILEFLD

  where  (                   Present 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
--------------------------------------------------------------------------------
  REM-GT-MAX-AMT    FILEFLD

  where  (                        Max Amt != Zeroes                         
    And                         Remit Amt  > Max 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
--------------------------------------------------------------------------------
  REM-LT-MIN-AMT    FILEFLD

  where  (                      Remit Amt  < Min 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
--------------------------------------------------------------------------------
  REMIT-NBR         FILEFLD

  where ((                      Remit Nbr != Zeroes                         ))


  Is Used In Index - DRMSET3
                   - DRMSET7
  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
--------------------------------------------------------------------------------
  REMITTED-DRAFT    FILEFLD

  where  (                         Status  > Zeroes                         )


  Is Used In No Indexes
  Is Used In Rel - REMITTED-DRAFT
  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
--------------------------------------------------------------------------------
  SELECTED          FILEFLD, STATE

  where  (                         Status  = Zeroes                         )


  Is Used In No Indexes
  Is Used In No Rels
  Is Used In No SubType
  Is Used In State - SELECTED
  Is Used In No CndFlds
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  UPD-FOR-CASH      FILEFLD

  where  (                 Gl Update Code  = "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 1 Rule



  Condition         Type
--------------------------------------------------------------------------------
  UPD-FOR-PRSENT    FILEFLD

  where  (                 Gl Update Code  = "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 3 Rules