POPIVAUDIT – Vendor Item Audit

System: Purchase Order (PO)
Prefix: PIU
Primary key: PROCURE-GROUP, ITEM, VENDOR, VENDOR-ITEM, DATE, TIME, FLD-NBR
Fields: 12
Updated by: 12 programs
Referenced by: 1 program

POPIVAUDIT is the Vendor Item Audit table in Lawson Purchase Order (prefix PIU). It is indexed by PROCURE-GROUP, ITEM, VENDOR, VENDOR-ITEM, DATE, TIME, FLD-NBR (PIUSET1). It is related 1:1 to APVENMAST, ITEMMAST, POITEMVEN and PROCUREGRP. It is updated by PO13.1, PO13.3, PO150, PO192, PO25.6, PO25.7, PO26.4, PO26.5 and 4 more and referenced by PO69.1. The table has 12 fields, 1 index and 4 documented relations.

About POPIVAUDIT

The Vendor Item Audit table is created as a result of choosing the audit option in PO00.1 (Procurement Group). When this option is selected, entries to this table are added whenever changes are made to a vendor item.

Fields (12)

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

Field / column	Type	Description & values	Updated by
`PIU-PROCURE-GROUP` PK PROCURE_GROUP	Alpha 4	—	PO13.1, PO13.3, PO150, PO25.6, PO25.7, PO26.4, PO26.5, PO28.2 +3 more
`PIU-ITEM` PK ITEM	Alpha 32	—	PO13.1, PO13.3, PO150, PO25.6, PO25.7, PO26.4, PO26.5, PO28.2 +3 more
`PIU-VENDOR` PK VENDOR	Alpha 9 (Right Justified)	—	PO13.1, PO13.3, PO150, PO25.6, PO25.7, PO26.4, PO26.5, PO28.2 +3 more
`PIU-VENDOR-ITEM` PK VENDOR_ITEM	Alpha 32	This is the vendor's item identifier.	PO13.1, PO13.3, PO150, PO25.6, PO25.7, PO26.4, PO26.5, PO28.2 +3 more
`PIU-DATE` PK DATE	Numeric 8 (yyyymmdd)	—	PO13.1, PO13.3, PO150, PO25.6, PO25.7, PO26.4, PO26.5, PO28.2 +3 more
`PIU-TIME` PK TIME	Numeric 8	—	PO13.1, PO13.3, PO150, PO25.6, PO25.7, PO26.4, PO26.5, PO28.2 +3 more
`PIU-FLD-NBR` PK FLD_NBR	Numeric 4	—	PO13.1, PO13.3, PO150, PO25.6, PO25.7, PO26.4, PO26.5, PO28.2 +3 more
`PIU-BEFORE-IMAGE` BEFORE_IMAGE	Alpha 35	—	PO13.1, PO13.3, PO150, PO25.6, PO25.7, PO26.4, PO26.5, PO28.2 +3 more
`PIU-AFTER-IMAGE` AFTER_IMAGE	Alpha 35	This field contains the field image after the change.	PO13.1, PO13.3, PO150, PO25.6, PO25.7, PO26.4, PO26.5, PO28.2 +3 more
`PIU-OPERATOR-ID` OPERATOR_ID	Alpha 10	Contains the operator ID of the person who last changed this record.	PO13.1, PO13.3, PO150, PO25.6, PO25.7, PO26.4, PO26.5, PO28.2 +3 more
`PIU-DESC` DESC	Alpha 30 (Lower Case)	The description of the field that has changed.	PO13.1, PO13.3, PO150, PO25.6, PO25.7, PO26.4, PO26.5, PO28.2 +3 more
`PIU-AUDIT-ACTION` AUDIT_ACTION	Alpha 1	— `A` Add `C` Change `D` Delete `M` Mark Default `V` Activate `T` Inactivate `R` Replace and Inactivate	PO13.1, PO13.3, PO150, PO25.6, PO25.7, PO26.4, PO26.5, PO28.2 +3 more

Indexes (1)

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
`PIUSET1`	`PROCURE-GROUP`, `ITEM`, `VENDOR`, `VENDOR-ITEM`, `DATE`, `TIME`, `FLD-NBR`	Primary		PO13.1, PO13.3, PO150, PO192, PO25.6, PO25.7, PO26.4, PO26.5 +5 more

Relations

One to one (4) — lookups and parents

Relation	Table	Rules	Field map
Apvenmast	APVENMAST	Required	`PCG-VENDOR-GROUP` → `VEN-VENDOR-GROUP`, `PIU-VENDOR` → `VEN-VENDOR`
Itemmast	ITEMMAST	Required	`PCG-ITEM-GROUP` → `ITE-ITEM-GROUP`, `PIU-ITEM` → `ITE-ITEM`
Poitemven	POITEMVEN	Not Required	`PIU-PROCURE-GROUP` → `PIV-PROCURE-GROUP`, `PIU-ITEM` → `PIV-ITEM`, `PIU-VENDOR` → `PIV-VENDOR`, `PIU-VENDOR-ITEM` → `PIV-VEN-ITEM`
Procuregrp	PROCUREGRP	Required	`PIU-PROCURE-GROUP` → `PCG-PROCURE-GROUP`

Programs

Updated by (12)

PO13.1 Vendor Item
PO13.3 Vendor Items
PO150 Bid Load to Contract or Catalog
PO192 PO Vendor Item Audit Report
PO25.6 Vendor Agreement Line
PO25.7 Service Agreement Line
PO26.4 Vendor Agreement Line Price Breaks
PO26.5 Vendor Agreement Line Price Breaks
PO28.2 Vendor Agreement Line Detail List
PO36.2 Vendor Agreement Import Manual Input
PO536 Vendor Price Agreement Load
PO813 Item Vendor Load

Referenced by (1)

PO69.1 PO Vendor Item Audit Inquiry