Lawson Insight Technical Documentation


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

AC105     AC112     AC115     AC123     AC130     AC14.1
AC160     AC165     AC17.1    AC170     AC190     AC191
AC196     AC20.1    AC20.2    AC20.3    AC20.4    AC203
AC206     AC207     AC210     AC214     AC215     AC216
AC240     AC256     AC265     AC290     AC295     AC297
AC30.2    AC30.3    AC310     AC32.1    AC401     AC410
AC412     AC415     AC416     AC420     AC421     AC440
AC450     AC460     AC470     AC471     AC472     AC473
AC480     AC490     AC50.1    AC51.1    AC530     AC54.1
AC540     AC55.1    AC79.1    ACBA.1    AM220     AM221
AM222     AM223     AM224     AM225     AM230     AM235
AM240     AM245     AM250     AM255     AM260     AM265
AM275     AM277     AM280     AM285     AM290     AM292
AM295     AM94.1    CA10.1    CA10.2    CA10.8    GL165
GL256     GL55.1    GL65.1    GL70.1    GL70.2    GL70.3
GL70.7    RW80.1    GL62.1    GLBL.1    MX05.1    MX10.1
MX10.2    MX123     MX201     SLBL.1    GL11.1    AM115
AM15.1    AM15.2    AM15.3    AM15.4    AM170     AM20.1
AM20.2    AM20.3    AM20.4    AM20.5    AM20.6    AM96.1
AM98.1

UPDATED BY

AC10.1    AC110     AC120     AC13.1    AC13.2    AC40.1
AC41.1    AC42.1    AC500     AC510     AC950     AM192
AM23.1    AM23.2    AM40.1    AM500     AM951     AM952
GL110     GL120     GL146     GL190     GL191     GL199
GL300     GL40.1    GL40.2    GL40.3    GL40.7    GL40.8
GL40.9    GL44.1    GL45.1    GL05.1    GL05.2    GL161
GL162     GL20.1    GL20.5    GL20.7    IFGT.1    MX00.3
MX100     SL00.5    SL00.6    SL40.1

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

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

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

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

                     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
                                                                 AC41.1  AC42.1
                                                                 AC500   AC510
                                                                 AC950   AM23.1
                                                                 AM23.2  AM40.1
                                                                 AM500   AM951
                                                                 AM952   GL110
                                                                 GL120   GL146
                                                                 GL161   GL162
                                                                 GL190   GL191
                                                                 GL199   GL20.1
                                                                 GL20.5  GL20.7
                                                                 GL300   GL40.1
                                                                 GL40.2  GL40.3
                                                                 GL40.7  GL40.8
                                                                 GL40.9  GL44.1
                                                                 GL45.1  IFGT.1
                                                                 SL00.5  SL00.6
                                                                 SL40.1

MOC-CALL-TOKEN       Alpha 6
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                                               AC10.1  AC105
          MATRIX-CAT                                             AC110   AC112
                                                                 AC115   AC120
                                                                 AC123   AC13.1
                                                                 AC13.2  AC13.3
                                                                 AC130   AC14.1
                                                                 AC160   AC165
                                                                 AC17.1  AC170
                                                                 AC190   AC191
                                                                 AC196   AC20.1
                                                                 AC20.2  AC20.3
                                                                 AC20.4  AC203
                                                                 AC206   AC207
                                                                 AC210   AC214
                                                                 AC215   AC216
                                                                 ...

MOCSET2   OBJ-TYPE      KeyChange, Subset                        GL11.1
          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  AM500
                                                                 AM96.1  AM98.1
                                                                 GL20.1  SL00.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

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