|
|
ACPERCMPLX FILE
AC Percent Complete Detail
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.
REFERENCED BY
AC265 BR130 BR265 BR530
UPDATED BY
AC165 AC300 AC310 AC65.2 BR165 BR65.3
AC10.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PEX-RECORD-TYPE Alpha 1 AC165 AC65.2
Element: Record Type This field identifies the type of BR165 BR65.3
record defined.
Valid values are:
S = Summary
D = Detail
PEX-ACTIVITY Alpha 15 AC165 AC65.2
Element: Activity Required key. This is the activity for BR165 BR65.3
the percent complete information.
PEX-DATE Numeric 8 (yyyymmdd) AC165 AC65.2
Element: Date Required key. This is the date as of BR165 BR65.3
which the percentage complete was
calculated.
PEX-ACCT-CATEGORY Alpha 5 AC165 AC65.2
Element: Account CategoRequired key. This is the account BR165 BR65.3
category for the percent complete
information.
PEX-AMOUNT-TYPE Alpha 1 AC165 AC65.2
Element: Amount Type This field indicates the type for the BR165 BR65.3
budget: Amount or Units.
A = Amount
U = Unit
PEX-PERC-COMPLETE Signed 7.3 AC165 AC65.2
Element: Percent CompleThis is the percentage complete for the BR165 BR65.3
account category.
PEX-TOTAL-BUDGET Signed 18.2 AC165 AC65.2
Element: Total Budget This is the total budget for the BR165 BR65.3
account category.
PEX-COST-TO-DATE Signed 18.2 AC165 AC65.2
Element: Cost-to-Date This is the cost-to-date amount for the BR165 BR65.3
account category.
PEX-COST-TO-CMPLT Signed 18.2 AC165 AC65.2
Element: Cost-to-CompleThis is the cost to complete, or the BR165 BR65.3
amount remaining to be expended, for the
account category.
PEX-BUDGET-TYPE Alpha 1 AC165 AC65.2
Element: Budget Type This field indicates the budget type: BR165 BR65.3
Amount or Units.
PEX-GROSS-MARGIN Signed 7.3 BR165 BR65.3
Element: Gross Margin
ACPERCMPLX FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PEXSET1 RECORD-TYPE AC10.1 AC165
ACTIVITY AC265 AC310
BUDGET-TYPE AC65.2 BR130
DATE* BR165 BR265
ACCT-CATEGORY BR530 BR65.3
PEXSET2 ACTIVITY KeyChange AC300 AC310
RECORD-TYPE
BUDGET-TYPE
ACCT-CATEGORY
DATE*
ACPERCMPLX FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Acacctcat ACACCTCAT Required
PEX-ACCT-CATEGORY -> AAX-ACCT-CATEGORY
Acactivity ACACTIVITY Required
PEX-ACTIVITY -> ACV-ACTIVITY
|
