PROCTEMP – Procurement Template
- System
- Purchase Order (PO)
- Prefix
POP- Primary key
PROCURE-GROUP,TEMPLATE-REF- Fields
- 11
- Updated by
- 6 programs
- Referenced by
- 7 programs
PROCTEMP is the Procurement Template table in Lawson Purchase Order (prefix POP). It is indexed by PROCURE-GROUP, TEMPLATE-REF (POPSET1). It is related 1:1 to POVAGRMTHD and 1:M to PROCTEMPLN and PROCTMPPAR. It is updated by PO115, PO15.1, PO15.2, PO15.3, PO15.4 and PO27.4 and referenced by PO165, PO20.1, PO215, PO65.3, PO65.4, RQ10.1 and RQIG.1. The table has 11 fields, 1 index and 4 documented relations.
About PROCTEMP
No description in the Lawson data dictionary.
Fields (11)
Column = COBOL field name without the POP- 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 / column | Type | Description & values | Updated by |
|---|---|---|---|
#POP-PROCURE-GROUP PKPROCURE_GROUP | Alpha 4 | Type or select a procurement group. A procurement group is a group of companies that share a common procurement effort. They buy items and services together. | PO115, PO15.1, PO15.2, PO15.4, PO20.1, PO27.3, RQ10.1 |
#POP-TEMPLATE-REF PKTEMPLATE_REF | Alpha 30 | — | PO115, PO15.1, PO15.2, PO15.4, PO20.1, PO27.3, RQ10.1 |
#POP-DESCRIPTIONDESCRIPTION | Alpha 30 (Lower Case) | This field displays the description. | PO115, PO15.1, PO15.2, PO15.4, PO20.1, PO27.3, RQ10.1 |
#POP-LAST-LINE-NBRLAST_LINE_NBR | Numeric 6 | This field contains the line number. | PO115, PO15.1, PO15.2, PO15.4, PO20.1, PO27.3, RQ10.1 |
#POP-FROM-COMPANYFROM_COMPANY | Numeric 4 | Identifies the AP company if the resource type = V. Identifies the HR company if the resource type = E. It is blank for type A, P or Q resources. | PO115, PO15.1, PO15.2, PO15.4, PO20.1, PO27.3, RQ10.1 |
#POP-FROM-LOCATIONFROM_LOCATION | Alpha 5 | This field contains a valid stocking location within the company inventory. | PO115, PO15.1, PO15.2, PO15.4, PO20.1, PO27.3, RQ10.1 |
#POP-LOCK-FLAGLOCK_FLAG | Numeric 1 | —
| PO115, PO15.1, PO15.2, PO15.3, PO15.4, PO20.1, PO27.3, RQ10.1 |
#POP-PARTICIPANTPARTICIPANT | Derived | — | — |
#POP-VEN-AGRMT-REFVEN_AGRMT_REF | Alpha 30 | — | PO115, PO15.1, PO15.2, PO15.4, PO20.1, PO27.3, RQ10.1 |
#POP-TEMPLT-DOC-NBRTEMPLT_DOC_NBR | Numeric 8 | — | PO115, PO15.1, PO15.2, PO15.4, PO20.1, PO27.3, PO27.4, RQ10.1 |
#POP-TEMPLATE-CODETEMPLATE_CODE | Alpha 4 | — | — |
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.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
POPSET1 |
| Primary | PO115, PO15.1, PO15.2, PO15.3, PO15.4, PO165, PO20.1, PO215 +6 more |
Relations
One to one (1) — lookups and parents
| Relation | Table | Rules | Condition | Field map | ||||||
|---|---|---|---|---|---|---|---|---|---|---|
| Povagrmthd | POVAGRMTHD | Not Required | Valid When POP-VEN-AGRMT-REF != Spaces |
|
One to many (3) — child tables
| Relation | Table | Rules | Condition | Field map | |||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Proctempl2 | PROCTEMPLN | Delete Cascades |
| ||||||||||||||||||||||
| Proctempln | PROCTEMPLN | Delete Cascades |
| ||||||||||||||||||||||
| Proctmppar | PROCTMPPAR | Delete Cascades |
|
Programs
Updated by (6)
- PO115 Procurement Template Mass Changes
- PO15.1 Procurement Templates
- PO15.2 Procurement Template Participants
- PO15.3 Procurement Templates Locking
- PO15.4 Procurement Template Line Detail
- PO27.4 Select and Copy Template