Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ACPERCMPLX


                            ACPERCMPLX FILE

                       AC Percent Complete Detail

This file contains activity and account category percent complete information
from AC65.1 (Activity Percentage of Completion) and AC65.2 (Percent Complete
by Account Category). It includes activity, account category, amount type,
percent complete, total budget, date, cost-to-date, and
cost-to-complete.

REFERENCED BY

AC265

UPDATED BY

AC165     AC300     AC310     AC65.2    AC10.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

PEX-RECORD-TYPE        Alpha 1                                   AC165   AC65.2
Element: Record Type   This field identifies the type of
                       record defined.

                       Valid values are:
                       S = Summary
                       D = Detail

PEX-ACTIVITY           Alpha 15                                  AC165   AC65.2
Element: Activity      Required key. This is the activity for
                       the percent complete information.

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

PEX-ACCT-CATEGORY      Alpha 5                                   AC165   AC65.2
Element: Account CategoRequired key. This is the account
                       category for the percent complete
                       information.

PEX-AMOUNT-TYPE        Alpha 1                                   AC165   AC65.2
Element: Amount Type   This field indicates the type for the
                       budget: Amount or Units.
                       A = Amount
                       U = Unit

PEX-PERC-COMPLETE      Signed 7.3                                AC165   AC65.2
Element: Percent CompleThis is the percentage complete for the
                       account category.

PEX-TOTAL-BUDGET       Signed 15.2                               AC165   AC65.2
Element: Total Budget  This is the total budget for the
                       account category.

PEX-COST-TO-DATE       Signed 15.2                               AC165   AC65.2
Element: Cost-to-Date  This is the cost-to-date amount for the
                       account category.

PEX-COST-TO-CMPLT      Signed 15.2                               AC165   AC65.2
Element: Cost-to-CompleThis is the cost to complete, or the
                       amount remaining to be expended, for the
                       account category.

PEX-BUDGET-TYPE        Alpha 1                                   AC165   AC65.2
Element: Budget Type   This field indicates the budget type:
                       Amount or Units.

                         ACPERCMPLX FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

PEXSET1   RECORD-TYPE                                            AC10.1  AC165
          ACTIVITY                                               AC265   AC300
          BUDGET-TYPE                                            AC310   AC65.2
          DATE*
          ACCT-CATEGORY

PEXSET2   ACTIVITY      KeyChange                                AC310
          RECORD-TYPE
          BUDGET-TYPE
          ACCT-CATEGORY
          DATE*

                         ACPERCMPLX FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Acacctcat      ACACCTCAT    Required

                            PEX-ACCT-CATEGORY    -> AAX-ACCT-CATEGORY

Acactivity     ACACTIVITY   Required

                            PEX-ACTIVITY         -> ACV-ACTIVITY