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     AC14.1    AC14.2    AC14.3    AC14.6    AC14.7
AC145     AC160     AC165     AC190     AC191     AC197
AC198     AC200     AC203     AC206     AC207     AC210
AC213     AC218     AC220     AC240     AC246     AC256
AC261     AC265     AC290     AC295     AC298     AC30.3
AC310     AC32.1    AC34.1    AC346     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     AC54.1    AC55.1    AC580
AC583     AC90.1    AC92.1    AC93.1    AC94.1    AC95.1
ACAC.1    ACBA.1    ACDL.1    ACDM.2    ACDM.9    ACVW.1
SE90.1    AM115     AM117     AM120     AM15.1    AM15.2
AM15.3    AM15.4    AM20.1    AM20.3    AM21.1    AM21.3
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     AM310     AM320     AM35.1    AM45.1
AM500     AM501     AM51.1    AM551     AM70.4    AM88.1
AM88.8    AM94.1    AM97.1    AMBL.1    AMDM.2    AP03.1
AP03.2    AP03.3    AP211     AP510     API3.1    API4.1
AR01.3    AR135     AR170     AR210     AR211     AR222
AR23.1    AR23.2    AR23.3    AR232     AR235     AR250
AR251     AR253     AR271     AR275     AR290     AR293
AR294     AR30.1    AR30.5    AR33.1    AR33.2    AR515
BL232     BR00.3    BR03.1    BR03.3    BR10.7    BR120
BR121     BR130     BR131     BR140     BR142     BR145
BR165     BR19.2    BR190     BR20.6    BR20.9    BR200
BR202     BR204     BR205     BR210     BR212     BR215
BR220     BR245     BR265     BR300     BR400     BR405
BR43.1    BR430     BR44.1    BR450     BR521     BR530
BR580     BRCC.1    CB01.4    CB01.5    CB01.7    CA10.1
CA10.7    FB141     GL170     GL191     GL256     GL292
GL293     GL294     GL55.1    GL95.4    GL99.1    RW100
RW20.1    RW20.2    RW80.1    IC840     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    OE280     OE285
OE290     PR05.1    PR05.3    PR226     PR247     PR26.1
PR47.1    UK47.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   AC14.1
                                                                 AC14.2  AC14.3
                                                                 AC14.6  AC14.7
                                                                 AC145   AC160
                                                                 AC165   AC190
                                                                 AC191   AC197
                                                                 ...

                         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