POAGMTPART – Vendor Agreement Participants

System
Purchase Order (PO)
Prefix
PRK
Primary key
PROCURE-GROUP, VEN-AGRMT-REF, COMPANY, LOCATION, REQ-LOCATION
Fields
6
Updated by
19 programs
Referenced by
214 programs

POAGMTPART is the Vendor Agreement Participants table in Lawson Purchase Order (prefix PRK). It is indexed by PROCURE-GROUP, VEN-AGRMT-REF, COMPANY, LOCATION, REQ-LOCATION (PRKSET1); alternate indexes: PRKSET2. It is related 1:1 to POVAGRMTHD and 1:M to APINVOICE and POAGMAUDIT. It is updated by AP125, AP126, AP25.1, AP25.2, AP26.1, AP27.1, API1.1, MA61.1 and 11 more and referenced by AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7, AP21.1 and 206 more. The table has 6 fields, 2 indexes and 3 documented relations.

About POAGMTPART

No description in the Lawson data dictionary.

Fields (6)

Column = COBOL field name without the PRK- 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
#PRK-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.AP125, AP126, AP25.1, AP25.2, AP26.1, AP27.1, API1.1, IC140 +10 more
#PRK-VEN-AGRMT-REF PK
VEN_AGRMT_REF		Alpha 30—AP125, AP126, AP25.1, AP25.2, AP26.1, AP27.1, API1.1, IC140 +10 more
#PRK-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.AP125, AP126, AP25.1, AP25.2, AP26.1, AP27.1, API1.1, IC140 +10 more
#PRK-LOCATION PK
LOCATION		Alpha 5This field contains a valid stocking location within the company inventory.AP125, AP126, AP25.1, AP25.2, AP26.1, AP27.1, API1.1, IC140 +10 more
#PRK-REQ-LOCATION PK
REQ_LOCATION		Alpha 5The location requisitioning items. This location can be an inventory or noninventory location.AP125, AP126, AP25.1, AP25.2, AP26.1, AP27.1, API1.1, IC140 +10 more
#PRK-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.AP125, AP126, AP25.1, AP25.2, AP26.1, AP27.1, API1.1, IC140 +10 more

Indexes (2)

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
PRKSET1
  1. PROCURE-GROUP
  2. VEN-AGRMT-REF
  3. COMPANY
  4. LOCATION
  5. REQ-LOCATION
PrimaryAP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source)
PRKSET2
  1. PROCURE-GROUP
  2. VEN-AGRMT-REF
  3. COMPANY
  4. REQ-LOCATION
  5. LOCATION
KeyChangePO101, PO150, PO25.1, PO25.6, PO25.7, PO26.4, PO26.5, PO28.2 +3 more

Relations

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

One to one (1) — lookups and parents

RelationTableRulesConditionField map
PovagrmthdPOVAGRMTHDRequired
PRK-PROCURE-GROUP→PVH-PROCURE-GROUP
PRK-VEN-AGRMT-REF→PVH-VEN-AGRMT-REF

One to many (2) — child tables

RelationTableRulesConditionField map
ApinvoiceAPINVOICEValid When (PVH-AGMT-TYPE = "V")
PRK-COMPANY→API-COMPANY
PVH-VENDOR→API-VENDOR
PVH-PO-NUMBER→API-PO-NUMBER
PVH-LAST-PO-REL→API-PO-RELEASE
—→API-PO-CODE
—→API-LOCATION
—→API-INVOICE
—→API-SUFFIX
—→API-CANCEL-SEQ
PoagmauditPOAGMAUDIT
PRK-PROCURE-GROUP→PVB-PROCURE-GROUP
PRK-VEN-AGRMT-REF→PVB-VEN-AGRMT-REF
Zeroes→PVB-EFFECTIVE-DT
PRK-COMPANY→PVB-COMPANY
PRK-LOCATION→PVB-LOCATION
PRK-REQ-LOCATION→PVB-REQ-LOCATION
—→PVB-SYSTEM
—→PVB-COMMIT-DATE
—→PVB-UPDATE-DATE
—→PVB-UPDATE-TIME
—→PVB-FLD-NBR
—→PVB-AUDIT-TYPE

Programs

Updated by (19)

Referenced by (214)