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

Field / columnTypeDescription & valuesUpdated 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 SET2
COMPANY		Numeric 4—PO00.1, PO01.1, PO01.5, PO10.1, PO10.2
#PGU-VENDOR-GROUP SET3 SET5
VENDOR_GROUP		Alpha 4—PO00.1, PO01.1, PO01.5, PO10.1, PO10.2
#PGU-VENDOR SET3 SET5
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 SET4
BUYER_CODE		Alpha 3—PO00.1, PO01.1, PO01.5, PO10.1, PO10.2
#PGU-PURCH-FR-LOC SET5
PURCH_FR_LOC		Alpha 4—PO00.1, PO01.1, PO01.5, PO10.1, PO10.2

Indexes (5)

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
PGUSET1
  1. DB-FILE
  2. PROCURE-GROUP
  3. DATE
  4. TIME
  5. FLD-NBR
PrimaryPO10.1, PO10.2, PO193, PO194, PO61.1
PGUSET2
  1. DB-FILE
  2. COMPANY
  3. DATE
  4. TIME
  5. FLD-NBR
PO194, PO61.2
PGUSET3
  1. DB-FILE
  2. VENDOR-GROUP
  3. VENDOR
  4. DATE
  5. TIME
  6. FLD-NBR
PO196, PO61.3
PGUSET4
  1. DB-FILE
  2. PROCURE-GROUP
  3. BUYER-CODE
  4. DATE
  5. TIME
  6. FLD-NBR
—
PGUSET5
  1. DB-FILE
  2. VENDOR-GROUP
  3. VENDOR
  4. PURCH-FR-LOC
  5. DATE
  6. TIME
  7. FLD-NBR
PO197, PO61.4

Programs

Updated by (9)

Referenced by (4)