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