ACBRDNBLRT – Activity Burden Billing Rate

System
Activity Management (AC)
Prefix
BRT
Primary key
ACTIVITY, BURDEN-CD, BURDEN-TYPE
Fields
3
Updated by
2 programs
Referenced by
1 program

ACBRDNBLRT is the Activity Burden Billing Rate table in Lawson Activity Management (prefix BRT). It is indexed by ACTIVITY, BURDEN-CD, BURDEN-TYPE (BRTSET1). It is related 1:1 to ACBRDNHDR and 1:M to ACBRDNBLRX. It is updated by AC300 and BR04.1 and referenced by AC64.1. The table has 3 fields, 1 index and 2 documented relations.

About ACBRDNBLRT

No description in the Lawson data dictionary.

Fields (3)

Column = COBOL field name without the BRT- 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
#BRT-ACTIVITY PK
ACTIVITY		Alpha 15Activities are the processes or procedures that produce work. Cost objects (products, services, customers, and so on) are the reasons for performing the activity.BR04.1
#BRT-BURDEN-CD PK
BURDEN_CD		Alpha 5—BR04.1
#BRT-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.BR04.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
BRTSET1
  1. ACTIVITY
  2. BURDEN-CD
  3. BURDEN-TYPE
PrimaryAC300, AC64.1, BR04.1

Relations

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

One to one (1) — lookups and parents

RelationTableRulesConditionField map
AcbrdnhdrACBRDNHDRRequired
BRT-BURDEN-CD→BRH-BURDEN-CD

One to many (1) — child tables

RelationTableRulesConditionField map
AcbrdnblrxACBRDNBLRX
BRT-ACTIVITY→BRX-ACTIVITY
BRT-BURDEN-CD→BRX-BURDEN-CD
BRT-BURDEN-TYPE→BRX-BURDEN-TYPE
—→BRX-POOL-NBR
—→BRX-EFFECTIVE-DATE

Programs

Updated by (2)

Referenced by (1)