PDAUDIT – No description in the Lawson data dictionary

System
Purchase Order (PO)
Prefix
PDU
Primary key
PCARD-PROGRAM, PCARD-NBR, PD-AUDIT-TYPE, ACTION, FIELD-NBR, USER, DATE, TIME, SEQ
Fields
13
Updated by
8 programs
Referenced by
1 program

PDAUDIT is a Lawson Purchase Order table (prefix PDU); no description in the lawson data dictionary. It is indexed by PCARD-PROGRAM, PCARD-NBR, PD-AUDIT-TYPE, ACTION, FIELD-NBR, USER, DATE, TIME, SEQ (PDUSET1); alternate indexes: PDUSET2. It is updated by PD10.2, PD10.3, PD20.1, PD20.2, PD20.3, PD21.1, PD22.1 and PD260 and referenced by PD60.1. The table has 13 fields, 2 indexes and 0 documented relations.

About PDAUDIT

No description in the Lawson data dictionary.

Fields (13)

Column = COBOL field name without the PDU- 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
#PDU-PCARD-PROGRAM PK
PCARD_PROGRAM		Alpha 10—PD10.2, PD10.3, PD20.1, PD20.2, PD20.3, PD21.1, PD22.1
#PDU-PCARD-NBR PK
PCARD_NBR		Alpha 16—PD10.2, PD10.3, PD20.1, PD20.2, PD20.3, PD21.1, PD22.1
#PDU-PD-AUDIT-TYPE PK
PD_AUDIT_TYPE		Alpha 1—
  • 1 Card
  • 2 Charge
PD10.2, PD10.3, PD20.1, PD20.2, PD20.3, PD21.1, PD22.1
#PDU-ACTION PK
ACTION		Alpha 1—
  • A Add
  • C Change
  • L Cancel
  • D Delete
PD10.2, PD10.3, PD20.1, PD20.2, PD20.3, PD21.1, PD22.1
#PDU-FIELD-NBR PK
FIELD_NBR		Numeric 3—PD10.2, PD10.3, PD20.1, PD20.2, PD20.3, PD21.1, PD22.1
#PDU-BEFORE-VALUE
BEFORE_VALUE		Alpha 35This field contains the field image before the change.PD10.2, PD10.3, PD20.1, PD20.2, PD20.3, PD21.1, PD22.1
#PDU-AFTER-VALUE
AFTER_VALUE		Alpha 35This field contains the field image before the change.PD10.2, PD10.3, PD20.1, PD20.2, PD20.3, PD21.1, PD22.1
#PDU-USER PK
USER		Alpha 10 (Lower Case)—PD10.2, PD10.3, PD20.1, PD20.2, PD20.3, PD21.1, PD22.1
#PDU-DATE PK
DATE		Numeric 8 (yyyymmdd)This field contains the date the record was updated.PD10.2, PD10.3, PD20.1, PD20.2, PD20.3, PD21.1, PD22.1
#PDU-TIME PK
TIME		Numeric 6This field contains the system time when the record was updated.PD10.2, PD10.3, PD20.1, PD20.2, PD20.3, PD21.1, PD22.1
#PDU-SEQ PK
SEQ		Numeric 3This field contains the record sequence number.PD10.3, PD20.1, PD20.2, PD20.3, PD21.1, PD22.1
#PDU-TXN-NBR SET2
TXN_NBR		Alpha 22—PD10.2, PD10.3, PD20.1, PD20.2, PD20.3, PD21.1, PD22.1
#PDU-STATEMENT SET2
STATEMENT		Alpha 22Used to identify the invoice.PD10.2, PD10.3, PD20.1, PD20.2, PD20.3, PD21.1, PD22.1

Indexes (2)

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
PDUSET1
  1. PCARD-PROGRAM
  2. PCARD-NBR
  3. PD-AUDIT-TYPE
  4. ACTION
  5. FIELD-NBR
  6. USER
  7. DATE
  8. TIME
  9. SEQ
PrimaryPD20.1, PD260, PD60.1
PDUSET2
  1. PCARD-PROGRAM
  2. PCARD-NBR
  3. STATEMENT
  4. TXN-NBR
  5. PD-AUDIT-TYPE
  6. ACTION
  7. FIELD-NBR
  8. USER
  9. DATE
  10. TIME
  11. SEQ
SubsetWhere PD-AUDIT-TYPE = "2"—

Programs

Updated by (8)

Referenced by (1)