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