AMAUGRPAU – AM Accounting Unit Group Audit

System
Asset Management (AM)
Prefix
AUA
Primary key
COMPANY, AU-GROUP, ACTION, DATE, TIME, UNIQUE-I-D
Fields
12
Updated by
302 programs
Referenced by
76 programs

AMAUGRPAU is the AM Accounting Unit Group Audit table in Lawson Asset Management (prefix AUA). It is indexed by COMPANY, AU-GROUP, ACTION, DATE, TIME, UNIQUE-I-D (AUASET1); alternate indexes: AUASET2, AUASET3, AUASET4, AUASET5 and AUAUID. It is related 1:1 to AMAUGROUP. 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.5, BR44.1, CB222, CU00.1, CU01.1, CU01.2 and 68 more. The table has 12 fields, 6 indexes and 1 documented relation.

About AMAUGRPAU

No description in the Lawson data dictionary.

Fields (12)

Column = COBOL field name without the AUA- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
AUA-UNIQUE-I-D PK
UNIQUE_I_D		Bad Type 36——
AUA-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)
AUA-AU-GROUP PK
AU_GROUP		Alpha 10—AC10.1, AC10.3, AC160, AC56.1, AC560, AC71.1, AM05.1, AM06.1 +52 more (list truncated in source)
AUA-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)
AUA-OPERATOR
OPERATOR		Alpha 10—AC10.1, AC10.3, AC160, AC56.1, AC560, AC71.1, AM05.1, AM06.1 +52 more (list truncated in source)
AUA-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)
AUA-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)
AUA-PROGRAM
PROGRAM		Alpha 5—AC10.1, AC10.3, AC160, AC56.1, AC560, AC71.1, AM05.1, AM06.1 +52 more (list truncated in source)
AUA-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)
AUA-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)
AUA-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)
AUA-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 (6)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
AUASET1COMPANY, AU-GROUP, ACTION, DATE, TIME, UNIQUE-I-DPrimaryAC191, AM288, AM82.5, AP125, AP126, AP20.1, AP20.2, AP20.3 +22 more (list truncated in source)
AUASET2AU-GROUP, COMPANY, ACTION, DATE, TIME, UNIQUE-I-D—
AUASET3OPERATOR, ACTION, DATE, COMPANY, AU-GROUP, UNIQUE-I-DAM305
AUASET4ACTION, DATE, COMPANY, AU-GROUP, UNIQUE-I-D—
AUASET5DATE, ACTION, COMPANY, AU-GROUP, UNIQUE-I-DAM305
AUAUIDUNIQUE-I-D—

Relations

One to one (1) — lookups and parents

RelationTableRulesConditionField map
AmaugroupAMAUGROUPRequiredAUA-COMPANY → AAU-COMPANY (AAUSET1), AUA-AU-GROUP → AAU-AU-GROUP

Programs

Updated by (302)

Referenced by (76)