AMACCTAU – Asset Account Audit

System
Asset Management (AM)
Prefix
AAA
Primary key
COMPANY, ACCT-GRP, ASSET-TYPE, SUB-TYPE, ACCT-TYPE, ASSET-EVENT, ACTION, DATE, TIME, UNIQUE-I-D
Fields
16
Updated by
302 programs
Referenced by
76 programs

AMACCTAU is the Asset Account Audit table in Lawson Asset Management (prefix AAA). It is indexed by COMPANY, ACCT-GRP, ASSET-TYPE, SUB-TYPE, ACCT-TYPE, ASSET-EVENT, ACTION, DATE, TIME, UNIQUE-I-D (AAASET1); alternate indexes: AAASET2, AAASET3, AAASET4, AAASET5, AAASET6 and AAAUID. It is related 1:1 to AMACCOUNT. It is updated by AC10.1, AC10.3, AC160, AC56.1, AC560, AC71.1, AM05.1, AM06.1 and 294 more and referenced by AC191, AM288, AM82.3, BR44.1, CB222, CU00.1, CU01.1, CU01.2 and 68 more. The table has 16 fields, 7 indexes and 1 documented relation.

About AMACCTAU

No description in the Lawson data dictionary.

Fields (16)

Column = COBOL field name without the AAA- 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
#AAA-UNIQUE-I-D PK
UNIQUE_I_D		Bad Type 36——
#AAA-COMPANY PK
COMPANY		Numeric 4—AC10.1, AC10.3, AC160, AC56.1, AC560, AC71.1, AM05.1, AM06.1 +52 more (list truncated in source)
#AAA-ACCT-GRP PK
ACCT_GRP		Alpha 10—AC10.1, AC10.3, AC160, AC56.1, AC560, AC71.1, AM05.1, AM06.1 +52 more (list truncated in source)
#AAA-ASSET-TYPE PK
ASSET_TYPE		Alpha 10—AC10.1, AC10.3, AC160, AC56.1, AC560, AC71.1, AM05.1, AM06.1 +52 more (list truncated in source)
#AAA-SUB-TYPE PK
SUB_TYPE		Alpha 10—AC10.1, AC10.3, AC160, AC56.1, AC560, AC71.1, AM05.1, AM06.1 +52 more (list truncated in source)
#AAA-ACCT-TYPE PK
ACCT_TYPE		Alpha 3—AC10.1, AC10.3, AC160, AC56.1, AC560, AC71.1, AM05.1, AM06.1 +52 more (list truncated in source)
#AAA-ASSET-EVENT PK
ASSET_EVENT		Alpha 1—AC10.1, AC10.3, AC160, AC56.1, AC560, AC71.1, AM05.1, AM06.1 +52 more (list truncated in source)
#AAA-ACTION PK
ACTION		Alpha 1—AC10.1, AC10.3, AC160, AC56.1, AC560, AC71.1, AM05.1, AM06.1 +52 more (list truncated in source)
#AAA-OPERATOR SET4
OPERATOR		Alpha 10—AC10.1, AC10.3, AC160, AC56.1, AC560, AC71.1, AM05.1, AM06.1 +52 more (list truncated in source)
#AAA-DATE PK
DATE		Numeric 8 (yyyymmdd)—AC10.1, AC10.3, AC160, AC56.1, AC560, AC71.1, AM05.1, AM06.1 +52 more (list truncated in source)
#AAA-TIME PK
TIME		Numeric 6 (hhmmss)—AC10.1, AC10.3, AC160, AC56.1, AC560, AC71.1, AM05.1, AM06.1 +52 more (list truncated in source)
#AAA-PROGRAM
PROGRAM		Alpha 5—AC10.1, AC10.3, AC160, AC56.1, AC560, AC71.1, AM05.1, AM06.1 +52 more (list truncated in source)
#AAA-FIELD-NAME
FIELD_NAME		Alpha 20 (Lower Case)—AC10.1, AC10.3, AC160, AC56.1, AC560, AC71.1, AM05.1, AM06.1 +52 more (list truncated in source)
#AAA-FIELD-ID
FIELD_ID		Numeric 3—AC10.1, AC10.3, AC160, AC56.1, AC560, AC71.1, AM05.1, AM06.1 +52 more (list truncated in source)
#AAA-OLD-VALUE
OLD_VALUE		Alpha 60 (Lower Case)—AC10.1, AC10.3, AC160, AC56.1, AC560, AC71.1, AM05.1, AM06.1 +52 more (list truncated in source)
#AAA-NEW-VALUE
NEW_VALUE		Alpha 60 (Lower Case)—AC10.1, AC10.3, AC160, AC56.1, AC560, AC71.1, AM05.1, AM06.1 +52 more (list truncated in source)

Indexes (7)

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
AAASET1
  1. COMPANY
  2. ACCT-GRP
  3. ASSET-TYPE
  4. SUB-TYPE
  5. ACCT-TYPE
  6. ASSET-EVENT
  7. ACTION
  8. DATE
  9. TIME
  10. UNIQUE-I-D
PrimaryAC191, AM288, AM82.3, AP125, AP126, AP20.1, AP20.2, AP20.3 +22 more (list truncated in source)
AAASET2
  1. ACCT-GRP
  2. COMPANY
  3. ACCT-TYPE
  4. ASSET-EVENT
  5. ACTION
  6. DATE
  7. TIME
  8. UNIQUE-I-D
—
AAASET3
  1. ASSET-TYPE
  2. SUB-TYPE
  3. COMPANY
  4. ACCT-TYPE
  5. ASSET-EVENT
  6. ACTION
  7. DATE
  8. TIME
  9. UNIQUE-I-D
—
AAASET4
  1. OPERATOR
  2. ACTION
  3. DATE
  4. COMPANY
  5. ACCT-GRP
  6. ASSET-TYPE
  7. SUB-TYPE
  8. ACCT-TYPE
  9. ASSET-EVENT
  10. UNIQUE-I-D
—
AAASET5
  1. ACTION
  2. DATE
  3. COMPANY
  4. ACCT-GRP
  5. ASSET-TYPE
  6. SUB-TYPE
  7. ACCT-TYPE
  8. ASSET-EVENT
  9. UNIQUE-I-D
—
AAASET6
  1. DATE
  2. ACTION
  3. COMPANY
  4. ACCT-GRP
  5. ASSET-TYPE
  6. SUB-TYPE
  7. ACCT-TYPE
  8. ASSET-EVENT
  9. UNIQUE-I-D
AM305
AAAUID
  1. UNIQUE-I-D
—

Relations

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

One to one (1) — lookups and parents

RelationTableRulesConditionField map
AmaccountAMACCOUNTRequired
AAA-COMPANY→AAC-COMPANY (AACSET1)
AAA-ACCT-GRP→AAC-ACCT-GRP
AAA-ASSET-TYPE→AAC-ASSET-TYPE
AAA-SUB-TYPE→AAC-SUB-TYPE
AAA-ACCT-TYPE→AAC-ACCT-TYPE
AAA-ASSET-EVENT→AAC-ASSET-EVENT

Programs

Updated by (302)

Referenced by (76)