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

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 SET2
COMPANY		Numeric 4—PD01.1, PD01.2, PD08.1
#PDF-REASON-CODE SET3
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 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
PDFSET1
  1. DB-FILE
  2. PCARD-PROGRAM
  3. DATE
  4. TIME
  5. FLD-NBR
PrimaryPD01.1, PD01.2, PD08.1, PD262, PD62.1
PDFSET2
  1. DB-FILE
  2. PCARD-PROGRAM
  3. COMPANY
  4. DATE
  5. TIME
  6. FLD-NBR
PD01.1, PD01.2, PD08.1, PD262, PD62.2
PDFSET3
  1. DB-FILE
  2. PCARD-PROGRAM
  3. REASON-CODE
  4. DATE
  5. TIME
  6. FLD-NBR
PD01.1, PD01.2, PD08.1, PD262, PD62.3

Programs

Updated by (4)

Referenced by (3)