ACPERCCMPL – Activity Percent Complete

System
Activity Management (AC)
Prefix
PEC
Primary key
RECORD-TYPE, ACTIVITY, BUDGET-TYPE, DATE
Fields
13
Updated by
9 programs
Referenced by
31 programs

ACPERCCMPL is the Activity Percent Complete table in Lawson Activity Management (prefix PEC). It is indexed by RECORD-TYPE, ACTIVITY, BUDGET-TYPE, DATE (PECSET1); alternate indexes: PECSET2. It is related 1:M to ACPERCMPLX. It is updated by AC10.1, AC165, AC300, AC65.1, AC65.2, BR165, BR65.1, BR65.2 and 1 more and referenced by AC121, AC123, AC130, AC20.1, AC20.2, AC20.3, AC20.4, AC20.5 and 23 more. The table has 13 fields, 2 indexes and 1 documented relation.

About ACPERCCMPL

This file contains activity percent complete information from AC65.1 (Activity Percentage of Completion) and AC65.2 (Percent Complete by Account Category). It includes activity, budget number, total budget, date, cost-to-complete, as well as gross margin, and contract amount.

Fields (13)

Column = COBOL field name without the PEC- 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
#PEC-RECORD-TYPE PK
RECORD_TYPE		Alpha 1This field identifies the type of record defined. Valid values are:
  • S Summary
  • D Detail
  • P Created in AC
  • C Created in BR
AC165, AC65.1, AC65.2, BR165, BR65.1, BR65.2, BR65.3
#PEC-ACTIVITY PK
ACTIVITY		Alpha 15Required key. This is the activity for the percent complete information.AC165, AC65.1, AC65.2, BR165, BR65.1, BR65.2, BR65.3
#PEC-DATE PK
DATE		Numeric 8 (yyyymmdd)Required key. This is the date as of which the percentage complete was calculated.AC165, AC65.1, AC65.2, BR165, BR65.1, BR65.2, BR65.3
#PEC-BUDGET-NBR
BUDGET_NBR		Numeric 3This is the budget number for the percent complete information.AC165, AC65.1, AC65.2, BR165, BR65.1, BR65.2, BR65.3
#PEC-GROUP
GROUP		Alpha 15If you are using the Percent Complete method of revenue recognition, you can use an account category group to determine the account categories used to calculate total cost-to-date and total budget.AC165, AC65.1, BR165, BR65.1, BR65.2, BR65.3
#PEC-PERC-COMPLETE
PERC_COMPLETE		Signed 7.3This is the percentage of completion for the activity.AC165, AC65.1, AC65.2, BR165, BR65.1, BR65.2, BR65.3
#PEC-BASE-ND
BASE_ND		Numeric 1This is the number of decimal positions defined for the activity group base currency.AC165, AC65.1, AC65.2, BR165, BR65.1, BR65.2, BR65.3
#PEC-TOTAL-BUDGET
TOTAL_BUDGET		Signed 18.2This is the total budget for the activity.AC165, AC65.1, AC65.2, BR165, BR65.1, BR65.2, BR65.3
#PEC-COST-TO-DATE
COST_TO_DATE		Signed 18.2This is the cost to date for the activity.AC165, AC65.1, AC65.2, BR165, BR65.1, BR65.2, BR65.3
#PEC-COST-TO-CMPLT
COST_TO_CMPLT		Signed 18.2This is the cost to complete for the activity, or the cost remaining to expend the total budget.AC165, AC65.1, AC65.2, BR165, BR65.1, BR65.2, BR65.3
#PEC-GROSS-MARGIN
GROSS_MARGIN		Signed 7.3This is the gross margin for the activity. Gross margin is calculated as follows: Budgeted Costs
  • Gross Margin Contract Price - Total
BR165, BR65.1, BR65.2, BR65.3
#PEC-CONTRACT-AMT
CONTRACT_AMT		Signed 18.2This is the contract amount for the activity.BR65.1, BR65.2
#PEC-BUDGET-TYPE PK
BUDGET_TYPE		Alpha 1This field indicates the budget type: Amount or Units.
  • A Amount
  • U Unit
AC165, AC65.1, AC65.2, BR165, BR65.1, BR65.2, BR65.3

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
PECSET1
  1. RECORD-TYPE
  2. ACTIVITY
  3. BUDGET-TYPE
  4. DATE ↓
PrimaryAC10.1, AC121, AC123, AC130, AC165, AC20.1, AC20.2, AC20.3 +22 more (list truncated in source)
PECSET2
  1. ACTIVITY
  2. RECORD-TYPE
  3. BUDGET-TYPE
  4. DATE ↓
AC300

Relations

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

One to many (1) — child tables

RelationTableRulesConditionField map
AcpercmplxACPERCMPLX
PEC-RECORD-TYPE→PEX-RECORD-TYPE
PEC-ACTIVITY→PEX-ACTIVITY
PEC-BUDGET-TYPE→PEX-BUDGET-TYPE
PEC-DATE→PEX-DATE
—→PEX-ACCT-CATEGORY

Programs

Updated by (9)

Referenced by (31)