Lawson Insight Technical Documentation


ERDs Tables Elements Libraries App Forms

                            PROCLVLGRP FILE

                     AR Process Level Report Group

AR Process Level Report Group

REFERENCED BY

AR203     AR252

UPDATED BY

AR03.2

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

PLG-COMPANY          Numeric 4                                   AR03.2
Company              Company number.

PLG-RPT-GROUP        Alpha 5                                     AR03.2
Process Level        Identifies a reporting group of process
Report Group         levels.

PLG-SEQ-NBR          Numeric 4                                   AR03.2
Sequence Number      Indicates the order in which the groups
                     will be printed and totaled.

PLG-PL-GROUP         Alpha 5                                     AR03.2
Process Level Group  Process level group. This group
                     represents one or more process level
                     detail records for reporting purposes.

                         PROCLVLGRP FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

PLGSET1   COMPANY       This is the primary path used to access  AR03.2  AR203
          RPT-GROUP     records.                                 AR252
          SEQ-NBR
          PL-GROUP

PLGSET2   COMPANY       This path is used to validate process    AR03.1  AR03.2
          PL-GROUP      level group.

                         PROCLVLGRP FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Ar Company     ARCOMP       Required

                            PLG-COMPANY     -> ACO-COMPANY

Pl Group Hdr   PLGRPHDR     Required

                            PLG-COMPANY     -> PGH-COMPANY
                            PLG-PL-GROUP    -> PGH-PL-GROUP

                         PROCLVLGRP FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Pl Group Detl  PLGRPDTL     Required

                            PLG-COMPANY     -> PGD-COMPANY
                            PLG-PL-GROUP    -> PGD-PL-GROUP
                                               PGD-PROCESS-LEVEL