GLELMLIST – General Ledger Element List

System
General Ledger Setup (IF)
Prefix
ELM
Primary key
SOURCE-CODE, FIELD-NAME
Fields
6
Updated by
4 programs
Referenced by
3 programs

GLELMLIST is the General Ledger Element List table in Lawson General Ledger Setup (prefix ELM). It is indexed by SOURCE-CODE, FIELD-NAME (ELMSET1); alternate indexes: ELMSET2 and ELMSET3. It is related 1:1 to MXELEMENT and GLSRCCODE and 1:M to GLSCCAT. It is updated by GL05.1, GL05.2, GL05.3 and GL106 and referenced by GL205, MX00.2 and MX100. The table has 6 fields, 3 indexes and 3 documented relations.

About GLELMLIST

This file contains valid source code and category relationship records.

Fields (6)

Column = COBOL field name without the ELM- 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
#ELM-SOURCE-CODE PK
SOURCE_CODE		Alpha 2A two-character code assigned to a transaction that identifies where it was created.GL05.3, GL106
#ELM-FIELD-NAME PK
FIELD_NAME		Alpha 20 (Lower Case)The element field name used to identify transactions.GL05.3, GL106
#ELM-ELEMENT-NAME SET2
ELEMENT_NAME		Alpha 20The name that identifies the element associated with the attribute.GL05.3, GL106
#ELM-DESCRIPTION
DESCRIPTION		Alpha 30 (Lower Case)This is the database field description.GL05.3, GL106
#ELM-SOURCE-TYPE
SOURCE_TYPE		Alpha 1Determines if the source code is Lawson or user-defined.
  • L Lawson
  • U User
GL05.3, GL106
#ELM-FIELD-ID SET3
FIELD_ID		Numeric 3The originating system field ID number.GL05.3, GL106

Indexes (3)

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
ELMSET1
  1. SOURCE-CODE
  2. FIELD-NAME
PrimaryGL05.1, GL05.2, GL05.3, GL106, GL205
ELMSET2
  1. ELEMENT-NAME
  2. SOURCE-CODE
  3. FIELD-NAME
KeyChangeMX00.2, MX100
ELMSET3
  1. SOURCE-CODE
  2. FIELD-ID
GL05.1, GL05.2, GL05.3

Relations

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

One to one (2) — lookups and parents

RelationTableRulesConditionField map
MxelementMXELEMENTRequired
ELM-ELEMENT-NAME→MXE-ELEMENT-NAME
Source CodeGLSRCCODERequired
ELM-SOURCE-CODE→GSR-SOURCE-CODE

One to many (1) — child tables

RelationTableRulesConditionField map
GlsccatGLSCCAT
ELM-SOURCE-CODE→GSC-SOURCE-CODE
ELM-FIELD-NAME→GSC-FIELD-NAME
—→GSC-SEQ-NBR

Programs

Updated by (4)

Referenced by (3)