MXCATDEF – Attribute Definition

System
General Ledger Setup (IF)
Prefix
MXC
Primary key
MATRIX-CAT
Fields
6
Updated by
3 programs
Referenced by
680 programs

MXCATDEF is the Attribute Definition table in Lawson General Ledger Setup (prefix MXC). It is indexed by MATRIX-CAT (MXCSET1); alternate indexes: MXCSET2 and MXCSET3. It is related 1:1 to MXELEMENT and 1:M to ACCATMXVDT, MXLISTDTL, MXCATDEFAU, MXOBJCAT, MXVALIDATE and GLSCCAT. It is updated by MX00.1, MX100 and MX160 and referenced by AC01.1, AC03.2, AC03.3, AC03.4, AC03.5, AC03.6, AC105, AC112 and 672 more. The table has 6 fields, 3 indexes and 9 documented relations.

About MXCATDEF

This file contains the valid Lawson and user-type attribute header records including, the attribute type, description, column headings, and element names defined in MX00.1 (Attribute). The attributes can be applied to various objects. Attribute values can be assigned to an object and used for analysis, grouping, and sorting.

Fields (6)

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

Field / columnTypeDescription & valuesUpdated by
MXC-MATRIX-CAT PK
MATRIX_CAT		Alpha 12Attribute name assigned to an object (like an accounting unit) to track additional information. Attribute values may then be used in selection and sorting for reporting and analysis.MX00.1, MX100
MXC-CATEGORY-TYPE
CATEGORY_TYPE		Alpha 1Defines whether the attribute category is a Lawson type (maintained by the system), or a User type (maintained by the user). Both types are available for selection and reporting.
  • L Lawson
  • U User
MX00.1, MX100
MXC-DESCRIPTION
DESCRIPTION		Alpha 30 (Lower Case)The attribute description.MX00.1, MX100
MXC-COLM-HEADING
COLM_HEADING		Alpha 32 (Lower Case)Text used for column headings on screens or reports. Heading size is limited to the size of the field.MX00.1
MXC-HAS-VALIDATION
HAS_VALIDATION		Alpha 1Identifies if valid values have been defined for the category. Yes = valid value records are defined and the entered value must cohere.
  • N No
MX00.1, MX160
MXC-ELEMENT-NAME
ELEMENT_NAME		Alpha 20The Lawson or user-defined element name that identifies the field size and type.MX00.1, MX100

Indexes (3)

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

IndexKeysFlagsConditionUsed in
MXCSET1MATRIX-CATPrimaryAC01.1, AC03.2, AC03.3, AC03.4, AC03.5, AC03.6, AC105, AC112 +22 more (list truncated in source)
MXCSET2CATEGORY-TYPE, MATRIX-CATKeyChangeAP162, AP262, AP62.1, CB162, CB262, CB62.1, GL162, GL262 +2 more
MXCSET3ELEMENT-NAME, MATRIX-CATKeyChangeMX00.2, MX100

Relations

One to one (1) — lookups and parents

RelationTableRulesConditionField map
Matrix ElementMXELEMENTRequiredMXC-ELEMENT-NAME → MXE-ELEMENT-NAME

One to many (8) — child tables

RelationTableRulesConditionField map
AccatmxvdtACCATMXVDTMXC-MATRIX-CAT → MXB-MATRIX-CAT, → MXB-EFFECTIVE-DATE, → MXB-OBJ-ID
Listdtl AcgrpMXLISTDTL"ACGRP" → MLD-OBJ-TYPE, MXC-MATRIX-CAT → MLD-MATRIX-CAT, → MLD-MATRIX-LIST, → MLD-OR-GROUP, → MLD-SEQ-NUMBER
MxcatdefauMXCATDEFAUMXC-MATRIX-CAT → MCU-MATRIX-CAT, → MCU-ACTION, → MCU-DATE, → MCU-TIME, → MCU-UNIQUE-I-D
Mxlistdtl AcMXLISTDTL"ACTVY" → MLD-OBJ-TYPE, MXC-MATRIX-CAT → MLD-MATRIX-CAT, → MLD-MATRIX-LIST, → MLD-OR-GROUP, → MLD-SEQ-NUMBER
Mxlistdtl AuMXLISTDTL"ACCTU" → MLD-OBJ-TYPE, MXC-MATRIX-CAT → MLD-MATRIX-CAT, → MLD-MATRIX-LIST, → MLD-OR-GROUP, → MLD-SEQ-NUMBER
MxobjcatMXOBJCATDelete RestrictedMXC-MATRIX-CAT → MOC-MATRIX-CAT, → MOC-OBJ-TYPE
MxvalidateMXVALIDATEDelete CascadesMXC-MATRIX-CAT → MVL-MATRIX-CAT, → MVL-TH-MX-VAL
Src Code CatsGLSCCATDelete RestrictedMXC-MATRIX-CAT → GSC-MATRIX-CAT, → GSC-SOURCE-CODE, → GSC-SEQ-NBR

Programs

Updated by (3)

Referenced by (680)