ACBRDNDTL – Burden Codes Assignment

System
Activity Management (AC)
Prefix
BRD
Primary key
ACTIVITY-GRP, ACTIVITY, ACCT-CATEGORY, BURDEN-CD, POOL-NBR
Fields
5
Updated by
7 programs
Referenced by
6 programs

ACBRDNDTL is the Burden Codes Assignment table in Lawson Activity Management (prefix BRD). It is indexed by ACTIVITY-GRP, ACTIVITY, ACCT-CATEGORY, BURDEN-CD, POOL-NBR (BRDSET1); alternate indexes: BRDSET2. It is related 1:1 to ACACCTCAT, ACACCTCATX, ACACTGRP, ACACTIVITY, ACBRDNHDR and ACBRDNPOOL. It is updated by AC00.1, AC10.1, AC105, AC110, AC120, AC300 and AC61.1 and referenced by AC190, AC197, AC261, AC60.1, AC62.1 and BR04.1. The table has 5 fields, 2 indexes and 6 documented relations.

About ACBRDNDTL

No description in the Lawson data dictionary.

Fields (5)

Column = COBOL field name without the BRD- 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
#BRD-ACTIVITY-GRP PK
ACTIVITY_GRP		Alpha 15The activity group is the overall project.AC105, AC110, AC120, AC61.1
#BRD-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.AC105, AC110, AC120, AC61.1
#BRD-ACCT-CATEGORY PK
ACCT_CATEGORY		Alpha 5Account categories are groupings of costs, revenues, or a combination of both used for reporting and inquiries for activities in the Activity Management system. All transactions are posted to an account category within an activity. You can assign a specific General Ledger account or range of accounts (company, accounting unit, account, and subaccount) that make up the transactions posted to an account category using AC07.1 (Account Assignment). Period-to-date, year-to-date, and life-to-date balances are maintained by account category for activities. Account categories must be assigned to activities before you do any budgeting or transaction processing. Valid account category types are: cost revenue accrual pass thruAC105, AC61.1
#BRD-BURDEN-CD PK
BURDEN_CD		Alpha 5—AC105, AC61.1
#BRD-POOL-NBR PK
POOL_NBR		Numeric 3—AC105, AC61.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
BRDSET1
  1. ACTIVITY-GRP
  2. ACTIVITY
  3. ACCT-CATEGORY
  4. BURDEN-CD
  5. POOL-NBR
PrimaryAC00.1, AC10.1, AC105, AC110, AC120, AC190, AC197, AC261 +3 more
BRDSET2
  1. BURDEN-CD
  2. POOL-NBR
  3. ACTIVITY-GRP
  4. ACTIVITY
  5. ACCT-CATEGORY
AC60.1, AC62.1

Relations

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

One to one (6) — lookups and parents

RelationTableRulesConditionField map
AcacctcatACACCTCATRequired
BRD-ACCT-CATEGORY→AAX-ACCT-CATEGORY
AcacctcatxACACCTCATXRequired
BRD-ACTIVITY-GRP→AXX-ACTIVITY-GRP
BRD-ACTIVITY→AXX-ACTIVITY
BRD-ACCT-CATEGORY→AXX-ACCT-CATEGORY
AcactgrpACACTGRPRequired
BRD-ACTIVITY-GRP→AGP-ACTIVITY-GRP
AcactivityACACTIVITYRequired
BRD-ACTIVITY→ACV-ACTIVITY
AcbrdnhdrACBRDNHDRRequired
BRD-BURDEN-CD→BRH-BURDEN-CD
AcbrdnpoolACBRDNPOOLRequired
BRD-BURDEN-CD→BPL-BURDEN-CD
BRD-POOL-NBR→BPL-POOL-NBR

Programs

Updated by (7)

Referenced by (6)