Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

MXCATDEF


                             MXCATDEF FILE

                          Attribute Definition

This file contains the valid Lawson and user-type attribute header records
including, the attribute type, description, column headings, and element names
defined in MX00.1 (Attribute). The attributes can be applied to various
objects. Attribute values can be assigned to an object and used for analysis,
grouping, and sorting.


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     AC255     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.8    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
AMAS.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.2    CA10.7    GL110
GL170     GL191     GL240     GL256     GL265     GL270
GL55.1    GL65.1    GL70.1    GL70.2    GL70.3    GL70.6
RW80.1    GL05.1    GL05.2    GL123     GL124     GL14.5
GL14.7    GL16.1    GL16.2    GL16.3    GL16.4    GL20.1
GL20.5    GL20.7    GL20.8    GL20.9    GL205     GL220
GLAC.1    GLBL.1    IFAS.2    IFBA.1    IFBO.1    IFOS.2
IFOS.3    IFSC.1    MX05.1    MX06.1    MX07.1    MX10.1
MX10.2    MX123     MX135     MX201     MX202     MX205
MX207     MX260     MX500     MX60.1    SL00.5    SL00.6
SLBL.1    GL162     GL262     GL62.1

UPDATED BY

MX00.1    MX100     MX160

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

MXC-MATRIX-CAT         Alpha 12                                  MX00.1  MX100
Element: Matrix CategorAttribute name assigned to an object
                       (like an accounting unit) to track
                       additional information. Attribute values
                       may then be used in selection and
                       sorting for reporting and analysis.


MXC-CATEGORY-TYPE      Alpha 1                                   MX00.1  MX100
Element: Category Type Defines whether the attribute category
                       is a Lawson type (maintained by the
                       system), or a User type (maintained by
                       the user). Both types are available for
                       selection and reporting.

                       L = Lawson
                       U = User

MXC-DESCRIPTION        Alpha 30  (Lower Case)                    MX00.1  MX100
Element: Description   The attribute description.

MXC-COLM-HEADING       Alpha 32  (Lower Case)                    MX00.1
Element: Column HeadingText used for column headings on
                       screens or reports. Heading size is
                       limited to the size of the field.

MXC-HAS-VALIDATION     Alpha 1                                   MX00.1  MX160
Element: Validation    Identifies if valid values have been
                       defined for the category.  Yes = valid
                       value records are defined and the
                       entered value must cohere.

                       N = No

MXC-ELEMENT-NAME       Alpha 20                                  MX00.1  MX100
Element: Element Name  The Lawson or user-defined element name
                       that identifies the field size and type.



                         MXCATDEF FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

MXCSET1   MATRIX-CAT                                             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
                                                                 ...

MXCSET2   CATEGORY-TYPE KeyChange                                GL162   GL262
          MATRIX-CAT                                             GL62.1

MXCSET3   ELEMENT-NAME  KeyChange                                MX00.2
          MATRIX-CAT

                         MXCATDEF FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Matrix Element MXELEMENT    Required

                            MXC-ELEMENT-NAME    -> MXE-ELEMENT-NAME

                         MXCATDEF FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Mxlistdtl Ac   MXLISTDTL

                            "ACTVY"             -> MLD-OBJ-TYPE
                            MXC-MATRIX-CAT      -> MLD-MATRIX-CAT
                                                   MLD-MATRIX-LIST
                                                   MLD-OR-GROUP
                                                   MLD-SEQ-NUMBER

Mxlistdtl Au   MXLISTDTL

                            "ACCTU"             -> MLD-OBJ-TYPE
                            MXC-MATRIX-CAT      -> MLD-MATRIX-CAT
                                                   MLD-MATRIX-LIST
                                                   MLD-OR-GROUP
                                                   MLD-SEQ-NUMBER

Mxobjcat       MXOBJCAT     Delete Restricted

                            MXC-MATRIX-CAT      -> MOC-MATRIX-CAT
                                                   MOC-OBJ-TYPE

Mxvalidate     MXVALIDATE   Delete Cascades

                            MXC-MATRIX-CAT      -> MVL-MATRIX-CAT
                                                   MVL-TH-MX-VAL

Src Code Cats  GLSCCAT      Delete Restricted

                            MXC-MATRIX-CAT      -> GSC-MATRIX-CAT
                                                   GSC-SOURCE-CODE
                                                   GSC-SEQ-NBR