Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

OEWKSHEET


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

       

   FILE - OEWKSHEET


  Condition         Type
--------------------------------------------------------------------------------
  CREATED           FILEFLD, STATE

  where  (                         Status  = 1                              )


  Is Used In No Indexes
  Is Used In No Rels
  Is Used In No SubType
  Is Used In State - CREATED
  Is Used In No CndFlds
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  EDIT              FILEFLD, STATE

  where  (                         Status  = Zeroes                         )


  Is Used In No Indexes
  Is Used In No Rels
  Is Used In No SubType
  Is Used In State - EDIT
  Is Used In No CndFlds
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  EFF-DT-GE-CURR    FILEFLD

  where  (                  Plan Eff Date >=                                )


  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
--------------------------------------------------------------------------------
  ICLOCATION        FILEFLD

  where  (                   Sel Location != Spaces                         )


  Is Used In No Indexes
  Is Used In Rel - ICLOCATION
  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
--------------------------------------------------------------------------------
  NO-BASE-CURR      OTOFLDS

  where  (       Oecompany->Currency 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 No CndFlds
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  PROCESSED         FILEFLD, STATE

  where  (                         Status  = 3                              )


  Is Used In No Indexes
  Is Used In No Rels
  Is Used In No SubType
  Is Used In State - PROCESSED
  Is Used In No CndFlds
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  RELEASED          FILEFLD, STATE

  where  (                         Status  = 2                              )


  Is Used In No Indexes
  Is Used In No Rels
  Is Used In No SubType
  Is Used In State - RELEASED
  Is Used In No CndFlds
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  SEL-BASE-ENTRD    FILEFLD

  where  (                       Sel Base != Spaces                         )


  Is Used In No Indexes
  Is Used In Rel - OESELBASE
  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
--------------------------------------------------------------------------------
  SEL-CURR          FILEFLD

  where  (                       Sel Curr != Spaces                         )


  Is Used In No Indexes
  Is Used In Rel - SEL-CURR
  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
--------------------------------------------------------------------------------
  SEL-LOC-ENTRD     FILEFLD

  where  (                   Sel Base Loc != Spaces                         )


  Is Used In No Indexes
  Is Used In Rel - ITEMLOC
                 - SEL-LOCATION
  Is Used In No SubType
  Is Used In No States
  Is Used In No CndFlds
  Is Used In No AvfFlds
  Is Used In 2 Rules



  Condition         Type
--------------------------------------------------------------------------------
  UPD-CURR          FILEFLD

  where  (                       Upd Curr != Spaces                         )


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

  where  (                        Upd Loc != Spaces                         )


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

  where  (                     Sel Vendor != Spaces                         )


  Is Used In No Indexes
  Is Used In Rel - APCOMPANY
                 - APVENMAST
  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
--------------------------------------------------------------------------------
  WKSHEET-CREATD    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 1 Rule



  Condition         Type
--------------------------------------------------------------------------------
  WKSHT-IN-PRCSS    FILEFLD

  where  (                         Status  = 1                              
     Or                            Status  = 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 1 Rule