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. PK = primary key (present in every index); SETn = leading/alternate key of that index.

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 are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
MXESET1
  1. ELEMENT-NAME
PrimaryAC01.1, AC03.2, AC03.3, AC03.4, AC03.5, AC03.6, AC10.1, AC10.5 +22 more (list truncated in source)

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
MXCATDEFMXELEMNTAUGLELMLISTMXELEMENT

One to many (3) — child tables

RelationTableRulesConditionField map
MxcatdefMXCATDEF
MXE-ELEMENT-NAME→MXC-ELEMENT-NAME
—→MXC-MATRIX-CAT
MxelemntauMXELEMNTAU
MXE-ELEMENT-NAME→MEA-ELEMENT-NAME
—→MEA-ACTION
—→MEA-DATE
—→MEA-TIME
—→MEA-UNIQUE-I-D
Src Code FieldGLELMLISTDelete Restricted
MXE-ELEMENT-NAME→ELM-ELEMENT-NAME
—→ELM-SOURCE-CODE
—→ELM-FIELD-NAME

Programs

Updated by (70)

Referenced by (616)