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. PK = primary key (present in every index); SETn = leading/alternate key of that index.

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 SET2
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 are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
MOCSET1
  1. OBJ-TYPE
  2. MATRIX-CAT
PrimaryAC00.1, AC01.1, AC03.2, AC03.3, AC03.4, AC03.5, AC03.6, AC08.1 +22 more (list truncated in source)
MOCSET2
  1. OBJ-TYPE
  2. APPLY-TO-GROUP
  3. MATRIX-CAT
KeyChange, SubsetWhere (APPLY-TO-GROUP != Spaces)—
MOCSET3
  1. OBJ-TYPE
  2. MATRIX-CAT
KeyChange, SubsetWhere (REQUIRED = "Y")AC10.1, AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4 +22 more (list truncated in source)
MOCSET4
  1. MATRIX-CAT
  2. OBJ-TYPE
MX00.1, MX00.2, MX00.3, MX100, MX201

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
GLCPYGRPMXCATDEFMXELEMENTOBJIDACCATMXVDTAUMXCONVCBMXCONVMXTMPLEFDTGLSCCATAUMXVALUEMXOBJCATAUMXVALIDATEMXTMPLDTLMXLISTDTLVNMXCONVMXOBJCAT

One to one (4) — lookups and parents

RelationTableRulesConditionField map
Company GroupGLCPYGRPNot RequiredValid When (MOC-OBJ-TYPE = "ACCTU")
MOC-APPLY-TO-GROUP→GCG-COMPANY-GROUP
MxcatdefMXCATDEFRequired
MOC-MATRIX-CAT→MXC-MATRIX-CAT
MxelementMXELEMENTRequired
MXC-ELEMENT-NAME→MXE-ELEMENT-NAME
Object IdOBJIDRequired
MOC-OBJ-TYPE→OBI-OBJ-TYPE

One to many (11) — child tables

RelationTableRulesConditionField map
AccatmxvdtACCATMXVDT
MOC-MATRIX-CAT→MXB-MATRIX-CAT
—→MXB-EFFECTIVE-DATE
—→MXB-OBJ-ID
AumxconvAUMXCONV
MOC-MATRIX-CAT→AUC-MATRIX-CAT
—→AUC-OLD-COMPANY
—→AUC-RUN-GROUP
—→AUC-EFFECTIVE-DATE
CbmxconvCBMXCONV
MOC-MATRIX-CAT→CBN-MATRIX-CAT
—→CBN-COMPANY
—→CBN-CASH-CODE
—→CBN-RUN-GROUP
EdtemplateMXTMPLEFDT
MOC-OBJ-TYPE→MTE-OBJ-TYPE
MOC-MATRIX-CAT→MTE-MATRIX-CAT
—→MTE-EFFECTIVE-DATE
—→MTE-TEMPLATE-NAME
GlsccatGLSCCAT
MOC-MATRIX-CAT→GSC-MATRIX-CAT
—→GSC-SOURCE-CODE
—→GSC-SEQ-NBR
Matrix ValuesAUMXVALUEValid When (MOC-OBJ-TYPE = "ACCTU")
MOC-MATRIX-CAT→AMV-MATRIX-CAT
—→AMV-MX-VALUE
—→AMV-OBJ-ID
MxobjcatauMXOBJCATAU
MOC-OBJ-TYPE→MOA-OBJ-TYPE
MOC-MATRIX-CAT→MOA-MATRIX-CAT
—→MOA-ACTION
—→MOA-DATE
—→MOA-TIME
—→MOA-UNIQUE-I-D
MxvalidateMXVALIDATE
MOC-MATRIX-CAT→MVL-MATRIX-CAT
—→MVL-TH-MX-VAL
TemplatesMXTMPLDTL
MOC-OBJ-TYPE→MTD-OBJ-TYPE
MOC-MATRIX-CAT→MTD-MATRIX-CAT
—→MTD-TEMPLATE-NAME
Used In ListsMXLISTDTLDelete Restricted
MOC-OBJ-TYPE→MLD-OBJ-TYPE
MOC-MATRIX-CAT→MLD-MATRIX-CAT
—→MLD-MATRIX-LIST
—→MLD-OR-GROUP
—→MLD-SEQ-NUMBER
VnmxconvVNMXCONV
MOC-MATRIX-CAT→VNC-MATRIX-CAT
—→VNC-VENDOR-GROUP
—→VNC-VENDOR

Programs

Updated by (105)

Referenced by (586)