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

Field / columnTypeDescription & valuesUpdated 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 32This 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 35This 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 10Contains 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 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
PIUSET1
  1. PROCURE-GROUP
  2. ITEM
  3. VENDOR
  4. VENDOR-ITEM
  5. DATE ↓
  6. TIME ↓
  7. FLD-NBR
PrimaryPO13.1, PO13.3, PO150, PO192, PO25.6, PO25.7, PO26.4, PO26.5 +5 more

Relations

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

One to one (4) — lookups and parents

RelationTableRulesConditionField map
ApvenmastAPVENMASTRequired
PCG-VENDOR-GROUP→VEN-VENDOR-GROUP
PIU-VENDOR→VEN-VENDOR
ItemmastITEMMASTRequired
PCG-ITEM-GROUP→ITE-ITEM-GROUP
PIU-ITEM→ITE-ITEM
PoitemvenPOITEMVENNot Required
PIU-PROCURE-GROUP→PIV-PROCURE-GROUP
PIU-ITEM→PIV-ITEM
PIU-VENDOR→PIV-VENDOR
PIU-VENDOR-ITEM→PIV-VEN-ITEM
ProcuregrpPROCUREGRPRequired
PIU-PROCURE-GROUP→PCG-PROCURE-GROUP

Programs

Updated by (12)

Referenced by (1)