PODEFAUDIT – PO Default Audit

System
Purchase Order (PO)
Prefix
PDT
Primary key
COMPANY, AUDIT-TYPE, UPDATE-DATE, UPDATE-TIME, FLD-NBR, SEQ-NBR, AUDIT-ACTION
Fields
11
Updated by
1 program
Referenced by
4 programs

PODEFAUDIT is the PO Default Audit table in Lawson Purchase Order (prefix PDT). It is indexed by COMPANY, AUDIT-TYPE, UPDATE-DATE, UPDATE-TIME, FLD-NBR, SEQ-NBR, AUDIT-ACTION (PDTSET1); alternate indexes: PDTSET2. It is updated by PO01.4 and referenced by PO00.1, PO268, PO68.1 and PO68.2. The table has 11 fields, 2 indexes and 0 documented relations.

About PODEFAUDIT

No description in the Lawson data dictionary.

Fields (11)

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

Field / columnTypeDescription & valuesUpdated by
PDT-COMPANY PK
COMPANY		Numeric 4Identifies the AP company if the resource type = V. Identifies the HR company if the resource type = E. It is blank for type A, P or Q resources.PO01.4
PDT-AUDIT-TYPE PK
AUDIT_TYPE		Alpha 2The type of source record that is being audited.
  • AU Account Unit
  • AT Account
  • AV Activity
  • AC Account Category
  • VN Vendor
  • PF Purchase From Location
  • CT Cost
  • SP One Source Document to One PO
PO01.4
PDT-AUDIT-ACTION PK
AUDIT_ACTION		Alpha 1The action (add, change, etc.) that is being audited.
  • A Add
  • C Change
PO01.4
PDT-FLD-NBR PK
FLD_NBR		Numeric 4This field contains the PO dictionary field number.PO01.4
PDT-SEQ-NBR PK
SEQ_NBR		Numeric 4An automatically assigned sequence number.PO01.4
PDT-UPDATE-DATE PK
UPDATE_DATE		Numeric 8 (yyyymmdd)This field contains the date the record was updated.PO01.4
PDT-UPDATE-TIME PK
UPDATE_TIME		Numeric 6This field contains the system time when the record was updated.PO01.4
PDT-BEFORE-IMAGE
BEFORE_IMAGE		Alpha 32This field contains the field image before the change.PO01.4
PDT-AFTER-IMAGE
AFTER_IMAGE		Alpha 32This field contains the field image before the change.PO01.4
PDT-USER-ID
USER_ID		Alpha 10 (Lower Case)—PO01.4
PDT-DESCRIPTION
DESCRIPTION		Alpha 30 (Lower Case)This field displays the description.PO01.4

Indexes (2)

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

IndexKeysFlagsConditionUsed in
PDTSET1COMPANY, AUDIT-TYPE, UPDATE-DATE*, UPDATE-TIME*, FLD-NBR, SEQ-NBR*, AUDIT-ACTIONPrimaryPO00.1, PO268, PO68.1, PO68.2
PDTSET2COMPANY, UPDATE-DATE*, UPDATE-TIME*, AUDIT-TYPE, FLD-NBR, SEQ-NBR*, AUDIT-ACTION—

Programs

Updated by (1)

Referenced by (4)