Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

REQLINE


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

       

   FILE - REQLINE


  Condition         Type
--------------------------------------------------------------------------------
  CLOSED            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
--------------------------------------------------------------------------------
  CREATE-PO         FILEFLD

  where  (                   Create Po Fl  = "Y"                            
    And                            Status >= 1                              )


  Is Used In No Indexes
  Is Used In Rel - POLINESRC
  Is Used In No SubType
  Is Used In No States
  Is Used In CndFld - DER-ORIGIN-CD
                    - DER-REQUESTER
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  HAS-ACCOUNTS      OTOFLDS

  where  (             Relation: Accounts 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-DEMAND        OTOFLDS

  where  (             Relation: Whdemand 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-DETAIL        OTOFLDS

  where  (            Relation: Rqlinedtl 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-ITEMSUB       OTOFLDS

  where  (              Relation: Itemsub 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-MMUAVAL       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
--------------------------------------------------------------------------------
  HAS-PH-DEMAND     OTOFLDS

  where  (        Relation: Whdemand Phar 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
--------------------------------------------------------------------------------
  HAS-WHSHIPLINE    OTOFLDS

  where  (           Relation: Whshipline 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
--------------------------------------------------------------------------------
  INVENTORY         FILEFLD

  where  (                      Item Type  = "I"                            )


  Is Used In Index - RLNSET2
  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
--------------------------------------------------------------------------------
  ITEM              FILEFLD

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


  Is Used In No Indexes
  Is Used In Rel - 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
--------------------------------------------------------------------------------
  ITEM-LOCATION     FILEFLD

  where  (                      Item Type  = "I"                            )


  Is Used In No Indexes
  Is Used In Rel - ITEM-LOCATION
  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 Index - RLNSET4
  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-COMPANY        FILEFLD

  where  (                      Item Type != "I"                            )


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

  where  (                   Create Po Fl  = "Y"                            
    And                            Status  = 9                              )


  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
--------------------------------------------------------------------------------
  PROCREJ-STATUS    FILEFLD

  where ((                         Status  = 9                              )
    And  (                      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 - DER-CLOSE-STAT
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  REJECT-STATUS     FILEFLD

  where  (                         Status  = 8                              )


  Is Used In No Indexes
  Is Used In No Rels
  Is Used In No SubType
  Is Used In No States
  Is Used In CndFld - DER-CLOSE-STAT
  Is Used In No AvfFlds
  Is Used In No Rules



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

  where  (                         Status  = 1                              )


  Is Used In No Indexes
  Is Used In No Rels
  Is Used In No SubType
  Is Used In No States
  Is Used In CndFld - DER-CLOSE-STAT
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  UNRELEASE-STAT    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 CndFld - DER-CLOSE-STAT
  Is Used In No AvfFlds
  Is Used In No Rules