MXOBJCAT – Attribute Object

System
General Ledger Setup (IF)
Prefix
MOC
Primary key
OBJ-TYPE, MATRIX-CAT
Fields
11
Updated by
105 programs
Referenced by
586 programs

MXOBJCAT is the Attribute Object table in Lawson General Ledger Setup (prefix MOC). It is indexed by OBJ-TYPE, MATRIX-CAT (MOCSET1); alternate indexes: MOCSET2, MOCSET3 and MOCSET4. It is related 1:1 to GLCPYGRP, MXCATDEF, MXELEMENT and OBJID and 1:M to ACCATMXVDT, AUMXCONV, CBMXCONV, MXTMPLEFDT, GLSCCAT, AUMXVALUE, MXOBJCATAU, MXVALIDATE and 3 more. It is updated by AC00.1, AC08.1, AC08.2, AC08.3, AC08.6, AC10.1, AC13.1, AC13.2 and 97 more and referenced by AC01.1, AC03.2, AC03.3, AC03.4, AC03.5, AC03.6, AC105, AC112 and 578 more. The table has 11 fields, 4 indexes and 15 documented relations.

About MXOBJCAT

This file contains the valid object and attribute records and determines how an object is used by the attribute.

Fields (11)

Column = COBOL field name without the MOC- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
MOC-OBJ-TYPE PK
OBJ_TYPE
Alpha 5This field determines the type of object used by the Attribute. These values are not user maintainable.AC40.1, AC40.4, AC41.1, AC41.4, AC42.1, AC45.1, GL05.1, GL05.2 +24 more
MOC-MATRIX-CAT PK
MATRIX_CAT
Alpha 12Attribute name assigned to an object (like an accounting unit) to track additional information. Attribute values are used in selection and sorting for reporting and analysis.AC40.1, AC40.4, AC41.1, AC41.4, AC42.1, AC45.1, GL05.1, GL05.2 +24 more
MOC-REQUIRED
REQUIRED
Alpha 1Indicates if a attribute category is required.
  • Y Yes
  • N No
GL05.1, GL05.2, MX00.3, MX100
MOC-APPLY-TO-GROUP
APPLY_TO_GROUP
Alpha 15Indicates if the attribute category applies to a company group or template.MX00.3
MOC-USAGE-COUNT
USAGE_COUNT
Numeric 12The object record count.AC13.1, AC13.2, AC13.7, AC13.8, AC135, AC14.1, AC14.2, AC14.6 +52 more (list truncated in source)
MOC-CALL-TOKEN
CALL_TOKEN
Alpha 6Not referenced at this time.
MOC-DERIVED-DESC
DERIVED_DESC
DerivedThe attribute description.
MOC-DERIVED-TYPE
DERIVED_TYPE
DerivedThe attribute type.
MOC-DERIVED-ELEM
DERIVED_ELEM
DerivedThe element associated with the attribute category.
MOC-DERIVED-SIZE
DERIVED_SIZE
DerivedThe element field size.
MOC-DERIVED-DATA
DERIVED_DATA
DerivedThe attribute object.

Indexes (4)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
MOCSET1OBJ-TYPE, MATRIX-CATPrimaryAC00.1, AC01.1, AC03.2, AC03.3, AC03.4, AC03.5, AC03.6, AC08.1 +22 more (list truncated in source)
MOCSET2OBJ-TYPE, APPLY-TO-GROUP, MATRIX-CATKeyChange, SubsetWhere (APPLY-TO-GROUP != Spaces)
MOCSET3OBJ-TYPE, MATRIX-CATKeyChange, SubsetWhere (REQUIRED = "Y")AC10.1, AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4 +22 more (list truncated in source)
MOCSET4MATRIX-CAT, OBJ-TYPEMX00.1, MX00.2, MX00.3, MX100, MX201

Relations

One to one (4) — lookups and parents

RelationTableRulesConditionField map
Company GroupGLCPYGRPNot RequiredValid When (MOC-OBJ-TYPE = "ACCTU")MOC-APPLY-TO-GROUPGCG-COMPANY-GROUP
MxcatdefMXCATDEFRequiredMOC-MATRIX-CATMXC-MATRIX-CAT
MxelementMXELEMENTRequiredMXC-ELEMENT-NAMEMXE-ELEMENT-NAME
Object IdOBJIDRequiredMOC-OBJ-TYPEOBI-OBJ-TYPE

One to many (11) — child tables

RelationTableRulesConditionField map
AccatmxvdtACCATMXVDTMOC-MATRIX-CATMXB-MATRIX-CAT, MXB-EFFECTIVE-DATE, MXB-OBJ-ID
AumxconvAUMXCONVMOC-MATRIX-CATAUC-MATRIX-CAT, AUC-OLD-COMPANY, AUC-RUN-GROUP, AUC-EFFECTIVE-DATE
CbmxconvCBMXCONVMOC-MATRIX-CATCBN-MATRIX-CAT, CBN-COMPANY, CBN-CASH-CODE, CBN-RUN-GROUP
EdtemplateMXTMPLEFDTMOC-OBJ-TYPEMTE-OBJ-TYPE, MOC-MATRIX-CATMTE-MATRIX-CAT, MTE-EFFECTIVE-DATE, MTE-TEMPLATE-NAME
GlsccatGLSCCATMOC-MATRIX-CATGSC-MATRIX-CAT, GSC-SOURCE-CODE, GSC-SEQ-NBR
Matrix ValuesAUMXVALUEValid When (MOC-OBJ-TYPE = "ACCTU")MOC-MATRIX-CATAMV-MATRIX-CAT, AMV-MX-VALUE, AMV-OBJ-ID
MxobjcatauMXOBJCATAUMOC-OBJ-TYPEMOA-OBJ-TYPE, MOC-MATRIX-CATMOA-MATRIX-CAT, MOA-ACTION, MOA-DATE, MOA-TIME, MOA-UNIQUE-I-D
MxvalidateMXVALIDATEMOC-MATRIX-CATMVL-MATRIX-CAT, MVL-TH-MX-VAL
TemplatesMXTMPLDTLMOC-OBJ-TYPEMTD-OBJ-TYPE, MOC-MATRIX-CATMTD-MATRIX-CAT, MTD-TEMPLATE-NAME
Used In ListsMXLISTDTLDelete RestrictedMOC-OBJ-TYPEMLD-OBJ-TYPE, MOC-MATRIX-CATMLD-MATRIX-CAT, MLD-MATRIX-LIST, MLD-OR-GROUP, MLD-SEQ-NUMBER
VnmxconvVNMXCONVMOC-MATRIX-CATVNC-MATRIX-CAT, VNC-VENDOR-GROUP, VNC-VENDOR

Programs

Updated by (105)

Referenced by (586)