ACDETAILAU – CA Alloc Code Detail Audit

System
General Ledger (GL)
Prefix
ALU
Primary key
ALLOC-CODE, COMPANY, ACCT-UNIT, ACTION, DATE, TIME, UNIQUE-I-D
Fields
13
Updated by
69 programs
Referenced by
75 programs

ACDETAILAU is the CA Alloc Code Detail Audit table in Lawson General Ledger (prefix ALU). It is indexed by ALLOC-CODE, COMPANY, ACCT-UNIT, ACTION, DATE, TIME, UNIQUE-I-D (ALUSET1); alternate indexes: ALUSET2, ALUSET3, ALUSET4, ALUSET5 and ALUUID. It is related 1:1 to ACDETAIL. It is updated by AP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7 and 61 more and referenced by AC191, API1.1, API2.1, BR44.1, CA278, CA91.4, CB222, CU00.1 and 67 more. The table has 13 fields, 6 indexes and 1 documented relation.

About ACDETAILAU

No description in the Lawson data dictionary.

Fields (13)

Column = COBOL field name without the ALU- 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
#ALU-UNIQUE-I-D PK
UNIQUE_I_D		Bad Type 36——
#ALU-ALLOC-CODE PK
ALLOC_CODE		Alpha 12—AP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7 +52 more (list truncated in source)
#ALU-COMPANY PK
COMPANY		Numeric 4—AP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7 +52 more (list truncated in source)
#ALU-ACCT-UNIT PK
ACCT_UNIT		Alpha 15—AP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7 +52 more (list truncated in source)
#ALU-ACTION PK
ACTION		Alpha 1—
  • A Add
  • C Change
  • D Delete
AP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7 +52 more (list truncated in source)
#ALU-OPERATOR SET3
OPERATOR		Alpha 10—AP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7 +52 more (list truncated in source)
#ALU-DATE PK
DATE		Numeric 8 (yyyymmdd)—AP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7 +52 more (list truncated in source)
#ALU-TIME PK
TIME		Numeric 6 (hhmmss)—AP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7 +52 more (list truncated in source)
#ALU-PROGRAM
PROGRAM		Alpha 5—AP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7 +52 more (list truncated in source)
#ALU-FIELD-NAME
FIELD_NAME		Alpha 20 (Lower Case)—AP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7 +52 more (list truncated in source)
#ALU-FIELD-ID
FIELD_ID		Numeric 3—AP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7 +52 more (list truncated in source)
#ALU-OLD-VALUE
OLD_VALUE		Alpha 60 (Lower Case)—AP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7 +52 more (list truncated in source)
#ALU-NEW-VALUE
NEW_VALUE		Alpha 60 (Lower Case)—AP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7 +52 more (list truncated in source)

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
ALUSET1
  1. ALLOC-CODE
  2. COMPANY
  3. ACCT-UNIT
  4. ACTION
  5. DATE
  6. TIME
  7. UNIQUE-I-D
PrimaryAC191, AP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source)
ALUSET2
  1. ALLOC-CODE
  2. ACTION
  3. DATE
  4. COMPANY
  5. ACCT-UNIT
  6. TIME
  7. UNIQUE-I-D
—
ALUSET3
  1. OPERATOR
  2. ACTION
  3. DATE
  4. ALLOC-CODE
  5. COMPANY
  6. ACCT-UNIT
  7. TIME
  8. UNIQUE-I-D
—
ALUSET4
  1. ACTION
  2. DATE
  3. ALLOC-CODE
  4. COMPANY
  5. ACCT-UNIT
  6. TIME
  7. UNIQUE-I-D
—
ALUSET5
  1. DATE
  2. ALLOC-CODE
  3. ACTION
  4. COMPANY
  5. ACCT-UNIT
  6. TIME
  7. UNIQUE-I-D
CA305
ALUUID
  1. UNIQUE-I-D
—

Relations

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

One to one (1) — lookups and parents

RelationTableRulesConditionField map
AcdetailACDETAILRequired
ALU-ALLOC-CODE→ALD-ALLOC-CODE (ALDSET1)
ALU-COMPANY→ALD-COMPANY
ALU-ACCT-UNIT→ALD-ACCT-UNIT

Programs

Updated by (69)

Referenced by (75)