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

Field / columnTypeDescription & valuesUpdated 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 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
#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 12The 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 SET2
ACTIVE_STATUS		Alpha 1The status of the account. If Inactive, no posting can be done to the account.
  • A Active
  • I Inactive
AC63.1

Indexes (2)

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
BPXSET1
  1. BURDEN-CD
  2. POOL-NBR
  3. BURDEN-TYPE
  4. EFFECTIVE-DATE
  5. DATE-ENTERED
PrimaryAC263, AC63.1
BPXSET2
  1. BURDEN-CD
  2. POOL-NBR
  3. BURDEN-TYPE
  4. ACTIVE-STATUS
  5. EFFECTIVE-DATE ↓
  6. DATE-ENTERED
KeyChangeAC190, AC197, AC198

Relations

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

One to one (6) — lookups and parents

RelationTableRulesConditionField map
AcbrdnhdrACBRDNHDRRequired
BPX-BURDEN-CD→BRH-BURDEN-CD
AcbrdnplxACBRDNPLXNot Required
BPX-BURDEN-CD→BPA-BURDEN-CD
BPX-POOL-NBR→BPA-POOL-NBR
AcbrdnpoolACBRDNPOOLRequired
BPX-BURDEN-CD→BPL-BURDEN-CD
BPX-POOL-NBR→BPL-POOL-NBR
AcbrdnprrtACBRDNPRRTRequired
BPX-BURDEN-CD→BPR-BURDEN-CD
BPX-POOL-NBR→BPR-POOL-NBR
BPX-BURDEN-TYPE→BPR-BURDEN-TYPE
AccmpparamACCMPPARAMRequired
BPX-PARAM-NAME→CPM-PARAM-NAME
CmputeCMPUTENot Required
BPX-COMPUTE-NAME→CMP-COMPUTE-NAME

Programs

Updated by (1)

Referenced by (4)