MAMTCHELEM – Matching Elements

System
Matching (MA)
Prefix
MAE
Primary key
ELEMENT
Fields
7
Updated by
2 programs
Referenced by
229 programs

MAMTCHELEM is the Matching Elements table in Lawson Matching (prefix MAE). It is indexed by ELEMENT (MAESET1). It is updated by MA00.2 and MA00.3 and referenced by AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 and 221 more. The table has 7 fields, 1 index and 0 documented relations.

About MAMTCHELEM

The Match Elements file contains the definition of matching elements. Match elements are defined in MA00.2 (Elements).

Fields (7)

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

Field / columnTypeDescription & valuesUpdated by
MAE-ELEMENT PK
ELEMENT		Alpha 20The name of the matching element.MA00.2
MAE-DATA-TYPE
DATA_TYPE		Alpha 1Data type. Determines how the data is entered and how to edit it. Valid values are:
  • A Alphanumeric
  • D Date
  • N Numeric
MA00.2
MAE-FIELD-SIZE
FIELD_SIZE		Numeric 2The 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.2
MAE-ELEMENT-TYPE
ELEMENT_TYPE		Alpha 1The element type.MA00.2
MAE-USED-FLAG
USED_FLAG		Alpha 1Indicates if the record has been accessed by some source after creation.MA00.3
MAE-ACTIVE-STATUS
ACTIVE_STATUS		Alpha 1The status of the account. If Inactive, no posting can be done to the account.
  • A Active
  • I Inactive
MA00.2
MAE-ITEM-IND
ITEM_IND		Alpha 1—
  • Y Yes
  • N No
MA00.2

Indexes (1)

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

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

Programs

Updated by (2)

Referenced by (229)