Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

MXELEMENT


                             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     AC113     AC120     AC121     AC123
AC13.1    AC13.2    AC13.3    AC13.7    AC13.8    AC130
AC135     AC160     AC165     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    AC90.1
AC92.1    AC93.1    AC94.1    AC95.1    AC97.1    ACBA.1
ACDM.9    ACVW.1    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     AM330     AM35.1    AM45.1    AM500     AM501
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     BR151     BR152
BR153     BR154     BR155     BR156     BR157     BR165
BR20.6    BR200     BR202     BR204     BR205     BR210
BR215     BR220     BR251     BR252     BR253     BR254
BR265     BR400     BR405     BR420     BR43.1    BR430
BR450     BR521     BR530     BR900     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    SL00.5    SL00.6    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: Element       The Lawson or user-defined element
                       name.


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

MXE-DATA-TYPE          Alpha 1                                   MX00.2  MX100
Element: 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
Element: 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: 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
                                                                 AC113   AC120
                                                                 AC121   AC123
                                                                 AC13.1  AC13.2
                                                                 AC13.3  AC13.7
                                                                 AC13.8  AC130
                                                                 AC135   AC160
                                                                 AC165   AC190
                                                                 AC191   AC196
                                                                 AC198   AC203
                                                                 AC206   AC207
                                                                 AC210   AC213
                                                                 ...

                         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