Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

TATABLE


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

       

   FILE - TATABLE


  Condition         Type
--------------------------------------------------------------------------------
  ACCR-EARNINGS     FILEFLD

  where ((                     Table Type  = 2                              )
    And  (                      Rule Type  = 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
--------------------------------------------------------------------------------
  ACCR-HOURS        FILEFLD

  where(((                     Table Type  = 1                              )
    And  (                      Rule Type  = 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
--------------------------------------------------------------------------------
  ACCRUAL-RULE      FILEFLD

  where ((                      Rule Type  = 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
--------------------------------------------------------------------------------
  ALLOT-EARNINGS    FILEFLD

  where ((                     Table Type  = 2                              )
    And  (                      Rule Type  = 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
--------------------------------------------------------------------------------
  ALLOT-HOURS       FILEFLD

  where ((                     Table Type  = 1                              )
    And  (                      Rule Type  = 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
--------------------------------------------------------------------------------
  ALLOT-RULE        FILEFLD

  where ((                      Rule Type  = 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
--------------------------------------------------------------------------------
  CYC-BASED-ACCR    FILEFLD

  where ((                    Table Basis  = 1                              )
    And  (                      Rule Type  = 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
--------------------------------------------------------------------------------
  CYC-BASED-ALLT    FILEFLD

  where ((                    Table Basis  = 1                              )
    And  (                      Rule Type  = 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
--------------------------------------------------------------------------------
  CYC-BASED-GL      FILEFLD

  where ((                    Table Basis  = 1                              )
    And  (                      Rule Type  = 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
--------------------------------------------------------------------------------
  CYC-BASED-LMT     FILEFLD

  where ((                    Table Basis  = 1                              )
    And  (                      Rule Type  = 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
--------------------------------------------------------------------------------
  CYCLE-BASIS       FILEFLD

  where ((                    Table Basis  = 1                              ))


  Is Used In Index - TBLSET3
  Is Used In No Rels
  Is Used In SubType - CYCLE-BASIS
  Is Used In No States
  Is Used In No CndFlds
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  EARNINGS-TYPE     FILEFLD

  where  (                     Table Type  = 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
--------------------------------------------------------------------------------
  GL-EARNINGS       FILEFLD

  where ((                     Table Type  = 2                              )
    And  (                      Rule Type  = 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
--------------------------------------------------------------------------------
  GL-HOURS          FILEFLD

  where ((                     Table Type  = 1                              )
    And  (                      Rule Type  = 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
--------------------------------------------------------------------------------
  GL-RULE           FILEFLD

  where ((                      Rule Type  = 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
--------------------------------------------------------------------------------
  HOURS-BASIS       FILEFLD

  where ((                    Table Basis  = 2                              ))


  Is Used In Index - TBLSET4
  Is Used In No Rels
  Is Used In SubType - HOURS-BASIS
  Is Used In No States
  Is Used In No CndFlds
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  HOURS-SRV-CLS     FILEFLD

  where ((                  Hours Srv Cls != Spaces                         ))


  Is Used In No Indexes
  Is Used In Rel - HOURS-SRV-CLS
  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
--------------------------------------------------------------------------------
  HOURS-TYPE        FILEFLD

  where  (                     Table Type  = 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
--------------------------------------------------------------------------------
  HRS-BASED-ACCR    FILEFLD

  where ((                    Table Basis  = 2                              )
    And  (                      Rule Type  = 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
--------------------------------------------------------------------------------
  HRS-BASED-ALLT    FILEFLD

  where ((                    Table Basis  = 2                              )
    And  (                      Rule Type  = 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
--------------------------------------------------------------------------------
  HRS-BASED-GL      FILEFLD

  where ((                    Table Basis  = 2                              )
    And  (                      Rule Type  = 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
--------------------------------------------------------------------------------
  HRS-BASED-LMT     FILEFLD

  where ((                    Table Basis  = 2                              )
    And  (                      Rule Type  = 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
--------------------------------------------------------------------------------
  LIMIT-EARNINGS    FILEFLD

  where ((                     Table Type  = 2                              )
    And  (                      Rule Type  = 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
--------------------------------------------------------------------------------
  LIMIT-HOURS       FILEFLD

  where ((                     Table Type  = 1                              )
    And  (                      Rule Type  = 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
--------------------------------------------------------------------------------
  LIMIT-RULE        FILEFLD

  where ((                      Rule Type  = 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
--------------------------------------------------------------------------------
  TATABLEX          OTOFLDS

  where ((             Relation: Tatablex 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