Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

COMISC


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

       

   FILE - COMISC


  Condition         Type
--------------------------------------------------------------------------------
  AOC-CODE          FILEFLD

  where  (                       Aoc Code != Spaces                         
    And                            Status != 8                              )


  Is Used In Index - CMCSET3
  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
--------------------------------------------------------------------------------
  CGS-ACCOUNT       FILEFLD

  where  (                  Cgs Acct Unit != Spaces                         
     Or                       Cgs Account != Zeroes                         
     Or                      Cgs Sub Acct != Zeroes                         )


  Is Used In No Indexes
  Is Used In Rel - CGS-ACCOUNT
  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
--------------------------------------------------------------------------------
  COLINE            FILEFLD

  where  (                       Line Nbr != Zeroes                         )


  Is Used In No Indexes
  Is Used In Rel - COLINE
  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
--------------------------------------------------------------------------------
  COMMITTED         FILEFLD

  where  (                     Atn Obj Id != Zeroes                         )


  Is Used In Index - CMCSET4
  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
--------------------------------------------------------------------------------
  COMMITTED-C       FILEFLD

  where  (                   Atn Obj Id C != Zeroes                         )


  Is Used In Index - CMCSET5
  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
--------------------------------------------------------------------------------
  FLAT-AMOUNT       FILEFLD

  where  (                    Charge 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 CndFld - PRT-PRC-CURR
                    - PRT-PRICE
  Is Used In No AvfFlds
  Is Used In 1 Rule



  Condition         Type
--------------------------------------------------------------------------------
  LINE-ADD-ON       FILEFLD

  where  (                       Line Nbr != 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
--------------------------------------------------------------------------------
  LINE-PCT          FILEFLD

  where  (                       Line Nbr != Zeroes                         
    And                       Charge 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
--------------------------------------------------------------------------------
  LINE-UNIT-PRC     FILEFLD

  where  (                       Line Nbr != Zeroes                         
    And                       Charge 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
--------------------------------------------------------------------------------
  MULT-RATE         OTOFLDS

  where  (           Custorder->Curr Mudv  = "M"                            )


  Is Used In No Indexes
  Is Used In No Rels
  Is Used In No SubType
  Is Used In No States
  Is Used In CndFld - BILLED-BASE
                    - TAX-AMT-BASE
                    - TAXABLE-BASE
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  NOT-CANCELLED     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
--------------------------------------------------------------------------------
  OFF-ACCOUNT       FILEFLD

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


  Is Used In No Indexes
  Is Used In Rel - OFF-ACCOUNT
  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
--------------------------------------------------------------------------------
  OPEN              FILEFLD

  where  (                         Status  = 1                              
     Or                            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
--------------------------------------------------------------------------------
  ORDER-AOC         FILEFLD

  where  (                       Line Nbr  = 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 - PRT-PRC-CURR
                    - PRT-PRICE
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  ORDER-PCT         FILEFLD

  where  (                       Line Nbr  = Zeroes                         
    And                       Charge 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
--------------------------------------------------------------------------------
  PER-UNIT          FILEFLD

  where  (                    Charge 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 CndFld - PER-UNIT-FL
                    - PRT-PRC-CURR
                    - PRT-PRICE
  Is Used In No AvfFlds
  Is Used In 1 Rule



  Condition         Type
--------------------------------------------------------------------------------
  PERCENTAGE        FILEFLD

  where  (                    Charge 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 1 Rule



  Condition         Type
--------------------------------------------------------------------------------
  SALES-ACCOUNT     FILEFLD

  where  (                  Sls Acct Unit != Spaces                         
     Or                       Sls Account != Zeroes                         
     Or                      Sls Sub Acct != Zeroes                         )


  Is Used In No Indexes
  Is Used In Rel - SALES-ACCOUNT
  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
--------------------------------------------------------------------------------
  SHIPPED           FILEFLD

  where  (                   Shipment Nbr != Zeroes                         
    And                          Line Nbr  = 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
--------------------------------------------------------------------------------
  SHIPPED-LINE      FILEFLD

  where  (                   Shipment Nbr != Zeroes                         
    And                          Line Nbr != 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