Lawson Insight Technical Documentation |
|
ACPERCCMPL
ACPERCCMPL FILE
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 AC310 AC65.1 AC65.2 BR165
BR65.1 BR65.2 BR65.3 AC10.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PEC-RECORD-TYPE Alpha 1 AC165 AC65.1
Element: Record Type This field identifies the type of AC65.2 BR165
record defined. BR65.1 BR65.2
BR65.3
Valid values are:
S = Summary
D = Detail
P
C
PEC-ACTIVITY Alpha 15 AC165 AC65.1
Element: Activity Required key. This is the activity for AC65.2 BR165
the percent complete information. BR65.1 BR65.2
BR65.3
PEC-DATE Numeric 8 (yyyymmdd) AC165 AC65.1
Element: Date Required key. This is the date as of AC65.2 BR165
which the percentage complete was BR65.1 BR65.2
calculated. BR65.3
PEC-BUDGET-NBR Numeric 3 AC165 AC65.1
Element: Budget Number This is the budget number for the AC65.2 BR165
percent complete information. BR65.1 BR65.2
BR65.3
PEC-GROUP Alpha 15 AC165 AC65.1
Element: Group If you are using the Percent Complete BR165 BR65.1
method of revenue recognition, you can BR65.2 BR65.3
use an account category group to
determine the account categories used to
calculate total cost-to-date and total
budget.
PEC-PERC-COMPLETE Signed 7.3 AC165 AC65.1
Element: Percent CompleThis is the percentage of completion AC65.2 BR65.1
for the activity. BR65.2 BR65.3
PEC-BASE-ND Numeric 1 AC165 AC65.1
Base Number of This is the number of decimal positions AC65.2 BR165
Decimals defined for the activity group base BR65.1 BR65.2
currency. BR65.3
PEC-TOTAL-BUDGET Signed 18.2 AC165 AC65.1
Element: Total Budget This is the total budget for the AC65.2 BR165
activity. BR65.1 BR65.2
BR65.3
PEC-COST-TO-DATE Signed 18.2 AC165 AC65.1
Element: Cost-to-Date This is the cost to date for the AC65.2 BR165
activity. BR65.1 BR65.2
BR65.3
PEC-COST-TO-CMPLT Signed 18.2 AC165 AC65.1
Element: Cost-to-CompleThis is the cost to complete for the AC65.2 BR165
activity, or the cost remaining to BR65.1 BR65.2
expend the total budget. BR65.3
PEC-GROSS-MARGIN Signed 7.3 BR165 BR65.1
Element: Gross Margin This is the gross margin for the BR65.2 BR65.3
activity. Gross margin is calculated as
follows:
Gross Margin = Contract Price - Total
Budgeted Costs
PEC-CONTRACT-AMT Signed 18.2 BR65.1 BR65.2
Element: Contract AmounThis is the contract amount for the
activity.
PEC-BUDGET-TYPE Alpha 1 AC165 AC65.1
Element: Budget Type This field indicates the budget type: AC65.2 BR165
Amount or Units. BR65.1 BR65.2
A = Amount BR65.3
U = Unit
ACPERCCMPL FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PECSET1 RECORD-TYPE AC10.1 AC121
ACTIVITY AC123 AC130
BUDGET-TYPE AC165 AC20.1
DATE* AC20.2 AC20.3
AC20.4 AC20.5
AC265 AC310
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
...
PECSET2 ACTIVITY AC300 AC310
RECORD-TYPE
BUDGET-TYPE
DATE*
ACPERCCMPL FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME 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
|