Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

MXOBJCAT


                             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     AC113     AC121     AC123     AC130
AC160     AC165     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    AC90.1    AC92.1    AC93.1    AC94.1    AC95.1
AC97.1    ACBA.1    ACDM.8    ACVW.1    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
AM330     AM35.1    AM45.1    AM501     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     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    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     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    AC135     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     MX135     SL00.1    SL00.3    SL00.5    SL00.6
SL40.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

MOC-OBJ-TYPE           Alpha 5                                   AC40.1  AC40.4
Element: 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
                                                                 SL40.1

MOC-MATRIX-CAT         Alpha 12                                  AC40.1  AC40.4
Element: Matrix CategorAttribute 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
                                                                 SL40.1

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

                       Y = Yes
                       N = No

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


MOC-USAGE-COUNT        Numeric 12                                AC10.1  AC110
Element: Usage Count   The object record count.                  AC120   AC13.1
                                                                 AC13.2  AC13.7
                                                                 AC13.8  AC135
                                                                 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  MX135
                                                                 SL00.5  SL00.6
                                                                 SL40.1

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

MOC-DERIVED-DESC       Derived
Element: Description   The attribute description.

MOC-DERIVED-TYPE       Derived
Element: Type          The attribute type.

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


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

MOC-DERIVED-DATA       Derived
Element: 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
                                                                 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
                                                                 ...

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
                                                                 SL00.1  SL00.3

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