ACBRDNPRRT – Activity Burden Pool Rate

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

ACBRDNPRRT is the Activity Burden Pool Rate table in Lawson Activity Management (prefix BPR). It is indexed by BURDEN-CD, POOL-NBR, BURDEN-TYPE (BPRSET1). It is related 1:1 to ACBRDNHDR and ACBRDNPOOL and 1:M to ACBRDNPRRX. It is updated by AC63.1 and referenced by AC62.1, AC64.1 and BR04.1. The table has 3 fields, 1 index and 3 documented relations.

About ACBRDNPRRT

No description in the Lawson data dictionary.

Fields (3)

Column = COBOL field name without the BPR- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
BPR-BURDEN-CD PK
BURDEN_CD		Alpha 5—AC63.1
BPR-POOL-NBR PK
POOL_NBR		Numeric 3—AC63.1
BPR-BURDEN-TYPE PK
BURDEN_TYPE		Alpha 1Burden type is used to determine the type of calculation that is used to determine the total cost associated with a specific burden.AC63.1

Indexes (1)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
BPRSET1BURDEN-CD, POOL-NBR, BURDEN-TYPEPrimaryAC62.1, AC63.1, AC64.1, BR04.1

Relations

One to one (2) — lookups and parents

RelationTableRulesConditionField map
AcbrdnhdrACBRDNHDRRequiredBPR-BURDEN-CD → BRH-BURDEN-CD
AcbrdnpoolACBRDNPOOLRequiredBPR-BURDEN-CD → BPL-BURDEN-CD, BPR-POOL-NBR → BPL-POOL-NBR

One to many (1) — child tables

RelationTableRulesConditionField map
AcbrdnprrxACBRDNPRRXBPR-BURDEN-CD → BPX-BURDEN-CD, BPR-POOL-NBR → BPX-POOL-NBR, BPR-BURDEN-TYPE → BPX-BURDEN-TYPE, → BPX-EFFECTIVE-DATE, → BPX-DATE-ENTERED

Programs

Updated by (1)

Referenced by (3)