|
|
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
AC50.2 ACAC.1 BR40.3 BR41.1 BR43.1
UPDATED BY
AC10.6 AC10.1 AC110 AC120 AC19.1 AC300
AC310 AC502 AC560 AC00.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PFM-ACTIVITY-GRP Alpha 15 AC10.6 AC110
Element: Activity Grp The activity group is the overall AC120 AC19.1
project. AC502 AC560
PFM-ACTIVITY Alpha 15 AC10.6 AC110
Element: Activity Activities are the processes or AC19.1 AC502
procedures that produce work. Cost AC560
objects (products, services, customers,
and so on) are the reasons for
performing the activity.
PFM-SYSTEM Alpha 2 AC10.6 AC110
Element: System A two-character code representing an AC19.1 AC502
application used within the Lawson AC560
system. (i.e.: GL = General Ledger, AP =
Accounts Payable, etc.)
PFM-SEQ-NUMBER Numeric 6 AC10.6 AC110
Element: Seq Number A unique number assigned to each AC19.1 AC502
transaction to be interfaced into the AC560
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 AC19.1 AC502
from the begin date of the activity or AC560
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. AC19.1 AC502
AC560
PFM-END-DAYS Signed 3.0 AC10.6 AC110
Element: End Days The number of days to be added to the AC19.1 AC502
end date of the activity or activity AC560
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: End Date The end date for this effort period. AC19.1 AC502
AC560
PFM-OPERATOR Alpha 10 AC10.6 AC110
Element: Operator This field is used to store the login AC19.1 AC560
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 AC560
PFMSET2 ACTIVITY-GRP AC10.6 AC110
ACTIVITY AC40.1 AC41.1
SYSTEM AC41.4 AC46.1
SEQ-NUMBER* AC50.2 AC502
ACAC.1 BR40.3
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
|
