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.
UPDATED BY
AC10.6 AC10.1 AC00.1 AC200 AC210 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
MA41.1 MA41.2 MA41.4 MA41.7 MA43.1 MA43.2
MA43.3 MA43.4 MA43.6 MA43.7 MAI1.1 PO136
PO190 PO300 PO520 POCP.1 POI3.1 POII.1
POIJ.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PFM-ACTIVITY-GRP
Element: Activity Grp		Alpha 15
The activity group is the overall project.
AC10.6
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
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
PFM-SEQ-NUMBER
Element: Seq Number		Numeric 6
A unique number assigned to each transaction to be interfaced into the Lawson system.
AC10.6
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
PFM-BEGIN-DATE
Element: Begin Date		Numeric 8 (yyyymmdd)
The begin date for this effort period.
AC10.6
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
PFM-END-DATE
Element: End Date		Numeric 8 (yyyymmdd)
The end date for this effort period.
AC10.6
PFM-OPERATOR
Element: Operator		Alpha 10
This field is used to store the login id of the person who entered the record.
AC10.6
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 AC200
AC210
PFMSET2 ACTIVITY-GRP
ACTIVITY
SYSTEM
SEQ-NUMBER*
...
AC10.6 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
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7


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: Wed Jun 08 20:46:56 2016

Home
Contact Us



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