ACBRDNPOOL – Activity Burden Pool

System
Activity Management (AC)
Prefix
BPL
Primary key
BURDEN-CD, POOL-NBR
Fields
3
Updated by
1 program
Referenced by
7 programs

ACBRDNPOOL is the Activity Burden Pool table in Lawson Activity Management (prefix BPL). It is indexed by BURDEN-CD, POOL-NBR (BPLSET1). It is related 1:1 to ACBRDNHDR and 1:M to ACBRDNPLX, ACBRDNPRRT and ACBRDNPRRX. It is updated by AC62.1 and referenced by AC261, AC262, AC263, AC60.1, AC61.1, AC63.1 and BR04.1. The table has 3 fields, 1 index and 4 documented relations.

About ACBRDNPOOL

No description in the Lawson data dictionary.

Fields (3)

Column = COBOL field name without the BPL- 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
#BPL-BURDEN-CD PK
BURDEN_CD
Alpha 5—AC62.1
#BPL-POOL-NBR PK
POOL_NBR
Numeric 3—AC62.1
#BPL-POOL-DESC
POOL_DESC
Alpha 30—AC62.1

Indexes (1)

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
BPLSET1
  1. BURDEN-CD
  2. POOL-NBR
PrimaryAC261, AC262, AC263, AC60.1, AC61.1, AC62.1, AC63.1, BR04.1

Relations

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

One to one (1) — lookups and parents

RelationTableRulesConditionField map
AcbrdnhdrACBRDNHDRRequired
BPL-BURDEN-CD→BRH-BURDEN-CD

One to many (3) — child tables

RelationTableRulesConditionField map
AcbrdnplxACBRDNPLX
BPL-BURDEN-CD→BPA-BURDEN-CD
—→BPA-POOL-NBR
AcbrdnprrtACBRDNPRRT
BPL-BURDEN-CD→BPR-BURDEN-CD
BPL-POOL-NBR→BPR-POOL-NBR
—→BPR-BURDEN-TYPE
AcbrdnprrxACBRDNPRRX
BPL-BURDEN-CD→BPX-BURDEN-CD
BPL-POOL-NBR→BPX-POOL-NBR
—→BPX-BURDEN-TYPE
—→BPX-EFFECTIVE-DATE
—→BPX-DATE-ENTERED

Programs

Updated by (1)

Referenced by (7)