Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms


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

         

   FILE - DEDCODE


  Condition         Type
--------------------------------------------------------------------------------
  ACCT-CATEGORY     FILEFLD

  where  (                  Acct Category != Spaces                         )


  Is Used In No Indexes
  Is Used In Rel - ACCT-CATEGORY
  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
--------------------------------------------------------------------------------
  ACR-DIST-CO-NZ    FILEFLD

  where  (                    Acr Dist Co != 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 - ACR-DIST-CO-D
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  ACTIVITY          FILEFLD

  where  (                       Activity != Spaces                         )


  Is Used In No Indexes
  Is Used In Rel - ACTIVITY
  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
--------------------------------------------------------------------------------
  ADD-TO-NET        FILEFLD

  where  (                     Adjust Pay  = "A"                            )


  Is Used In No Indexes
  Is Used In No Rels
  Is Used In SubType - ADD-TO-NET
  Is Used In No States
  Is Used In No CndFlds
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  AFTER-TAX         FILEFLD

  where  (                     Adjust Pay  = "S"                            
    And                        Tax Status  = Spaces                         
    And                         Calc Type != "T"                            )


  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
--------------------------------------------------------------------------------
  ARREARS-Y-OR-A    FILEFLD

  where  (                        Arrears  = "A"                            
     Or                           Arrears  = "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
--------------------------------------------------------------------------------
  CA                FILEFLD

  where  (                   Country Code  = "CA"                           )


  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
--------------------------------------------------------------------------------
  CA-BEN-TAX-STS    FILEFLD

  where  (                     Tax Status  = "C1"                           
     Or                        Tax Status  = "C2"                           
     Or                        Tax Status  = "C3"                           
     Or                        Tax Status  = "C4"                           
     Or                        Tax Status  = "C5"                           
     Or                        Tax Status  = "C9"                           )


  Is Used In No Indexes
  Is Used In No Rels
  Is Used In No SubType
  Is Used In No States
  Is Used In CndFld - CA-BEN-TAX-STS
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  CO-MATCH-AFTER    FILEFLD

  where ((                      Calc Type  = "E"                            
     Or                         Calc Type  = "P"                            )
    And                        Adjust Pay  = "C"                            
    And  (                     Tax Status  = Spaces                         
     Or                        Tax Status  = "C1"                           ))


  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
--------------------------------------------------------------------------------
  CO-MATCH-PRE      FILEFLD

  where ((                      Calc Type  = "E"                            
     Or                         Calc Type  = "P"                            )
    And                        Adjust Pay  = "C"                            
    And  (                  Us Tax Status  = 1                              
     Or                        Tax Status  = Spaces                         
     Or                        Tax Status  = "C1"                           
     Or                        Tax Status  = "C2"                           ))


  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
--------------------------------------------------------------------------------
  COMPANY-AMOUNT    FILEFLD

  where  (                      Calc Type  = "A"                            
    And                        Adjust Pay  = "C"                            
    And  (                     Tax Status  = Spaces                         
     Or                     Us Tax Status  = 1                              
     Or                    Ca Ben Tax Sts  = 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
--------------------------------------------------------------------------------
  COMPANY-PAID      FILEFLD

  where  (                     Adjust Pay  = "C"                            )


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



  Condition         Type
--------------------------------------------------------------------------------
  COMPANY-PCT       FILEFLD

  where  (                      Calc Type  = "P"                            
    And                        Adjust Pay  = "C"                            
    And  (                     Tax Status  = Spaces                         
     Or                     Us Tax Status  = 1                              
     Or                    Ca Ben Tax Sts  = 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
--------------------------------------------------------------------------------
  CURRENT-TAX       FILEFLD

  where  (                    Tax Id Code != Spaces                         
    And                          End Date  = Zeroes                         )


  Is Used In Index - DDCSET7
  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
--------------------------------------------------------------------------------
  DDCSET3           FILEFLD

  where  (                       Req Code != Spaces                         )


  Is Used In Index - DDCSET3
  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
--------------------------------------------------------------------------------
  DDCSET5           FILEFLD

  where  (                    Change Flag  = "Y"                            )


  Is Used In Index - DDCSET5
  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
--------------------------------------------------------------------------------
  DED-CLASS         FILEFLD

  where  (                      Ded Class != Spaces                         )


  Is Used In No Indexes
  Is Used In Rel - DED-CLASS
  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
--------------------------------------------------------------------------------
  DEFERRED-COMP     FILEFLD

  where  (                     Tax Status  = "01"                           
     Or                        Tax Status  = "02"                           
     Or                        Tax Status  = "03"                           
     Or                        Tax Status  = "04"                           
     Or                        Tax Status  = "05"                           )


  Is Used In No Indexes
  Is Used In No Rels
  Is Used In No SubType
  Is Used In No States
  Is Used In CndFld - US-TAX-STATUS
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  EMP-AMT-AFTER     FILEFLD

  where  (                      Calc Type  = "A"                            
    And                        Adjust Pay  = "S"                            
    And                        Tax Status  = 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
--------------------------------------------------------------------------------
  EMP-AMT-PRETAX    FILEFLD

  where  (                      Calc Type  = "A"                            
    And                        Adjust Pay  = "S"                            
    And                        Tax Status >= "01"                           
    And                        Tax Status <= "11"                           
     Or  (                     Tax Status  = "C1"                           
     Or                        Tax Status  = "C2"                           ))


  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
--------------------------------------------------------------------------------
  EMP-PCT-AFTER     FILEFLD

  where  (                      Calc Type  = "P"                            
    And                        Adjust Pay  = "S"                            
    And                        Tax Status  = 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
--------------------------------------------------------------------------------
  EMP-PCT-PRETAX    FILEFLD

  where  (                      Calc Type  = "P"                            
    And                        Adjust Pay  = "S"                            
    And                        Tax Status >= "01"                           
    And                        Tax Status <= "11"                           )


  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
--------------------------------------------------------------------------------
  EMPLOYEE-PAID     FILEFLD

  where  (                     Adjust Pay  = "S"                            )


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



  Condition         Type
--------------------------------------------------------------------------------
  EXP-DIST-CO-NZ    FILEFLD

  where  (                    Exp Dist Co != 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 - EXP-DIST-CO-D
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  EXPENSE-ACCT      FILEFLD

  where  (                    Exp Account != Zeroes                         
     Or                     Exp Acct Unit != Spaces                         )


  Is Used In No Indexes
  Is Used In Rel - EXPENSE-ACCT
  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
--------------------------------------------------------------------------------
  FLEX-DED-CODE     FILEFLD

  where  (                     Adjust Pay  = "C"                            
    And                         Calc Type  = "A"                            
    And                        Tax Status  = 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
--------------------------------------------------------------------------------
  LINKED-DED        FILEFLD

  where  (                     Linked Ded != Spaces                         )


  Is Used In No Indexes
  Is Used In Rel - LINKED-DED
  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
--------------------------------------------------------------------------------
  MATCHED-CALC      OTOFLDS

  where  (         Matched Ded->Calc Type  = "P"                            
     Or            Matched Ded->Calc Type  = "A"                            )


  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
--------------------------------------------------------------------------------
  MATCHED-DED       FILEFLD

  where  (                    Matched Ded != Spaces                         )


  Is Used In No Indexes
  Is Used In Rel - MATCHED-DED
  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
--------------------------------------------------------------------------------
  MATCHED-EMP-PD    OTOFLDS

  where  (        Matched Ded->Adjust Pay  = "S"                            )


  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
--------------------------------------------------------------------------------
  NON-TAX           FILEFLD

  where  (                      Calc Type != "T"                            )


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



  Condition         Type
--------------------------------------------------------------------------------
  PAY-CLASS         FILEFLD

  where  (                      Pay Class != Spaces                         )


  Is Used In No Indexes
  Is Used In Rel - PAY-CLASS
  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
--------------------------------------------------------------------------------
  PRE-TAX           FILEFLD

  where  (                     Tax Status >= "06"                           
    And                        Tax Status <= "12"                           )


  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
--------------------------------------------------------------------------------
  REQ-CODE          FILEFLD

  where  (                       Req Code != Spaces                         )


  Is Used In No Indexes
  Is Used In Rel - REQ-CODE
  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
--------------------------------------------------------------------------------
  TABLE-EXEMPT      FILEFLD

  where  (                     Tax Status  = "X"                            )


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

  where  (                      Calc Type  = "T"                            )


  Is Used In Index - DDCSET6
  Is Used In Rel - TAX-ID-CODE
  Is Used In SubType - TAX
  Is Used In No States
  Is Used In No CndFlds
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  TAX-CAT-ONE       FILEFLD

  where  (                   Tax Category  = 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
--------------------------------------------------------------------------------
  TAX-CATEGORY      FILEFLD

  where  (                   Tax Category != Zeroes                         )


  Is Used In No Indexes
  Is Used In Rel - TAX-CATEGORY
  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
--------------------------------------------------------------------------------
  TAX-STATE         OTOFLDS

  where  (         Tax Id Code->Tax State != Spaces                         )


  Is Used In No Indexes
  Is Used In Rel - TAX-STATE
  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
--------------------------------------------------------------------------------
  TAXABLE           FILEFLD

  where  (                     Tax Status  = 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
--------------------------------------------------------------------------------
  TBL-EXMP-EXIST    OTOFLDS

  where  (       Relation: Tbl Exempt Ded 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
--------------------------------------------------------------------------------
  US                FILEFLD

  where  (                   Country Code  = "US"                           )


  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