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
AC145     AC160     AC165     AC190     AC191     AC197
AC198     AC200     AC203     AC206     AC207     AC210
AC213     AC218     AC220     AC240     AC246     AC256
AC261     AC265     AC290     AC295     AC298     AC30.3
AC310     AC32.1    AC34.1    AC346     AC35.1    AC36.1
AC400     AC401     AC410     AC412     AC420     AC421
AC440     AC460     AC471     AC472     AC473     AC480
AC490     AC493     AC494     AC50.1    AC51.1    AC54.1
AC540     AC55.1    AC580     AC583     AC90.1    AC92.1
AC93.1    AC94.1    AC95.1    ACAC.1    ACBA.1    ACDL.1
ACDM.2    ACDM.8    ACVW.1    SE90.1    AM115     AM117
AM120     AM15.1    AM15.2    AM15.3    AM15.4    AM20.1
AM20.3    AM20.2    AM20.4    AM20.5    AM20.6    AM21.1
AM21.3    AM21.2    AM21.4    AM21.5    AM21.6    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     AM310     AM320
AM35.1    AM45.1    AM501     AM51.1    AM551     AM70.4
AM88.1    AM88.8    AM94.1    AM97.1    AMBL.1    AMDM.2
AP211     AP510     API3.1    API4.1    AR01.3    AR135
AR170     AR210     AR211     AR222     AR232     AR235
AR250     AR251     AR253     AR271     AR275     AR290
AR293     AR294     AR30.5    AR33.2    BL232     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    CA10.1
CA10.2    CA10.7    FB141     GL165     GL256     GL292
GL293     GL294     GL55.1    GL65.1    GL70.1    GL70.2
GL70.3    GL70.6    GL95.4    GL99.1    RW20.1    RW20.2
RW80.1    IC840     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     OE280     OE285     OE290     PR05.1    PR05.3
PR226     PR247     PR26.1    PR47.1    UK47.1    SLBL.1
AM170     AM96.1    AM98.1    CB00.3

UPDATED BY

AC00.1    AC10.1    AC110     AC120     AC13.1    AC13.2
AC13.7    AC13.8    AC135     AC14.1    AC14.2    AC14.6
AC14.7    AC40.1    AC40.4    AC41.1    AC41.4    AC42.1
AC45.1    AC500     AC510     AM192     AM23.1    AM23.2
AM40.1    AM500     AP03.1    AP03.2    AR23.1    AR23.2
AR501     AR515     AR550     CB01.4    CB01.5    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
                                                                 AC14.1  AC14.2
                                                                 AC14.6  AC14.7
                                                                 AC40.1  AC40.4
                                                                 AC41.1  AC41.4
                                                                 AC42.1  AC45.1
                                                                 AC500   AC510
                                                                 AM23.1  AM23.2
                                                                 AM40.1  AM500
                                                                 AP03.1  AP03.2
                                                                 AR23.1  AR23.2
                                                                 AR501   AR515
                                                                 AR550   CB01.4
                                                                 CB01.5  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
                                                                 ...

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                                               AC00.1  AC01.1
          MATRIX-CAT                                             AC03.2  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
                                                                 AC14.1  AC14.2
                                                                 AC14.3  AC14.6
                                                                 AC14.7  AC145
                                                                 AC160   AC165
                                                                 ...

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" )                  AM117   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
                                                                 CB00.3  GL00.1
                                                                 GL00.3  GL20.1
                                                                 SL00.1  SL00.3

MOCSET4   MATRIX-CAT                                             MX00.1  MX00.2
          OBJ-TYPE                                               MX00.3  MX100
                                                                 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