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.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
ELM-SOURCE-CODE PKSOURCE_CODE | Alpha 2 | A two-character code assigned to a transaction that identifies where it was created. | GL05.3, GL106 |
ELM-FIELD-NAME PKFIELD_NAME | Alpha 20 (Lower Case) | The element field name used to identify transactions. | GL05.3, GL106 |
ELM-ELEMENT-NAMEELEMENT_NAME | Alpha 20 | The name that identifies the element associated with the attribute. | GL05.3, GL106 |
ELM-DESCRIPTIONDESCRIPTION | Alpha 30 (Lower Case) | This is the database field description. | GL05.3, GL106 |
ELM-SOURCE-TYPESOURCE_TYPE | Alpha 1 | Determines if the source code is Lawson or user-defined.
| GL05.3, GL106 |
ELM-FIELD-IDFIELD_ID | Numeric 3 | The originating system field ID number. | GL05.3, GL106 |
Indexes (3)
Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
ELMSET1 | SOURCE-CODE, FIELD-NAME | Primary | GL05.1, GL05.2, GL05.3, GL106, GL205 | |
ELMSET2 | ELEMENT-NAME, SOURCE-CODE, FIELD-NAME | KeyChange | MX00.2, MX100 | |
ELMSET3 | SOURCE-CODE, FIELD-ID | GL05.1, GL05.2, GL05.3 |
Relations
One to one (2) — lookups and parents
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| Mxelement | MXELEMENT | Required | ELM-ELEMENT-NAME → MXE-ELEMENT-NAME | |
| Source Code | GLSRCCODE | Required | ELM-SOURCE-CODE → GSR-SOURCE-CODE |
One to many (1) — child tables
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| Glsccat | GLSCCAT | ELM-SOURCE-CODE → GSC-SOURCE-CODE, ELM-FIELD-NAME → GSC-FIELD-NAME, GSC-SEQ-NBR |