ACPOPTMPX – This file stores the Period of Performance Template Header records.
- System
- Activity Management (AC)
- Prefix
TMX- Primary key
TEMPLATE,SYSTEM- Fields
- 4
- Updated by
- 1 program
- Referenced by
- 4 programs
ACPOPTMPX is the This file stores the Period of Performance Template Header records. table in Lawson Activity Management (prefix TMX). It is indexed by TEMPLATE, SYSTEM (TMXSET1). It is related 1:1 to ACPOPTMP. It is updated by AC10.7 and referenced by AC110, AC19.1, AC211 and AC560. The table has 4 fields, 1 index and 1 documented relation.
About ACPOPTMPX
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 (4)
Column = COBOL field name without the TMX- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
TMX-TEMPLATE PKTEMPLATE | Alpha 15 | The name of the template the detail records are associated to. | AC10.7 |
TMX-SYSTEM PKSYSTEM | Alpha 2 | A two-character code representing an application used within the Lawson system. (i.e.: GL = General Ledger, AP = Accounts Payable, etc.) | AC10.7 |
TMX-BEGIN-DAYSBEGIN_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.7 |
TMX-END-DAYSEND_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.7 |
Indexes (1)
Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
TMXSET1 | TEMPLATE, SYSTEM | Primary | AC10.6, AC10.7, AC110, AC19.1, AC211, AC560 |
Relations
One to one (1) — lookups and parents
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| Acpoptmp | ACPOPTMP | Required | TMX-TEMPLATE → TMP-TEMPLATE |
Programs
Updated by (1)
- AC10.7 Period of Performance Template