ACPERCCMPL FILE
Activity Percent Complete
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.
REFERENCED BY
AC121 AC123 AC130 AC20.1 AC20.2 AC20.3
AC20.4 AC20.5 AC265 AC30.2 AC30.3 AC32.1
AC490 BR120 BR265
UPDATED BY
AC165 AC300 AC310 AC65.1 AC65.2 BR65.1
BR65.2 BRCC.1 AC10.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PEC-RECORD-TYPE Alpha 1 AC165 AC65.1
Record Type This field identifies the type of AC65.2 BR65.1
record defined. BR65.2 BRCC.1
Valid values are:
S = Summary
D = Detail
P
C
PEC-ACTIVITY Alpha 15 AC165 AC65.1
Activity Required key. This is the activity for AC65.2 BR65.1
the percent complete information. BR65.2 BRCC.1
PEC-DATE Numeric 8 (yyyymmdd) AC165 AC65.1
Date Required key. This is the date as of AC65.2 BR65.1
which the percentage complete was BR65.2 BRCC.1
calculated.
PEC-BUDGET-NBR Numeric 3 AC165 AC65.1
Budget Number This is the budget number for the AC65.2 BR65.1
percent complete information. BR65.2 BRCC.1
PEC-GROUP Alpha 15 AC165 AC65.1
Group If you are using the Percent Complete BR65.1 BRCC.1
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.
PEC-PERC-COMPLETE Signed 7.3 AC165 AC65.1
Percent Complete This is the percentage of completion AC65.2 BR65.1
for the activity. BR65.2 BRCC.1
PEC-BASE-ND Numeric 1 AC165 AC65.1
Base Number of This is the number of decimal positions AC65.2 BR65.1
Decimals defined for the activity group base BR65.2 BRCC.1
currency.
PEC-TOTAL-BUDGET Signed 15.2 AC165 AC65.1
Total Budget This is the total budget for the AC65.2 BR65.1
activity. BR65.2 BRCC.1
PEC-COST-TO-DATE Signed 15.2 AC165 AC65.1
Cost-to-Date This is the cost to date for the AC65.2 BR65.1
activity. BR65.2 BRCC.1
PEC-COST-TO-CMPLT Signed 15.2 AC165 AC65.1
Cost-to-Complete This is the cost to complete for the AC65.2 BR65.1
activity, or the cost remaining to BR65.2 BRCC.1
expend the total budget.
PEC-GROSS-MARGIN Signed 7.3 BR65.1 BR65.2
Gross Margin This is the gross margin for the BRCC.1
activity. Gross margin is calculated as
follows:
Gross Margin = Contract Price - Total
Budgeted Costs
PEC-CONTRACT-AMT Signed 15.2 BR65.1 BR65.2
Contract Amount This is the contract amount for the BRCC.1
activity.
PEC-BUDGET-TYPE Alpha 1 AC165 AC65.1
Budget Type This field indicates the budget type: AC65.2 BR65.1
Amount or Units. BR65.2 BRCC.1
A = Amount
U = Unit
ACPERCCMPL FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PECSET1 RECORD-TYPE AC10.1 AC121
ACTIVITY AC123 AC130
BUDGET-TYPE AC165 AC20.1
DATE* AC20.2 AC20.3
AC20.4 AC20.5
AC265 AC30.2
AC30.3 AC300
AC310 AC32.1
AC490 AC65.1
AC65.2 BR120
BR265 BR65.1
BR65.2 BRCC.1
PECSET2 ACTIVITY AC310
RECORD-TYPE
BUDGET-TYPE
DATE*
ACPERCCMPL FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Acpercmplx ACPERCMPLX
PEC-RECORD-TYPE -> PEX-RECORD-TYPE
PEC-ACTIVITY -> PEX-ACTIVITY
PEC-BUDGET-TYPE -> PEX-BUDGET-TYPE
PEC-DATE -> PEX-DATE
PEX-ACCT-CATEGORY
|
