Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

GLELMLIST


                             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
Element: 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
Element: Field Name    The element field name used to identify
                       transactions.


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


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


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

                       L = Lawson
                       U = User

ELM-FIELD-ID           Numeric 3                                 GL05.3  GL106
Element: 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