POPCGAUDIT – No description in the Lawson data dictionary

System: Purchase Order (PO)
Prefix: PGU
Primary key: DB-FILE, PROCURE-GROUP, DATE, TIME, FLD-NBR
Fields: 13
Updated by: 9 programs
Referenced by: 4 programs

POPCGAUDIT is a Lawson Purchase Order table (prefix PGU); no description in the lawson data dictionary. It is indexed by DB-FILE, PROCURE-GROUP, DATE, TIME, FLD-NBR (PGUSET1); alternate indexes: PGUSET2, PGUSET3, PGUSET4 and PGUSET5. It is updated by PO00.1, PO01.1, PO01.5, PO10.1, PO10.2, PO193, PO194, PO196 and 1 more and referenced by PO61.1, PO61.2, PO61.3 and PO61.4. The table has 13 fields, 5 indexes and 0 documented relations.

About POPCGAUDIT

No description in the Lawson data dictionary.

Fields (13)

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

Field / column	Type	Description & values	Updated by
`PGU-DB-FILE` PK DB_FILE	Alpha 3	—	PO00.1, PO01.1, PO01.5, PO10.1, PO10.2
`PGU-PROCURE-GROUP` PK PROCURE_GROUP	Alpha 4	—	PO00.1, PO01.1, PO01.5, PO10.1, PO10.2
`PGU-COMPANY` COMPANY	Numeric 4	—	PO00.1, PO01.1, PO01.5, PO10.1, PO10.2
`PGU-VENDOR-GROUP` VENDOR_GROUP	Alpha 4	—	PO00.1, PO01.1, PO01.5, PO10.1, PO10.2
`PGU-VENDOR` VENDOR	Alpha 9 (Right Justified)	—	PO00.1, PO01.1, PO01.5, PO10.1, PO10.2
`PGU-DATE` PK DATE	Numeric 8 (yyyymmdd)	—	PO00.1, PO01.1, PO01.5, PO10.1, PO10.2
`PGU-TIME` PK TIME	Numeric 8	—	PO00.1, PO01.1, PO01.5, PO10.1, PO10.2
`PGU-FLD-NBR` PK FLD_NBR	Numeric 4	—	PO00.1, PO01.1, PO01.5, PO10.1, PO10.2
`PGU-BEFORE-IMAGE` BEFORE_IMAGE	Alpha 350 (Lower Case)	—	PO00.1, PO01.1, PO01.5, PO10.1, PO10.2
`PGU-AFTER-IMAGE` AFTER_IMAGE	Alpha 350 (Lower Case)	—	PO00.1, PO01.1, PO01.5, PO10.1, PO10.2
`PGU-OPERATOR-ID` OPERATOR_ID	Alpha 10	—	PO00.1, PO01.1, PO01.5, PO10.1, PO10.2
`PGU-BUYER-CODE` BUYER_CODE	Alpha 3	—	PO00.1, PO01.1, PO01.5, PO10.1, PO10.2
`PGU-PURCH-FR-LOC` PURCH_FR_LOC	Alpha 4	—	PO00.1, PO01.1, PO01.5, PO10.1, PO10.2

Indexes (5)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

Index	Keys	Flags	Used in
`PGUSET1`	`DB-FILE`, `PROCURE-GROUP`, `DATE`, `TIME`, `FLD-NBR`	Primary	PO10.1, PO10.2, PO193, PO194, PO61.1
`PGUSET2`	`DB-FILE`, `COMPANY`, `DATE`, `TIME`, `FLD-NBR`		PO194, PO61.2
`PGUSET3`	`DB-FILE`, `VENDOR-GROUP`, `VENDOR`, `DATE`, `TIME`, `FLD-NBR`		PO196, PO61.3
`PGUSET4`	`DB-FILE`, `PROCURE-GROUP`, `BUYER-CODE`, `DATE`, `TIME`, `FLD-NBR`		—
`PGUSET5`	`DB-FILE`, `VENDOR-GROUP`, `VENDOR`, `PURCH-FR-LOC`, `DATE`, `TIME`, `FLD-NBR`		PO197, PO61.4

Programs

Updated by (9)

PO00.1 Procurement Group
PO01.1 PO Company Setup
PO01.5 Procedure Info Output
PO10.1 PO Vendor
PO10.2 Vendor Purchase From Location
PO193 Procurement Group Audit Report
PO194 PO Company Setup Audit Report
PO196 PO Vendor Audit Report
PO197 PO Vendor Purchase From Location Audit Report

Referenced by (4)

PO61.1 Procurement Group Audit Inquiry
PO61.2 PO Company Audit Inquiry
PO61.3 PO Vendor Audit Inquiry
PO61.4 PO Vendor Purchase From Location Audit Inquiry