Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

POLINE


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

       

   FILE - POLINE


  Condition         Type
--------------------------------------------------------------------------------
  ADJ-INS-EXISTS    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
--------------------------------------------------------------------------------
  AGRMT-EXISTS      FILEFLD

  where  (                  Agreement Ref != Spaces                         
    And                       Released Fl  = "Y"                            )


  Is Used In Index - PLISET2
  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
--------------------------------------------------------------------------------
  CLOSED            OTOFLDS

  where ((          Purchorder->Closed 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 CndFld - PO-CLOSED-FL
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  DROP-SHIP         OTOFLDS

  where  (        Purchorder->Dropship 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 CndFld - PO-DROP-SHIP
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  FROM-RETURN       OTOFLDS

  where  (      Purchorder->Return Number != Zeroes                         )


  Is Used In No Indexes
  Is Used In Rel - RETURN-HEADER
  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-AOCDTL        OTOFLDS

  where  (             Relation: Poaocdtl 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-APPROVAL      OTOFLDS

  where  (       Relation: Poappr By Date 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-APPROVAL2     OTOFLDS

  where  (       Relation: Poappr By Dte2 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-AUDIT-REC     OTOFLDS

  where  (              Relation: Poaudit 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
--------------------------------------------------------------------------------
  HAS-PO-CODE       FILEFLD

  where  (                        Po 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 CndFld - DISP-DOC-NBR
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  HAS-RECEIVING     OTOFLDS

  where  (        Relation: Porec By Date 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-SOURCE        OTOFLDS

  where  (            Relation: Polinesrc 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
--------------------------------------------------------------------------------
  IAGRMT-EXISTS     OTOFLDS

  where  (          Relation: Ipovagrmtln 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
--------------------------------------------------------------------------------
  INVENTORYTYPE     FILEFLD

  where ((                      Item Type  = "I"                            ))


  Is Used In No Indexes
  Is Used In Rel - ICCATEGORY
  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
--------------------------------------------------------------------------------
  IS-RELEASE        FILEFLD

  where  (                     Po Release != 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 - DISP-DOC-NBR
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  IS-VEND-ITEM      FILEFLD

  where  (                       Ven Item != Spaces                         )


  Is Used In No Indexes
  Is Used In Rel - HAS-VEND-ITEM
  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
--------------------------------------------------------------------------------
  ITEMVEN-EXISTS    OTOFLDS

  where  (            Relation: Poitemven 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
--------------------------------------------------------------------------------
  MAINVDTL-EXIST    OTOFLDS

  where  (             Relation: Mainvdtl 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
--------------------------------------------------------------------------------
  MAJOR-CLASS       FILEFLD

  where  (                    Purch Majcl != Spaces                         )


  Is Used In No Indexes
  Is Used In Rel - MAJOR-CLASS
  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
--------------------------------------------------------------------------------
  MANUF-CD-ENTRD    FILEFLD

  where  (                     Manuf Code != Spaces                         )


  Is Used In No Indexes
  Is Used In Rel - ICMANFCODE
  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
--------------------------------------------------------------------------------
  MINOR-CLASS       FILEFLD

  where  (                    Purch Mincl != Spaces                         )


  Is Used In No Indexes
  Is Used In Rel - MINOR-CLASS
  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
--------------------------------------------------------------------------------
  MMUAVAL-EXISTS    OTOFLDS

  where  (              Relation: Mmuaval 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-SERVICE       FILEFLD

  where ((                      Item Type != "S"                            ))


  Is Used In Index - PLISET3
                   - PLISET8
                   - PLISET9
  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
--------------------------------------------------------------------------------
  NOTINVENTORY      FILEFLD

  where  (                      Item Type != "I"                            )


  Is Used In No Indexes
  Is Used In Rel - MMDIST
  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
--------------------------------------------------------------------------------
  OBJ-ID-EXISTS     FILEFLD

  where  (                      Po Obj Id != Spaces                         )


  Is Used In Index - PLISET12
  Is Used In Rel - WHDEMAND
  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

  where  (                      Closed 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
--------------------------------------------------------------------------------
  OPENRECEIVING     FILEFLD, OTOFLDS

  where ((        Purchorder->Released Fl  = "Y"                            )
    And  (                      Remaining  > Zeroes                         )
    And  (                      Item Type != "S"                            )
    And  (        Purchorder->Dropship 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
--------------------------------------------------------------------------------
  PO-HISTORY        OTOFLDS

  where  (          Purchorder->Closed 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 CndFld - PO-CNCLED-FL
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  PRINTED           FILEFLD

  where  (                    Issued 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 CndFld - PO-PRINTED-FL
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  PURCH-FR-LOC      FILEFLD

  where  (                   Purch Fr Loc != Spaces                         )


  Is Used In No Indexes
  Is Used In Rel - VENDORLOCATION
  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
--------------------------------------------------------------------------------
  RECEIPTS-EXIST    FILEFLD

  where  (                        Rec Qty  > 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
--------------------------------------------------------------------------------
  RECEIVABLE        FILEFLD

  where  (                      Item Type != "S"                            
    And                       Released Fl  = "Y"                            
    And                         Closed Fl  = "N"                            
    And                       Qty To Proc  > Rec Qty                        )


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

  where ((        Purchorder->Released 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 CndFld - PO-RELEASED-FL
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  RETURNS-EXIST     OTOFLDS

  where  (          Relation: Return Line 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
--------------------------------------------------------------------------------
  UNREL-AGRMT       FILEFLD

  where  (                  Agreement Ref != Spaces                         
    And                       Released Fl  = "N"                            )


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

  where ((        Purchorder->Released 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
--------------------------------------------------------------------------------
  VAGRMT-EXISTS     OTOFLDS

  where  (          Relation: Vpovagrmtln 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