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.

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
MERCHANT_GRP		Alpha 4—PD04.1, PD05.1, PD06.1
PDJ-MCC-CODE
MCC_CODE		Alpha 4—PD04.1, PD05.1, PD06.1
PDJ-VENDOR-GROUP
VENDOR_GROUP		Alpha 4—PD04.1, PD05.1, PD06.1
PDJ-VENDOR
VENDOR		Alpha 9 (Right Justified)—PD04.1, PD05.1, PD06.1
PDJ-LOCATION-CODE
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 marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
PDJSET1DB-FILE, PCARD-PROGRAM, MERCHANT, DATE, TIME, FLD-NBRPrimaryPD04.1, PD05.1, PD06.1, PD263, PD63.1
PDJSET2DB-FILE, PCARD-PROGRAM, MERCHANT-GRP, MERCHANT, MCC-CODE, DATE, TIME, FLD-NBRPD04.1, PD05.1, PD06.1, PD263, PD63.2
PDJSET3DB-FILE, PCARD-PROGRAM, VENDOR-GROUP, VENDOR, LOCATION-CODE, MERCHANT, DATE, TIME, FLD-NBRPD04.1, PD05.1, PD06.1, PD263, PD63.3

Programs

Updated by (4)

Referenced by (3)