Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                             MXOBJCAT FILE

                            Attribute Object

This file contains the valid object and attribute records and determines how
an object is used by the attribute.


REFERENCED BY

AC01.1    AC03.2    AC03.3    AC03.4    AC03.5    AC03.6
AC105     AC112     AC121     AC123     AC135     AC160
AC165     AC170     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    AC400     AC401
AC410     AC412     AC420     AC421     AC440     AC460
AC471     AC472     AC473     AC480     AC490     AC493
AC494     AC50.1    AC51.1    AC530     AC54.1    AC540
AC55.1    AC70.1    AC70.4    AC90.1    AC92.1    AC93.1
AC94.1    AC95.1    AC97.1    ACBA.1    ACDM.8    ACVW.1
DA233     DA240     GR240     SE90.1    AM120     AM214
AM220     AM221     AM222     AM223     AM224     AM225
AM230     AM235     AM240     AM245     AM25.2    AM250
AM255     AM260     AM265     AM267     AM270     AM275
AM277     AM278     AM280     AM281     AM282     AM285
AM287     AM290     AM292     AM295     AM320     AM35.1
AM45.1    AM70.4    AM88.1    AM88.8    AM94.1    AMBL.1
AMDM.2    AR01.3    AR250     AR251     AR30.5    BR03.1
BR03.3    BR10.1    BR120     BR121     BR130     BR131
BR142     BR165     BR20.6    BR200     BR202     BR204
BR205     BR210     BR220     BR265     BR400     BR405
BR420     BR430     BR450     BRCC.1    CA10.1    CA10.2
CA10.7    GL165     GL256     GL55.1    GL65.1    GL70.1
GL70.2    GL70.3    GL70.6    RW80.1    GL00.1    GL00.3
GL11.1    GL11.2    GL62.1    GLAC.1    GLBL.1    IFAS.2
IFOS.2    MX05.1    MX06.1    MX10.1    MX10.2    MX123
MX135     MX201     MX202     MX500     SLBL.1    AM115
AM15.1    AM15.2    AM15.3    AM15.4    AM170     AM20.1
AM20.2    AM20.3    AM20.4    AM20.5    AM20.6    AM21.1
AM21.2    AM21.3    AM21.4    AM21.5    AM21.6    AM551
AM96.1    AM98.1

UPDATED BY

AC10.1    AC110     AC120     AC13.1    AC13.2    AC13.7
AC13.8    AC40.1    AC40.4    AC41.1    AC41.4    AC42.1
AC45.1    AC500     AC510     AM192     AM23.1    AM23.2
AM40.1    AM500     GL110     GL120     GL146     GL190
GL191     GL197     GL199     GL300     GL40.1    GL40.2
GL40.3    GL40.6    GL40.7    GL40.8    GL44.1    GL45.1
GL05.1    GL05.2    GL124     GL14.5    GL16.1    GL16.2
GL16.3    GL16.4    GL161     GL162     GL20.1    GL20.5
GL20.7    GL20.8    GL20.9    IFGT.1    MX00.3    MX100
SL195

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

MOC-OBJ-TYPE         Alpha 5                                     AC40.1  AC40.4
Object Type          This field determines the type of           AC41.1  AC41.4
                     object used by the Attribute. These         AC42.1  AC45.1
                     values are not user maintainable.           GL05.1  GL05.2
                                                                 GL146   GL190
                                                                 GL191   GL197
                                                                 GL40.1  GL40.2
                                                                 GL40.3  GL40.7
                                                                 GL40.8  GL44.1
                                                                 GL45.1  IFGT.1
                                                                 MX00.3  MX100
                                                                 SL195

MOC-MATRIX-CAT       Alpha 12                                    AC40.1  AC40.4
Matrix Category      Attribute name assigned to an object        AC41.1  AC41.4
                     (like an accounting unit) to track          AC42.1  AC45.1
                     additional information.  Attribute          GL05.1  GL05.2
                     values are used in selection and sorting    GL146   GL190
                     for reporting and analysis.                 GL191   GL197
                                                                 GL40.1  GL40.2
                                                                 GL40.3  GL40.7
                                                                 GL40.8  GL44.1
                                                                 GL45.1  IFGT.1
                                                                 MX00.3  MX100
                                                                 SL195

MOC-REQUIRED         Alpha 1                                     GL05.1  GL05.2
Required             Indicates if a attribute category is        MX00.3  MX100
                     required.

                     Y = Yes
                     N = No

MOC-APPLY-TO-GROUP   Alpha 15                                    MX00.3
Apply to Group       Indicates if the attribute category
                     applies to a company group or template.


MOC-USAGE-COUNT      Numeric 12                                  AC10.1  AC110
Usage Count          The object record count.                    AC120   AC13.1
                                                                 AC13.2  AC13.7
                                                                 AC13.8  AC40.1
                                                                 AC40.4  AC41.1
                                                                 AC41.4  AC42.1
                                                                 AC45.1  AC500
                                                                 AC510   AM23.1
                                                                 AM23.2  AM40.1
                                                                 AM500   GL110
                                                                 GL120   GL124
                                                                 GL146   GL16.1
                                                                 GL16.2  GL16.3
                                                                 GL16.4  GL161
                                                                 GL162   GL190
                                                                 GL191   GL197
                                                                 GL199   GL20.1
                                                                 GL20.5  GL20.7
                                                                 GL20.8  GL20.9
                                                                 GL300   GL40.1
                                                                 GL40.2  GL40.3
                                                                 GL40.6  GL40.7
                                                                 GL40.8  GL44.1
                                                                 GL45.1  IFGT.1
                                                                 SL195

MOC-CALL-TOKEN       Alpha 6
Call Token           Not referenced at this time.

MOC-DERIVED-DESC     Derived
Description          The attribute description.

MOC-DERIVED-TYPE     Derived
Type                 The attribute type.

MOC-DERIVED-ELEM     Derived
Element              The element associated with the
                     attribute category.


MOC-DERIVED-SIZE     Derived
Size                 The element field size.

MOC-DERIVED-DATA     Derived
Data                 The attribute object.

                         MXOBJCAT FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

MOCSET1   OBJ-TYPE                                               AC01.1  AC03.2
          MATRIX-CAT                                             AC03.3  AC03.4
                                                                 AC03.5  AC03.6
                                                                 AC10.1  AC105
                                                                 AC110   AC112
                                                                 AC120   AC121
                                                                 AC123   AC13.1
                                                                 AC13.2  AC13.3
                                                                 AC13.7  AC13.8
                                                                 AC135   AC160
                                                                 AC165   AC170
                                                                 AC190   AC191
                                                                 AC196   AC198
                                                                 AC203   AC206
                                                                 AC207   AC210
                                                                 ...

MOCSET2   OBJ-TYPE      KeyChange, Subset
          APPLY-TO-GROUPWhere (APPLY-TO-GROUP != Spaces )
          MATRIX-CAT

MOCSET3   OBJ-TYPE      KeyChange, Subset                        AC10.1  AM115
          MATRIX-CAT    Where (REQUIRED = "Y" )                  AM15.1  AM15.2
                                                                 AM15.3  AM15.4
                                                                 AM170   AM20.1
                                                                 AM20.2  AM20.3
                                                                 AM20.4  AM20.5
                                                                 AM20.6  AM21.1
                                                                 AM21.2  AM21.3
                                                                 AM21.4  AM21.5
                                                                 AM21.6  AM500
                                                                 AM551   AM96.1
                                                                 AM98.1  GL00.1
                                                                 GL00.3  GL20.1

MOCSET4   MATRIX-CAT                                             MX00.1  MX00.2
          OBJ-TYPE                                               MX00.3  MX201

                         MXOBJCAT FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Company Group  GLCPYGRP     Not Required
                            Valid When (MOC-OBJ-TYPE = "ACCTU" )

                            MOC-APPLY-TO-GROUP    -> GCG-COMPANY-GROUP

Mxcatdef       MXCATDEF     Required

                            MOC-MATRIX-CAT        -> MXC-MATRIX-CAT

Mxelement      MXELEMENT    Required

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

Object Id      OBJID        Required

                            MOC-OBJ-TYPE          -> OBI-OBJ-TYPE

                         MXOBJCAT FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Aumxconv       AUMXCONV

                            MOC-MATRIX-CAT        -> AUC-MATRIX-CAT
                                                     AUC-OLD-COMPANY
                                                     AUC-RUN-GROUP
                                                     AUC-EFFECTIVE-DATE

Edtemplate     MXTMPLEFDT

                            MOC-OBJ-TYPE          -> MTE-OBJ-TYPE
                            MOC-MATRIX-CAT        -> MTE-MATRIX-CAT
                                                     MTE-EFFECTIVE-DATE
                                                     MTE-TEMPLATE-NAME

Glsccat        GLSCCAT

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

Matrix Values  AUMXVALUE
                            Valid When (MOC-OBJ-TYPE = "ACCTU" )

                            MOC-MATRIX-CAT        -> AMV-MATRIX-CAT
                                                     AMV-MX-VALUE
                                                     AMV-OBJ-ID

Mxvalidate     MXVALIDATE

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

Templates      MXTMPLDTL

                            MOC-OBJ-TYPE          -> MTD-OBJ-TYPE
                            MOC-MATRIX-CAT        -> MTD-MATRIX-CAT
                                                     MTD-TEMPLATE-NAME

Used In Lists  MXLISTDTL    Delete Restricted

                            MOC-OBJ-TYPE          -> MLD-OBJ-TYPE
                            MOC-MATRIX-CAT        -> MLD-MATRIX-CAT
                                                     MLD-MATRIX-LIST
                                                     MLD-OR-GROUP
                                                     MLD-SEQ-NUMBER