PDSAUDIT – No description in the Lawson data dictionary

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

PDSAUDIT is a Lawson Purchase Order table (prefix PDF); no description in the lawson data dictionary. It is indexed by DB-FILE, PCARD-PROGRAM, DATE, TIME, FLD-NBR (PDFSET1); alternate indexes: PDFSET2 and PDFSET3. It is updated by PD01.1, PD01.2, PD08.1 and PD262 and referenced by PD62.1, PD62.2 and PD62.3. The table has 10 fields, 3 indexes and 0 documented relations.

About PDSAUDIT

No description in the Lawson data dictionary.

Fields (10)

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

Field / columnTypeDescription & valuesUpdated by
PDF-DB-FILE PK
DB_FILE		Alpha 3—PD01.1, PD01.2, PD08.1
PDF-PCARD-PROGRAM PK
PCARD_PROGRAM		Alpha 10—PD01.1, PD01.2, PD08.1
PDF-COMPANY
COMPANY		Numeric 4—PD01.1, PD01.2, PD08.1
PDF-REASON-CODE
REASON_CODE		Alpha 4—PD01.1, PD01.2, PD08.1
PDF-DATE PK
DATE		Numeric 8 (yyyymmdd)—PD01.1, PD01.2, PD08.1
PDF-TIME PK
TIME		Numeric 8—PD01.1, PD01.2, PD08.1
PDF-FLD-NBR PK
FLD_NBR		Numeric 4—PD01.1, PD01.2, PD08.1
PDF-BEFORE-IMAGE
BEFORE_IMAGE		Alpha 60—PD01.1, PD01.2, PD08.1
PDF-AFTER-IMAGE
AFTER_IMAGE		Alpha 60—PD01.1, PD01.2, PD08.1
PDF-OPERATOR-ID
OPERATOR_ID		Alpha 10—PD01.1, PD01.2, PD08.1

Indexes (3)

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

IndexKeysFlagsConditionUsed in
PDFSET1DB-FILE, PCARD-PROGRAM, DATE, TIME, FLD-NBRPrimaryPD01.1, PD01.2, PD08.1, PD262, PD62.1
PDFSET2DB-FILE, PCARD-PROGRAM, COMPANY, DATE, TIME, FLD-NBRPD01.1, PD01.2, PD08.1, PD262, PD62.2
PDFSET3DB-FILE, PCARD-PROGRAM, REASON-CODE, DATE, TIME, FLD-NBRPD01.1, PD01.2, PD08.1, PD262, PD62.3

Programs

Updated by (4)

Referenced by (3)