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.

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 marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
PRKSET1PROCURE-GROUP, VEN-AGRMT-REF, COMPANY, LOCATION, REQ-LOCATIONPrimaryAP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source)
PRKSET2PROCURE-GROUP, VEN-AGRMT-REF, COMPANY, REQ-LOCATION, LOCATIONKeyChangePO101, PO150, PO25.1, PO25.6, PO25.7, PO26.4, PO26.5, PO28.2 +3 more

Relations

One to one (1) — lookups and parents

RelationTableRulesConditionField map
PovagrmthdPOVAGRMTHDRequiredPRK-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
PoagmauditPOAGMAUDITPRK-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)