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    AC160     AC165     AC170     AC190
AC191     AC196     AC198     AC203     AC206     AC207
AC210     AC213     AC218     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    SE90.1
AM120     AM220     AM221     AM222     AM223     AM224
AM225     AM23.1    AM23.2    AM23.3    AM230     AM235
AM240     AM245     AM25.2    AM250     AM255     AM260
AM265     AM270     AM275     AM277     AM278     AM280
AM281     AM282     AM285     AM290     AM292     AM295
AM320     AM35.1    AM45.1    AM500     AM70.4    AM88.1
AM88.8    AM94.1    AMBL.1    AMDM.2    AR250     AR251
AR30.1    AR30.2    AR30.3    AR30.5    BR00.3    BR03.1
BR03.3    BR120     BR121     BR142     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    MX10.1    MX123     MX135
MX160     MX200     MX205     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
                                                                 AC160   AC165
                                                                 AC170   AC190
                                                                 AC191   AC196
                                                                 AC198   AC203
                                                                 AC206   AC207
                                                                 AC210   AC213
                                                                 AC218   AC240
                                                                 AC256   AC258
                                                                 ...

                         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