ACBRDNPRRX – Activity Burden Pool Rate Dtl

System: Activity Management (AC)
Prefix: BPX
Primary key: BURDEN-CD, POOL-NBR, BURDEN-TYPE, EFFECTIVE-DATE, DATE-ENTERED
Fields: 9
Updated by: 1 program
Referenced by: 4 programs

ACBRDNPRRX is the Activity Burden Pool Rate Dtl table in Lawson Activity Management (prefix BPX). It is indexed by BURDEN-CD, POOL-NBR, BURDEN-TYPE, EFFECTIVE-DATE, DATE-ENTERED (BPXSET1); alternate indexes: BPXSET2. It is related 1:1 to ACBRDNHDR, ACBRDNPLX, ACBRDNPOOL, ACBRDNPRRT, ACCMPPARAM and CMPUTE. It is updated by AC63.1 and referenced by AC190, AC197, AC198 and AC263. The table has 9 fields, 2 indexes and 6 documented relations.

About ACBRDNPRRX

No description in the Lawson data dictionary.

Fields (9)

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

Field / column	Type	Description & values	Updated by
`BPX-BURDEN-CD` PK BURDEN_CD	Alpha 5	—	AC63.1
`BPX-POOL-NBR` PK POOL_NBR	Numeric 3	—	AC63.1
`BPX-BURDEN-TYPE` PK BURDEN_TYPE	Alpha 1	Burden type is used to determine the type of calculation that is used to determine the total cost associated with a specific burden.	AC63.1
`BPX-EFFECTIVE-DATE` PK EFFECTIVE_DATE	Numeric 8 (yyyymmdd)	The date a vendor's prices will be in effect.	AC63.1
`BPX-PROV-RATE` PROV_RATE	Signed 13.4	—	AC63.1
`BPX-COMPUTE-NAME` COMPUTE_NAME	Alpha 12	The name assigned to an arithmetic equation created in Compute Statement (RW50.1). A compute statement consists of data dictionary items and operation symbols.	AC63.1
`BPX-PARAM-NAME` PARAM_NAME	Alpha 12	—	AC63.1
`BPX-DATE-ENTERED` PK DATE_ENTERED	Numeric 8 (yyyymmdd)	—	AC63.1
`BPX-ACTIVE-STATUS` ACTIVE_STATUS	Alpha 1	The status of the account. If Inactive, no posting can be done to the account. `A` Active `I` Inactive	AC63.1

Indexes (2)

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

Index	Keys	Flags	Condition	Used in
`BPXSET1`	`BURDEN-CD`, `POOL-NBR`, `BURDEN-TYPE`, `EFFECTIVE-DATE`, `DATE-ENTERED`	Primary		AC263, AC63.1
`BPXSET2`	`BURDEN-CD`, `POOL-NBR`, `BURDEN-TYPE`, `ACTIVE-STATUS`, `EFFECTIVE-DATE*`, `DATE-ENTERED`	KeyChange		AC190, AC197, AC198

Relations

One to one (6) — lookups and parents

Relation	Table	Rules	Field map
Acbrdnhdr	ACBRDNHDR	Required	`BPX-BURDEN-CD` → `BRH-BURDEN-CD`
Acbrdnplx	ACBRDNPLX	Not Required	`BPX-BURDEN-CD` → `BPA-BURDEN-CD`, `BPX-POOL-NBR` → `BPA-POOL-NBR`
Acbrdnpool	ACBRDNPOOL	Required	`BPX-BURDEN-CD` → `BPL-BURDEN-CD`, `BPX-POOL-NBR` → `BPL-POOL-NBR`
Acbrdnprrt	ACBRDNPRRT	Required	`BPX-BURDEN-CD` → `BPR-BURDEN-CD`, `BPX-POOL-NBR` → `BPR-POOL-NBR`, `BPX-BURDEN-TYPE` → `BPR-BURDEN-TYPE`
Accmpparam	ACCMPPARAM	Required	`BPX-PARAM-NAME` → `CPM-PARAM-NAME`
Cmpute	CMPUTE	Not Required	`BPX-COMPUTE-NAME` → `CMP-COMPUTE-NAME`

ACBRDNPRRX – Activity Burden Pool Rate Dtl

About ACBRDNPRRX

Fields (9)

Indexes (2)

Relations

One to one (6) — lookups and parents

Programs

Updated by (1)

Referenced by (4)