ACPERCMPLX – Activity Percent Complete Dtl

System: Activity Management (AC)
Prefix: PEX
Primary key: RECORD-TYPE, ACTIVITY, BUDGET-TYPE, DATE, ACCT-CATEGORY
Fields: 11
Updated by: 6 programs
Referenced by: 4 programs

ACPERCMPLX is the Activity Percent Complete Dtl table in Lawson Activity Management (prefix PEX). It is indexed by RECORD-TYPE, ACTIVITY, BUDGET-TYPE, DATE, ACCT-CATEGORY (PEXSET1); alternate indexes: PEXSET2. It is related 1:1 to ACACCTCAT and ACACTIVITY. It is updated by AC10.1, AC165, AC300, AC65.2, BR165 and BR65.3 and referenced by AC265, BR130, BR265 and BR530. The table has 11 fields, 2 indexes and 2 documented relations.

About ACPERCMPLX

This file contains activity and account category percent complete information from AC65.1 (Activity Percentage of Completion) and AC65.2 (Percent Complete by Account Category). It includes activity, account category, amount type, percent complete, total budget, date, cost-to-date, and cost-to-complete.

Fields (11)

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

Field / column	Type	Description & values	Updated by
`PEX-RECORD-TYPE` PK RECORD_TYPE	Alpha 1	This field identifies the type of record defined. Valid values are: `S` Summary `D` Detail	AC165, AC65.2, BR165, BR65.3
`PEX-ACTIVITY` PK ACTIVITY	Alpha 15	Required key. This is the activity for the percent complete information.	AC165, AC65.2, BR165, BR65.3
`PEX-DATE` PK DATE	Numeric 8 (yyyymmdd)	Required key. This is the date as of which the percentage complete was calculated.	AC165, AC65.2, BR165, BR65.3
`PEX-ACCT-CATEGORY` PK ACCT_CATEGORY	Alpha 5	Required key. This is the account category for the percent complete information.	AC165, AC65.2, BR165, BR65.3
`PEX-AMOUNT-TYPE` AMOUNT_TYPE	Alpha 1	This field indicates the type for the budget: Amount or Units. `A` Amount `U` Unit	AC165, AC65.2, BR165, BR65.3
`PEX-PERC-COMPLETE` PERC_COMPLETE	Signed 7.3	This is the percentage complete for the account category.	AC165, AC65.2, BR165, BR65.3
`PEX-TOTAL-BUDGET` TOTAL_BUDGET	Signed 18.2	This is the total budget for the account category.	AC165, AC65.2, BR165, BR65.3
`PEX-COST-TO-DATE` COST_TO_DATE	Signed 18.2	This is the cost-to-date amount for the account category.	AC165, AC65.2, BR165, BR65.3
`PEX-COST-TO-CMPLT` COST_TO_CMPLT	Signed 18.2	This is the cost to complete, or the amount remaining to be expended, for the account category.	AC165, AC65.2, BR165, BR65.3
`PEX-BUDGET-TYPE` PK BUDGET_TYPE	Alpha 1	This field indicates the budget type: Amount or Units.	AC165, AC65.2, BR165, BR65.3
`PEX-GROSS-MARGIN` GROSS_MARGIN	Signed 7.3	—	BR165, BR65.3

Indexes (2)

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
`PEXSET1`	`RECORD-TYPE`, `ACTIVITY`, `BUDGET-TYPE`, `DATE*`, `ACCT-CATEGORY`	Primary		AC10.1, AC165, AC265, AC65.2, BR130, BR165, BR265, BR530 +1 more
`PEXSET2`	`ACTIVITY`, `RECORD-TYPE`, `BUDGET-TYPE`, `ACCT-CATEGORY`, `DATE*`	KeyChange		AC300

Relations

One to one (2) — lookups and parents

Relation	Table	Rules	Condition	Field map
Acacctcat	ACACCTCAT	Required		`PEX-ACCT-CATEGORY` → `AAX-ACCT-CATEGORY`
Acactivity	ACACTIVITY	Required		`PEX-ACTIVITY` → `ACV-ACTIVITY`

Programs

Updated by (6)

AC10.1 Activity
AC165 Percent Complete Calculation
AC300 Activity Group Purge
AC65.2 Percent Complete by Account Category
BR165 Percent Complete Calculation
BR65.3 Percent Complete by Account Category

Referenced by (4)

AC265 Percent Complete Report
BR130 Revenue Calculation
BR265 Percent of Completion Report
BR530 Revenue Import