Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                            PROCLVLGRP FILE

                     AR Process Level Report Group

The AR Process Level Report Group file contains process level group records.
A process level group represents one or more process level detail records used
in reporting purposes. A process level group is user defined and allows for
unique report selection and sorting criteria.

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