Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ACPRDPERF


                             ACPRDPERF FILE

The ACPRDPERF file will be keyed by activity group, activity and system code.
It will store a record for each system and corresponding performance begin and
end dates.  This file will be primarily maintained by AC10.6.

REFERENCED BY

AC200     AC210     AC40.1    AC41.1    AC41.4    AC46.1
ACAC.1    BR41.1    BR43.1

UPDATED BY

AC10.6    AC10.1    AC110     AC120     AC300     AC310
AC502     AC00.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

PFM-ACTIVITY-GRP       Alpha 15                                  AC10.6  AC110
Element: Activity GroupThe activity group is the overall         AC120   AC502
                       project.

PFM-ACTIVITY           Alpha 15                                  AC10.6  AC110
Element: Activity      Activities are the processes or           AC502
                       procedures that produce work. Cost
                       objects (products, services, customers,
                       and so on) are the reasons for
                       performing the activity.


PFM-SYSTEM             Alpha 2                                   AC10.6  AC110
Element: System Code   A two-character code representing an      AC502
                       application used within the Lawson
                       system. (i.e.: GL = General Ledger, AP =
                       Accounts Payable, etc.)

PFM-SEQ-NUMBER         Numeric 6                                 AC10.6  AC110
Record Sequence        A unique number assigned to each
Number                 transaction to be interfaced into the
                       Lawson system.

PFM-UPDATE-DATE        Numeric 8  (yyyymmdd)                     AC10.6
Element: Update Date   This field contains the date the record
                       was updated.

PFM-BEGIN-DAYS         Signed 3.0                                AC10.6  AC110
Element: Begin Days    The number of days to be subtracted from  AC502
                       the begin date of the activity or
                       activity group the template is applied
                       to. This calculation will result in the
                       POP record begin date.

PFM-BEGIN-DATE         Numeric 8  (yyyymmdd)                     AC10.6  AC110
Element: Begin Date    The begin date for this effort period.    AC502

PFM-END-DAYS           Signed 3.0                                AC10.6  AC110
Element: End Days      The number of days to be added to the     AC502
                       end date of the activity or activity
                       group the template is applied to.
                       This calculation will result in the POP
                       records begin date.

PFM-END-DATE           Numeric 8  (yyyymmdd)                     AC10.6  AC110
Element: Ending Date   The end date for this effort period.      AC502

PFM-OPERATOR           Alpha 10                                  AC10.6  AC110
Element: Operator Code This field is used to store the login
                       id of the person who entered the record.


PFM-RECORD-TYPE        Alpha 1                                   AC10.6
Element: Record Type   This field identifies the type of
                       record defined.

                       Valid values are:
                       S = Summary
                       D = Detail

                         ACPRDPERF FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

PFMSET1   ACTIVITY-GRP                                           AC00.1  AC10.1
          ACTIVITY                                               AC10.6  AC110
          SYSTEM                                                 AC120   AC200
          SEQ-NUMBER                                             AC210   AC300
                                                                 AC310

PFMSET2   ACTIVITY-GRP                                           AC10.6  AC110
          ACTIVITY                                               AC40.1  AC41.1
          SYSTEM                                                 AC41.4  AC46.1
          SEQ-NUMBER*                                            AC502   ACAC.1
                                                                 BR41.1  BR43.1

                         ACPRDPERF FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Acactgrp       ACACTGRP     Required

                            PFM-ACTIVITY-GRP    -> AGP-ACTIVITY-GRP

Acactgrp1      ACACTGRP     Required
                            When PFM-RECORD-TYPE = Spaces

                            PFM-ACTIVITY-GRP    -> AGP-ACTIVITY-GRP

Acactgrp2      ACACTGRP     Required
                            When PFM-RECORD-TYPE != Spaces

                            PFM-ACTIVITY-GRP    -> AGP-ACTIVITY-GRP

Acactivity     ACACTIVITY   Required

                            PFM-ACTIVITY        -> ACV-ACTIVITY

Acactivity1    ACACTIVITY   Required
                            When PFM-RECORD-TYPE = Spaces

                            PFM-ACTIVITY        -> ACV-ACTIVITY

Acactivity2    ACACTIVITY   Required
                            When PFM-RECORD-TYPE != Spaces

                            PFM-ACTIVITY        -> ACV-ACTIVITY