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

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 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
BPRSET1
  1. BURDEN-CD
  2. POOL-NBR
  3. BURDEN-TYPE
PrimaryAC62.1, AC63.1, AC64.1, BR04.1

Relations

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

One to one (2) — lookups and parents

RelationTableRulesConditionField map
AcbrdnhdrACBRDNHDRRequired
BPR-BURDEN-CD→BRH-BURDEN-CD
AcbrdnpoolACBRDNPOOLRequired
BPR-BURDEN-CD→BPL-BURDEN-CD
BPR-POOL-NBR→BPL-POOL-NBR

One to many (1) — child tables

RelationTableRulesConditionField map
AcbrdnprrxACBRDNPRRX
BPR-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)