ACBRDNHDR – Burden Codes

System
Activity Management (AC)
Prefix
BRH
Primary key
BURDEN-CD
Fields
16
Updated by
1 program
Referenced by
13 programs

ACBRDNHDR is the Burden Codes table in Lawson Activity Management (prefix BRH). It is indexed by BURDEN-CD (BRHSET1); alternate indexes: BRHSET2. It is related 1:M to ACBRDNBLRX and ACBRDNDTL. It is updated by AC60.1 and referenced by AC105, AC190, AC197, AC198, AC260, AC261, AC262, AC263 and 5 more. The table has 16 fields, 2 indexes and 2 documented relations.

About ACBRDNHDR

No description in the Lawson data dictionary.

Fields (16)

Column = COBOL field name without the BRH- 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
#BRH-BURDEN-CD PK
BURDEN_CD
Alpha 5—AC60.1
#BRH-DESCRIPTION
DESCRIPTION
Alpha 30 (Lower Case)This field displays the description.AC60.1
#BRH-STEP
STEP
Numeric 3This field determines when an allocation detail line will get processed. All lower steps are processed before processing higher steps.AC60.1
#BRH-DRIVER-TYPE
DRIVER_TYPE
Numeric 2—
  • 01 Company and work acct unit
  • 02 Company and home acct unit
  • 03 Activity company acct unit
  • 04 Activity
  • 05 Account category
  • 06 Job code
  • 07 Salary class
  • 08 Employee
AC60.1
#BRH-VARIATION
VARIATION
Alpha 1—
  • A Applies only to Burden
  • S Stand Alone Burden
AC60.1
#BRH-VAR-BURDEN-CD SET2
VAR_BURDEN_CD
Alpha 5—AC60.1
#BRH-POST-TO-CAT
POST_TO_CAT
Alpha 5—AC60.1
#BRH-OFF-ACTIVITY
OFF_ACTIVITY
Alpha 15—AC60.1
#BRH-OFF-ACCT-CAT
OFF_ACCT_CAT
Alpha 5—AC60.1
#BRH-OFF-GL-CD
OFF_GL_CD
Alpha 4—AC60.1
#BRH-OFF-ACCOUNT
OFF_ACCOUNT
Numeric 6This field along with the accounting unit and subaccount make up the location (account) where amounts and other account information is stored.AC60.1
#BRH-OFF-SUB-ACCT
OFF_SUB_ACCT
Numeric 4This field contains the subaccount from your general ledger chart of accounts that was charged with the amount carried on this record.AC60.1
#BRH-PT-GL-CD
PT_GL_CD
Alpha 4—AC60.1
#BRH-PT-ACCOUNT
PT_ACCOUNT
Numeric 6This field along with the accounting unit and subaccount make up the location (account) where amounts and other account information is stored.AC60.1
#BRH-PT-SUB-ACCT
PT_SUB_ACCT
Numeric 4This field contains the subaccount from your general ledger chart of accounts that was charged with the amount carried on this record.AC60.1
#BRH-OFF-DFLT
OFF_DFLT
Alpha 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
BRHSET1
  1. BURDEN-CD
PrimaryAC105, AC190, AC197, AC198, AC260, AC261, AC262, AC263 +6 more
BRHSET2
  1. VAR-BURDEN-CD
  2. BURDEN-CD
KeyChangeAC60.1

Relations

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

One to many (2) — child tables

RelationTableRulesConditionField map
AcbrdnblrxACBRDNBLRX
BRH-BURDEN-CD→BRX-BURDEN-CD
—→BRX-BURDEN-TYPE
—→BRX-POOL-NBR
—→BRX-ACTIVITY
—→BRX-EFFECTIVE-DATE
AcbrdndtlACBRDNDTL
BRH-BURDEN-CD→BRD-BURDEN-CD
—→BRD-POOL-NBR
—→BRD-ACTIVITY-GRP
—→BRD-ACTIVITY
—→BRD-ACCT-CATEGORY

Programs

Updated by (1)

Referenced by (13)