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     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     AC255
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.8
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    AMAS.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.2    CA10.7    FB141
GL110     GL170     GL191     GL240     GL256     GL265
GL270     GL292     GL293     GL294     GL55.1    GL65.1
GL70.1    GL70.2    GL70.3    GL70.6    GL95.4    GL99.1
RW100     RW20.1    RW20.2    RW80.1    IC840     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    MX10.1    MX10.2    MX123     MX135
MX201     MX202     MX205     MX260     MX500     MX60.1
OE280     OE285     OE290     PA495     PR05.1    PR05.3
PR226     PR247     PR26.1    PR47.1    UK47.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   AC14.1
                                                                 AC14.2  AC14.3
                                                                 AC14.6  AC14.7
                                                                 AC145   AC160
                                                                 AC165   AC190
                                                                 AC191   AC197
                                                                 ...

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

MXCSET3   ELEMENT-NAME  KeyChange                                MX00.2  MX100
          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

Listdtl Acgrp  MXLISTDTL

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

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