APPRCLVAUD – AP Process Level Audit

System
Accounts Payable (AP)
Prefix
LVA
Primary key
COMPANY, PROCESS-LEVEL, ACTION, DATE, TIME, UNIQUE-I-D
Fields
15
Updated by
4 programs
Referenced by
1 program

APPRCLVAUD is the AP Process Level Audit table in Lawson Accounts Payable (prefix LVA). It is indexed by COMPANY, PROCESS-LEVEL, ACTION, DATE, TIME, UNIQUE-I-D (LVASET1); alternate indexes: LVASET2, LVASET3, LVASET4, LVASET5 and LVAUID. It is related 1:1 to APDICT2 and APPROCLEV. It is updated by AP00.5, AP101, AP189 and MAPL.1 and referenced by AP89.3. The table has 15 fields, 6 indexes and 2 documented relations.

About APPRCLVAUD

No description in the Lawson data dictionary.

Fields (15)

Column = COBOL field name without the LVA- 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
#LVA-UNIQUE-I-D PK
UNIQUE_I_D		Bad Type 36——
#LVA-COMPANY PK
COMPANY		Numeric 4—AP00.5, AP101, MAPL.1
#LVA-PROCESS-LEVEL PK
PROCESS_LEVEL		Alpha 5—AP00.5, AP101, MAPL.1
#LVA-PAY-GROUP SET2
PAY_GROUP		Alpha 4—AP00.5, AP101, MAPL.1
#LVA-ACTION PK
ACTION		Alpha 1—AP00.5, AP101, MAPL.1
#LVA-OPERATOR SET4
OPERATOR		Alpha 10—AP00.5, AP101, MAPL.1
#LVA-DATE PK
DATE		Numeric 8 (yyyymmdd)—AP00.5, AP101, MAPL.1
#LVA-TIME PK
TIME		Numeric 6 (hhmmss)—AP00.5, AP101, MAPL.1
#LVA-PROGRAM
PROGRAM		Alpha 5—AP00.5, AP101, MAPL.1
#LVA-FLD-NAME SET5
FLD_NAME		Alpha 15—AP00.5, AP101, MAPL.1
#LVA-FLD-NBR
FLD_NBR		Numeric 4—AP00.5, AP101, MAPL.1
#LVA-OLD-VALUE
OLD_VALUE		Alpha 60 (Lower Case)—AP00.5, AP101, MAPL.1
#LVA-NEW-VALUE
NEW_VALUE		Alpha 60 (Lower Case)—AP00.5, AP101, MAPL.1
#LVA-DB-FILE-PFX
DB_FILE_PFX		Alpha 3—AP00.5, AP101, MAPL.1
#LVA-FIELD-DESC
FIELD_DESC		Derived——

Indexes (6)

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
LVASET1
  1. COMPANY
  2. PROCESS-LEVEL
  3. ACTION
  4. DATE
  5. TIME
  6. UNIQUE-I-D
PrimaryAP189, AP89.3
LVASET2
  1. COMPANY
  2. PROCESS-LEVEL
  3. PAY-GROUP
  4. ACTION
  5. DATE
  6. TIME
  7. UNIQUE-I-D
KeyChange—
LVASET3
  1. COMPANY
  2. PROCESS-LEVEL
  3. DATE
  4. TIME
  5. ACTION
  6. UNIQUE-I-D
KeyChange—
LVASET4
  1. COMPANY
  2. PROCESS-LEVEL
  3. OPERATOR
  4. DATE
  5. TIME
  6. UNIQUE-I-D
KeyChange—
LVASET5
  1. COMPANY
  2. PROCESS-LEVEL
  3. FLD-NAME
  4. ACTION
  5. DATE
  6. TIME
  7. UNIQUE-I-D
KeyChange—
LVAUID
  1. UNIQUE-I-D
—

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
APDICT2APPROCLEVAPPRCLVAUD

One to one (2) — lookups and parents

RelationTableRulesConditionField map
DictionaryAPDICT2Required
LVA-DB-FILE-PFX→AP2-DB-FILE-PFX (AP2SET1)
LVA-FLD-NBR→AP2-FLD-NBR
Process LevelAPPROCLEVRequired
LVA-COMPANY→APR-COMPANY
LVA-PROCESS-LEVEL→APR-PROC-LEVEL

Programs

Updated by (4)

Referenced by (1)