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.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
PLG-COMPANY PKCOMPANY | Numeric 4 | The number representing an AR company. | AR03.2 |
PLG-RPT-GROUP PKRPT_GROUP | Alpha 5 | Identifies a reporting group of process levels. | AR03.2 |
PLG-SEQ-NBR PKSEQ_NBR | Numeric 4 | Indicates the order in which the groups will be printed and totaled. | AR03.2 |
PLG-PL-GROUP PKPL_GROUP | Alpha 5 | Process level group. This group represents one or more process level detail records for reporting purposes. | AR03.2 |
Indexes (2)
Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
PLGSET1 | COMPANY, RPT-GROUP, SEQ-NBR, PL-GROUP | Primary | AR03.2, AR203 | |
PLGSET2 | COMPANY, PL-GROUP | AR03.1, AR03.2 |
Relations
One to one (2) — lookups and parents
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| Ar Company | ARCOMP | Required | PLG-COMPANY → ACO-COMPANY | |
| Pl Group Hdr | PLGRPHDR | Required | PLG-COMPANY → PGH-COMPANY, PLG-PL-GROUP → PGH-PL-GROUP |
One to many (1) — child tables
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| Pl Group Detl | PLGRPDTL | Required | PLG-COMPANY → PGD-COMPANY, PLG-PL-GROUP → PGD-PL-GROUP, PGD-PROCESS-LEVEL |
Programs
Updated by (1)
- AR03.2 Process Level Report Group
Referenced by (1)
- AR203 Report Group Listing