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.

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
TXN_NBR		Alpha 22—PD10.2, PD10.3, PD20.1, PD20.2, PD20.3, PD21.1, PD22.1
PDU-STATEMENT
STATEMENT		Alpha 22Used to identify the invoice.PD10.2, PD10.3, PD20.1, PD20.2, PD20.3, PD21.1, PD22.1

Indexes (2)

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

IndexKeysFlagsConditionUsed in
PDUSET1PCARD-PROGRAM, PCARD-NBR, PD-AUDIT-TYPE, ACTION, FIELD-NBR, USER, DATE, TIME, SEQPrimaryPD20.1, PD260, PD60.1
PDUSET2PCARD-PROGRAM, PCARD-NBR, STATEMENT, TXN-NBR, PD-AUDIT-TYPE, ACTION, FIELD-NBR, USER, DATE, TIME, SEQSubsetWhere PD-AUDIT-TYPE = "2"—

Programs

Updated by (8)

Referenced by (1)