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
BR120     BR130     BR265     BR530

UPDATED BY

AC165     AC300     AC310     AC65.1    AC65.2    BR65.1
BR65.2    BRCC.1    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  BR65.1
                       record defined.                           BR65.2  BRCC.1

                       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  BR65.1
                       the percent complete information.         BR65.2  BRCC.1

PEC-DATE               Numeric 8  (yyyymmdd)                     AC165   AC65.1
Element: Date          Required key. This is the date as of      AC65.2  BR65.1
                       which the percentage complete was         BR65.2  BRCC.1
                       calculated.

PEC-BUDGET-NBR         Numeric 3                                 AC165   AC65.1
Element: Budget Number This is the budget number for the         AC65.2  BR65.1
                       percent complete information.             BR65.2  BRCC.1

PEC-GROUP              Alpha 15                                  AC165   AC65.1
Element: Group         If you are using the Percent Complete     BR65.1  BRCC.1
                       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      Signed 7.3                                AC165   AC65.1
Element: Percent CompleThis is the percentage of completion      AC65.2  BR65.1
                       for the activity.                         BR65.2  BRCC.1

PEC-BASE-ND            Numeric 1                                 AC165   AC65.1
Base Number of         This is the number of decimal positions   AC65.2  BR65.1
Decimals               defined for the activity group base       BR65.2  BRCC.1
                       currency.

PEC-TOTAL-BUDGET       Signed 15.2                               AC165   AC65.1
Element: Total Budget  This is the total budget for the          AC65.2  BR65.1
                       activity.                                 BR65.2  BRCC.1

PEC-COST-TO-DATE       Signed 15.2                               AC165   AC65.1
Element: Cost-to-Date  This is the cost to date for the          AC65.2  BR65.1
                       activity.                                 BR65.2  BRCC.1

PEC-COST-TO-CMPLT      Signed 15.2                               AC165   AC65.1
Element: Cost-to-CompleThis is the cost to complete for the      AC65.2  BR65.1
                       activity, or the cost remaining to        BR65.2  BRCC.1
                       expend the total budget.

PEC-GROSS-MARGIN       Signed 7.3                                BR65.1  BR65.2
Element: Gross Margin  This is the gross margin for the          BRCC.1
                       activity. Gross margin is calculated as
                       follows:

                       Gross Margin = Contract Price - Total
                       Budgeted Costs

PEC-CONTRACT-AMT       Signed 15.2                               BR65.1  BR65.2
Element: Contract AmounThis is the contract amount for the       BRCC.1
                       activity.

PEC-BUDGET-TYPE        Alpha 1                                   AC165   AC65.1
Element: Budget Type   This field indicates the budget type:     AC65.2  BR65.1
                       Amount or Units.                          BR65.2  BRCC.1
                       A = Amount
                       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   AC300
                                                                 AC310   AC32.1
                                                                 AC37.1  AC490
                                                                 AC65.1  AC65.2
                                                                 BR120   BR130
                                                                 BR265   BR530
                                                                 BR65.1  BR65.2
                                                                 BRCC.1

PECSET2   ACTIVITY                                               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