Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

MMDIST


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

       

   FILE - MMDIST


  Condition         Type
--------------------------------------------------------------------------------
  ATN-OBJ-ID-EX     FILEFLD

  where  (                     Atn Obj Id != Zeroes                         )


  Is Used In Index - MMDSET2
  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
--------------------------------------------------------------------------------
  FROM-IC           FILEFLD

  where  (                      System Cd  = "IC"                           )


  Is Used In No Indexes
  Is Used In Rel - ICTRANS
  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
--------------------------------------------------------------------------------
  FROM-PO           FILEFLD

  where  (                      System Cd  = "PO"                           
    And                          Doc Type  = "PT"                           )


  Is Used In No Indexes
  Is Used In Rel - POAOCDTL
                 - POLINE
                 - PURCHORDER
  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
--------------------------------------------------------------------------------
  FROM-RECEIVING    FILEFLD

  where  (                       Doc Type  = "PO"                           
     Or                          Doc Type  = "RA"                           
     Or                          Doc Type  = "RJ"                           )


  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
--------------------------------------------------------------------------------
  FROM-REQLINE      FILEFLD

  where  (                      System Cd  = "RQ"                           
    And                          Doc Type  = "RQ"                           )


  Is Used In Index - MMDSET8
  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
--------------------------------------------------------------------------------
  FROM-RETURN       FILEFLD

  where  (                       Doc Type  = "VR"                           )


  Is Used In No Indexes
  Is Used In Rel - PORETURNHD
                 - PORETURNLN
  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
--------------------------------------------------------------------------------
  FROM-RQ           FILEFLD

  where  (                      System Cd  = "RQ"                           )


  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
--------------------------------------------------------------------------------
  HAS-ACTIVITY      FILEFLD

  where  (                       Activity != 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
--------------------------------------------------------------------------------
  IC-FIN-RPTG-D     FILEFLD

  where ((                 Pull For Fr 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 No Rules



  Condition         Type
--------------------------------------------------------------------------------
  IC-FIN-RPTING     FILEFLD

  where ((                 Pull For Fr Fl  = "Y"                            ))


  Is Used In Index - MMDSET10
  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
--------------------------------------------------------------------------------
  INTERCOMPANY      FILEFLD

  where  (                        Company != Dist Company                   )


  Is Used In No Indexes
  Is Used In Rel - REQLINE3
  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
--------------------------------------------------------------------------------
  INTERFACE         FILEFLD

  where  (                       Doc Type  = "IF"                           )


  Is Used In Index - MMDSET6
  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
--------------------------------------------------------------------------------
  MMDSET5-AP        FILEFLD

  where  (                      System Cd  = "AP"                           )


  Is Used In Index - MMDSET5
  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-PO-MNR        FILEFLD

  where  (                   Posting Type != "MN"                           )


  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
--------------------------------------------------------------------------------
  NOT-PO-RNI        FILEFLD

  where  (                       Line Seq != 999                            )


  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
--------------------------------------------------------------------------------
  PO-MMDIST         FILEFLD

  where  (                      System Cd  = "PO"                           
    And                          Doc Type  = "PT"                           
    And                          Line Seq  < 997                            )


  Is Used In Index - MMDSET4
  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
--------------------------------------------------------------------------------
  PO-OR-RQ          FILEFLD

  where ((                      System Cd  = "PO"                           
    And                          Doc Type  = "PT"                           
    And                          Line Seq  < 997                            )
     Or  (                      System Cd  = "RQ"                           
    And                          Doc Type  = "RQ"                           ))


  Is Used In Index - MMDSET9
  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
--------------------------------------------------------------------------------
  PO-RECEIVING      FILEFLD

  where ((                       Doc Type  = "PO"                           ))


  Is Used In No Indexes
  Is Used In Rel - PORECLINE
  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
--------------------------------------------------------------------------------
  POSTED            FILEFLD

  where  (                     Glt Obj Id != Zeroes                         )


  Is Used In Index - MMDSET3
  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
--------------------------------------------------------------------------------
  RNI-OBJ-ID-EX     FILEFLD

  where  (                     Rni Obj Id != Zeroes                         )


  Is Used In Index - MMDSET12
  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
--------------------------------------------------------------------------------
  SLTRANS-EXISTS    OTOFLDS

  where  (              Relation: Sltrans 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
--------------------------------------------------------------------------------
  TO-REQLINE        FILEFLD

  where ((                      System Cd  = "RQ"                           )
    And  (                       Doc Type  = "DT"                           
     Or                          Doc Type  = "IS"                           
     Or                          Doc Type  = "IT"                           ))


  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
--------------------------------------------------------------------------------
  UNPOSTED-PO-RQ    FILEFLD

  where  (                         Status  = Zeroes                         
    And ((                      System Cd  = "PO"                           )
    And  (                       Doc Type != "VA"                           )
    And  (                       Doc Type != "VR"                           ))
     Or ((                      System Cd  = "RQ"                           )
    And  (                       Doc Type  = "IS"                           )
     Or  (                       Doc Type  = "RR"                           )))


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