ACIFPERF – No description in the Lawson data dictionary

System
Activity Management (AC)
Prefix
ACE
Primary key
RUN-GROUP, OLD-ACT-GRP, OLD-ACTIVITY, SYSTEM
Fields
8
Updated by
2 programs
Referenced by
0 programs

ACIFPERF is a Lawson Activity Management table (prefix ACE); no description in the lawson data dictionary. It is indexed by RUN-GROUP, OLD-ACT-GRP, OLD-ACTIVITY, SYSTEM (ACESET1). It is updated by AC50.2 and AC502. The table has 8 fields, 1 index and 0 documented relations.

About ACIFPERF

No description in the Lawson data dictionary.

Fields (8)

Column = COBOL field name without the ACE- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#ACE-RUN-GROUP PK
RUN_GROUP		Alpha 15Run Group is used to group records together for interfacing.AC50.2, AC502
#ACE-OLD-ACT-GRP PK
OLD_ACT_GRP		Alpha 35Period of performance activity group.AC50.2, AC502
#ACE-OLD-ACTIVITY PK
OLD_ACTIVITY		Alpha 35Period of performance activity.AC50.2, AC502
#ACE-SYSTEM PK
SYSTEM		Alpha 2A two-character code representing an application used within the Lawson system. (i.e.: GL = General Ledger, AP = Accounts Payable, etc.)AC50.2, AC502
#ACE-BEGIN-DAYS
BEGIN_DAYS		Signed 3.0The 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.AC50.2, AC502
#ACE-BEGIN-DATE
BEGIN_DATE		Numeric 8 (yyyymmdd)The begin date for this effort period.AC50.2, AC502
#ACE-END-DAYS
END_DAYS		Signed 3.0The 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.AC50.2, AC502
#ACE-END-DATE
END_DATE		Numeric 8 (yyyymmdd)The end date for this effort period.AC50.2, AC502

Indexes (1)

Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
ACESET1
  1. RUN-GROUP
  2. OLD-ACT-GRP
  3. OLD-ACTIVITY
  4. SYSTEM
PrimaryAC50.2, AC502

Programs

Updated by (2)