Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms


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

         

   FILE - WORDER


  Condition         Type
--------------------------------------------------------------------------------
  BIN-TRACKED       OTOFLDS

  where  (         Itemmast->Lot Track Fl  = "N"                            
    And            Itemmast->Ser Track Fl  = "N"                            
    And             Itemloc->Bin Track Fl  = "Y"                            )


  Is Used In No Indexes
  Is Used In Rel - BIN-DETAILS
  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
--------------------------------------------------------------------------------
  CANCELED          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 No CndFlds
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  COMPLETED         FILEFLD

  where  (                         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
--------------------------------------------------------------------------------
  CUSTORDER         FILEFLD

  where  (                      System Cd  = "OE"                           
    And                       Doc Nbr Num != Zeroes                         )


  Is Used In No Indexes
  Is Used In Rel - CUSTORDER
  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
--------------------------------------------------------------------------------
  EXPLODED          FILEFLD

  where  (                         Status  = 3                              )


  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
--------------------------------------------------------------------------------
  IN-PRODUCTION     FILEFLD

  where  (                         Status  = 4                              )


  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
--------------------------------------------------------------------------------
  LOT-TRACKED       OTOFLDS

  where  (         Itemmast->Lot Track Fl  = "Y"                            )


  Is Used In No Indexes
  Is Used In Rel - LOT-DETAILS
  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
--------------------------------------------------------------------------------
  NOT-RUSH          FILEFLD

  where  (                      System Cd  = 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
--------------------------------------------------------------------------------
  OE-RUSH           FILEFLD

  where  (                      System Cd  = "OE"                           )


  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
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  ON-HOLD           FILEFLD

  where  (                      Hold Code != Spaces                         )


  Is Used In No Indexes
  Is Used In Rel - HOLDCODES
  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  = 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
--------------------------------------------------------------------------------
  REQHEADER         FILEFLD

  where  (                      System Cd  = "RQ"                           
    And                       Doc Nbr Num != Zeroes                         )


  Is Used In No Indexes
  Is Used In Rel - REQHEADER
  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
--------------------------------------------------------------------------------
  RQ-RUSH           FILEFLD

  where  (                      System Cd  = "RQ"                           )


  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
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  RUSH              FILEFLD

  where  (                      System Cd != 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
--------------------------------------------------------------------------------
  SERIAL-TRACKED    OTOFLDS

  where  (         Itemmast->Ser Track Fl != "N"                            )


  Is Used In No Indexes
  Is Used In Rel - SERIAL-DETAILS
  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  = 1                              )


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

  where  (                  Wo User Fld 1 != Spaces                         )


  Is Used In Index - WORSET7
  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
--------------------------------------------------------------------------------
  VENDOR-ENTERED    FILEFLD

  where  (                         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
--------------------------------------------------------------------------------
  WOTOPRINT         FILEFLD

  where ((                     Printed Fl  = "N"                            )
    And  (                         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 No Rules