Lawson Insight Technical Documentation


ERDs Tables Elements Libraries App Forms

                             MXELEMENT FILE

                           Attribute Element

This file contains attribute element information, including the element name,
description, type, and data type defined in MX00.2 (Element).


REFERENCED BY

AC105     AC110     AC112     AC115     AC120     AC123
AC13.1    AC13.2    AC13.3    AC130     AC14.1    AC160
AC165     AC17.1    AC170     AC190     AC191     AC196
AC20.1    AC20.2    AC20.3    AC20.4    AC203     AC206
AC207     AC210     AC214     AC215     AC216     AC240
AC256     AC265     AC290     AC295     AC297     AC30.2
AC30.3    AC310     AC32.1    AC40.1    AC401     AC41.1
AC410     AC412     AC415     AC416     AC42.1    AC420
AC421     AC440     AC450     AC460     AC470     AC471
AC472     AC473     AC480     AC490     AC50.1    AC500
AC51.1    AC510     AC530     AC55.1    AC79.1    ACBA.1
AM220     AM221     AM222     AM223     AM224     AM225
AM23.1    AM23.2    AM23.3    AM230     AM235     AM240
AM245     AM250     AM255     AM260     AM265     AM275
AM277     AM280     AM285     AM290     AM292     AM295
AM500     AM94.1    CA10.1    CA10.8    GL170     GL191
GL256     GL55.1    RW80.1    GL05.3    GL162     GL20.5
GL20.7    GL205     GL220     GL262     GL62.1    GLBL.1
IFSC.1    MX05.1    MX10.1    MX123     MX200     MX205
MX500     SL00.5    SL00.6    SLBL.1

UPDATED BY

AM951     AM952     MX00.2    MX100

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

MXE-ELEMENT-NAME     Alpha 20                                    AM951   AM952
Element              The Lawson or user-defined element name.    MX00.2  MX100


MXE-DESCRIPTION      Alpha 30  (Lower Case)                      MX00.2  MX100
Description          The description of the element.

MXE-DATA-TYPE        Alpha 1                                     AM951   AM952
Data Type            Determines the type of data used to         MX00.2  MX100
                     define the element. Values are Date,
                     Alpha, or Numeric.

                     A = Alpha
                     N = Numeric
                     D = Date
                     S = Signed

MXE-FIELD-SIZE       Numeric 2                                   AM951   AM952
Field Size           The attribute field size. Date fields       MX00.2  MX100
                     are 8, numeric fields are maximum of 18,
                     and alpha fields are maximum of 20.


MXE-ELEMENT-TYPE     Alpha 1                                     AM951   AM952
Element Type         Indicates if the element is                 MX00.2  MX100
                     Lawson-defined or user-defined.

                     L = Lawson
                     U = User

MXE-NBR-DECIMALS     Numeric 1                                   AM951   AM952
Decimals             The number of decimals.                     MX100
                     1
                     2
                     3
                     4
                     5
                     6

                         MXELEMENT FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

MXESET1   ELEMENT-NAME                                           AC105   AC110
                                                                 AC112   AC115
                                                                 AC120   AC123
                                                                 AC13.1  AC13.2
                                                                 AC13.3  AC130
                                                                 AC14.1  AC160
                                                                 AC165   AC17.1
                                                                 AC170   AC190
                                                                 AC191   AC196
                                                                 AC20.1  AC20.2
                                                                 AC20.3  AC20.4
                                                                 AC203   AC206
                                                                 AC207   AC210
                                                                 AC214   AC215
                                                                 AC216   AC240
                                                                 ...

                         MXELEMENT FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Mxcatdef       MXCATDEF

                            MXE-ELEMENT-NAME    -> MXC-ELEMENT-NAME
                                                   MXC-MATRIX-CAT

Src Code Field GLELMLIST    Delete Restricted

                            MXE-ELEMENT-NAME    -> ELM-ELEMENT-NAME
                                                   ELM-SOURCE-CODE
                                                   ELM-FIELD-NAME