Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

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

AC01.1    AC03.2    AC03.3    AC03.4    AC03.5    AC03.6
AC105     AC112     AC120     AC121     AC123     AC13.1
AC13.2    AC13.3    AC13.7    AC13.8    AC135     AC160
AC165     AC170     AC190     AC191     AC196     AC198
AC203     AC206     AC207     AC210     AC213     AC218
AC220     AC240     AC256     AC258     AC261     AC265
AC290     AC295     AC297     AC298     AC30.3    AC310
AC32.1    AC34.1    AC35.1    AC36.1    AC40.1    AC40.4
AC400     AC401     AC41.1    AC41.4    AC410     AC412
AC42.1    AC420     AC421     AC440     AC45.1    AC460
AC471     AC472     AC473     AC480     AC490     AC493
AC494     AC50.1    AC500     AC51.1    AC510     AC52.1
AC520     AC530     AC54.1    AC55.1    AC70.1    AC70.4
AC90.1    AC92.1    AC93.1    AC94.1    AC95.1    AC97.1
ACBA.1    ACDM.9    ACVW.1    DA233     DA240     GR240
SE90.1    AM120     AM214     AM220     AM221     AM222
AM223     AM224     AM225     AM23.1    AM23.2    AM23.3
AM230     AM235     AM240     AM245     AM25.2    AM250
AM255     AM260     AM265     AM267     AM270     AM275
AM277     AM278     AM280     AM281     AM282     AM285
AM287     AM290     AM292     AM295     AM320     AM35.1
AM45.1    AM500     AM70.4    AM88.1    AM88.8    AM94.1
AMBL.1    AMDM.2    AR01.3    AR250     AR251     AR30.1
AR30.2    AR30.3    AR30.5    BR00.3    BR03.1    BR03.3
BR10.1    BR120     BR121     BR130     BR131     BR142
BR165     BR20.6    BR200     BR202     BR204     BR205
BR210     BR220     BR265     BR400     BR405     BR420
BR430     BR450     BRCC.1    CA10.1    CA10.7    GL170
GL191     GL256     GL55.1    RW80.1    GL05.3    GL123
GL124     GL14.5    GL14.7    GL16.1    GL16.2    GL16.3
GL16.4    GL162     GL20.5    GL20.7    GL20.8    GL20.9
GL205     GL220     GL262     GL62.1    GLAC.1    GLBL.1
IFAS.2    IFBA.1    IFBO.1    IFOS.3    IFSC.1    MX05.1
MX06.1    MX07.1    MX10.1    MX123     MX135     MX160
MX200     MX205     MX207     MX260     MX500     MX60.1
SLBL.1

UPDATED BY

CA110     CA190     MX00.2    MX100

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

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


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

MXE-DATA-TYPE        Alpha 1                                     MX00.2  MX100
Data Type            Determines the type of data used to
                     define the element. Values are Date,
                     Alpha, or Numeric.
                     A = Alpha
                     N = Numeric
                     D = Date
                     S = Signed

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


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

                     L = Lawson
                     U = User

MXE-NBR-DECIMALS     Numeric 1                                   MX100
Number of Decimal    The number of decimals.
Places               1
                     2
                     3
                     4
                     5
                     6

                         MXELEMENT FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

MXESET1   ELEMENT-NAME                                           AC01.1  AC03.2
                                                                 AC03.3  AC03.4
                                                                 AC03.5  AC03.6
                                                                 AC105   AC112
                                                                 AC120   AC121
                                                                 AC123   AC13.1
                                                                 AC13.2  AC13.3
                                                                 AC13.7  AC13.8
                                                                 AC135   AC160
                                                                 AC165   AC170
                                                                 AC190   AC191
                                                                 AC196   AC198
                                                                 AC203   AC206
                                                                 AC207   AC210
                                                                 AC213   AC218
                                                                 ...

                         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