PROCLVLGRP – AR Process Level Report Group

System
Accounts Receivable (AR)
Prefix
PLG
Primary key
COMPANY, RPT-GROUP, SEQ-NBR, PL-GROUP
Fields
4
Updated by
1 program
Referenced by
1 program

PROCLVLGRP is the AR Process Level Report Group table in Lawson Accounts Receivable (prefix PLG). It is indexed by COMPANY, RPT-GROUP, SEQ-NBR, PL-GROUP (PLGSET1); alternate indexes: PLGSET2. It is related 1:1 to ARCOMP and PLGRPHDR and 1:M to PLGRPDTL. It is updated by AR03.2 and referenced by AR203. The table has 4 fields, 2 indexes and 3 documented relations.

About PROCLVLGRP

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.

Fields (4)

Column = COBOL field name without the PLG- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#PLG-COMPANY PK
COMPANY		Numeric 4The number representing an AR company.AR03.2
#PLG-RPT-GROUP PK
RPT_GROUP		Alpha 5Identifies a reporting group of process levels.AR03.2
#PLG-SEQ-NBR PK
SEQ_NBR		Numeric 4Indicates the order in which the groups will be printed and totaled.AR03.2
#PLG-PL-GROUP PK
PL_GROUP		Alpha 5Process level group. This group represents one or more process level detail records for reporting purposes.AR03.2

Indexes (2)

Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
PLGSET1
  1. COMPANY
  2. RPT-GROUP
  3. SEQ-NBR
  4. PL-GROUP
PrimaryAR03.2, AR203
PLGSET2
  1. COMPANY
  2. PL-GROUP
AR03.1, AR03.2

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
ARCOMPPLGRPHDRPLGRPDTLPROCLVLGRP

One to one (2) — lookups and parents

RelationTableRulesConditionField map
Ar CompanyARCOMPRequired
PLG-COMPANY→ACO-COMPANY
Pl Group HdrPLGRPHDRRequired
PLG-COMPANY→PGH-COMPANY
PLG-PL-GROUP→PGH-PL-GROUP

One to many (1) — child tables

RelationTableRulesConditionField map
Pl Group DetlPLGRPDTLRequired
PLG-COMPANY→PGD-COMPANY
PLG-PL-GROUP→PGD-PL-GROUP
—→PGD-PROCESS-LEVEL

Programs

Updated by (1)

Referenced by (1)