AMSYSOPTAU – No description in the Lawson data dictionary

System: Asset Management (AM)
Prefix: AOA
Primary key: COMPANY, CREATION-DATE, CREATION-TIME, ACTION, DATE, TIME, UNIQUE-I-D
Fields: 13
Updated by: 0 programs
Referenced by: 0 programs

AMSYSOPTAU is a Lawson Asset Management table (prefix AOA); no description in the lawson data dictionary. It is indexed by COMPANY, CREATION-DATE, CREATION-TIME, ACTION, DATE, TIME, UNIQUE-I-D (AOASET1); alternate indexes: AOASET2, AOASET3, AOASET4, AOASET5 and AOAUID. It is related 1:1 to AMSYSOPTS. The table has 13 fields, 6 indexes and 1 documented relation.

About AMSYSOPTAU

No description in the Lawson data dictionary.

Fields (13)

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

Field / column	Type	Description & values	Updated by
`AOA-UNIQUE-I-D` PK UNIQUE_I_D	Bad Type 36	—	—
`AOA-COMPANY` PK COMPANY	Numeric 4	—	—
`AOA-CREATION-DATE` PK CREATION_DATE	Numeric 8 (yyyymmdd)	—	—
`AOA-CREATION-TIME` PK CREATION_TIME	Numeric 6 (hhmmss)	—	—
`AOA-ACTION` PK ACTION	Alpha 1	—	—
`AOA-OPERATOR` OPERATOR	Alpha 10	—	—
`AOA-DATE` PK DATE	Numeric 8 (yyyymmdd)	—	—
`AOA-TIME` PK TIME	Numeric 6 (hhmmss)	—	—
`AOA-PROGRAM` PROGRAM	Alpha 5	—	—
`AOA-FIELD-NAME` FIELD_NAME	Alpha 20 (Lower Case)	—	—
`AOA-FIELD-ID` FIELD_ID	Numeric 3	—	—
`AOA-OLD-VALUE` OLD_VALUE	Alpha 60 (Lower Case)	—	—
`AOA-NEW-VALUE` NEW_VALUE	Alpha 60 (Lower Case)	—	—

Indexes (6)

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

Index	Keys	Flags	Used in
`AOASET1`	`COMPANY`, `CREATION-DATE`, `CREATION-TIME`, `ACTION`, `DATE`, `TIME`, `UNIQUE-I-D`	Primary	AC191, AP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source)
`AOASET2`	`COMPANY`, `ACTION`, `DATE`, `TIME`, `UNIQUE-I-D`		—
`AOASET3`	`OPERATOR`, `ACTION`, `DATE`, `COMPANY`, `UNIQUE-I-D`		—
`AOASET4`	`ACTION`, `DATE`, `COMPANY`, `UNIQUE-I-D`		—
`AOASET5`	`DATE`, `ACTION`, `COMPANY`, `UNIQUE-I-D`		—
`AOAUID`	`UNIQUE-I-D`		—

Relations

One to one (1) — lookups and parents

Relation	Table	Rules	Condition	Field map
Amsysopts	AMSYSOPTS	Required		`AOA-COMPANY` → `AMO-COMPANY (AMOSET1)`, `AOA-CREATION-DATE` → `AMO-CREATION-DATE`, `AOA-CREATION-TIME` → `AMO-CREATION-TIME`

Programs

No Lawson programs are documented as updating or referencing this table.