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.
UPDATED BY
| 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 |
|
|
| PEC-ACTIVITY Element: Activity | Alpha 15 Required key. This is the activity for the percent complete information. |
|
|
| PEC-DATE Element: Date | Numeric 8 (yyyymmdd) Required key. This is the date as of which the percentage complete was calculated. |
|
|
| PEC-BUDGET-NBR Element: Budget Number | Numeric 3 This is the budget number for the percent complete information. |
|
|
| 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. |
|
|
| PEC-PERC-COMPLETE Element: Percent Complete | Signed 7.3 This is the percentage of completion for the activity. |
|
|
| PEC-BASE-ND Base Number of Decimals | Numeric 1 This is the number of decimal positions defined for the activity group base currency. |
|
|
| PEC-TOTAL-BUDGET Element: Total Budget | Signed 18.2 This is the total budget for the activity. |
|
|
| PEC-COST-TO-DATE Element: Cost-to-Date | Signed 18.2 This is the cost to date for the activity. |
|
|
| 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. |
|
|
| 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 |
|
|
| PEC-CONTRACT-AMT Element: Contract Amount | Signed 18.2 This is the contract amount for the activity. |
|
|
| PEC-BUDGET-TYPE Element: Budget Type | Alpha 1 This field indicates the budget type: Amount or Units. A = Amount U = Unit |
|
| NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| PECSET1 |
RECORD-TYPE ACTIVITY BUDGET-TYPE DATE* |
|
| ||||||||
| PECSET2 |
ACTIVITY RECORD-TYPE BUDGET-TYPE DATE* |
|
|||||||||
| RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | |||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Acpercmplx | ACPERCMPLX |
|
All trademarks and registered trademarks are the property of their
respective owners.