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