Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms


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

         

   FILE - ICTRANS


  Condition         Type
--------------------------------------------------------------------------------
  CREDITACCOUNT     FILEFLD

  where  (                  Off Acct Unit != Spaces                         
    And                       Off Account != Zeroes                         
    And                      Off Sub Acct != Zeroes                         )


  Is Used In No Indexes
  Is Used In No Rels
  Is Used In SubType - CREDITACCOUNT
  Is Used In No States
  Is Used In No CndFlds
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  DETAIL-EXISTS     OTOFLDS

  where  (           Relation: Ictransdtl 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
--------------------------------------------------------------------------------
  HISTORY-REPORT    FILEFLD

  where ((                       Doc Type  = "IS"                           
     Or                          Doc Type  = "RR"                           )
    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



  Condition         Type
--------------------------------------------------------------------------------
  ICTSET4           FILEFLD

  where ((                         Status  = 1                              
     Or                            Status  = 5                              ))


  Is Used In Index - ICTSET4
  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
--------------------------------------------------------------------------------
  ICTSET5           FILEFLD

  where  (                         Status  = Zeroes                         )


  Is Used In Index - ICTSET5
  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
--------------------------------------------------------------------------------
  INSPECTION        FILEFLD

  where  (                       Doc Type  = "RJ"                           
     Or                          Doc Type  = "AC"                           )


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

  where  (                  Inv Acct Unit != 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
--------------------------------------------------------------------------------
  MFG-INFO-EXIST    FILEFLD

  where  (                       Manuf Id != Zeroes                         )


  Is Used In Index - ICTSET8
  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
--------------------------------------------------------------------------------
  MMDIST-EXISTS     OTOFLDS

  where  (               Relation: Mmdist 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
--------------------------------------------------------------------------------
  PO-RECEIVING      FILEFLD

  where  (                       Doc Type  = "PO"                           )


  Is Used In No Indexes
  Is Used In Rel - PORECLINE
  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
--------------------------------------------------------------------------------
  POSTED            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
--------------------------------------------------------------------------------
  REASONCODE        FILEFLD

  where  (                    Reason Code != Spaces                         )


  Is Used In No Indexes
  Is Used In Rel - REASONCODE
  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
--------------------------------------------------------------------------------
  REC-ADJUST        FILEFLD

  where  (                       Doc Type  = "RA"                           )


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

  where  (                         Status != Zeroes                         )


  Is Used In Index - ICTSET2
                   - ICTSET3
                   - ICTSET7
  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
--------------------------------------------------------------------------------
  REQ-RETURN        FILEFLD

  where  (                       Doc Type  = "RR"                           )


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

  where  (                      System Cd  = "RQ"                           )


  Is Used In No Indexes
  Is Used In Rel - REQLINE
  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
--------------------------------------------------------------------------------
  RETURN-EXISTS     OTOFLDS

  where  (           Relation: Poreturnln 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
--------------------------------------------------------------------------------
  SHIPLN-EXISTS     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
--------------------------------------------------------------------------------
  UNPOSTED          FILEFLD

  where  (                         Status  = Zeroes                         
    And                          Doc Type  = "IS"                           
     Or                          Doc Type  = "RT"                           
     Or  (                       Doc Type  = "AJ"                           
    And                          Quantity  < 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 No Rules



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

  where  (                       Doc Type  = "VR"                           
     Or                          Doc Type  = "VA"                           )


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