PROCTMPPAR – Proc Template Participants

System: Purchase Order (PO)
Prefix: POA
Primary key: PROCURE-GROUP, TEMPLATE-REF, COMPANY, REQ-LOCATION, REQUESTER, BUYER-GRP, BUYER
Fields: 8
Updated by: 4 programs
Referenced by: 4 programs

PROCTMPPAR is the Proc Template Participants table in Lawson Purchase Order (prefix POA). It is indexed by PROCURE-GROUP, TEMPLATE-REF, COMPANY, REQ-LOCATION, REQUESTER, BUYER-GRP, BUYER (POASET1); alternate indexes: POASET2, POASET3, POASET4, POASET5 and POASET6. It is related 1:1 to PROCTEMP and 1:M to PROCTEMPLN. It is updated by PO115, PO15.1, PO15.2 and PO15.4 and referenced by PO20.1, PO215, RQ10.1 and RQIG.1. The table has 8 fields, 6 indexes and 2 documented relations.

About PROCTMPPAR

No description in the Lawson data dictionary.

Fields (8)

Column = COBOL field name without the POA- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / column	Type	Description & values	Updated by
`POA-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
`POA-TEMPLATE-REF` PK TEMPLATE_REF	Alpha 30	—	PO115, PO15.1, PO15.2, PO15.4
`POA-COMPANY` PK 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
`POA-REQ-LOCATION` PK REQ_LOCATION	Alpha 5	The location requisitioning items. This location can be an inventory or noninventory location.	PO115, PO15.1, PO15.2, PO15.4
`POA-REQUESTER` PK REQUESTER	Alpha 10 (Lower Case)	This is the person who requested this requisition.	PO115, PO15.1, PO15.2, PO15.4
`POA-BUYER-GRP` PK BUYER_GRP	Alpha 5	The user defined buyer group.	PO115, PO15.1, PO15.2, PO15.4
`POA-BUYER` PK BUYER	Alpha 3	—	PO115, PO15.1, PO15.2, PO15.4
`POA-ACCT-UNIT` ACCT_UNIT	Alpha 15	The accounting unit is a shorthand notation representing the variable level number. When used in the General Ledger Account Master file, the accounting unit must be defined in the General Ledger Names file as a posting accounting unit.	—

Indexes (6)

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
`POASET1`	`PROCURE-GROUP`, `TEMPLATE-REF`, `COMPANY`, `REQ-LOCATION`, `REQUESTER`, `BUYER-GRP`, `BUYER`	Primary		PO115, PO15.1, PO15.2, PO15.4, PO20.1, PO215, RQIG.1
`POASET2`	`PROCURE-GROUP`, `BUYER-GRP`, `TEMPLATE-REF`	KeyChange, Subset	Where (BUYER-GRP != Spaces)	PO115, PO20.1
`POASET3`	`PROCURE-GROUP`, `BUYER`, `TEMPLATE-REF`	KeyChange, Subset	Where (BUYER != Spaces)	PO115, PO20.1
`POASET4`	`PROCURE-GROUP`, `COMPANY`, `TEMPLATE-REF`	KeyChange, Subset	Where (COMPANY != Zeroes) And (REQ-LOCATION = Spaces)	PO115, RQ10.1, RQIG.1
`POASET5`	`PROCURE-GROUP`, `COMPANY`, `REQ-LOCATION`, `TEMPLATE-REF`	KeyChange, Subset	Where (REQ-LOCATION != Spaces) And (COMPANY != Zeroes)	PO115, RQ10.1, RQIG.1
`POASET6`	`PROCURE-GROUP`, `REQUESTER`, `TEMPLATE-REF`	KeyChange, Subset	Where (REQUESTER != Spaces)	PO115, RQ10.1, RQIG.1

Relations

One to one (1) — lookups and parents

Relation	Table	Rules	Condition	Field map
Proctemp	PROCTEMP	Required		`POA-PROCURE-GROUP` → `POP-PROCURE-GROUP`, `POA-TEMPLATE-REF` → `POP-TEMPLATE-REF`

One to many (1) — child tables

Relation	Table	Rules	Condition	Field map
Proctempln	PROCTEMPLN			`POA-PROCURE-GROUP` → `POE-PROCURE-GROUP`, `POA-TEMPLATE-REF` → `POE-TEMPLATE-REF`, → `POE-LINE-NBR`

PROCTMPPAR – Proc Template Participants

About PROCTMPPAR

Fields (8)

Indexes (6)

Relations

One to one (1) — lookups and parents

One to many (1) — child tables

Programs

Updated by (4)

Referenced by (4)