MATCHCLASS – Match Class

System
Matching (MA)
Prefix
MAL
Primary key
MATCH-CLASS
Fields
7
Updated by
2 programs
Referenced by
232 programs

MATCHCLASS is the Match Class table in Lawson Matching (prefix MAL). It is indexed by MATCH-CLASS (MALSET1). It is related 1:1 to MAMTCHELEM and 1:M to MAELMGPREL. It is updated by MA00.3 and MA01.1 and referenced by AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 and 224 more. The table has 7 fields, 1 index and 2 documented relations.

About MATCHCLASS

The Match Class file contains the match class parameters. Match classes are maintained in MA00.3 (Match Class).

Fields (7)

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

Field / columnTypeDescription & valuesUpdated by
MAL-MATCH-CLASS PK
MATCH_CLASS		Alpha 10Match classMA00.3
MAL-ELEMENT
ELEMENT		Alpha 20 Occurs 10 Times ×10The name of the matching element.MA00.3
MAL-FIELD-SIZE
FIELD_SIZE		Numeric 2 Occurs 10 Times ×10The field size of the data. This will be different for different data types. Date fields are 8 characters. Numeric fields can be a maximum of 18 characters. Alpha fields can be a maximum of 20 characters.MA00.3
MAL-CREATE-DATE
CREATE_DATE		Numeric 8 (yyyymmdd)The creation date of the match class.MA00.3
MAL-ACTIVE-STATUS
ACTIVE_STATUS		Alpha 1The status of the match class.
  • A Active
  • I Inactive
MA00.3
MAL-USED-FLAG
USED_FLAG		Alpha 1Indicates if the record has been accessed by some source after creation.MA00.3, MA01.1
MAL-LONG-STATUS
LONG_STATUS		DerivedContains the text for the match class status. (Active or Inactive) Used for Drill Around(TM) purposes.—

Indexes (1)

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

IndexKeysFlagsConditionUsed in
MALSET1MATCH-CLASSPrimaryAP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source)

Relations

One to one (1) — lookups and parents

RelationTableRulesConditionField map
MamtchelemMAMTCHELEMRequiredMAL-ELEMENT → MAE-ELEMENT

One to many (1) — child tables

RelationTableRulesConditionField map
MaelmgprelMAELMGPRELMAL-MATCH-CLASS → MGR-MATCH-CLASS, → MGR-RELATION, → MGR-SEQ-TRNS-NBR

Programs

Updated by (2)

Referenced by (232)