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     AC160     AC165
AC170     AC190     AC191     AC196     AC198     AC203
AC206     AC207     AC210     AC213     AC218     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    SE90.1    AM120
AM220     AM221     AM222     AM223     AM224     AM225
AM230     AM235     AM240     AM245     AM25.2    AM250
AM255     AM260     AM265     AM270     AM275     AM277
AM278     AM280     AM281     AM282     AM285     AM290
AM292     AM295     AM320     AM35.1    AM45.1    AM70.4
AM88.1    AM88.8    AM94.1    AMBL.1    AMDM.2    AR250
AR251     AR30.5    BR03.1    BR03.3    BR120     BR121
BR142     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    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     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

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   GL199
                                                                 GL40.1  GL40.2
                                                                 GL40.3  GL40.7
                                                                 GL40.8  GL44.1
                                                                 GL45.1  IFGT.1
                                                                 MX00.3  MX100

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   GL199
                                                                 GL40.1  GL40.2
                                                                 GL40.3  GL40.7
                                                                 GL40.8  GL44.1
                                                                 GL45.1  IFGT.1
                                                                 MX00.3  MX100

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  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   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

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
                                                                 AC160   AC165
                                                                 AC170   AC190
                                                                 AC191   AC196
                                                                 AC198   AC203
                                                                 AC206   AC207
                                                                 AC210   AC213
                                                                 AC218   AC240
                                                                 ...

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