PDUAUDIT – No description in the Lawson data dictionary

System
Purchase Order (PO)
Prefix
PDB
Primary key
PROCURE-GROUP, CARD-USER-ID, DATE, TIME, FLD-NBR
Fields
8
Updated by
2 programs
Referenced by
1 program

PDUAUDIT is a Lawson Purchase Order table (prefix PDB); no description in the lawson data dictionary. It is indexed by PROCURE-GROUP, CARD-USER-ID, DATE, TIME, FLD-NBR (PDBSET1). It is updated by PD00.1 and PD261 and referenced by PD61.1. The table has 8 fields, 1 index and 0 documented relations.

About PDUAUDIT

No description in the Lawson data dictionary.

Fields (8)

Column = COBOL field name without the PDB- 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
#PDB-PROCURE-GROUP PK
PROCURE_GROUP		Alpha 4—PD00.1
#PDB-CARD-USER-ID PK
CARD_USER_ID		Alpha 10 (Lower Case)—PD00.1
#PDB-DATE PK
DATE		Numeric 8 (yyyymmdd)—PD00.1
#PDB-TIME PK
TIME		Numeric 8—PD00.1
#PDB-FLD-NBR PK
FLD_NBR		Numeric 4—PD00.1
#PDB-BEFORE-IMAGE
BEFORE_IMAGE		Alpha 60—PD00.1
#PDB-AFTER-IMAGE
AFTER_IMAGE		Alpha 60—PD00.1
#PDB-OPERATOR-ID
OPERATOR_ID		Alpha 10—PD00.1

Indexes (1)

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
PDBSET1
  1. PROCURE-GROUP
  2. CARD-USER-ID
  3. DATE
  4. TIME
  5. FLD-NBR
PrimaryPD00.1, PD261, PD61.1

Programs

Updated by (2)

Referenced by (1)