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     AC121     AC123     AC128
AC13.1    AC13.2    AC13.3    AC13.7    AC13.8    AC130
AC135     AC14.1    AC14.2    AC14.3    AC14.6    AC14.7
AC145     AC16.1    AC16.2    AC16.3    AC16.7    AC16.8
AC16.9    AC165     AC197     AC198     AC200     AC203
AC206     AC207     AC210     AC213     AC218     AC220
AC225     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     AC460     AC471
AC472     AC473     AC480     AC490     AC493     AC494
AC50.1    AC500     AC51.1    AC510     AC52.1    AC520
AC527     AC54.1    AC55.1    AC558     AC560     AC58.3
AC58.4    AC583     AC90.1    AC92.1    AC93.1    AC94.1
AC95.1    ACAC.1    ACBA.1    ACDL.1    ACDM.2    ACDM.9
ACVW.1    ATVW.1    SE90.1    AM115     AM117     AM120
AM15.1    AM15.2    AM15.3    AM15.4    AM19.1    AM19.2
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     AM330     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    AP110     AP115     AP125     AP126     AP131
AP150     AP155     AP160     AP161     AP162     AP20.1
AP20.2    AP20.3    AP20.4    AP20.5    AP20.7    AP21.1
AP210     AP211     AP220     AP23.1    AP25.1    AP25.2
AP26.1    AP262     AP265     AP27.1    AP30.2    AP30.4
AP305     AP510     AP62.1    AP90.1    AP91.1    API1.1
API2.1    API3.1    API4.1    AR01.3    AR120     AR129
AR130     AR131     AR135     AR170     AR21.2    AR210
AR211     AR217     AR222     AR223     AR227     AR228
AR229     AR23.1    AR23.2    AR23.3    AR230     AR232
AR233     AR235     AR237     AR238     AR239     AR245
AR250     AR251     AR253     AR257     AR258     AR264
AR265     AR27.2    AR271     AR275     AR282     AR285
AR29.1    AR290     AR291     AR292     AR293     AR294
AR296     AR30.1    AR30.5    AR300     AR301     AR32.1
AR33.1    AR33.2    AR38.5    AR39.1    AR39.2    AR39.3
AR39.4    AR42.1    AR42.2    AR42.7    AR42.8    AR43.1
AR502     AR503     AR515     AR55.1    AR560     AR575
AR72.1    AR800     AR91.1    ARLL.1    BL120     BL122
BL130     BL20.1    BL20.3    BL21.2    BL21.5    BL232
BL29.1    BL29.2    BL290     BL520     BL820     BL92.1
BR00.3    BR03.1    BR03.3    BR10.7    BR130     BR142
BR145     BR155     BR157     BR165     BR190     BR20.6
BR20.9    BR200     BR202     BR204     BR205     BR210
BR212     BR215     BR220     BR245     BR251     BR252
BR253     BR254     BR265     BR400     BR405     BR422
BR43.1    BR430     BR44.1    BR450     BR530     CB01.4
CB01.5    CB01.7    CB145     CB162     CB170     CB175
CB180     CB186     CB187     CB210     CB215     CB220
CB221     CB260     CB262     CB286     CB62.1    CBBC.1
CBDM.5    ET700     CA10.1    CA10.7    FB141     GL170
GL191     GL256     GL292     GL293     GL294     GL55.1
GL95.4    GL99.1    RW100     RW20.1    RW20.2    RW80.1
IC02.3    IC02.4    ICBL.1    ICBL.2    ICBL.3    ICLM.1
ICLM.3    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    MA180     MA279     MA41.1    MA41.2    MA41.4
MA41.7    MA43.1    MA43.2    MA43.3    MA43.4    MA43.6
MA43.7    MA530     MA531     MA60.2    MA60.3    MA60.5
MA61.1    MA63.1    MA65.1    MA66.2    MA66.3    MA67.2
MA67.3    MA68.2    MA68.3    MA68.5    MA70.1    MA75.1
MA80.1    MAI1.1    PD10.1    PD10.2    PD130     PD20.1
PD20.2    PD20.3    PD230     PD235     PO04.5    PO04.6
PO10.1    PO100     PO101     PO120     PO122     PO131
PO20.1    PO21.1    PO21.2    PO21.3    PO21.4    PO21.5
PO22.1    PO220     PO223     PO23.1    PO233     PO24.1
PO25.1    PO25.5    PO25.6    PO25.7    PO253     PO254
PO27.2    PO278     PO29.1    PO30.1    PO30.2    PO30.3
PO300     PO31.1    PO31.2    PO32.2    PO32.4    PO33.1
PO34.1    PO35.1    PO36.1    PO36.2    PO38.1    PO39.1
PO39.2    PO44.1    PO50.1    PO52.1    PO520     PO536
PO54.1    PO54.2    PO54.3    PO54.4    POBL.1    POBL.3
POI3.1    POID.1    POII.1    POIJ.1    PR05.1    PR05.3
PR226     PR247     PR26.1    PR47.1    PR514     UK47.1
PW110     PW510     RQ01.2    RQ01.3    RQ10.1    RQ10.2
RQBL.1    RQBL.3    SL00.5    SL00.6    SLBL.1    SN02.1
SNAC.1    SNAU.1    SNGL.1    WH110     WH130     WH20.2
WH20.7    WH226

UPDATED BY

AC10.1    AC10.5    AC120     AC160     AC169     AC190
AC191     AC195     AC45.1    AC580     BR120     BR121
BR122     BR123     BR124     BR131     BR140     BR151
BR152     BR153     BR154     BR156     BR19.1    BR21.1
BR300     BR42.1    BR45.1    BR51.1    BR521     BR55.1
BR56.1    BR580     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
Element: Nbr Decimals  The number of decimals.
                       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
                                                                 AC10.1  AC10.5
                                                                 AC105   AC112
                                                                 AC113   AC120
                                                                 AC121   AC123
                                                                 AC128   AC13.1
                                                                 AC13.2  AC13.3
                                                                 AC13.7  AC13.8
                                                                 AC130   AC135
                                                                 AC14.1  AC14.2
                                                                 AC14.3  AC14.6
                                                                 AC14.7  AC145
                                                                 AC16.1  AC16.2
                                                                 ...

                         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