ACBRDNPLX – Activity Burden Pool Detail

System: Activity Management (AC)
Prefix: BPA
Primary key: BURDEN-CD, POOL-NBR
Fields: 18
Updated by: 1 program
Referenced by: 3 programs

ACBRDNPLX is the Activity Burden Pool Detail table in Lawson Activity Management (prefix BPA). It is indexed by BURDEN-CD, POOL-NBR (BPASET1). It is related 1:1 to ACBRDNHDR and ACBRDNPOOL and 1:M to ACBRDNPRRX. It is updated by AC62.1 and referenced by AC190, AC197 and AC262. The table has 18 fields, 1 index and 3 documented relations.

About ACBRDNPLX

No description in the Lawson data dictionary.

Fields (18)

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

Field / column	Type	Description & values	Updated by
`BPA-BURDEN-CD` PK BURDEN_CD	Alpha 5	—	AC62.1
`BPA-POOL-NBR` PK POOL_NBR	Numeric 3	—	AC62.1
`BPA-FR-ACTIVITY` FR_ACTIVITY	Alpha 15	Activities are the processes or procedures that produce work. Cost objects (products, services, customers, and so on) are the reasons for performing the activity.	AC62.1
`BPA-TO-ACTIVITY` TO_ACTIVITY	Alpha 15	Activities are the processes or procedures that produce work. Cost objects (products, services, customers, and so on) are the reasons for performing the activity.	AC62.1
`BPA-MATRIX-LIST` MATRIX_LIST	Alpha 12	Attribute categories are selection parameters used to build a list of objects (accounting units). Attribute categories and values are the basis of the selection and sorting. A attribute list can then be used for reporting on and processing objects.	AC62.1
`BPA-COMPANY` COMPANY	Numeric 4	Identifies the AP company if the resource type = V. Identifies the HR company if the resource type = E. It is blank for type A, P or Q resources.	AC62.1
`BPA-FR-ACCT-UNIT` FR_ACCT_UNIT	Alpha 15	The accounting unit is a shorthand notation representing the variable level number. When used in the General Ledger Account Master file, the accounting unit must be defined in the General Ledger Names file as a posting accounting unit.	AC62.1
`BPA-TO-ACCT-UNIT` TO_ACCT_UNIT	Alpha 15	The accounting unit is a shorthand notation representing the variable level number. When used in the General Ledger Account Master file, the accounting unit must be defined in the General Ledger Names file as a posting accounting unit.	AC62.1
`BPA-ACCOUNT-LIST` ACCOUNT_LIST	Alpha 12	—	AC62.1
`BPA-FR-ACCT-CAT` FR_ACCT_CAT	Alpha 5	Account 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 thru	AC62.1
`BPA-TO-ACCT-CAT` TO_ACCT_CAT	Alpha 5	Account 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 thru	AC62.1
`BPA-CAT-GROUP` CAT_GROUP	Alpha 15	—	AC62.1
`BPA-FR-JOB-CODE` FR_JOB_CODE	Alpha 9	—	AC62.1
`BPA-TO-JOB-CODE` TO_JOB_CODE	Alpha 9	—	AC62.1
`BPA-FR-EMPLOYEE` FR_EMPLOYEE	Numeric 9	—	AC62.1
`BPA-TO-EMPLOYEE` TO_EMPLOYEE	Numeric 9	—	AC62.1
`BPA-GROUP-NAME` GROUP_NAME	Alpha 10	—	AC62.1
`BPA-SALARY-CLASS` SALARY_CLASS	Alpha 1	—	AC62.1

Indexes (1)

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

Index	Keys	Flags	Condition	Used in
`BPASET1`	`BURDEN-CD`, `POOL-NBR`	Primary		AC190, AC197, AC262, AC62.1

Relations

One to one (2) — lookups and parents

Relation	Table	Rules	Condition	Field map
Acbrdnhdr	ACBRDNHDR	Required		`BPA-BURDEN-CD` → `BRH-BURDEN-CD`
Acbrdnpool	ACBRDNPOOL	Required		`BPA-BURDEN-CD` → `BPL-BURDEN-CD`, `BPA-POOL-NBR` → `BPL-POOL-NBR`

One to many (1) — child tables

Relation	Table	Rules	Condition	Field map
Acbrdnprrx	ACBRDNPRRX			`BPA-BURDEN-CD` → `BPX-BURDEN-CD`, `BPA-POOL-NBR` → `BPX-POOL-NBR`, → `BPX-BURDEN-TYPE`, → `BPX-EFFECTIVE-DATE`, → `BPX-DATE-ENTERED`

ACBRDNPLX – Activity Burden Pool Detail

About ACBRDNPLX

Fields (18)

Indexes (1)

Relations

One to one (2) — lookups and parents

One to many (1) — child tables

Programs

Updated by (1)

Referenced by (3)