BNPLNGROUP – No description in the Lawson data dictionary
- System
- Benefits (BN)
- Prefix
BPG- Primary key
COMPANY,PLAN-GROUP- Fields
- 5
- Updated by
- 1 program
- Referenced by
- 5 programs
BNPLNGROUP is a Lawson Benefits table (prefix BPG); no description in the lawson data dictionary. It is indexed by COMPANY, PLAN-GROUP (BPGSET1); alternate indexes: BPGSET2. It is updated by BS02.1 and referenced by BS03.1, BS03.2, BS03.3, BS12.1 and ZB599. The table has 5 fields, 2 indexes and 0 documented relations.
About BNPLNGROUP
No description in the Lawson data dictionary.
Fields (5)
Column = COBOL field name without the BPG- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
BPG-COMPANY PKCOMPANY | Numeric 4 | — | BS02.1 |
BPG-PLAN-GROUP PKPLAN_GROUP | Alpha 20 | — | BS02.1 |
BPG-PROCESS-ORDERPROCESS_ORDER | Numeric 2 | — | BS02.1 |
BPG-NBR-PLANSNBR_PLANS | Numeric 2 | — | BS02.1, BS12.1 |
BPG-REQUIRED-FLAGREQUIRED_FLAG | Alpha 1 | —
| BS02.1 |
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 |
|---|---|---|---|---|
BPGSET1 | COMPANY, PLAN-GROUP | Primary | BS02.1, BS03.1, BS03.2, BS03.3, BS12.1 | |
BPGSET2 | COMPANY, PROCESS-ORDER | BS02.1, ZB599 |
Programs
Updated by (1)
- BS02.1 Benefits Plan Groups