Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

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