Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

PORECLINE


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

       

   FILE - PORECLINE


  Condition         Type
--------------------------------------------------------------------------------
  AVAIL-TO-MATCH    FILEFLD, OTOFLDS

  where  (                         Status  > Zeroes                         
    And                      Match Obj Id  = Zeroes                         
    And                 Poreceive->Status  = 1                              
    And              Poreceive->Match Amt  > Zeroes                         
    And ((                         Status  = 1                              )
     Or  (         Vendor->Hold Insp Flag  = "N"                            )
     Or  (         Vendor->Hold Insp Flag  = Spaces                         
    And         Macompany->Hold Insp Flag != "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
--------------------------------------------------------------------------------
  BUYER-MESSAGE     FILEFLD

  where  (                 Buyer Msg Flag  = "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
--------------------------------------------------------------------------------
  DETAILS-EXIST     FILEFLD

  where  (                   Last Pot 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



  Condition         Type
--------------------------------------------------------------------------------
  ERS-AOC-EXISTS    OTOFLDS

  where  (            Relation: Recaocdtl Exists         
    And               Vendor->Ers Capable  = "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
--------------------------------------------------------------------------------
  HAS-ADJ-IN        OTOFLDS

  where  (           Relation: Porecadjln 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
--------------------------------------------------------------------------------
  HAS-DIST          OTOFLDS

  where  (               Relation: Mmdist 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
--------------------------------------------------------------------------------
  ICBIN             FILEFLD

  where  (                            Bin != Spaces                         
    And                               Bin != "*"                            )


  Is Used In No Indexes
  Is Used In Rel - ICBIN
  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
--------------------------------------------------------------------------------
  INSPECTION        FILEFLD

  where  (                         Status  = 5                              
     Or                            Status  = 6                              )


  Is Used In Index - PRLSET10
  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
--------------------------------------------------------------------------------
  ITEMLOC           FILEFLD

  where  (                      Item Type  = "I"                            )


  Is Used In No Indexes
  Is Used In Rel - ICCATEGORY
                 - ICTRANS
                 - ITEMLOC
  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
--------------------------------------------------------------------------------
  ITEMMAST          FILEFLD

  where  (                      Item Type  = "I"                            
     Or                         Item Type  = "N"                            )


  Is Used In No Indexes
  Is Used In Rel - ITEMMAST
  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
--------------------------------------------------------------------------------
  MATCHED           FILEFLD

  where  (                   Match Obj Id != Zeroes                         )


  Is Used In No Indexes
  Is Used In Rel - MAINVDTL
  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
--------------------------------------------------------------------------------
  MFG-INFO-EXIST    FILEFLD

  where  (                      Manuf Nbr != Spaces                         )


  Is Used In Index - PRLSET14
  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-INVENTORY     FILEFLD

  where  (                      Item Type  = "N"                            
     Or                         Item Type  = "X"                            )


  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
--------------------------------------------------------------------------------
  ORIG-RECEIVING    FILEFLD

  where  (                       Line Nbr  = Po Line Nbr                    )


  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
--------------------------------------------------------------------------------
  REFERENCE-NO      FILEFLD

  where  (                   Reference No != 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
--------------------------------------------------------------------------------
  RELEASED          FILEFLD

  where  (                         Status  > Zeroes                         )


  Is Used In Index - PRLSET5
  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
--------------------------------------------------------------------------------
  SUB-RECEIVING     FILEFLD

  where  (                    Po Line Nbr != Line Nbr                       )


  Is Used In No Indexes
  Is Used In Rel - SUBSTITUTES
  Is Used In No SubType
  Is Used In No States
  Is Used In CndFld - SUBSTITUTE
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  UNDELIVERED       FILEFLD

  where  (                    Fully Deliv  = "N"                            
    And                            Status  = 1                              )


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

  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