LMLSEMXAU – Lease Attributes Audit

System: LM (LM)
Prefix: LXA
Primary key: OBJ-ID, MATRIX-CAT, COMPANY, LEASE, ACTION, DATE, TIME, UNIQUE-I-D
Fields: 14
Updated by: 1 program
Referenced by: 0 programs

LMLSEMXAU is the Lease Attributes Audit table in Lawson LM (prefix LXA). It is indexed by OBJ-ID, MATRIX-CAT, COMPANY, LEASE, ACTION, DATE, TIME, UNIQUE-I-D (LXASET1); alternate indexes: LXASET2, LXASET3, LXASET4, LXASET5, LXASET6 and LXAUID. It is related 1:1 to LMLSEMXVAL. It is updated by MX500. The table has 14 fields, 7 indexes and 1 documented relation.

About LMLSEMXAU

No description in the Lawson data dictionary.

Fields (14)

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

Field / column	Type	Description & values	Updated by
`LXA-UNIQUE-I-D` PK UNIQUE_I_D	Bad Type 36	—	—
`LXA-OBJ-ID` PK OBJ_ID	Numeric 12	—	MX500
`LXA-MATRIX-CAT` PK MATRIX_CAT	Alpha 12	—	MX500
`LXA-COMPANY` PK COMPANY	Numeric 4	—	MX500
`LXA-LEASE` PK LEASE	Alpha 19	—	MX500
`LXA-ACTION` PK ACTION	Alpha 1	—	MX500
`LXA-OPERATOR` OPERATOR	Alpha 10	—	MX500
`LXA-DATE` PK DATE	Numeric 8 (yyyymmdd)	—	MX500
`LXA-TIME` PK TIME	Numeric 6 (hhmmss)	—	MX500
`LXA-PROGRAM` PROGRAM	Alpha 5	—	MX500
`LXA-FIELD-NAME` FIELD_NAME	Alpha 20 (Lower Case)	—	MX500
`LXA-FIELD-ID` FIELD_ID	Numeric 3	—	MX500
`LXA-OLD-VALUE` OLD_VALUE	Alpha 60 (Lower Case)	—	MX500
`LXA-NEW-VALUE` NEW_VALUE	Alpha 60 (Lower Case)	—	MX500

Indexes (7)

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

Index	Keys	Flags	Used in
`LXASET1`	`OBJ-ID`, `MATRIX-CAT`, `COMPANY`, `LEASE`, `ACTION`, `DATE`, `TIME`, `UNIQUE-I-D`	Primary	—
`LXASET2`	`MATRIX-CAT`, `COMPANY`, `LEASE`, `OBJ-ID`, `ACTION`, `DATE`, `TIME`, `UNIQUE-I-D`		—
`LXASET3`	`COMPANY`, `LEASE`, `MATRIX-CAT`, `OBJ-ID`, `ACTION`, `DATE`, `TIME`, `UNIQUE-I-D`		—
`LXASET4`	`OPERATOR`, `ACTION`, `DATE`, `OBJ-ID`, `MATRIX-CAT`, `COMPANY`, `LEASE`, `UNIQUE-I-D`		—
`LXASET5`	`ACTION`, `DATE`, `OBJ-ID`, `MATRIX-CAT`, `COMPANY`, `LEASE`, `UNIQUE-I-D`		—
`LXASET6`	`DATE`, `COMPANY`, `LEASE`, `MATRIX-CAT`, `OBJ-ID`, `ACTION`, `UNIQUE-I-D`		—
`LXAUID`	`UNIQUE-I-D`		—

Relations

One to one (1) — lookups and parents

Relation	Table	Rules	Condition	Field map
Lmlsemxval	LMLSEMXVAL	Required		`LXA-OBJ-ID` → `LXV-OBJ-ID (LXVSET1)`, `LXA-MATRIX-CAT` → `LXV-MATRIX-CAT`

Programs

Updated by (1)

MX500 Attribute Value Population