Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms


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

         

   FILE - WHDEMAND


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

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


  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
--------------------------------------------------------------------------------
  CASE-CART         FILEFLD

  where  (                      System Cd  = "CX"                           )


  Is Used In No Indexes
  Is Used In Rel - CASEHEADER
                 - CASELINE
  Is Used In No SubType
  Is Used In No States
  Is Used In CndFld - ORIGIN
                    - SRC-ITEM-DESC
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  CTW               OTOFLDS

  where  (             Itemmast->Ctw Code  = "A"                            
     Or                Itemmast->Ctw Code  = "R"                            )


  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-ALLOCATED
                    - DISP-BACKORD
                    - DISP-IN-PROC
                    - DISP-PRINTED
                    - DISP-QUANTITY
                    - DISP-SHIPPED
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  CUSTOMER-ORDER    FILEFLD

  where  (                      System Cd  = "OE"                           )


  Is Used In No Indexes
  Is Used In Rel - COLINE
                 - CUSTORDER
  Is Used In No SubType
  Is Used In No States
  Is Used In CndFld - ORIGIN
                    - SRC-ITEM-DESC
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  DEMAND            FILEFLD

  where ((                    Record Type  = "D"                            ))


  Is Used In Index - WDMSET1
                   - WDMSET9
  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
--------------------------------------------------------------------------------
  DETAIL-REQ        FILEFLD

  where ((                    Record Type  = "D"                            )
    And  (                      Line Type  = "I"                            )
    And  (                     Detail Req  = "Y"                            ))


  Is Used In Index - WDMSET4
  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
--------------------------------------------------------------------------------
  FG-TO-ALLOC       FILEFLD

  where ((                    Record Type  = "D"                            
    And                      Allocable Fl  = "Y"                            
    And                       Backord Qty  > Zeroes                         
    And                            Kit Fl  = "S"                            
    And                            Status  = 1                              
    And                       Obj Id Dmnd  = Zeroes                         ))


  Is Used In Index - WDMSET6
  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
--------------------------------------------------------------------------------
  GATHEREDMND       FILEFLD

  where ((                    Obj Id Dmnd  > Zeroes                         
    And                       Obj Id Dmnd  < 999999999999                   ))


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

  where  (                      System Cd  = "PO"                           
    And                       Record Type  = "S"                            
    And                   Poline->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
--------------------------------------------------------------------------------
  INVENTORIED       FILEFLD

  where  (                      Line Type  = "I"                            )


  Is Used In No Indexes
  Is Used In Rel - ICLOCATION
                 - ITEMLOC
                 - ITEMLOCS
  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, OTOFLDS

  where  (                      System Cd  = "PO"                           
    And                       Record Type  = "S"                            
    And                Poline->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
--------------------------------------------------------------------------------
  ITEMMAST          FILEFLD

  where  (                      Line Type  = "I"                            
     Or                         Line 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 CndFld - SRC-ITEM-DESC
  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 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                FILEFLD

  where  (                    Record Type  = "S"                            
    And                         System Cd  = "PO"                           )


  Is Used In No Indexes
  Is Used In Rel - APCOMPANY
                 - APVENMAST
                 - POLINE
  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
--------------------------------------------------------------------------------
  READ-TO-ALLOC     FILEFLD

  where ((                    Record Type  = "D"                            )
    And  (                   Allocable Fl  = "Y"                            )
    And  (                  Component Seq  = Zeroes                         )
    And  (                       Quantity  > Printed Qty                    ))


  Is Used In Index - WDMSET2
  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
--------------------------------------------------------------------------------
  REQUISITION       FILEFLD

  where  (                      System Cd  = "RQ"                           )


  Is Used In No Indexes
  Is Used In Rel - REQHEADER
                 - REQLINE
  Is Used In No SubType
  Is Used In No States
  Is Used In CndFld - ORIGIN
                    - SRC-ITEM-DESC
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  RETURN            FILEFLD

  where  (                      System Cd  = "RT"                           )


  Is Used In No Indexes
  Is Used In Rel - RETURNHDR
                 - RETURNLINE
  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  = "R"                            )


  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
--------------------------------------------------------------------------------
  SHIP-CREATE       FILEFLD

  where ((                    Record Type  = "D"                            )
    And  (                         Status  = 1                              )
    And  (                  Component Seq  = Zeroes                         )
    And  (                      Alloc Qty  > Printed Qty                    )
    And  (                      System Cd != "WO"                           ))


  Is Used In Index - WDMSET3
  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
--------------------------------------------------------------------------------
  SUPPLY            FILEFLD

  where  (                    Record Type  = "S"                            )


  Is Used In Index - WDMSET7
  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
--------------------------------------------------------------------------------
  UOM-TRACKED       FILEFLD, OTOFLDS

  where  (         Itemmast->Lot Track Fl  = "N"                            
    And            Itemmast->Ser Track Fl != "R"                            
    And             Itemloc->Bin Track Fl  = "N"                            
    And                        Detail Req  = "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