MXELEMENT – Attribute Element

System
General Ledger Setup (IF)
Prefix
MXE
Primary key
ELEMENT-NAME
Fields
6
Updated by
70 programs
Referenced by
616 programs

MXELEMENT is the Attribute Element table in Lawson General Ledger Setup (prefix MXE). It is indexed by ELEMENT-NAME (MXESET1). It is related 1:M to MXCATDEF, MXELEMNTAU and GLELMLIST. It is updated by AC10.1, AC10.5, AC120, AC130, AC131, AC145, AC147, AC160 and 62 more and referenced by AC01.1, AC03.2, AC03.3, AC03.4, AC03.5, AC03.6, AC105, AC112 and 608 more. The table has 6 fields, 1 index and 3 documented relations.

About MXELEMENT

This file contains attribute element information, including the element name, description, type, and data type defined in MX00.2 (Element).

Fields (6)

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

Field / columnTypeDescription & valuesUpdated by
MXE-ELEMENT-NAME PK
ELEMENT_NAME		Alpha 20The Lawson or user-defined element name.MX00.2, MX100
MXE-DESCRIPTION
DESCRIPTION		Alpha 30 (Lower Case)The description of the element.MX00.2, MX100
MXE-DATA-TYPE
DATA_TYPE		Alpha 1Determines the type of data used to define the element. Values are Date, Alpha, or Numeric.
  • A Alpha
  • N Numeric
  • D Date
  • S Signed
MX00.2, MX100
MXE-FIELD-SIZE
FIELD_SIZE		Numeric 2The attribute field size. Date fields are 8, numeric fields are maximum of 18, and alpha fields are maximum of 20.MX00.2, MX100
MXE-ELEMENT-TYPE
ELEMENT_TYPE		Alpha 1Indicates if the element is Lawson-defined or user-defined.
  • L Lawson
  • U User
MX00.2, MX100
MXE-NBR-DECIMALS
NBR_DECIMALS		Numeric 1The number of decimals. 1 2 3 4 5 6MX100

Indexes (1)

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

IndexKeysFlagsConditionUsed in
MXESET1ELEMENT-NAMEPrimaryAC01.1, AC03.2, AC03.3, AC03.4, AC03.5, AC03.6, AC10.1, AC10.5 +22 more (list truncated in source)

Relations

One to many (3) — child tables

RelationTableRulesConditionField map
MxcatdefMXCATDEFMXE-ELEMENT-NAME → MXC-ELEMENT-NAME, → MXC-MATRIX-CAT
MxelemntauMXELEMNTAUMXE-ELEMENT-NAME → MEA-ELEMENT-NAME, → MEA-ACTION, → MEA-DATE, → MEA-TIME, → MEA-UNIQUE-I-D
Src Code FieldGLELMLISTDelete RestrictedMXE-ELEMENT-NAME → ELM-ELEMENT-NAME, → ELM-SOURCE-CODE, → ELM-FIELD-NAME

Programs

Updated by (70)

Referenced by (616)