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	AC32.1	AC37.1	AC490
BR02.3	BR120	BR121	BR122	BR123	BR130
BR140	BR151	BR152	BR156	BR20.1	BR20.2
BR20.3	BR20.4	BR20.5	BR265	BR420	BR521
BR530

UPDATED BY

AC165	AC300	AC65.1	AC65.2	BR165	BR65.1
BR65.2	BR65.3	AC10.1

FIELD NAME	DESCRIPTION/VALID VALUES	UPDATED BY
PEC-RECORD-TYPE Element: Record Type	Alpha 1 This field identifies the type of record defined. Valid values are: S = Summary D = Detail P = Created in AC C = Created in BR	AC165 AC65.1 AC65.2 BR165 BR65.1 BR65.2 BR65.3
PEC-ACTIVITY Element: Activity	Alpha 15 Required key. This is the activity for the percent complete information.	AC165 AC65.1 AC65.2 BR165 BR65.1 BR65.2 BR65.3
PEC-DATE Element: Date	Numeric 8 (yyyymmdd) Required key. This is the date as of which the percentage complete was calculated.	AC165 AC65.1 AC65.2 BR165 BR65.1 BR65.2 BR65.3
PEC-BUDGET-NBR Element: Budget Number	Numeric 3 This is the budget number for the percent complete information.	AC165 AC65.1 AC65.2 BR165 BR65.1 BR65.2 BR65.3
PEC-GROUP Element: Group	Alpha 15 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.	AC165 AC65.1 BR165 BR65.1 BR65.2 BR65.3
PEC-PERC-COMPLETE Element: Percent Complete	Signed 7.3 This is the percentage of completion for the activity.	AC165 AC65.1 AC65.2 BR165 BR65.1 BR65.2 BR65.3
PEC-BASE-ND Base Number of Decimals	Numeric 1 This is the number of decimal positions defined for the activity group base currency.	AC165 AC65.1 AC65.2 BR165 BR65.1 BR65.2 BR65.3
PEC-TOTAL-BUDGET Element: Total Budget	Signed 18.2 This is the total budget for the activity.	AC165 AC65.1 AC65.2 BR165 BR65.1 BR65.2 BR65.3
PEC-COST-TO-DATE Element: Cost-to-Date	Signed 18.2 This is the cost to date for the activity.	AC165 AC65.1 AC65.2 BR165 BR65.1 BR65.2 BR65.3
PEC-COST-TO-CMPLT Element: Cost-to-Complete	Signed 18.2 This is the cost to complete for the activity, or the cost remaining to expend the total budget.	AC165 AC65.1 AC65.2 BR165 BR65.1 BR65.2 BR65.3
PEC-GROSS-MARGIN Element: Gross Margin	Signed 7.3 This is the gross margin for the activity. Gross margin is calculated as follows: Gross Margin = Contract Price - Total Budgeted Costs	BR165 BR65.1 BR65.2 BR65.3
PEC-CONTRACT-AMT Element: Contract Amount	Signed 18.2 This is the contract amount for the activity.	BR65.1 BR65.2
PEC-BUDGET-TYPE Element: Budget Type	Alpha 1 This field indicates the budget type: Amount or Units. A = Amount U = Unit	AC165 AC65.1 AC65.2 BR165 BR65.1 BR65.2 BR65.3

ACPERCCMPL FILE INDEX

ACPERCCMPL FILE RELATIONS

ONE TO MANY RELATIONS

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