ACPRDPERF

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
AC00.1


UPDATED BY
AC10.1 AC10.6 AC110 AC120 AC130 AC131
AC19.1 AC200 AC210 AC300 AC40.1 AC41.1
AC41.4 AC46.1 AC50.2 AC502 AC560 ACAC.1
AP125 AP126 AP131 AP20.1 AP20.2 AP20.3
AP20.4 AP20.5 AP20.7 AP21.1 AP23.1 AP25.1
AP25.2 AP26.1 AP27.1 AP30.4 API1.1 API2.1
BR40.3 BR41.1 BR43.1 CX100 CX20.1 CX20.2
CX20.4 CX20.5 CX220 CX30.1 CX300 CX506
CXCP.1 DR100 IC140 IC66.1 IC83.1 MA180
MA41.1 MA41.2 MA41.4 MA41.7 MA42.2 MA43.2
MA43.7 MA44.1 MA44.2 MA530 MA531 MA60.2
MA60.3 MA60.5 MA61.1 MA66.2 MA67.2 MA67.3
MA68.2 MA68.3 MA68.5 MA70.1 MA75.1 MA80.1
MAI1.1 PD10.1 PD10.2 PD130 PD20.1 PD20.2
PD20.3 PO100 PO101 PO122 PO131 PO136
PO150 PO190 PO20.1 PO20.6 PO20.9 PO21.1
PO21.2 PO21.3 PO21.4 PO21.5 PO22.1 PO22.3
PO22.4 PO23.1 PO24.1 PO25.1 PO25.5 PO25.6
PO25.7 PO26.2 PO26.3 PO26.4 PO26.5 PO26.6
PO26.7 PO26.9 PO27.2 PO28.2 PO29.1 PO30.1
PO30.2 PO30.3 PO30.4 PO300 PO31.1 PO31.2
PO32.2 PO32.4 PO33.1 PO34.1 PO35.1 PO36.1
PO36.2 PO38.1 PO39.1 PO39.2 PO44.1 PO50.1
PO52.1 PO520 PO536 PO54.5 POCP.1 POI3.1
POID.1 POII.1 POIJ.1 RQ10.1 RQ10.2 RQ10.4
RQ12.1 RQ13.1 RQ13.2 RQ35.1 RQ500 RQIF.1
WH130 WH132 WH190 WH20.2 WH20.7 WH222
WH30.1 WH30.2 WH30.3 WH30.4 WH31.1 WH31.2
WH31.3 WH31.4 WH32.1 WH32.2 WH32.3 WH32.4
WH32.5 WH33.1 WH33.2 WH33.3 WH33.4 WH33.5
WH33.6 WH33.8 WH33.9 WH34.1 WH34.2 WH34.3
WH34.4 WH40.1 WH40.2 WH520 WH830 ZW130

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PFM-ACTIVITY-GRP
Element: Activity Grp
Alpha 15
The activity group is the overall project.
AC10.6 AC110
AC120 AC19.1
AC502 AC560
PFM-ACTIVITY
Element: Activity
Alpha 15
Activities are the processes or procedures that produce work. Cost objects (products, services, customers, and so on) are the reasons for performing the activity.
AC10.6 AC110
AC19.1 AC502
AC560
PFM-SYSTEM
Element: System
Alpha 2
A two-character code representing an application used within the Lawson system. (i.e.: GL = General Ledger, AP = Accounts Payable, etc.)
AC10.6 AC110
AC19.1 AC502
AC560
PFM-SEQ-NUMBER
Element: Seq Number
Numeric 6
A unique number assigned to each transaction to be interfaced into the Lawson system.
AC10.6 AC110
AC19.1 AC502
AC560
PFM-UPDATE-DATE
Element: Update Date
Numeric 8 (yyyymmdd)
This field contains the date the record was updated.
AC10.6
PFM-BEGIN-DAYS
Element: Begin Days
Signed 3.0
The number of days to be subtracted from the begin date of the activity or activity group the template is applied to. This calculation will result in the POP record begin date.
AC10.6 AC110
AC19.1 AC502
AC560
PFM-BEGIN-DATE
Element: Begin Date
Numeric 8 (yyyymmdd)
The begin date for this effort period.
AC10.6 AC110
AC19.1 AC502
AC560
PFM-END-DAYS
Element: End Days
Signed 3.0
The number of days to be added to the end date of the activity or activity group the template is applied to. This calculation will result in the POP records begin date.
AC10.6 AC110
AC19.1 AC502
AC560
PFM-END-DATE
Element: End Date
Numeric 8 (yyyymmdd)
The end date for this effort period.
AC10.6 AC110
AC19.1 AC502
AC560
PFM-OPERATOR
Element: Operator
Alpha 10
This field is used to store the login id of the person who entered the record.
AC10.6 AC110
AC19.1 AC560
PFM-RECORD-TYPE
Element: Record Type
Alpha 1
This field identifies the type of record defined. Valid values are: S = Summary D = Detail
AC10.6


ACPRDPERF FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PFMSET1 ACTIVITY-GRP
ACTIVITY
SYSTEM
SEQ-NUMBER
AC00.1 AC10.1
AC10.6 AC110
AC120 AC200
AC210 AC300
AC560
PFMSET2 ACTIVITY-GRP
ACTIVITY
SYSTEM
SEQ-NUMBER*
...
AC10.6 AC110
AC130 AC131
AC40.1 AC41.1
AC41.4 AC46.1
AC50.2 AC502
ACAC.1 AP125
AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
API2.1 BR40.3


ACPRDPERF FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED 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


File created: Thu Jun 09 11:04:12 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.