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. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#BPG-COMPANY PK
COMPANY		Numeric 4—BS02.1
#BPG-PLAN-GROUP PK
PLAN_GROUP		Alpha 20—BS02.1
#BPG-PROCESS-ORDER SET2
PROCESS_ORDER		Numeric 2—BS02.1
#BPG-NBR-PLANS
NBR_PLANS		Numeric 2—BS02.1, BS12.1
#BPG-REQUIRED-FLAG
REQUIRED_FLAG		Alpha 1—
  • Y Yes
  • N No
BS02.1

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
BPGSET1
  1. COMPANY
  2. PLAN-GROUP
PrimaryBS02.1, BS03.1, BS03.2, BS03.3, BS12.1
BPGSET2
  1. COMPANY
  2. PROCESS-ORDER
BS02.1, ZB599

Programs

Updated by (1)

Referenced by (5)