MARULAUD – Matching Rules Audit

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

MARULAUD is the Matching Rules Audit table in Lawson Matching (prefix MRU). It is indexed by MATCH-RULE, ACTION, DATE, TIME, UNIQUE-I-D (MRUSET1); alternate indexes: MRUSET2, MRUSET3, MRUSET4 and MRUUID. It is related 1:1 to MADICT and MAMTCHRULE. It is updated by MA00.1, MA00.4, MA01.1 and MA189 and referenced by MA89.3. The table has 12 fields, 5 indexes and 2 documented relations.

About MARULAUD

No description in the Lawson data dictionary.

Fields (12)

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

Field / column	Type	Description & values	Updated by
`MRU-UNIQUE-I-D` PK UNIQUE_I_D	Bad Type 36	—	—
`MRU-MATCH-RULE` PK MATCH_RULE	Alpha 10	—	MA00.1, MA00.4, MA01.1
`MRU-ACTION` PK ACTION	Alpha 1	—	MA00.1, MA00.4, MA01.1
`MRU-OPERATOR` OPERATOR	Alpha 10	—	MA00.1, MA00.4, MA01.1
`MRU-DATE` PK DATE	Numeric 8 (yyyymmdd)	—	MA00.1, MA00.4, MA01.1
`MRU-TIME` PK TIME	Numeric 6 (hhmmss)	—	MA00.1, MA00.4, MA01.1
`MRU-PROGRAM` PROGRAM	Alpha 5	—	MA00.1, MA00.4, MA01.1
`MRU-FIELD-NAME` FIELD_NAME	Alpha 15	—	MA00.1, MA00.4, MA01.1
`MRU-FIELD-NBR` FIELD_NBR	Numeric 3	—	MA00.1, MA00.4, MA01.1
`MRU-OLD-VALUE` OLD_VALUE	Alpha 60 (Lower Case)	—	MA00.1, MA00.4, MA01.1
`MRU-NEW-VALUE` NEW_VALUE	Alpha 60 (Lower Case)	—	MA00.1, MA00.4, MA01.1
`MRU-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
`MRUSET1`	`MATCH-RULE`, `ACTION`, `DATE`, `TIME`, `UNIQUE-I-D`	Primary	MA189, MA89.3
`MRUSET2`	`MATCH-RULE`, `DATE`, `TIME`, `ACTION`, `UNIQUE-I-D`		—
`MRUSET3`	`MATCH-RULE`, `OPERATOR`, `ACTION`, `DATE`, `TIME`, `UNIQUE-I-D`		—
`MRUSET4`	`MATCH-RULE`, `FIELD-NAME`, `DATE`, `TIME`, `UNIQUE-I-D`		—
`MRUUID`	`UNIQUE-I-D`		—

Relations

One to one (2) — lookups and parents

Relation	Table	Rules	Condition	Field map
Dictionary	MADICT	Required		`MRU-DB-FILE-PFX` → `MDC-DB-FILE-PFX (MDCSET1)`, `MRU-FIELD-NBR` → `MDC-FIELD-NBR`
Match Rule	MAMTCHRULE	Required		`MRU-MATCH-RULE` → `MAU-MATCH-RULE`

MARULAUD – Matching Rules Audit

About MARULAUD

Fields (12)

Indexes (5)

Relations

One to one (2) — lookups and parents

Programs

Updated by (4)

Referenced by (1)