MAMTTAUD – Match Table Audit

System: Matching (MA)
Prefix: MTT
Primary key: MATCH-TABLE, ACTION, DATE, TIME, UNIQUE-I-D
Fields: 12
Updated by: 4 programs
Referenced by: 1 program

MAMTTAUD is the Match Table Audit table in Lawson Matching (prefix MTT). It is indexed by MATCH-TABLE, ACTION, DATE, TIME, UNIQUE-I-D (MTTSET1); alternate indexes: MTTSET2, MTTSET3, MTTSET4 and MTTUID. It is related 1:1 to MADICT and MAMATCHTBL. It is updated by MA00.1, MA00.4, MA01.1 and MA189 and referenced by MA89.2. The table has 12 fields, 5 indexes and 2 documented relations.

About MAMTTAUD

No description in the Lawson data dictionary.

Fields (12)

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

Field / column	Type	Description & values	Updated by
`MTT-UNIQUE-I-D` PK UNIQUE_I_D	Bad Type 36	—	—
`MTT-MATCH-TABLE` PK MATCH_TABLE	Alpha 10	—	MA00.1, MA00.4, MA01.1
`MTT-ACTION` PK ACTION	Alpha 1	—	MA00.1, MA00.4, MA01.1
`MTT-OPERATOR` OPERATOR	Alpha 10	—	MA00.1, MA00.4, MA01.1
`MTT-DATE` PK DATE	Numeric 8 (yyyymmdd)	—	MA00.1, MA00.4, MA01.1
`MTT-TIME` PK TIME	Numeric 6 (hhmmss)	—	MA00.1, MA00.4, MA01.1
`MTT-PROGRAM` PROGRAM	Alpha 5	—	MA00.1, MA00.4, MA01.1
`MTT-FLD-NAME` FLD_NAME	Alpha 15	—	MA00.1, MA00.4, MA01.1
`MTT-FLD-NBR` FLD_NBR	Numeric 4	—	MA00.1, MA00.4, MA01.1
`MTT-OLD-VALUE` OLD_VALUE	Alpha 60 (Lower Case)	—	MA00.1, MA00.4, MA01.1
`MTT-NEW-VALUE` NEW_VALUE	Alpha 60 (Lower Case)	—	MA00.1, MA00.4, MA01.1
`MTT-DB-FILE-PFX` DB_FILE_PFX	Alpha 3	—	—

Indexes (5)

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

Index	Keys	Flags	Used in
`MTTSET1`	`MATCH-TABLE`, `ACTION`, `DATE`, `TIME`, `UNIQUE-I-D`	Primary	MA189, MA89.2
`MTTSET2`	`MATCH-TABLE`, `DATE`, `TIME`, `ACTION`, `UNIQUE-I-D`		—
`MTTSET3`	`MATCH-TABLE`, `OPERATOR`, `ACTION`, `DATE`, `TIME`, `UNIQUE-I-D`		—
`MTTSET4`	`MATCH-TABLE`, `FLD-NAME`, `ACTION`, `DATE`, `TIME`, `UNIQUE-I-D`		—
`MTTUID`	`UNIQUE-I-D`		—

Relations

One to one (2) — lookups and parents

Relation	Table	Rules	Condition	Field map
Dictionary	MADICT	Required		`MTT-DB-FILE-PFX` → `MDC-DB-FILE-PFX (MDCSET1)`, `MTT-FLD-NBR` → `MDC-FIELD-NBR`
Match Table	MAMATCHTBL	Required		`MTT-MATCH-TABLE` → `MAM-MATCH-TABLE`

MAMTTAUD – Match Table Audit

About MAMTTAUD

Fields (12)

Indexes (5)

Relations

One to one (2) — lookups and parents

Programs

Updated by (4)

Referenced by (1)