PDMAUDIT – No description in the Lawson data dictionary

System
Purchase Order (PO)
Prefix
PDJ
Primary key
DB-FILE, PCARD-PROGRAM, MERCHANT, DATE, TIME, FLD-NBR
Fields
14
Updated by
4 programs
Referenced by
3 programs

PDMAUDIT is a Lawson Purchase Order table (prefix PDJ); no description in the lawson data dictionary. It is indexed by DB-FILE, PCARD-PROGRAM, MERCHANT, DATE, TIME, FLD-NBR (PDJSET1); alternate indexes: PDJSET2 and PDJSET3. It is updated by PD04.1, PD05.1, PD06.1 and PD263 and referenced by PD63.1, PD63.2 and PD63.3. The table has 14 fields, 3 indexes and 0 documented relations.

About PDMAUDIT

No description in the Lawson data dictionary.

Fields (14)

Column = COBOL field name without the PDJ- 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
#PDJ-DB-FILE PK
DB_FILE		Alpha 3—PD04.1, PD05.1, PD06.1
#PDJ-PCARD-PROGRAM PK
PCARD_PROGRAM		Alpha 10—PD04.1, PD05.1, PD06.1
#PDJ-MERCHANT PK
MERCHANT		Alpha 32—PD04.1, PD05.1, PD06.1
#PDJ-MERCHANT-GRP SET2
MERCHANT_GRP		Alpha 4—PD04.1, PD05.1, PD06.1
#PDJ-MCC-CODE SET2
MCC_CODE		Alpha 4—PD04.1, PD05.1, PD06.1
#PDJ-VENDOR-GROUP SET3
VENDOR_GROUP		Alpha 4—PD04.1, PD05.1, PD06.1
#PDJ-VENDOR SET3
VENDOR		Alpha 9 (Right Justified)—PD04.1, PD05.1, PD06.1
#PDJ-LOCATION-CODE SET3
LOCATION_CODE		Alpha 4—PD04.1, PD05.1, PD06.1
#PDJ-DATE PK
DATE		Numeric 8 (yyyymmdd)—PD04.1, PD05.1, PD06.1
#PDJ-TIME PK
TIME		Numeric 8—PD04.1, PD05.1, PD06.1
#PDJ-FLD-NBR PK
FLD_NBR		Numeric 4—PD04.1, PD05.1, PD06.1
#PDJ-BEFORE-IMAGE
BEFORE_IMAGE		Alpha 60—PD04.1, PD05.1, PD06.1
#PDJ-AFTER-IMAGE
AFTER_IMAGE		Alpha 60—PD04.1, PD05.1, PD06.1
#PDJ-OPERATOR-ID
OPERATOR_ID		Alpha 10—PD04.1, PD05.1, PD06.1

Indexes (3)

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
PDJSET1
  1. DB-FILE
  2. PCARD-PROGRAM
  3. MERCHANT
  4. DATE
  5. TIME
  6. FLD-NBR
PrimaryPD04.1, PD05.1, PD06.1, PD263, PD63.1
PDJSET2
  1. DB-FILE
  2. PCARD-PROGRAM
  3. MERCHANT-GRP
  4. MERCHANT
  5. MCC-CODE
  6. DATE
  7. TIME
  8. FLD-NBR
PD04.1, PD05.1, PD06.1, PD263, PD63.2
PDJSET3
  1. DB-FILE
  2. PCARD-PROGRAM
  3. VENDOR-GROUP
  4. VENDOR
  5. LOCATION-CODE
  6. MERCHANT
  7. DATE
  8. TIME
  9. FLD-NBR
PD04.1, PD05.1, PD06.1, PD263, PD63.3

Programs

Updated by (4)

Referenced by (3)