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.

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 marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
BPLSET1BURDEN-CD, POOL-NBRPrimaryAC261, AC262, AC263, AC60.1, AC61.1, AC62.1, AC63.1, BR04.1

Relations

One to one (1) — lookups and parents

RelationTableRulesConditionField map
AcbrdnhdrACBRDNHDRRequiredBPL-BURDEN-CD → BRH-BURDEN-CD

One to many (3) — child tables

RelationTableRulesConditionField map
AcbrdnplxACBRDNPLXBPL-BURDEN-CD → BPA-BURDEN-CD, → BPA-POOL-NBR
AcbrdnprrtACBRDNPRRTBPL-BURDEN-CD → BPR-BURDEN-CD, BPL-POOL-NBR → BPR-POOL-NBR, → BPR-BURDEN-TYPE
AcbrdnprrxACBRDNPRRXBPL-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)