Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

CXPREFITEM


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

       

   FILE - CXPREFITEM


  Condition         Type
--------------------------------------------------------------------------------
  CREATE-PO         FILEFLD

  where  (                   Create Po Cd  = "Y"                            )


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

  where  (                 Demand Created  = "Y"                            )


  Is Used In Index - CPISET8
  Is Used In Rel - WHSHIPLINE
  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-LOCATION     FILEFLD

  where  (                  From Location != Spaces                         )


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

  where(((                   Create Po Cd  = "Y"                            )
    And  (                     If Ref Nbr != Zeroes                         )))


  Is Used In Index - CPISET9
  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
--------------------------------------------------------------------------------
  POSTITEM          FILEFLD

  where  (                   Post Item Fl  = "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
--------------------------------------------------------------------------------
  PRAC-TEMP-EXST    OTOFLDS

  where  (       Relation: Prac Temp Item 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 1 Rule



  Condition         Type
--------------------------------------------------------------------------------
  VENDOR-EXISTS     FILEFLD

  where  (                         Vendor != Spaces                         )


  Is Used In No Indexes
  Is Used In Rel - VENDOR
  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