Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                             GLELMLIST FILE

                      General Ledger Element List

This file contains valid source code and category relationship records.

REFERENCED BY

GL205     MX00.2

UPDATED BY

GL05.1    GL05.2    GL05.3    GL106

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

ELM-SOURCE-CODE      Alpha 2                                     GL05.3  GL106
Source Code          A two-character code assigned to a
                     transaction that identifies where it was
                     created.


ELM-FIELD-NAME       Alpha 20  (Lower Case)                      GL05.3  GL106
Field Name           The element field name used to identify
                     transactions.


ELM-ELEMENT-NAME     Alpha 20                                    GL05.3  GL106
Element Name         The name that identifies the element
                     associated with the attribute.


ELM-DESCRIPTION      Alpha 30  (Lower Case)                      GL05.3  GL106
Description          This is the database field description.


ELM-SOURCE-TYPE      Alpha 1                                     GL05.3  GL106
Source Type          Determines if the source code is Lawson
                     or user-defined.

                     L = Lawson
                     U = User

ELM-FIELD-ID         Numeric 3                                   GL05.3  GL106
Field ID             The originating system field ID number.


                         GLELMLIST FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

ELMSET1   SOURCE-CODE                                            GL05.1  GL05.2
          FIELD-NAME                                             GL05.3  GL106
                                                                 GL205

ELMSET2   ELEMENT-NAME  KeyChange                                MX00.2
          SOURCE-CODE
          FIELD-NAME

ELMSET3   SOURCE-CODE                                            GL05.1  GL05.2
          FIELD-ID                                               GL05.3

                         GLELMLIST FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Mxelement      MXELEMENT    Required

                            ELM-ELEMENT-NAME    -> MXE-ELEMENT-NAME

Source Code    GLSRCCODE    Required

                            ELM-SOURCE-CODE     -> GSR-SOURCE-CODE

                         GLELMLIST FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Glsccat        GLSCCAT

                            ELM-SOURCE-CODE     -> GSC-SOURCE-CODE
                            ELM-FIELD-NAME      -> GSC-FIELD-NAME
                                                   GSC-SEQ-NBR