ACPERCMPLX

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


UPDATED BY
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
AC165 AC65.2
BR165 BR65.3
PEX-ACTIVITY
Element: Activity
Alpha 15
Required key. This is the activity for the percent complete information.
AC165 AC65.2
BR165 BR65.3
PEX-DATE
Element: Date
Numeric 8 (yyyymmdd)
Required key. This is the date as of which the percentage complete was calculated.
AC165 AC65.2
BR165 BR65.3
PEX-ACCT-CATEGORY
Element: Account Category
Alpha 5
Required key. This is the account category for the percent complete information.
AC165 AC65.2
BR165 BR65.3
PEX-AMOUNT-TYPE
Element: Amount Type
Alpha 1
This field indicates the type for the budget: Amount or Units.
A = Amount
U = Unit
AC165 AC65.2
BR165 BR65.3
PEX-PERC-COMPLETE
Element: Percent Complete
Signed 7.3
This is the percentage complete for the account category.
AC165 AC65.2
BR165 BR65.3
PEX-TOTAL-BUDGET
Element: Total Budget
Signed 18.2
This is the total budget for the account category.
AC165 AC65.2
BR165 BR65.3
PEX-COST-TO-DATE
Element: Cost-to-Date
Signed 18.2
This is the cost-to-date amount for the account category.
AC165 AC65.2
BR165 BR65.3
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.
AC165 AC65.2
BR165 BR65.3
PEX-BUDGET-TYPE
Element: Budget Type
Alpha 1
This field indicates the budget type: Amount or Units.
AC165 AC65.2
BR165 BR65.3
PEX-GROSS-MARGIN
Element: Gross Margin
Signed 7.3
BR165 BR65.3


ACPERCMPLX FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PEXSET1 RECORD-TYPE
ACTIVITY
BUDGET-TYPE
DATE*
ACCT-CATEGORY
AC10.1 AC165
AC265 AC65.2
BR130 BR165
BR265 BR530
BR65.3
PEXSET2 ACTIVITY
RECORD-TYPE
BUDGET-TYPE
ACCT-CATEGORY
DATE*
KeyChange
AC300


ACPERCMPLX FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Acacctcat ACACCTCAT Required
PEX-ACCT-CATEGORY->AAX-ACCT-CATEGORY
Acactivity ACACTIVITY Required
PEX-ACTIVITY->ACV-ACTIVITY


File created: Thu Jun 09 02:03:11 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.