Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

PRDISTRIB


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

       

   FILE - PRDISTRIB


  Condition         Type
--------------------------------------------------------------------------------
  ACCRUAL           FILEFLD

  where  (                    Record 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
--------------------------------------------------------------------------------
  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
--------------------------------------------------------------------------------
  ACTIVITY          FILEFLD

  where  (                       Activity != Spaces                         )


  Is Used In Index - PRDSET5
  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
--------------------------------------------------------------------------------
  ACTRANS           OTOFLDS

  where ((              Relation: Actrans 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
--------------------------------------------------------------------------------
  CASH              FILEFLD

  where  (                    Record Type  = "C"                            )


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

  where  (                       Ded Code != Spaces                         )


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

  where  (                     Department != Spaces                         )


  Is Used In No Indexes
  Is Used In Rel - DEPARTMENT
  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
--------------------------------------------------------------------------------
  DIST-COMPANY      FILEFLD

  where  (                   Dist Company != Zeroes                         )


  Is Used In No Indexes
  Is Used In Rel - DIST-COMPANY
  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          FILEFLD

  where  (                       Employee != Zeroes                         )


  Is Used In No Indexes
  Is Used In Rel - EMPLOYEE
  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
--------------------------------------------------------------------------------
  EXPENSE           FILEFLD

  where  (                    Record Type  = "E"                            )


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

  where  (                     Glt Obj Id != Zeroes                         )


  Is Used In No Indexes
  Is Used In Rel - GLTRANS
  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
--------------------------------------------------------------------------------
  GMLABDIST         OTOFLDS

  where ((            Relation: Gmlabdist 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
--------------------------------------------------------------------------------
  GMRETDIST1        OTOFLDS

  where ((           Relation: Gmretdist1 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
--------------------------------------------------------------------------------
  GMRETDIST2        OTOFLDS

  where ((           Relation: Gmretdist2 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
--------------------------------------------------------------------------------
  HISTORICAL        FILEFLD

  where  (                         Status  = 9                              )


  Is Used In Index - PRDSET6
  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
--------------------------------------------------------------------------------
  JOB-CODE          FILEFLD

  where  (                       Job Code != Spaces                         )


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

  where ((                         Status  = Zeroes                         )
    And  (                     Error Type != 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
--------------------------------------------------------------------------------
  PAY-CODE          FILEFLD

  where  (                    Pcd Seq Nbr != Zeroes                         )


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

  where  (                       Position != Spaces                         )


  Is Used In Index - PRDSET7
  Is Used In Rel - POSITION
  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
--------------------------------------------------------------------------------
  SLTRANS-EXISTS    OTOFLDS

  where  (              Relation: Sltrans 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
--------------------------------------------------------------------------------
  SUB-ACCOUNT       FILEFLD

  where  (                   Dst Sub Acct != 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 - FULL-ACCT
  Is Used In No AvfFlds
  Is Used In No Rules