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     AC120     AC121     AC123
AC128     AC130     AC145     AC160     AC165     AC169
AC190     AC191     AC197     AC198     AC200     AC203
AC206     AC207     AC210     AC213     AC218     AC220
AC225     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    AC527     AC54.1    AC540
AC55.1    AC58.3    AC58.4    AC580     AC583     AC90.1
AC92.1    AC93.1    AC94.1    AC95.1    ACAC.1    ACBA.1
ACDL.1    ACDM.2    ACDM.8    ACDM.9    ACVW.1    ATVW.1
SE90.1    AM115     AM117     AM120     AM15.1    AM15.2
AM15.3    AM15.4    AM19.1    AM19.2    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     AM330
AM35.1    AM45.1    AM501     AM51.1    AM551     AM70.4
AM88.1    AM88.8    AM94.1    AM97.1    AMBL.1    AMDM.2
AP110     AP115     AP125     AP126     AP131     AP150
AP155     AP160     AP161     AP20.1    AP20.2    AP20.3
AP20.4    AP20.5    AP20.7    AP21.1    AP210     AP211
AP220     AP23.1    AP25.1    AP25.2    AP26.1    AP265
AP27.1    AP30.2    AP30.4    AP305     AP510     AP62.1
AP90.1    AP91.1    API1.1    API2.1    API3.1    API4.1
AR01.3    AR120     AR129     AR130     AR131     AR135
AR170     AR21.2    AR210     AR211     AR217     AR222
AR223     AR227     AR228     AR229     AR230     AR232
AR233     AR235     AR237     AR238     AR239     AR245
AR250     AR251     AR253     AR257     AR258     AR264
AR265     AR27.2    AR271     AR275     AR282     AR285
AR29.1    AR290     AR291     AR292     AR293     AR294
AR296     AR30.5    AR300     AR301     AR32.1    AR33.2
AR38.5    AR39.3    AR39.4    AR42.1    AR42.2    AR42.7
AR42.8    AR43.1    AR502     AR503     AR55.1    AR560
AR575     AR800     AR91.1    ARLL.1    BL120     BL122
BL130     BL20.1    BL20.3    BL21.2    BL21.5    BL232
BL29.1    BL29.2    BL290     BL520     BL820     BL92.1
BR03.1    BR03.3    BR10.7    BR120     BR121     BR130
BR131     BR140     BR142     BR145     BR151     BR152
BR153     BR154     BR155     BR156     BR157     BR165
BR19.2    BR190     BR20.6    BR20.9    BR200     BR202
BR204     BR205     BR210     BR212     BR215     BR220
BR245     BR251     BR252     BR253     BR254     BR265
BR300     BR400     BR405     BR422     BR43.1    BR430
BR44.1    BR450     BR521     BR530     BR580     CB145
CB170     CB175     CB180     CB186     CB187     CB210
CB215     CB220     CB221     CB260     CB286     CB62.1
CBDM.5    ET540     ET700     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    IC02.3
IC02.4    IC02.1    GL00.1    GL00.3    GL11.1    GL11.2
GL62.1    GLAC.1    GLBL.1    IFAS.2    MX05.1    MX06.1
MX10.1    MX10.2    MX123     MX201     MX202     MX500
MA180     MA279     MA41.1    MA41.2    MA41.4    MA41.7
MA43.1    MA43.2    MA43.3    MA43.4    MA43.6    MA43.7
MA530     MA531     MA60.2    MA60.3    MA60.5    MA61.1
MA63.1    MA65.1    MA66.2    MA66.3    MA67.2    MA67.3
MA68.2    MA68.3    MA68.5    MA70.1    MA75.1    MA80.1
MAI1.1    PD10.1    PD10.2    PD130     PD20.1    PD20.2
PD20.3    PD230     PD235     PO04.5    PO04.6    PO04.1
PO04.2    PO10.1    PO10.2    PO100     PO101     PO120
PO122     PO131     PO20.1    PO21.1    PO21.2    PO21.3
PO21.4    PO21.5    PO22.1    PO220     PO223     PO23.1
PO233     PO24.1    PO25.1    PO25.5    PO25.6    PO25.7
PO253     PO254     PO27.2    PO278     PO29.1    PO30.1
PO30.2    PO30.3    PO300     PO31.1    PO31.2    PO32.2
PO32.4    PO33.1    PO34.1    PO35.1    PO36.1    PO36.2
PO38.1    PO39.1    PO39.2    PO44.1    PO50.1    PO52.1
PO520     PO536     PO54.1    PO54.2    PO54.3    PO54.4
POI3.1    POID.1    POII.1    POIJ.1    PR05.1    PR05.3
PR226     PR247     PR26.1    PR47.1    PR514     UK47.1
RQ01.2    RQ01.3    RQ01.1    RQ10.1    RQ10.2    RQ10.3
SLBL.1    SN02.1    SN70.1    SN70.4    SNAC.1    SNGL.1
WH110     WH130     WH20.2    WH20.7    WH226     AM170
AM96.1    AM98.1    CB00.3    IC12.1    IC330     IC811
MA278     MA53.1    PO115     PO15.1    PO15.2    PO150
PO204     PO224     PO225     PO229     PO230     PO234
PO251     PO275     PO276     PO277     PO280     RQ11.1
RQ13.2    RQ35.1    RQ44.1    RQ500     RQ810     RQIB.1
RQIF.1    RQII.1    RQIJ.1

UPDATED BY

AC00.1    AC08.1    AC08.2    AC08.3    AC08.6    AC10.1
AC13.1    AC13.2    AC13.7    AC13.8    AC135     AC14.1
AC14.2    AC14.6    AC14.7    AC16.1    AC16.2    AC16.7
AC16.8    AC16.9    AC40.1    AC40.4    AC41.1    AC41.4
AC42.1    AC45.1    AC500     AC510     AC558     AC560
AM192     AM23.1    AM23.2    AM40.1    AM500     AP03.1
AP03.2    AP162     AR23.1    AR23.2    AR501     AR515
AR550     CB01.4    CB01.5    CB162     GL110     GL120
GL146     GL190     GL191     GL197     GL199     GL300
GL40.1    GL40.2    GL40.3    GL40.6    GL40.7    GL40.8
GL44.1    GL45.1    ICBL.3    ICLM.3    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    IFOS.3    MX00.3    MX100     MX135
POBL.3    PW110     PW510     RQBL.3    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                                AC13.1  AC13.2
Element: Usage Count   The object record count.                  AC13.7  AC13.8
                                                                 AC135   AC14.1
                                                                 AC14.2  AC14.6
                                                                 AC14.7  AC16.1
                                                                 AC16.2  AC16.7
                                                                 AC16.8  AC16.9
                                                                 AC40.1  AC40.4
                                                                 AC41.1  AC41.4
                                                                 AC42.1  AC45.1
                                                                 AC500   AC510
                                                                 AC558   AC560
                                                                 AM23.1  AM23.2
                                                                 AM40.1  AM500
                                                                 AP03.1  AP03.2
                                                                 AP162   AR23.1
                                                                 AR23.2  AR501
                                                                 AR515   AR550
                                                                 CB01.4  CB01.5
                                                                 CB162   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
                                                                 ...

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  AC08.1
                                                                 AC08.2  AC08.3
                                                                 AC08.6  AC10.1
                                                                 AC105   AC112
                                                                 AC113   AC120
                                                                 AC121   AC123
                                                                 AC128   AC13.1
                                                                 AC13.2  AC13.3
                                                                 AC13.7  AC13.8
                                                                 AC130   AC135
                                                                 AC14.1  AC14.2
                                                                 AC14.3  AC14.6
                                                                 ...

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

MOCSET3   OBJ-TYPE      KeyChange, Subset                        AC10.1  AC160
          MATRIX-CAT    Where (REQUIRED = "Y" )                  AM115   AM117
                                                                 AM15.1  AM15.2
                                                                 AM15.3  AM15.4
                                                                 AM170   AM19.1
                                                                 AM19.2  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  AP115
                                                                 AP125   AP126
                                                                 ...

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

Accatmxvdt     ACCATMXVDT

                            MOC-MATRIX-CAT        -> MXB-MATRIX-CAT
                                                     MXB-EFFECTIVE-DATE
                                                     MXB-OBJ-ID

Aumxconv       AUMXCONV

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

Cbmxconv       CBMXCONV

                            MOC-MATRIX-CAT        -> CBN-MATRIX-CAT
                                                     CBN-COMPANY
                                                     CBN-CASH-CODE
                                                     CBN-RUN-GROUP

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

Vnmxconv       VNMXCONV

                            MOC-MATRIX-CAT        -> VNC-MATRIX-CAT
                                                     VNC-VENDOR-GROUP
                                                     VNC-VENDOR