APCOMPAUD – AP Company Audit

System
Accounts Payable (AP)
Prefix
CAP
Primary key
COMPANY, ACTION, DATE, TIME, UNIQUE-I-D
Fields
19
Updated by
5 programs
Referenced by
1 program

APCOMPAUD is the AP Company Audit table in Lawson Accounts Payable (prefix CAP). It is indexed by COMPANY, ACTION, DATE, TIME, UNIQUE-I-D (CAPSET1); alternate indexes: CAPSET2, CAPSET3, CAPSET4, CAPSET5, CAPSET6, CAPSET7, CAPSET8, CAPSET9 and 1 more. It is related 1:1 to APCOMPANY and APDICT2. It is updated by AP00.4, AP00.6, AP00.7, AP101 and AP189 and referenced by AP89.1. The table has 19 fields, 10 indexes and 2 documented relations.

About APCOMPAUD

No description in the Lawson data dictionary.

Fields (19)

Column = COBOL field name without the CAP- 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
#CAP-UNIQUE-I-D PK
UNIQUE_I_D		Bad Type 36——
#CAP-COMPANY PK
COMPANY		Numeric 4—AP00.4, AP00.6, AP00.7, AP101
#CAP-VENDOR-GROUP SET2 SET7
VENDOR_GROUP		Alpha 4—AP00.4, AP00.6, AP00.7, AP101
#CAP-PAY-GROUP SET3
PAY_GROUP		Alpha 4—AP00.4, AP00.6, AP00.7, AP101
#CAP-ACTION PK
ACTION		Alpha 1—
  • A Add
  • D Delete
  • C Change
AP00.4, AP00.6, AP00.7, AP101
#CAP-OPERATOR SET5
OPERATOR		Alpha 10—AP00.4, AP00.6, AP00.7, AP101
#CAP-DATE PK
DATE		Numeric 8 (yyyymmdd)—AP00.4, AP00.6, AP00.7, AP101
#CAP-TIME PK
TIME		Numeric 6 (hhmmss)—AP00.4, AP00.6, AP00.7, AP101
#CAP-PROGRAM
PROGRAM		Alpha 5—AP00.4, AP00.6, AP00.7, AP101
#CAP-FLD-NAME SET6
FLD_NAME		Alpha 15—AP00.4, AP00.6, AP00.7, AP101
#CAP-FLD-NBR
FLD_NBR		Numeric 4—AP00.4, AP00.6, AP00.7, AP101
#CAP-OLD-VALUE
OLD_VALUE		Alpha 60 (Lower Case)—AP00.4, AP00.6, AP00.7, AP101
#CAP-NEW-VALUE
NEW_VALUE		Alpha 60 (Lower Case)—AP00.4, AP00.6, AP00.7, AP101
#CAP-DB-FILE-PFX
DB_FILE_PFX		Alpha 3—AP00.4, AP00.6, AP00.7, AP101
#CAP-USER-FLD-TYPE SET7
USER_FLD_TYPE		Alpha 1—AP00.4, AP00.6, AP00.7, AP101
#CAP-APPROVAL-TYPE SET8
APPROVAL_TYPE		Alpha 1—AP00.4, AP00.6, AP00.7, AP101
#CAP-PROC-LEVEL SET8
PROC_LEVEL		Alpha 5—AP00.4, AP00.6, AP00.7, AP101
#CAP-FIELD-DESC
FIELD_DESC		Derived——
#CAP-ACCT-STRCT SET9
ACCT_STRCT		Alpha 15—AP00.4, AP00.6, AP00.7, AP101

Indexes (10)

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
CAPSET1
  1. COMPANY
  2. ACTION
  3. DATE
  4. TIME
  5. UNIQUE-I-D
PrimaryAP189, AP89.1
CAPSET2
  1. VENDOR-GROUP
  2. COMPANY
  3. ACTION
  4. DATE
  5. TIME
  6. UNIQUE-I-D
KeyChange—
CAPSET3
  1. PAY-GROUP
  2. COMPANY
  3. ACTION
  4. DATE
  5. TIME
  6. UNIQUE-I-D
KeyChange—
CAPSET4
  1. COMPANY
  2. DATE
  3. TIME
  4. ACTION
  5. UNIQUE-I-D
KeyChange—
CAPSET5
  1. COMPANY
  2. OPERATOR
  3. ACTION
  4. DATE
  5. TIME
  6. UNIQUE-I-D
KeyChange—
CAPSET6
  1. COMPANY
  2. FLD-NAME
  3. ACTION
  4. DATE
  5. TIME
  6. UNIQUE-I-D
KeyChange—
CAPSET7
  1. COMPANY
  2. USER-FLD-TYPE
  3. VENDOR-GROUP
  4. UNIQUE-I-D
KeyChange—
CAPSET8
  1. APPROVAL-TYPE
  2. COMPANY
  3. PROC-LEVEL
  4. UNIQUE-I-D
KeyChange—
CAPSET9
  1. COMPANY
  2. ACCT-STRCT
  3. UNIQUE-I-D
—
CAPUID
  1. UNIQUE-I-D
—

Relations

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

One to one (2) — lookups and parents

RelationTableRulesConditionField map
CompanyAPCOMPANYRequired
CAP-COMPANY→CPY-COMPANY (CPYSET1)
DictionaryAPDICT2Required
CAP-DB-FILE-PFX→AP2-DB-FILE-PFX
CAP-FLD-NBR→AP2-FLD-NBR

Programs

Updated by (5)

Referenced by (1)