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. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#POA-PROCURE-GROUP PK
PROCURE_GROUP		Alpha 4Type 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 4Identifies 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 5The 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 5The 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 15The 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 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
POASET1
  1. PROCURE-GROUP
  2. TEMPLATE-REF
  3. COMPANY
  4. REQ-LOCATION
  5. REQUESTER
  6. BUYER-GRP
  7. BUYER
PrimaryPO115, PO15.1, PO15.2, PO15.4, PO20.1, PO215, RQIG.1
POASET2
  1. PROCURE-GROUP
  2. BUYER-GRP
  3. TEMPLATE-REF
KeyChange, SubsetWhere (BUYER-GRP != Spaces)PO115, PO20.1
POASET3
  1. PROCURE-GROUP
  2. BUYER
  3. TEMPLATE-REF
KeyChange, SubsetWhere (BUYER != Spaces)PO115, PO20.1
POASET4
  1. PROCURE-GROUP
  2. COMPANY
  3. TEMPLATE-REF
KeyChange, SubsetWhere (COMPANY != Zeroes) And (REQ-LOCATION = Spaces)PO115, RQ10.1, RQIG.1
POASET5
  1. PROCURE-GROUP
  2. COMPANY
  3. REQ-LOCATION
  4. TEMPLATE-REF
KeyChange, SubsetWhere (REQ-LOCATION != Spaces) And (COMPANY != Zeroes)PO115, RQ10.1, RQIG.1
POASET6
  1. PROCURE-GROUP
  2. REQUESTER
  3. TEMPLATE-REF
KeyChange, SubsetWhere (REQUESTER != Spaces)PO115, RQ10.1, RQIG.1

Relations

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

One to one (1) — lookups and parents

RelationTableRulesConditionField map
ProctempPROCTEMPRequired
POA-PROCURE-GROUP→POP-PROCURE-GROUP
POA-TEMPLATE-REF→POP-TEMPLATE-REF

One to many (1) — child tables

RelationTableRulesConditionField map
ProctemplnPROCTEMPLN
POA-PROCURE-GROUP→POE-PROCURE-GROUP
POA-TEMPLATE-REF→POE-TEMPLATE-REF
—→POE-LINE-NBR

Programs

Updated by (4)

Referenced by (4)