ACBRDNBLRX – Activity Brdn Billing Rate Dtl

System
AC Billing Revenue (BR)
Prefix
BRX
Primary key
ACTIVITY, BURDEN-CD, BURDEN-TYPE, POOL-NBR, EFFECTIVE-DATE
Fields
7
Updated by
2 programs
Referenced by
5 programs

ACBRDNBLRX is the Activity Brdn Billing Rate Dtl table in Lawson AC Billing Revenue (prefix BRX). It is indexed by ACTIVITY, BURDEN-CD, BURDEN-TYPE, POOL-NBR, EFFECTIVE-DATE (BRXSET1); alternate indexes: BRXSET2 and BRXSET3. It is related 1:1 to ACACTIVITY, ACBRDNBLRT, ACBRDNHDR and ACBRDNPOOL. It is updated by AC300 and BR04.1 and referenced by AC190, AC197, AC198, AC62.1 and BR204. The table has 7 fields, 3 indexes and 4 documented relations.

About ACBRDNBLRX

This file contains burden bill rate information from the Burden Bill Rate (BR04.1). It includes the burdon code, type, pool number, effective date, rate and a fixed or ceiling flag for an activity. Burdens are additional costs that are assigned to transactions such as fringe, and G&A expenses. Burden transactions are created as separate activity transactions when AC190 (Activity Posting) is run. Burdens can be thought of as line level allocations required for Gov't Contracting and Grant Management industries. Specifically, this table maintains the billing rates for burden transactions.

Fields (7)

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

Field / columnTypeDescription & valuesUpdated by
BRX-ACTIVITY PK
ACTIVITY		Alpha 15The activity associated with the burden rate being established in Burden Bill Rates (BR04.1). The activity is created on Activity (AC10.1).BR04.1
BRX-BURDEN-CD PK
BURDEN_CD		Alpha 5The burden code identifies the burden cost being calculated. The Burden Code is maintained on Burden Codes (AC60.1) and associated to an activity in Burden Bill Rates (BR04.1).BR04.1
BRX-EFFECTIVE-DATE PK
EFFECTIVE_DATE		Numeric 8 (yyyymmdd)The date the burden code pool number rate will be in effect. The effective date is maintained in Burden Bill Rate (BR04.1) by pool number for an activity and burden code.BR04.1
BRX-POOL-NBR PK
POOL_NBR		Numeric 3The pool number associated with the burden code maintained in Pool Driver Values (AC62.1).BR04.1
BRX-BILL-BRDN-RATE
BILL_BRDN_RATE		Signed 13.4The rate associated with the pool number and effective date for a activity and burden code. The rate is maintained in Burden Bill Rates (BR04.1).BR04.1
BRX-CEILING-FL
CEILING_FL		Alpha 1The Ceiling Flag determines if the rate is a fixed rate or a ceiling rate. The flag is maintained in Burden Bill Rates (BR04.1). The values are: If the value is Ceiling, the burden routine will use the lower of the cost rate defined on Burden Pool Rates(AC63.1) or the rate defined on Burden Bill Rates (BR04.1). If the value is Fixed, the burden routine will use the rate defined on Burden Bill Rates (BR04.1).
  • F Fixed Bill Rate
  • C Ceiling
BR04.1
BRX-BURDEN-TYPE PK
BURDEN_TYPE		Alpha 1Burden type specifies the type of calculation that is used to determine the total cost associated with a specific burden. The type is maintained on Burden Bill Rates (BR04.1) The values are:
  • B Billing
  • R Revenue
BR04.1

Indexes (3)

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

IndexKeysFlagsConditionUsed in
BRXSET1ACTIVITY, BURDEN-CD, BURDEN-TYPE, POOL-NBR, EFFECTIVE-DATEPrimaryAC300, BR04.1, BR204
BRXSET2ACTIVITY, BURDEN-CD, BURDEN-TYPE, POOL-NBR, EFFECTIVE-DATE*AC190, AC197, AC198
BRXSET3BURDEN-CD, BURDEN-TYPE, POOL-NBR, ACTIVITY, EFFECTIVE-DATEAC62.1

Relations

One to one (4) — lookups and parents

RelationTableRulesConditionField map
AcactivityACACTIVITYRequiredBRX-ACTIVITY → ACV-ACTIVITY
AcbrdnblrtACBRDNBLRTRequiredBRX-ACTIVITY → BRT-ACTIVITY, BRX-BURDEN-CD → BRT-BURDEN-CD, BRX-BURDEN-TYPE → BRT-BURDEN-TYPE
AcbrdnhdrACBRDNHDRRequiredBRX-BURDEN-CD → BRH-BURDEN-CD
AcbrdnpoolACBRDNPOOLRequiredBRX-BURDEN-CD → BPL-BURDEN-CD, BRX-POOL-NBR → BPL-POOL-NBR

Programs

Updated by (2)

Referenced by (5)