ACPERCCMPL

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
BR265


UPDATED BY
AC10.1 AC121 AC123 AC130 AC165 AC20.1
AC20.2 AC20.3 AC20.4 AC20.5 AC265 AC300
AC32.1 AC37.1 AC490 AC65.1 AC65.2 BR02.3
BR120 BR121 BR122 BR123 BR130 BR140
BR151 BR152 BR156 BR165 BR20.1 BR20.2
BR20.3 BR20.4 BR20.5 BR420 BR521 BR530
BR65.1 BR65.2 BR65.3

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

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PECSET1 RECORD-TYPE
ACTIVITY
BUDGET-TYPE
DATE*
...
AC10.1 AC121
AC123 AC130
AC165 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC265 AC32.1
AC37.1 AC490
AC65.1 AC65.2
BR02.3 BR120
BR121 BR122
BR123 BR130
BR140 BR151
BR152 BR156
BR165 BR20.1
BR20.2 BR20.3
PECSET2 ACTIVITY
RECORD-TYPE
BUDGET-TYPE
DATE*
AC300


ACPERCCMPL FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Acpercmplx ACPERCMPLX
PEC-RECORD-TYPE->PEX-RECORD-TYPE
PEC-ACTIVITY->PEX-ACTIVITY
PEC-BUDGET-TYPE->PEX-BUDGET-TYPE
PEC-DATE->PEX-DATE
  PEX-ACCT-CATEGORY


File created: Thu Jun 09 11:04:12 2016

Home
Contact Us



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