ACPOPTMP – This file stores the Period of Performance Template Header records.

System
Activity Management (AC)
Prefix
TMP
Primary key
TEMPLATE
Fields
2
Updated by
1 program
Referenced by
6 programs

ACPOPTMP is the This file stores the Period of Performance Template Header records. table in Lawson Activity Management (prefix TMP). It is indexed by TEMPLATE (TMPSET1). It is related 1:M to ACPOPTMPX. It is updated by AC10.7 and referenced by AC110, AC19.1, AC19.2, AC19.3, AC211 and AC56.1. The table has 2 fields, 1 index and 1 documented relation.

About ACPOPTMP

This file stores the Period of Performance Template Header records. The template allows the ability to pre-define or create, and assign a set of POP number of days for serveral system codes. This will simplify the maintenance and setup required for Period of Performance functionality. The template will include a set of system codes and designedated number of begin and end dates for each system assigned to the template. The begin number of days will be subtracted from the activity or activity group begin date to arrive at the systems POP begin date. The end number of days will be added to the activity or activity group end date to arrive at the POP end date. By removing the date from the template, the templates set of POP rangtes can be applied to mulitiple activities or activity groups regardless of their date ranges, or fiscal year.

Fields (2)

Column = COBOL field name without the TMP- 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
#TMP-TEMPLATE PK
TEMPLATE
Alpha 15The name of the template the detail records are associated to.AC10.7
#TMP-DESCRIPTION
DESCRIPTION
Alpha 30 (Lower Case)This field displays the description.AC10.7

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
TMPSET1
  1. TEMPLATE
PrimaryAC10.7, AC110, AC19.1, AC19.2, AC19.3, AC211, AC56.1

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
ACPOPTMPXACPOPTMP

One to many (1) — child tables

RelationTableRulesConditionField map
AcpoptmpxACPOPTMPX
TMP-TEMPLATETMX-TEMPLATE
TMX-SYSTEM

Programs

Updated by (1)

Referenced by (6)