POAGMAUDIT – Vendor Agreement Audit

System
Purchase Order (PO)
Prefix
PVB
Primary key
PROCURE-GROUP, VEN-AGRMT-REF, EFFECTIVE-DT, COMPANY, LOCATION, REQ-LOCATION, SYSTEM, COMMIT-DATE, UPDATE-DATE, UPDATE-TIME, FLD-NBR, AUDIT-TYPE
Fields
20
Updated by
231 programs
Referenced by
0 programs

POAGMAUDIT is the Vendor Agreement Audit table in Lawson Purchase Order (prefix PVB). It is indexed by PROCURE-GROUP, VEN-AGRMT-REF, EFFECTIVE-DT, COMPANY, LOCATION, REQ-LOCATION, SYSTEM, COMMIT-DATE, UPDATE-DATE, UPDATE-TIME, FLD-NBR, AUDIT-TYPE (PVBSET1); alternate indexes: PVBSET2. It is related 1:1 to POAGMTPART, POAGMTPRIC, POAOCDTL, POVACOMMIT, POVADIST, POVAGRMTHD, POVAGRMTLN and PROCUREGRP. It is updated by AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 and 223 more. The table has 20 fields, 2 indexes and 8 documented relations.

About POAGMAUDIT

No description in the Lawson data dictionary.

Fields (20)

Column = COBOL field name without the PVB- 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
#PVB-AUDIT-TYPE PK
AUDIT_TYPE		Alpha 2—
  • 01 Vendor Agreement Header
  • 02 Vendor Agreement Line
  • 03 Vendor Agreement Pricing
  • 04 Vendor Agreement Participants
  • 05 Agreement Line Add-On Cost
  • 06 Agreement Line Distribution
  • 07 Vendor Agreement Spread Amount
AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#PVB-AUDIT-ACTION
AUDIT_ACTION		Alpha 1—
  • A Add
  • C Change
  • D Delete
  • E Close Commitments
  • H Hold
  • R Remove Hold
  • L Release Agreement
  • S Close Agreement
  • B Add/Create Item
AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#PVB-PROCURE-GROUP PK
PROCURE_GROUP		Alpha 4—AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#PVB-VEN-AGRMT-REF PK
VEN_AGRMT_REF		Alpha 30—AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#PVB-COMPANY PK
COMPANY		Numeric 4—AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#PVB-LOCATION PK
LOCATION		Alpha 5—AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#PVB-REQ-LOCATION PK
REQ_LOCATION		Alpha 5—AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#PVB-EFFECTIVE-DT PK
EFFECTIVE_DT		Numeric 8 (yyyymmdd)—AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#PVB-LINE-NBR SET2
LINE_NBR		Numeric 6—AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#PVB-LINE-SEQ SET2
LINE_SEQ		Numeric 3This is the sequence number of the agreement line distribution, or it has a zero value for agreement header spread commitments.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#PVB-SYSTEM PK
SYSTEM		Alpha 2—AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#PVB-COMMIT-DATE PK
COMMIT_DATE		Numeric 8 (yyyymmdd)The date for the spread commitment amount. It will fall into a particular year and period. For non-commitment spread amounts this is the period beginning date.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#PVB-FLD-NBR PK
FLD_NBR		Numeric 4—AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#PVB-AOC-CODE SET2
AOC_CODE		Alpha 2—AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#PVB-UPDATE-DATE PK
UPDATE_DATE		Numeric 8 (yyyymmdd)—AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#PVB-UPDATE-TIME PK
UPDATE_TIME		Numeric 8—AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#PVB-BEFORE-IMAGE
BEFORE_IMAGE		Alpha 35—AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#PVB-AFTER-IMAGE
AFTER_IMAGE		Alpha 35This field contains the field image before the change.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#PVB-USER-ID
USER_ID		Alpha 10 (Lower Case)—AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#PVB-DESC
DESC		Alpha 30 (Lower Case)The description of the field that has changed.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)

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
PVBSET1
  1. PROCURE-GROUP
  2. VEN-AGRMT-REF
  3. EFFECTIVE-DT
  4. COMPANY
  5. LOCATION
  6. REQ-LOCATION
  7. SYSTEM
  8. COMMIT-DATE
  9. UPDATE-DATE ↓
  10. UPDATE-TIME ↓
  11. FLD-NBR
  12. AUDIT-TYPE
PrimaryAP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source)
PVBSET2
  1. PROCURE-GROUP
  2. VEN-AGRMT-REF
  3. LINE-NBR
  4. AOC-CODE
  5. SYSTEM
  6. LINE-SEQ
  7. COMMIT-DATE
  8. UPDATE-DATE ↓
  9. UPDATE-TIME ↓
  10. FLD-NBR
  11. AUDIT-TYPE
KeyChangePO65.2

Relations

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

One to one (8) — lookups and parents

RelationTableRulesConditionField map
PoagmtpartPOAGMTPARTNot Required
PVB-PROCURE-GROUP→PRK-PROCURE-GROUP
PVB-VEN-AGRMT-REF→PRK-VEN-AGRMT-REF
PVB-COMPANY→PRK-COMPANY
PVB-LOCATION→PRK-LOCATION
PVB-REQ-LOCATION→PRK-REQ-LOCATION
PoagmtpricPOAGMTPRICNot Required
PVB-PROCURE-GROUP→PRI-PROCURE-GROUP
PVB-VEN-AGRMT-REF→PRI-VEN-AGRMT-REF
PVB-EFFECTIVE-DT→PRI-EFFECTIVE-DT
PoaocdtlPOAOCDTLNot Required
PVB-PROCURE-GROUP→PAO-PROCURE-GROUP
PVB-VEN-AGRMT-REF→PAO-VEN-AGRMT-REF
PVB-LINE-NBR→PAO-LINE-NBR
PVB-AOC-CODE→PAO-AOC-CODE
PovacommitPOVACOMMITNot Required
PVB-PROCURE-GROUP→PVC-PROCURE-GROUP
PVB-VEN-AGRMT-REF→PVC-VEN-AGRMT-REF
PVB-LINE-NBR→PVC-LINE-NBR
PVB-SYSTEM→PVC-SYSTEM
PVB-LINE-SEQ→PVC-LINE-SEQ
PVB-COMMIT-DATE→PVC-COMMIT-DATE
PovadistPOVADISTNot Required
PVB-PROCURE-GROUP→PVD-PROCURE-GROUP
PVB-VEN-AGRMT-REF→PVD-VEN-AGRMT-REF
PVB-LINE-NBR→PVD-LINE-NBR
PVB-LINE-SEQ→PVD-LINE-SEQ
PovagrmthdPOVAGRMTHDRequired
PVB-PROCURE-GROUP→PVH-PROCURE-GROUP
PVB-VEN-AGRMT-REF→PVH-VEN-AGRMT-REF
PovagrmtlnPOVAGRMTLNNot Required
PVB-PROCURE-GROUP→PVN-PROCURE-GROUP
PVB-VEN-AGRMT-REF→PVN-VEN-AGRMT-REF
PVB-LINE-NBR→PVN-LINE-NBR
ProcuregrpPROCUREGRPRequired
PVB-PROCURE-GROUP→PCG-PROCURE-GROUP

Programs

Updated by (231)