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.

Field / column	Type	Description & values	Updated by
`POP-PROCURE-GROUP` PK PROCURE_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` PK TEMPLATE_REF	Alpha 30	—	PO115, PO15.1, PO15.2, PO15.4, PO20.1, PO27.3, RQ10.1
`POP-DESCRIPTION` DESCRIPTION	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-NBR` LAST_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-COMPANY` FROM_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-LOCATION` FROM_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-FLAG` LOCK_FLAG	Numeric 1	— `0` Not Locked `1` Locked	PO115, PO15.1, PO15.2, PO15.3, PO15.4, PO20.1, PO27.3, RQ10.1
`POP-PARTICIPANT` PARTICIPANT	Derived	—	—
`POP-VEN-AGRMT-REF` VEN_AGRMT_REF	Alpha 30	—	PO115, PO15.1, PO15.2, PO15.4, PO20.1, PO27.3, RQ10.1
`POP-TEMPLT-DOC-NBR` TEMPLT_DOC_NBR	Numeric 8	—	PO115, PO15.1, PO15.2, PO15.4, PO20.1, PO27.3, PO27.4, RQ10.1
`POP-TEMPLATE-CODE` TEMPLATE_CODE	Alpha 4	—	—

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
`POPSET1`	`PROCURE-GROUP`, `TEMPLATE-REF`	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	`POP-PROCURE-GROUP` → `PVH-PROCURE-GROUP`, `POP-VEN-AGRMT-REF` → `PVH-VEN-AGRMT-REF`

One to many (3) — child tables

Relation	Table	Rules	Field map
Proctempl2	PROCTEMPLN	Delete Cascades	`POP-PROCURE-GROUP` → `POE-PROCURE-GROUP`, `POP-TEMPLATE-REF` → `POE-TEMPLATE-REF`, → `POE-ITEM`, → `POE-LINE-NBR`
Proctempln	PROCTEMPLN	Delete Cascades	`POP-PROCURE-GROUP` → `POE-PROCURE-GROUP`, `POP-TEMPLATE-REF` → `POE-TEMPLATE-REF`, → `POE-LINE-NBR`
Proctmppar	PROCTMPPAR	Delete Cascades	`POP-PROCURE-GROUP` → `POA-PROCURE-GROUP`, `POP-TEMPLATE-REF` → `POA-TEMPLATE-REF`, → `POA-COMPANY`, → `POA-REQ-LOCATION`, → `POA-REQUESTER`, → `POA-BUYER-GRP`, → `POA-BUYER`

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

Referenced by (7)

PO165 Procure Template Audit Report
PO20.1 Purchase Order Entry
PO215 Procurement Template Listing
PO65.3 Procurement Template Audit
PO65.4 Procurement Template Participants Audit
RQ10.1 Requisition
RQIG.1 Get Shopping List Invoke Object